Basic Forecast Excel Model Template
Originally published: 26/12/2018 10:55
Last version published: 02/01/2019 16:45
Publication number: ELQ-83294-2
View all versions & Certificate

Basic Forecast Excel Model Template

Great first time forecast model (Cash Flow, Balance Sheet, Income Statement, and valuation)

Great model for someone who wants to teach themselves the basics of modelling and valuations.

The Excel model template has the ability to enter up to 8 years. The user has the ability to enter both actuals and forecast numbers. The user will also have the ability to build up assumptions for a discount rate based on WACC (Weighted Average Cost of Capital) and calculate a valuation for the business.

The Income Statement includes revenue with the ability to add monthly seasonal trends. Cost of sales is calculated as a margin on sales and admin costs are calculated as a percentage of sales. Interest expenses and interest income are also calculated.
The corporation tax is calculated in a flexible way to allow the user to fully determine the tax payments to correctly reflect their own tax jurisdiction.

Significant Balance Sheet items include stock, debtors and creditors driven by working capital days assumptions. Calculations include sales tax (referred in the model as VAT), corporation tax, interest, capital expenditure (and depreciation) and dividends.

The Balance Sheet also includes a number of balances that are held constant throughout the model timeline such as other fixed assets and other net working capital. The model contains basic debt and accrued interest calculations that are typed in over the timeline.

With this tool comes a PDF slide of instructions on how to use the model Additionally, there are multiple notes and labels within the model's assumptions pages in order to guide the user when filling in their assumptions.

This Best Practice includes
1 excel model and 1 powerpoint of instructions

Acquire business license for $30.00

Add to cart

Add to bookmarks


Further information

To teach yourselves the basics of modelling and valuations and generate a simple forecast set of financial statements and valuation

When someone wants to teach themselves the basics of modelling and valuation
Understand the basics of the business sales, costs, working capital, and capex assumptions
The user has a basic understanding of accounting
The user requires flexibility in the tax calculations to correctly reflect their own tax jurisdiction

When someone needs a sophisticated model for a specific business purpose - this is a training model for teaching yourselves the basics


  • Be the first to review this Downloadable Best Practice

    Write a review

People using this Best Practice also downloaded


More Best Practices from ModellingGuy

See all

Any questions on Basic Forecast Excel Model Template?

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

0.0 / 5 (0 votes)

please wait...