Create a worksheet that through inputs and a series of formulas, be a basis of an expandable tool, that you can use to create project an amortization schedule.
The spreadsheet should be able to do various calculations using automated formulas.
Also include:
Calculate date of each payment
Calculate the sum of interest and principal for calendar or loan year
Actual vs 360 payments.
Average life
Duration
SHOW ALL EXCEL FORMULAS that are USED IN the EXCEL cell AND USE YOUR OWN NUMBERS THANKS
Get Answers For Free
Most questions answered within 1 hours.