Projections for next 3 years.xlsx

	A	B	C	D	E
1	INFICOLD INDIA PRIVATE LIMITED
2
3	Projected Financials				(INR in Million)
4
5	Particulars	2023-24	2024-25	2025-26	2026-27
6
7	Revenue from Operations	183.5	389.0	649.7	1,266.8
8
9	Cost of Goods Sold	99.3	188.7	320.7	609.4
10
11	Gross Margin	84.2	200.4	328.9	657.4
12	Gross Margin %	46%	52%	51%	52%
13
14	Freight Outward	9.6	19.0	31.0	57.0
15
16	Contribution Margin1	74.6	181.4	297.9	600.4
17	Contribution Margin1 %	40.7%	46.6%	45.9%	47.4%
18
19	Sales & Marketing	3.1	8.0	12.0	20.0
20
21	Contribution Margin2	71.5	173.4	285.9	580.4
22	Contribution Margin2 %	39%	45%	44%	46%
23
24	Business & Product R&D	3.9	7.8	13.0	25.3
25	Team (Excl. R&D and Marketing	25.1	54.5	71.0	97.4
26	Other SG&A	20.0	42.8	57.5	80.4
27
28	Operating EBITDA	22.5	68.3	144.4	377.3
29	Operating EBITDA %	12%	18%	22%	30%
30
31	Interest	0.05	0.01	0.01	0.01
32	Depreciation	0.12	0.10	0.09	0.08
33
34	PBT	22.30	68.20	144.33	377.22
35
36	Income Tax @ 30%	6.69	20.46	43.30	113.16
37
38	PAT	15.61	47.74	101.03	264.05
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60		54%	48%	49%	48%
61
62	Fixed Expenses	34026936	61248485	85747879	120047030
63		#REF!	#REF!	#REF!	#REF!
64
65	Variable Expenese	22371385	47427336	85369205	187812251
66		#REF!	#REF!	#REF!	#REF!
67
68	EBITDA	#REF!	#REF!	#REF!	#REF!
69	Percentage	#REF!	#REF!	#REF!	#REF!
70
71	Interest	543763	50000.000	53000.000	58000.000
72	Depreciation	1234427	1049263	944337	802686
73
74	PBT	#REF!	#REF!	#REF!	#REF!
75	Income Tax @ 30%	#REF!	#REF!	#REF!	#REF!
76	PAT	#REF!	#REF!	#REF!	#REF!
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100