Case 068Forecasting and scenariosHard
Taralika Cloud opens the year with Rs 400 crore of ARR, 12% gross churn, 25% expansion, Rs 120 crore of new ARR and a free cash flow margin of minus 5%. Build the ARR bridge, compute net dollar retention and the Rule of 40, and forecast next year.
1The situation
Taralika Cloud sells subscription logistics software. It starts the year with annual recurring revenue of Rs 400 crore. During the year, customers worth 12% of opening ARR cancel, and the customers that stay buy more seats and modules worth 25% of opening ARR. Sales to new customers add Rs 120 crore of ARR. Free cash flow is minus 5% of revenue.
Management expects the same churn, expansion and new ARR next year, and the same cash margin.
2Your task
Build the bridge from opening to closing ARR, compute net dollar retention, growth and the Rule of 40 score, then forecast next year and say what the forecast reveals.
Quick check
Net dollar retention is measured on the installed base only. Roughly what is it here?
Worked solution
Try it on paper, then open one step at a time.
30-second answerThe answer to give first
Closing ARR is Rs 572 crore, net dollar retention 113%, growth 43%, and a Rule of 40 score of 38. The bridge is 400 less 48 of churn plus 100 of expansion plus 120 new. Next year on the same rates ARR reaches about Rs 766 crore, but growth slows to 34% because new ARR is flat while the base grows, so the Rule of 40 score falls to about 29 unless cash margin improves.
Step 1What does the bridge look like, and what does each piece mean?
Four movements. Churn: 12% of Rs 400 crore, Rs 48 crore, walks out. Expansion: the customers who stay buy 25% more, Rs 100 crore. New: Rs 120 crore from logos signed this year. Closing ARR is 400 less 48 plus 100 plus 120, Rs 572 crore, and the installed base alone contributed a net Rs 52 crore before a single new customer was signed. Think of a gym: members who quit, members who upgrade to personal training, and new joiners. The first two are about the product; the third is about the sales team.
Step 2What are NDR and the Rule of 40, and why do investors ask for both?
Net dollar retentionRevenue from the customers you had a year ago, as a percentage of what they paid then, after churn and expansion but before new customers. is 452 over 400, 113%: last year's customers are worth 13% more this year even after the leavers. Above 100% the base grows on its own, and at 113% it would double in about 5.7 years with no new sales at all. The Rule of 40 adds growth to cash margin: 43 plus minus 5 is 38, just under the bar that investors use to say growth is being bought at an acceptable burn. Investors ask for both because NDR measures the product and the Rule of 40 measures the whole company's efficiency; a business can have a fine NDR and a terrible score if it overspends on new logos.
| 400 - 48 + 100 | opening ARR less churn plus expansion: what the installed base is worth a year later |
| 43% | ARR growth, 572 over 400 less 1, including new customers |
| -5% | free cash flow as a share of revenue |
Step 3What does next year look like on the same rates?
Apply the rates to a bigger base and the same Rs 120 crore of new sales. Churn is 12% of 572, Rs 68.6 crore; expansion 25%, Rs 143 crore; new 120. Closing ARR is about Rs 766 crore, but growth is 34%, down from 43%, because the retention engine scales with the base while new ARR is flat at 120, a smaller and smaller share of a growing company. On the same minus 5% cash margin, the Rule of 40 score drops to about 29. Management's forecast is really a statement that new logo sales must grow too, or the cash margin must improve, and the interviewer wants to hear which.
| Rs crore | This year | Next year |
|---|---|---|
| Opening ARR | 400.0 | 572.0 |
| Churn, 12% | (48.0) | (68.6) |
| Expansion, 25% | 100.0 | 143.0 |
| New ARR | 120.0 | 120.0 |
| Closing ARR | 572.0 | 766.4 |
| Growth | 43% | 34% |
| Rule of 40 at -5% FCF | 38 | 29 |
Step 4Which lever matters most over three years?
Churn, because it compounds. Hold new ARR at Rs 120 crore and run three years: at 12% churn ARR reaches about Rs 986 crore, at 18% about Rs 876 crore, and at 8% about Rs 1,065 crore. Six points of churn on the plan are worth Rs 110 crore of ARR by year 3, roughly a full year of new logo sales. That is why a SaaS operator fixes retention before adding sales headcount: a point of churn saved applies to every customer ever won, while a new salesperson adds a fixed amount once. Say the limit: expansion of 25% is high and tends to fall as the base matures, so a forecast that holds it flat for three years is optimistic.
Where candidates lose it
The common miss is including new customers in net dollar retention and reporting 143%. NDR is about the customers you already had; mixing in new logos hides whether the product keeps its users.
The second is forecasting next year's growth at 43% again. New ARR of Rs 120 crore is 30% of a Rs 400 crore base and 21% of a Rs 572 crore base; unless new sales scale, growth decelerates mechanically.
What the interviewer asks next
- New ARR must grow at what rate to hold growth at 43% next year?
- How does gross margin change the way you read the minus 5% cash margin?
- A competitor reports NDR of 125% with 20% churn. What does that tell you about its customers?
Asked at Insight Partners, Generalist, New York, 2021 (Wall Street Oasis): Went through a difficult SaaS case, asked some tech-specific questions
Company names and figures are illustrative.
