NPV vs XNPV: Discounting Dated Cash Flows
This lesson is part of the course
In this lesson
You value Juniper's planned café with NPV, rebuild XNPV by hand from the real dates and see why the two results differ.
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