A CAC calculator template lets you plug in your sales and marketing expenses plus new customer counts and instantly get your fully-loaded Customer Acquisition Cost. The formula: CAC = (Sales expenses + Marketing expenses) ÷ New customers acquired. Our free interactive CAC calculator walks you through what to include, computes the number, and shows you where your CAC lands relative to industry benchmarks. This post explains what a good CAC template needs to include, walks you through using the calculator, and covers what to do with the number once you have it.
Most businesses know they should calculate Customer Acquisition Cost. Many don't because the arithmetic feels ambiguous — what exactly counts as marketing spend? Are salaries included? What about the marketing intern? What's the right time period?
A good CAC calculator template resolves those ambiguities by pre-defining what to include, showing you the formula in action, and giving you a number you can trust.
We built our free CAC calculator specifically to solve this problem for SMB operators who need a defensible CAC number for planning, board meetings, or investor conversations. This post explains how it works and how to use the output.
What a good CAC template includes
Any CAC calculator template — ours or someone else's — should include these components:
Input: Sales expenses (fully loaded)
The template should prompt you for ALL sales-related costs, not just a single "sales budget" line:
- Salaries and benefits of sales team members
- Sales commissions and bonuses paid
- Sales tools (CRM, prospecting, enablement)
- Sales training and enablement content production
- Sales-attributable travel and entertainment
- Sales operations headcount
- Allocated overhead (space, IT, HR support)
Input: Marketing expenses (fully loaded)
The template should prompt for all marketing costs:
- Paid advertising across all channels
- Marketing team salaries and benefits
- Marketing tools (marketing automation, analytics, SEO tools)
- Content production (writers, designers, video)
- Agency fees and consulting spend
- Events and sponsorships
- PR and communications
- Marketing-attributable overhead
Input: New customers acquired
Not all customers — only new ones acquired in the measurement period. Expansions and renewals are separate metrics.
Input: Time period
A defined window (monthly, quarterly, or annually) with numerator (spend) and denominator (customers) using the same window.
Output: Blended CAC + segmentation guidance
Blended CAC is the top-line number, but the template should encourage you to segment by channel and customer type — because blended CAC hides more than it reveals.
Output: Comparison to industry benchmarks
A CAC number in isolation is meaningless. A good template shows you what healthy CAC looks like for your industry and business model.
Output: LTV:CAC ratio calculation
The CAC number's real meaning comes from comparison to Customer Lifetime Value. Any useful CAC template should either compute or prompt you toward the LTV:CAC ratio, which is the actual decision-making metric.
Walking through our CAC calculator
Our interactive CAC calculator is designed for SMB and mid-market operators. The workflow:
Step 1: Define your time period. Most operators use quarterly. Monthly works for high-velocity businesses; annual works for professional services with long cycles.
Step 2: Enter your sales expenses for the period. The calculator prompts you category by category so you don't miss anything. If you don't have a sales function (common in DTC), you skip this section entirely.
Step 3: Enter your marketing expenses for the period. Same structure. The calculator explicitly asks about categories operators typically forget (agency fees, allocated overhead, content production).
Step 4: Enter new customers acquired in the period. The calculator clarifies what counts (net new customers) and what doesn't (expansions, renewals, reactivations).
Step 5: Get your blended CAC. The calculator produces the fully-loaded CAC number.
Step 6: See it against benchmarks. The output includes the healthy CAC range for your industry, so you can immediately see whether you're above, at, or below where you should be.
Step 7: Add LTV to compute LTV:CAC. If you know your average customer LTV, the calculator computes your LTV:CAC ratio. If you don't know your LTV, we point you to our CLV calculator to get that number first.
Total time: 90 seconds if your financial data is at hand. Under 5 minutes if you have to hunt for numbers.
Using a CAC template in Excel or Google Sheets
If you'd rather build your own CAC calculator in a spreadsheet, the structure looks like this:
Column A — Category (Sales, Marketing) Column B — Line item (Salaries, Commissions, Ads, etc.) Column C — Amount for the period
Sum column C for total S&M spend.
Below the total, add:
- Row for "New customers acquired"
- Row for "CAC" with formula
= Total Spend / New Customers - Row for "Average LTV"
- Row for "LTV:CAC Ratio" with formula
= LTV / CAC
That's the minimal viable CAC template. Extend it with segmentation columns (channel, customer tier) if you want more analytical depth.
The advantage of a spreadsheet template: you can save it, iterate on assumptions, run scenarios. The disadvantage: you have to build the industry benchmark comparison yourself.
Our free interactive calculator does the benchmark comparison automatically. Use whichever tool fits your workflow.
What to do with your CAC number
The CAC number itself doesn't tell you anything until you compare it to something. Once you have it, three questions matter:
Question 1: Is your LTV:CAC ratio healthy?
Take your CAC and divide it into your average customer LTV. Interpretation:
- Ratio > 3:1 — healthy, sustainable growth economics
- Ratio 1-3:1 — tight; investment scrutiny warranted
- Ratio < 1:1 — every new customer is destroying value; unit economics are broken
If you don't know your LTV, our CLV calculator computes it in about the same time as the CAC calculator.
Question 2: How does your CAC compare to your industry?
Rough industry ranges (from our CAC benchmarks post):
- B2B SaaS: $500 - $10,000+ depending on sales motion
- DTC/E-commerce: $30 - $250
- Professional services: $3,000 - $25,000
- Financial services: $200 - $1,500
- Healthcare: $50 - $500
If your CAC is significantly above your industry range, you need a clear explanation. Sometimes higher CAC is justified (enterprise sales motion, premium market position). Sometimes it indicates inefficient acquisition that needs fixing.
Question 3: How is your CAC trending?
A single CAC number tells you today. A CAC trend tells you the direction. Rising CAC alongside rising customer counts might be fine (you're pushing into more expensive segments). Rising CAC with flat or declining customer counts is a red flag.
Set up your CAC calculation as a quarterly discipline. Watch the trend. Investigate anomalies.
Common mistakes when using a CAC template
Even a good template can produce misleading numbers if you use it wrong. The mistakes we see most often:
Mistake 1: Not fully loading the spend. Templates work only if you actually input all costs. Skipping salaries or overhead produces artificially low CAC.
Mistake 2: Mismatching time periods. If you input Q1 spend and Q2 customer count, your CAC will look different than if you use matched periods. Pick a convention and stick to it.
Mistake 3: Counting the wrong customers. Templates ask for "new customers acquired." If you include existing customer renewals, your CAC will look artificially low.
Mistake 4: Using blended CAC when you need segmented CAC. The template produces a single blended number. If you're making channel investment decisions, you need per-channel CAC — which requires running the template multiple times.
Mistake 5: Not connecting to LTV. A CAC number without LTV comparison is trivia. Always run the LTV:CAC ratio to make the CAC number decision-relevant.
Beyond the calculator: connecting CAC to CS quality
One point that most CAC calculators don't make explicit: your effective CAC depends on retention as much as acquisition efficiency. A customer acquired at $500 CAC who churns in 6 months has effective CAC of $500 amortized over 6 months. The same customer retained for 24 months has effective CAC amortized over 24 months — same acquisition dollars, 4x the return.
This is why businesses with high CAC (SaaS, financial services, professional services) invest heavily in customer service quality. Better CS produces retention. Retention amortizes CAC. Higher effective LTV:CAC ratio.
If your CAC is coming out on the high end of your industry range and you're wondering where to invest to fix it, the answer is often: improve customer service quality. It's the fastest lever to improve your effective unit economics without touching acquisition spend.
Our Customer Service Audit is specifically designed for operations wanting to understand how CS quality is affecting retention — and therefore CAC amortization. Three weeks, fixed fee, prioritized recommendations.