Prepare an amortization schedule for a five-year loan of $61,000. The interest r
ID: 2634697 • Letter: P
Question
Prepare an amortization schedule for a five-year loan of $61,000. The interest rate is 8 percent per year, and the loan calls for equal annual payments. (Do not round intermediate calculations and round your final answer to 2 decimal places. (e.g., 32.16))
How much interest is paid in the third year? (Do not round intermediate calculations and round your final answer to 2 decimal places. (e.g., 32.16))
The interest rate is 8 percent per year, and the loan calls for equal annual payments. How much total interest is paid over the life of the loan? (Do not round intermediate calculations and round your final answer to 2 decimal places. (e.g., 32.16))
Prepare an amortization schedule for a five-year loan of $61,000. The interest rate is 8 percent per year, and the loan calls for equal annual payments. (Do not round intermediate calculations and round your final answer to 2 decimal places. (e.g., 32.16))
Explanation / Answer
1. Annual Interest paid in third year = $3149.80 and cumulative interest upto 3rd year is $12077.97.
2. Total Interest paid is $15389.22 till 5 year.
PmtNo. Payment Date Beginning Balance Scheduled Payment Total Payment Principal Interest Ending Balance Cumulative Interest 1 01-01-02 $ 61,000.00 $ 15,277.84 $ 15,277.84 $ 10,397.84 $ 4,880.00 $ 50,602.16 $ 4,880.00 2 01-01-03 50,602.16 15,277.84 15,277.84 11,229.67 4,048.17 39,372.49 8,928.17 3 01-01-04 39,372.49 15,277.84 15,277.84 12,128.04 3,149.80 27,244.44 12,077.97 4 01-01-05 27,244.44 15,277.84 15,277.84 13,098.29 2,179.56 14,146.15 14,257.53 5 01-01-06 14,146.15 15,277.84 14,146.15 13,014.46 1,131.69 0.00 15,389.22