Archives for August, 2009

Can Fimodo change the financial modelling world?

Tuesday, August 25th   2 Comments
There are a number of financial modelling websites out there, and they all have their respective strengths and weaknesses. Over the last few years I have of...

Read entire article

3 approaches to avoid complex off-sheet references

Tuesday, August 25th   5 Comments
A key differentiator of the many different Best Practice Methodologies that have been developed, both by in-house and professional financial modelling...

Read entire article

‘Edit directly in cell’ – Quick Excel Tip

Tuesday, August 25th   4 Comments
There is a setting in the Options -> Edit -> Setting section called ‘Edit directly in cell. The ‘Edit directly in cell’ related to the way Excel...

Read entire article

Group and Outline – Essential tool for large financial models

Sunday, August 23rd   No Comments (yet)
The world of professional financial modellers have most core values aligned – simplicity, transparency, flexibility etc – but are divided when it co...

Read entire article

The 7 deadly sins of financial modelling

Sunday, August 16th   2 Comments
All of us have bad habits when it comes to financial modelling. Some of us are self-taught and lack fundamental discipline and others have attended too many...

Read entire article

Input structure for depreciation rates and asset lives

Friday, August 14th   2 Comments
Depreciation is a key component of a financial model to calculate the tax payable. Of course it is often critical to calculate the Profit and Loss but in proj...

Read entire article

Essential integrity checks for project finance modelling

Tuesday, August 11th   No Comments (yet)
Integrity checks are a crucial part of a project finance model. They alert the user when any one or several conditions that need to be satisfied are indeed br...

Read entire article

Sense-checking delay scenarios in a project finance model

Thursday, August 6th   No Comments (yet)
On of the most common mistakes in project finance modelling is incorrect coding of delay scenarios. The main reason for this is that it is not implemented as...

Read entire article

Spot-checking a project finance model in 60 seconds

Wednesday, August 5th   No Comments (yet)
Most financial models contain serious errors. The challenge is to find out before you rely upon a financial model for an investment decision! There are a nu...

Read entire article