Prepare an amortization schedule for a three-year loan of $102,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 '0' where necessary. Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) Answer is complete but not entirely correct. Year Beginning Balance Total Payment Interest Payment Principal Payment 1 30,519.73 $ 33,876.90✔✔ 37.603.36X wN. $ 102,000.00 $ 71,480.27 ✔ 37,603.36✔ 113,220.00 x $ 79,343.10 X 41,739.73✔ Total interest 11,220.00 $ 7,862.83✔✔ 4,136.37✔ $ 23,219.20 Ending Balance 71,480.27✔ 37,603.36 0.00

EBK CONTEMPORARY FINANCIAL MANAGEMENT
14th Edition
ISBN:9781337514835
Author:MOYER
Publisher:MOYER
Chapter19: Lease And Intermediate-term Financing
Section: Chapter Questions
Problem 17P
icon
Related questions
Question
Prepare an amortization schedule for a three-year loan of $102,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 '0' where
necessary. Do not round intermediate calculations and round your answers to 2
decimal places, e.g., 32.16.)
X Answer is complete but not entirely correct.
Year
Beginning
Balance
Total
Payment
Interest
Payment
Principal
Payment
1
$ 113,220.00 x $
30,519.73 $
2
79,343.10 X
33,876.90
3
41,739.73
37.603.36X
Total interest
$
102,000.00
71,480.27
37,603.36
11,220.00
7,862.83
4,136.37
$ 23,219.20
Ending
Balance
71,480.27
37,603.36
0.00
Transcribed Image Text:Prepare an amortization schedule for a three-year loan of $102,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 '0' where necessary. Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) X Answer is complete but not entirely correct. Year Beginning Balance Total Payment Interest Payment Principal Payment 1 $ 113,220.00 x $ 30,519.73 $ 2 79,343.10 X 33,876.90 3 41,739.73 37.603.36X Total interest $ 102,000.00 71,480.27 37,603.36 11,220.00 7,862.83 4,136.37 $ 23,219.20 Ending Balance 71,480.27 37,603.36 0.00
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
Recommended textbooks for you
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
Pfin (with Mindtap, 1 Term Printed Access Card) (…
Pfin (with Mindtap, 1 Term Printed Access Card) (…
Finance
ISBN:
9780357033609
Author:
Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Corporate Fin Focused Approach
Corporate Fin Focused Approach
Finance
ISBN:
9781285660516
Author:
EHRHARDT
Publisher:
Cengage
Intermediate Financial Management (MindTap Course…
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning