Mitigata MIS Projections FY- 2023-2026.xlsx

	A	B	C	D
1	PROFIT AND LOSS STATEMENT
2
3		Sep 2023	Oct 2023	Nov 2023
4	Revenue	41,917	157,713	408,200
5	Operational Expenses	11,787	24,600	18,786
6
7	GROSS INCOME	30,131	133,114	389,415
8	GM %	71.88%	84.40%	95.40%
9
10	Marketing Expenses	0	0	0
11	CONTRIBUTION MARGIN (CM)	41,917.38	157,713.47	408,200.49
12	CM %	100.00%	100.00%	100.00%
13
14	Rent and Utilities	9,316	6,048	0
15	Salary Cost	244,200	229,200	202,200
16	Corporate Overheads (Inc. Tech Infra, Travel, Ops, Softwares)	142,047	165,496	199,026
17	Others	8,068	1,581	0
18	Employee Benefits	0	0	0
19	Total Operational Expenses	403,631	402,325	401,226
20
21	EBIDTA	-365,955	-240,822	61,665
22
23	Interest Expenses (on loan taken)	0	0	0
24	PBT	-373,501	-269,211	-11,811
25
26	Taxes	7545	28388	73476
27	NET INCOME	-369,259	-273,000	-66,502
28	NM %	-880.92%	-173.10%	-16.29%
29
30
31	Net Burn (Actual cash burn)	11,787	24,600	18,786
32	Cash & Bank Balance			2,236,536
33	Runway (in months)			5
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