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).

Transcribed Image Text:

3-Month 3-Month U.K. Date Pound LIBOR Bond Yield TED Spread Date 3-Month Pound LIBOR 3-Month U.K. Bond Yield TED Spread 9/8/2008 5.74% 5.10% 9/29/2008 6.26% 4.90% 9/9/2008 5.73% 5.10% 9/30/2008 6.30% 4.85% 9/10/2008 5.72% 5.09% 10/1/2008 6.31% 4.76% 9/11/2008 5.71% 5.07% 10/2/2008 6.28% 4.74% 9/12/2008 5.70% 5.09% 10/3/2008 6.27% 4.67% 9/15/2008 5.72% 5.10% 10/6/2008 6.27% 4.65% 9/16/2008 5.79% 5.12% 10/7/2008 6.28% 4.53% 9/17/2008 5.87% 5.15% 10/8/2008 6.27% 4.43% 9/18/2008 5.98% 5.06% 10/9/2008 6.28% 4.33% 9/19/2008 6.00% 5.04% 10/10/2008 6.29% 4.33% 9/22/2008 6.01% 5.03% 10/13/2008 6.27% 4.35% 9/23/2008 6.07% 4.95% 10/14/2008 6.25% 4.43% 9/24/2008 6.20% 4.89% 10/15/2008 6.21% 4.44% 9/25/2008 6.28% 4.89% 10/16/2008 6.18% 4.39% 9/26/2008 6.26% 4.90% 10/17/2008 6.16% 4.31%