Prepare an amortization schedule for a three-year loan of $117,000. 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? Note: Leave no cells blank. Enter '0' where necessary. Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16. Year 1 2 3 $ Beginning Balance 117,000.00 Total Payment Total interest Interest Payment Principal Payment Ending Balance

EBK CONTEMPORARY FINANCIAL MANAGEMENT
14th Edition
ISBN:9781337514835
Author:MOYER
Publisher:MOYER
Chapter5: The Time Value Of Money
Section: Chapter Questions
Problem 41P
icon
Related questions
Question
Prepare an amortization schedule for a three-year loan of $117,000. 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?
Note: Leave no cells blank. Enter '0' where necessary. Do not round intermediate calculations and round your answers to
2 decimal places, e.g., 32.16.
Year
1
2
3
$
Beginning
Balance
117,000.00
Total
Payment
Total interest
Interest
Payment
Principal
Payment
Ending
Balance
Transcribed Image Text:Prepare an amortization schedule for a three-year loan of $117,000. 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? Note: Leave no cells blank. Enter '0' where necessary. Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16. Year 1 2 3 $ Beginning Balance 117,000.00 Total Payment Total interest Interest Payment Principal Payment Ending Balance
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Rate Of Return
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT