Generic forecast financial Excel Model Template
Originally published: 06/07/2018 08:05
Last version published: 22/12/2018 16:45
Publication number: ELQ-72284-9
View all versions & Certificate

Generic forecast financial Excel Model Template

Generic forecasting model including valuation calculations

The 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 and calculate a valuation for the business.

The operations includes up to three sales divisions, the ability to add monthly seasonal trends.
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.

Other significant Profit and Loss balances include staff costs, rent and rates, maintenance and repairs, professional fees, and other exceptional items.
Significant Balance Sheet items include stock, debtors and creditors driven by working capital days assumptions. Calculations include VAT (sales tax), 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 goodwill and investments. Whilst the model does not contain calculations for new debt funding to be drawn down within the timeline the user can make the assumptions that the business includes debt from day 1 or from the date of the opening balance sheet and then manually define what happens to the amortisation and interest payments.

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 slide of instructions

Acquire business license for $45.00

Add to cart

Add to bookmarks


Further information

To generate a forecast set of financial statements for a business and produce a valuation. The model also has the ability to enter historic balances if there are any

The user has some basic understanding of discounted cash flow valuations
The user has enough understanding of the business to enter sales, costs, working capital, capex and transaction assumptions
The user has a decent understanding of accounting
The user requires flexibility in the tax calculations to correctly reflect their own tax jurisdiction

When the model requires debt to be drawn down at some point in the future/forecast period (note that if debt already exists in the business then that is fine)
When there are more than three sales divisions (however there is no obligation to use all three!)
If the user requires more than one type of depreciation rate for assets
When the user wishes to model intangibles or the Investments balance in a flexible way (ie not held constant)
If the user requires more than one type of working capital assumptions for each of debtors, creditors and stock

0.0 / 5 (0 votes)

please wait...