PMT, IPMT, PPMT and an Amortisation Table
This lesson is part of the course
In this lesson
You calculate the monthly payment on Juniper's roaster loan, split the first year into interest and principal, roll the balance forward and get year-2 interest with CUMIPMT.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- FV, PV and Excel's Sign Convention Locked
- PMT, IPMT, PPMT and an Amortisation Table Locked
- RATE and NPER: Solve for the Rate and the Term Locked
- NPV vs XNPV: Discounting Dated Cash Flows Locked
- IRR vs XIRR vs MIRR Locked
- Depreciation: SLN, DB, DDB and SYD Locked
- EFFECT, NOMINAL and Day-Count Basics Locked
- Capstone: Investment Comparison Dashboard Locked