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?
Last Completed Projects
| topic title | academic level | Writer | delivered |
|---|