Feature
Nick explores how Data Validation can be applied to restrict a cell’s allowed contents to a range of predefined values or rules with a particular focus on its application in the field of Project Finance modelling.
Recent Articles
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 to go I answer with the following questions...
I am a member of a dedicated financial modelling team within KfW IPEX-Bank, a global provider of long term debt finance. As an internal consultant I support our loan originators with financial modelling services.
When you create a new Workbook in Excel you get the standard three worksheets and the standard (useless) Excel Styles. This means that every time you want to start preparing a workbook, you need to do one of the following to improve the presentation...
Recent Comments
"In my experience and opinion I believe that there are not enough solutions providers out there who possess sufficient technical skills. They are either too ‘technical’ or too ‘financial’. I don’t mean to cause offence with this statement..."
Jon von der Heyden
"Hi Jon, Thanks again for your comments – I really think it is great for Fimodo’s readers to see the different views on VBA which proves that it is quite a controversial topic..."
Rickard Wärnelid
"Wonderful stuff. I was just talking to a tax colleague this morning who was complaining about the treatment of depreciation lives in some of the software he uses to compute various tax provisions. I will encourage him to look up this blog."
Chris Mishler
"I strongly support the approach of fewer but deeper worksheets in a model. I usually have one central calculation sheet that does virtually everything in the model..."
Gavin Townshend
"Hi Gavin, As always I think its all about striking the fine balance between userbility and auditability / editability (thats a lot of “bilities”!). In particular when working on portfolio models..."
Nick Crawley
|
