Question

Mr. Homemaker has just taken out a $175,000 mortgage at an interest rate of 3.6% [Annual...

Mr. Homemaker has just taken out a $175,000 mortgage at an interest rate of 3.6% [Annual rate]. The mortgage calls for equal monthly payments for 15 years. Then the amount of the monthly payment is:[Assume monthly compounding]

Homework Answers

Answer #1

Here, the payments will be same every month, so it is an annuity. We will use the present value of annuity formula to calculate the monthly payments as per below:

PVA = P * (1 - (1 + r)-n / r)

where, PVA = Present value of annuity = $175000, P is the periodical amount, r is the rate of interest = 3.6% compounding monthly, so monthly rate = 3.6% / 12 = 0.3% and n is the time period = 15 * 12 = 180 months.

Now, putting these values in the above formula, we get,

$175000 = P * (1 - (1 + 0.3%)-180 / 0.3%)

$175000 = P * (1 - ( 1+ 0.003)-180 / 0.003)

$175000 = P * (1 - ( 1.003)-180 / 0.003)

$175000 = P * (1 - 0.58321952698) / 0.003)

$175000 = P * (0.41678047301 / 0.003)

$175000 = P * 138.926824338

P = $175000 / 138.926824338

P = $1259.6559

So, the amount of monthly payment is $1259.66

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
You have just purchased a home and taken out a $275,000 mortgage. The mortgage has a...
You have just purchased a home and taken out a $275,000 mortgage. The mortgage has a 25-year term with monthly payments and an APR of 3% compounding monthly. How much of your 288th payment will be interest and how much will go toward reducing your principal?
You have just taken out a 26 -year, $ 184 ,000 mortgage loan at an annual...
You have just taken out a 26 -year, $ 184 ,000 mortgage loan at an annual interest rate of 5.3 percent. The mortgage has monthly payments. What is the amount of each payment? Calculate your answer to the nearest $.01. Enter your answer as a positive number.
You have just taken out a 29 -year, $ 118 ,000 mortgage loan at an annual...
You have just taken out a 29 -year, $ 118 ,000 mortgage loan at an annual interest rate of 6.2 percent. The mortgage has monthly payments. What is the amount of each payment? Calculate your answer to the nearest $.01. Enter your answer as a positive number. Please show work on how to compute in MS Excel
You have just purchased a home and taken out a $540,000 mortgage. The mortgage has a...
You have just purchased a home and taken out a $540,000 mortgage. The mortgage has a 30-year term with monthly payments and an APR 9with semi-annual compounding) of 7.04%. A. How much will you pay in interest, and how much will you pay in principal, during the first year ? B. How much will you pay in interest, and how much you in pay in principal, during the the Twentieth year (i.e. between 19 and 20 years from now) ?
Mr. H issues a 20 year mortgage of $275,000 at an annual interest rate of 4.4%...
Mr. H issues a 20 year mortgage of $275,000 at an annual interest rate of 4.4% to buy a house.The mortgage payments are made annually. 1.What is Mr. H's annual payment of principal and interest? $20,958 $22,425 $18,653 $24,102 2.How much interest does Mr. H pay in the second year of the mortgage? $11,710 $13,467 $12,530 $10,422 3.Suppose that immediately after making the second annual payment, Mr. H has the opportunity to refinance the remaining mortgage balance at an annual...
A. Julio has taken out a 25-year mortgage for $82,000.       The interest rate is 8.5%...
A. Julio has taken out a 25-year mortgage for $82,000.       The interest rate is 8.5% and the down payment is 20%.       Calculate the monthly payment. Purchase Price $82,000.00 Interest Rate 8.5% Length of Loan in Years 25 Down Payment Percent 20% Down Payment Amount Financed Units Factor 8.0528 Monthly Payment B. Complete the amortization schedule for the first three months of Julio’s mortgage. Month Monthly Payment Interest Portion Principal Portion Loan Balance ––––– ––––– ––––– ––––– 1 2...
You have taken out a standard $250,000, 30-year mortgage, at a nominal annual rate of 4.9%,...
You have taken out a standard $250,000, 30-year mortgage, at a nominal annual rate of 4.9%, with monthly compounding. Determine how much you will still owe on your mortgage, as a percent of the original $250,000, after 15 years (180 payments) if you only make the required monthly payments. A) 65.56% B) 66.23% C) 66.90% D) 67.56% E) 68.21% Pleasse do not use excel to explain this to me thank you.
Solve using excel: A. You have taken out a $225,000, 3/1 ARM. The initial rate of...
Solve using excel: A. You have taken out a $225,000, 3/1 ARM. The initial rate of 5.8% (annual) is locked in for 3 years and is expected to increase to 6.5% at the end of the lock period. Calculate the initial payment on the loan. (Note: the term on this 3/1 ARM is 30 years) 
 B. Given the following information, calculate the Effective Borrowing Cost (EBC). Loan amount: $175,000, Term: 30 years, Interest rate: 7 %, Payment: $1,164.28, Discount points:...
Suppose you have taken out a $200,000 fully amortizing fixed rate mortgage loan that has a...
Suppose you have taken out a $200,000 fully amortizing fixed rate mortgage loan that has a term of 15 years and an interest rate of 4.25%. In month two of the mortgage, how much of the monthly mortgage payment does the principal repayment portion consist of?
1) Jens just took out a loan from the bank for 79,702 dollars. He plans to...
1) Jens just took out a loan from the bank for 79,702 dollars. He plans to repay this loan by making a special payment to the bank of 4,130 dollars in 4 years and by also making equal, regular annual payments of X for 8 years. If the interest rate on the loan is 12.57 percent per year and he makes his first regular annual payment in 1 year, then what is X, Jens’s regular annual payment? 2) Theo just...