Case 078Forecasting and modellingCore

Build next year's revenue for a quick commerce company growing from 400 to 700 dark stores, where each new store takes six months to reach 1,500 orders a day.

The situation

Nimbora Quick Commerce delivers groceries in about fifteen minutes from small warehouses called dark stores. It ends this year with 400 stores, all mature, and plans to end next year with 700. A mature store handles 1,500 orders a day at an average order value of Rs 520, and Nimbora keeps 18% of gross order value as revenue through commissions, delivery fees and ad income.

New stores open evenly, 25 at the start of each month. A new store ramps in a straight line: a sixth of mature orders in its first month, two sixths in its second, and full volume from its sixth month.

Your task

What is next year's revenue, how far off are the two shortcut answers, and what run rate does Nimbora exit the year with?

Quick check

Which is closest to next year's revenue?

Worked solution

Try it on paper, then open one step at a time.

30-second answerThe answer to give first

About Rs 2,598 crore. Each mature store earns Rs 5.12 crore a year: 1,500 orders a day, Rs 520 a basket, 18% kept. The 400 existing stores give Rs 2,050 crore. The 300 new ones, opened monthly and ramping over six months, add the equivalent of 107 mature stores, Rs 548 crore. Counting 700 mature stores would overstate revenue by 38%.

Step 1What is the unit you build from?

Build one mature store first, then count how many mature-store equivalents Nimbora runs. A mature dark store earns Rs 5.12 crore of revenue a year: 1,500 orders a day for 365 days is 5.5 lakh orders, at Rs 520 a basket that is Rs 28.5 crore of gross order valueThe total value of the baskets customers pay for, before the platform keeps its share. Revenue is the platform share, not this figure., and Nimbora keeps 18% of it. The 400 existing stores are mature all year, so they give Rs 2,050 crore on their own.

Step 2Why can a new store not simply be counted as a store?

Think of a new tea stall at a bus stand. On day one only passers-by stop; regulars take months to form. A dark store is the same: delivery radius, rider density and repeat customers all have to build. Store additions become revenue only at the pace of the ramp, so a store opened in month seven contributes far less than half a year of mature sales. Under a six-month straight-line ramp, a store's first six months deliver 3.5 months of mature orders.

A new dark store earns its way to maturity over six months5001,0001,5000250M1500M2750M31,000M41,250M51,500M61,500M71,500M81,500M9Month since the store openedOrders per store per dayRamp: 3.5 mature months out of the first 6Mature: 1,500 a day
A new Nimbora dark store handles 250 orders a day in its first month and climbs by 250 a month to 1,500 at month six, so its first half-year delivers the equivalent of 3.5 mature months.
Step 3How do you add up 300 stores opening at different times?

Take each monthly cohort of 25 stores and add up its ramp for the months it is open. The January cohort is open twelve months and delivers 9.5 mature months; the July cohort is open six months and delivers 3.5; the December cohort delivers one sixth of a month. Summed across all twelve cohorts, 300 new stores deliver 106.9 mature store-years, barely a third of their count. That is Rs 548 crore of revenue.

MethodStore-years countedRevenue, Rs croreVersus the cohort build
700 mature stores all year700.03,587+38%
Average of 550 mature stores550.02,819+8%
Cohort build with ramp506.92,598
Counting 700 mature stores overstates Nimbora's revenue by 38% and even the average store count overstates it by 8%, because both ignore that new stores spend their first months below maturity.
Revenue by month: the new-store layer grows slowly under the 700-store lineM1173M2M3M4M5M6208M7M8M9M10M11M12272700 mature stores: 299 a month, the naive forecast400 existing stores, 171 a monthnew stores, rampingRs crore of revenue per month, next year
Nimbora's 400 existing stores give about Rs 171 crore a month all year, while the new-store layer grows only to Rs 101 crore by month 12, so the year never reaches the Rs 299 crore a month that 700 mature stores would earn.
Step 4What does the exit run rate tell you about the year after?

In month 12, the new cohorts together run at 237.5 mature-store equivalents, so Nimbora exits the year at about 637.5 mature stores, an annualised Rs 3,267 crore. The ramp that holds this year back is growth already banked for next year: even with no new openings, the following year gets the remaining ramp of the late cohorts for free. Say that out loud, because it is the answer to why quick commerce revenue keeps compounding after openings slow.

Then name the assumption most likely to be wrong. New stores in newer, thinner neighbourhoods may never reach 1,500 orders a day, and new stores near old ones can pull orders from them. A careful model keeps a separate maturity level for each vintage and checks it against the orders Nimbora discloses.

Where candidates lose it

The fast wrong answer multiplies 700 stores by mature revenue and lands near Rs 3,587 crore, 38% too high. Slightly better candidates use the average store count and still miss by 8% because they forget the ramp.

The other loss is treating revenue as gross order value. Nimbora keeps 18%; a forecast of Rs 14,433 crore of revenue is really its gross order value.

What the interviewer asks next

  • Openings are back-loaded, 100 in the last quarter. What happens to this year's revenue and next year's?
  • New-store maturity drops to 1,200 orders a day. Rework the new-store revenue.
  • Which disclosure would you ask Nimbora for to test the ramp assumption?

Company names and figures are illustrative.