Expense forecasting
Expense forecasting is estimating a business's future expenses from expected activity, staffing and prices. A budget sets spending targets; an expense forecast predicts what the business is likely to spend and changes as new information arrives.
How it works
Start with recent actual spending and forecast each category by month:
- Fixed expenses: use known commitments, such as rent under a lease.
- Payroll: calculate costs from planned headcount, start dates, salaries and benefits.
- Variable expenses: tie costs to activity, such as shipping expense per order.
Each month, replace estimates with actuals and revise the months ahead. Investigate differences rather than copying last month's forecast forward.
For a startup, connect the expense forecast to a cash forecast. Expenses and cash payments are not interchangeable: annual software paid upfront, for example, affects cash differently from a monthly accounting expense.
A planned hire creates a $5,000 cash shortfall
A startup begins January with $120,000 in cash and expects no incoming cash during the quarter. Every listed expense is paid in the month shown, with no other cash movements. A new hire adds $8,000 per month starting in March.
| Expense | January | February | March |
|---|---|---|---|
| Payroll and benefits | $30,000 | $30,000 | $38,000 |
| Rent and software | $5,000 | $5,000 | $5,000 |
| Marketing | $2,000 | $4,000 | $6,000 |
| Total | $37,000 | $39,000 | $49,000 |
Quarterly expenses total $37,000 + $39,000 + $49,000 = $125,000. Against $120,000 of starting cash, that leaves a $5,000 shortfall.
Moving the hire's start date to April reduces quarterly expenses to $117,000 and leaves $3,000. The forecast exposes a decision before the company commits to the hire.
Questions people ask
How do you forecast expenses in Excel?
Put months across columns and expense categories down rows. Keep assumptions, such as headcount and monthly compensation, in separate cells. Calculate payroll by multiplying those inputs, then use SUM for monthly totals. Add actual-spending and variance rows so you can see which assumptions were wrong.
