Case 012Systematic research and dataCore
A card-spending panel covers about 3% of Kalyra Mart's sales. Panel spending is up 14% this quarter, and the panel skews to younger urban shoppers. How do you turn the panel into a revenue estimate, and what biases do you correct for?
1The situation
Kalyra Mart, a supermarket chain, reported revenue of Rs 1,000 crore in the same quarter last year. Your fund buys an anonymised card-spending panel that captured about Rs 30 crore of spending at Kalyra in that quarter, roughly 3% of its sales. This quarter the panel shows Rs 34.2 crore, up 14%. The market consensus expects revenue growth of 12%.
The panel's users are mostly younger shoppers in large cities, where Kalyra's newest stores are. You also have eight past quarters of panel growth alongside Kalyra's reported growth.
2Your task
How do you turn the panel into a revenue estimate, which biases do you correct for, and how confident is the number you give the portfolio manager?
Quick check
The panel says +14% and consensus says +12%. What is the first thing to do before calling a beat?
Worked solution
Try it on paper, then open one step at a time.
30-second answerThe answer to give first
Calibrate the panel on history before scaling it: on eight past quarters, 14% panel growth maps to about 9.8% reported growth, roughly Rs 1,098 crore, below the 12% consensus. The naive scale-up says Rs 1,140 crore and a beat. The panel overstates growth because its young urban users shop more at new stores and pay more often by card. The estimate carries a band of about Rs 1,079 to 1,118 crore.
Step 1Why is the panel's 14% not Kalyra's growth rate?
A poll of voters taken only outside college campuses is still data, but it is data about students. A card panel measures the shoppers who are in the panel, paying the way the panel sees, so its growth equals the company's growth only if those shoppers behave like all of Kalyra's customers. Three biases push this panel above the truth: its users are young and urban, where Kalyra's new stores are opening; more shoppers each year switch from cash to cards, which looks like growth in card data; and the panel's own membership changes as users join and leave.
Step 2How do you correct for the bias?
Let history tell you how the panel translates. Put panel growth against reported growth for the past eight quarters and fit a line. Here reported growth has been about 1.8 points plus 0.58 times panel growth, so the panel overstates growth, and a 14% panel reading implies about 9.8%. The scatter of past quarters around the line, about 1.0 points, is your error, which gives a range of about two errors either side. Where possible, go further: reweight the panel by city and age to match Kalyra's store footprint, and hold the panel to users present in both years so that panel churn does not masquerade as growth.
| g_panel | the panel's growth over the same quarter last year, 14% |
| a, b | the intercept and slope fitted on eight past quarters |
| g-hat | the estimated reported growth |
Step 3What do you tell the portfolio manager, and with what caveats?
Lead with the number and its range, then the call. The panel points to growth of about 10%, and the whole two-error range sits below the 12% consensus, so the data leans towards a miss rather than a beat. Then the caveats, briefly: eight quarters is a short history to fit a line on, a new store programme can change the relationship, and the alternative dataData from outside company filings, such as card spending, web traffic or satellite images, used to estimate results before they are reported. vendor's panel may itself have changed. A good analyst also checks whether consensus already moved on the same data, because if every fund buys this panel, the edge is in the correction, not the raw number.
Where candidates lose it
The trap is reading the panel's growth as the company's. Candidates see 14% against a 12% consensus and call a beat, when the panel's history shows it overstates Kalyra's growth by several points.
The second is scaling the level instead of the growth. Dividing Rs 34.2 crore by 3% assumes the panel's share of sales is exactly stable, which it never is; working from growth and calibrating against the past removes most of that error.
What the interviewer asks next
- Kalyra opens 40 new stores in small towns this quarter. How does that change your correction?
- How would you test whether the panel's relationship to reported revenue has broken?
- A second vendor's panel says +9%. How do you combine the two?
Company names and figures are illustrative.
