Unlock the code – Model Definition & Purpose
This is a new series of blogs in which we will dig into the new ICAEW Financial Modelling Code. Sign up to receive the whole series here. You can also download our whitepaper describing the Numeritas approach to complying with the Code here: download our whitepaper
How to build a financial model from scratch
So you’ve just been told that a model is required and you’ve been lucky enough to be chosen to build it. You enthusiastically open up Excel ready to jump right in, when you face the initial panic of dealing with a completely blank workbook!
To rebuild or not to rebuild that is the question
If Hamlet were around today, looking at his tired spreadsheet, surely he would be asking himself this question; it comes up time and again.
Bringing Excel charts or data tables into Powerpoint or Word using Office 2010
Having built your flexible and robust model in excel, based on Numeritas’ financial modelling SCILS no doubt, you will be eager to share the key insights which you have gained from the process.
Problems with the IRR in Excel
Many organisations rely on the IRR as a measure of the success of a project. There are, however, some technical issues with using the IRR function in Excel, as well as some general issues that the user should be aware of.
Cheaper model reviews
The way you build your spreadsheet model can dramatically affect the time and cost of having it reviewed – read on to find out how:
