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…
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 articleExcel has some powerful features that allow the user to directly query databases and websites. Whilst the application of such functionality is not going t…
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 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…
I work as an associate for Corality, managing the audits of financial models form large PPP and project finance transactions to investment b…
Lets get real and stop modelling discrete ‘construction phases’ in real world transactions.
Traditionally finan…
Export worksheets, like Import worksheets, can give your financial model another dimension as it can be seamlessly exported into corresponding financi…
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…
Import worksheets will greatly enhance the credibility of your financial model. One of the greatest challenges users face when using, managing or enhanc…
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…
Incorporating error checks into a financial model helps to bulletproof, safeguard and enhances the integrity and value of a financial model to users. All…
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…
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…
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…
In a volatile economic environment, creating a business case for a new project or product which contains financial projections is an extremely difficult…
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…
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…
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…