Syntha Lab RU

Investment and store openings

Whether a new store or project pays back and under which assumptions.

For retail Result, investment and taxes

Open interactively →

About the topic

Opening a store means paying today and waiting years for the return. The topic “Investment and store openings” teaches you to assess such a decision honestly: how much money is needed at time zero, when it comes back and what the project gives given that a ruble today is worth more than a ruble in three years. It is read by the owner, the development director, the finance person and whoever asks a bank or investor for money for new points. Monthly store economics are covered in the topic “Store and chain”; here they turn into annual cash flow and are compared with the investment.

Start with the investment. It is always larger than it seems: repairs and equipment are visible to all, while the first stock, the lease deposit, pre-opening costs, staff training and operating losses in the first months are added quietly. Illustrative example: repairs RUB 8 million, equipment 4, first stock 10, lease deposit 3, a total of RUB 25 million. Then the flow: a store does not reach maturity at once, so let profit by year be 3, 6, 7, 7, 7 million RUB. Simple payback: cumulative profit 3, 9, 16, 23, 30; 25 million comes back in the fifth year, more precisely in 4.3 years. It looks tolerable.

Now account for the cost of money. If your money costs 18% a year (the discount rate), the flow of future years “weighs” less. Discounted flows: 3 / 1.18 = 2.54; 6 / 1.18² = 4.31; 7 / 1.18³ = 4.26; 7 / 1.18⁴ = 3.61; 7 / 1.18⁵ = 3.06. The sum is RUB 17.78 million. NPV (net present value) = 17.78 − 25 = −RUB 7.2 million. In this form the project does not repay the investment given the cost of capital. It would become good if revenue per meter were higher, rent lower or the life longer (the example does not include stock recovery and residual value; they should be added). IRR (internal rate of return) is the rate at which NPV is zero; comparing it with the cost of capital shows the project’s margin of safety.

Where does the rate come from? It is the weighted average cost of capital (WACC): equity of 60% at 22% and debt of 40% at 16% with the tax shield (12% after tax) gives 0.6 x 22 + 0.4 x 12 = 18%. There is no single norm, you set the rate, with a risk premium.

Two more things. Cannibalization: a new store with revenue of RUB 9.6 million a month, 25% of which is taken from neighboring stores of the chain, gives the chain a net increase of 7.2 million, not 9.6. And a stress check: take revenue 20–30% below plan.

Traps: leaving stock and taxes out of the flow, taking a rate without a risk premium, planning mature revenue from the first month and signing a lease shorter than the payback period.

Key ideas

Total investment

Hidden items move the payback period. Add pre-opening costs of RUB 2 million, training 1 and first-month losses 1.5: investment is 29.5 instead of 25. Cumulative profit by the fourth year is 23, the remaining 6.5 takes 6.5 / 7 = about 0.9 of a year. Payback comes out at 4.9 years instead of 4.3: almost eight months of difference from items that were not in the budget.

Simple payback and its blind spot

A payback of 4.3 years ignores that later money is cheaper than earlier money and says nothing about what happens after. A project with fast payback and a short lease can lose to a long one.

NPV and the discount rate

Find the rate at which NPV becomes zero: about 5.8% (at 5% NPV is +RUB 0.6 million, at 8% already −1.6). This is the IRR of the flow. The cost of capital of 18% is three times higher, and the argument “15 or 18%” changes nothing: the project lacks flow, or the investment must be reduced.

WACC, ROIC and economic profit

More debt lowers WACC only on paper. At 60% debt and the same rates 0.4 x 22 + 0.6 x 12 = 16%. But the rates do not stay the same: the bank makes credit dearer and owners demand more for risk, so the real benefit is smaller than calculated. The capital structure is checked together with headroom on debt, not by the formula alone.

Cannibalization

