Investor Presentaiton
IV Appendix
Income Statement
IN
In EGP
Gross Revenue
Net Revenue
Cost of Revenue
2014
2015
2016
9M16
9M17
4,301,431,071
4,197,291,157
(3,889,571,576)
5,437,428,208
5,326,037,025
(4,931,515,024)
7,368,955,861
7,202,471,767
(6,636,864,499)
5,110,598,478
5,004,538,429
(4,584,670,320)
6,872,056,337
6,715,209,995
(6,117,421,392)
Gross Profit
307,719,581
394,522,001
Total General & Administrative
(43,965,382)
(54,746,924)
565,607,268
(86,392,050)
419,868,109
597,788,603
(58,157,217)
(74,191,616)
Recurring & Operational General & Administrative
(37,275,415)
(49,634,827)
(86,305,323)
(55,518,802)
Non-operational & Non-recurring Balances included in General & Administrative
(6,689,967)
(5,112,097)
(86,727)
(2,638,415)
Selling & Marketing
(144,135,752)
(188,349,279)
(246,444,706)
(175,266,069)
(74,064,392)
(127,224)
(235,780,087)
Provisions on Doubtful Receivables
(5,776,118)
(6,475,000)
(13,338,388)
(9,880,388)
(2,065,497)
Fixed Assets Depreciation
Total Other Income
Other Income
Penalties on Returned Checks
Transportation Income
Capital Gain
Impairment for Debtors & Other Debit Balances
Provisions for Claims
FX Gain/Loss
Non-recurring Expense
EBIT
Interest Expense
Working Capital
(10,328,474)
(17,721,410)
Amortization of Company Share in Finance Leased Assets
(708,637)
(1,071,088)
(24,713,506)
(2,076,237)
(18,051,022)
(1,516,474)
2,158,942
5,330,849
9,704,719
3,664,314
282,250
343,663
614,231
1,791,692
3,296,186
5,579,494
307,646
3,356,666
(20,717,219)
(1,892,261)
9,932,542
897,206
9,035,336
85,000
1,691,000
3,510,994
7,119,374
1,376,700
2,750,360
693,691
1,989,503
(937,396)
(200,000)
(1,000,000)
(600,000)
(2,500,000)
(90,086)
152,369
5,772,434
1,360,152
111,056,052
132,218,407
207,369,983
162,715,096
42,109
(4,111,579)
270,994,498
(48,879,962)
(56,330,766)
(74,272,012)
(55,788,855)
(83,916,773)
(47,677,527)
(53,533,569)
(70,136,656)
(52,826,089)
(77,059,546)
Medium Term Loans
(1,202,435)
(2,797,197)
(4,135,355)
(2,962,766)
(6,857,227)
Interest Income
EBT
79,404
62,255,494
75,887,641
133,097,972
106,926,241
187,077,725
Deferred Tax
(2,379,078)
3,034,600
4,792,756
Income Tax (Expense) Benefit
(22,335,421)
(21,563,921)
Net Profit
37,540,995
57,358,320
(36,142,877)
101,747,851
In EGP
Pro Forma Revenue¹
Cost of Revenue
Gross Profit
Gross Profit Margin (%)
EBITDA
EBITDA Margin (%)
Net Profit
Net Profit Margin
2014
2015
2016
4,301,516,071
(3,889,571,576)
307,804,5812
7.16%
122,408,988
2.85%
37,540,995
0.87%
5,439,119,208
(4,931,515,024)
396,213,1902
7.28%
155,050,271
2.85%
57,358,320
1.05%
7,372,466,698
(6,636,864,499)
569,118,3512
7.72%
228,609,428
3.10%
101,747,850
1.38%
182,559,516
3.57%
81,675,136
294,913,963
1.60%
4.29%
143,079,626
2.08%
4,102,477
(29,353,582)
81,675,136
9M 2016
5,110,598,478
(4,584,670,320)
419,868,109
8.22%
(409,305)
(43,588,794)
143,079,626
9M 2017
6,872,056,337
(6,117,421,392)
597,788,603
8.70%
Source: Company Management
(1) Pro forma gross revenue includes transportation revenue that was stated as other income until 2016; (2) Includes transportation revenue
ibnsinapharma
25View entire presentation