Case 053Diligence and red flagsCore
Interviewer-led case: Kodvik Dev Tools' ARR growth fell from 60% to 25% in a year. Ask for the data you need, find the driver, and say what you would ask next.
1The situation
Kodvik Dev Tools sells a code testing tool to software teams on annual subscriptions. The interviewer opens with one fact: ARR growth has slowed from 60% last year to 25% this year. Every other number comes only when you ask for it.
If you ask for the ARR bridge, you get it. Last year opening ARR was Rs 25 crore, new-logo ARR Rs 8 crore, expansion Rs 9 crore and churn Rs 2 crore. This year opening ARR was Rs 40 crore, new-logo ARR again Rs 8 crore, expansion Rs 5 crore and churn Rs 3 crore.
2Your task
What drove the slowdown, and what is the next question you would ask the company?
Quick check
Which part of the bridge did most of the damage?
Worked solution
Try it on paper, then open one step at a time.
30-second answerThe answer to give first
The slowdown is mostly existing customers expanding less, not a sales problem. Of the 35 points lost, expansion accounts for 23.5: net revenue retention fell from 128% to 105%. New-logo sales held at Rs 8 crore, which costs 12 points only because the base grew. The churn rate improved slightly. The next question goes to existing customers: which cohorts stopped adding seats or usage, and why.
Step 1What do you ask for first when growth slows?
Ask for the ARR bridgeA walk from opening to closing annual recurring revenue: plus new customers, plus expansion from existing customers, minus churn and downgrades., because growth is only the sum of its parts. A shop whose sales growth slows could be finding fewer new shoppers or selling less to regulars; the till total alone cannot tell you which. In an interviewer-led case, the first question you ask is scored as heavily as the answer, and a request for the bridge shows you know growth has components.
Step 2Why compare the lines in points of growth rather than in rupees?
Rupees mislead here: churn rose by half in rupees, which sounds alarming. Dividing each line by opening ARR turns the bridge into points of growth, and on that basis the churn rate improved from 8% to 7.5%. New logos were 32 points last year and 20 this year, only because Rs 8 crore sits on Rs 40 crore instead of Rs 25 crore. Expansion collapsed from 36 points to 12.5. Net revenue retention, opening ARR plus expansion minus churn over opening ARR, fell from 128% to 105%.
| Rs crore | Last year | Points | This year | Points |
|---|---|---|---|---|
| Opening ARR | 25 | 40 | ||
| New logos | 8 | 32.0 | 8 | 20.0 |
| Expansion | 9 | 36.0 | 5 | 12.5 |
| Churn | (2) | (8.0) | (3) | (7.5) |
| Closing ARR | 40 | 60.0 | 50 | 25.0 |
| Net revenue retention | 128% | 105% |
Step 3Is flat new-logo ARR a problem too?
Yes, but a smaller and more predictable one. To keep new logos at 32 points on a Rs 40 crore base, Kodvik would have needed Rs 12.8 crore of new-logo ARR, 60% more than it booked. Every growing company faces this: the same sales team adds fewer points each year unless it grows too. Had expansion held at 36% of the base, it would have added Rs 14.4 crore instead of Rs 5 crore, and growth would have been about 49%. The expansion miss is the surprise; the base effect was arithmetic you could have forecast a year ago.
Step 4What is the next question you ask?
Go to the customers who stopped expanding. Ask for expansion by cohort and by customer size: did last year's big expanders hit a ceiling, or did a pricing change stop seats from being added? A code testing tool usually expands as customers hire engineers, so a hiring freeze among tech customers would show up exactly here and could reverse. A competitor winning the second team inside each account would not reverse. Those two explanations lead to different valuations, and the interviewer wants to see you ask for the data that separates them.
Where candidates lose it
Most candidates see growth fall and blame sales, then spend the case on pipeline and quota. New-logo rupees were flat, so the sales team did the same job as last year; the story is in existing customers.
The second trap is reading churn in rupees and calling it the problem. As a share of the base it improved; say that, and you show the interviewer you normalise before you judge.
What the interviewer asks next
- Kodvik's expansion comes 70% from seat growth. What would you ask about its customers' hiring?
- How would you forecast next year's growth from this bridge?
- What would the bridge look like if a large customer had downgraded rather than churned?
Asked at Insight Partners, Generalist, New York, 2021 (Wall Street Oasis): back to back 30 minute cases, interview led, about tech
Company names and figures are illustrative.
