Hi everyone,
We have our large production model, with 100s of modules that are currently feeding our P&L. This houses all of our actual, forecast, and budget data. The rest of the year we will be budgeting in this model for 2023 and 2024, but we want a "Long Term Model" (LTM) where we plan for 2025-2028.
Ideally the LTM would house the numbers for 2023 and 2024 as well, but be at a much higher level.
For example, in our current production model, we may have a structure in our P&L such as:
- Revenue
- Chocolate
- Fruit
- Pies
- Cakes
- Doughnuts
In our LTM we would want the "Revenue" but none of the individual revenue drivers that are feeding the revenue, and hypothetically 2025-2028 would just be a forecasted growth rate applied to the previous year.
For example, 2025 would = 2024 Revenue * 5%.
Does anyone have any ideas on the best way to go about this or any experience within their company as to how they have handled long term planning/forecasting?
Thanks in advance!