PMT, IPMT, PPMT and an Amortisation Table
All lessons
- FV, PV and Excel's Sign ConventionFree
- PMT, IPMT, PPMT and an Amortisation TableFree
- RATE and NPER: Solve for the Rate and the Term Pro
- NPV vs XNPV: Discounting Dated Cash Flows Pro
- IRR vs XIRR vs MIRR Pro
- Depreciation: SLN, DB, DDB and SYD Pro
- EFFECT, NOMINAL and Day-Count Basics Pro
- Capstone: Investment Comparison Dashboard Pro
You are not signed in — the lab works, but your progress is not saved. Start free
Loading the spreadsheet…