Financial Formulas: PMT, PPMT, NPV and XNPV
This lesson is part of the course
In this lesson
You work out a van loan payment and its principal split, value a warehouse expansion with NPV and a supplier deal with irregular dates using XNPV.
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
- Advanced Lookups: Two-Way, Multi-Criteria and Tiers Locked
- Multi-Criteria SUMIFS, COUNTIFS, AVERAGEIFS and MAXIFS Locked
- SUMPRODUCT with Boolean Arrays Locked
- Array Math inside SUM, AVERAGE, MAX and MATCH Locked
- Nested Logic: IFS, SWITCH, CHOOSE and IFERROR Locked
- Text Formulas: FIND, MID, SUBSTITUTE, TEXT and TEXTJOIN Locked
- Date & Time Formulas: EOMONTH, NETWORKDAYS, WEEKNUM, HOUR Locked
- Statistical Formulas: RANK, PERCENTRANK, LARGE and Conditional MEDIAN Locked
- Financial Formulas: PMT, PPMT, NPV and XNPV Locked
- Capstone: Audit and Repair a Broken Report Locked