Instructions
Complete the loan amortization exercise explained below and submit it by the due date
Remember to follow academically acceptable Excel standards.
Exercise #2: Loan Amortization
Loan Assumptions ●Term: 30 Years ●Interest Rate: 5% annual ●Amortization: Full ●Principal: $500,000 ●Payments: Monthly
Excel Output A.Loan Amortization, by month, over Term B.Scenario Analysis: i.Principal balance, in Year 2, 5, 10 ii.What if interest rate 4% vs. 5%? C.Output Matrix, can we create: i.“Lookup” on # years? ii.Link to interest rate change?
