Transcript
Instructions
- Calculate the total payment (monthly payment * monthly loan term).
- Use an absolute cell reference ($) for the number of payments cell.
- Calculate the amount you will pay in interest (total payments - loan amount).
- Copy these formulas to the rest of your loan amount table.
- Experiment changing the APR and loan terms.