Cannibalization has a limit. At a 55% margin and store costs of RUB 3.2 million a month, a net increase of 3.2 / 0.55 = about 5.8 million is needed. Of the 9.6 million revenue of the store no more than 1 − 5.8 / 9.6 = about 39% can be “taken” from neighbors. At 25% there is headroom, at 45% the chain as a whole loses although the store itself looks profitable.

How to work through it

  1. Collect the full investment: repairs, equipment, stock, deposit, pre-opening costs.
  2. Build the point’s monthly economics and the ramp-up curve.
  3. Convert to annual cash flow accounting for tax and the change in stock.
  4. Set the discount rate: cost of capital plus a risk premium.
  5. Calculate NPV, IRR, simple and discounted payback.
  6. Subtract cannibalization and estimate the chain’s net growth.
  7. Test a scenario: revenue 20–30% lower, rent higher.
  8. Compare the lease term with the payback period and decide on renewal.

Where to start

First store economics for monthly profit and investment, then the investment project for the appraisal by year; to stress it take revenue 20–30% below plan. Calculations of the topic in order: “Investment project: NPV, IRR and payback”, “Cannibalization on a store opening: the chain’s net gain”, “WACC: cost of capital, ROIC against WACC and economic profit”. See also (their primary topic is another one): “Store economics”, “Lease under FSBU 25: liability, right of use and moving rent below EBITDA”.

Calculations in this topic

  • Investment project: NPV, IRR and payback

    Appraises a project from its cash flows: opening a store, launching a collection, buying equipment. Calculates net present value, internal rate of return and payback.

    Whether the project pays back with the time value of money and what its return is.

  • Cannibalization on a store opening: the chain’s net gain

    Compares the sales of neighboring stores before and after a new store opens with an adjustment for the growth of control stores, calculates the neighbors’ loss, the cannibalization rate, the net sales gain and the new store’s contribution with and without the loss.

    How much of a new store’s sales came from the chain and whether the chain keeps a contribution after that.

  • WACC: cost of capital, ROIC against WACC and economic profit

    Calculates the weighted average cost of capital from the shares, the cost of equity and debt after tax, then compares it with ROIC and finds economic profit (EVA); the table shows how WACC and EVA change at another debt share.

    What the company’s capital costs, whether the business earns more than that cost and how much economic profit it creates.

  • Store economics

    From traffic and conversion to store profit: revenue, break-even, rent share and payback of the investment.

    Whether the store will make a profit, at what traffic and how fast the investment pays back.

  • Lease under FSBU 25: liability, right of use and moving rent below EBITDA

    Computes for a premises lease the present value of payments (the liability), the right-of-use asset, interest and depreciation by year and shows how much EBITDA grows with the same cash flow because the rent moves from operating costs into depreciation and interest. Needed by a retailer when opening a store, by a brand with retail and in a talk with a bank about covenants.

    What liability and right of use will appear on the balance sheet, how EBITDA and profit change by year and how much rent moves below EBITDA.

Self-check questions

  • Does the investment include first stock, deposit and pre-opening costs?
  • Does revenue ramp along a curve, not mature at once?
  • Are taxes and changes in stock included in the flow?
  • Does the rate include a risk premium and is it justified?
  • Are both simple payback and NPV calculated?
  • Is cannibalization subtracted from the chain’s growth, not only from the point’s revenue?
  • Does the project withstand revenue 20–30% below plan?
  • Is the lease not shorter than payback, or is there a renewal plan?
  • Are the format and category accounted for (footwear, children’s, accessories)?

Knowledge check

