Question: can someone help me fill in the missing values? Prepare an amortization schedule for a three-year loan of $114,000. The interest rate is 11 percent
Prepare an amortization schedule for a three-year loan of $114,000. The interest rate is 11 percent per year, and the loan calls for equal annual payments. How much total interest is paid over the life of the loan? (Leave no cells blank. Enter 'O' where necessary. Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) Year Principal Payment Ending Balance 1 $ 2 Beginning Total Balance Payment 114,000.00 s 46,650.29 $ 79,889.71 46,650.29 42,027.29 46,650.29 Total interest Interest Payment 12,540.00 8,787.87 4,623.00 25,950.87 3
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
