Discounted cash flow webinar materials
The materials from this session.
NPV and XNPV in a project finance model
This recorded webinar looks at project valuation with the discounted cash flow (DCF) method, using project finance examples to show the XNPV approach in Excel. It focuses on adding the XNPV function to an existing financial model, and on how XNPV differs from Excel’s standard NPV function and why it is often better.
It also covers the common mistakes in NPV calculations and how to avoid them.
What you will learn
- The theory of NPV and the time value of money as applied to project finance models, with a focus on energy and infrastructure assets
- A live demonstration of Excel’s NPV and XNPV functions in a financial model
- Why the model’s timeline matters, and how it affects NPV, XNPV and first principles calculations
- How NPV is built into a financial model and how to read it
- The typical errors in NPV calculations and how to avoid them in your own models