You are a mortgage banker at Home Bank. One customer, Sean, wants to borrow mone
ID: 2718345 • Letter: Y
Question
You are a mortgage banker at Home Bank. One customer, Sean, wants to borrow money from your bank to finance his real estate investment project. The price for the real estate asset is $300,000. Sean wants to borrow a 80% loan to purchase the asset. You tell Sean that a constant payment, fully amortizing loan (FRM) with a 30 amortization period is available. The interest rate for the loan is 4.5%, which is the same as the market interest rate. Moreover, you will charge a loan origination fee of 3% for the loan.
(a) What is the monthly payment for the loan?
(b) What is the effective interest rate, assuming the mortgage is paid off after 30 years?
(c) If Sean plans to repay the loan after five years, what is the effective interest rate?
(d) If Sean wants to borrow a 90% loan, the loan rate will be 5.5%. Everything else being equal (i.e., he prepays the loan after 5 years, with the 3% loan fee), would you recommend him to borrow the 90% loan? [Hint: calculate incremental cost of borrowing]
(e) Suppose Sean can get a loan with a below-market interest rate from the builder. This fully amortizing FRM loan will have a 80% LTV, 4% interest rate, 30 years amortization period, and with no loan fees. At what price should the builder sell the asset to Sean in order to earn the market rate of interest (4.5%) on the loan? Assume that Sean would have the loan for the entire term of 30 years and the asset would normally sell for $300,000 without any special financing.
Explanation / Answer
PmtNo. Payment Date Beginning Balance Scheduled Payment Extra Payment Total Payment Principal Interest Ending Balance Cumulative Interest 1 01/02/2015 $ 240,000.00 $ 7,139.26 $ - $ 7,139.26 $ 6,239.26 $ 900.00 $ 233,760.74 $ 900.00 2 01/03/2015 233,760.74 7,139.26 - 7,139.26 6,262.66 876.60 227,498.08 1,776.60 3 01/04/2015 227,498.08 7,139.26 - 7,139.26 6,286.14 853.12 221,211.93 2,629.72 4 01/05/2015 221,211.93 7,139.26 - 7,139.26 6,309.72 829.54 214,902.22 3,459.27 5 01/06/2015 214,902.22 7,139.26 - 7,139.26 6,333.38 805.88 208,568.84 4,265.15 6 01/07/2015 208,568.84 7,139.26 - 7,139.26 6,357.13 782.13 202,211.71 5,047.28 7 01/08/2015 202,211.71 7,139.26 - 7,139.26 6,380.97 758.29 195,830.74 5,805.58 8 01/09/2015 195,830.74 7,139.26 - 7,139.26 6,404.90 734.37 189,425.85 6,539.94 9 01/10/2015 189,425.85 7,139.26 - 7,139.26 6,428.91 710.35 182,996.93 7,250.29 10 01/11/2015 182,996.93 7,139.26 - 7,139.26 6,453.02 686.24 176,543.91 7,936.53 11 01/12/2015 176,543.91 7,139.26 - 7,139.26 6,477.22 662.04 170,066.69 8,598.57 12 01/01/2016 170,066.69 7,139.26 - 7,139.26 6,501.51 637.75 163,565.17 9,236.32 13 01/02/2016 163,565.17 7,139.26 - 7,139.26 6,525.89 613.37 157,039.28 9,849.69 14 01/03/2016 157,039.28 7,139.26 - 7,139.26 6,550.36 588.90 150,488.92 10,438.58 15 01/04/2016 150,488.92 7,139.26 - 7,139.26 6,574.93 564.33 143,913.99 11,002.92 16 01/05/2016 143,913.99 7,139.26 - 7,139.26 6,599.58 539.68 137,314.40 11,542.59 17 01/06/2016 137,314.40 7,139.26 - 7,139.26 6,624.33 514.93 130,690.07 12,057.52 18 01/07/2016 130,690.07 7,139.26 - 7,139.26 6,649.17 490.09 124,040.90 12,547.61 19 01/08/2016 124,040.90 7,139.26 - 7,139.26 6,674.11 465.15 117,366.79 13,012.76 20 01/09/2016 117,366.79 7,139.26 - 7,139.26 6,699.14 440.13 110,667.65 13,452.89 21 01/10/2016 110,667.65 7,139.26 - 7,139.26 6,724.26 415.00 103,943.39 13,867.89 22 01/11/2016 103,943.39 7,139.26 - 7,139.26 6,749.47 389.79 97,193.92 14,257.68 23 01/12/2016 97,193.92 7,139.26 - 7,139.26 6,774.78 364.48 90,419.13 14,622.16 24 01/01/2017 90,419.13 7,139.26 - 7,139.26 6,800.19 339.07 83,618.94 14,961.23 25 01/02/2017 83,618.94 7,139.26 - 7,139.26 6,825.69 313.57 76,793.25 15,274.80 26 01/03/2017 76,793.25 7,139.26 - 7,139.26 6,851.29 287.97 69,941.97 15,562.78 27 01/04/2017 69,941.97 7,139.26 - 7,139.26 6,876.98 262.28 63,064.99 15,825.06 28 01/05/2017 63,064.99 7,139.26 - 7,139.26 6,902.77 236.49 56,162.22 16,061.55 29 01/06/2017 56,162.22 7,139.26 - 7,139.26 6,928.65 210.61 49,233.57 16,272.16 30 01/07/2017 49,233.57 7,139.26 - 7,139.26 6,954.64 184.63 42,278.93 16,456.79 31 01/08/2017 42,278.93 7,139.26 - 7,139.26 6,980.72 158.55 35,298.21 16,615.33 32 01/09/2017 35,298.21 7,139.26 - 7,139.26 7,006.89 132.37 28,291.32 16,747.70 33 01/10/2017 28,291.32 7,139.26 - 7,139.26 7,033.17 106.09 21,258.15 16,853.79 34 01/11/2017 21,258.15 7,139.26 - 7,139.26 7,059.54 79.72 14,198.61 16,933.51 35 01/12/2017 14,198.61 7,139.26 - 7,139.26 7,086.02 53.24 7,112.59 16,986.76 36 01/01/2018 7,112.59 7,139.26 - 7,112.59 7,085.92 26.67 0.00 17,013.43
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.