Business/Revenue Planning Template: Three Years

	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
1		M1	M2	M3	M4	M5	M6	M7	M8	M9	M10	M11	M12	M13	M14	M15	M16	M17	M18	M19	M20	M21	M22	M23	M24	M25	M26	M27	M28	M29	M30	M31	M32	M33	M34	M35	M36

2	FINANCIAL VISIBILITY
3
4	OPENING BALANCE	0	-182,000	-344,000	-494,000	-696,400	-890,400	-1,094,400	-1,288,400	-1,487,400	-1,686,400	-1,966,400	-2,201,400	-2,911,400	-3,712,900	-4,392,800	-4,847,860	-5,764,354	-6,197,997	-6,628,862	-7,601,336	-8,160,852	-8,603,523	-9,079,795	-9,307,899	-9,398,384	-9,137,856	-8,286,626	-6,947,481	-5,035,047	-2,044,539	2,712,467	7,912,638	13,780,857	19,983,928	27,360,160	35,655,564
5
6	REVENUES	0	0	42,000	0	0	0	0	0	0	0	0	0	180,000	207,000	238,050	273,758	314,821	362,044	470,658	611,855	795,411	1,034,035	1,344,245	1,747,519	2,044,597	2,657,976	3,455,369	4,491,979	5,839,573	7,591,445	8,350,589	9,185,648	10,104,213	11,114,634	12,226,098	13,448,708
7	SALARY, TAX :: DUES	182,000	162,000	192,000	202,400	194,000	204,000	194,000	199,000	199,000	280,000	235,000	710,000	981,500	886,900	693,110	1,190,252	748,464	792,909	1,443,132	1,171,371	1,238,082	1,510,307	1,572,349	1,838,004	1,784,069	1,806,745	2,116,224	2,579,546	2,849,065	2,834,439	3,150,418	3,317,430	3,901,143	3,738,402	3,930,695	4,220,217
8
9	PROFIT/LOSS	-182,000	-344,000	-494,000	-696,400	-890,400	-1,094,400	-1,288,400	-1,487,400	-1,686,400	-1,966,400	-2,201,400	-2,911,400	-3,712,900	-4,392,800	-4,847,860	-5,764,354	-6,197,997	-6,628,862	-7,601,336	-8,160,852	-8,603,523	-9,079,795	-9,307,899	-9,398,384	-9,137,856	-8,286,626	-6,947,481	-5,035,047	-2,044,539	2,712,467	7,912,638	13,780,857	19,983,928	27,360,160	35,655,564	44,884,055
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
50
51
52
53
54
55
56
57
58
59
60
61
62