Loan Amortization
Loan Amortization
Repaying a loan with equal periodic payments. Each payment covers interest plus principal reduction.
$$R = P \cdot \frac{i}{1-(1+i)^{-n}}$$
$P$ = loan amount, $i$ = rate per period, $n$ = total payments.
For payment $k$:
- Interest portion: $I_k = B_{k-1} \cdot i$
- Principal portion: $P_k = R - I_k$
- New balance: $B_k = B_{k-1} - P_k$
Monthly payment on a $\$200{,}000$ mortgage at $6\%$ for 30 years.
$i = 0.005$, $n = 360$. $R = 200000 \cdot \frac{0.005}{1-1.005^{-360}} \approx \$1{,}199.10$.
Total interest paid on the loan above.
Total paid $= 360 \times 1199.10 = \$431{,}676$. Interest $= 431{,}676 - 200{,}000 = \$231{,}676$.
First two rows of an amortization schedule for a $\$10{,}000$ loan at $12\%$ monthly over 4 years.
$i = 0.01$, $n = 48$. $R \approx \$263.34$.
Month 1: Interest $= 100$, Principal $= 163.34$, Balance $= 9{,}836.66$.
Month 2: Interest $= 98.37$, Principal $= 164.97$, Balance $= 9{,}671.69$.
Practice Problems
Show Answer Key
1. $R \approx \$471.78$
2. $60 \times 471.78 - 25000 = \$3{,}306.80$
3. $R \approx \$1{,}147.49$
4. Interest = $150000(0.045/12) = \$562.50$; Principal = $1147.49 - 562.50 = \$584.99$
5. $B_{12} = R \cdot \frac{1-(1+i)^{-(n-12)}}{i} \approx \$6{,}844.08$
6. 15-yr total interest $\approx \$84{,}686$; 30-yr $\approx \$186{,}512$; savings $\approx \$101{,}826$
7. $R \approx \$1{,}798.65$; Interest = $300000(0.005)= \$1{,}500$; fraction $\approx 83.4\%$
8. $\approx \$52{,}000+$ saved, payoff $\approx 25$ years
9. Effectively 13 monthly payments/year; shaves $\approx 5$ years off a 30-yr loan
10. $B_k = R \cdot \frac{1-(1+i)^{-(n-k)}}{i}$
11. $R = 5000 \cdot 0.08/(1-1.08^{-2}) \approx \$2{,}805.77$. Yr 1: Int $400$, Princ $2405.77$, Bal $2594.23$. Yr 2: Int $207.54$, Princ $2598.23$, Bal $0$.
12. When fees/costs are included; APR reflects true cost