Skip to tool

Categories

Google Sheets & ModelsGoogle Sheet100% Free & Open Source

SaaS Unit Economics & Cohort Retention Tracker

Track core SaaS performance metrics: MRR/ARR, Customer Acquisition Cost (CAC), Lifetime Value (LTV), LTV:CAC ratio, CAC Payback Period, and monthly logo churn.

Designed For

SaaS Founders, Growth Marketers, Product Managers, and Investors

Companion OpenTools Utility
Percentage & Math CalculatorOpen Tool

What's Included in this Template

Automated LTV:CAC Ratio Gauge with healthy benchmark guidance (> 3.0x)
CAC Payback Period calculator in months based on gross margin %
Monthly Logo Churn vs Net Revenue Retention (NRR) cohort table
Visual graphs for MRR growth, blended CAC, and customer lifetime value

Access & Download Template

Make a Copy in Google Sheets
Live Preview & Code InspectorZero Server Uploads
# SaaS Unit Economics & Cohort Retention Tracker Know your numbers before talking to investors or scaling paid acquisition channels. ## 📈 Key Formulas Included * **Customer Acquisition Cost (CAC)**: `=(Total_Sales_Expense + Total_Marketing_Expense) / New_Customers_Acquired` * **Customer Lifetime Value (LTV)**: `=(Average_Revenue_Per_Account * Gross_Margin_Percentage) / Monthly_Churn_Rate` * **LTV : CAC Ratio**: Target is $3.0\times$ to $5.0\times$. Less than $3.0\times$ indicates unprofitable acquisition. * **CAC Payback (Months)**: `=CAC / (Average_Monthly_Revenue_Per_Account * Gross_Margin_Percentage)`. Target is $< 12\text{ months}`.

Frequently Asked Questions (FAQ)

Why is LTV:CAC ratio so important?

It measures how much gross profit a customer generates compared to the cost of acquiring them. A healthy SaaS company typically maintains an LTV:CAC ratio of 3x or higher.

More in Google Sheets & Models

FinancialView
EssentialView