Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Make an Excel spreadsheet for Example 5.8. Include 1. Repayment schedule using the sinking fund method; 2. Repayment schedules using amortization methods (a) prospective method
Make an Excel spreadsheet for Example 5.8. Include 1. Repayment schedule using the sinking fund method; 2. Repayment schedules using amortization methods (a) prospective method (b) retrospective method Example 5.8: A loan of $1,000 at effective rate of interest of 6% per year is to be redeemed over 5 years by a sinking fund that credits interest at 5.5% with reinvestment rate of interest of 5%. Calculate the annual installments of the annuity-immediate required to redeem the loan. What is the equivalent rate of interest using the amortization method? Make an Excel spreadsheet for Example 5.8. Include 1. Repayment schedule using the sinking fund method; 2. Repayment schedules using amortization methods (a) prospective method (b) retrospective method Example 5.8: A loan of $1,000 at effective rate of interest of 6% per year is to be redeemed over 5 years by a sinking fund that credits interest at 5.5% with reinvestment rate of interest of 5%. Calculate the annual installments of the annuity-immediate required to redeem the loan. What is the equivalent rate of interest using the amortization method
Step 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