IPMT, PPMT, CUMIPMT & CUMPRINC: Any Month, Any Year
This lesson is part of the course
In this lesson
You split payment 61 of Leo's 30-year mortgage into interest and principal and build an annual summary with CUMIPMT and CUMPRINC, without a 360-row schedule.
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
- PMT Basics & the Sign Convention Locked
- Build a Full Amortization Schedule Locked
- IPMT, PPMT, CUMIPMT & CUMPRINC: Any Month, Any Year Locked
- Extra Monthly Payments: Months & Interest Saved Locked
- One-Off Lump-Sum Payments: Shorter Loan or Lower Payment Locked
- Balloon Payment Loans: PMT with fv Locked
- Interest-Only Then Amortising: The Payment Jump Locked
- Comparing Loans: APR with Fees, Total Cost & Balance Curves (Chart) Locked