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.
Real time saver!
This is a very well constructed template.