Building financial models is an inherently difficult and complex task. Most guidance on managing the model build process recommends a traditional life-cycle approach of Specify, Design, Develop, Test, Deploy. When applied to most financial modelling assignments this approach doesn’t work. It is too inflexible and relies on being able to fully specify the model at… Read more →
This week you are invited to experience the highs (and lows) of being a model auditor and embark on a ‘find the errors’ exercise. Difficulty: Easy Prize: Free access to our new online course FAST Fundamentals and a limited edition F1F9 mug. Introduction The flexibility of excel, responsible in large part for its ubiquity in the… Read more →
We’ve designed FAST Fundamentals for those who have completed our free “31 days to better financial modelling” online course and are looking for their next step.
In “Beyond the FAST Standard: adventures in enterprise reporting and analysis”, Kevin and Andrew will explore with you what it is like to break the rules but retain the spirit and the philosophy of a modelling standard.
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.