Archives for August, 2009
3 approaches to avoid complex off-sheet references
A key differentiator of the many different Best Practice Methodologies that have been developed, both by in-house and professional financial modelling...
‘Edit directly in cell’ – Quick Excel Tip
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 shows f...
Group and Outline – Essential tool for large financial models
The world of professional financial modellers have most core values aligned – simplicity, transparency, flexibility etc – but are divided when it comes t...
The 7 deadly sins of financial modelling
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...
Input structure for depreciation rates and asset lives
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...
Essential integrity checks for project finance modelling
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...
Sense-checking delay scenarios in a project finance model
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...