SaaS Unit Economics Template: Track CAC, LTV, Churn, and Payback Period
A reliable SaaS unit economics worksheet turns scattered revenue, marketing, sales, and retention data into a repeatable view of how efficiently your business acquires and keeps customers. This guide explains how to structure a SaaS unit economics template, select consistent inputs, calculate CAC, customer lifetime value, gross margin, churn, and CAC payback, and review the results each month without confusing estimates with accounting results.
Overview
Unit economics describes the revenue and costs associated with one customer, account, subscription, or other clearly defined unit of business. For a SaaS company, the unit is usually a customer or account, but the right choice depends on how the product is priced and reported. A business that sells seats may need both account-level and seat-level views. A usage-based product may also track consumption cohorts separately.
A practical SaaS unit economics template should give you four views:
- Acquisition efficiency: how much the company spends to acquire a new customer.
- Customer value: how much gross-profit contribution a customer may generate over the relationship.
- Retention: how quickly customers or recurring revenue are lost.
- Cash recovery: how long it takes to recover acquisition spend from gross profit.
These measures are decision tools rather than isolated performance scores. A falling CAC may reflect lower-quality leads, while a higher LTV estimate may simply result from an overly long observation period. The template is most useful when every metric has a defined period, owner, source, and calculation method.
For the wider operating context, connect this worksheet to a SaaS customer renewal operations playbook and documented workflows. Retention data is more actionable when account reviews, renewal risks, and escalation steps are recorded consistently.
How to estimate
Build the worksheet with one input tab, one calculation tab, and one monthly review tab. Keep raw inputs separate from formulas so you can update assumptions without overwriting historical results.
1. Customer acquisition cost
The basic customer acquisition cost formula is:
CAC = total acquisition and sales cost ÷ number of new customers acquired
Choose a period, such as a calendar month or quarter. Include the costs that your business consistently assigns to acquisition, such as campaign spend, sales compensation, demand-generation tools, and relevant contractor or event costs. Do not mix a monthly cost total with a quarterly customer count unless you intentionally use a blended period.
2. Gross margin
Gross margin shows how much recurring revenue remains after direct service delivery costs:
Gross margin = (revenue − cost of goods sold) ÷ revenue
For SaaS, direct costs may include hosting, payment processing, support costs treated as delivery costs, or other expenses your accounting policy places in cost of goods sold. The template should document what is included. Changing the definition from one month to the next makes comparisons unreliable.
3. Customer lifetime value
A simplified subscription LTV estimate can be calculated as:
LTV = average revenue per account × gross margin ÷ customer churn rate
This formula assumes churn is expressed as a decimal for the same period as the revenue measure. If average monthly revenue is used, monthly churn should be used as well. The result is an estimate, not a guarantee of future cash flow. It becomes less stable when the customer base is small, churn is volatile, or expansion and contraction revenue are significant.
4. CAC payback period
CAC payback estimates the number of periods needed to recover acquisition cost from gross profit:
CAC payback in months = CAC ÷ (average monthly revenue per account × gross margin)
Use gross profit rather than revenue in the denominator. A revenue-only payback figure can make recovery appear faster than it is because it ignores direct delivery costs.
5. Add a comparison layer
For each month, show the current result, the previous period, the internal target, and a short explanation for material changes. Add cohort fields where possible: acquisition month, plan, segment, channel, region, and customer size. Cohort analysis can reveal whether a blended metric is hiding differences between newer and older customers.
Inputs and assumptions
A useful CAC LTV calculator is less about complex formulas than disciplined inputs. Add these fields to the worksheet:
| Input | Definition | Control to add |
|---|---|---|
| Period | Month or quarter being measured | Use one reporting calendar |
| New customers | Customers that meet your acquisition definition | Exclude migrations or reactivations unless documented |
| Acquisition cost | Included marketing and sales spend | List included cost categories |
| Average revenue per account | Recurring revenue divided by active accounts | State whether discounts, refunds, and expansion are included |
| Customer churn | Customers lost during the period divided by the starting customer base | Define cancellations and pauses |
| Revenue churn | Recurring revenue lost during the period relative to starting recurring revenue | Separate contraction, cancellation, and downgrade if possible |
| Gross margin | Revenue remaining after defined direct costs | Keep the accounting treatment consistent |
Separate customer churn from revenue churn. Losing one small account and losing one large account are different commercial events, even if both count as one customer cancellation. If expansion revenue is important, add net revenue retention as a separate metric rather than forcing it into a basic LTV formula.
Also record data quality notes. Examples include an incomplete billing export, a delayed sales-cost allocation, a changed definition of an active customer, or a new pricing plan with limited history. A visible note is preferable to false precision.
Before publishing a result, check three points: the numerator and denominator cover the same period, customer counts reconcile to the billing or CRM system, and the formula has not been changed without a note. If your team is formalizing this process, a process documentation template can capture owners, sources, review steps, and exception handling.
Worked examples
Assume a monthly subscription business reports the following simplified figures for one month:
- Acquisition and sales cost: $24,000
- New customers: 60
- Average monthly revenue per account: $500
- Gross margin: 80%
- Monthly customer churn: 2.5%, expressed as 0.025
CAC: $24,000 ÷ 60 = $400 per new customer.
Estimated monthly gross profit per account: $500 × 80% = $400.
Estimated LTV: ($500 × 80%) ÷ 0.025 = $16,000.
CAC payback: $400 ÷ $400 = 1 month.
These outputs are useful only within the stated assumptions. The LTV estimate uses a simplified churn-based model and assumes the average revenue, margin, and churn relationship remains reasonably comparable. It does not account for onboarding costs, expansion timing, refunds, implementation work, sales-cycle length, or customer-specific service costs unless those are included in the inputs.
To make the example more useful for planning, create alternative cases. A conservative case might use lower gross margin and higher churn; a base case uses the current observed inputs; an upside case uses a documented improvement assumption. Label these as scenarios, not forecasts, and keep the actual monthly result separate.
When to recalculate
Recalculate the worksheet on a regular monthly close, then review trends across several periods rather than reacting to one unusual month. Update it immediately when pricing inputs change, a major plan is introduced, acquisition channels are reclassified, gross-margin treatment changes, or the definition of an active or lost customer is revised.
Revisit assumptions when the customer mix changes. A move from small self-serve accounts to larger annual contracts can affect CAC, revenue per account, sales-cycle timing, churn measurement, and payback. Likewise, a new usage-based pricing model may require a different unit definition or a cohort-based LTV method.
Use this monthly review workflow:
- Lock the reporting period and export billing, CRM, finance, and marketing inputs.
- Reconcile customer counts and recurring revenue before calculating metrics.
- Run the formulas and compare actuals with the prior period and internal targets.
- Review channel, segment, plan, and cohort differences where data supports it.
- Write a short explanation for each material movement and assign an owner for follow-up.
- Record any formula or definition change in the worksheet’s assumptions log.
Keep the template accessible to finance, revenue operations, and business owners, but limit formula editing to designated administrators. Pair the results with a SaaS operations manual so metric definitions remain available as the team grows. The goal is not to produce a perfect single-number forecast; it is to create a consistent operating rhythm for deciding where acquisition spend, pricing work, retention effort, and product investment deserve attention.