Syntha Lab RU

Store payback: ramp-up and rent holiday by month

Builds the store’s cash flow by month: revenue rises from a starting level to the plan over a given number of months, no rent is paid in the rent holiday. Shows the payback month, the cumulative result, the depth of the dip and the payback without the ramp-up.

Full cost of the premises and display For whom: Chain owners and expansion directors.

Calculate on your data →

At a glance

What question does it answer?
In how many months a new store pays back with a ramp-up.
What data is needed?
Fit-out, equipment and opening stock.
How to read the result?
Investment is 11.5 m, profit at plan 0.93 m a month. The quick estimate gives 12.4 months; with the ramp-up payback is 18.5 months. At month 12 the cumulative result is minus 6.01 m, at month 24 plus 5.15 m; the depth of the dip is minus 11.51 m. Example on the default values: Total investment: RUB 11.5 million; Store profit a month at plan: RUB 930,000; Payback with the ramp-up: 18.5 months; Payback without the ramp-up: 12.4 months. The figures are illustrative: enter your own to see your result.

Why and how to reason

A store does not bring planned profit from day one: revenue grows for months while investments (fit-out, equipment, starting stock) are made at once. The simple estimate “investment ÷ profit at plan” understates the term. The calculation builds a monthly cash flow. Revenue of the month = plan × (start + (1 − start) × (month − 1) ÷ (months to plan − 1)), not above plan: in the example start is 40% of plan, reaching plan in 9 months. Profit of the month = revenue × (margin − variable) − fixed + rent in holidays (rent holidays when rent is not paid). Investment 8.5 + 3 million = 11.5 million. Profit at plan 6 million × (45% − 2%) − 1.65 million = 930 thousand a month; the quick estimate gives 11.5 ÷ 0.93 = 12.4 months while with the ramp-up payback is 18.5 months. Cumulative result at month 12 is −6.0 million, at month 24 +5.15 million, depth of the pit −11.5 million.

When to use it

It is useful before opening a point, in rent negotiations and when choosing between options. It suits retail and a brand with retail. It does not replace a discounted assessment: for that use the investment project calculation (NPV, IRR). Assumptions: the calculation is before taxes and without depreciation; return of the deposit to the landlord and leftover stock at closing are not shown; ramp-up to plan is linear.

How to read the result

Look at three numbers: payback with ramp-up, depth of the pit and loss-making months. The depth of the pit is the amount of money you must have before turning positive: −11.5 million means more than the investment itself is needed because in the first months revenue does not cover fixed costs. If payback is longer than your term, look at the levers: rent holidays, less starting stock, faster ramp-up. Compare the quick estimate and the ramp-up calculation: a six-month gap is an understatement. The decision: whether to open the point, on what rent terms, with what money in reserve.

Common mistakes

Taking first-month revenue equal to plan. Not including starting stock in investment. Treating rent holidays as free: later the rent may be higher. Forgetting seasonality: opening before a low season lengthens payback. Using for a new point a planned margin equal to mature stores: at the start discounts are higher.

What data is needed?

  • Fit-out, equipment and opening stock.
  • Plan revenue, margin, variable and fixed costs.
  • Months to the plan, first-month revenue, rent holiday.

Inputs

FieldUnitValue in the exampleMeaning
Fit-out and equipment₽8,500,000All pre-opening investment excl. VAT (if you deduct it).
Investment in opening stock₽3,000,000Stock returns as cash when sold but is frozen meanwhile: it is included in the payback.
Payback period you accept (optional)months—Optional. You set it from your plan and lease term; if empty, the payback card has no color.
Plan revenue a month excl. VAT₽6,000,000Excl. VAT (if you pay VAT and deduct it). Confirm your regime and rate with an accountant.
Gross margin%45Margin share in revenue excl. VAT.
Variable costs%2Acquiring, commissions and other turnover-based costs.
Fixed costs a month₽1,650,000Rent, utilities, staff and other: see “Full cost of the premises”.
Months to reach the planmonths9In that month revenue reaches the plan level. An example: enter your own data, there is no single standard in Russia.
First-month revenue%40As a percentage of the plan. An example: enter your own data, there is no single standard in Russia.
Rent holidaymonths2Months at the start without fixed rent: under the lease.
Fixed rent a month₽650,000The part of fixed costs not paid in the holiday.

How it is calculated

StepFormula
Month revenueplan × (start + (1 − start) × (month − 1) ÷ (ramp months − 1)), not above the plan
Month profitrevenue × (margin − variable) − fixed + rent in the holiday
Paybackthe month in which the cumulative result (less the investment) crosses zero

Worked numbers

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

Total investment
11.5 m ₽
Store profit a month at plan
930,000 ₽Revenue × (margin − variable) − fixed, before taxes and depreciation.
Payback with the ramp-up
18.5 monthsThe month when the cumulative result turns zero (interpolated within the month).
Payback without the ramp-up
12.4 monthsInvestment ÷ profit at plan: how the quick estimate counts.
Cumulative result at month 12
−6.01 m ₽
Cumulative result at month 24
5.15 m ₽
Depth of the cumulative dip
−11.5 m ₽The lowest cumulative result over 60 months: how much money is needed, including the investment.
Loss-making months out of 60
2 mo.Months when the store’s profit is negative: while revenue climbs to the plan.

Months: revenue, profit, cumulative result

MonthRevenueProfitCumulative result
12.4 m ₽32,000 ₽−11.5 m ₽
33.3 m ₽−231,000 ₽−11.5 m ₽
64.65 m ₽349,500 ₽−11 m ₽
96 m ₽930,000 ₽−8.8 m ₽
126 m ₽930,000 ₽−6.01 m ₽
186 m ₽930,000 ₽−426,000 ₽
246 m ₽930,000 ₽5.15 m ₽
366 m ₽930,000 ₽16.3 m ₽

With the ramp-up the payback is 18.5 months against 12.4 on the quick estimate: the quick estimate understates the term and the need for money.

The calculation is before taxes and without depreciation; the return of the landlord’s deposit and the stock left on closing are not shown. For discounted evaluation use “Investment project: NPV, IRR and payback”.

Empty = 0 in the fields: Payback period you accept (optional). If that is not the case, fill them in: the result will change.

Nuances and limits

  • The quick estimate understates the term and the need for money.
  • Taxes and depreciation are not included.

Terms used

Calculate on your data →