In: Finance
How much interest will be paid in the 7th month if you borrow $20,000 at a rate of 6%, compounded monthly, and pay it off over 6 years?
Monthly Loan Payment
Loan Amount (P) = $20,000
Monthly Interest Rate (n) = 0.50% per month [6% / 12 Months]
Number of months (n) = 72 Months [6 Years x 12 months]
Monthly Loan Payment = [P x {r (1+r)n} ] / [( 1+r)n – 1]
= [$20,000 x {0.05 x (1 + 0.05)72}] / [(1 + 0.05)72 – 1]
= [$20,000 x {0.05 x 1.432044}] / [1.432044 – 1]
= [$20,000 x 0.007160] / 0.432044
= $143.20 / 0.432044
= $331.46 per month
Loan amortization schedule for the first seven months
Month |
Beginning Balance |
Total Payment |
Interest Paid at 0.50% |
Principal Paid |
Ending Balance |
1 |
20,000.00 |
331.46 |
100.00 |
231.46 |
19,768.54 |
2 |
19,768.54 |
331.46 |
98.84 |
232.62 |
19,535.92 |
3 |
19,535.92 |
331.46 |
97.68 |
233.78 |
19,302.14 |
4 |
19,302.14 |
331.46 |
96.51 |
234.95 |
19,067.19 |
5 |
19,067.19 |
331.46 |
95.34 |
236.12 |
18,831.07 |
6 |
18,831.07 |
331.46 |
94.16 |
237.30 |
18,593.76 |
7 |
18,593.76 |
331.46 |
92.97 |
238.49 |
18,355.27 |
“Hence, the interest will be paid in the 7th month = $92.97”