IDHC-2-2-2-3.xlsx

	C	F	G	H	I	J	K	L	M	N	O	P	Q
1	IDHC			Historical Results					Projection Period
2
3	Amounts are in EGP (Mn)	Unit	Constant	2017	2018	2019	2020	2021	2022	2023	2024	2025	2026

4
5	Income Statement
6	Sales Revenue			1٬514	1٬921	2٬226	2٬656	5٬048	4٬973	5٬703	6٬438	7٬255	8٬158
7	COGS			(723)	(896)	(989)	(1٬128)	(2٬182)	(2٬200)	(2٬470)	(2٬739)	(3٬047)	(3٬393)
8	Gross Profit			791	1٬026	1٬237	1٬528	2٬866	2٬774	3٬233	3٬699	4٬208	4٬765
9	SG&A			(186)	(255)	(305)	(329)	(533)	(619)	(710)	(801)	(903)	(1٬016)
10	EBITDA			605	771	932	1٬199	2٬333	2٬155	2٬523	2٬897	3٬305	3٬750
11	Amortization			(5)	(6)	(7)	(6)	(7)	(7)	(7)	(7)	(7)	(7)
12	Depreciation of PPE			(57)	(71)	(147)	(119)	(152)	(186)	(242)	(301)	(363)	(429)
13	Depreciation of right of use assets			0	0	0	(61)	(80)	(105)	(145)	(186)	(227)	(269)
14	EBIT			543	693	779	1٬013	2٬094	1٬857	2٬129	2٬403	2٬708	3٬045
15	Impairment loss on trade and other recievables			(6)	(10)	(9)	(42)	(25)	(25)	(25)	(25)	(25)	(25)
16	Other Income			3	1	21	14	16	14	14	14	14	14
17	Finance Cost			(33)	(31)	(80)	(84)	(143)	(59)	(67)	(74)	(82)	(92)
18	Finance Income			51	63	47	68	113	68	113	68	113	68
19	EBT			558	717	758	969	2٬056	1٬854	2٬165	2٬387	2٬729	3٬011
20	Income Tax expense			(175)	(220)	(254)	(360)	(740)	(649)	(758)	(835)	(955)	(1٬054)
21	Net Profit for the year		-8٫39%	384	497	505	609	1٬316	1٬205	1٬407	1٬551	1٬774	1٬957
22	Non Controlling interest			10	(5)	(6)	15	80	80	80	80	80	80
23	Net Profit for the parent company			374	502	511	594	1٬236	1٬125	1٬327	1٬471	1٬694	1٬877
24	No. of shares			150	150	600	600	600	600	600	600	600	600
25	EPS			2٫49	3٫35	0٫85	0٫99	2٫06	1٫88	2٫21	2٫45	2٫82	3٫13
26
27	Balance Sheet Statement
28
29	Current Assets
30
31	Financial assets at amortized cost			0	0	0	277	1٬459	1٬459	1٬459	1٬459	1٬459	1٬459
32	Inventories			70	91	84	100	223	191	214	238	264	294
33	Trade and other receivables			202	300	323	383	470	669	767	866	976	1٬097
34	Restricted cash			13	12	0	0	0	0	0	0	0	0
35	Other investments			9	240	222	0	0	0	0	0	0	0
36	Cash and cash equivalents			685	413	409	600	891	793	861	911	1٬029	1٬144
37	Total Current Assets			980	1٬056	1٬038	1٬360	3٬043	3٬111	3٬301	3٬473	3٬728	3٬994
38
39	Non Current Assets
40
41	Financial assets at fair value through profit and loss			0	0	0	10	10	10	10	10	10	10
42	Right of use assets			0	0	265	355	462	640	818	998	1٬183	1٬377
43	Other investments			0	0	6	0	0	0	0	0	0	0
44	Property, plant and equipment			474	706	786	793	1٬062	1٬382	1٬720	2٬074	2٬449	2٬850
45	Intangible assets and goodwill			1٬658	1٬672	1٬661	1٬660	1٬659	1٬652	1٬644	1٬637	1٬630	1٬623
46	Total non-current assets			2٬132	2٬378	2٬718	2٬817	3٬194	3٬684	4٬193	4٬719	5٬272	5٬860
47
48	Total Assets			3٬112	3٬434	3٬755	4٬177	6٬236	6٬795	7٬494	8٬192	9٬000	9٬855
49
50	Current Liabilities
51
52	Current put option liability			0	0	0	282	921	921	921	921	921	921
53	ShortTerm Financial obligation			0	157	261	61	115	115	115	115	115	115
54	Trade and other payables			333	287	320	384	777	824	926	1٬026	1٬142	1٬271
55	Loans and borrowings			15	25	25	25	22	25	25	25	25	25
56	Current tax liabilities			137	200	222	258	513	484	544	603	671	747
57	Total Current Liabilities			485	669	828	1٬009	2٬349	2٬371	2٬532	2٬692	2٬875	3٬081
58
59	Non Current Liabilities
60
61	Deferred tax liabilities			159	168	174	240	332	332	332	332	332	332
62	Other provisions			15	15	5	3	4	4	4	4	4	4
63	Loans and borrowings			38	101	81	68	76	72	57	40	21	0
64	Non current Put option liability			0	0	0	32	35	35	35	35	35	35
65	Long-term financial obligations			100	79	306	399	645	581	523	470	423	381
66	Total Non Current Liabilities			312	364	567	742	1٬093	1٬023	951	882	816	752
67
68	Total Liabilities			798	1٬033	1٬395	1٬751	3٬442	3٬394	3٬482	3٬573	3٬691	3٬833
69
70	Equity
71
72	Share capital			1٬073	1٬073	1٬073	1٬073	1٬073	1٬073	1٬073	1٬073	1٬073	1٬073
73	Share premium reserve			1٬028	1٬028	1٬028	1٬028	1٬028	1٬028	1٬028	1٬028	1٬028	1٬028
74	Capital reserves			(314)	(314)	(314)	(314)	(314)	(314)	(314)	(314)	(314)	(314)
75	Legal reserve			33	38	46	49	52	56	66	74	85	94
76	Put option reserve			(93)	(145)	(229)	(314)	(956)	(314)	(314)	(314)	(314)	(314)
77	Translation reserve			204	195	156	146	151	151	151	151	151	151
78	Retained earnings			316	397	457	603	1٬551	1٬510	2٬111	2٬711	3٬390	4٬094
79	Equity attributable to the owners of the Company			2٬246	2٬270	2٬216	2٬270	2٬583	3٬189	3٬800	4٬407	5٬098	5٬810
80	Non Controlling Interest			69	131	145	156	212	212	212	212	212	212
81	Total Equity			2٬314	2٬401	2٬360	2٬426	2٬794	3٬401	4٬012	4٬619	5٬309	6٬022
82
83	Total Liabilities and Equity			3٬112	3٬434	3٬755	4٬177	6٬236	6٬795	7٬494	8٬192	9٬000	9٬855
84
85	Check			0	0	(0)	0	0	(0)	0	0	(0)	(0)
86
87
88
89	Cash Flow Statement
90
91	Cash Flow from Operating Activities
135
136	Financial Ratios
137
138	Liquidity Ratios:
139
140	Current ratio		1٫5	2٫0	1٫6	1٫3	1٫3	1٫3	1٫3	1٫3	1٫3	1٫3	1٫3
141	Quik ratio		1٫4	1٫9	1٫4	1٫2	1٫2	1٫2	1٫2	1٫2	1٫2	1٫2	1٫2
142	Cash ratio		0٫7	1٫4	0٫6	0٫5	0٫6	0٫4	0٫3	0٫3	0٫3	0٫4	0٫4
143