Unit Economics Worksheet Template: Free Download

Most operators know their headline unit economics numbers. Fewer have a structured way to calculate them consistently, segment them correctly, and turn the results into decisions. A worksheet without decision rules is just arithmetic. This template is built to close that gap — covering the five sections that matter, with formulas, benchmarks, and the action thresholds that tell you what to do with the numbers.

The structure applies to SaaS and DTC brands, though the specific inputs, benchmarks, and levers differ between them. Where they diverge, this guide calls it out explicitly.

Why Most Unit Economics Analyses Miss the Point

The standard unit economics calculation — LTV divided by CAC — gives you a ratio that is only meaningful if both inputs are calculated correctly. Most teams get at least one wrong.

The most common error in SaaS is quoting blended LTV and CAC as single numbers without breaking them by segment, channel, or cohort. A company running both a product-led growth (PLG) motion and an enterprise sales motion might have a $200 PLG CAC and a $50,000 enterprise CAC. Blending them produces a number that describes neither motion accurately. The enterprise team thinks they are efficient because the blended number looks good. The PLG team gets less investment than their economics deserve.

For DTC, the equivalent error is confusing blended CAC with new customer CAC. Brands with strong repeat purchase rates show a misleadingly low blended CAC because returning customers carry no acquisition cost. When ad costs rise, blended CAC barely moves — until the new customer cohort collapses and the brand suddenly has no pipeline of future repeat buyers.

The worksheet below is structured to force segment-level inputs before any aggregation. That single discipline catches more problems than any single metric.

The Unit Economics Worksheet: All Five Sections

Section 1: Customer Acquisition Costs

CAC is the total cost to acquire one paying customer. Total cost means everything — not just ad spend. Include salaries and commissions for sales and marketing headcount, marketing technology, events, content production, and agency fees. Divide by the number of new customers acquired in the same period.

For SaaS, calculate CAC separately for each GTM motion: inbound, outbound, and self-serve PLG if applicable. Mixing them produces numbers that guide no decision. For DTC, separate new customer CAC from blended CAC, and track new customer CAC by channel. DTC median blended CAC reached $130 to $156 per customer in 2026 across most categories — but new customer CAC in paid social is typically 40% to 80% higher than that blended figure.

Benchmark targets: For B2B SaaS, CAC payback under 12 months is healthy; the median is 15 to 18 months. For DTC, CAC payback under 3 months is cash-efficient; 3 to 6 months is normal for growth-stage brands.

Section 2: Retention and Expansion Metrics

Retention is where unit economics either compound or collapse. A SaaS business with 95% monthly retention behaves completely differently from one with 90% monthly retention — the second loses roughly half its customer base every year. For DTC, retention determines whether the initial acquisition cost is amortized across 1.2 orders or 4.8 orders.

Benchmark targets: Top-quartile SaaS achieves NRR of 120% to 130%. Median B2B SaaS is around 105% to 110%. Monthly gross retention above 92% (annual above 80%) is the minimum threshold for viable unit economics — below this, growth becomes a capital-intensive struggle. For DTC, repeat purchase rates above 30% within 12 months indicate a healthy retention curve.

Section 3: Lifetime Value Calculation

LTV is the net present value of all revenue a customer generates over their relationship with your business. The simplified formula is ARPU × gross margin ÷ monthly churn rate. The expanded version — which includes expansion — is more accurate for SaaS businesses where NRR exceeds 100%.

Always include gross margin in the LTV calculation. A SaaS product with 60% gross margin (due to high infrastructure or support costs) has an LTV 25% lower than the same ARR at 80% gross margin. Omitting margin is the single most common LTV error, and it tends to make unit economics look better than they are.

Benchmark targets: SaaS median LTV:CAC is 3.2:1 to 3.6:1; top quartile is 4:1 to 6:1. DTC healthy range is 3:1 to 5:1. Below 2:1 in either model, acquisition is likely destroying value.

Section 4: Margin Analysis

Margin analysis translates unit economics from ratio metrics into dollars. It tells you how much each customer actually contributes to covering fixed costs and generating profit, which is what matters when making pricing, headcount, and acquisition budget decisions.

