Run Rate and Seasonal Effects

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY
1	Customers on T0		10000		Bad case reduction		3%							2
2	customers growth rate (absolute)		10000		Good case increase		2%				= Changeable
3	churn rate (relative)		7%		case operatior		0,5
4	average value per customer		6
5	Cost per new Cutomer		0
6
7	Month	T0	T1	T2	T3	T4	T5	T6	T7	T8	T9	T10	T11	T0	T1	T2	T3	T4	T5	T6	T7	T8	T9	T10	T11	T12	T13	T14	T15	T16	T17	T18	T19	T20	T21	T22	T23	T24	T25	T26	T27	T28	T29	T30	T31	T32	T33	T34	T35	T36	T37
8	Sessional Effect	1	0,9	1,2	1,1	1	0,8	1	0,8	0,8	1,1	1,3	1,6	1	0,9	1,2	1,1	1	0,8	1	0,8	0,8	1,1	1,3	1,6	1	0,9	1,2	1,1	1	0,8	1	0,8	0,8	1,1	1,3	1,6	1	0,9	1,2	1,1	1	0,8	1	0,8	0,8	1,1	1,3	1,6	1	0,9
9	c w/o chrun	10000	20000	30000	40000	50000	60000	70000	80000	90000	100000	110000	120000	130000	140000	150000	160000	170000	180000	190000	200000	210000	220000	230000	240000	250000	260000	270000	280000	290000	300000	310000	320000	330000	340000	350000	360000	370000	380000	390000	400000	410000	420000	430000	440000	450000	460000	470000	480000	490000	500000
10	C at end of period	10000	17670	27593	35892	42679	47132	53132	56853	60313	66321	73769	83485	86941	89225	94140	97780	100235	100659	102913	103149	103368	106363	111007	118117	119148	119178	121996	123686	124328	123065	123750	122528	121391	123124	126595	132613	132630	131716	133656	134530	134413	132444	132473	130640	128935	130140	133120	138682	138274	136965
11	C w/o season	10000	18600	26598	34036	40954	47387	53370	58934	64109	68921	73396	77559	81430	85030	88377	91491	94387	97080	99584	101913	104079	106094	107967	109709	111330	112837	114238	115541	116754	117881	118929	119904	120811	121654	122438	123168	123846	124477	125063	125609	126116	126588	127027	127435	127815	128168	128496	128801	129085	129349
12	Iterator	0	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	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
13	estimations w/o chrun	60000	120000	180000	240000	300000	360000	420000	480000	540000	600000	660000	720000	780000	840000	900000	960000	1020000	1080000	1140000	1200000	1260000	1320000	1380000	1440000	1500000	1560000	1620000	1680000	1740000	1800000	1860000	1920000	1980000	2040000	2100000	2160000	2220000	2280000	2340000	2400000	2460000	2520000	2580000	2640000	2700000	2760000	2820000	2880000	2940000	3000000
14	estimations w/o season	60000	111600	159588	204217	245722	284321	320219	353603	384651	413526	440379	465352	488578	510177	530265	548946	566320	582478	597504	611479	624475	636562	647803	658257	667979	677020	685429	693249	700521	707285	713575	719425	724865	729924	734630	739006	743075	746860	750380	753653	756697	759529	762162	764610	766888	769005	770975	772807	774510	776095
15	Estimations w Season	60000	106020	165559	215349	256075	282790	318794	341119	361881	397929	442614	500911	521647	535352	564837	586679	601411	603952	617476	618892	620210	638175	666043	708700	714891	715069	731974	742116	745968	738390	742503	735167	728346	738741	759570	795680	795782	790297	801937	807181	806478	794665	794838	783840	773611	780838	798719	832089	829643	821788
16	bad case	60000	104430	160592	205659	240711	261581	290103	305301	318455	344209	376222	418261	427751	430958	446221	454676	457072	449944	450757	442508	434147	437150	446249	464198	457530	446918	446504	441559	432661	417190	408376	393315	378740	373064	372189	377948	366060	351682	344833	334980	322591	305946	294090	278263	263028	253772	247603	245466	232300	217774
17	good case	60000	107080	168870	221810	266318	296929	337922	364997	390831	433743	486875	556011	584245	604948	643914	674680	697637	706624	728621	736482	744252	772192	812572	871701	886465	893836	922287	942487	954838	952523	965253	963069	961416	982526	1017823	1074168	1082264	1082707	1106672	1121982	1129070	1120477	1128670	1120891	1114000	1132215	1166130	1223171	1227871	1224464
18	Runrate w/o chrun	4680000
19	Run Rate w/o Season	3443177		Result:	The Run Rate is a very inaccurate tool do describe growth, revenue or anything. But it is some kind of indicator to compare and/or evaluate.
20	Run Rate w Season	3449041			Seasonal effects should be considert, if the seasonal effects are very strong (>2)
21
22
23
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