“If you can’t describe what you are doing as a process,
you don’t know what you’re doing”
W. Edwards Deming

Inserting your financial model databook, within your financial model

Written by Hedieh Kianyfard

Sometimes financial models are accompanied by another document called “The Databook” or “manual for using the Financial model”. I don’t like to call it a manual, as I agree with Elon Musk in that any product that needs a manual to work is broken!

To me, the purpose of the Databook is to provide the key technical, financing and project assumptions and give an overview of the cash flow projections and the main results of the financial model.

Usually the busy investment officers appreciate this document and use it to quickly extract information from it and use it with the project documents. Although I really like the idea of having a databook, personally I can’t handle updating it every time that I am circulating a different version of the financial model. So, I decided to include the databook within my models and link it to the model input sheet and Dashboard.

I would like to know what you think about the idea of having a databook along with the financial model and what you think are the important topics that should be included in the databook?

You can find a sample Databook sheet in the Excel file. Click here to download.

Below are the content headings of atypical financial model databook.

1. Model overview

1.1. Colour-codes
1.2. Worksheets description
1.3. Macros
1.4. Financial model flow diagram
1.5. Periodicity

2. Project overview

3. Key assumptions

3.1. Project schedule
3.2. Construction cost assumptions
3.3. Financing assumptions
3.4. Operating assumptions

3.4.1. Technical Assumptions
3.4.2. Revenue Assumptions
3.4.3. Operating Cost Assumptions
3.4.4. Major Maintenance Assumptions
3.4.5. Working Capital Assumptions
3.4.6. Tax Assumptions
3.4.7. Dividend policy

4. Output results

4.1. Sources & Uses
4.2. Key Ratios and Returns
4.3. Sensitivity summary results

Monte Carlo simulation – New handbook guide

One of our latest financial modelling handbook guides is on Monte Carlo simulation. We are really grateful to Gerald Strever for putting it together. Gerald is a leading expert on financial modelling and spreadsheet techniques. He is the Senior … [Continue reading]

How to switch off animation in Excel 2013

Excel 2013 is pretty nice. The interface is clean and crisp and Microsoft seem to have gotten rid of most of the bugs that made Excel 2007 such a disaster. However the "sweeping" animation on the cursor, and the slot machine style animations when … [Continue reading]

Give it away for free

By Andrew Berkley.  Andrew has taken on the role of Financial Modelling Handbook editor from Kenny Whitelaw-Jones.  He will hand on the role to a new editor at the end of 2014. How many PC users know that you can put spaces in between words in … [Continue reading]

Checkmate errors with checks!

Written by Hedieh Kianyfard “ Errors using inadequate data are much less than those using no data at all.” - Charles Babbage It is common to hear people complaining about excel being prone to errors. Even if we take a very systematic and … [Continue reading]

Your feedback on the Financial Modelling Handbook

A few weeks ago we asked you for feedback about the Handbook Project and the guides we’d released so far. Lots of you replied and gave us really useful feedback - thank you! Overall usefulness Overall it seems that most of you are finding the … [Continue reading]

Handbook-athon! 15 new guide topics

A couple of weeks ago the F1F9 modelling team had a full day "Handbook-athon". The team came up with ideas for 15 new modelling guides. They then split into small teams and started to write the content for them and create the model example files. The … [Continue reading]

NEW CONTRIBUTION: ADVANCED DEPRECIATION USING SUMIF

This week's guide has been put together with Andrew, one of the modelling instructors at F1F9 and looks at depreciation calculations. You'll see a use of SUMIF that you might not have come across. There are lots of ways of doing these kinds of "look … [Continue reading]

New Contribution: Using Placeholders

This week Neha from the F1F9 modelling team has put together a guide on using placeholders. This is such a simple technique but one that we use ALL THE TIME in in our modelling. Thank you for all the comments over the last week - I appreciate them … [Continue reading]

Sign Convention

When should numbers in a financial model be positive, and when should they be negative? This question is one that modellers often feel quite strongly about. Although the FAST Standard has a well established position on this, I want to open this up … [Continue reading]