Benchmark targets: SaaS gross margin above 70% is optimal; 75% to 80% is typical at scale. The median overall gross margin for private SaaS companies is 77%. For DTC, CM3 (contribution margin after marketing) above 20% is healthy; beauty and supplements typically reach 18% to 35%. Below 10% CM3, the brand is scaling losses.

Teams using Fairview track margin at the segment, channel, and product level in a single view — making it possible to see where margin is compressing before it shows up in aggregate numbers.

Section 5: Action Thresholds

This is the section most worksheets omit. Numbers without decision rules produce analysis without action. For each key metric, define the threshold that triggers a specific response — before you need to use it.

Operators who set thresholds in advance make faster decisions when numbers deteriorate. The threshold removes the need to re-analyze the data from scratch when a problem appears — the decision rule is already documented.

How to Use the Worksheet: SaaS vs. DTC Differences

The worksheet structure is the same for both SaaS and DTC, but the economic mechanics differ in ways that change which metrics matter most.

In SaaS, the primary LTV lever is expansion revenue. A SaaS business where customers expand at 15% annually has fundamentally better unit economics than an identical business with no expansion — even if initial contracts are the same size. The expansion rate feeds directly into LTV, and NRR above 100% means you can grow revenue without acquiring a single new customer. The worksheet should track expansion cohorts separately to isolate whether expansion is happening in specific segments or products.

In DTC, the primary LTV lever is repeat purchase frequency. A customer who buys three times in 12 months is worth 3x a one-time buyer, and carries no additional acquisition cost. Subscription products and loyalty programs shift the repeat purchase curve materially. The worksheet should track purchase frequency by acquisition cohort — not just overall average — because cohort-level frequency shows whether retention is improving or degrading over time.

The segment-level discipline matters in both models. Customers acquired via different channels behave differently at scale. For SaaS, companies that tailor pricing and positioning to specific customer segments report 25% higher revenue growth than those using generic tiers. For DTC, organic and email-acquired customers typically show 40% to 60% higher LTV:CAC ratios than paid social cohorts — because acquisition cost was lower, not because they spend more.

Connecting Unit Economics to Pricing and Expansion Decisions

Unit economics are not a reporting exercise. They are an input to three specific decisions: where to acquire, how to price, and whether to expand.

Acquisition decisions: Channel-level CAC tells you where to invest and where to cut. If one channel shows LTV:CAC of 5:1 and another shows 1.8:1, the decision is clear — unless the higher-CAC channel reaches segments the lower-CAC channel cannot. Segment-level unit economics make that comparison meaningful.

Pricing decisions: If your margin analysis shows that Customer Segment A costs $3.40/month to serve and Customer Segment B costs $14.80/month, charging them the same price is a subsidy. Segment-level cost-to-serve data directly informs pricing tiers. Teams that use their unit economics to build pricing structure outperform teams that price based on competitive benchmarks alone.

Expansion decisions: Before entering a new market, segment, or channel, model the unit economics at target scale. The assumption that economics will mirror current performance is usually wrong — expansion introduces new CAC structures, lower pricing power in competitive markets, and cost-to-serve differences. The worksheet becomes a pre-expansion stress test: what LTV:CAC does this segment need at breakeven, and is that realistic?

Fairview surfaces unit economics by segment automatically as data flows in — so operators see CAC, LTV, margin, and payback by channel and cohort without manual worksheet maintenance. But regardless of the tool, the underlying structure in this worksheet is what turns raw numbers into decisions.

Review Cadence and Maintenance

A unit economics worksheet that is reviewed once per quarter is a lagging indicator document. The goal is a cadence where you catch problems early enough to fix them cheaply.

Run the full worksheet monthly. This includes all five sections, all segments, and a comparison against the prior month and prior quarter. Monthly review is enough time for trends to become statistically meaningful without being so delayed that problems compound.

Review the three highest-leverage metrics — LTV:CAC, NRR (or repeat purchase rate for DTC), and CAC payback — weekly. These move fast enough that monthly review misses inflection points. A CAC spike that starts in week 1 of the month is actionable by week 2. Discovered at month-end, it has already consumed four weeks of budget at the wrong rate.

When any metric triggers an action threshold, that triggers an investigation, not just a note. Document the probable cause, the planned response, and the checkpoint date to re-evaluate. The worksheet is the record — not just of current economics, but of how and why decisions were made.