Question

You are about to buy a million dollar house with a 20 percent down payment. The...

You are about to buy a million dollar house with a 20 percent down payment. The mortgage has 5 percent stated annual interest rate, compounded monthly, and calls for equal monthly payments over the next 30 years. The first payment is due one month from now. What is your monthly mortgage payment?

I know the answer si 4294.57

but I am having trouble understanding the second part of the question

The mortgage terms require that at the end of year 7 you prepay the mortgage, that is pay the present value of the subsequent payments. How much will you have to pay 7 years from now?

What is this asking exactly and how do I approach this?

Homework Answers

Answer #1

Loan taken = 80% of $1 million = $800,000

Annual interest = 5% per annum

Monthly interest = 5%/12 = 0.416%

No. of periods = 12*30 = 360 months

Let monthly mortgage payment be x

800,000 = x/(1+0.416%) + x/(1+0.416%)^2 + .... + x/(1+0.416%)^360

x=$4294.57

At the end of 7 years, PV of all future payments = Y. No. of periods remaining = 23*12 = 276

Y = x/(1+0.416%) + x/(1+0.416%)^2 + .... + x/(1+0.416%)^276; where x=$4294.57

Using PV function in excel where rate = 0.416%, nper=276, pmt=4294.57, fv=0, type = 0, we get Y = $704,086.18 which will be the prepayment amount for subsequent 23 years.

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 want to buy a house that costs $320,000. You will make a down payment equal...
You want to buy a house that costs $320,000. You will make a down payment equal to 20 percent of the price of the house and finance the remainder with a loan that has an interest rate of 4.55 percent compounded monthly. If the loan is for 30 years, what are your monthly mortgage payments?
You want to buy a house that costs $255,000. You will make a down payment equal...
You want to buy a house that costs $255,000. You will make a down payment equal to 20 percent of the price of the house and finance the remainder with a loan that has an interest rate of 5.37 percent compounded monthly. If the loan is for 30 years, what are your monthly mortgage payments?
You are planning to purchase a house for $180,000. You will pay 20% down payment and...
You are planning to purchase a house for $180,000. You will pay 20% down payment and take a mortgage loan for the remaining 80%. You could get a 3/1 ARM amortized over 15 years at 3.9 % or a fixed 15 year FRM loan at 5.3%. The expected interest rate of the ARM from years 4 to 5 is 7.5%. You will live in the house for five years, and after that you expect to sell the house for $200,000...
You buy a $200,000 house and have a 20% down payment (hence the mortgage is for...
You buy a $200,000 house and have a 20% down payment (hence the mortgage is for $160,000). A 15 year mortgage has a rate of 3.5% and 0 points. The monthly mortgage payment is $1,143.8 How much (give the dollar amount) of the first month’s mortgage payment pays off principal on the mortgage? To answer, first compute how much of the first month’s payment is used to pay interest. Then, the remainder of the mortgage payment is used to pay...
I am buying a house for $240,000. I will make a down payment of 30% of...
I am buying a house for $240,000. I will make a down payment of 30% of the price and finance the balance over 30 years at 4.8 percent (APR). What will be my monthly mortgage payment?
You buy a $200,000 house and have a 20% down payment (hence the mortgage is for...
You buy a $200,000 house and have a 20% down payment (hence the mortgage is for $160,000). A 15 year mortgage has a rate of 3.5% and 0 points. The monthly mortgage payment is $1,143.81. How much (give the dollar amount) of the first month’s mortgage payment pays off principal on the mortgage? To answer, first compute how much of the first month’s payment is used to pay interest. Then, the remainder of the mortgage payment is used to pay...
Mr. Smith is purchasing a $ 90000 house. The down payment is 20 % of the...
Mr. Smith is purchasing a $ 90000 house. The down payment is 20 % of the price of the house. He is given the choice of two mortgages: a) a 25-year mortgage at a rate of 7 %. Find (i) the monthly payment: $ (ii) the total amount of interest paid: $ b) a 15-year mortgage at a rate of 7 %. Find (i) The monthly payment: $ (ii) the total amount of interest paid: $
Mr. Smith is purchasing a $ 120000 house. The down payment is 20 % of the...
Mr. Smith is purchasing a $ 120000 house. The down payment is 20 % of the price of the house. He is given the choice of two mortgages: a) a 25-year mortgage at a rate of 7 %. Find (i) the monthly payment: $ (ii) the total amount of interest paid: $ b) a 15-year mortgage at a rate of 7 %. Find (i) The monthly payment: $ (ii) the total amount of interest paid: $
You have just arranged for a $200,000 mortgage to finance the purchase of a house. The...
You have just arranged for a $200,000 mortgage to finance the purchase of a house. The mortgage has an 8 percent quoted rate, interest is compounded semi-annually and it calls for monthly payments for the next 20 years. What is the monthly payment?Please provide step-by-step instructions for solving the problem
You borrow $185,000 to buy a house. The mortgage interest rate is 7.5 percent and the...
You borrow $185,000 to buy a house. The mortgage interest rate is 7.5 percent and the loan period is 30 years. Payments are made monthly. What is your monthly mortgage payment? $1,293.55 $953.70 $1,083.78 $1,153.70 $1,398.43