Unit Economics & Break-Even Modeler

Author

SectorPrompts.com

How to read this report. Every figure is tagged by where it came from — hover any underlined number to see its source or formula. A full breakdown of every value is in the appendix.

This report contains 27 figures you provided, 27 calculated figures (27 of them independently re-checked), and 3 stated assumptions.

3 of the 57 figures in this report are our estimates, not your numbers. They are marked est. and carry an amber underline. To make this report entirely your own, give us: Sensitivity step.

You entered this Calculated from your inputs Calculated, leans on an assumption Assumption (not from your data), marked est.

Executive Summary

Fiscal 2025 delivered profitable, subscription-anchored growth — but the margin stack leaves almost no room for error at the GAAP level. Reported net sales grew 6.2% year-over-year (52-week vs. 53-week comparison; the company’s own normalized 52-week figure is 8.3%), reaching $12,600M. GAAP net income was $222.8M (1.8% margin), against which adjusted EBITDA of $719.2M at 5.7% (non-GAAP, excluding share-based compensation and depreciation) is the number management and investors will anchor on. Free cash flow of $562.4M (non-GAAP) was $452.5M in the prior year — the single most operationally meaningful improvement in the period.

  • Situation → Insight → Action — Autoship is the structural moat: Autoship customer sales reached 83.3% of net sales (up from 79.2%), creating a recurring-revenue base that directly insulates gross margin. Gross margin expanded 29.2% → 29.8% — a consequence of the mix shift, not a price event. The board should treat Autoship penetration rate as a leading indicator of margin trajectory, not a vanity metric.

  • Situation → Insight → Action — Customer growth is slowing, spend is not: Net customer additions were 813,000 (21.327M active vs. 20.514M prior year, 4% growth) against $824.9M in advertising and marketing. The modeled CAC proxy — advertising spend divided by net additions — is approximately $1,015 per net customer added (see methodology caveat in §3). This ratio’s denominator uses net, not gross, additions; the true cost of acquiring a customer is higher because churned customers consume spend before a single net add registers. Management must disclose gross acquisition volume or this figure will remain structurally understated.

  • Situation → Insight → Action — SG&A is improving but still consumes over a fifth of revenue: SG&A as a percent of net sales fell from 21.5% to 21.2%, a directionally correct move. Advertising held roughly flat at 6.5% of net sales vs. 6.8% prior year, implying no material efficiency gain in paid acquisition — revenue grew, but so did the absolute spend line.

  • Situation → Insight → Action — The company is GAAP-profitable and well above break-even: At the modeled monthly active-customer volume of 1,777,250, the business generates a monthly operating surplus versus its fixed-cost base. Break-even in the margin-structure model occurs at approximately 1,121,586 monthly customers. The 1.8% GAAP net margin reflects $311.2M of share-based compensation and related taxes flowing through the P&L — remove that and the business is substantially more cash-generative than the headline income figure suggests.

  • Situation → Insight → Action — Free cash flow is the recovery metric to watch: FCF of $562.4M (non-GAAP) improved from $452.5M in the prior year, an increase of $109.9M. For a mature subscription-anchored retailer, FCF conversion relative to adjusted EBITDA is the clearest signal of capital efficiency. The board should set an explicit FCF/adjusted EBITDA conversion target as the primary financial KPI for FY26.

1. Unit Economics Snapshot

Note

Key insight: Calculated reconciliations match published figures to the dollar — confirming data integrity. Non-GAAP items are explicitly flagged; GAAP net margin of 1.8% is depressed primarily by $311.2M in share-based compensation.

2. CAC Proxy — Acquisition Cost Analysis

Note

Key insight: The modeled CAC proxy of ~$1,015 per net customer addition is a lower-bound estimate — the company does not publish gross additions or churn, so LTV, LTV:CAC, and payback period cannot be computed from public data.

