7th Nov 2018 13:57
Nasr City 9-2018E
REPORT OF THE INDEPENDENT AUDITOR ON THE
SUMMARY INTERIM SEPARATE FINANCIAL STATEMENTS
TO THE BOARD OF DIRECTORS OF
Madinet Nasr for Housing & Development S.A.E.
We have reviewed the interim separate financial statements of Madinet Nasr for Housing & Development S.A.E. for the period from 1 January 2018 to 30 September 2018, from which the attached summary interim separate financial statements are derived, in accordance with the Egyptian Standards on Auditing and the relevant laws and regulations. As stated in our Arabic review report dated 5 November 2018, we expressed an unqualified review conclusion on the interim separate financial statements for the period then ended, from which the attached summary interim separate financial statements are derived.
In our opinion, the attached summary interim separate financial statements are consistent in all material respects, with the interim separate financial statements for the period then ended.
In order to obtain a comprehensive understanding of the company's separate financial position as of 30 September 2018, the results of its operations for the period then ended and our scope of limited review, you should refer to the Arabic interim separate financial statements for the period then ended and our review report thereon.
Mohanad T. Khaled
Fellow of ACCA
Fellow of ESAA
R.A.A. 22444
FRA No. 375
Cairo, 5 November 2018
Madinet Nasr for Housing & Development S.A.E.
SEPARATE STATEMENT OF FINANCIAL POSITION
At 30 September 2018
|
| 30/9/2018 | 31/12/2017 |
| Note | L.E. | L.E. |
Non current Assets |
|
|
|
Fixed assets (Net) | 4/1 | 42,317,921 | 38,984,793 |
Projects under construction | 4/2 | 16,623,700 | 12,287,797 |
Investment in subsidiaries | 5/1 | 64,900,606 | 45,381,960 |
Held to maturity investments | 5/2 | 121,962 | 121,962 |
Available for sale investments | 5/3 | 4,514,110 | 4,514,110 |
Investment properties | 5/4 | 4,302,885 | 4,348,677 |
Long term notes receivables (Net) | 7 | 5,950,949,725 | 5,144,994,601 |
Amounts due from related parties | 30 | 4,137,508 | 10,000,000 |
Deferred tax assets | 20 | 1,610,248 | 1,665,597 |
Total non current assets |
| 6,089,478,665 | 5,262,299,497 |
|
|
|
|
Current Assets |
|
|
|
Housing & development projects - WIP | 6 | 1,288,920,178 | 1,279,706,549 |
Housing & development projects - Finished properties | 6 | 78,545,713 | 78,262,306 |
Short term notes receivable | 7 | 1,997,262,337 | 1,576,608,078 |
Trade and notes receivables (Net) | 7 | 358,844,265 | 173,561,775 |
Trade payables - debit balances (Net) | 8/1 | 83,845,735 | 104,266,797 |
Debtors and other debit balances | 9 | 230,056,452 | 174,086,839 |
Investments at fair value through profit or loss | 5/5 | 11,795,565 | 10,807,609 |
Bank deposits for projects maintenance | 19 | 281,969,104 | 192,332,965 |
Cash and bank balances | 10 | 448,223,952 | 203,923,463 |
Total current assets |
| 4,779,463,301 | 3,793,556,381 |
Total assets |
| 10,868,941,966 | 9,055,855,878 |
|
|
|
|
Equity |
|
|
|
Issued and paid up capital | 16 | 1,200,000,000 | 997,100,389 |
Legal reserve |
| 170,478,648 | 123,313,788 |
Retained earnings |
| 894,645,685 | 296,577,953 |
Net profit for the period/year |
| 816,746,282 | 943,297,203 |
Total shareholders' equity |
| 3,081,870,615 | 2,360,289,333 |
|
|
|
|
Non-current Liabilities |
|
|
|
Unearned revenue | 11 | 6,332,433,883 | 5,119,108,765 |
Term loans | 17 | 103,703,828 | 207,152,774 |
Total Non-current liabilities |
| 6,436,137,711 | 5,326,261,539 |
|
|
|
|
Current Liabilities |
|
|
|
Provisions | 12 | 69,482,824 | 70,061,807 |
Project infrastructure completion liabilities | 13 | 127,113,683 | 170,827,359 |
Creditors and other credit balances | 15 | 183,760,341 | 229,511,508 |
Current portion of long term loans | 17 | 160,647,533 | 177,892,520 |
Short term loans | 18 | 195,416,666 | 56,875,747 |
Bank's overdraft (credit facilities) | 18 | 38,130,134 | 91,216,797 |
Creditors of deposits for projects maintenance | 19 | 282,379,448 | 192,401,793 |
Trade payables | 8/2 | 37,516,417 | 95,018,306 |
Tax Authority |
| 237,448,549 | 279,044,422 |
Dividends payable |
| 19,038,045 | 6,454,747 |
Total current liabilities |
| 1,350,933,640 | 1,369,305,006 |
Total liabilities |
| 7,787,071,351 | 6,695,566,545 |
Total Equity and Liabilities |
| 10,868,941,966 | 9,055,855,878 |
Review report "attached".
CFO | Managing Director | Chairman |
Mr. Mohamed Abdelsalam | Eng. Ahmed Ali ElHetmy | Eng. Mohamed Hazem Barakat |
Madinet Nasr for Housing & Development S.A.E.
SEPARATE STATEMENT OF INCOME
For the period from 1 January to 30 September 2018
|
| From 1/1/2018 to 30/9/2018 | From 1/1/2017 to 30/9/2017 | From 1/7/2018 to 30/9/2018 | From 1/7/2017 to 30/9/2017 |
| Note | L.E. | L.E. | L.E. | L.E. |
|
|
|
|
|
|
Net revenue | 22-a | 1,725,348,975 | 1,503,955,367 | 702,806,821 | 464,573,403 |
Less: |
|
|
|
|
|
Cost of revenue | 22-b | (438,624,182) | (354,903,393) | (335,500,393) | (96,562,820) |
Gross Profit |
| 1,286,724,793 | 1,149,051,974 | 367,306,428 | 368,010,583 |
Less: |
|
|
|
|
|
Selling & marketing expenses | 23 | (145,494,638) | (136,525,378) | (25,128,477) | (41,718,798) |
General & administrative expenses | 24 | (57,880,936) | (48,639,566) | (22,539,047) | (15,681,287) |
Impairment of trade payables - debit balances | 8 | (24,375,000) | - | (8,125,000) | - |
Provisions | 12 | (10,001) | (4,629,970) | - | (505,705) |
Finance cost |
| (85,647,427) | (12,281,773) | (28,678,603) | (8,817,110) |
Add: |
|
|
|
|
|
Financing income | 25 | 23,051,434 | 18,115,406 | 11,463,949 | 4,557,133 |
Other operating revenue | 26 | 39,041,915 | 29,920,097 | 15,047,469 | 9,829,992 |
Profits from operation |
| 1,035,410,140 | 995,010,790 | 309,346,719 | 315,674,808 |
Return on investments held to maturity |
| 45,985 | 41,716 | 4,270 | - |
Reverse of impairment in investments in subsidiaries | 5/1 | 19,518,646 | - | - | - |
Other expenses | 27 | (8,868,779) | (26,565,618) | (4,760,737) | (292,644) |
Net profit for the period before tax |
| 1,046,105,992 | 968,486,888 | 304,590,252 | 315,382,590 |
Income tax | 21 | (229,304,361) | (212,484,677) | (62,043,571) | (71,996,426) |
Deferred tax | 20 | (55,349) | (36,158) | (189,241) | (79,071) |
Net profit for the period |
| 816,746,282 | 755,966,053 | 242,357,440 | 243,306,667 |
|
|
|
|
|
|
Earnings per share for the period | 28 | 0.62 | 0.59 | 0.18 | 0.20 |
CFO | Managing Director | Chairman |
Mr. Mohamed Abdelsalam | Eng. Ahmed Ali ElHetmy | Eng. Mohamed Hazem Barakat |
Madinet Nasr for Housing & Development S.A.E.
SEPARATE STATEMENT OF COMPREHENSIVE INCOME
For the period from 1 January to 30 September 2018
| From 1/1/2018 to 30/9/2018 | From 1/1/2017 to 30/9/2018 | From 1/7/2018 to 30/9/2018 | From 1/7/2017 to 30/9/2017 |
| L.E. | L.E. | L.E. | L.E. |
|
|
|
|
|
Net profit for the period | 816,746,282 | 755,966,053 | 242,357,440 | 243,306,667 |
Other comprehensive income | - | - | - | - |
Total comprehensive incomefor the period | 816,746,282 | 755,966,053 | 242,357,440 | 243,306,667 |
CFO | Managing Director | Chairman |
Mr. Mohamed Abdelsalam | Eng. Ahmed Ali ElHetmy | Eng. Mohamed Hazem Barakat |
Madinet Nasr for Housing & Development S.A.E.
SEPARATE STATEMENT OF CHANGES IN EQUITY
For the period from 1 January to 30 September 2018
| Issued and paid up capital | Treasury shares | Legal reserve | Retained earnings | Net profit for the period | Total |
| L.E. | L.E. | L.E. | L.E. | L.E. | L.E. |
|
|
|
|
|
|
|
Balance at 1 January 2017 | 500,000,000 | (74,633,025) | 86,375,259 | 336,060,528 | 738,770,573 | 1,586,573,335 |
Sale of 4 million treasury shares | - | 74,633,025 | - | (1,433,024) | - | 73,200,001 |
Transferred to retained earnings | - | - | - | 738,770,573 | (738,770,573) | - |
Dividends for 2016 | - | - | - | (223,000,000) | - | (223,000,000) |
Transfer to legal reserve | - | - | 36,938,529 | (36,938,529) | - | - |
Capital increase according to the decision of Extraordinary General Assembly Meeting held on 29 March 2017 | 500,000,000 | - | - | (500,000,000) | - | - |
Capital reduction by value of bonus shares | (2,899,611) | - | - | (16,881,595) | - | (19,781,206) |
Comprehensive income for the period | - | - | - | - | 755,966,053 | 755,966,053 |
Balance at 30 September 2017 | 997,100,389 | - | 123,313,788 | 296,577,953 | 755,966,053 | 2,172,958,183 |
|
|
|
|
|
|
|
Balance at 1 January 2018 | 997,100,389 | - | 123,313,788 | 296,577,953 | 943,297,203 | 2,360,289,333 |
Transferred to retained earnings | - | - | - | 943,297,203 | (943,297,203) | - |
Dividends for 2017 | - | - | - | (95,165,000) | - | (95,165,000) |
Transfer to legal reserve | - | - | 47,164,860 | (47,164,860) | - | - |
Capital increase in accordance with the Extraordinary General Assembly Resolution of 1/4/2018 (Note 16) | 202,899,611 | - | - | (202,899,611) | - | - |
Comprehensive income for the period | - | - | - | - | 816,746,282 | 816,746,282 |
Balance at 30 September 2018 | 1,200,000,000 | - | 170,478,648 | 894,645,685 | 816,746,282 | 3,081,870,615 |
CFO | Managing Director | Chairman |
Mr. Mohamed Abdelsalam | Eng. Ahmed Ali ElHetmy | Eng. Mohamed Hazem Barakat |
Madinet Nasr for Housing & Development S.A.E.
SEPARATE STATEMENT OF CASH FLOWS
For the period from 1 January to 30 September 2018
|
| 30/9/2018 | 30/9/2018 |
| Note | L.E. | L.E. |
OPERATING ACTIVITIES |
|
|
|
Net profit for the period before tax |
| 1,046,105,992 | 968,486,888 |
Adjustments for: |
|
|
|
Depreciation of fixed assets and investment properties | 4/1, 5/4 | 4,484,609 | 2,811,177 |
Capital loss | 27 | 13,260 | - |
Provisions | 12 | 10,001 | 8,922,654 |
Impairment of trade payables - debit balances | 8 | 24,375,000 | - |
Bad debts |
| 3,016 | - |
Reverse of impairment of investments in subsidiaries |
| (19,518,646) | - |
Return on investments held to maturity |
| (45,985) | (41,716) |
Deferred profits and accrued interests on installments during the period (Net) |
| (41,410,524) | (57,366,007) |
(Gain)/Loss on foreign currencies exchange | 26 | (20,712) | 196,433 |
Operating profit before working capital changes: |
| 1,013,996,011 | 923,009,429 |
|
|
|
|
Housing and development projects |
| (9,497,036) | (279,681,826) |
Trade receivables, customers, trade payables and notes receivables |
| (1,430,066,400) | (2,352,245,792) |
Trade payables - unearned revenue, creditors, and projects' infrastructure completion liabilities |
| 1,066,358,386 | 1,970,031,053 |
Provisions used | 12 | (588,984) | (34,294,612) |
Dividends paid to Board of Directors and employees |
| (82,581,702) | (64,024,629) |
Income tax paid |
| (270,900,234) | (255,499,358) |
Net cash from/(used in) operating activities |
| 286,720,041 | (92,705,735) |
|
|
|
|
INVESTING ACTIVITIES: |
|
|
|
Payments for purchase of fixed assets & Projects under construction |
| (12,121,108) | (9,272,943) |
Proceeds from investments held to maturity |
| 45,985 | 41,716 |
Proceeds from amounts due from related parties | 30 | 5,862,492 | - |
Net cash used in investing activities |
| (6,212,631) | (9,231,227) |
|
|
|
|
FINANCING ACTIVITIES: |
|
|
|
Dividends paid to shareholders |
| - | (150,000,000) |
Treasury shares |
| - | 73,200,001 |
Payments for long term loans | 17 | (120,693,933) | (4,385,441) |
Proceeds from long term loans | 17 | - | 94,846,759 |
Payments for short term loans | 18 | (196,469,455) | (80,635,758) |
Proceeds from short term loans | 18 | 335,010,374 | 156,570,506 |
Net cash from financing activities |
| 17,846,986 | 89,596,067 |
|
|
|
|
Change in cash and cash equivalents |
| 298,354,396 | (12,340,895) |
Cash and cash equivalents at the beginning of the period |
| 123,514,275 | 226,950,875 |
Gain/(Loss) on foreign exchange | 26 | 20,712 | (196,433) |
Total cash and cash equivalents at the end of the period |
| 421,889,383 | 214,413,547 |
Less: Restricted time deposits against letters of guarantee |
| (4,592,268) | (4,592,268) |
Restricted investment certificates against letters of guarantee |
| (8,888,556) | - |
Cash and cash equivalents at the end of the period | 18 | 408,408,559 | 209,821,279 |
NON-CASH TRANSACTIONS:
The statement of cash flows does not include the following non-cash transactions:
· An amount of L.E. 1,828,508 represents transfer from Projects under construction to fixed assets.
· An amount of L.E. 281,969,104 (2017: L.E. 192,332,965) represents bank accounts and deposits against management, operation, and maintenance projects' creditors.
· An amount of L.E. 202,899,611 (2017: L.E. 500,000,000) represents paid up capital increase by issuance free shares from retained earnings.
CFO | Managing Director | Chairman |
Mr. Mohamed Abdelsalam | Eng. Ahmed Ali ElHetmy | Eng. Mohamed Hazem Barakat |
1. COMPANY BACKGROUND
1.1 Legal form of the company
Madinet Nasr for Housing & Development S.A.E. was incorporated in accordance with the Presidential Decree No. 815/1959 then changed to Joint Stock Company according to Presidential Decree No 2908/1964 under the umbrella of the Public Sector Authority for Housing by Presidential Decree No. 469/1983.
The company transferred to an Egyptian joint stock company under the provisions of Law No. 203 for 1991 issued on 19/06/1991 under the umbrella of the Holding Company for Housing under the name of Madinet Nasr Housing and Development. The Extraordinary General Assembly of the company held on 30/6/1996 approved the change to the provisions of Law No. 159 for 1981 and its executive regulations and published in company's journal on January 1997 rather than the provisions of Law No. 203 for 1991.
The company was registered in the Commercial Register No. 300874 on 23 December 1996 under tax card No. 200-009-095.
1.2 Activity
The company is engaged in all activities related to real estate development for lands, buildings and facilities including acquisition of land and real estate sale and rental, dividing it and providing all types of facilities necessary for reconstruction and connected to it in Nasr City and other areas nationwide, the purchase and development, utilization, leasing and sale of all buildings and land. The company can establish, manage and invest all residential, administrative, tourists, recreational and all projects necessary to achieve these purposes, and all real estate, financial, commercial and entertainment operations related to these purposes, as well as carrying out designs, and engineering consultancy and supervision of the execution to others.
BIG Investment Group Limited - Egypt considered the main shareholder of the company.
1.3 Duration
The company's term is 50 years starting from the date of the registration in the commercial register and has been renewed for another 25 started from 23/12/1996 to 22/12/2021.
1.4 Location
The company's head office is located at 4, Youssef Abbass St., 2nd Area, Nasr City, Cairo, Egypt.
The Chairman is Eng. Mohamed Hazem Barakat.
The company is listed on Egyptian Stock Exchange and London Stock Exchange on GDR admission system.
The company Board of Directors has approved the separate financial statements for the period ended 30 September 2018 on 1 November 2018.
2. USE OF ESTIMATES AND JUDGMENTS
The preparation of separate financial statements in accordance with Egyptian Accounting Standards requires management to make judgments, estimates and assumptions that affect the application of policies and reported amounts of assets, liabilities, income and expenses. The estimates and associated assumption are based on historical experience and various other factors that are believed to be reasonable under the circumstances, the results of which form the basis of making the judgments about the carrying values of assets and liabilities. Actual results may differ from those estimates.
The estimates and underlying assumptions are reviewed on a continuous basis. Revisions to accounting estimates are recognized in the period in which the estimate is revised and the future periods if it affects future periods.
The following estimates and judgments that is affect on financial statements are as follows:
- Depreciation of fixed assets and Investment property
- Provisions
- Impairment of assets values
- Taxation
- Liabilities for utilities completion
- Amortization of the discount of present value for notes receivable
3. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES
a) Basis of preparation of the summarized separate financial statements
The separate financial statements are prepared in accordance with the Egyptian Accounting Standards and relevant local laws and regulations.
The separate financial statements are prepared under the historical cost convention modified for measurement of available for sale investments, held to maturity investments and investment at fair value through profit and loss.
The separate financial statements are presented in Egyptian Pounds.
According to the Egyptian Accounting Standard No. 42 (Consolidated Financial Statements) and Article 188 of the Executive Regulations of the Companies Law No. 159 of 1981, the company prepares consolidated financial statements.
b) Fixed assets and depreciation
Fixed assets are recorded on purchase at cost and are presented in the statement of financial position net of accumulated depreciation and impairment losses. Historical costs include costs associated with the purchase of the asset. For assets constructed internally, the cost of the asset includes the cost of raw materials, direct labour and other direct costs incurred in bringing each asset to its location and the purpose for which it was acquired, as well as the costs of removal and rearrangement of the site, where the assets are located.
Components are accounted for on an item of fixed assets that have different useful lives as separate items within those fixed assets.
3. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued
The carrying amount of fixed assets includes the cost of replacing a part or component of such assets when it is expected to obtain future economic benefits as a result of spending that cost. Other costs allocated to the separate income statement as an expense when incurred.
Depreciation is provided on a straight line basis to write off the cost less estimated residual value of each asset - other than land - over its expected useful life.
| Useful life |
|
|
Buildings | 50 |
Elevators | 10 |
Machinery & equipment for production | 5 |
Machinery & equipment for utilities and erection | 5 - 12.5 |
Transportation means | 5 |
Tools & equipment | 1 |
Furniture & office equipment | 10 |
c) Projects under construction
Projects under construction are recorded at cost which includes all the direct costs incurred on the assets to reach its final position. These are transferred to fixed assets or investment properties when the asset is complete and ready for its intended use. Projects under construction are recorded at cost less impairment, if any.
d) Investment in subsidiaries
A subsidiary is a company in which the company owns more than 50% of the share capital and the company exercises the right to control the investee when the company is exposed or entitled to variable returns through the company's contribution to the investee company and has the ability to affect those returns through its authority over the company. Therefore the company controls the investee company when the company has all the following:
· Power over the investee.
· Exposure or right to variable returns by contributing to the investee company.
· The ability to use the authority on the investee company to influence the amount of proceeds obtained from it.
Investments in subsidiaries are carried at cost less impairment losses, if any.
In case of impairment, the carrying amount of the impairment loss is reduced and charged to the separate statement of income for each investment. The impairment loss is reversed in prior periods so that the carrying amount of the investment does not exceed its original net worth before the impairment loss is recognized in value.
e) Available for sales investments
Available for sale investments are initially recorded at cost and are subsequently measured at fair value. Changes in fair value are reported as a separate component of other comprehensive income. Where available for sale investments could not be measured reliably, as the market for an investment is not active (and for unlisted securities), these are stated at cost less impairment losses, if any. Impairment loss is charged to the separate statement of income.
3. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued
f) Held to maturity investments
Held to maturity investments are carried at amortized cost using the effective interest method. Premiums or discounts (if any) are amortized using the effective interest rate. When the investment is impaired, the impairment loss is adjusted against book value and included in the separate statement of income.
g) Investment properties
Investment properties are measured at cost model and depreciation expense charged to the separate statement of income according to the straight-line method over the estimated useful life of all investment property except the land. In case of such assets are impaired, the loss is included in the separate income statement.
h) Investments at fair value through profit and loss (investment certificates)
Investments at fair value through profit and loss are initially recorded at cost and revaluated at the date of separate financial statements at fair value which represents the market price at the valuation date. Changes in fair value are charged to the separate statement of income.
i) Housing and Development projects
All cost incurred on housing and development projects are included in this account. At point of sale, this account is adjusted based on actual per meter cost of land or units sold. Housing and development projects are measured at the lower of cost and net realizable value. In case of decrease the net realizable value under the cost, the decrease is charged to the separate statement of income.
j) Separate statement of cash flows
The separate statement of cash flow is prepared according to the indirect method.
k) Cash and cash equivalents
Cash and cash equivalents include cash on hand, time deposits (due within 3 months), bank current accounts, and short term highly liquid investments, which can be easily converted to cash, less credit banks and pledged time deposits against letters of guarantee.
l) Receivables and other debtors
Trade accounts receivable stated at cost net of allowance for doubtful debts, which is estimated for amounts not expected to be collected in full. Other debtors stated at cost less any impairment. (If any)
The notes receivable are the value of post-dated checks (PDCs) obtained from the customers in payment of the remaining contractual values of the contracted real estate units. The initial recognition of the notes receivable is at fair value at the time the contract is entered into with the customers. At the date of preparation of the separate financial statements; notes receivable are re-measured at amortized cost; which is determined by discounting the future cash flows of the notes using the rate of return that discounts the nominal value of the instruments to the current cash price for selling the real estate units.
3. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued
m) Assets impairment
Non-Financial Assets
At the separate financial statements date, the company reviews the carrying amounts of its owned non financial assets to determine whether there is any indication that those assets may be impaired. If any such indication exists, the company estimates the recoverable amount for each asset separately in order to estimate the impairment losses. In case the recoverable amount of the asset cannot be properly estimated, the company estimates the recoverable amounts for the cash-generating unit which is related to the asset.
In case of using a reasonable and consistent basis for allocating of the assets to the cash generating units, the company's general assets would be also allocated to these units. If this is unattainable, the general assets of the company shall be allocated to the smallest group of the cash-generating units, which the company determined using logical and fixed bases.
The asset recoverable amount or the cash-generating unit is represented by the higher of the fair value (less the estimated selling costs) or the estimated amount from the usage of the asset (or the cash generating unit).
The estimated future cash flow from the usage of the assets, or the cash generating unit using a discount rate before tax is discounted in order to reach the present value for these flows which represents the estimated amount from using the asset (or the cash generating unit).
This rate reflects current market assessments of the time value of money and the risks specific to the asset, which were not taken into consideration when estimating the future cash flow generated from it. When the recoverable amount of the asset (cash generating unit) is estimated to be less than its carrying amount, the carrying amount of the asset (cash generating unit) is reduced to its recoverable amount with the impairment loss recognized immediately in the separate income statement.
In case the impairment on asset (or cash generating unit) decreases subsequently, and this decrease is related in a logical manner to one event or more taking place after the initial recognition of the impairment at the profit or losses, a reversal is done for the revised amount of losses (or a part of it)- which had been recognized previously- in the separate income statement, and the carrying amount for the asset is increased (or the cash generating unit) with the new estimated recoverable amount provided that the revised carrying amount of the asset after revising (or the cash generating unit) does not exceed the carrying amount determined for the asset, had the recognized losses resulting from impairment, not been recognized in previous years
Financial Assets
At the end of the reporting period, the company determines whether there is any indication that its financial assets may be impaired.
Financial assets are exposed to impairment when an objective evidence that the estimated future cash flow have been affected by the event or more established at a date subsequent to the initial recognition of the financial asset.
The carrying value of all financial assets is reduced directly with the impairment losses except those related to the reduction in the expected value of the collections from the customers debts and other debit balances, where a formed allowances for impairment loss is done on its value. When the debt of the clients or the owner of the debit balance is uncollectible, a written off discount is applied upon this account. All the changes in the book value relating to this account are recognized in the separate income statement.
3. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued
n) Provisions
Provisions are recognized when there is a present legal or constructive obligation as a result of a past event, it is probable an outflow of resources embodying economic benefits will be required to settle this obligation and a reliable estimate can be made for the obligation.
Provisions are reviewed at the separate financial position date and adjusted (if necessary) to present the best current estimate.
o) Unearned revenue, payables and other creditors
The value of unearned revenues on real estate units (villas, townhouses, twin houses, apartments and garages) contracted for sale and were not delivered to customers on the date of the separate financial position is recorded as a liability at the cash price of those units (after discounting the future contractual value of these units to reach the cash sale price). These balances are recognized as sales income in the separate statement of income on the date of delivery.
Liabilities are recognized for amounts to be paid in the future for goods received or services rendered to the company, whether billed or not billed by the supplier.
p) Treasury shares
Treasury shares are recorded at cost and deducted from shareholders equity. Gain or loss from sale of shares is included in retained earnings.
q) Dividends
Dividends are recorded as liability during the year when declared.
r) Revenue recognition
1. Cash sales
Sales of land & property is recoded after collection of the agreed upon price and delivery to the customer in accordance with the terms of the contract.
2. Installment Sales
Revenue on sales during the period are recorded when the related land and property is actually received by the customers or, where delay in receiving by customer is due to circumstances out of the company's control, according to the contractual terms as follows:
- Total sale of value of land and property is recorded as sales during the period after deduction of profit relating to deferred installments on those sales. Such deduction is recorded as a liability (profit from deferred installments) when all the following terms for sales are met as:
§ The risk and rewards of ownership of units sold is not transferred to the buyer until settlement of all installments due from the buyers and the transfer of ownership to buyer.
§ The company has the right of managerial intervention and supervision on units sold to guarantee that the buyer is a biding by the contractual terms.
§ According to the signed contracts with the customers, the company has the right to cancel the contracts if all installments due were not paid.
3. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued
- Interest on installments is recorded directly in credit balances (Deferred interests on installments) at the time of sale.
- Deferred installments profit and deferred interests on installments which related to sale of land and properties in prior years are recognized on the actual basis when the installments full due adjusting the profit margin by cost incurred on projects during the year.
3. Revenue from real estate contracts
The company is performing the activity of real estate and marketing to this activity through customers' contracts which give them the right to have real estate villa, ton house and unit over the period of the contract. Revenue recognized from sales agreements according to the stages included in the sales agreements according to the following:
· Development of land to construction of real estate
· Construction of the building
· Completion of Within a year
4. Joint arrangement
A joint arrangement is an arrangement in which two or more parties have joint control. It is either a joint operation or a joint venture. A joint arrangement is that the parties are bound by a contractual agreement granting joint control to two or more parties of the arrangement.
The classification of a joint arrangement as a joint operation or a joint venture depends on the rights and obligations (undertakings) of the parties to the arrangement. The joint operation becomes a joint arrangement when its parties have joint control over the rights over the assets and the obligations associated with the arrangement. These parties are called joint operators. A joint venture is a joint arrangement when its parties have joint control over the rights over the net assets associated with the arrangement. These parties are called shareholders in joint ventures. The entity shall apply the judgment in assessing whether the joint arrangement is a joint venture or a joint venture.
The joint operator shall account for assets, liabilities, income and expenses related to its share in the joint operation in accordance with the Egyptian Accounting Standards applicable to such assets, liabilities, revenues and expenses.
On 31 December 2015, the Company adopted a new strategy to execute a joint operation development contract based on a share in the revenue of the sales. The Company receives its share against the land provided for development by the other co-developer who will receive the rest of the sale revenue against incurring the development cost.
5. Other revenues
· Rental income is recognized on a time-apportioned basis. Interest income on deposits and bonds is recognized on a time basis and using the target rate of return on the financial asset.
· Dividend income is recognized in the separate statement of income when the right to receive dividends from the investee is established and is recognized after the date of acquisition.
3. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued
s) Direct and indirect cost
Direct and indirect costs incurred for the constructions of the real estate are accumulated in the inventor account for constructions. Cost of the completed contracts are comprises of land cost, cost of building constructed and other indirect costs.
t) Employees' benefits
The company contributes to the social insurance scheme for the benefit of its employees in accordance with the Social Insurance Law. Contributions of workers and employers are calculated at a fixed rate of wages. The company's commitment is represented in value of its contribution. The company's contributions are charged to the separate statement of income. The company gives employees who have reached retirement age, end of service gratuity up to a maximum of 50 thousand Egyptian pounds. The Company also applies an optional early retirement scheme. End of service benefits for employees benefiting from this system are charged to the separate income statement in the period in which they are approved for early retirement.
u) Taxation
Income tax
Taxation is accounted according to Egyptian laws and regulations.
Income tax expense that is calculated on the profits of the company represents the sum of the tax currently payable (calculated according to the applied laws and regulations and using the tax rates prevailing as of the separate financial statements date) and deferred tax. Current and deferred taxes are recognized as income or expenses and included in the profits or losses of the period except for instances that taxes are established from:
1. A transaction or event recognized, in the same period or other period, outside profit or loss either in other comprehensive income or directly in equity, or
2. Business combinations.
Deferred tax is recognized on temporary differences between the carrying amounts of assets and liabilities according to the accounting basis used in the separate financial statements and the corresponding tax bases used in the computation of taxable profit. Deferred tax assets and liabilities are measured at the tax rates that are expected to apply in the period in which the liability is settled or the asset realized, based on tax rates that have been enacted or substantively enacted at the separate financial statements date.
Deferred tax liabilities are generally recognized (generated from taxable temporary differences in the future) while deferred tax assets recognized for all deductible temporary differences to the extent that it is probable that taxable profits will be available against which those deductible temporary differences can be utilized.
The carrying amount of deferred tax assets is reduced to the extent that it is no longer probable that sufficient taxable profits will be available in future years to allow all or part of the asset to be recovered. The balance sheet method is used in accounting for deferred assets and liabilities and they are recognized as non-current assets and liabilities.
3. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued
v) Earnings per share
Earnings per share are calculated by dividing the net profit for the period, after deducting employees share and Board of Directors remuneration, by the weighted average number of outstanding shares during the period.
w) Borrowing cost
Borrowing costs directly attributable to the acquisition, construction or production of a qualified asset for capitalization of cost of borrowing; are capitalized as part of the cost of the asset. Other borrowing costs are charged as an expense in the separate statement of income on a time-apportioned basis using the effective interest rate.
An asset eligible to bear the cost of borrowing necessarily requires a long period of time to process it for use for its intended purposes or to sell it. This applies to land and building facilities items as fixed assets under construction (under construction projects) and incomplete inventory of reconstruction and housing projects.
Capitalization of borrowing costs begins as part of the cost of the qualifying asset to bear the cost of borrowing when:
- Expenditure on the qualified asset.
- The Company incurs a borrowing cost.
- The activities required for the preparation of the asset for use for purposes specified for it or for its sale to others are currently under implementation.
Capitalization of borrowing costs is suspended during periods in which the effective construction of the asset is impaired. Capitalization is contingent upon the completion of all material activities necessary to prepare the qualifying asset to bear the borrowing cost for its intended use or to sell it to third parties.
x) Legal reserve
As required by the Companies Law No. 159 of 1981 and the company's Articles of Association, 5% of the profit for the year is transferred to the legal reserve. The company may resolve to discontinue such annual transfers when the reserve totals 50% of the issued share capital. The legal reserve cannot be distributed except in cases stated in the Law.
y) Foreign currency transactions
The company's functional currency is the Egyptian pound. Transactions in foreign currencies are recorded at the rate ruling at the date of the transaction. Monetary assets and liabilities denominated in foreign currencies at the financial position date are translated at the rate of exchange ruling at that date. Retranslation exchange profit and loss is taken to the separate statement of income.
z) Related parties' transactions
Related parties transactions carried out by the company within its normal course of business, are recognized pursuant to the conditions set out by the Board of Directors on an arm's length- basis.
4/1 FIXED ASSETS
| Land (*) | Buildings and constructions (*) | Machinery & equipment | Motor vehicles | Tools | Furniture & office equipment | Computers & software | Total |
| L.E. | L.E. | L.E. | L.E. | L.E. | L.E. | L.E. | L.E. |
Cost: |
|
|
|
|
|
|
|
|
At 1 January 2018 | 1,351,229 | 20,940,185 | 2,677,829 | 3,186,826 | 513,777 | 10,175,543 | 18,956,461 | 57,801,850 |
Additions during the period | - | 1,016,897 | 1,327,045 | 22,778 | 4,047 | 1,200,513 | 2,385,417 | 5,956,697 |
Transferred from Projects under construction (Note 4/2) | - | 5,000 | 1,823,508 | - | - | - | - | 1,828,508 |
Disposals during the period | - | - | - | - | - | (26,542) | (29,670) | (56,212) |
At 30 September 2018 | 1,351,229 | 21,962,082 | 5,828,382 | 3,209,604 | 517,824 | 11,349,514 | 21,312,208 | 65,530,843 |
|
|
|
|
|
|
|
|
|
Accumulated depreciation: |
|
|
|
|
|
|
|
|
At 1 January 2018 | - | 3,011,868 | 1,898,261 | 3,119,830 | 511,389 | 5,111,871 | 5,163,838 | 18,817,057 |
Provided during the period | - | 1,508,015 | 660,451 | 20,381 | 2,807 | 749,325 | 1,497,838 | 4,438,817 |
Disposals during the period | - | - | - | - | - | (25,536) | (17,416) | (42,952) |
At 30 September 2018 | - | 4,519,883 | 2,558,712 | 3,140,211 | 514,196 | 5,835,660 | 6,644,260 | 23,212,922 |
|
|
|
|
|
|
|
|
|
Net book value: |
|
|
|
|
|
|
|
|
At 30 September 2018 | 1,351,229 | 17,442,199 | 3,269,670 | 69,393 | 3,628 | 5,513,854 | 14,667,948 | 42,317,921 |
At 31 December 2017 | 1,351,229 | 17,928,317 | 779,568 | 66,996 | 2,388 | 5,063,672 | 13,792,623 | 38,984,793 |
(*) Land and buildings includes land and building of the social club and the playground rented for Madinet Nasr for Housing & Development Employees club, and the book value is approximately L.E. 1.3 million for land and L.E. 4.5 million for building. There are no guarantees or pledging on fixed assets at the date of the separate financial statements.
4/1 FIXED ASSETS - Continued
a) The fully depreciated assets and still working are as follows:
| 30/9/2018 | 31/12/2017 |
| L.E. | L.E. |
|
|
|
Buildings and constructions | 114,889 | 114,889 |
Motor vehicles | 3,096,859 | 3,043,609 |
Furniture and office equipment | 1,383,680 | 1,400,107 |
Machinery & equipment | 694,879 | 687,728 |
Tools | 512,241 | 509,868 |
| 5,802,548 | 5,756,201 |
b) Depreciation for the period is allocated as follows:
| 30/9/2018 | 30/9/2017 |
| L.E. | L.E. |
|
|
|
Cost of sales | 524,885 | 158,535 |
Selling and marketing expenses (Note 23) | 1,140,363 | 101,736 |
General and administrative expenses (Note 24) | 2,773,569 | 2,510,086 |
| 4,438,817 | 2,770,357 |
4/2 PROJECTS UNDER CONSTRUCTION
| 30/9/2018 | 31/12/2017 |
| L.E. | L.E. |
|
|
|
Balance at the beginning of the period/year | 12,287,797 | 375,308 |
Additions during the period/year | 6,164,411 | 12,215,592 |
Transferred to fixed assets (Note 4/1) | (1,828,508) | (303,103) |
Balance at the end of the period/year | 16,623,700 | 12,287,797 |
5. INVESTMENTS
5/1 Investments in subsidiaries
| Contribution | 30/9/2018 | 31/12/2017 |
| % | L.E. | L.E. |
|
|
|
|
Al Nasr Co. for Utilities & Erections - S.A.E. | 94.9 | 3,061,103 | 3,061,103 |
Impairment of investment |
| (3,061,103) | (3,061,103) |
|
| - | - |
Al Nasr Co. for Civil Works - S.A.E. | 52.46 | 64,900,606 | 64,900,606 |
Impairment of investment (*) |
| - | (19,518,646) |
|
| 64,900,606 | 45,381,960 |
(*) The impairment of Al Nasr Co. for Civil Works' investment represents the decline of shares' market price by cost which is listed in the financial statements for the year ended 31 December 2016, which the company accomplished significant improvement in current financial position compared with year 2016 which has been positively reflected on the market value of shares, consequently there is no indication for impairment in the cost of investment, and the impairment was reversed during the period.
5. INVESTMENTS - Continued
5/2 Held to maturities investments
| 30/9/2018 | 31/12/2017 |
| L.E. | L.E. |
|
|
|
Investments in Governmental treasury bonds (non-active market) | 121,962 | 121,962 |
5/3 Available for sale investments
| Contribution | 30/9/2018 | 31/12/2017 |
| % | L.E. | L.E. |
|
|
|
|
Egyptian Kuwaiti Real Estate Development | 7.503 | 4,314,110 | 4,314,110 |
High Education House ( S.A.E) | 1.2 | 200,000 | 200,000 |
|
| 4,514,110 | 4,514,110 |
Available for sale investments are not listed in active market (stock exchange), so we cannot determine its fair value, so it is recorded at historical cost.
5/4 Investment properties
| 30/9/2018 | 31/12/2017 |
| L.E. | L.E. |
|
|
|
Allocated land for Developing and Housing Projects | 48,067 | 48,067 |
Title held land on sold properties | 3,427,691 | 3,427,691 |
Rental buildings (Net) (*) | 827,127 | 872,919 |
| 4,302,885 | 4,348,677 |
The fair values of investment properties are not less than its book value.
(*) Rental buildings (Net)
| Residential units | None residential units | Total |
| L.E. | L.E. | L.E. |
Cost: |
|
|
|
At 1 January 2018 |
|
|
|
and at 30 September 2018 | 545,997 | 2,882,169 | 3,428,166 |
|
|
|
|
Accumulated depreciation: |
|
|
|
At 1 January 2018 | 447,958 | 2,107,289 | 2,555,247 |
Provided during the period (Note 22-b) | 6,933 | 38,859 | 45,792 |
At 30 September 2018 | 454,891 | 2,146,148 | 2,601,039 |
|
|
|
|
Net book value: |
|
|
|
At 30 September 2018 | 91,106 | 736,021 | 827,127 |
At 31 December 2017 | 98,039 | 774,880 | 872,919 |
5. INVESTMENTS - Continued
Cost of investment properties which are fully depreciated and still in use are as follows:
| 30/9/2018 | 31/12/2017 |
| L.E. | L.E. |
|
|
|
Residential units | 109,417 | 53,602 |
Non residential units | 300,737 | 248,273 |
| 410,154 | 301,875 |
5/5 Investments at fair value through profit and loss
| 30/9/2018 | 31/12/2017 |
| L.E. | L.E. |
Investment certificates in: |
|
|
Bank Misr Investment Fund (Day-By-Day) | 266,556 | 240,662 |
QNB Investment Fund | 1,098,849 | 992,307 |
Banque Du Caire Investment Fund (Day-By-Day) | 749,809 | 859,676 |
United Bank Investment Fund (Rakhaa) (*) | 9,658,392 | 8,693,005 |
Arab Investment Bank Investment Fund | 21,959 | 21,959 |
| 11,795,565 | 10,807,609 |
(*) United Bank Investment Fund (Rakhaa) includes restricted investment certificates by L.E. 8,888,556 against letters of guarantee as of separate financial statement date. (Note 18)
6. HOUSING & DEVELOPMENT PROJECTS
| 30/9/2018 | 31/12/2017 |
| L.E. | L.E. |
Lands and non-completed units: |
|
|
El Waha Project | 74,551,206 | 141,766,889 |
6th October Project (Nasr Gardens) | 179,272,345 | 133,832,030 |
Tag City Project | 628,667,501 | 608,086,720 |
Nasr City (Main City) Project | 1,134,240 | 2,297,896 |
Sarai City | 405,294,886 | 393,723,014 |
| 1,288,920,178 | 1,279,706,549 |
Completed units: |
|
|
El Waha Project | 6,680,048 | 6,420,410 |
Nasr City (Main City) Project | 11,587,224 | 11,563,454 |
6th October Project (Nasr Gardens) | 60,278,441 | 60,278,442 |
| 78,545,713 | 78,262,306 |
Total lands, non-completed and completed units | 1,367,465,891 | 1,357,968,855 |
Housing and development projects has been recorded at cost which is not less than net realizable value as the separate financial statements date.
7. TRADE AND NOTES RECEIVABLES
| 30/9/2018 | 31/12/2017 |
| L.E. | L.E. |
Long term notes receivable |
|
|
Tag Sultan customers | 330,096,753 | 450,606,088 |
Tag City customers (Zone T) | 2,195,140,495 | 2,467,547,802 |
Tag City customers (Zone B) | 1,181,285,512 | 257,133,516 |
Premira customers | 67,439,051 | 82,497,978 |
Capital Gardens customers | 473,331,679 | 370,059,492 |
Sarai City customers 1 | 1,331,316,297 | 638,082,019 |
Sarai City customers 2 | 1,542,353,125 | 2,153,329,435 |
Sarai City customers 3 | 161,364,692 | - |
Total long term notes receivables | 7,282,327,604 | 6,419,256,330 |
|
|
|
Less: |
|
|
Tag Sultan Project | (61,206,328) | (72,679,392) |
Tag City (Zone T) | (365,664,586) | (447,929,785) |
Tag City (Zone B) | (187,507,870) | (41,881,651) |
Premira Project | (24,486,855) | (29,156,749) |
Capital Gardens | (149,676,310) | (130,856,066) |
Sarai City 1 | (147,634,122) | (108,523,928) |
Sarai City 2 | (367,408,380) | (443,234,158) |
Sarai City 3 | (27,793,428) | - |
Total present value discount | (1,331,377,879) | (1,274,261,729) |
Net long term notes receivables | 5,950,949,725 | 5,144,994,601 |
|
|
|
Short term notes receivable |
|
|
|
|
|
Tag Sultan Project | 219,722,597 | 239,698,796 |
Tag City Project (Zone T) | 579,368,803 | 548,036,867 |
Tag City Project (Zone B) | 301,462,820 | 57,907,386 |
Premira Project | 38,576,077 | 51,796,263 |
Sarai City 1 | 268,142,752 | 167,922,665 |
Sarai City 2 | 539,310,195 | 511,246,101 |
Sarai City 3 | 50,679,093 | - |
| 1,997,262,337 | 1,576,608,078 |
Trade debtors |
|
|
Tag Sultan | 6,559,274 | 4,830,678 |
Tag City (Zone T( | 120,983,854 | 59,461,906 |
Tag City (Zone B( | 19,111,894 | - |
Premira | 649,914 | 516,394 |
Sarai City 1 | 25,472,280 | 54,767,667 |
Sarai City 2 | 94,860,828 | - |
Sarai City 3 | 1,071,318 | - |
El Waha and Nasr City | 204,767,069 | 242,857,571 |
Land | 92,683,009 | 51,471,905 |
Leaseholders | 1,323,523 | 1,128,196 |
| 567,482,963 | 415,034,317 |
Less: |
|
|
Deferred profits and interests on outstanding installments (Note 14) | (193,977,316) | (226,811,160) |
Impairment of customers balances | (14,661,382) | (14,661,382) |
| 358,844,265 | 173,561,775 |
8. TRADE PAYABLES
8/1 Trade payables - debit balances
| 30/9/2018 | 31/12/2017 |
| L.E. | L.E. |
|
|
|
Suppliers and contractors | 56,772,094 | 79,370,792 |
Amount due from related parties (Note 30) | 101,545,734 | 74,993,098 |
| 158,317,828 | 154,363,890 |
Less: |
|
|
Impairment of due from related parties(*) | (74,472,093) | (50,097,093) |
| 83,845,735 | 104,266,797 |
(*) The movements in impairment of amounts due from related parties are as follows:
| 30/9/2018 | 31/12/2017 |
| L.E. | L.E. |
|
|
|
Impairment balance at the beginning period/year | 50,097,093 | 50,097,093 |
Provided during the period/year | 24,375,000 | - |
Impairment balance at the end of period/year | 74,472,093 | 50,097,093 |
8/2 Trade payable - credit balances
| 30/9/2018 | 31/12/2017 |
| L.E. | L.E. |
|
|
|
Trade payables | 21,422,986 | 81,118,069 |
Amount due to related parties (Note 30) | 16,093,431 | 13,900,237 |
| 37,516,417 | 95,018,306 |
9. DEBTORS AND OTHER DEBIT BALANCES
| 30/9/2018 | 31/12/2017 |
| L.E. | L.E. |
|
|
|
Cheques under collection | 1,262,569 | 1,826,132 |
Refundable deposits | 6,822,580 | 2,653,909 |
Prepaid expenses | 212,003,240 | 160,601,026 |
Accrued income (interests) | 137,622 | 693,257 |
Cash margin on letters of guarantee (Note 29) | 6,892,374 | 6,892,374 |
Other debit balances | 2,938,067 | 1,420,141 |
| 230,056,452 | 174,086,839 |
10. CASH AND BANK BALANCES
| 30/9/2018 | 31/12/2017 |
| L.E. | L.E. |
|
|
|
Cash on hand | 323,257 | 125,117 |
Bank current accounts with return | 442,300,695 | 198,198,346 |
Time deposits (3 months) (*) | 5,600,000 | 5,600,000 |
| 448,223,952 | 203,923,463 |
(*) Time deposits include L.E. 4,592,268 (2017: L.E. 4,592,268) as restricted time deposits against letters of guarantee. (Notes 18, 29)
11. UNEARNED REVENUE
| 30/9/2018 | 31/12/2017 |
| L.E. | L.E. |
|
|
|
Tag Sultan project | 338,894,797 | 518,912,026 |
Premira project | 54,334,665 | 133,437,248 |
Tag City (Zone T) project | 2,146,505,137 | 2,010,245,953 |
Tag City (Zone B) project | 1,020,052,154 | 198,573,733 |
Capital Gardens project | 131,780,473 | 99,520,063 |
Sarai City project | 2,640,866,657 | 2,158,419,742 |
| 6,332,433,883 | 5,119,108,765 |
12. PROVISIONS
| Balance at 1/1/2018 | Provided during the period | Used during the period | Balance at 30/9/2018 |
| L.E. | L.E. | L.E. | L.E. |
|
|
|
|
|
Disputed taxes provision | 12,228,706 | - | - | 12,228,706 |
Claims provision | 34,548,893 | - | - | 34,548,893 |
Legal provision | 20,757,528 | 10,001 | - | 20,767,529 |
Other provisions | 2,526,680 | - | (588,984) | 1,937,696 |
| 70,061,807 | 10,001 | (588,984) | 69,482,824 |
13. PROJECT INFRASTRUCTURE COMPLETION LIABILITIES
| Balance at 1/1/2018 | Provided | Work executed | Balance at 30/9/2018 |
| L.E. | L.E. | L.E. | L.E. |
|
|
|
|
|
Tag City project | 79,323,864 | 49,503,069 | (47,795,828) | 81,031,105 |
Sarai City project | 74,155,134 | 51,602,776 | (92,591,350) | 33,166,560 |
Capital Gardens project | 2,859,260 | 1,333,725 | - | 4,192,985 |
El Waha Project | 13,802,885 | 6,994,485 | (12,760,553) | 8,036,817 |
Nasr City project | 686,216 | - | - | 686,216 |
| 170,827,359 | 109,434,055 | (153,147,731) | 127,113,683 |
This balance represents estimated amounts to complete utilities for projects that have not been completely delivered.
14. DEFERRED PROFITS & INTERESTS ON OUTSTANDING INSTALLMENTS
| Land | Properties | Total |
| L.E. | L.E. | L.E. |
30/9/2018 |
|
|
|
Balance at beginning of the period | 48,852,758 | 177,958,402 | 226,811,160 |
Additions during the period | 9,826,126 | - | 9,826,126 |
Due during the period | (16,571,447) | (24,839,077) | (41,410,524) |
Disposals during the period | - | (1,249,446) | (1,249,446) |
Balance at the end of the period (Note 7) | 42,107,437 | 151,869,879 | 193,977,316 |
|
|
|
|
31/12/2017 |
|
|
|
Balance at beginning of the year | 80,544,379 | 224,405,842 | 304,950,221 |
Due during the year | (31,639,428) | (43,144,259) | (74,783,687) |
Disposals during the year | (52,193) | (3,303,181) | (3,355,374) |
Balance at the end of the year | 48,852,758 | 177,958,402 | 226,811,160 |
15. CREDITORS AND OTHER CREDIT BALANCES
| 30/9/2018 | 31/12/2017 |
| L.E. | L.E. |
|
|
|
Notes payable | 20,168,657 | 9,131,934 |
Support to National Housing Project | 880,000 | 880,000 |
Final retention and other refundable deposits | 35,923,868 | 37,332,179 |
Down payment for reservation of land & property sales(El Waha & 6th October) | 6,064,580 | 6,069,741 |
Down payment for reservation of land & property sales (Tag Sultan - T Zone - Premira) | 8,738,152 | 7,781,757 |
Selling and marketing commissions | 26,416,875 | 23,304,415 |
Employees bonus account | 8,923,890 | 8,289,465 |
Customers' balances for canceled reservations | 13,115,179 | 12,004,283 |
Proceeds for maintenance expenses and counters | 9,847,442 | 9,886,005 |
Accrued debit interest on long term loans | 12,960,513 | 19,222,292 |
Prepaid income of rents | 50,673 | 18,586 |
Governmental authorities | 32,050,860 | 25,486,635 |
Accrued advertising expenses | 7,615,206 | 45,748,121 |
Early retirement benefits and others | 44,031 | 21,010,313 |
Fixed assets creditors |
| 1,395,353 |
Proceeds from customers under reconciliation | 653,105 | 1,205,209 |
Other | 307,310 | 745,220 |
| 183,760,341 | 229,511,508 |
16. SHARE CAPITAL
Authorized capital:
The authorized capital is five billion Egyptian Pounds.
| 30/9/2018 | 31/12/2017 |
| L.E. | L.E. |
|
|
|
Issued and paid up capital | 1,200,000,000 | 997,100,389 |
List of percentage of shares of issued and paid up capital for shareholders as of 30 September 2018 is as follows:
Name | No. of shares | Nominal value | Contribution % |
|
| L.E. | L.E. |
|
|
|
|
BIG Investment Group Ltd. | 238,590,867 | 238,590,867 | 19.88% |
Holding Co. for Construction and Development | 182,285,249 | 182,285,249 | 15.19% |
BPI Holding for Financial Investments S.A.E. | 89,462,770 | 89,462,770 | 7.45% |
National Investment Bank | 44,224,368 | 44,224,368 | 3.69% |
Al Olayan Saudi Investment Co. Ltd. | 42,303,187 | 42,303,187 | 3.53% |
Misr Banque | 38,023,030 | 38,023,030 | 3.17% |
Other shareholders | 565,110,529 | 565,110,529 | 47.09% |
| 1,200,000,000 | 1,200,000,000 | 100.00% |
17. TERM LOANS
| 30/9/2018 | |||
| National Investment Bank | Arab Investment Bank | Commercial International Bank | Total |
| L.E. | L.E. | L.E. | L.E. |
|
|
|
|
|
Balance at the beginning of the period | 1,694,337 | 2,026,971 | 381,323,986 | 385,045,294 |
Payments during the period | (456,524) | (2,026,971) | (118,210,438) | (120,693,933) |
Balance at the end of the period | 1,237,813 | - | 263,113,548 | 264,351,361 |
|
|
|
|
|
Classification in the statement of financial position as follows: |
|
|
|
|
|
|
|
|
|
Current liabilities: |
|
|
|
|
Current portion of long term loans | 491,458 | - | 160,156,075 | 160,647,533 |
|
|
|
|
|
Non current liabilities: |
|
|
|
|
Long term loans | 746,355 | - | 102,957,473 | 103,703,828 |
17. TERM LOANS - Continued
| 31/12/2017 | |||
| National Investment Bank | Arab Investment Bank | Commercial International Bank | Total |
| L.E. | L.E. | L.E. | L.E. |
|
|
|
|
|
Balance at the beginning of the year | 2,129,076 | 7,883,930 | 253,568,210 | 263,581,216 |
Proceeds during the year | - | - | 127,755,776 | 127,755,776 |
Payments of installments duringthe year | (434,739) | (5,856,959) | - | (6,291,698) |
Balance at the end of the year | 1,694,337 | 2,026,971 | 381,323,986 | 385,045,294 |
|
|
|
|
|
Classification in financial position |
|
|
|
|
as follows: |
|
|
|
|
Current liabilities: |
|
|
|
|
Current portion of long term loans | 456,524 | 2,026,971 | 175,409,025 | 177,892,520 |
|
|
|
|
|
Non current liabilities: |
|
|
|
|
Long term loans | 1,237,813 | - | 205,914,961 | 207,152,774 |
18. CASH AND CASH EQUIVALENTS
Cash and cash equivalents included in the separate statement of cash flows comprise the following separate financial position amounts:
| 30/9/2018 | 31/12/2017 |
| L.E. | L.E. |
|
|
|
Cash and bank balances (Note 10) | 448,223,952 | 203,923,463 |
Investment at fair value through profit and loss (Note 5/5) | 11,795,565 | 10,807,609 |
Less: |
|
|
Bank's overdraft - Credit facilities | (38,130,134) | (91,216,797) |
| 421,889,383 | 123,514,275 |
Less: Restricted time deposits against letters of guarantee (Note 10) | (4,592,268) | (4,592,268) |
Restricted investment certificates against letters of guarantee (Note 5/5) | (8,888,556) | - |
Cash and cash equivalents at the end of the period/year | 408,408,559 | 118,922,007 |
Short term loan
| 30/9/2018 | 31/12/2017 |
| L.E. | L.E. |
|
|
|
Balance at the beginning of the period/year | 56,875,747 | 19,333,333 |
Proceeds during the period/year | 335,010,374 | 156,570,506 |
Installments and interests paid during the period/year | (196,469,455) | (119,028,092) |
Balance at the end of the period/year | 195,416,666 | 56,875,747 |
19. CREDITORS OF PROJECT DEPOSITS FOR MAINTENANCE
| 30/9/2018 | 31/12/2017 |
| L.E. | L.E. |
|
|
|
Bank current accounts | 72,262,304 | 5,656,271 |
Time deposits | 198,131,790 | 169,258,322 |
Cheques under collection | 7,642,864 | 17,418,372 |
Accrued revenue | 3,932,146 | - |
Project maintenance deposit liabilities | 281,969,104 | 192,332,965 |
Amounts under settlement | 410,344 | 68,828 |
Project maintenance creditors | 282,379,448 | 192,401,793 |
The checks received from the customers for the project management, operation and maintenance account amounted to L.E. 1,008,912,763 (2017: L.E. 776,641,173). The sum of L.E. 281,969,104 (2017: L.E. 192,332,965) was collected and invested in deposits and interest-bearing bank accounts. The remaining balance amounting to L.E. 726,943,659 at 30 September 2018 (2017: L.E. 584,239,380) will be collected on maturity dates during the subsequent periods.
20. DEFERRED TAX
| 30/9/2018 | 31/12/2017 | ||
| Assets | (Liabilities) | Assets | (Liabilities) |
| L.E. | L.E. | L.E. | L.E. |
|
|
|
|
|
Fixed assets | - | (3,104,406) | - | (3,046,807) |
Provisions | 4,714,654 | - | 4,712,404 | - |
Total deferred tax assets/(liabilities) | 4,714,654 | (3,104,406) | 4,712,404 | (3,046,807) |
Net deferred tax | 1,610,248 | - | 1,665,597 | - |
Deferred tax charged to the separate statement of income | - | (55,349) | - | (701,626) |
Unrecorded deferred tax assets
| 30/9/2018 | 31/12/2017 |
| L.E. | L.E. |
|
|
|
Unrecorded deferred tax assets (provisions) | 20,055,032 | 14,594,957 |
Deferred tax assets does not include the balances of litigation provision, as there is no high probability to use the deferred tax in the future.
21. RECONCILIATIONS TO CALCULATE THE EFFECTIVE INCOME TAX RATE
| 30/9/2018 | 30/9/2017 |
| L.E. | L.E. |
|
|
|
Net accounting profit before tax | 1,046,005,992 | 968,486,888 |
Tax rate | 22,5% | 22.50% |
Calculated income tax according to income tax law | 235,373,848 | 217,909,550 |
Provisions effect | 2,250 | 1,041,743 |
Impairment effect | 1,092,680 | - |
Depreciation differences | (86,417) | (187,994) |
Tax exemptions | (274,918) | (6,324,972) |
Utilities completion liabilities | (7,275,119) | - |
Training and rehabilitation fund | 414,887 | - |
Un-deductible expenses | 57,150 | 46,350 |
Income tax according to statement of income | 229,304,361 | 212,484,677 |
Effective income tax rate | 21.92% | 21.94% |
22. REVENUES AND COST OF REVENUES
22-a Net revenues
| 30/9/2018 | 30/9/2017 |
| L.E. | L.E. |
Property sales revenue |
|
|
Tag Sultan Project | 235,644,325 | 170,698,033 |
Premira Project | 102,780,982 | - |
Tag City (Zone T) Project | 96,133,265 | 222,990,471 |
Tag City (Zone B) Project | 350,857,148 | - |
Capital Garden project | 88,488,384 | 30,604,126 |
Sarai City 1 project | 212,989,414 | 1,585,516 |
Sarai City 2 project | 115,952,788 | 883,553,231 |
Sarai City 3 project | 108,152,024 | - |
El Waha Project | 120,000 | 1,810,459 |
Total property sales revenue | 1,311,118,330 | 1,311,241,836 |
Land sales revenue - El Waha and Original City project | 214,280,140 | - |
Total property and land sales revenues | 1,525,398,470 | 1,311,241,836 |
|
|
|
Less: |
|
|
Tag Sultan Project sales returns | (1,366,350) | (374,595) |
Premira sales returns | (244,400) | (1,268,155) |
Tag City Zone T sales returns | (32,744,585) | (8,117,545) |
Tag City Zone B sales returns | (7,817,419) | - |
Capital Garden sales returns | (4,611,318) | (1,628,552) |
Sarai City 1 project sales returns | (6,569,421) | (1,262,000) |
Sarai City 2 project sales returns | (68,476,774) | (4,287,207) |
El Waha Project sales returns | (1,653,494) | (1,051,980) |
Total finished properties sales returns | (123,483,761) | (17,990,034) |
Net sales | 1,401,914,709 | 1,293,251,802 |
Amortization of notes receivable of present value discount | 281,114,154 | 152,575,176 |
Profit, interest and installments due during the period | 41,410,524 | 57,366,007 |
Income from investment properties | 909,588 | 762,382 |
Net sales revenue | 1,725,348,975 | 1,503,955,367 |
22. REVENUES AND COST OF REVENUES - Continued
22-b Cost of revenues
| 30/9/2018 | 30/9/2017 |
| L.E. | L.E. |
Cost of sold property |
|
|
Cost of Tag Sultan Project | 222,314,275 | 146,335,887 |
Cost of Premira Project | 121,199,445 | - |
Cost of Tag City Zone T Project | 8,534,604 | 25,994,330 |
Cost of Tag City Zone B Project | 39,090,999 | - |
Cost of Capital Garden project | 2,629,994 | 1,237,027 |
Cost of Sarai 1 City project | 32,505,517 | 599,170 |
Cost of Sarai 2 City project | 21,486,253 | 181,926,197 |
Cost of Sarai 3 City project | 6,960,009 | - |
Cost of land sold - El Waha project | - | 439,897 |
Total cost of properties sales | 454,721,096 | 356,532,508 |
Cost of land sold | 3,331,709 | - |
Total cost of land and finished properties sales | 458,052,805 | 356,532,508 |
|
|
|
Less: |
|
|
Cost of Tag Sultan sales returns | (750,470) | (53,611) |
Cost of Premira sales returns | (61,107) | (307,140) |
Cost of Tag City Zone T Project sales returns | (2,950,870) | (422,746) |
Cost of Tag City Zone B project sales returns | (882,894) | - |
Cost of Capital Garden project sales returns | (157,264) | (52,371) |
Cost of Sarai 1 project sales returns | (1,226,607) | (163,725) |
Cost of Sarai 2 project sales returns | (13,161,796) | (617,606) |
Cost of El Waha sales returns | (283,407) | (52,736) |
Total cost of sales returns | (19,474,415) | (1,669,935) |
Net cost of sales | 438,578,390 | 354,862,573 |
Depreciation of investment properties (Note 5/4) | 45,792 | 40,820 |
Cost of revenue | 438,624,182 | 354,903,393 |
23. SELLING AND MARKETING EXPENSES
| 30/9/2018 | 30/9/2017 |
| L.E. | L.E. |
|
|
|
Salaries and wages | 1,297,187 | 957,356 |
Sales and marketing concession | 46,357,248 | 57,817,960 |
Advertisement expenses (including stamp tax) | 82,887,305 | 67,921,091 |
Rent | 6,959,848 | 5,968,280 |
Professional fees | 2,120,350 | 2,379,550 |
Depreciation (Note 4/1) | 1,140,363 | 101,736 |
Transportation and sundry expenses | 4,732,337 | 1,379,405 |
| 145,494,638 | 136,525,378 |
24. GENERAL AND ADMINISTRATIVE EXPENSES
| 30/9/2018 | 30/9/2017 |
| L.E. | L.E. |
|
|
|
Salaries, wages and equivalent | 18,290,430 | 21,018,516 |
Board of Directors remuneration | 4,236,209 | 3,580,209 |
Advertisement expenses | 1,383,164 | 1,200,829 |
Transportation and communications expenses | 5,553,251 | 4,498,271 |
Consulting fees, training and conferences | 6,716,236 | 4,578,150 |
Depreciation (Note 4/1) | 2,773,569 | 2,510,086 |
Maintenance expenses, and software licenses | 4,798,582 | 1,585,720 |
Rent of electronic data storage sites | 2,778,692 | 233,092 |
Raw materials, fuel and spare parts | 2,499,841 | 2,522,615 |
Property tax and stamp tax | 1,361,360 | 517,508 |
International deposit certificates at London Stock Exchange expenses | 2,280,589 | 1,247,643 |
Security, cleaning and training expenses | 2,403,556 | 1,357,978 |
Bank charges | 1,779,738 | 1,002,510 |
Other service expenses | 1,025,719 | 2,786,439 |
| 57,880,936 | 48,639,566 |
25. FINANCING INCOME
| 30/9/2018 | 30/9/2017 |
| L.E. | L.E. |
Return on investment at fair value through profit and loss | 1,221,856 | 4,905,730 |
Credit interest | 21,829,578 | 13,209,676 |
| 23,051,434 | 18,115,406 |
26. OTHER OPERATING REVENUE
| 30/9/2018 | 30/9/2017 |
| L.E. | L.E. |
|
|
|
Administrative fees from customers (for redemption assignment etc.) | 28,970,140 | 12,231,840 |
Delay fines on customers | 6,448,745 | 13,894,925 |
Delay penalty on contractors | - | 710,839 |
Capital gains | 3,648 | - |
Sundry revenue | 3,598,670 | 3,082,493 |
Gain on foreign exchange | 20,712 | - |
| 39,041,915 | 29,920,097 |
27. OTHER EXPENSES
| 30/9/2018 | 30/9/2017 |
| L.E. | L.E. |
|
|
|
Compensations and fines | 8,227,503 | 395,543 |
Donations for others | 625,000 | 25,973,642 |
Loss on foreign exchange | - | 196,433 |
Capital losses | 13,260 | - |
Bad debt - customers | 3,016 | - |
| 8,868,779 | 26,565,618 |
28. EARNINGS PER SHARE
| 30/9/2018 | 30/9/2017 |
| L.E. | L.E. |
|
|
|
Net profit for the period after tax | 816,746,282 | 755,966,053 |
Less: Estimated employees and Board of Directorsshare in profit | (76,000,000) | (49,620,000) |
Shareholders share in net profit | 740,746,282 | 706,346,053 |
Weighted average numbers of shares outstandingduring the period | 1,200,000,000 | 1,199,854,894 |
Earnings per share | 0.62 | 0.59 |
29. CONTINGENT LIABILITIES
Letters of guarantee
The letters of guarantees issued amounted to L.E. 23,204,040 by National Bank of Egypt, Banque Misr, and United Bank as of 30 September 2018 as a guarantee of Al Nasr Company for Utilities and Erections - subsidiary in favor of third parties (31/12/2017: L.E. 93,834,885 includes an amount of L.E. 23,204,040 as a guarantee of Al Nasr Company for Utilities and Erections), the letters are secured by the company's time deposits amounted to L.E. 4,592,268 (31/12/2017: L.E. 4,592,268) - (Note 10), and margin of letters of guarantee by L.E. 6,892,374 (31/12/2017: L.E. 6,892,374) - (Note 9).
30. TRANSACTIONS WITH RELATED PARTIES
Related parties are represented in the shareholding by the company and companies in which the shareholders have directly or indirectly shares that entitles them to exercise control or significant influence.
The company has some transactions with the related parties that include subcontracting of the building, utilities & installation works according to the following:
| Nature of relationship | Nature of transactions | 30/9/2018 | 30/9/2017 |
| L.E. | L.E. | ||
|
|
|
|
|
Al Nasr Co. for Utilities & Erections - S.A.E. | Subsidiary | Utilities and installation works | 53,370,284 | 53,509,196 |
|
|
|
|
|
Al Nasr Co. for Civil Works S.A.E. | Subsidiary | Buildings and utilities works | 21,841,816 | 4,333,597 |
30. TRANSACTIONS WITH RELATED PARTIES - Continued
Balances of related parties are as follows:
| Nature of relationship | Nature of | 30/9/2018 | 31/12/2017 |
| transactions | L.E. | L.E. | |
Amounts due from related parties: |
|
|
|
|
a) Al Nasr Co, for Utilities & Erections S.A.E. | Subsidiary | Long term loan (*) | 4,137,508 | 10,000,000 |
|
| Supplier (Debit) | 92,919,285 | 68,148,494 |
|
| Supplier (Debit) | 14,891 | 1,345,177 |
|
| Advance | 27,870 | 103,819 |
b) Al Nasr Co, for Civil Works S.A.E. | Subsidiary | Supplier (Debit) | 421,757 | 377,824 |
|
| Advance | 8,161,931 | 5,017,784 |
|
|
| 101,545,734 | 74,993,098 |
Amounts due to related parties: |
|
|
|
|
a) Al Nasr Co, for Utilities & Erections S.A.E. | Subsidiary | Retention | 7,110,399 | 6,416,618 |
|
| Supplier (Credit) | 6,155,404 | 5,918,659 |
b) Al Nasr Co, for Civil Works S.A.E. | Subsidiary | Supplier (Credit) | 985,700 | 815,121 |
|
| Warranty | 1,841,928 | 749,839 |
|
|
| 16,093,431 | 13,900,237 |
- The Board of Directors agreed in its meeting held on 18/8/2008 to grant Al Nasr Co, for Utilities & Erections - S.A.E. loan with no interest amounting to L.E. 10 million and an amount of L.E. 5,862,492 has been settled as partial payment of the loan during the period.
- Amount due to/from related parties are disclosed in (Notes 8/1 and 8/2).
31. TAX POSITION
The company submits tax returns to the Tax Authority on due dates and pays taxes on time.
32. FINANCIAL INSTRUMENTS AND RELATED RISKS
On-financial position financial instruments comprise cash and bank balances, financial investments, debtors, creditors, and amounts due from/to subsidiaries, Notes to the separate financial statements include the accounting policies adopted in the recognition and measurement of financial instruments.
The significant risks associated with the financial instruments and the procedures followed by the company to mitigate these risks are as follows:
32. FINANCIAL INSTRUMENTS AND RELATED RISKS - Continued
· Credit risk
Credit risk is the risk that debtors fail to settle the amounts due from them, the company seeks to reduce this risk to the minimum by agreeing with the customers to transfer property after settling all of their debts, also the company takes delay penalties upon later installments which exceeded their due dates calculated on settlement.
· Liquidity risk
Liquidity risk represents all factors which affect the company's ability to pay part or all of its obligations, According to the company's policy sufficient liquidity is maintained which reduce the risk to the minimum.
The following are due dates of the liabilities:
| Less than one year | 1 - 2 years | More than 2 years | Book value |
| L.E. | L.E. | L.E. | L.E. |
30/9/2018 |
|
|
|
|
Long term loans | 160,647,533 | 103,703,828 | - | 264,351,361 |
Creditors and other credit balances | 183,760,341 | - | - | 183,760,341 |
Short term loans | 195,416,666 | - | - | 195,416,666 |
Suppliers and taxes | 274,964,966 | - | - | 274,964,966 |
| 814,789,506 | 103,703,828 | - | 918,493,334 |
31/12/2017 |
|
|
|
|
Long term loans | 177,892,520 | 207,152,774 | - | 385,045,294 |
Creditors and other credit balances | 229,492,922 | - | - | 229,492,922 |
Short term loans | 56,875,747 | - | - | 56,875,747 |
Suppliers and taxes | 374,062,728 | - | - | 374,062,728 |
| 838,323,917 | 207,152,774 | - | 1,045,476,691 |
· Interest rate risk
Interest rate risk represents the risk of changes in the rate of interest, time deposits, loans and bank overdrafts are subject to this risk, the company uses most of its deposits in settling its loans and overdraft balances whenever a gab between debit and credit balances takes place in order to reduce this risk to the minimum as possible.
The following are the financial assets and liabilities according interest rate:
| 30/9/2018 | 31/12/2017 |
| L.E. | L.E. |
Financial assets instruments with fixed interest rate |
|
|
Financial assets - trade receivable | 9,847,072,904 | 8,410,898,725 |
|
|
|
Financial liabilities instruments with variableinterest rate |
|
|
Financial liabilities- short term loans | 497,898,161 | 533,137,838 |
32. FINANCIAL INSTRUMENTS AND RELATED RISKS - Continued
· Foreign currency risk
Foreign currency risk represents the changes in the currency rates which affect the receipts and disbursements and the translation of assets and liabilities in foreign currencies, the company policy is neither takes a loan in foreign currencies nor keep currencies rather than Egyptian pound.
33. CONTRACTUAL COMMITMENTS
The value of contracts with contractors for the implementation of housing and development projects amounted to L.E. 1 billion, the executed works till 30 September 2018 amounted to L.E. 981 million. Contractors' dues have been paid in accordance with the contracts.
34. FAIR VALUE
The fair values of financial assets and liabilities are not materially different from their carrying value as of 30 September 2018, except for investments held for sale.
35. COMPARATIVE FIGURES
Certain of prior year figures have been amended to conform to the separate financial statement presentation for the current year.
36. EARLY RETIREMENT
In accordance with the Board of Directors' Decision No. 26 of 22/12/2016 and the General Assembly Resolution of 29/3/2017, the application of some employees was approved for an optional early retirement. An amount of L.E. 28 million was provided during 2016 where the number of 50 employees retired in 2017. An amount of L.E. 20 million was charged during 2017 to complete the program in 2018.
37. SUBSEQUENT EVENTS TO FINANCIAL POSITION DATE
On 14 October 2018, the company has received an offer from 6th of October Company for Development and Investment S.A.E. (SODIC) regarding Mandatory Purchase offer for the company's shares by direct exchange for shares only.
On 15 October 2018, the Board of Directors had decided studying the offer and mandates the Managing Director for hiring an independent financial consultant to present report to Board of Directors as the legal counsel has been hired for that deal, and information exchanged between the two companies, until the company receive the final offer from SODIC.
Related Shares:
Madinet Nasr S