Simple Startup Cashflow Projections - sendwithses.com

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1																10%	10%	<----YoY Inflation
2	ASSUMPTIONS/PROJECTIONS		Month-1	M-2	M-3	M-4	M-5	M-6	M-7	M-8	M-9	M-10	M-11	M-12	YEAR-1	YEAR-2	YEAR-3

3	SMALL Plan Cost	a	15	15	15	15	15	15	15	15	15	15	15	15	15	15	15
4	Small Plan Paying Subscribers	b	0	0	3	10	25	40	50	65	95	120	160	195	195	350	550
5	MEDIUM Plan Cost	c	150	150	150	150	150	150	150	150	150	150	150	150	150	150	150
6	Medium Plan Paying Subscribers	d	0	0	3	5	7	10	15	18	18	20	20	25	25	60	125
7	LARGE Plan Cost	e	1,500	1,500	1,500	1,500	1,500	1,500	1,500	1,500	1,500	1,500	1,500	1,500	1,500	1,500	1,500
8	Large Plan Paying Subscribers	f	0	0	0	0	1	2	3	3	4	4	5	5	5	10	15
9	Number of Employees	g	2	2	3	3	3	3	3	3	3	4	4	4	4	5	6
10	Avg. Salary (CTC) Per Employee	h	4,000	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,500
11
12
13	INCOME
14	Small Plan Revenue	i = (a * b)	0	0	45	150	375	600	750	975	1,425	1,800	2,400	2,925	11,445	63,000	99,000
15	Medium Plan Revenue	j = (c * d)	0	0	450	750	1,050	1,500	2,250	2,700	2,700	3,000	3,000	3,750	21,150	108,000	225,000
16	Large Plan Revenue	k = (e * f)	0	0	0	0	1,500	3,000	4,500	4,500	6,000	6,000	7,500	7,500	40,500	180,000	270,000
17	Other Revenue - 1	l
18	Other Revenue - 2	m
19	TOTAL INCOME		0	0	495	900	2,925	5,100	7,500	8,175	10,125	10,800	12,900	14,175	73,095	351,000	594,000
20
21
22	EXPENDITURE
23	Sales, Marketing, Advertising	n	1,500	1,500	1,500	2,000	2,000	2,000	2,500	2,500	2,500	3,000	3,000	3,000	27,000	29,700	32,670
24	Server Costs	o	500	500	500	500	500	500	750	750	750	750	750	750	7,500	8,250	9,075
25	Salaries	p = (g * h)	8,000	8,000	12,000	12,000	12,000	12,000	12,000	12,000	12,000	16,000	16,000	16,000	148,000	300,000	396,000
26	Rent of Office	q	2,500	2,500	2,500	2,500	2,500	2,500	2,500	2,500	2,500	2,500	2,500	2,500	30,000	33,000	36,300
27	Utilities of Office (Power, Water, etc)	r	250	250	250	250	250	250	250	250	250	250	250	250	3,000	3,300	3,630
28	Hardware and Software Purchases	s	10,000	0	0	0	0	0	15,000	0	0	0	0	0	25,000	27,500	30,250
29	Printing, Stationery	t	50	50	50	50	50	50	50	50	50	50	50	50	600	660	726
30	Travel	u	500	500	500	500	500	500	500	500	500	500	500	500	6,000	6,600	7,260
31	Legal Expenses	v	1,000	0	0	0	0	0	1,000	0	0	0	0	0	2,000	2,200	2,420
32	Bank Charges	w	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
33	Payment Gateway Charges	x	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
34	Other Expenses - 1	y	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
35	Other Expenses - 2	z	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
36	TOTAL EXPENDITURE		24,300	13,300	17,300	17,800	17,800	17,800	34,550	18,550	18,550	23,050	23,050	23,050	249,100	411,210	518,331
37
38
39	PROFIT/LOSS		-24,300	-13,300	-16,805	-16,900	-14,875	-12,700	-27,050	-10,375	-8,425	-12,250	-10,150	-8,875	-176,005	-60,210	75,669
40	Cumulative PROFIT/LOSS		-24,300	-37,600	-54,405	-71,305	-86,180	-98,880	-125,930	-136,305	-144,730	-156,980	-167,130	-176,005	-176,005	-236,215	-160,546
41
42	Made by:
43	Send With SES / sendwithses.com
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