Financial Model of sandy sandwich Pvt Ltd.xlsx

	B	C	D	E	F	G
1
2	Sandy Sandwich Pvt Ltd
3
4	Profit & Loss Statement
5
6
7	Particulars	Amount (₹)		Y1	Y2	Y3
8	Revenue	999,600		1,685,326	2,519,562	4,251,379
9	COGS	-299,880		(505,598)	(705,477)	(1,105,359)
10	Gross Profit	699,720		1,179,728	1,814,084	3,146,021
11	% Gross margin	70%		70%	72%	74%
12	Employee Benefit	200,000		(480,000)	(1,008,000)	(1,382,400)
13	SG&A	40,000		(817,451)	(1,530,250)	(1,762,727)
14	EBITDA	459,720		-117,723	-724,165	894
15	Margin	46%		-6.99%	-28.74%	0.02%
16	Deperciation and amortization	18,000	CFO/CFI	-64,500	-129,500	-129,500
17	Interest	15,000	cfo/cff	-28,093	-49,697	-20,213
18	Profit Before Tax	426,720		-210,316	-903,362	-148,819
19	Tax @20%	85,344		0	0	0
20	Net Profit	341,376	CFO	-210,316	-903,362	-148,819
21	Profit Margin	34%		-12%	-36%	-4%
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