Financial Model Assumption Book
Originally published: 10/03/2020 14:44
Last version published: 10/09/2021 08:00
Publication number: ELQ-98928-3
View all versions & Certificate
certified

Financial Model Assumption Book

Financial model assumption and reference sheet template to be linked to the model

Description
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.

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

The spreadsheet also includes a sample sheet for setting out the sources of each input you are using in your models.

This Best Practice includes
1 Excel file

FinExMod offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss

Reviews

keyboard_arrow_downShow all


keyboard_arrow_leftkeyboard_arrow_right

More Best Practices from FinExMod

See all
keyboard_arrow_leftkeyboard_arrow_right

Any questions on Financial Model Assumption Book?

The user community and author are here to help. Go ahead!


4.8 / 5 (13 votes)

please wait...