Methodology disclosure: The CAC proxy below is a modeled estimate, not a company-reported metric. It is computed as advertising and marketing expense divided by net customer additions ($824.9M ÷ 813,000 net adds = ~$1,015). Using net additions structurally understates the true acquisition cost: every churned customer must be replaced at full cost before a single net addition registers. The company does not report gross customer additions or churn rate. LTV, LTV:CAC ratio, and payback period are not computable from published data — no retention assumption is disclosed, and inventing one would produce a fabricated ratio. These metrics are omitted.

Data availability note: The three grey bars represent metrics the board should request management to publish: gross customer additions (enabling true CAC), a retention rate (enabling LTV), and a stated payback period. Without these, the investor relations narrative on customer economics rests on a single lower-bound proxy.

3. Break-Even Analysis

Note

Key insight: At 1,777,250 monthly active customers served, the business operates well above the modeled break-even of 1,121,586 — the margin structure is sound, but the thin 1.8% GAAP net margin means any cost shock at scale lands directly on the bottom line.

Framing: The company is GAAP-profitable. Break-even is presented here as a margin-structure analysis — where does revenue cover fixed costs plus variable costs per customer? The model treats the annualized SG&A net of advertising ($1.85B annually, approximately $154.1M monthly) as the fixed-cost base, and uses advertising spend per active customer as the variable selling cost layered on top of COGS. All figures are monthly (active customers served per month, derived from the annual base). This is a modeled construct — the company does not publish a per-unit cost structure at this granularity.

Reading this chart: Revenue (blue) and Total Cost (red) cross at approximately 1,121,586 monthly customers. Current modeled volume of approximately 1,777,250 sits well to the right — the gap between revenue and total cost at that point represents the monthly operating surplus in the model. The contribution margin line (green dotted) shows cumulative coverage of fixed costs as volume scales; it turns positive immediately (every customer contributes above variable cost) and covers the full fixed-cost base at the break-even crossing. The 1.8% GAAP net margin is thin in absolute percentage terms, but the business is structurally above break-even at current scale.

4. Sensitivity Analysis — Advertising Cost Scenarios

Note

Key insight: A 20%est. adverse move in advertising cost per customer pushes break-even up to 1,188,480 monthly customers — still well below current volume, confirming structural headroom, but tightening the buffer meaningfully.

Scenario methodology: Three scenarios stress the advertising-cost-per-customer variable (the key driver of contribution margin) by ±20%est.. Fixed costs and price are held constant. LTV, LTV:CAC, and payback period are omitted in all scenarios — they require a retention rate the company does not publish.

Interpreting the range: Break-even moves from 1,061,822 (advertising efficiency scenario) to 1,188,480 (pressure scenario) — a spread of approximately 127,000est. monthly customers. Against a current modeled volume of 1,777,250, all three scenarios sit comfortably below current scale. The real risk is not break-even proximity — it is that advertising efficiency deterioration at scale translates directly into EBITDA margin compression, not break-even breach.

5. Key Recommendations

1. Establish gross customer acquisition reporting as a board-level disclosure requirement. The CFO should require management to present gross additions and gross churn alongside net additions starting with Q1 FY26 earnings. This moves the modeled CAC proxy of ~$1,015 (per net add, a known understatement) toward a defensible figure, and gives the board the data needed to assess whether the $824.9M advertising budget is allocated efficiently or is subsidizing churn replacement. Without gross acquisition data, investor relations cannot credibly defend the customer economics narrative to institutional holders.

2. Set a formal FCF-to-adjusted-EBITDA conversion ratio target for FY26. The CFO should propose a conversion ratio floor (FCF ÷ adjusted EBITDA) to the board for adoption as the primary capital efficiency KPI at the next board meeting. FCF improved from $452.5M to $562.4M while adjusted EBITDA was $719.2M — the conversion story is positive but not yet formalized as a management commitment. A stated target anchors investor expectations and disciplines capital allocation decisions between now and year-end.

3. Defend Autoship penetration rate as the primary top-line margin lever. The Head of Product and the CMO should jointly own a target to hold Autoship at or above 83.3% of net sales through FY26. Autoship moved from 79.2% to 83.3% — that mix shift is the primary driver of gross margin expansion from 29.2% to 29.8%. Any advertising strategy that prioritizes one-time buyers over Autoship enrollees is buying revenue at the cost of the margin structure the business depends on.

