In: Finance
Complete an amortization schedule for a $33,000 loan to be repaid in equal installments at the end of each of the next three years. The interest rate is 11% compounded annually. Round all answers to the nearest cent.
Loan amount to be repaid (PV) | $33,000.00 | ||||
Interest rate (r) | 11.00% | ||||
Length of loan (in years) | 3 | ||||
a. Setting up amortization table | Formula | ||||
Calculation of loan payment | #N/A | ||||
Year | Beginning Balance | Payment | Interest | Repayment of Principal | Remaining Balance |
1 | |||||
2 | |||||
3 | |||||
b. Calculating % of Payment Representing Interest and Principal for Each Year | |||||
Year | Payment % Representing Interest | Payment % Representing Principal | Check: Total = 100% | ||
1 | |||||
2 | |||||
3 |