How to read this
Cells are referenced by R<row>/<column><row> notation. R9/E9 means column E, row 9. R38–R45 is a block of inputs spanning those rows. Multi-column ranges like D39–J39 mean the same row across several columns. Types: INPUT = user-edited, FORMULA = calculated, DROPDOWN = select from list.
Unit Economics Tool — Sheet Map
Sheets (7)
README, License, Disclaimer, Unit Economics, Model Comparison, Additional Tools, Changelog
Unit Economics (B1:BA1001) — Single sheet, all-in-one
| Row |
Label |
Type |
Default |
| R7/D7 |
Show/hide notes |
DROPDOWN |
"show" |
| Revenues |
|
|
|
| R10/D10 |
Revenue per unit (recurring) |
INPUT ($) |
$25 |
| R11/D11 |
Revenue per unit (transaction) |
INPUT ($) |
$0 |
| R12/D12 |
Revenue per unit (one-time) |
INPUT ($) |
$0 |
| Cost of Sales |
|
|
|
| R15/D15 |
COGS % (recurring) |
INPUT (%) |
10% |
| R16/D16 |
COGS % (one-time) |
INPUT (%) |
0% |
| R17/D17 |
COGS % (transaction) |
INPUT (%) |
0% |
| Discounts |
|
|
|
| R20/D20 |
Discount recurring |
INPUT ($) |
$0 |
| R21/D21 |
Discount transaction |
INPUT ($) |
$0 |
| Churn & Growth |
|
|
|
| R24/D24 |
Billing period months (recurring) |
INPUT (#) |
1 |
| R25/D25 |
Churn period months |
INPUT (#) |
1 |
| R26/D26 |
% Growth in gross margin/unit (annual) |
INPUT (%) |
5% |
| R27/D27 |
% Churn per period |
INPUT (%) |
10% |
| R28/D28 |
Average customer lifetime months |
INPUT (#) |
10 |
| R31/D31 |
Months after acquisition for one-time |
INPUT (#) |
0 |
| R34/D34 |
Transaction churn period months |
INPUT (#) |
0 |
| R35/D35 |
Transaction growth % |
INPUT (%) |
0% |
| R36/D36 |
Transaction churn % |
INPUT (%) |
0% |
| R37/D37 |
Repeat transactions per year |
INPUT (#) |
0 |
| Discount Rate |
|
|
|
| R40/D40 |
Discount rate (annual) |
INPUT (%) |
10% |
| R41/D41 |
K, Recurring |
FORMULA |
0.81 |
| R42/D42 |
K, Transaction |
FORMULA |
0.9 |
| Acquisition Costs |
|
|
|
| R45/D45 |
CAC |
INPUT ($) |
$65 |
| R46/D46 |
Cost of retention (recurring) |
INPUT ($) |
$0 |
| R47/D47 |
Cost of repeat (transaction) |
INPUT ($) |
$0 |
Outputs (R49-R54)
| Row |
Label |
Type |
| R49/D49 |
LTV, Recurring |
FORMULA |
| R50/D50 |
LTV, One-time |
FORMULA |
| R51/D51 |
LTV, Transaction |
FORMULA |
| R52/D52 |
LTV (total) |
FORMULA |
| R53/D53 |
LTV / CAC |
FORMULA |
| R54/D54 |
CAC Payback months |
FORMULA |
Detail Section (R56-R1001, columns E-BA)
- 48-month per-unit cash flow projection
- Monthly: Revenue, COGS, Gross Margin, Growth adjustment, Churn adjustment, Net margin
- Cumulative: Total margin, CAC payback tracking
- Separated by Recurring, One-time, Transaction revenue types
Key characteristics
- Self-contained single sheet (no cross-sheet references)
- No time-series forecast — purely per-unit economics
- Three revenue types modeled independently: Recurring, One-time, Transaction
- Payback calculated on contribution margin, not revenue