Archives for July, 2009
Line Summaries – get the big picture!
Within the first few minutes of starting to build a financial model for project finance, corporate finance or any other sector it becomes clear that a finan...
Do not use WordArt in your financial model!
In Excel there is a horrible functionality called WordArt. If you didn’t know this already then I apologise for having given you an idea of being able to pres...
Why your last financial model audit was so expensive?
Building a financial model that is cost efficient to audit is a lesson that many Analysts learn the hard way when they receive a quote exceeding their annual...
Improved financial modelling with conditional formatting
Presenting data in a format that is easy to read in Excel can be a challenge, in particular when you are dealing with larger arrays of data. In this example we w...
How many Excel Worksheets do you prefer?
When building a financial model, for any discipline, you may want to think about if you want to have lots of worksheets with not much in each one or few but rich...
How to successfully build portfolio (multi-asset) models
It is common practice in project, corporate and structured finance transactions for a financial model to need to accommodate more than just one project, c...