4. Resolve the non-GAAP / GAAP presentation gap for the IR narrative. The CFO should prepare a single-page GAAP-to-non-GAAP bridge for board packets and earnings supplements, making explicit that the $311.2M in share-based compensation and related taxes is the primary reason GAAP net income of $222.8M (1.8% margin) understates cash generation against adjusted EBITDA of $719.2M (5.7% margin, non-GAAP). For a publicly traded company under SEC review, the absence of a clean reconciliation in the board package creates unnecessary regulatory and reputational exposure.

5. Monitor advertising efficiency ratio — not just absolute spend — as customer growth slows. The CMO and CFO should jointly track advertising spend as a percent of net sales on a trailing-twelve-month basis, flagging any increase above the FY25 ratio of 6.5% as a leading indicator of deteriorating returns. Active customer growth of 4% at $824.9M in spend suggests the marginal cost of adding customers is rising in a maturing market — spending through that trend without a commensurate NSPC improvement (currently 2.2%) destroys contribution margin without growing the base.

Appendix — Where every number came from

Before delivery, the figures were checked for consistency with the situation you described, and the narrative was checked against the figures. Anything that couldn’t be verified is labeled as an assumption above.

Value Amount Source
net_sales_fy25 $12,600 net sales $12.60 billion FY25
active_customers_fy25 21.327 active customers 21.327 million FY25
active_customers_fy24 20.514 active customers 20.514 million FY24
published_nspc_fy25 $591 net sales per active customer $591 FY25
published_nspc_fy24 $578 net sales per active customer $578 FY24
autoship_pct_fy25 83.3% 83.3 percent of net sales FY25
autoship_pct_fy24 79.2% 79.2 percent of net sales FY24
gross_profit_fy25 $3,754 gross profit $3,753.9 million FY25
gross_margin_pct_fy25 29.8% gross margin 29.8 percent FY25
gross_margin_pct_fy24 29.2% gross margin 29.2 percent FY24
sga_fy25 $2,675 SG&A $2,674.7 million FY25
sga_fy24 $2,551 SG&A $2,551.0 million FY24
adv_mkt_fy25 $824.9 advertising and marketing $824.9M FY25
adv_mkt_fy24 $804.1 advertising and marketing $804.1M FY24
net_income_fy25 $222.8 net income $222.8 million FY25
net_margin_pct_fy25 1.8% net margin 1.8 percent FY25
sbc_incl_taxes_fy25 $311.2 (matches a value you provided)
adj_ebitda_fy25 $719.2 adjusted EBITDA $719.2 million FY25
adj_ebitda_margin_pct 5.7% adjusted EBITDA margin 5.7 percent FY25
sbc_fy25 $297.9 (matches a value you provided)
sbc_fy24 $306.4 (matches a value you provided)
fcf_fy25 $562.4 free cash flow $562.4 million FY25
fcf_fy24 $452.5 free cash flow $452.5 million FY24
reported_sales_growth_pct 6.2% headline +6.2 percent net sales growth
normalized_growth_pct 8.3% normalized 52-week figure +8.3 percent
active_cust_growth_pct 4% active customers up 4.0 percent FY25
nspc_growth_pct 2.2% NSPC up 2.2 percent FY25
Value Amount Basis
net_sales_fy24 $11,860 declared as an input but could not be traced to a value you supplied
autoship_sales_fy25 $10,500 declared as an input but could not be traced to a value you supplied
sensitivity_step 0.2 illustrative +/-20% adv cost stress
Value Amount Grounding
gross_margin 29.8% ✓ re-checked from your inputs
calc_nspc_fy25 590.8 ✓ re-checked from your inputs
calc_autoship_pct 83.3% leans on: autoship_sales_fy25
calc_gross_margin_pct 29.8% ✓ re-checked from your inputs
sga_pct_fy25 21.2% ✓ re-checked from your inputs
sga_pct_fy24 21.5% leans on: net_sales_fy24
adv_pct_fy25 6.5% ✓ re-checked from your inputs
adv_pct_fy24 6.8% leans on: net_sales_fy24
net_cust_additions 813,000 ✓ re-checked from your inputs
cac_proxy_modeled $1,015 ✓ re-checked from your inputs
price_per_unit $591 ✓ re-checked from your inputs
cogs_per_unit 414.9 ✓ re-checked from your inputs
variable_cost_per_unit $38.679 ✓ re-checked from your inputs
annual_fixed_costs $1.85B ✓ re-checked from your inputs
monthly_fixed_costs $154.1M ✓ re-checked from your inputs
current_volume 1,777,250 ✓ re-checked from your inputs
contribution_per_unit 137.4 ✓ re-checked from your inputs
breakeven_volume 1,121,586 ✓ re-checked from your inputs
monthly_revenue_current $1.05B ✓ re-checked from your inputs
monthly_total_cost_current $960.2M ✓ re-checked from your inputs
monthly_operating_surplus 90,114,049 ✓ re-checked from your inputs
variable_cost_low $30.943 leans on: sensitivity_step
variable_cost_high $46.414 leans on: sensitivity_step
breakeven_low 1,061,822 leans on: sensitivity_step
breakeven_mid 1,121,586 ✓ re-checked from your inputs
breakeven_high 1,188,480 leans on: sensitivity_step
vol_max 2,243,172 ✓ re-checked from your inputs

