ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
White Cells are Outputs - Don't Touch
2
Yellow Highlight Cells are Inputs - Complete
3
$s
4
Hubspot's Values (Example)
5
Customer Acquisition Cost:$6,793$6,793
6
MRR Churn:5.00%1.50%
7
Average MRR:$1,500$577
8
Software Margin:82%82%
9
Lifetime Value:$24,600$31,543
10
LTV:CAC3.64.6
11
Customer Lifetime (months)2067
12
Payback Period (months)5.5
13
Paid Upfront (Yes or No)No
Please write "Yes" or "No"
14
If so, upfront payment amount25000
15
16
MonthAcquisition CostPaymentsCOGSContribution
Cumulative Cash Flow
17
1-$6,793$1,500-$270$1,230-$5,563
18
2$1,500-$270$1,230-$4,333
19
3$1,500-$270$1,230-$3,103
20
4$1,500-$270$1,230-$1,873
21
5$1,500-$270$1,230-$643
22
6$1,500-$270$1,230$587
23
7$1,500-$270$1,230$1,817
24
8$1,500-$270$1,230$3,047
25
9$1,500-$270$1,230$4,277
26
10$1,500-$270$1,230$5,507
27
11$1,500-$270$1,230$6,737
28
12$1,500-$270$1,230$7,967
29
13$1,500-$270$1,230$9,197
30
14$1,500-$270$1,230$10,427
31
15$1,500-$270$1,230$11,657
32
16$1,500-$270$1,230$12,887
33
17$1,500-$270$1,230$14,117
34
18$1,500-$270$1,230$15,347
35
19$1,500-$270$1,230$16,577
36
20$1,500-$270$1,230$17,807
37
21$1,500-$270$1,230$19,037
38
#N/A$1,500-$270$1,230$20,267
39
#N/A$1,500-$270$1,230$21,497
40
#N/A$1,500-$270$1,230$22,727
41
#N/A$1,500-$270$1,230$23,957
42
#N/A$1,500-$270$1,230$25,187
43
#N/A$1,500-$270$1,230$26,417
44
#N/A$1,500-$270$1,230$27,647
45
#N/A$1,500-$270$1,230$28,877
46
#N/A$1,500-$270$1,230$30,107
47
#N/A$1,500-$270$1,230$31,337
48
#N/A$1,500-$270$1,230$32,567
49
#N/A$1,500-$270$1,230$33,797
50
#N/A$1,500-$270$1,230$35,027
51
#N/A$1,500-$270$1,230$36,257
52
#N/A$1,500-$270$1,230$37,487
53
#N/A$1,500-$270$1,230$38,717
54
#N/A$1,500-$270$1,230$39,947
55
#N/A$1,500-$270$1,230$41,177
56
#N/A$1,500-$270$1,230$42,407
57
#N/A$1,500-$270$1,230$43,637
58
#N/A$1,500-$270$1,230$44,867
59
#N/A$1,500-$270$1,230$46,097
60
#N/A$1,500-$270$1,230$47,327
61
#N/A$1,500-$270$1,230$48,557
62
#N/A$1,500-$270$1,230$49,787
63
#N/A$1,500-$270$1,230$51,017
64
#N/A$1,500-$270$1,230$52,247
65
#N/A$1,500-$270$1,230$53,477
66
#N/A$1,500-$270$1,230$54,707
67
#N/A$1,500-$270$1,230$55,937
68
#N/A$1,500-$270$1,230$57,167
69
#N/A$1,500-$270$1,230$58,397
70
#N/A$1,500-$270$1,230$59,627
71
#N/A$1,500-$270$1,230$60,857
72
#N/A$1,500-$270$1,230$62,087
73
#N/A$1,500-$270$1,230$63,317
74
#N/A$1,500-$270$1,230$64,547
75
#N/A$1,500-$270$1,230$65,777
76
#N/A$1,500-$270$1,230$67,007
77
#N/A$1,500-$270$1,230$68,237
78
#N/A$1,500-$270$1,230$69,467
79
#N/A$1,500-$270$1,230$70,697
80
#N/A$1,500-$270$1,230$71,927
81
#N/A$1,500-$270$1,230$73,157
82
#N/A$1,500-$270$1,230$74,387
83
#N/A$1,500-$270$1,230$75,617
84
#N/A$1,500-$270$1,230$76,847
85
#N/A$1,500-$270$1,230$78,077
86
#N/A$1,500-$270$1,230$79,307
87
#N/A$1,500-$270$1,230$80,537
88
#N/A$1,500-$270$1,230$81,767
89
#N/A$1,500-$270$1,230$82,997
90
#N/A$1,500-$270$1,230$84,227
91
#N/A$1,500-$270$1,230$85,457
92
#N/A$1,500-$270$1,230$86,687
93
94
95
96
97
98
99
100