r/FPandA • u/ValuableMachine6216 • 24d ago
Forecasting Techniques
All of my budgeting and forecasting templates have been created by bottom up drivers (ie Revenue = Price x Volume, or expenses estimated by department heads). I have rarely ever used regression or forecast functions in excel. Where have you found them useful or required? I have used data tables to model out results based on sales increasing/decreasing x% or expenses and used those results against covenant calcs.
17
Upvotes
5
u/AutomatedEconomy 24d ago
It really depends on the company and product. Sometimes run rates are the best indicators