Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to calculate the CAC payback period in Excel and Google Sheets
Topic:SaaS metricsExcel & Google Sheets
=B1/(B2*(B3/100))Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
Step by step
- 1In cell A1 enter 'CAC ($)' and in B1 enter your CAC value (e.g. 1200).
- 2In cell A2 enter 'ARPU per month ($)' and in B2 enter monthly revenue per customer (e.g. 150).
- 3In cell A3 enter 'Gross Margin (%)' and in B3 enter your gross margin percentage (e.g. 75).
- 4In cell A4 enter 'Payback Period (months)' and in B4 enter the formula =B1/(B2*(B3/100)).
- 5The result is the number of months until gross profit from that customer equals CAC. Compare against your 12-month target.
Tips
- Use gross profit per customer, not revenue per customer. Using revenue overstates payback health because it ignores cost of goods sold.
- If you sell multiple plans, calculate payback period per plan tier — enterprise and SMB customers often have dramatically different payback profiles.
- A payback period over 18 months signals that you need to either reduce CAC, increase ARPU, or improve gross margin before scaling spend.
Working on a sheet you inherited? Run the Auditor on the whole file first — it flags every #REF!, #N/A, broken column pattern, and inconsistent formula in seconds, free, no signup.
Frequently asked
What is a good CAC payback period?
Best-in-class SaaS businesses recover CAC in under 12 months. 12–18 months is acceptable for enterprise sales. Over 24 months is a red flag requiring attention.
How does expansion revenue affect payback period?
If customers expand (upgrade plans or add seats), the effective payback is shorter because monthly gross profit increases over time. The formula above uses entry-level ARPU; build a month-by-month model to capture expansion.
Should I use blended or channel-specific CAC in this formula?
Use channel-specific CAC to understand payback by acquisition source. Blended CAC is useful for the company-level metric but masks channel inefficiency.
More on SaaS metrics
See all →Reference
RANDARRAY
Spills a grid of random numbers with specified rows, columns, min, max, and integer/decimal options. Excel 365 and Google Sheets only.
How-toHow to calculate churn rate
Calculate monthly or annual customer churn rate as lost customers divided by starting customers, expressed as a percentage, in Excel and Google Sheets.
Error fixFix #####
Fix ##### in Excel — the column is too narrow to display the number or date. Widen the column or change the format to resolve it.
ReferenceARRAYTOTEXT
Converts an array or range into a single text string, with concise or strict formatting options.
How-toHow to calculate monthly recurring revenue (MRR)
Learn how to calculate MRR in Excel and Google Sheets using SUMIF to sum active subscription revenue by billing period, normalized to a monthly figure.
Error fixFix Array result
Array result was not expanded in Google Sheets means output cells are blocked. Clear adjacent cells or use a blank area.