Financial Model Template - With Scenarios

	A	B	C	D	E	F	G	H	I	J
1	Category	Year 1			Year 2			Year 3
2		Best	Worst	Most Likely	Best	Worst	Most Likely	Best	Worst	Most Likely
3	Revenue
4	Game Sales	0	0	0	250,000	1,000	100,000	350,000	1,000	100,000
5	In-App Purchases	0	0	0	25,000	100	1,000	45,000	100	15,000
6	Service Work	90,000	30,000	60,000	108,000	30,000	45,000	129,600	36,500	54,000
7	Grants	15,000	0	15,000	50,000	0	15,000	75,000	0	50,000
8	Investment	150,000	0	75,000	0	0	75,000	0	0	75,000
9	Total Revenue	255,000	30,000	150,000	433,000	31,100	236,000	599,600	37,600	294,000
10	Expenses
11	Salaries	90,000	12,000	60,000	180,000	24,000	120,000	300,000	30,000	240,000
12	Development Costs	30,000	10,000	20,000	45,000	6,000	20,000	67,500	6,000	20,000
13	Equipment	15,000	6,000	9,000	0	0	0	0	0	0
14	Depreciation	1,500	600	900	1,500	600	900	1,500	600	900
15	Marketing & Advertising	0	0	0	22,500	0	10,000	33,750	500	15,000
16	Software & Licenses	1,500	500	500	2,000	500	1,000	2,000	500	1,500
17	Travel	5,000	0	0	15,000	0	15,000	25,000	0	15,000
18	Miscellaneous	3,000	0	0	4,500	0	1,000	6,750	0	1,500
19	Total Expenses	146,000	29,100	90,400	270,500	31,100	167,900	436,500	37,600	293,900
20	Net Income	109,000	900	59,600	162,500	0	68,100	163,100	0	100
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