How to Calculate Customer Acquisition Cost (CAC) + Free Excel Template

If you don’t know your Customer Acquisition Cost (CAC), you’re flying blind.

CAC is one of the most important growth metrics for startups and SaaS companies. It tells you how much it actually costs to acquire a new customer—and whether your marketing and sales efforts are sustainable.

In this guide, you’ll learn how to calculate CAC step by step, common mistakes to avoid, and how to track it easily using a simple Excel template.

📌 TL;DR

• CAC measures how much you spend to acquire one customer
• Formula: Total Sales & Marketing Cost ÷ New Customers Acquired
• A good CAC depends on your business model
• Tracking CAC in Excel helps control growth and profitability

✅ What Is Customer Acquisition Cost (CAC)?

Customer Acquisition Cost (CAC) is the total cost your business incurs to acquire a single new customer over a specific period.

It includes:

• Marketing expenses
• Sales expenses
• Tools and software
• Team salaries (partial or full)

CAC is especially critical for:

• SaaS companies
• Subscription businesses
• Startups and VC‑backed companies

🧮 The Basic CAC Formula

The standard formula for calculating CAC is:

CAC = Total Sales & Marketing Cost ÷ Number of New Customers Acquired

Example:

• Sales & marketing spend in a month: ₹5,00,000
• New customers acquired: 100

CAC = 5,00,000 ÷ 100 = ₹5,000

This means it costs you ₹5,000 to acquire one customer.

🧾 What Costs Should Be Included in CAC?

To calculate accurate CAC, include all acquisition‑related expenses:

✅ Marketing Costs

• Paid ads (Google, Meta, LinkedIn, etc.)
• Content marketing & SEO
• Influencer campaigns
• Marketing tools & software

✅ Sales Costs

• Sales team salaries & commissions
• CRM tools
• Sales software & call expenses

✅ Support Costs (Optional but Recommended)

• Pre‑sales support
• Demo and onboarding costs (for SaaS)

🚫 Do not include product development or customer support meant for existing customers.

📉 CAC vs LTV: Why CAC Alone Isn’t Enough

CAC becomes powerful when compared with Customer Lifetime Value (LTV).

A healthy rule of thumb:

LTV ≥ 3 × CAC

If your CAC is high and LTV is low, growth will eventually stall.

🗂️ CAC Excel Template Structure (Simple & Effective)

You can easily track CAC in Excel or Google Sheets using this format:

✅ Sheet Columns

• Month
• Marketing Spend
• Sales Spend
• Total Acquisition Cost
• New Customers Acquired
• CAC

✅ Excel Formula Example

If:

• Total Cost is in cell D2
• New Customers are in E2

= D2 / E2

This gives you CAC for that period.

You can duplicate this monthly to track trends over time.

📈 Advanced CAC Tracking (Optional)

Once you’re comfortable, you can calculate:

• Paid CAC (ads only)
• Organic CAC (content + SEO)
• Channel‑wise CAC (Google Ads, LinkedIn, referrals)
• Blended CAC (overall average)

This helps you double down on the most efficient growth channels.

❌ Common CAC Calculation Mistakes

Avoid these pitfalls:

• Ignoring sales salaries
• Mixing time periods
• Counting leads instead of customers
• Not segmenting channels
• Calculating CAC too infrequently

✅ Why Tracking CAC Regularly Matters

• Controls marketing spend
• Improves forecasting
• Prevents cash burn
• Supports investor conversations
• Enables sustainable growth

🎯 Final Call to Action

👉 You can’t scale what you don’t measure.

Start tracking your Customer Acquisition Cost today to make smarter growth decisions and avoid expensive surprises.

✅ Calculate CAC monthly
✅ Track trends, not just one number
✅ Compare CAC with LTV