Archives for December, 2009

Achieve better flexibility using Import Worksheets

Monday, November 30th   1 Comment
Import worksheets will greatly enhance the credibility of your financial model. One of the greatest challenges users face when using, managing or enhanc...

Read entire article

How has your approach to financial modelling evolved over your career?

Tuesday, November 24th   1 Comment
Fimodo speaks to four financial modelling experts to get a brief history of their professional development, and how that has changed over time. ...

Read entire article

Assume nothing with your financial model – Assumptions worksheet

Monday, November 23rd   1 Comment
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...

Read entire article

Use Error Checks in your financial model

Thursday, November 19th   4 Comments
Incorporating error checks into a financial model helps to bulletproof, safeguard and enhances the integrity and value of a financial model to users. All...

Read entire article

Six reasons your spreadsheet is NOT a financial model

Monday, November 16th   3 Comments
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...

Read entire article

Using a faded colour scheme in Excel for user interface modelling

Monday, November 16th   No Comments (yet)
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...

Read entire article

Tips for mastering financial modelling of balance sheets

Monday, November 9th   11 Comments
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...

Read entire article

How to Stress-test Your Business Case

Sunday, November 1st   1 Comment
In a volatile economic environment, creating a business case for a new project or product which contains financial projections is an extremely difficult...

Read entire article