In: Finance
Assume you take out a loan that you will make payments, once per year, for four years. Complete the table assuming the loan is for $10,000 and the interest rate on the loan is 4.25%.
Year |
Beginning Balance |
Total Payment |
Interest Paid |
Principal Paid |
Ending Balance |
1 |
|||||
2 |
|||||
3 |
|||||
4 |
|
Year | Beginning Balance | Total Payment | Interest Paid | Principal Paid | Ending Balance | |||
1 | $ 10,000.00 | $ 2,771.15 | $ 425.00 | $ 2,346.15 | $ 7,653.85 | |||
2 | $ 7,653.85 | $ 2,771.15 | $ 325.29 | $ 2,445.86 | $ 5,207.99 | |||
3 | $ 5,207.99 | $ 2,771.15 | $ 221.34 | $ 2,549.81 | $ 2,658.18 | |||
4 | $ 2,658.18 | $ 2,771.15 | $ 112.97 | $ 2,658.18 | $ -0.00 | |||
working: | ||||||||
Annual payment | = | Loan Amount/Present Value of annuity of 1 | ||||||
= | $ 10,000 | / | 3.60861 | |||||
= | $ 2,771.15 | |||||||
Present Value of annuity of 1 | = | (1-(1+i)^-n)/i | Where, | |||||
= | (1-(1+0.0425)^-4)/0.0425 | i | 0.0425 | |||||
= | 3.60861 | n | 4 | |||||