Archives for November, 2009
How has your approach to financial modelling evolved over your career?
Fimodo speaks to four financial modelling experts to get a brief history of their professional development, and how that has changed over time.
...
Assume nothing with your financial model – Assumptions worksheet
A financial model should incorporate an Assumptions worksheet that outlines the key features of the financial model, such as the relevant tax rate or fina...
Use Error Checks in your financial model
Incorporating error checks into a financial model helps to bulletproof, safeguard and enhances the integrity and value of a financial model to users. All...
Six reasons your spreadsheet is NOT a financial model
I’ve often been asked the difference between a spreadsheet and a financial model, and there is a fine line of definition between the two. In a nutshell, an Ex...
Using a faded colour scheme in Excel for user interface modelling
I have recently been involved in a project where the end product spreadsheet has been designed to be used to consumers, i.e. a less technical audience than I...
Tips for mastering financial modelling of balance sheets
The Balance Sheet can be one of the trickiest financial statements to model, as several line items are the result of decisions you make for the other financi...