Archives for July, 2009

Business planning for a start-up venture

Sunday, July 26th   No Comments (yet)
Starting a new business is a challenging process and involves a number of hurdles. The challenges range across finance, reporting, legal, commercial and...

Read entire article

Line Summaries – get the big picture!

Saturday, July 18th   1 Comment
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...

Read entire article

Do not use WordArt in your financial model!

Thursday, July 16th   4 Comments
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 pr...

Read entire article

Why your last financial model audit was so expensive?

Wednesday, July 15th   1 Comment
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...

Read entire article

Improved financial modelling with conditional formatting

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

Read entire article

How many Excel Worksheets do you prefer?

Friday, July 10th   4 Comments
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...

Read entire article

How to successfully build portfolio (multi-asset) models

Wednesday, July 8th   No Comments (yet)
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...

Read entire article

Visually tracing all precedents in Excel without add-ins

Sunday, July 5th   7 Comments
There are numerous tools and add-ins in the market constructed to enhance the ability to critically review formulas in Excel. Many of these tools build on t...

Read entire article