Financial Modelling Workshop – Discounted Cashflow Valuation (DCF) using XNPV approach

25 March, 10AM GMT// 12PM SAST

This complimentary financial modelling workshop is designed to enhance participants’ expertise in project valuation using the discounted cashflow (DCF) method, drawing on project finance examples to illustrate the XNPV approach in Excel. The session will focus on integrating the XNPV function into an existing financial model, highlighting the distinctions and benefits of XNPV compared to Excel’s standard NPV function. The workshop will also address common mistakes in NPV calculations and provide guidance on how to avoid them. 

 - Gain an overview of the theoretical foundations of NPV and the time value of money as applied to financial modelling for project finance, with a focus on energy and infrastructure assets.
- Observe a live demonstration of Excel’s native NPV and XNPV functions, highlighting their application in financial models.
- Understand why the financial model’s timeline is critical, and how it influences NPV, XNPV and first principles calculations.
- Strengthen your grasp of how NPV is integrated and interpreted within a financial model.
- Review typical errors made in NPV calculations and learn practical strategies for avoiding these pitfalls in your own models.

Register for this free webinar