Loan Amortization Schedules in Excel: PMT, IPMT, PPMT, Extra Payments & Balloons
Build a real amortization schedule step by step: PMT and the sign convention, a full schedule copied down to zero, IPMT/PPMT and CUMIPMT/CUMPRINC for any month or year, extra monthly payments, lump sums and recasting, balloon loans, interest-only periods and an APR comparison with a balance chart. 8 hands-on labs, every cell checked. Educational only, not financial advice.
The first 2 lessons are free — no account needed.
About this course
A loan amortization schedule course that builds the loans of one fictional borrower, Leo, in a spreadsheet, for anyone who borrows, lends or advises on loans and for finance and Excel learners. You price a car loan with PMT and the sign convention, build a full schedule row by row until the balance reaches zero, split any payment of a 30-year mortgage into interest and principal with IPMT and PPMT and summarise whole years with CUMIPMT and CUMPRINC, add extra monthly payments and stop the schedule cleanly with MIN, drop in a lump sum and compare a shorter loan with a lower payment, price balloon and interest-only loans, and compare three offers by APR with fees and a balance chart. Fictional borrower, illustrative rates, educational only, not financial advice. The first two labs are free.
Lessons
- PMT Basics & the Sign ConventionFree
- Build a Full Amortization ScheduleFree
- IPMT, PPMT, CUMIPMT & CUMPRINC: Any Month, Any Year Pro
- Extra Monthly Payments: Months & Interest Saved Pro
- One-Off Lump-Sum Payments: Shorter Loan or Lower Payment Pro
- Balloon Payment Loans: PMT with fv Pro
- Interest-Only Then Amortising: The Payment Jump Pro
- Comparing Loans: APR with Fees, Total Cost & Balance Curves (Chart) Pro