|Distribution, FMCG, General Excel Financial Models, Manufacturing|
|5-year financial projections, Budgeting, CFO, Dashboard, DCF Model, Financial Feasibility, Financial Planning, Financial Projections, Forecasting|
This is long term budget covering the time of year or 12-period showing performance analysis versus previous year in addition to 4 estimate financial year.
This model is very simple to use by simply recording your revenue, cost of goods and your expenses under different categories in the green cells as per the instruction showing in the sheet under the name of Index
Once the data is completed, this model shows the following below
-3 forecasting financial statements
-P&L strategic plan for 3 years
-P&L summary showing the variance of budget versus previous years
-P&L common size
-Ration analysis and explanation
This model is mainly for FMCG and heavy machinery dealership, however, it is very easy to customize it for your business by only amend the revenue and expenses sheets.