Errors will happen. It is an unfortunate fact of life, whenever humans are involved with complex data manipulation and modelling, errors occur. A financial modelling manager needs to create an environment where any member of the modelling team can feel comfortable notifying them as soon as an error or mistake is identified. Having confidence in… Read more →
We have taught analysts from hundreds of companies to build financial models. Financial modelling proficiency requires skills that take time to acquire, develop and perfect. Sometimes the difficulties students have are related to how to build their model. More often, difficulties relate to what it is they need to model. Once the modeller understands how… Read more →
“The habit of beginning a process of construction with a clear understanding of the end product can be highly beneficial when building financial models”
The article below is taken from our new ebook: Managing Modelling – How to run an effective modelling team – you can download the full ebook here. Modelling should be a collaborative team-based activity, not an individual activity. Building team spirit and a collaborative environment is fundamental to the role of a financial modelling manager…. Read more →
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