Chapter 5 ◼ Interest Rates 143
Monthly payments for the thirty-year loan:
Solutions to Advanced Problems for Spreadsheet Application
1. a. Monthly amortization schedule:
Loan Amount Interes Rate Years for Loan
$650,000.00 7.00% 20
Mnth Beginning Balance Annual Payment Interest Expense Principal Reduction Extra Principal Ending Balance
1$650,000.00 ($5,039.44) $3,791.67 ($1,247.78) $648,752.22
2$648,752.22 ($5,039.44) $3,784.39 ($1,255.06) $647,497.17
3$647,497.17 ($5,039.44) $3,777.07 ($1,262.38) $646,234.79
4$646,234.79 ($5,039.44) $3,769.70 ($1,269.74) $644,965.05
5$644,965.05 ($5,039.44) $3,762.30 ($1,277.15) $643,687.91
6$643,687.91 ($5,039.44) $3,754.85 ($1,284.60) $642,403.31
7$642,403.31 ($5,039.44) $3,747.35 ($1,292.09) $641,111.22
8$641,111.22 ($5,039.44) $3,739.82 ($1,299.63) $639,811.59
9$639,811.59 ($5,039.44) $3,732.23 ($1,307.21) $638,504.38
10 $638,504.38 ($5,039.44) $3,724.61 ($1,314.83) $637,189.55
230 $53,541.75 ($5,039.44) $312.33 ($4,727.12) $48,814.63
231 $48,814.63 ($5,039.44) $284.75 ($4,754.69) $44,059.94
232 $44,059.94 ($5,039.44) $257.02 ($4,782.43) $39,277.51
233 $39,277.51 ($5,039.44) $229.12 ($4,810.32) $34,467.19
234 $34,467.19 ($5,039.44) $201.06 ($4,838.38) $29,628.81
235 $29,628.81 ($5,039.44) $172.83 ($4,866.61) $24,762.20
236 $24,762.20 ($5,039.44) $144.45 ($4,895.00) $19,867.20
237 $19,867.20 ($5,039.44) $115.89 ($4,923.55) $14,943.65
238 $14,943.65 ($5,039.44) $87.17 ($4,952.27) $9,991.38
239 $9,991.38 ($5,039.44) $58.28 ($4,981.16) $5,010.22
240 $5,010.22 ($5,039.44) $29.23 ($5,010.22) $0.00