Making your financial model look professional Back in school, teachers always gave a few extra marks to the students who set out their workings in...
Sparklines in Excel are great little visual representations of your data. They make it easier for users to gain insight into a whole block of...
The SUMIF function allows you to sum values in a given range, provided the corresponding cells in another range satisfy a chosen criterion. The SUMIFS...
The DATEDIF function is one of several hidden Excel legacy functions. We say hidden, it’s because Excel does not suggest any of these as part...
Simplifying a model is one of our favourite projects. There’s nothing more satisfying than taking a working model, which, for whatever reason, has become too...
If you build or work with financial models, your work will undoubtedly be reviewed sooner or later. In this blog, we will outline the various...
Inflation is very important in financial modelling. It’s an area that creeps into many models, whether they are integrated financial statements, or component/sub models. It’s...
The NPV or Net Present Value of cashflows is a key metric in investment appraisal. It lets us look at the cashflows of a given...
We’ve all been there. A formula changes somewhere along a row or column and isn’t marked in any way to make you aware of it....
Use these tips to save time and reduce the risk of error in your Excel formula. Long formulae are difficult to understand five minutes after...
Building a financial model can be a long and complex process. In a world where accuracy is key, ensuring that your model is fit for...