Syntha Lab RU

Annual budget by month

From last year’s revenue, growth and cost structure builds a monthly income and expense budget: revenue, gross profit, EBITDA and the months in which the business goes into the red.

Forecast and budget For whom: Finance directors and owners planning the year.

Calculate on your data →

At a glance

What question does it answer?
What revenue and EBITDA result by month and in which months the budget goes into the red.
What data is needed?
Last year’s revenue by month: it sets the seasonality.
How to read the result?
Look at EBITDA by month: red bars are months needing a cash cushion. Compare the year total with the margin goal. Then check the red months in the cash flow. Example on the default values: Growth of 8% on last year: annual revenue of RUB 107,136,000 and annual EBITDA of RUB 9,189,888. Two months (January and February) turn negative; the best month gives RUB 2,511,680 and the worst loses RUB 294,160. If there are loss-making months, check the cash cushion for them in the cash flow before the buying season starts. Next: “Monthly cash flow and cash gap” and “Sales plan by store”.

Why and how to reason

The annual budget is a calendar showing when the business earns and when it sinks. The basis is last year’s revenue by month: it carries the seasonal shape. It is multiplied by growth to get the month’s revenue. From that: gross profit (after the cost-of-sales share), minus variable expenses (a share of revenue), minus fixed ones (the same amount a month). This gives each month’s EBITDA.

The point of the calculation is the loss months. Fixed costs are the same all year round, revenue is not, so in weak months they are not covered.

Example. Last year RUB 99.2 m, growth of 8% gives RUB 107.1 m. January 6.4 x 1.08 = RUB 6.91 m; gross profit less variable expenses leaves 43.3% = RUB 2.99 m, fixed RUB 3.1 m: -RUB 0.11 m. February -RUB 0.29 m. Annual EBITDA RUB 9.19 m, best month +RUB 2.51 m.

When to use it

It is useful for yearly planning and to check whether the business will withstand weak months. It helps decide when cash is needed and where costs can be shifted. Assumption: the seasonal structure repeats. If last year had one-off events (a closure, a delayed delivery), adjust the “adjustment” column. It does not replace a cash plan: payments and profit differ in timing. Update after each quarter.

How to read the result

Look at the number of loss months and the worst month: that is the size of cash pressure. Compare the year’s EBITDA with the expected one; revenue growth of 8% gives RUB 9.19 m, while last year’s picture may have been different. Check sensitivity: if growth is 0%, how many months go negative? Decision: arrange credit terms or financing for weak months in advance, tie flexible costs to revenue and recalculate the budget every quarter. Check whether the worst month coincides with the month of largest purchases: then the cash gap is deeper than EBITDA shows. It is worth comparing the budget with “Cash flow” to see the real bottom.

Common mistakes

The usual mistakes: applying the same growth to all months despite known specifics; setting fixed costs without indexation; not accounting for a new store changing the structure; treating EBITDA as cash. Also: taking last year’s discounts as the norm. Also: making no reserve for contingencies. Also: ignoring one-off payments.

What data is needed?

  • Last year’s revenue by month: it sets the seasonality.
  • Growth, the cost of goods share, variable costs and fixed costs per month.
  • Where to take it: last year’s revenue by month from the sales report in 1C excl. VAT; growth from the development and price plan; the cost share and variable costs from last year’s management report; fixed costs from the rent, payroll and IT budgets. Enter month adjustments only for known reasons (an opening, a price change).

Inputs

FieldUnitValue in the exampleMeaning
Revenue growth versus last year%8Planned revenue growth against last year, from price, traffic and openings.
Cost of goods sold% of revenue46.7The planned cost of goods as a percentage of revenue.
Variable costs (marketing, logistics, commissions)% of revenue10Variable costs growing with sales: marketing, logistics, commissions, as a percentage of revenue.
Fixed costs per month₽3,100,000Rent, salaries, administration: the monthly amount.
Growth of fixed costs versus last year (optional)%0Indexation of rent and salaries; at 0 fixed costs are taken as entered. Optional. Empty: the field is ignored (counted as zero in sums).

How it is calculated

StepFormula
Month revenueLast year’s revenue × (1 + growth)
Gross profitRevenue × (1 − cost of goods share)
EBITDAGross profit − variable costs − fixed costs

Worked numbers

Default values from the app; in the interactive version you enter your own.

Annual revenue
107.1 m ₽Versus last year 8 %.
Annual EBITDA
9.19 m ₽ · 8.6 %
Loss-making months
2 · January, February
Best month
2.51 m ₽ · December
Worst month
−294,160 ₽ · February

Budget by month

MonthRevenueGross profitEBITDA
January6.91 m ₽3.68 m ₽−107,104 ₽
February6.48 m ₽3.45 m ₽−294,160 ₽
March7.78 m ₽4.14 m ₽267,008 ₽
April8.64 m ₽4.61 m ₽641,120 ₽
May9.07 m ₽4.84 m ₽828,176 ₽
June8.21 m ₽4.37 m ₽454,064 ₽
July7.34 m ₽3.91 m ₽79,952 ₽
August7.78 m ₽4.14 m ₽267,008 ₽
September9.5 m ₽5.07 m ₽1.02 m ₽
October10.8 m ₽5.76 m ₽1.58 m ₽
November11.7 m ₽6.22 m ₽1.95 m ₽
December13 m ₽6.91 m ₽2.51 m ₽

EBITDA is negative in 2 months: January, February. These are months that need a cash cushion: check them in the cash flow tool.

Nuances and limits

  • The cost structure is the same in all months: for a precise budget vary the assumptions by season.
  • The cost structure is the same in all months: for an accurate budget adjust months where it differs.
  • Growth applies to all revenue: do not apply it to months in which you close a store.

Terms used

Calculate on your data →