CUSTOMER LIFETIME VALUE WORKSHEET
Space Office | 30 October 2026

DEFINITIONS
Decision to inform:
Value basis: revenue / gross profit / defined contribution
Customer population and identity rule:
Eligible order and refund treatment:
Revenue basis, excluded taxes/shipping, currency:
Observation window and reporting timezone:
Source system, owner, extraction date:

OBSERVED INPUTS
Eligible revenue:
Eligible orders:
Customers in original cohort:
AOV = revenue / orders:
Frequency per year = orders / customers (same annual scope):
Observed revenue per customer = revenue / customers:
Reconcile AOV x frequency with revenue / customers:

ASSUMPTIONS
Expected relationship years and evidence:
Gross margin definition and decimal:
Costs already included / excluded:
Revenue estimate = AOV x annual frequency x years:
Margin-adjusted estimate = revenue estimate x margin:
Low/base/high scenarios (not probability intervals):

FICTIONAL CHECK
12000 / 300 = 40; 300 / 100 = 3; 12000 / 100 = 120
40 x 3 x 2 = 240 revenue; 240 x .55 = 132 gross profit
1.5 years = 180 / 99; 2.5 years = 300 / 165
4000 / 100 = 40 CAC; 132 / 40 = 3.3 (not a benchmark)
First-year gross profit = 120 x .55 = 66; less 40 CAC = 26 before excluded costs

RETENTION TEST
Customer problem and evidence:
Proposed output, eligible group, comparison, allocation:
Early usability measure / later purchase measure / observation window:
Incremental contribution and test costs:
Confounders, evidence limits, and stop criteria:
Approved inputs and access:
Gold/Oxygen preparation and Hydrogen review:
Human owner, final approval, next review date:

All example figures are fictional. Forecasts are not observed outcomes. Customer communications and account access need their own approved scope.