Multiple-choice questions. The correct answer and the explanation follow each question.

  1. The NPV of a project at a 15% discount rate is −RUB 2 million. What does this mean? (A conventional flow: first the investment, then the inflows.)

    • A. The project will lose RUB 2 million on the sum of flows
    • B. The payback period is longer than 15 years
    • C. The project IRR is below 15%: it earns less than the rate requires
    • D. The rate must be raised to 17%

    Correct answer: C. The project IRR is below 15%: it earns less than the rate requires. A NPV below zero means that inflows brought to today money do not cover the investment at the required rate: the project own return (IRR) is below 15%. The undiscounted sum of flows may still be positive, so “a loss of 2 million” is wrong. The payback period is not directly tied to the rate. The rate must not be changed to fit the result: it is set by the cost of capital and risk.

  2. An investment of RUB 10 million today, then RUB 4 million at the end of each of three years, discount rate 10%. What is the NPV?

    • A. +RUB 2.00 million
    • B. −RUB 0.05 million
    • C. −RUB 0.98 million
    • D. +RUB 0.05 million

    Correct answer: B. −RUB 0.05 million. Discounted flows: 4 / 1.1 + 4 / 1.21 + 4 / 1.331 = 3.64 + 3.31 + 3.01 ≈ RUB 9.95 million. NPV = 9.95 − 10 ≈ −RUB 0.05 million: the sum of flows of 12 million looks profitable (+2), but with the price of time the project falls just short. +2.00 is the undiscounted sum. −0.98 comes from discounting all three flows as a third-year flow (12 / 1.331 = 9.02). +0.05 is a lost sign.

  3. Investment per the estimate is RUB 12 million, but another RUB 3 million was left out of the estimate (pre-opening costs and stock). Store profit by year: RUB 3, 5, 6 and 6 million. What is the simple payback period with the full investment?

    • A. 2.5 years
    • B. 2.7 years
    • C. 3.0 years
    • D. 3.2 years

    Correct answer: D. 3.2 years. Investment 12 + 3 = RUB 15 million. Cumulative profit: 3, 8, 14, 20. By the end of year three RUB 1 million is still missing, and it accumulates in 1 / 6 of a year: the period is 3 + 0.17 ≈ 3.2 years. 2.7 years (2 + 4 / 6) is the period per the estimate without the 3 million. 2.5 years comes from dividing 15 by the mature profit of 6 a year, ignoring the weaker first years. 3.0 years drops the fractional part, but 14 million over three years does not yet cover 15.

  4. The company capital is 70% equity costing 20% and 30% debt at 14%. The corporate income tax is 25% (check the rate with your accountant). What is the WACC?

    • A. 17.15%
    • B. 18.2%
    • C. 17%
    • D. 14.0%

    Correct answer: A. 17.15%. Debt after tax costs 14 × (1 − 0.25) = 10.5%. WACC = 0.7 × 20 + 0.3 × 10.5 = 14 + 3.15 = 17.15%. 18.2% comes from ignoring the tax shield (0.7 × 20 + 0.3 × 14). 17% is the simple average of 20 and 14 without weights. 14.0% is the contribution of equity alone, without debt.

  5. A new store brings RUB 8 million of revenue a month, the contribution per ruble is 50%, store costs are RUB 3 million. Neighboring stores lose 35% of the new store revenue. What is the effect on the chain for a month?

    • A. +RUB 1.0 million
    • B. −RUB 1.4 million
    • C. +RUB 0.4 million
    • D. −RUB 0.4 million

    Correct answer: D. −RUB 0.4 million. The net sales increase of the chain is 8 × (1 − 0.35) = RUB 5.2 million, the contribution is 5.2 × 0.5 = 2.6 million, less costs of 3 million: −RUB 0.4 million a month. The store alone is profitable (8 × 0.5 − 3 = +1.0), and that is the trap. −1.4 is only the neighbors loss (8 × 0.35 × 0.5) without the store own profit. +0.4 is the right size with a lost sign.

Common mistakes

  • Mistake: Leaving out stock and taxes

    What it costs: Investment understated, payback looks better

    How to avoid: A full list of investment and after-tax flow.

  • Mistake: A rate without a risk premium

    What it costs: NPV overstated

    How to avoid: Cost of capital plus a premium.

  • Mistake: Mature revenue from month one

    What it costs: Payback promised too early

    How to avoid: Ramp-up curve.

  • Mistake: A lease shorter than payback

    What it costs: Investment cannot return in time

    How to avoid: Negotiate the term before signing.

  • Mistake: Ignoring cannibalization

    What it costs: The chain grows on paper, not in money

    How to avoid: Look at net growth.

