Excel Financial Functions: PMT, IPMT, NPV, XNPV, IRR, XIRR & RATE
FV, PV, PMT, IPMT/PPMT amortisation, RATE, NPER, NPV vs XNPV, IRR vs XIRR vs MIRR, depreciation, EFFECT/NOMINAL and an investment dashboard: 8 hands-on labs at one company, every cell checked instantly.
The first 2 lessons are free — no account needed.
About this course
An Excel financial functions course that runs one fictional coffee roaster's savings, loans and investments through Excel's built-in finance formulas, for analysts, accountants, finance students and anyone who uses PMT without quite trusting it. You project a savings plan with FV and get Excel's sign convention right, find the lump sum needed today with PV, calculate a loan payment with PMT and split it into interest and principal with IPMT, PPMT and CUMIPMT, uncover the real rate behind a van financing offer with RATE and the term of a credit line with NPER, value a café with NPV and rebuild XNPV from the real dates, compare IRR, XIRR and MIRR on the same cash flows, build SLN, DB, DDB and SYD depreciation schedules, convert rates with EFFECT and NOMINAL and finish with an investment comparison dashboard. The first two labs are free.
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