Welcome to a 5-part video series on the “Must-have Excel Functions for Financial Modelling”. Taking into account the time value of money is something that we often need to do in financial models and in part 4 of this series, we take a look at some of the Excel functions specifically designed for decision making based on discounted cashflow and rates of return. Watch as Microsoft MVP, Danielle Stein Fairhurst demonstrates how to use the PV (Present Value), NPV (Net Present Value) and IRR (Internal Rate of Return) functions as well as how these differ to the XNPV and XIRR functions and what to watch out for when switching between these different functions.

Follow Danielle Stein Fairhurst on LinkedIn