Statement of Profit or Loss and Other Comprehensive Income For The Year Ended 31 December 2018
Statement of Profit or Loss and Other Comprehensive Income For The Year Ended 31 December 2018
Statement of Profit or Loss and Other Comprehensive Income For The Year Ended 31 December 2018
EBITDA
Finance income
Finance costs
Net foreign exchange losses
Depreciation and amortisation
Non-recurring expenses
Profit before income tax expense
Income tax expense
Profit for the year
Other comprehensive income
Other comprehensive income not to be reclassified to
profit or loss in subsequent periods (net of tax)
Effect of changes in tax legislation
Net other comprehensive income not to be reclassified to
profit or loss in subsequent periods
Other comprehensive income for the year, net of tax
Total comprehensive income for the year, net of tax
Current assets
Inventories
Trade and other receivables
Loans issued
Current income tax assets
Prepaid taxes other than income tax
Prepayments
Derivative financial assets
Restricted cash
Cash at bank
Total curret assets
Total assets
Equity
Charter capital
Additional paid-in capital
Accumulated deficit
Revaluation reseve
Other reserves
Total equty
Liabilities
Non-current liabilities
Borrowings
Deferred revenue
Total non-current liabilities
Current liabilities
Borrowings
Advances received
Trade and other payables
Deferred revenue
Derivative financial liabilities
Provisions for liabilities and charges
Current income tax liability
Other taxes payable
Total current liabilities
Total liabilities
(231) 2 (755)
3,404 1,738 2,122
(16,328) (10,892) (7,400)
(61,417) (55,027) (48,308)
67,998 63,697 66,138
8,364 5,049 2,177
(15,983) (13,793) (11,291)
(3,804) (695) (62)
(22,526) (17,771) (15,625)
(6,034) (1,709) −
28,015 34,778 41,337
- - (1,962)
28,015 34,778 39,375
− 26,150
−
26,150
− 26,150
28,015 34,778 65,525
2018 2017 2016
494,947 397,332 300,596
8,644 10,138 17,806
184 111 146
45,493 49,531 12,690
- - 5,094
1,874 6,974 1,908
551,142 464,086 338,240
Formulas
(Total Asset-total equity)/Total Assets
Total Debt/Total Equity
Total assets/Total equities
EBIT/interest
EBITDA/interest
Formulas
COGS/Av.Inventory
365/Inventory Turnover
Revenue/Av. Acc.Rec.
365/Acc.Rec.Turnover
Sales/Total Assets
Total Assets/Sales
Formulas
Net Profit/Revenue
Net Income/Total Assets
Net income/Total Equity
Profit Margin*Asset turnover*Equity Multiplier
Formulas
Stock Price Per Share/Earnings Per Share
(Net Income-Prefered Dividends)/Number of Shares
Enterprise value/EBITDA
Projected income statements
2018 2019 2020
Revenue from water supply 118,679 133,158 149,403
Revenue from electric power sales 6,061 6,007 6,147
Other revenue 4,675 6,015 6,307
Total revenue 129,415 145,180 161,857
Salaries and other employee benefits (17,218) (18,309) (20,100)
Electricity and transmission costs (13,226) (13,108) (13,413)
Allowance for expected credit losses / allowance for impairment
of trade receivables (4,064) (2,072) (2,264)
Taxes other than income tax (3,753) (3,341) (3,478)
General and administrative expenses (3,464) (3,943) (4,488)
Professional fees (2,391) (2,165) (2,165)
Maintenance expenditure (2,135) (2,674) (2,674)
Raw materials, fuel and other consumables (2,011) (2,256) (2,532)
(Charge for) / reversal of provisions and legal claims related
expenses (231) - -
Other income 3,404 - -
Other operating expenses (16,328) (11,540) (12,920)
(61,417) (59,409) (64,033)
EBITDA 67,998 85,772 97,824
Finance income 8,364 7,574 8,324
Finance costs (15,983) (26,540) (25,377)
Net foreign exchange losses (3,804) - -
Depreciation and amortisation (22,526) (25,926) (28,518)
Non-recurring expenses (6,034) - -
Profit before income tax expense 28,015 40,880 52,252
Income tax expense -
Profit for the year 28,015 40,880 52,252
Other comprehensive income
Other comprehensive income not to be reclassified to
profit or loss in subsequent periods (net of tax)
Effect of changes in tax legislation
Net other comprehensive income not to be reclassified to
profit or loss in subsequent periods
Other comprehensive income for the year, net of tax
Total comprehensive income for the year, net of tax 28,015 40,098 52,062
2021 2022 2023
157,329 165,675 174,463
6,493 7,524 9,001
6,649 7,160 7,426
170,470 180,358 190,890
(22,782) (26,657) (32,202)
(14,169) (16,418) (19,641)
- - -
- - -
(13,596) (12,685) (13,067)
(69,015) (74,169) (83,907)
101,456 106,189 106,983
9,074 9,824 10,574
(24,879) (24,329) (23,721)
- - -
(29,374) (30,255) (31,163)
- - -
56,277 61,429 62,673
Current assets
Inventories
Trade and other receivables
Loans issued
Current income tax assets
Prepaid taxes other than income tax
Prepayments
Derivative financial assets
Restricted cash
Cash at bank
Total curret assets
Total assets
Equity
Charter capital
Additional paid-in capital
Accumulated deficit
Revaluation reseve
Other reserves
Total equty
Liabilities
Non-current liabilities
Borrowings
Deferred revenue
Total non-current liabilities
Current liabilities
Borrowings
Advances received
Trade and other payables
Deferred revenue
Derivative financial liabilities
Provisions for liabilities and charges
Current income tax liability
Other taxes payable
Other liabilities
Total current liabilities
Total liabilities
($25,828.09)
($25,377.20)
($24,879.10)
($24,328.84)
($23,720.96)
2016 2017 2018 2019 2020 2021 2022 2023
300,596 397,332 494,947 544,442 598,886 616,852 635,358 654,419
17,806 10,138 8,644 8,644 8,644 8,644 8,644 8,644
146 111 184 184 184 184 184 184
12,690 49,531 45,493 50,493 55,493 60,493 65,493 70,493
5,094 - - - - - - -
1,908 6,974 1,874 1,874 1,874 1,874 1,874 1,874
338,240 464,086 551,142 605,637 665,081 688,047 711,553 735,614
- - - - - - - -
2019 2020 2021 2022
PPE growth rate 10% 10% 3% 3%
Property, plant and equipment 544,442 598,886 616,852 635,358
Depreciation 25,926 28,518 29,374 30,255
Loans issued 50,493 55,493 60,493 65,493
interest 7,573.95 8,324 9,074 9,824
A/R days 60 70 50 40
A/R 28,758 33,324 13,381 26,150
interest on borrowing -25,591.31 -25,115.62 -24,590.13 -24,009.61
2,917 3,501
265,656 265,656
0 0
0 0
PVs
terminal value
enterprise value
net debt
Equity value
NWC 6,566
2018 2019 2020 2021 2022 2023
90,524 111,697 126,342 130,830 136,445 138,146
85% 85% 85% 85% 85% 85%
22,526 25,926 28,518 29,374 30,255 31,163
120,141 75,420 82,963 47,341 48,761 50,224
(12,297) (56,563) (44,120) (68,799) (35,269) (42,480)
(32,966.60) (11,114.63) 8,826.55 24,440 62,203 55,883
0 1 2 3 4 5
(32,967) (9,546) 6,511 15,483 33,845 26,115 21,351.38
72,408
9,978
82,386
288,148
(205,762)