Demand Estimation for a New Store in Nashik
A retail chain is evaluating a new store in Nashik. Market research gives the following: the catchment has 42,000 households; average monthly spend on the product category is ₹1,450 per household; the chain's nearest competitor holds an estimated 35% share; the new store is expected to capture 8% of category spend in year one and 12% by year three. Store fixed costs are ₹9.6 lakh a year, variable cost is 62% of sales, and the initial investment is ₹55 lakh with a required payback of five years. A second analyst argues the 8% capture is optimistic because competitor share is already high and household spend may fall 5% in a slowdown. The chain's hurdle rate is 14%.
1. Estimate year-one and year-three sales, contribution and payback, and judge whether the store meets the five-year payback test.
Read the worked answer
Market size. 42,000 households × ₹1,450 = ₹6,09,00,000 per month, i.e. ₹7.308 crore a year.
Year one at 8%: sales = ₹7.308 crore × 0.08 = ₹58.46 lakh. Contribution at 38% (100% − 62%) = ₹22.22 lakh. Less fixed costs ₹9.6 lakh = ₹12.62 lakh before tax and depreciation.
Year three at 12%: sales = ₹87.70 lakh. Contribution = ₹33.33 lakh. Less fixed costs = ₹23.73 lakh.
Payback. Using year-one cash contribution of ₹22.22 lakh against ₹55 lakh investment gives about 2.5 years if contribution alone is counted, but fixed costs must be deducted, giving ₹12.62 lakh a year, which implies about 4.4 years. On a straight-line average of years one to three (roughly ₹18 lakh a year), payback is about three years. Either way the store is within the five-year test, but the margin for error is modest.
Judgement. The project passes, but only comfortably. The 14% hurdle rate must be applied to discounted cash flows, and early-year cash is thin relative to the ₹55 lakh outlay, so the decision is sensitive to the capture rate assumption.
2. Test the analyst's pessimistic scenario (capture of 6% and a 5% fall in household spend) and advise the chain.
Read the worked answer
Revised market size. Household spend falls 5% to ₹1,377.50 per month. Market = 42,000 × 1,377.50 = ₹5.7855 crore a year.
At 6% capture: sales = ₹34.71 lakh. Contribution at 38% = ₹13.19 lakh. Less fixed costs ₹9.6 lakh = ₹3.59 lakh before tax and depreciation.
Implication. Annual cash generation of ₹3.59 lakh against ₹55 lakh investment gives a payback of over 15 years, far outside the five-year test and far below a 14% return. The store would destroy value in this scenario.
Advice. The decision hinges on the capture rate, which is the least reliable input. The chain should: (1) validate capture with a pilot, a pop-up or a nearby comparable store rather than relying on a single estimate; (2) negotiate rent and fit-out so fixed costs fall below ₹9.6 lakh, since fixed costs are what turn a small sales shortfall into a loss; (3) stage the investment, opening a smaller format first; (4) set a decision gate - proceed only if early trading shows capture above 7%. The high existing competitor share of 35% supports the analyst's caution, so the chain should not commit the full ₹55 lakh on the base case alone.