I would prefer to use the XIRR function since it matches cashflows with actual dates
This week we move on to the twin brother of NPV – The Internal Rate of Return or IRR.
I was surprised at the variation in the results submitted. It highlighted to me the scope for misinterpretation and error in the calculation of something as apparently simple as an NPV.
FAST Financial Statement Modelling will give you the essential model construction and design skills you need and will teach you to apply them to the complexities that arise from a case study
Net present Value (NPV) is a key metric used by investors to calculate the attractiveness of a potential investment.
Colour is a transparent and effective way to communicate meaning within excel models.
It’s good to get the model ‘out there’ so decision makers can see what is really going on and not just the headlines.
“If the stuff shared for free is good, then how much better must the stuff they charge for be?”