How to (Actually) Calculate CAC -- Interactive Spreadsheets
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
Still loading...
ABCDEFGHIJKLM
1
JanFebMarAprilMayJuneJulyAugSeptOctNovDec
2
Mktng Expenses
$10,450$11,892$12,347$12,395$13,538$10,385$10,395$13,485$12,347$13,538$12,584$12,119
3
Sales Expenses
$30,122$34,321$38,943$38,234$40,438$44,784$48,348$44,321$44,756$44,943$48,218$50,326
4
Total Expenses$40,572$46,213$51,290$50,629$53,976$55,169$58,743$57,806$57,103$58,481$60,802$62,445
5
New Customers
453485481502509444545589590612690700
6
CAC$90$95$107$101$106$124$108$98$97$96$88$89
7
8
Simple CAC Calculation CAC = (Marketing Exp + Sales Exp)/New Customers
9
10
Loading...
 
 
 
Simple Calculation
Overstimating CAC - 1/2
Overstimating CAC
Average Cycle