| A | B | C | D | E | F | G | H | I | J | K | L | M | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Jan | Feb | Mar | April | May | June | July | Aug | Sept | Oct | Nov | Dec | ||
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 | 453 | 485 | 481 | 502 | 509 | 444 | 545 | 589 | 590 | 612 | 690 | 700 | |
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 | ||||||||||||||