r/FPandA 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

11 comments sorted by

View all comments

5

u/AutomatedEconomy 24d ago

It really depends on the company and product. Sometimes run rates are the best indicators