Linking Excel to Web Data – The Easy Way to Update Inputs
Excel has some powerful features that allow the user to directly query databases and websites. Whilst the application of such functionality is not going t…
Including Scenarios in your Financial Model (Video)
This video looks at including scenarios in your financial model, using different methods in Excel. From a simple manual drop down selection, to using ‘Scenario Manager’ within Excel, to data tables (one of the more complex tools). As a financial modeller – you need to know all of the tools that are available. A full transcript of the 3-minute long video is also supplied for your conven…
Read entire article
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.
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 t…
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…
Peter Weatherston – Financial model audits at Corality
What do you do?
I work as an associate for Corality, managing the audits of financial models form large PPP and project finance transactions to investment b…
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…
Streamline your Financial Model with Export Worksheets!
Export worksheets, like Import worksheets, can give your financial model another dimension as it can be seamlessly exported into corresponding financi…
Andy Hucknall, PPP financial model audit at PKF
What do you do?
I direct numerous model audit projects at PKF (UK) LLP, one of the world’s leading model audit practices, as well as being actively inv…
Achieve better flexibility using Import Worksheets
Import worksheets will greatly enhance the credibility of your financial model. One of the greatest challenges users face when using, managing or enhanc…
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.
Assume nothing with your financial model – Assumptions worksheet
A financial model should incorporate an Assumptions worksheet that outlines the key features of the financial model, such as the relevant tax rate or fina…
Use Error Checks in your financial model
Incorporating error checks into a financial model helps to bulletproof, safeguard and enhances the integrity and value of a financial model to users. All…
Six reasons your spreadsheet is NOT a financial model
I’ve often been asked the difference between a spreadsheet and a financial model, and there is a fine line of definition between the two. In a nutshell, an Ex…
Using a faded colour scheme in Excel for user interface modelling
I have recently been involved in a project where the end product spreadsheet has been designed to be used to consumers, i.e. a less technical audience than I…
Tips for mastering financial modelling of balance sheets
The Balance Sheet can be one of the trickiest financial statements to model, as several line items are the result of decisions you make for the other financi…
How to Stress-test Your Business Case
In a volatile economic environment, creating a business case for a new project or product which contains financial projections is an extremely difficult…
Do You Really Need an ‘Advanced Excel’ Course?
Excel is the backbone to any custom built financial model, and one of the core attributes of a financial modeller is to have good technical Excel skills. Wh…
Five Excel Formulas to make you cringe
When creating a financial model, there are always multiple ways to write a formula which will all give you the same result. The key is to write formulas inte…
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…