Loan Loan
Month Balance Payment Interest Principal Balance
1 $160,000.00 $1,011.31 $866.67 $144.64 $159,855.36
2 159,855.36 1,011.31 865.88 145.43 159,709.93
3 159,709.93 1,011.31 865.10 146.21 159,563.72
4 159,563.72 1,011.31 864.30 147.01 159,416.71
5 159,416.71 1,011.31 863.51 147.80 159,268.91
6 159,268.91 1,011.31 862.71 148.60 159,120.31
6. EXCEL Problem: Payment = $1,245.62
Payment = $1,286.13
Payment = $1,390.52
Payment = $1,521.40
7. EXCEL Problem: Payment = $875.36
Payment = $923.58
Payment = $1,048.82
Payment = $1,206.93
8. For the either mortgage, you will make a down payment of 20 percent of the purchase price: or a down payment
of $40,000 (0.20 x $200,000) at closing and borrow $160,000 through the mortgage.
a. Total payments on the 15-year mortgage are $250,878.60, of which $90,878.60 is interest. This compares to
interest of $232,932.80 on the 30-year mortgage (a difference of $142,054.20, disregarding time value of money).
The mortgage borrower’s interest payments are reduced significantly with the 15-year mortgage relative to the
30-year mortgage.
b. For the 30-year mortgage: $160,000 = PMT{[1 – (1/(1 + 0.0725/12)30(12))]/(0.0725/12)}
or PMT = $160,000/{[1 – (1/(1 + 0.0725/12)30(12))]/(0.0725/12)}
therefore PMT = $160,000/146.5897 = $1,091.48
For the 15-year mortgage: $160,000 = PMT{[1 – (1/(1 + 0.0650/12)15(12))]/(0.0650/12)}
or PMT = $160,000/{[1 – (1/(1 + 0.0650/12)15(12))]/(0.0650/12)}
therefore PMT = $160,000/114.7964 = $1,393.77
The borrower must pay $1,393.77 per month with the 15-year mortgage compared to $1,091.48 with the 30-year
mortgage, a difference of $302.29 per month. This may be difficult if the borrower’s income level is not very high.
9. For the either mortgage, you will make a down payment of 20 percent of the purchase price: or a down payment
of $48,000 (0.20 x $240,000) at closing and borrow $192,000 through the mortgage.
a. Total payments on the 15-year mortgage are $273,297.60, of which $81,279.60 is interest. This compares to
interest of $211,365.60 on the 30-year mortgage (a difference of $130,068.00, disregarding time value of money).
The mortgage borrower’s interest payments are reduced significantly with the 15-year mortgage relative to the
30-year mortgage.
b. For the 30-year mortgage: $192,000 = PMT{[1 – (1/(1 + 0.0575/12)30(12))]/(0.0575/12)}
or PMT = $192,000/{[1 – (1/(1 + 0.0575/12)30(12))]/(0.0575/12)}
therefore PMT = $192,000/171.3582 = $1,120.46
For the 15-year mortgage: $192,000 = PMT{[1 – (1/(1 + 0.0500/12)15(12))]/(0.0500/12)}
or PMT = $192,000/{[1 – (1/(1 + 0.0500/12)15(12))]/(0.0500/12)}
therefore PMT = $192,000/114.7964 = $1,518.32