Modelling Principal Pre-payments-Part 1
“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...
PPP/PFI Financial Modelling conference in London
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
Peter Weatherston – Financial model audits at Corality
Fimodo chats to Peter Weatherston, Financial model audits at Corality.
Pre-operational cashflow modelling in project finance
Modelling pre-operational cashflows
Lets get real and stop modelling discrete ‘construction phases’ in real world transactions.Traditionally finan...
Andy Hucknall, PPP financial model audit at PKF
Fimodo chats to Andy Hucknall, PPP financial model audit at PKF.
How has your approach to financial modelling evolved over your career?
Fimodo speaks to four financial modelling experts to get a brief history of their professional development, and how that has changed over time.
...
3 applications of Data Validation in a Project Finance model
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...
‘Real growth’ or ‘Escalation’ – alternative financial modelling approaches
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...
Max Wolf, global project finance in Germany (KfW-IPEX-Bank)
Fimodo chats to Max Wolf, global project finance in Germany (KfW-IPEX-Bank).
Russian project finance at Gazprombank, Fazil Gadzhiev
Fimodo chats to Fazil Gadzhiev – Group Head, Project & Structured Finance, Gazprombank.
Nick Crawley’s career in project finance modelling
Fimodo chats to Nick Crawley, Managing Director of Navigator Project Finance.
Debt sizing for minimum DSCR with VBA Goal Seek – Solve for zero delta!
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...
Can Fimodo change the financial modelling world?
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...
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...
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...
Spot-checking a project finance model in 60 seconds
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...