▲ 5 r/FPandA
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.
u/ValuableMachine6216 — 18 hours ago