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).
| input | value |
|---|---|
| Sales & marketing spend (year) | 48000000 |
| New customers acquired (year) | 320 |
| Average contract value (ACV) | 360000 |
| Gross margin | 78% |
| Annual logo churn | 12% |
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.
Unit economics: CAC, gross-margin LTV, LTV/CAC, CAC payback.