Assumptions 15-Year Mortgage 30-Year Mortgage
Price of house at purchase £406,000 £406,000
Less down-payment (20%) -£81,200 -£81,200
Mortgage principal (£)£324,800 £324,800
Monthly payment (amortizing loan, all equal payments) £2,346 £1,658
Assumptions 15-Year Mortgage
Price of house at purchase £406,000.00
Less down-payment (10%) 15% -£60,900.00
Mortgage principal (US$) £345,100.00
Monthly payment £2,872.22
Home’s original value £406,000.00 £406,000.00
Fall in value -30.0% -30.0%
New home market value £284,200.00 £284,200.00
Problem 8.3 Stapleton’s Mortgage
Frank Stapleton pays £406,000 for a four-bedroom bungalow on the outskirts of Edinburgh, Scotland. He plans to make
a 20% down payment but is having trouble deciding whether he wants a 15-year fixed rate (3.650%) or a 30-year fixed
rate (4.565%) mortgage.
a. What is the monthly payment for both the 15– and 30-year mortgages, assuming a fully amortizing loan of
equal payments for the life of the mortgage? Use a spreadsheet calculator for the payments.
b. Assume that instead of making a 20% down payment, he makes a 15% down payment, finances
the remainder at 5.785% fixed interest for 15 years. What is his monthly payment?
c. Assume that the bungalow’s total value falls by 30%. If Frank sells the house at the new market value, what
will be his gain or loss on the home and mortgage, assuming all the mortgage principal remains? Use the same
assumptions as in part (a).