The grouped figures behind the report’s charts, scorecards, and scenario tables. Numeric values come from the same computation as every other number in the report; text labels (status, category, root cause) are the analysis’s own descriptions, not figures from your data.

breakeven_df

Volume Revenue TotalCost ContributionMargin AtCurrentVolume
0 0 154150000 0
57517 33992683 180237554 7905130
115034 67985367 206325107 15810259
172552 101978050 232412661 23715389
230069 135970734 258500215 31620519
287586 169963417 284587769 39525648
345103 203956100 310675322 47430778
402621 237948784 336762876 55335908
460138 271941467 362850430 63241037
517655 305934150 388937984 71146167
575172 339926834 415025537 79051296
632690 373919517 441113091 86956426
690207 407912201 467200645 94861556
747724 441904884 493288199 102766685
805241 475897567 519375752 110671815
862758 509890251 545463306 118576945
920276 543882934 571550860 126482074
977793 577875618 597638414 134387204
1035310 611868301 623725967 142292334
1092827 645860984 649813521 150197463
1150345 679853668 675901075 158102593
1207862 713846351 701988628 166007723
1265379 747839034 728076182 173912852
1322896 781831718 754163736 181817982
1380414 815824401 780251290 189723112
1437931 849817085 806338843 197628241
1495448 883809768 832426397 205533371
1552965 917802451 858513951 213438500
1610482 951795135 884601505 221343630
1668000 985787818 910689058 229248760
1725517 1019780502 936776612 237153889
1783034 1053773185 962864166 245059019 Current Volume
1840551 1087765868 988951720 252964149
1898069 1121758552 1015039273 260869278
1955586 1155751235 1041126827 268774408
2013103 1189743918 1067214381 276679538
2070620 1223736602 1093301935 284584667
2128138 1257729285 1119389488 292489797
2185655 1291721969 1145477042 300394927
2243172 1325714652 1171564596 308300056

economics_df

