Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Consider a 4-year amortizing loan. You borrow $1,600 initially and repay it in four equal annual year-end payments. PLEASE SHOW FORMULAS IN EXCEL If the
Consider a 4-year amortizing loan. You borrow $1,600 initially and repay it in four equal annual year-end payments.
PLEASE SHOW FORMULAS IN EXCEL
If the interest rate is 8%, what is the annual payment?
b. Prepare an amortization schedule. (Do not round intermediate calculations. Round your answers to 2 decimal places. Leave no cells blank - be certain to enter "O" wherever required.) X Answer is complete but not entirely correct. Time Loan Balance ($) Year-End Interest Due on Loan Balance ($) 128.00 Total Year-End Payment ($) Amortization of Loan ($) 0 483.07 611.07 X 1 176.88 483.07 659.96 X 2 1,600.00 2,211.07 X 2,871.03 X 3,583.79 X 4,354 X 229.68 X 483.07 712.76 X 3 286.70 483.07483.07 769.78 X 4 4 348Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started