Prepare an amortization schedule for a five-year loan of $57,000. The interest rate is 9 percent per year, and the loan calls for equal annual payments.

Prepare an amortization schedule for a five-year loan of $57,000. The interest rate is 9 percent per year, and the loan calls for equal annual payments. (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16. Leave no cells blank - be certain to enter "0" wherever required.)

 
 

Year	Beginning Balance	Total Payment	Interest Payment	Principal Payment	Ending Balance
1	$	$	$	$	$
2
3
4
5

 

How much interest is paid in the third year? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)

  

Interest paid

$

 

How much total interest is paid over the life of the loan? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)

  

Total interest paid

$

 

Explanation:

The payment for a loan repaid with equal payments is the annuity payment with the loan value as the PV of the annuity. So, the loan payment will be:

    

PVA = $57,000 = C{[1 – 1 / (1 + .09)5] / .09}

C = $14,654.27

  

The interest payment is the beginning balance times the interest rate for the period, and the principal payment is the total payment minus the interest payment. The ending balance is the beginning balance minus the principal payment. The ending balance for a period is the beginning balance for the next period.

  

In the third year, $3,338.48 of interest is paid.

Total interest over life of the loan = $5,130 + 4,272.82 + 3,338.48 + 2,320.06 + 1,209.99

Total interest over life of the loan = $16,271.35