Metric Value Target Status
Net Sales FY25 ($M) 12600 Reported
Net Sales FY24 ($M) 11860 Illustrative
Reported Sales Growth (52w vs 53w, %) 6.2 8.3 Unequal periods — 52w vs 53w
Normalized Sales Growth (52w vs 52w, %) 8.3 8.3 Normalized 52w vs 52w
Active Customers FY25 (M) 21.327 Reported
Active Customers FY24 (M) 20.514 Prior Year
Active Customer Growth (%) 4 Growth
Net Customer Additions (K) 813 Net Additions
Net Sales Per Active Customer FY25 ($) — calc 590.8 591 Reconciled — matches published
Net Sales Per Active Customer FY25 ($) — published 591 591 Published
Net Sales Per Active Customer FY24 ($) 578 578 Prior Year
NSPC Growth (%) 2.2 Growth
Autoship Sales FY25 ($B) 10.5 Reported
Autoship % of Net Sales — calc 83.3 83.3 Reconciled — matches published
Autoship % of Net Sales — published 83.3 83.3 Published
Autoship % of Net Sales FY24 79.2 Prior Year
Gross Profit FY25 ($M) 3753.9 Reported
Gross Margin FY25 (%) — calc 29.8 29.8 Reconciled — matches published
Gross Margin FY25 (%) — published 29.8 29.8 Published
Gross Margin FY24 (%) 29.2 Prior Year
SG&A FY25 ($M) 2674.7 Reported
SG&A % of Net Sales FY25 21.2 Calculated
SG&A % of Net Sales FY24 21.5 Calculated
Advertising & Marketing FY25 ($M) 824.9 Reported
Advertising & Marketing % of Net Sales FY25 6.5 Calculated
Advertising & Marketing % of Net Sales FY24 6.8 Calculated
Net Income FY25 ($M) — GAAP 222.8 GAAP
Net Margin FY25 (%) — GAAP 1.8 GAAP
Adjusted EBITDA FY25 ($M) — non-GAAP 719.2 Non-GAAP: excludes SBC, D&A
Adjusted EBITDA Margin FY25 (%) — non-GAAP 5.7 Non-GAAP
SBC + Related Taxes FY25 ($M) 311.2 Included in GAAP net income
SBC Expense FY25 ($M) 297.9 Non-GAAP exclusion
SBC Expense FY24 ($M) 306.4 Prior Year
Free Cash Flow FY25 ($M) — non-GAAP 562.4 Non-GAAP
Free Cash Flow FY24 ($M) — non-GAAP 452.5 Non-GAAP Prior Year

ltvcac_df

Metric Value
CAC Proxy — Modeled (adv spend / net adds, $) 1015
CAC Basis Note Net adds understate gross CAC; churn replacement not visible
LTV Not computable — no published churn or retention rate
LTV:CAC Ratio Not computable — LTV requires retention assumption not disclosed
Payback Period Not computable — depends on LTV

sensitivity_df

Scenario BreakEvenVolume PaybackMonths LTV_CAC_Ratio
Adv cost -20% (efficiency gain) 1061822 Not computable — no LTV Not computable — no retention data
Base case (FY25 actuals) 1121586 Not computable — no LTV Not computable — no retention data
Adv cost +20% (pressure scenario) 1188480 Not computable — no LTV Not computable — no retention data

How each number was derived

Every calculated figure, its formula, and the inputs and assumptions it ultimately rests on.

