SaaS Operating Metrics

	A	B	C	D	E	F	G	H	I	J	K	L	M	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA
1	CMRR (in $s)	1/2016	2/2016	3/2016	4/2016	5/2016	6/2016	7/2016	8/2016	9/2016	10/2016	11/2016	12/2016	Customer count	1/2016	2/2016	3/2016	4/2016	5/2016	6/2016	7/2016	8/2016	9/2016	10/2016	11/2016	12/2016
2	Starting MRR	100,000.00	110,000.00	120,000.00	130,000.00	140,000.00	150,000.00	160,000.00	170,000.00	180,000.00	190,000.00	200,000.00	210,000.00	Starting MRR	1000	1100	1200	1300	1400	1500	1600	1700	1800	1900	2000	2100
3	New New TCV	60,000.00	60,000.00	60,000.00	60,000.00	60,000.00	60,000.00	60,000.00	60,000.00	60,000.00	60,000.00	60,000.00	60,000.00	New New TCV	200	220	240	260	280	300	320	340	360	380	400	420
4	New New Months Paid	1,200	1,320	1,440	1,560	1,680	1,800	1,920	2,040	2,160	2,280	2,400	2,520
5	New New Bookings (MRR)	10,000.00	10,000.00	10,000.00	10,000.00	10,000.00	10,000.00	10,000.00	10,000.00	10,000.00	10,000.00	10,000.00	10,000.00
6	Other New Bookings	5,000.00	5,000.00	5,000.00	5,000.00	5,000.00	5,000.00	5,000.00	5,000.00	5,000.00	5,000.00	5,000.00	5,000.00
7	New Bookings	15,000.00	15,000.00	15,000.00	15,000.00	15,000.00	15,000.00	15,000.00	15,000.00	15,000.00	15,000.00	15,000.00	15,000.00	New Bookings	250	270	290	310	330	350	370	390	410	430	450	470
8	Upgrades	5,000.00	5,000.00	5,000.00	5,000.00	5,000.00	5,000.00	5,000.00	5,000.00	5,000.00	5,000.00	5,000.00	5,000.00	Upgrades	50	55	60	65	70	75	80	85	90	95	100	105
9	Upgrade Adjustments	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
10	Total Upgrades	5,000.00	5,000.00	5,000.00	5,000.00	5,000.00	5,000.00	5,000.00	5,000.00	5,000.00	5,000.00	5,000.00	5,000.00
11	Downgrades	-2,000.00	-2,000.00	-2,000.00	-2,000.00	-2,000.00	-2,000.00	-2,000.00	-2,000.00	-2,000.00	-2,000.00	-2,000.00	-2,000.00	Downgrades	30	33	36	39	42	45	48	51	54	57	60	63
12	Downgrade Adjustments	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
13	Total Downgrades	-2,000.00	-2,000.00	-2,000.00	-2,000.00	-2,000.00	-2,000.00	-2,000.00	-2,000.00	-2,000.00	-2,000.00	-2,000.00	-2,000.00
14	Total Net Upgrades	3,000.00	3,000.00	3,000.00	3,000.00	3,000.00	3,000.00	3,000.00	3,000.00	3,000.00	3,000.00	3,000.00	3,000.00
15	Cancellation	-4,000.00	-4,000.00	-4,000.00	-4,000.00	-4,000.00	-4,000.00	-4,000.00	-4,000.00	-4,000.00	-4,000.00	-4,000.00	-4,000.00	Cancellation	20	22	24	26	28	30	32	34	36	38	40	42
16	Cancellation Adjustments	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
17	Total Cancellation	-4,000.00	-4,000.00	-4,000.00	-4,000.00	-4,000.00	-4,000.00	-4,000.00	-4,000.00	-4,000.00	-4,000.00	-4,000.00	-4,000.00
18	Ending MRR	110,000.00	120,000.00	130,000.00	140,000.00	150,000.00	160,000.00	170,000.00	180,000.00	190,000.00	200,000.00	210,000.00	220,000.00	Ending MRR	1100	1200	1300	1400	1500	1600	1700	1800	1900	2000	2100	2200
19
20
21	You fill in highlighted fields
22
23	Special thanks to David Skok and the Matrix team who published an Excel spreadsheet here: http://www.forentrepreneurs.com/saas-metrics-2/
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100