How are you currently dealing with compatibility issues of Excel 2003 / 2007?

Fimodo speaks to five financial modelling experts to understand how they have (and continue to) deal with compatability issues.
Rickard Warnelid
Corality
www.corality.com The issue of non-compatibility of Excel 2003 / 2007 is not generally a problem internally within financial modelling teams, unless of course dif
...Read entire article

PPP/PFI Financial Modelling conference in London

Friday, January 15th   No Comments (yet)

SMI Conferences are organising a financial modelling conference in London focusing on the PPP/PFI sector. Fimodo and Corality’s Financial Model Audit team supports this initiative as it aims to improve the quality of financial modelling for PPP/PFI bids....

Read entire article

Modelling Principal Pre-payments-Part 1

Monday, January 11th   5 Comments

“Modelling pre-payments can cause brain failure and will lead to an overly complex model” At some point in the career of project finance modeller comes the...

Read entire article

Peter Weatherston – Financial model audits at Corality

Monday, January 11th   3 Comments

Fimodo chats to Peter Weatherston, Financial model audits at Corality.

Read entire article

Pre-operational cashflow modelling in project finance

Monday, December 14th   3 Comments

Modelling pre-operational cashflows

Lets get real and stop modelling discrete ‘construction phases’ in real world transactions.
Traditionally finan...

Read entire article

Andy Hucknall, PPP financial model audit at PKF

Thursday, December 3rd   3 Comments

Fimodo chats to Andy Hucknall, PPP financial model audit at PKF.

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

3 applications of Data Validation in a Project Finance model

Friday, October 16th   10 Comments

Data Validation can be applied to restrict a cell’s allowed contents to a range of predefined values or rules. This is a subtle and effective way of allowing...

Read entire article

‘Real growth’ or ‘Escalation’ – alternative financial modelling approaches

Monday, October 12th   5 Comments

A common question, especially among resource project developers is whether or not to escalate a particular line item by rate. When asked if this is the way t...

Read entire article

Max Wolf, global project finance in Germany (KfW-IPEX-Bank)

Thursday, October 8th   No Comments (yet)

Fimodo chats to Max Wolf, global project finance in Germany (KfW-IPEX-Bank).

Read entire article

Russian project finance at Gazprombank, Fazil Gadzhiev

Monday, October 5th   1 Comment

Fimodo chats to Fazil Gadzhiev – Group Head, Project & Structured Finance, Gazprombank.

Read entire article

Nick Crawley’s career in project finance modelling

Sunday, September 27th   1 Comment

Fimodo chats to Nick Crawley, Managing Director of Navigator Project Finance.

Read entire article

Debt sizing for minimum DSCR with VBA Goal Seek – Solve for zero delta!

Friday, September 18th   12 Comments

Optimising the maximum debt limit in the structuring phase of a project finance transaction can be made a lot easier if you have a clear dashboard view of wha...

Read entire article

Can Fimodo change the financial modelling world?

Tuesday, August 25th   1 Comment

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   4 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

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 comes t...

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