Example Model Excel Template
Originally published: 21/01/2019 08:45
Last version published: 21/01/2019 11:07
Publication number: ELQ-95688-2
View all versions & Certificate

Example Model Excel Template

Example forecast financial model template (free)

Purpose of this free example model is to demonstrate the ease of use and quality of models that we produce.

Feel free to download and play with the model to get comfortable with how our models work. Please note that the model lacks a lot of flexibility required to make financial decisions and is intended for demonstration purposes only. All of our models contain vastly increased amounts of flexibility. Please check the model descriptions of those models for more information. If you require something more bespoke then please feel free to get in touch and we can build it for you.

Please note that we build all of our model in a similar style, maximising ease of use, so the instructions below will apply to most of our models.

How to use this example model:
The navigation sheet ("Nav") includes:
- Hyperlinked sheet names with description of the contents of each sheet
- A key of various coloured cells and fonts used throughout the model
Every tab contains a “Navigation” button in the top left corner. Clicking this button will take you back to the ‘Nav’ sheet

The layout is the same for each sheet other than ‘Nav’ and ‘Dash’:
- Column D contains description of the contents of each row
- Column E tell you the units for the row
- Column F includes any assumptions/calculations that are independent of time i.e. that doesn’t change irrespective of the time period
- Columns I to P include all annual assumptions, calcualtions and summary outputs
- Column R onwards contain monthly assumptions, calculations and outputs
- Cell A1 tells you the name of the model. This can be updated in the assumptions page within the Model settings section
- Cell A2 tells you the purpose and name of each sheet
- Cell G1 contains model warning messages to indicate to the user if something has gone wrong within the model. In this case the user will either update the opening Balance Sheet in order that it balances or re-open a previously saved version of the model
- Additional instructions on how to use the model may be included within A12
- Row 2 contains a label for the time period determining whether the time period is an “Actual” or “Forecast” period. “Actual” periods are historical periods
- Hidden rows include:
o Row 3 contains binary flags that indicate whether the period is an “Actual” period
o Row 4 contains binary flags that indicate whether the period is an “Forecast” period
o Row 5 contains binary flags that indicate the first “Forecast” period
o Row 6 contains binary flags that indicate the last “Actuals” period
o Row 7 contains the model year number
o Row 8 has data in the annual timeline only. It contains the start period/month number for the year that the column represents
o Row 9 has data in the annual timeline only. It contains the end period/month number for the year that the column represents
- Row 10 contains the financial year within the annual timeline and the period number within the monthly timeline
- Row 11 tells you the start date of the period that the column represents
- Row 12 tells you the end date of the period that the column represents
- The model uses various headers to help break up assumptions, calculations and outputs:
o Column A contains the start of the first level of headers
o Column B contains the start of the second level of headers
o Column C contains the third level of headers

Yellow and orange cells in the model can be updated to affect the outputs. Yellow cells affect the model parameters and forecast assumptions. Orange cells affect the historical balances. Blue cells are fixed assumptions and as such should not be changed.

The first section of the assumption page is the “Model settings”. Use this section to set the model name, units and the model timeline settings. The model start date determines the starting date of the model in cell I11 in the timeline. The forecast start date determines the forecast period start date and hence cannot be before the model start date. You can use this assumption to roll the model forward as “Forecast” periods become “Actual” periods.

All other assumptions are as described either in the blue notes in column D or in the row descriptions. Assumptions may be entered either in column F, the annual timeline or the monthly timeline.

For assumptions enter positive numbers only unless otherwise instructed.

On the “Actuals” sheet enter actual Profit and Loss figures and the opening Balance Sheet (and balance breakdowns) into the orange cells. The forecast start date entered on the “Assumptions” page determines where the orange cells end on the “Actuals” sheet. Enter income, assets and equity as positive, and expenses and liabilities as negative.

Once purchasing a download of the model, you have licence to make modifications to the model including all calculations. However, should you do so the model may not work as originally intended.

Outputs from the model can be found on blue sheets. Some outputs will also be included on the “Assumptions” page in order to help the user in entering assumptions.

All assumptions and are pulled into the “Calculations” sheet. Outputs on the blue sheet are then taken from the “Calculations” sheet. Users are welcome to investigate all sub-calculations on the “Calculations” sheet.

This Best Practice includes
1 Excel Model Template

ModellingGuy offers you this Best Practice for free!

download for free

Add to bookmarks


Further information

To demonstrate the quality and ease of use of our models
To provide the user with a free template to sample and experience our models prior to committing to purchasing a more complex model template

For a user considering purchasing one of our models but wants to experience an example of the type of model they'd be purchasing
For someone looking to learn and practice how to use one of our models before purchasing

This model is not intended for any other commercial purpose other than to sample what one of our models is like to use



More Best Practices from ModellingGuy

See all

Any questions on Example Model Excel Template?

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

4.3 / 5 (3 votes)

please wait...