SAAS Model
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
Still loading...
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARAS
1
JanFebMarAprMayJunJulAugSepOctNovDecJanFebMarAprMayJunJulAugSepOctNovDecJanFebMarAprMayJunJulAugSepOctNovDec
2
Created by Ryan Carson (@ryancarson) with the help ofI've highlighted the most important metrics in yellow, so you can keep an eye on them
3
Marc Roberts (@marcroberts) and the community.
4
5
Increase in new signups per month8.00%
6
Avg revenue per customer$25.00
7
8
% of customers that cancel each month (churn)109.598.587.576.565.555555555555555555555555555
9
Avg customer 'lifetime' in months10.0010.5311.1111.7612.5013.3314.2915.3816.6718.1820.0020.0020.0020.0020.0020.0020.0020.0020.0020.0020.0020.0020.0020.0020.0020.0020.0020.0020.0020.0020.0020.0020.0020.0020.0020.00
10
11
Current Customers01402784165577038561,0181,1921,3801,5841,8072,0432,2932,5592,8433,1443,4673,8124,1804,5764,9995,4545,9436,4677,0327,6398,2938,9969,75410,57111,45112,40013,42314,52715,717
12
Lost to Churn0-13-25-35-45-53-60-66-72-76-79-90-102-115-128-142-157-173-191-209-229-250-273-297-323-352-382-415-450-488-529-573-620-671-726-786
13
New Customers1401511631761902062222402592803023263533814114444805185596046537057618228889591,0351,1181,2081,3041,4091,5211,6431,7751,9172,070
14
Total Customers1402784165577038561,0181,1921,3801,5841,8072,0432,2932,5592,8433,1443,4673,8124,1804,5764,9995,4545,9436,4677,0327,6398,2938,9969,75410,57111,45112,40013,42314,52715,71717,001
15
CMRR (Contracted Monthly Recurring Revenue)$3,500$6,948$10,405$13,929$17,577$21,401$25,457$29,801$34,491$39,590$45,167$51,070$57,330$63,982$71,063$78,612$86,673$95,289$104,511$114,390$124,984$136,353$148,563$161,685$175,795$190,975$207,314$224,906$243,856$264,273$286,279$310,002$335,582$363,169$392,926$425,028
16
CMRR monthly growth98.50%49.76%33.88%26.19%21.76%18.95%17.06%15.74%14.79%14.09%13.07%12.26%11.60%11.07%10.62%10.25%9.94%9.68%9.45%9.26%9.10%8.95%8.83%8.73%8.63%8.56%8.49%8.43%8.37%8.33%8.29%8.25%8.22%8.19%8.17%
17
18
Marketing$4,000$4,000$4,000$4,000$4,000$4,000$4,000$4,000$4,000$4,000$4,000$4,000$6,000$6,000$6,000$6,000$6,000$6,000$6,000$6,000$6,000$6,000$6,000$6,000$9,000$9,000$9,000$9,000$9,000$9,000$9,000$9,000$9,000$9,000$9,000$9,000
19
Cost of Goods Sold (Salaries, Servers, Bandwidth, etc)$25,000$25,000$25,000$25,000$25,000$25,000$35,000$35,000$35,000$35,000$35,000$35,000$45,000$45,000$45,000$45,000$45,000$45,000$55,000$55,000$55,000$55,000$55,000$55,000$65,000$65,000$65,000$65,000$65,000$65,000$75,000$75,000$75,000$75,000$75,000$75,000
20
Fixed Costs (Rent, Phones, etc)$4,000$4,000$4,000$4,000$4,000$4,000$4,000$4,000$4,000$4,000$4,000$4,000$5,000$5,000$5,000$5,000$5,000$5,000$6,000$6,000$6,000$6,000$6,000$6,000$7,000$7,000$7,000$7,000$7,000$7,000$8,000$8,000$8,000$8,000$8,000$8,000
21
Total Costs$33,000$33,000$33,000$33,000$33,000$33,000$43,000$43,000$43,000$43,000$43,000$43,000$56,000$56,000$56,000$56,000$56,000$56,000$67,000$67,000$67,000$67,000$67,000$67,000$81,000$81,000$81,000$81,000$81,000$81,000$92,000$92,000$92,000$92,000$92,000$92,000
22
23
Cash flow-$29,500-$26,053-$22,595-$19,071-$15,423-$11,599-$17,543-$13,199-$8,509-$3,410$2,167$8,070$1,330$7,982$15,063$22,612$30,673$39,289$37,511$47,390$57,984$69,353$81,563$94,685$94,795$109,975$126,314$143,906$162,856$183,273$194,279$218,002$243,582$271,169$300,926$333,028
24
Cash (Starting with $50K in bank)$20,500-$5,553-$28,148-$47,219-$62,642-$74,241-$91,784-$104,983-$113,493-$116,902-$114,735-$106,665-$105,336-$97,354-$82,291-$59,679-$29,006$10,283$47,793$95,183$153,167$222,520$304,084$398,769$493,564$603,539$729,853$873,759$1,036,614$1,219,888$1,414,167$1,632,169$1,875,750$2,146,919$2,447,844$2,780,873
25
26
Cost per cust$235.71$118.75$79.29$59.23$46.94$38.55$42.23$36.07$31.17$27.15$23.80$21.05$24.42$21.88$19.70$17.81$16.15$14.69$16.03$14.64$13.40$12.28$11.27$10.36$11.52$10.60$9.77$9.00$8.30$7.66$8.03$7.42$6.85$6.33$5.85$5.41
27
CPA (Cost per Acquisition)$28.57$26.46$24.50$22.68$21.00$19.45$18.00$16.67$15.44$14.29$13.23$12.25$17.02$15.76$14.59$13.51$12.51$11.58$10.72$9.93$9.19$8.51$7.88$7.30$10.14$9.39$8.69$8.05$7.45$6.90$6.39$5.92$5.48$5.07$4.70$4.35
28
Months to recover CPA1.141.060.980.910.840.780.720.670.620.570.530.490.680.630.580.540.500.460.430.400.370.340.320.290.410.380.350.320.300.280.260.240.220.200.190.17
29
Average monthly cost per customer over their 'lifetime' months$67.17$47.66$37.65$32.68$28.22$25.05$22.68$20.10$18.08$16.08$14.40$13.62$12.94$12.08$11.32$10.64$10.28$9.97$9.71$9.34$9.01$8.71$8.46$8.24$8.06$7.75$7.46$7.21$6.98$6.80$6.65$6.37$6.11$5.87$5.63$5.41
30
Projected lifetime cost per customer$671.72$501.65$418.31$384.50$352.81$334.00$324.00$309.16$301.31$292.39$287.99$272.39$258.87$241.64$226.38$212.77$205.60$199.42$194.17$186.74$180.11$174.25$169.14$164.81$161.28$154.99$149.29$144.17$139.68$135.91$133.02$127.48$122.26$117.32$112.65$108.23
31
Sum of cost per customer over the next 'lifetime' months$738.89$524.23$451.78$392.19$366.92$350.70$340.20$321.53$307.34$305.54$302.39$286.01$271.81$253.73$237.70$223.41$205.60$189.45$174.76$158.73$144.09$130.68$118.40$107.13$96.77$85.25$74.64$64.88$55.87$47.57$39.91$31.87$24.45$17.60$11.26$5.41
32
Lifetime Revenue per customer$250.00$263.16$277.78$294.12$312.50$333.33$357.14$384.62$416.67$454.55$500.00$500.00$500.00$500.00$500.00$500.00$500.00$500.00$500.00$500.00$500.00$500.00$500.00$500.00$500.00$500.00$500.00$500.00$500.00$500.00$500.00$500.00$500.00$500.00$500.00$500.00
33
Lifetime Profit per customer-$488.89-$261.07-$174.00-$98.07-$54.42-$17.37$16.94$63.08$109.33$149.00$197.61$213.99$228.19$246.27$262.30$276.59$294.40$310.55$325.24$341.27$355.91$369.32$381.60$392.87$403.23$414.75$425.36$435.12$444.13$452.43$460.09$468.13$475.55$482.40$488.74$494.59
34
35
CACR (Customer Acquisition Cost Ratio)-3.19-1.910.280.841.912.744.495.855.647.4410.15
36
New Cumulative Recurring Rev for quarter$10,405$10,996$13,090$16,579$19,993$24,226$29,695$36,701$45,628$56,960$71,308$89,447
37
Net Profit for quarter-$78,148-$46,093-$39,251$6,827$24,374$92,574$142,884$245,602$331,084$490,035$655,862$905,122
38
Net Profit %-374.77%-87.12%-43.73%5.03%12.67%35.53%41.55%54.99%57.67%66.85%70.38%76.63%
39
Marketing costs for quarter$12,000$12,000$12,000$12,000$18,000$18,000$18,000$18,000$27,000$27,000$27,000$27,000
40
More info at: http://bit.ly/93pK2v
41
42
43
Loading...
 
 
 
Figures