Skip to main content
Institute of Advanced Technological and Commercial Studies

Resources

Building a forecast budget

A forecast budget turns a plan into monthly figures and shows its break-even point. It is built on explicit assumptions, which allows it to be corrected without being rebuilt when reality diverges.

Assumptions, not certainties

A solid budget separates what is decided from what is estimated. Rent is decided, sales volume is estimated: the first is set, the second is written as an assumption with its reasoning attached. That distinction makes revision simple, since you correct the assumption and the figure follows. It also makes the conversation possible with a funder, who judges the quality of the reasoning far more than the optimism of the result.

  • A volume assumption, justified by an observation or a commitment
  • A price assumption, consistent with the chosen positioning
  • Fixed costs separated from variable costs, line by line
  • A calculated break-even point, expressed in monthly volume
  • Seasonality set out, rather than a smoothed annual average

Building it in five passes

  1. 01

    Set the fixed costs

    Rent, salaries, subscriptions, insurance: they are known and give the monthly base to cover.

  2. 02

    Compute the unit margin

    Selling price minus variable cost. This is the figure that drives all the rest of the budget.

  3. 03

    Derive the break-even

    Fixed costs divided by unit margin: the monthly volume to reach becomes a tangible target.

  4. 04

    Spread over twelve months

    Seasonality and ramp-up are written month by month. An annual average hides the tight months.

  5. 05

    Track the variances

    Each month, actuals are compared with the plan and the faulty assumption is corrected. The budget becomes a steering tool.

The programmes that build this skill

The entrepreneurial track builds a launch forecast, the management programme full management control, and the short format the spreadsheet that carries both.

ProgrammeLevelDurationCredits and hoursFees
EntrepreneurshipBachelor's degree18 months60 credits · 600 h4 400 000 GNF per year
Business Management programme — Bac+3 levelBachelor's degree3 years180 credits · 1800 h4 800 000 GNF per year
Advanced ExcelShort course2 months4 credits · 40 h900 000 GNF in total

Questions from project owners

Over what period should I forecast?

Twelve months detailed monthly, then two years in annual summary. The monthly detail serves cash steering, the summary serves the conversation with a funder.

What if reality diverges from the budget?

You identify the assumption concerned and correct it, which updates everything else. That is precisely what an assumption-based budget allows: variance analysis becomes a few minutes' work each month.

How do I present a forecast to a funder?

By setting out the assumptions before the figures, with what grounds them: interviews conducted, commitments obtained, prices observed. A funder judges the soundness of the reasoning, and the entrepreneurial track has that file defended before a panel that includes funders.

Building a forecast budget — Resources | IHETC — IHETC