Build the Model: SaaS Unit Economics
Finance
medium35 min0 submissionsScenario
Northwind Analytics sells a single B2B plan. The board wants a one-page unit-economics view before it approves next year's sales budget.
You have the raw inputs below. Build the derived lines in the workspace — the ones the board actually argues about: CAC, LTV, the ratio between them, payback, and what each customer contributes.
Round to two decimals. Give percentages as numbers (18.5, not 0.185).
Supporting data
notesAll figures are trailing twelve months, in INR.
inputs
| input | value |
|---|---|
| Sales & marketing spend (year) | 48000000 |
| New customers acquired (year) | 320 |
| Average contract value (ACV) | 360000 |
| Gross margin | 78% |
| Annual logo churn | 12% |
Your task
Fill every cell in the workspace. Each is checked against a 2% tolerance band, so rounding differences are fine — a wrong formula is not.
Work down the sheet: row 2 depends on row 1, row 3 on row 2.
Ready to move forward? Up next: Solstice Travel: What Should This Project Have to Beat?Next question
Hint
Reveal suggested structure
Unit economics: CAC, gross-margin LTV, LTV/CAC, CAC payback.