Russia and the EAEU

For Russian projects the calculation is done in rubles without VAT: the VAT deduction on repairs and equipment is accounted for separately and depends on the tax regime (a simplified-system payer without VAT cannot claim it). The discount rate is tied to the Bank of Russia key rate and the cost of borrowed money: they change, take the current values and allow a margin for change. There is no single norm for a Russian retail project, so the justification of the rate should be written down.

Rent in shopping centers is fixed, a percentage of turnover or a combination, with annual indexation; the security deposit and rent-free periods for fit-out affect period zero. For leases of non-residential premises for more than a year FSBU 25/2018 applies and the right-of-use is recognized on the balance sheet: clarify with your accountant. For marked goods, time and costs for codes and scanning equipment should be provided in the first stock; cash registers work under 54-FZ and need a fiscal drive and an operator of fiscal data.

Opening in another region changes not just revenue but salaries, northern supplements and rent: take local values. Banks and investors usually ask for a calculation in several scenarios; a scenario with revenue 20–30% below plan is a good minimum.

The valuation method is the same; rates, taxes and currency differ. As a guide, check with a local accountant: corporate income tax is 20% in Belarus and Kazakhstan, 18% in Armenia, 10% in Kyrgyzstan; VAT is 20%, 16%, 20% and 12%. The discount rate must be in the project’s currency: for a project in tenge or drams take that country’s capital rates and their dynamics, not the Russian key rate. If the investment is in rubles and revenue in local currency, currency risk enters the calculation as a separate scenario. Rent in Minsk, Almaty, Yerevan and Bishkek: take the rates from landlord offers. Kyrgyzstan has garment-industry benefits to 2030 (medium reliability), but they concern production, not retail.

Categories and audiences

Apparel
Apparel needs a moderate investment in stock and fitting rooms, payback depends on ramp-up and season markdowns. Build maintained margin, not list margin, into the flow. A large format gives lower revenue per meter but a bigger receipt.
Footwear
Footwear needs a large first stock because of the size run: the share of stock in the investment is higher than in the example (10 million of 25 there), which eats NPV. Meters are needed for storage and fitting. Size returns add losses: count them in the flow.
Accessories
Accessories need little space and little stock, investment is small and payback fast, and revenue depends on traffic and location, not on area. It is often a kiosk or corner. Cannibalization is higher because goods are easy to buy in a neighboring chain store.
Kids
A children’s store is tied to season and neighborhood: schools and residential blocks nearby. A play area and wide aisles are needed, so fit-out costs more. Steady traffic from residential areas smooths the flow, while stock ages faster, so provide a reserve.
Men
The men’s format is often built around a basic core: the first stock in period zero can be set lower and payback checked on the contribution of the core. But the full “size x length” run is needed from day one, otherwise conversion will sag, and this dip must be put into the first months' flow instead of treating the store as mature.
Women
In the flow of a women’s store check returns: if revenue in the plan is gross, NPV is overstated. For example, at revenue of RUB 9.6 million and returns of 8%, net sales are 8.83 million a month. Calculate cannibalization on the overlap zone: a shopper compares several stores of the chain, and a new point takes more from neighbors than it seems.

Questions this topic answers

  • Will a new store pay back, allowing for rent, fit-out and ramp-up?
  • How much cash is needed in period zero, including the opening stock?
  • What is the project’s return (NPV, IRR) and when will the investment return, allowing for the time value of money?
  • How does payback change if sales per m² come in 20–30% below plan?

Key measures and terms

Study first

What next

Related: “Revenue, profit and costs”, “Stock and turnover”, “Taxes and VAT”.

Documents on this topic

Open interactively →