Question

SITUATION FOR QUESTIONS 7 - 12

A house is selling for $175,000 and your bank makes you the following offer: 5.36% interest per year compounded monthly, $35,000 down payment, 20 year amortization period.

$____________7. What is the amount of your monthly payment?

%____________8. What is the bank's loan to value ratio?

$____________9. If you sell the house at the end of 10 years, what is your mortgage balance at that time? (What will you owe the bank.)

$___________10. If you wish to reduce the term of the loan from a 20 year to 10 year amortization, calculate your payment based upon 10 year amortization?

$___________11. If you sell the house after 5 years for $225,000 how much will you have left, in cash, after paying off your mortgage, assuming you made your monthly payments when due. Assume no expenses or costs in selling the house?

$___________12. If you could come up with an additional $10,000 for a down payment how much would your monthly payment decrease?

Answer 1

Answer 7

Borrowed amount = $175,000 - $35,000 = $140,000

Monthly loan interest rate = 5.36% / 12 = 0.4467%

Number of months = 20 * 12 = 240 months

Amount of monthly payment = $140,000 / [(1 - (1.004467)^-240) / 0.004467]

= $952.03

Answer 8

Bank loan's to value ratio = $140,000 / $175,000 = 80%

Answer 9

First, we need to compute the total principal paid in 10 years (120 months). To calculate the total principal paid, "CUMPRINC" function will be used in excel.

Principal paid = $51,714.22

Mortgage balance after 10 years = $140,000 - $51,714.22 = $88,285.78

Answer 10

Borrowed amount = $140,000

Monthly loan interest rate = 5.36% / 12 = 0.4467%

Number of months = 10 * 12 = 120 months

Amount of monthly payment = $140,000 / [(1 - (1.004467)^-120) / 0.004467]

= $1,509.70

Answer 11

First, we need to compute the total principal paid in 5 years (60 months). To calculate the total principal paid, "CUMPRINC" function will be used in excel

.

Total principal paid in 5 years = $22,420.17

Mortgage balance left = $140,000 - $22,420.17 = $117,579.83

Selling proceeds = $225,000

Cash balance left = $225,000 - $117,579.83 = $107,420.17

Answer 12

Borrowed amount = $175,000 - $45,000 = $130,000

Monthly loan interest rate = 5.36% / 12 = 0.4467%

Number of months = 20 * 12 = 240 months

Amount of monthly payment = $130,000 / [(1 - (1.004467)^-240) / 0.004467]

= $884.01

Decrease in monthly payments = $952.03 - $884.01 = $68.02