Value Amount Formula Traces back to
gross_margin 29.8% gross_margin_pct_fy25/100 gross_margin_pct_fy25 (input)
calc_nspc_fy25 590.8 (net_sales_fy25 * 1e+06)/(active_customers_fy25 * 1e+06) net_sales_fy25 (input), active_customers_fy25 (input)
calc_autoship_pct 83.3% (autoship_sales_fy25/net_sales_fy25) * 100 net_sales_fy25 (input), autoship_sales_fy25 (assumption)
calc_gross_margin_pct 29.8% (gross_profit_fy25/net_sales_fy25) * 100 gross_profit_fy25 (input), net_sales_fy25 (input)
sga_pct_fy25 21.2% (sga_fy25/net_sales_fy25) * 100 sga_fy25 (input), net_sales_fy25 (input)
sga_pct_fy24 21.5% (sga_fy24/net_sales_fy24) * 100 sga_fy24 (input), net_sales_fy24 (assumption)
adv_pct_fy25 6.5% (adv_mkt_fy25/net_sales_fy25) * 100 adv_mkt_fy25 (input), net_sales_fy25 (input)
adv_pct_fy24 6.8% (adv_mkt_fy24/net_sales_fy24) * 100 adv_mkt_fy24 (input), net_sales_fy24 (assumption)
net_cust_additions 813,000 (active_customers_fy25 - active_customers_fy24) * 1e+06 active_customers_fy25 (input), active_customers_fy24 (input)
cac_proxy_modeled $1,015 (adv_mkt_fy25 * 1e+06)/net_cust_additions adv_mkt_fy25 (input), active_customers_fy25 (input), active_customers_fy24 (input)
price_per_unit $591 published_nspc_fy25 published_nspc_fy25 (input)
cogs_per_unit 414.9 price_per_unit * (1 - gross_margin) published_nspc_fy25 (input), gross_margin_pct_fy25 (input)
variable_cost_per_unit $38.679 (adv_mkt_fy25 * 1e+06)/(active_customers_fy25 * 1e+06) adv_mkt_fy25 (input), active_customers_fy25 (input)
annual_fixed_costs $1.85B (sga_fy25 - adv_mkt_fy25) * 1e+06 sga_fy25 (input), adv_mkt_fy25 (input)
monthly_fixed_costs $154.1M annual_fixed_costs/12 sga_fy25 (input), adv_mkt_fy25 (input)
current_volume 1,777,250 (active_customers_fy25 * 1e+06)/12 active_customers_fy25 (input)
contribution_per_unit 137.4 price_per_unit * gross_margin - variable_cost_per_unit published_nspc_fy25 (input), gross_margin_pct_fy25 (input), adv_mkt_fy25 (input), active_customers_fy25 (input)
breakeven_volume 1,121,586 ceiling(monthly_fixed_costs/contribution_per_unit) sga_fy25 (input), adv_mkt_fy25 (input), published_nspc_fy25 (input), gross_margin_pct_fy25 (input), active_customers_fy25 (input)
monthly_revenue_current $1.05B current_volume * price_per_unit active_customers_fy25 (input), published_nspc_fy25 (input)
monthly_total_cost_current $960.2M monthly_fixed_costs + current_volume * (price_per_unit * (1 - gross_margin) + variable_cost_per_unit) sga_fy25 (input), adv_mkt_fy25 (input), active_customers_fy25 (input), published_nspc_fy25 (input), gross_margin_pct_fy25 (input)
monthly_operating_surplus 90,114,049 monthly_revenue_current - monthly_total_cost_current active_customers_fy25 (input), published_nspc_fy25 (input), sga_fy25 (input), adv_mkt_fy25 (input), gross_margin_pct_fy25 (input)
variable_cost_low $30.943 variable_cost_per_unit * (1 - sensitivity_step) adv_mkt_fy25 (input), active_customers_fy25 (input), sensitivity_step (assumption)
variable_cost_high $46.414 variable_cost_per_unit * (1 + sensitivity_step) adv_mkt_fy25 (input), active_customers_fy25 (input), sensitivity_step (assumption)
breakeven_low 1,061,822 ceiling(monthly_fixed_costs/(price_per_unit * gross_margin - variable_cost_low)) sga_fy25 (input), adv_mkt_fy25 (input), published_nspc_fy25 (input), gross_margin_pct_fy25 (input), active_customers_fy25 (input), sensitivity_step (assumption)
breakeven_mid 1,121,586 breakeven_volume sga_fy25 (input), adv_mkt_fy25 (input), published_nspc_fy25 (input), gross_margin_pct_fy25 (input), active_customers_fy25 (input)
breakeven_high 1,188,480 ceiling(monthly_fixed_costs/(price_per_unit * gross_margin - variable_cost_high)) sga_fy25 (input), adv_mkt_fy25 (input), published_nspc_fy25 (input), gross_margin_pct_fy25 (input), active_customers_fy25 (input), sensitivity_step (assumption)
vol_max 2,243,172 max(2 * breakeven_volume, current_volume * 1.05) sga_fy25 (input), adv_mkt_fy25 (input), published_nspc_fy25 (input), gross_margin_pct_fy25 (input), active_customers_fy25 (input)

Prepared with SectorPrompts