Calculating LTV and CAC Ratios

The Art and Science of Calculating LTV and CAC

Calculating Lifetime Value (LTV) and Customer Acquisition Cost (CAC) is essential for understanding the profitability and efficiency of your business's marketing efforts. However, this task can be particularly challenging for earlier-stage businesses with limited historical data. At Firehawk Analytics, we blend art and science to help our clients accurately calculate these metrics, enabling them to make informed decisions that drive sustainable growth.

Understanding LTV and CAC

Lifetime Value (LTV)

Definition: Lifetime Value (LTV) is the predicted net profit attributed to the entire future relationship with a customer, considering the gross margin rather than total revenue. It helps businesses understand how much a customer is worth over the duration of their relationship.

Formula:

LTV = Average Purchase Value × Purchase Frequency × Customer Lifespan × Gross Margin %

• Average Purchase Value: Total revenue divided by the number of purchases.
• Purchase Frequency: Number of purchases divided by the number of unique customers.
• Customer Lifespan: Average number of months or years a customer continues to purchase.
• Gross Margin Percentage: The percentage of revenue remaining after deducting the cost of goods sold (COGS).

Worked Example:

1. Average Purchase Value: If total revenue for the year is $100,000 from 1,000 purchases → $100,000 ÷ 1,000 = $100
2. Purchase Frequency: If you have 200 unique customers making 1,000 purchases → 1,000 ÷ 200 = 5
3. Customer Lifespan: If customers typically remain active for 3 years → 3 years
4. Gross Margin Percentage: If gross margin is 60% → 0.60
5. LTV Calculation: $100 × 5 × 3 × 0.60 = $900

This means each customer is worth $900 over their lifetime in terms of gross profit.

Customer Acquisition Cost (CAC)

Definition: Customer Acquisition Cost (CAC) is the total cost of acquiring a new customer. It includes all marketing and sales expenses — advertising, sales team costs, agency fees, and any other costs directly associated with bringing in new customers.

Formula:

CAC = Total Marketing and Sales Expenses ÷ Number of New Customers Acquired

Worked Example:

1. Total Marketing and Sales Expenses: $50,000 spent on marketing and sales in the year.
2. New Customers Acquired: 500 new customers acquired during that year.
3. CAC Calculation: $50,000 ÷ 500 = $100 per new customer acquired.

This means it costs $100 to acquire each new customer.

The LTV to CAC Ratio

Definition: The LTV to CAC ratio is a key metric that indicates the relationship between the value of a customer over their lifetime and the cost of acquiring that customer. This ratio helps businesses assess the effectiveness and profitability of their customer acquisition efforts.

Formula:

LTV to CAC Ratio = LTV ÷ CAC

Interpreting the Ratio:

• A ratio of 1:1 means you are breaking even — the cost to acquire a customer equals the gross profit they generate over their lifetime.
• A ratio below 1:1 is a warning sign. It costs more to acquire a customer than they will ever return. This may be acceptable early on but is not sustainable.
• A ratio above 1:1 means the customer generates more gross profit than they cost to acquire. A ratio of 3:1 or more is typically considered healthy, though this varies by industry.

What Constitutes a Good or Bad Ratio?

• SaaS and Subscription Businesses: A ratio of around 3:1 is the standard benchmark — for every dollar spent acquiring a customer, they generate three dollars in gross profit over their lifetime.
• E-commerce Businesses: A ratio closer to 2:1 may be acceptable due to higher competition and potentially lower margins.
• Highly Competitive Industries: In industries with high acquisition costs, even a ratio of 1.5:1 can be considered acceptable.

Worked Example: Using the figures above — LTV of $900 and CAC of $100:

LTV to CAC Ratio = $900 ÷ $100 = 9:1

A ratio of 9:1 indicates a highly profitable customer acquisition strategy. Most businesses would be delighted with this result.

The Challenges of Calculating LTV and CAC

For early-stage businesses, arriving at reliable LTV and CAC numbers involves several real-world challenges:

1. Accurate Marketing Spend Allocation: Distinguishing between brand marketing and direct acquisition costs is harder than it sounds. Properly structuring your chart of accounts from the start makes this significantly easier — separating brand from performance spend so your CAC calculation reflects the true cost of winning new customers.
2. Estimating Churn: Without a long track record, future churn rates are speculative. Subscription businesses in particular may have limited data on how long customers stay, which directly affects LTV calculations.
3. Tracking Repeat Customers in eCommerce: Identifying and linking repeat purchases to individual customers requires robust tracking. Many eCommerce businesses undercount LTV because they cannot reliably match orders to returning customers.
4. Internal Resource Constraints: Thorough LTV and CAC analysis takes time. Many businesses lack the internal capacity to do it well — which is why Firehawk Analytics provides this analysis as part of our client engagements, freeing teams to focus on their core operations.

The Benefits of Accurate LTV and CAC Calculations

Understanding LTV and CAC can transform your marketing strategy. By identifying which customer cohorts have the highest lifetime value, and which acquisition channels deliver the lowest cost per customer, you can allocate budget with far greater precision — shifting spend toward what works and cutting what doesn't.

Practical Suggestions to Overcome Common Issues

1. Organise Your Chart of Accounts: Ensure your financial data clearly separates brand marketing from acquisition costs. This single structural decision can dramatically improve the accuracy of your CAC calculations. Well-structured accounts also make it easy to track marketing spend by channel, which is essential for channel-level CAC analysis.
2. Leverage Early Data: For new businesses with limited history, use early customer data to build initial estimates. The key is to start — imperfect data is better than no data, and you refine the model as more information becomes available.
3. Implement Robust Tracking Systems: Use a capable CRM and booking or e-commerce system to track individual customer behaviour over time. This data is the foundation of accurate LTV calculations, particularly for businesses with repeat purchase models.
4. Build It Into Your Reporting: LTV and CAC should not be calculated once a year for a board pack. They should sit inside your regular reporting cadence — tracked monthly, reviewed by the leadership team, and used to inform budget decisions in real time.

Firehawk Analytics' Methodology

At Firehawk Analytics, we integrate data from multiple sources — combining financial information from your accounting platform with CRM, booking engine, and e-commerce data. This comprehensive approach allows us to track both individual customer behaviour and cohort-level trends with accuracy.

Steps we follow:

1. Data Collection: Gather financial and customer data from all relevant platforms — accounting software, CRM, POS, e-commerce, payroll.
2. Data Preparation: Clean and organise the data to resolve inconsistencies, remove duplicates, and ensure every transaction is correctly attributed.
3. Data Integration: Combine sources into a single unified view — linking financial data to customer records so LTV and CAC can be calculated at both an individual and cohort level.
4. Analysis and Visualisation: Use advanced analytics and BI tools to calculate LTV and CAC, surface trends over time, and present the insights in a format that is immediately actionable for the leadership team.

Real-World Impact

During onboarding, we discuss key performance metrics with each client and help them build LTV and CAC tracking directly into their Firehawk Analytics member portal. This means the numbers are always current — not a quarterly exercise, but a live operational metric that informs decisions continuously.

Conclusion

Accurately calculating LTV and CAC, and maintaining a healthy LTV to CAC ratio, is both an art and a science — particularly for early-stage businesses where historical data is limited and assumptions carry significant weight. By combining rigorous data integration with sound financial structure, businesses can move from guesswork to genuine clarity on what it costs to grow and what that growth is worth.

Contact Firehawk Analytics today to learn how we can help you build this analysis into your business intelligence infrastructure.