financial indcrowd POS

	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
1	Financial Projections Template
2
3	Asumsi	Asumsi	Month 1	Month 2	Month 3	Month 4	Month 5	Month 6	Month 7	Month 8	Month 9	Month 10	Month 11	Month 12	Year 1 total	Month 13	Month 14	Month 15	Month 16	Month 17	Month 18	month 19	month 20	month 21	month 22	month 23	month 24	Year 2 Total
4	tingkat Perkembangan			20%	20%	20%	20%	20%	25%	25%	25%	25%	25%	25%		30%	30%	30%	30%	30%	30%	30%	30%	30%	30%	30%	30%
5	Key Driver 1 (Visit/Month)		1,200	1,440	1,728	2,074	2,488	2,986	3,732	4,666	5,832	7,290	9,113	11,391	53,939	14,808	19,250	25,025	32,533	42,293	54,980	71,474	92,917	120,792	157,029	204,138	265,380	1,154,559
6	Key Driver 2 (invested)		1	2	3	5	7	10	13	16	21	27	34	43	182	55	70	90	116	150	194	251	326	422	548	711	924	4,041
7	Key Driver 3 (investing)		24	29	35	41	50	60	75	93	117	146	182	228	1,079	296	385	501	651	846	1,100	1,429	1,858	2,416	3,141	4,083	5,308	23,091
8	Key Driver 4 (Tractions)		720	1,584	2,621	3,865	5,358	7,150	9,389	12,188	15,688	20,062	25,529	32,363	136,516	41,248	52,798	67,813	87,333	112,709	145,697	188,581	244,332	316,807	411,024	533,507	692,735	3,031,101
9
10	Revenue	Assumptions	Month 1	Month 2	Month 3	Month 4	Month 5	Month 6	Month 7	Month 8	Month 9	Month 10	Month 11	Month 12	Year 1 Total	Month 13	Month 14	Month 15	Month 16	Month 17	Month 18	Month 19	Month 20	Month 21	Month 22	Month 23	Month 24	Year 2 Total
11	company expenses CAC		Rp249,600	Rp309,120	Rp380,544	Rp466,253	Rp569,103	Rp692,524	Rp871,683	Rp1,095,632	Rp1,375,568	Rp1,725,488	Rp2,162,888	Rp2,709,638	Rp12,608,041	Rp3,511,538	Rp4,554,008	Rp5,909,219	Rp7,670,993	Rp9,961,300	Rp12,938,698	Rp16,809,316	Rp21,841,120	Rp28,382,465	Rp36,886,213	Rp47,941,085	Rp62,312,419	Rp271,326,415
12	Profit Sharing per tractions	Rp 3.000	Rp2,160,000	Rp4,752,000	Rp7,862,400	Rp11,594,880	Rp16,073,856	Rp21,448,627	Rp28,167,091	Rp36,565,171	Rp47,062,771	Rp60,184,771	Rp76,587,271	Rp97,090,396	Rp409,549,235	Rp123,744,459	Rp158,394,740	Rp203,440,106	Rp261,999,081	Rp338,125,749	Rp437,090,417	Rp565,744,486	Rp732,994,775	Rp950,420,151	Rp1,233,073,140	Rp1,600,522,026	Rp2,078,205,578	Rp9,093,303,943
13	Company profit after CAC		Rp1,910,400	Rp4,442,880	Rp7,481,856	Rp11,128,627	Rp15,504,753	Rp20,756,103	Rp27,295,408	Rp35,469,539	Rp45,687,203	Rp58,459,283	Rp74,424,383	Rp94,380,758	Rp396,941,195	Rp120,232,921	Rp153,840,732	Rp197,530,887	Rp254,328,088	Rp328,164,449	Rp424,151,719	Rp548,935,169	Rp711,153,655	Rp922,037,687	Rp1,196,186,928	Rp1,552,580,941	Rp2,015,893,158	Rp8,821,977,528
14
15	Headcount	Assumptions	Month 1	Month 2	Month 3	Month 4	Month 5	Month 6	Month 7	Month 8	Month 9	Month 10	Month 11	Month 12	Year 1 Total	Month 13	Month 14	Month 15	Month 16	Month 17	Month 18	Month 19	Month 20	Month 21	Month 22	Month 23	Month 24	Year 2 Total
16	CEO	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp48,000,000	Rp40,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp132,000,000
17	COO	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp48,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp96,000,000
18	CMO	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp48,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp96,000,000
19	CTO	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp48,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp96,000,000
20	CFO	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp48,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp4,000,000	Rp96,000,000
21	Legal	Rp2,500,000	Rp2,500,000	Rp2,500,000	Rp2,500,000	Rp2,500,000	Rp2,500,000	Rp2,500,000	Rp2,500,000	Rp2,500,000	Rp2,500,000	Rp2,500,000	Rp2,500,000	Rp2,500,000	Rp30,000,000	Rp2,500,000	Rp2,500,000	Rp2,500,000	Rp2,500,000	Rp2,500,000	Rp2,500,000	Rp2,500,000	Rp2,500,000	Rp2,500,000	Rp2,500,000	Rp2,500,000	Rp2,500,000	Rp60,000,000
22	Android Developer	Rp3,000,000													Rp0	Rp3,000,000	Rp3,000,000	Rp3,000,000	Rp3,000,000	Rp3,000,000	Rp3,000,000	Rp3,000,000	Rp3,000,000	Rp3,000,000	Rp3,000,000	Rp3,000,000	Rp3,000,000	Rp36,000,000
23	Ios Developer	Rp3,000,000													Rp0	Rp3,000,000	Rp3,000,000	Rp3,000,000	Rp3,000,000	Rp3,000,000	Rp3,000,000	Rp3,000,000	Rp3,000,000	Rp3,000,000	Rp3,000,000	Rp3,000,000	Rp3,000,000	Rp36,000,000
24	Data scientist	Rp2,500,000	Rp2,500,000	Rp2,500,000	Rp2,500,000	Rp2,500,000	Rp2,500,000	Rp2,500,000	Rp2,500,000	Rp2,500,000	Rp2,500,000	Rp2,500,000	Rp2,500,000	Rp2,500,000	Rp30,000,000	Rp2,500,000	Rp2,500,000	Rp2,500,000	Rp2,500,000	Rp2,500,000	Rp2,500,000	Rp2,500,000	Rp2,500,000	Rp2,500,000	Rp2,500,000	Rp2,500,000	Rp2,500,000	Rp60,000,000
25															Rp300,000,000													Rp708,000,000
26	Operating Expense														Year 1 Total
27	Rent for office	Rp70,000,000	Rp70,000,000												Rp70,000,000	Rp70,000,000												Rp140,000,000
28	Marketing (per month)	Rp2,500,000	Rp2,500,000	Rp2,500,000	Rp2,500,000	Rp2,500,000	Rp2,500,000	Rp2,500,000	Rp2,500,000	Rp2,500,000	Rp2,500,000	Rp2,500,000	Rp2,500,000	Rp2,500,000	Rp30,000,000	Rp2,500,000	Rp2,500,000	Rp2,500,000	Rp2,500,000	Rp2,500,000	Rp2,500,000	Rp2,500,000	Rp2,500,000	Rp2,500,000	Rp2,500,000	Rp2,500,000	Rp2,500,000	Rp60,000,000
29	Legal (per month)	Rp20,000,000	Rp20,000,000												Rp20,000,000													Rp20,000,000
30	Hosting (per month)	Rp4,500,000	Rp4,500,000												Rp4,500,000	Rp400,000												Rp4,900,000
31	Travel & Entertainment (per month)	Rp1,000,000	Rp1,000,000	Rp1,000,000	Rp1,000,000	Rp1,000,000	Rp1,000,000	Rp1,000,000	Rp1,000,000	Rp1,000,000	Rp1,000,000	Rp1,000,000	Rp1,000,000	Rp1,000,000	Rp12,000,000	Rp1,000,000	Rp1,000,000	Rp1,000,000	Rp1,000,000	Rp1,000,000	Rp1,000,000	Rp1,000,000	Rp1,000,000	Rp1,000,000	Rp1,000,000	Rp1,000,000	Rp1,000,000	Rp24,000,000
32	Miscellaneous (per month)	Rp3,000,000	Rp3,000,000	Rp3,000,000	Rp3,000,000	Rp3,000,000	Rp3,000,000	Rp3,000,000	Rp3,000,000	Rp3,000,000	Rp3,000,000	Rp3,000,000	Rp3,000,000	Rp3,000,000	Rp36,000,000	Rp3,000,000	Rp3,000,000	Rp3,000,000	Rp3,000,000	Rp3,000,000	Rp3,000,000	Rp3,000,000	Rp3,000,000	Rp3,000,000	Rp3,000,000	Rp3,000,000	Rp3,000,000	Rp72,000,000
33	Server costs (per month)	Rp500,000	Rp500,000												Rp500,000	Rp200,000												Rp700,000
34	Sub-Total		Rp126,500,000	Rp31,500,000	Rp31,500,000	Rp31,500,000	Rp31,500,000	Rp31,500,000	Rp31,500,000	Rp31,500,000	Rp31,500,000	Rp31,500,000	Rp31,500,000	Rp31,500,000	Rp173,000,000	Rp144,100,000	Rp37,500,000	Rp37,500,000	Rp37,500,000	Rp37,500,000	Rp37,500,000	Rp37,500,000	Rp37,500,000	Rp37,500,000	Rp37,500,000	Rp37,500,000	Rp37,500,000	Rp321,600,000
35														1 Year total Expenses	Rp473,000,000												Total expenses 2 Years	Rp1,029,600,000
36
37
38		Assumptions	Month 1	Month 2	Month 3	Month 4	Month 5	Month 6	Month 7	Month 8	Month 9	Month 10	Month 11	Month 12	1 year total	Month 13	Month 14	Month 15	Month 16	Month 17	Month 18	Month 19	Month 20	Month 21	Month 22	Month 23	Month 24	2 years total
39	pre-tax net profit		-Rp124,589,600	-Rp27,057,120	-Rp24,018,144	-Rp20,371,373	-Rp15,995,247	-Rp10,743,897	-Rp4,204,592	Rp3,969,539	Rp14,187,203	Rp26,959,283	Rp42,924,383	Rp62,880,758	-Rp76,058,805	-Rp23,867,079	Rp116,340,732	Rp160,030,887	Rp216,828,088	Rp290,664,449	Rp386,651,719	Rp511,435,169	Rp673,653,655	Rp884,537,687	Rp1,158,686,928	Rp1,515,080,941	Rp1,978,393,158	Rp7,792,377,528
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