Financial projection and forecasting model based on historical financial statements and budget

Description
This generic financial model tool allows the user to project and forecast a Company's Statement of Profit and Loss account, Statement of Financial Position (Balance Sheet), and Statement of Cash Flow. Being a generic model, it can be easily customised to fit almost any company, sector and industry. This tool will help the user to craft the financial forecast that will be a part of the business plan or annual operating plan.

The financial model consists of one-year financial projection and one-year forecast model based on historical four-year financial statements and current year budget consisting of the following:
1) Cover page
2) Input tabs
a) Historical financial statements (3-statements: Statement of Profit and Loss (P&L), Statement of Financial Position (Balance Sheet), and Statement of Cash Flow) and results and latest management account
b) Budget (based on 3-statements)
c) Input - general assumptions (such as forex, inflation rate, tax rate, etc), revenue (3 pricing scenarios: Base, High, Low) and cost driver assumptions as well depreciation and debt schedules
3) Output tab
a) One-year full financial statements projection (combination of actuals financial and latest budget)
b) One-year full financial statements forecast

The FM does not include a valuation model, financial ratio analyses nor graphical illustrations of the output.