7th Mar 2018 16:05
Nasr City - Cons 12-2017E2
TO THE SHAREHOLDERS OF
MADINET NASR FOR HOUSING & DEVELOPMENT S.A.E.
REPORT OF THE INDEPENDENT AUDITOR ON THE SUMMARY CONSOLIDATED FINANCIAL STATEMENTS
We have audited the consolidated financial statements of Madinet Nasr for Housing & Development S.A.E. for the year ended 31 December 2017, from which the attached summary consolidated financial statements are derived, in accordance with the Egyptian Standards on Auditing and the relevant laws and regulations. As stated in our Arabic audit report dated 6 March 2018, we expressed an unqualified audit opinion, with an emphasis of matter regarding going concern for a subsidiary, on the consolidated financial statements for the year then ended, from which the attached summary of consolidated financial statements are derived.
In our opinion, the attached summary consolidated financial statements are consistent in all material respects, with the audited consolidated financial statements for the year then ended.
In order to obtain a comprehensive understanding of the company's consolidated financial position as of 31 December 2017, the results of its operations for the year then ended and our scope of audit, you should refer to the Arabic audited consolidated financial statements for the year ended 31 December 2017 and our report thereon.
Mohanad T. Khaled
Fellow of ACCA
Fellow of ESAA
R.A.A. 22444
FRA No. 375
Cairo, 6 March 2018
Madinet Nasr for Housing & Development S.A.E.
CONSOLIDATED SATATEMENT OF FINANCIAL POSITION
At 31 December 2017
31/12/2017 | 31/12/2016 | ||
Note | L.E. | L.E. | |
Assets | |||
Non-Current Assets | |||
Fixed assets (Net) | 4/1 | 54,660,510 | 49,715,813 |
Projects under Construction | 4/2 | 12,927,380 | 15,746,082 |
Held to maturity investments | 5/1 | 672,200 | 672,200 |
Available for sale investments | 5/2 | 4,829,302 | 4,820,722 |
Investment properties | 5/3 | 10,220,066 | 9,377,948 |
Long term notes receivable (Net) | 8 | 5,144,994,601 | 2,972,919,771 |
Deferred tax asset | 32 | 11,960,016 | 9,181,830 |
Total Non-Current Assets | 5,240,264,075 | 3,062,434,366 | |
Current Assets | |||
Inventories | 6 | 54,221,611 | 61,479,086 |
Housing & development projects - WIP | 7 | 1,279,706,549 | 933,619,009 |
Housing & development projects - Finished properties | 7 | 78,262,306 | 78,649,467 |
Short term notes receivable | 8 | 1,576,608,078 | 824,401,148 |
Trade and notes receivables (Net) | 8 | 719,768,886 | 752,470,788 |
Trade payables - debit balances (Net) | 9 | 226,039,067 | 182,202,075 |
Debtors and other debit balances (Net) | 10 | 174,260,035 | 101,442,520 |
Cash margin on letters of guarantee | 10,329,638 | 10,865,252 | |
Investments at fair value through profit or loss | 5/4 | 10,807,609 | 153,043,880 |
Deposits for Projects' maintenance | 22 | 192,332,965 | 111,406,984 |
Cash and bank balances | 11 | 268,982,819 | 152,562,513 |
4,591,319,563 | 3,362,142,722 | ||
Assets held for sale | 4/3 | 14,731,191 | - |
Total Current Assets | 4,606,050,754 | 3,362,142,722 | |
Total Assets | 9,846,314,829 | 6,424,577,088 | |
EQUITY AND LIABILITIES | |||
Equity | |||
Issued and paid up capital | 17 | 997,100,389 | 500,000,000 |
Treasury stocks | - | (74,633,025) | |
Legal reserve | 123,313,788 | 86,375,259 | |
Retained earnings | 332,036,186 | 344,351,026 | |
Net profit for the year | 931,621,229 | 766,575,412 | |
Issued capital and reserves attributable to owners of the parent | 2,384,071,592 | 1,622,668,672 | |
Non-controlling interest | 19 | 70,527,049 | 69,672,444 |
Total Equity | 2,454,598,641 | 1,692,341,116 | |
Non-Current Liabilities | |||
Unearned revenues | 12 | 5,119,127,351 | 2,942,735,224 |
Term loans | 20 | 207,152,774 | 259,282,841 |
Total Non-Current Liabilities | 5,326,280,125 | 3,202,018,065 | |
Current Liabilities | |||
Creditors - customers | 79,187,826 | 87,176,679 | |
Provisions | 13 | 128,640,704 | 131,892,505 |
Creditors | 150,410,550 | 55,501,602 | |
Project infrastructure completion liabilities | 14 | 170,827,359 | 169,428,940 |
Deferred profit & interest on outstanding installments | 15 | 226,811,160 | 304,950,221 |
Dividends payable | 6,962,447 | 3,705,691 | |
Creditors & other credit balances | 16 | 447,911,362 | 339,151,103 |
Current portion of term loans | 20 | 177,892,520 | 4,298,375 |
Short term loans | 21 | 56,875,747 | 19,333,333 |
Liabilities for Projects' maintenance | 22 | 192,401,793 | 111,406,984 |
Credit banks (credit facilities) | 21 | 130,804,575 | 25,259,659 |
Tax Authority | 296,710,020 | 278,112,815 | |
Total current liabilities | 2,065,436,063 | 1,530,217,907 | |
Total Liabilities | 7,391,716,188 | 4,732,235,972 | |
Total Equity and Liabilities | 9,846,314,829 | 6,424,577,088 |
Auditor's report attached.
CFO | CEO | Chairman |
Mr. Mohamed Abdelsalam | Eng. Ahmed Ali El Hitamy | Eng. Mohamed Hazem Barakat |
Madinet Nasr for Housing & Development S.A.E.
CONSOLIDATED STATEMENT OF INCOME
For the year ended 31 December 2017
31/12/2017 | 31/12/2016 | ||
Note | L.E. | L.E. | |
Net revenues | 23-a | 2,428,257,956 | 2,014,424,600 |
Less: | |||
Cost of revenues | 23-b | (840,532,674) | (658,584,284) |
Gross Profit | 1,587,725,282 | 1,355,840,316 | |
Less: | |||
Selling & marketing expenses | 25 | (252,810,416) | (133,937,136) |
General & administrative expenses | 26 | (112,163,005) | (76,093,021) |
Provision | (32,720,662) | (86,142,850) | |
Provisions no longer required | 4,328,290 | - | |
Impairment of receivables | (2,927,501) | (14,760,648) | |
Impairment of in trade payables - debit balances | - | (16,519,352) | |
Finance expenses | (28,371,826) | (11,076,446) | |
Add: | |||
Finance Revenue | 27 | 31,254,148 | 20,106,168 |
Profit from operations | 1,194,314,310 | 1,037,417,031 | |
Revenue from investments available for sale | 845,622 | 344,309 | |
Other revenues | 28 | 46,226,306 | 23,185,423 |
Other expenses | 29 | (38,669,391) | (29,264,575) |
Net profit for the year before tax | 1,202,716,847 | 1,031,682,188 | |
Income tax | (272,441,848) | (264,668,491) | |
Deferred tax | 32 | 2,778,187 | 1,887,150 |
Net profit for the year | 933,053,186 | 768,900,846 | |
Less: Non-controlling interest | (1,431,957) | (2,325,434) | |
Attributable to owners of the parent | 30 | 931,621,229 | 766,575,412 |
Earnings per share for the year | 34 | 0.84 | 0.70 |
CFO | CEO | Chairman |
Mr. Mohamed Abdelsalam | Eng. Ahmed Ali El Hitamy | Eng. Mohamed Hazem Barakat |
Madinet Nasr for Housing & Development S.A.E.
CONSOLIDATED STATEMENT OF COMPREHENSIVE INCOME
For the year ended 31 December 2017
31/12/2017 | 31/12/2016 | |
L.E. | L.E. | |
Net profit for the year | 933,053,186 | 768,900,846 |
Other comprehensive income | 8,580 | 1,608 |
Total comprehensive income for the year | 933,061,766 | 768,902,454 |
Non-controlling interest | (1,436,036) | (2,326,198) |
Owners of the parent | 931,625,730 | 766,576,256 |
CFO | CEO | Chairman |
Mr. Mohamed Abdelsalam | Eng. Ahmed Ali El Hitamy | Eng. Mohamed Hazem Barakat |
Madinet Nasr for Housing & Development S.A.E.
CONSOLIDATED STATEMENT OF CHANGES IN SHAREHOLDERS' EQUITY
For the year ended 31 December 2017
Issued and paid up Capital | Treasury stocks | Legal reserve | Retained earnings | Net profit for the year | Total owners of the parent | Non-controlling interest | Total Equity | |
L.E. | L.E. | L.E. | L.E. | L.E. | L.E. | L.E. | L.E. | |
Balance at 1 January 2016 | 250,000,000 | - | 74,725,127 | 377,463,144 | 262,098,712 | 964,286,983 | 68,301,160 | 1,032,588,143 |
Increase in capital according to Extraordinary General Assembly Meeting held on 14/12/2015 | 125,000,000 | - | - | (125,000,000) | - | - | - | - |
Purchase of treasury stocks of 4 million stocks on 14/2/2016 | - | (74,633,025) | - | - | - | (74,633,025) | - | (74,633,025) |
Transferred to retained earnings | - | - | - | 262,098,712 | (262,098,712) | - | - | - |
Transferred reserves for dividends at 2015 | - | - | 11,650,132 | (11,650,132) | - | - | - | - |
Dividends for 2015 | - | - | - | (36,115,409) | - | (36,115,409) | - | (36,115,409) |
Increase in capital according to Extraordinary General Assembly Meeting held on 5/4/2016 | 125,000,000 | - | - | (125,000,000) | - | - | - | - |
Used retained earnings for Al Nasr Company for Civil Works | - | - | - | (1,197,462) | - | (1,197,462) | (954,914) | (2,152,376) |
Reduce tax return for 2014 | - | - | - | 3,751,330 | - | 3,751,330 | - | 3,751,330 |
Total comprehensive income | - | - | - | 843 | 766,575,412 | 766,576,255 | 2,326,198 | 768,902,453 |
Balance at 31 December 2016 | 500,000,000 | (74,633,025) | 86,375,259 | 344,351,026 | 766,575,412 | 1,622,668,672 | 69,672,444 | 1,692,341,116 |
Sale of treasury stocks of 4 million stocks | - | 74,633,025 | - | (1,433,024) | - | 73,200,001 | - | 73,200,001 |
Transferred to retained earnings | - | - | - | 766,575,412 | (766,575,412) | - | - | - |
Dividends for 2016 | - | - | 36,938,529 | (259,938,529) | - | (223,000,000) | - | (223,000,000) |
Increase in capital according to Extraordinary General Assembly Meeting held on 29/3/2017 | 500,000,000 | - | - | (500,000,000) | - | - | - | - |
Used retained earnings for Al Nasr Company for Civil Works | - | - | - | (641,605) | - | (641,605) | (581,431) | (1,223,036) |
Decrease in share capital by cancelled share option | (2,899,611) | - | - | (16,881,595) | - | (19,781,206) | - | (19,781,206) |
Total comprehensive income | - | - | - | 4,501 | 931,621,229 | 931,625,730 | 1,436,036 | 933,061,766 |
Balance at 31 December 2017 | 997,100,389 | - | 123,313,788 | 332,036,186 | 931,621,229 | 2,384,071,592 | 70,527,049 | 2,454,598,641 |
CFO | CEO | Chairman |
Mr. Mohamed Abdelsalam | Eng. Ahmed Ali El Hitamy | Eng. Mohamed Hazem Barakat |
Madinet Nasr for Housing & Development S.A.E.
CONSOLIDATED STATEMENT OF CASH FLOWS
For the year ended 31 December 2017
31/12/2017 | 31/12/2016 | ||
Note | L.E. | L.E. | |
OPERATING ACTIVITIES | |||
Net profit for the year before tax | 1,202,716,847 | 1,031,682,187 | |
Adjustments for: | |||
Depreciation of fixed assets and investment property | 4, 5/13 | 8,281,988 | 7,245,408 |
Provisions | 13 | 32,720,662 | 86,142,850 |
Provisions no longer required | (4,328,290) | - | |
Impairment of receivables | 2,927,501 | 14,760,648 | |
Impairment of trade payables - debit balances | - | 16,519,352 | |
Dividends from available for sale investments | (845,622) | (344,309) | |
Gain on sale of fixed assets | (190) | (174,947) | |
Net recognized installment - sale profit and interest | (75,024,473) | (48,387,838) | |
Discount of present value for long term liability | - | 451,450 | |
Operating profit before working capital changes | 1,166,448,423 | 1,107,894,801 | |
Inventory and housing and development projects | (338,442,904) | (233,821,255) | |
Trade receivables, debtors and debit balances | (3,029,611,504) | (2,495,606,071) | |
Trade payables and other credit balances | 2,368,066,666 | 1,609,345,412 | |
Provisions used | 13 | (31,644,173) | (991,275) |
Dividends paid to directors and employees | (67,802,382) | (37,926,140) | |
Income Tax paid | (253,844,643) | (56,937,811) | |
Net cash used in operating activities | (186,830,517) | (108,042,339) | |
INVESTING ACTIVITIES: | |||
Payments for purchase of fixed assets and projectsunder construction | (25,256,038) | (9,643,782) | |
Proceeds on sale of fixed assets | 5,000 | 179,000 | |
Payments for investment properties | (898,103) | (1,783,628) | |
Revenue from available for sale investments | 49,668 | 342,701 | |
Net cash used in investing activities | (26,099,473) | (10,905,709) | |
FINANCING ACTIVITIES: | |||
Treasury stocks | (150,000,000) | - | |
Sale/Purchase of treasury stocks | 73,200,001 | (74,633,025) | |
Non-controlling interest | (637,384) | (954,150) | |
Proceeds from long term loans | 127,755,776 | 193,032,788 | |
Repayments of long term loans | (6,291,698) | (2,698,235) | |
Repayments of short term loans | (119,028,092) | (65,618,071) | |
Proceeds from short term loans | 156,570,506 | 58,340,930 | |
Net cash from financing activities | 81,569,109 | 107,470,237 | |
Change in cash and cash equivalents | (131,360,881) | (11,477,811) | |
Cash and cash equivalents at the beginning of the year | 280,346,734 | 291,824,545 | |
Total cash and cash equivalents at the end of the year | 148,985,853 | 280,346,734 | |
Less: Pledged time deposits against letters of guarantee | (65,691,426) | (66,735,819) | |
Cash and cash equivalents at the end of the year | 21 | 83,294,427 | 213,610,915 |
CFO | CEO | Chairman |
Mr. Mohamed Abdelsalam | Eng. Ahmed Ali El Hitamy | 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 and was changed to Joint Stock Company according to Presidential Decree No 2908/1964, then became a subsidiary of Public Sector Authority for Housing by Presidential Decree No. 469/1983.
The company was converted under the provisions of Law No. 203 for 1991 issued on 30/06/1996 to an Egyptian joint stock company as a subsidiary to the Holding Company for Housing under the name of Madinet Nasr Housing and Development. The Extraordinary General Assembly of the company held on 30/06/1996 approved the change in the governing laws under which the company was operating from the provisions of Law No. 203 for 1991 to the provisions of Law No. 159 for 1981 and its executive regulations and published in company's journal on January 1997.
The Company has commercial registry No. (300874) dated 23 December 1996 and Tax Registration No. 200-009-095.
1.2 Activity
The company is engaged in all activities related to development of land and 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 in all residential, administrative, tourist, recreational and all projects necessary to achieve these purposes, and all real estate operations, financial, commercial and entertainment related to these purposes, as well as carrying out design, and engineering consultancy, and supervision of the execution by others.
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, Nasr City, Cairo, Egypt.
The Chairman is Eng. Mohamed Hazem Barakat.
The company's ordinary shares are listed on the Egyptian Exchange (EGX) and, as Global Depositary Receipts (GDRs),
The company Board of Directors has approved the Financial Statements for the year ended at 31 December 2017 on 25 February 2018.
1.5 Basis of consolidation
§ Subsidiaries are those enterprises controlled by the parent company. Control exists when the parent company has the power directly or indirectly, to govern the financial and operating policies of an enterprise so as to obtain benefits from its activities.
§ The consolidated financial statements include the financial statements of the company and its subsidiaries.
1. COMPANY BACKGROUND - Continued
§ The financial statements of the subsidiaries are prepared for the same reporting year as the parent company, using consistent accounting policies.
§ All intra-group balances, transactions, income and expenses and profits and losses resulting from intra-group transactions that are recognized as assets and liabilities, are eliminated in full.
§ Subsidiaries are fully consolidated from date of acquisition, being the date on which the group obtains control, and continue to be consolidated until the date such control ceases.
§ Non-controlling interests represent the portion of total comprehensive income and net assets not held by the group are presented separately in statement of income and within equity in consolidated balance sheet, separate from owners of parent's equity.
The following is a listing of subsidiaries:
Subsidiary | Percentage Ownership | Country of incorporation | Activity |
Al Nasr for Civil Works S.A.E. | 52.46% | Egypt | Civil construction |
Al Nasr for Utilities and Erection S.A.E. | 97.52% | Egypt | Civil construction |
2. USE OF ESTIMATES AND JUDGMENTS
The preparation of consolidated 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 assumptions 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 are items on the financial statements that are effected by judgments, assumptions, and estimates:
- Depreciation of fixed assets
- Provisions
- Assets impairment
- Taxation
- Cost of sales and cost of completion of infrastructure liability
- Amortization of present value of notes receivable
3. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES
a) Basis of preparation of consolidated financial statements
The consolidated financial statements were prepared in accordance with the Egyptian Accounting Standards and relevant local laws and regulations.
The consolidated 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 consolidated financial statements are presented in Egyptian Pounds.
b) Fixed assets and depreciation
Fixed assets are recorded on purchase at cost and are presented in the balance sheet 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 labor 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.
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 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 as follows:
Madinet Nasr for Housing & Development | Al Nasr for Civil Works | Al Nasr for Utilities & Erections | |
Years | Years | Years | |
Buildings | 50 | 10-40 | 20-50 |
Machinery & equipment for operation | 5 | 2-10 | 2-10 |
Machinery & equipment for serving & utilities | 5-12.5 | - | - |
Motor vehicles | 5 | 5-10 | 4-6 |
Tools | 1 | 4-10 | 4-12 |
Furniture and office equipment | 10 | 10 | 10-15 |
c) Projects Under Constructions
Projects under construction are recorded at cost which includes all the direct costs incurred on the assets to be ready to use. These are transferred to fixed assets when the asset is complete and ready for its intended use. "Projects under construction" is recorded at cost less impairment, if any.
3. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued
d) Available for sales investment
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 statement of income.
e) Held to maturity investments
Held to maturity investments are carried at cost and amortized using the effective interest method. Premiums or discounts (if any) are amortized using the effective interest method. When the investment is impaired, the impairment loss is adjusted against book value and included in the statement of income.
f) Investment properties
Investment properties are measured at cost and when such assets are impaired, the loss is included in the statement of income.
g) Investments at fair value through profit and loss (investment certificates)
Investment certificates are measured at fair value which represents the sale value, determined in line with the recoverable amount at the balance sheet date.
Investments classified as investment at fair value through profit and loss and the associated costs of these investments and differences charges are recorded in the statement of income.
h) Inventories
Inventories are stated at the lower of cost or net realizable value. Costs include expenses incurred in bringing each product to its present location and condition. Cost of raw materials, packing materials, spare parts, fuel and oil is determined on an weighted average basis.
Net realizable value is based on estimated selling price less selling expenses. Provision is made for obsolete and slow moving items.
i) Housing & 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.
j) Cash flow statement
Consolidated cash flow statement is prepared according to the indirect method
3. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued
k) Cash and cash equivalents
Cash and cash equivalents include cash on hand, time deposits (due within 3 months), investments at fair value through profit or loss, bank current accounts, and short term highly liquid investments, which can be easily converted to cash, less overdrafts (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.
The notes are the value of the 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 financial statements, notes 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 goods or providing the services.
m) Assets impairment
Asset values are reviewed at the consolidated balance sheet date to determine if there is any indication of impairment. In case of such an indication, an estimate is made of the recoverable amount and compared to the book value. Impairment loss, being the excess of book value over its recoverable amount, is taken to the consolidated statement of income on the same date.
n) Provisions
Provisions are recognized when there is a present obligation (legal or constructive) 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 consolidated statement of financial position date and adjusted (if unearned revenue, 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 statement of 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 statement of income on the date of delivery of the units sold to customers.
3. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued
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 the 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. Sales on installments
- Total sale of value of land and property is recorded as sales during the year after deduction of profit relating to deferred installments on those sales. Such deduction is recorded as a liability (profit from deferred installments) 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.
- Deferred installments profit and deferred interests on installments which related to sale of land and properties in prior years are recognized on the accrual 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:
3. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued
· Development of land for construction of real estate
· Construction of the building
· Finishing of units; within a year
4. Co-development projects:
On 31 December 2015, the Company adopted a new strategy to execute a joint venture 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 revenue:
- Rent, time deposits interest and bonds revenue recorded on the accrual basis.
- Dividends revenue are recognized and recorded as income when they become legally payable by the investee companies and realized after acquisition date.
6. Contracting Revenue
Contacting revenue of the two subsidiary companies included value of contracts with customers, approved change orders, incentives, and other claims. Revenue from contracting is recognized following percentage-of-completion method.
Direct and indirect cost
Direct and indirect costs incurred for the constructions of the real estate are accumulated in the housing and development projects inventory account. Cost of the completed units are comprises of land cost, cost of building constructed and other indirect costs.
s) Rent expenses
Rent expenses are recorded in the statement of income on a straight line method over the rent period.
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 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 income statement in the period in which they are approved for early retirement.
3. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued
u) Taxation
Income tax
Income tax on profit for the current and previous periods that have not been paid and need to be recognized are recorded as a liability. Provision is made for income tax liability for previous years based on the assessment of tax claims.
Deferred tax
Deferred tax is recognized under the liability method for temporary timing differences between assets and liabilities valued on the tax basis and the related amounts in the consolidated financial statements.
The amount is determined using the tax rates applicable on the consolidated balance sheet date. Deferred tax assets are recognized for all temporary differences, unused deferred tax assets and losses brought forward, if taxable profit is highly probable and the assets can be used in the future. Deferred tax assets are reviewed and reduced by the amount which is not expected to be used in the foreseeable future.
v) Earnings per share
Earnings per share are calculated by dividing the net profit for the year/period after deduct employees share in profit and Board of Directors share in profit by the weighted average number of shares outstanding during the year/period.
w) Borrowing cost
Borrowing costs directly attributable to the acquisition, construction or production of an asset, qualified for capitalization of borrowing cost, are charged as part of the cost of the asset. Other borrowing costs are charged as an expense in the statement of income on a time-apportioned basis using the effective interest rate.
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 consolidated balance sheet date are translated at the rate of exchange ruling at that date. Retranslation exchange profit and loss is taken to the consolidated statement of income.
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 2017 | 1,820,942 | 19,245,716 | 34,153,477 | 18,912,686 | 3,839,923 | 13,730,410 | 15,668,289 | 107,371,443 |
Additions during the year | - | 7,984,174 | 35,696 | 27,200 | 76,717 | 1,628,486 | 3,288,173 | 13,040,446 |
Transfer from projects under construction (4/2) | - | 181,741 | - | - | - | 121,362 | - | 303,103 |
Disposals | (160,625) | (102,200) | - | (21,471) | - | (126,974) | - | (411,270) |
At 31 December 2017 | 1,660,317 | 27,309,431 | 34,189,173 | 18,918,415 | 3,916,640 | 15,353,284 | 18,956,462 | 120,303,722 |
Accumulated depreciation: | ||||||||
At 1 January 2017 | - | 4,783,863 | 21,789,362 | 16,228,786 | 3,413,639 | 8,013,823 | 3,426,157 | 57,655,630 |
Provided during the year | - | 554,665 | 3,517,149 | 950,324 | 69,236 | 1,396,951 | 1,737,678 | 8,226,003 |
Relating to disposals | - | (94,787) | - | (21,470) | - | (122,164) | - | (238,421) |
At 31 December 2017 | - | 5,243,741 | 25,306,511 | 17,157,640 | 3,482,875 | 9,288,610 | 5,163,835 | 65,643,212 |
Net book value: | ||||||||
At 31 December 2017 | 1,660,317 | 22,065,690 | 8,882,662 | 1,760,775 | 433,765 | 6,064,674 | 13,792,627 | 54,660,510 |
At 31 December 2016 | 1,820,942 | 14,461,853 | 12,364,115 | 2,683,900 | 426,284 | 5,716,587 | 12,242,132 | 49,715,813 |
(*) Land and buildings including land and buildings of the social club for Madinet Nasr for Housing & Development club by book value approximately L.E. 1.3 million and L.E. 4.5 million for land and buildings respectively, also the buildings and constructions of El Nasr for Utilities on a plot of land of 7,780 M2 by a usufruct right for the company with unlimited period and there are negotiation to purchase this land.
4/1 FIXED ASSETS - Continued
a) Fully depreciated assets and still working are as follows:
31/12/2017 | 31/12/2016 | |
L.E. | L.E. | |
Buildings and constructions | 527,078 | 771,710 |
Motor vehicles | 14,982,407 | 13,437,233 |
Furniture and office equipment | 4,607,708 | 3,982,794 |
Machinery & equipment | 17,617,372 | 17,080,773 |
Tools | 3,254,703 | 3,281,983 |
40,989,268 | 38,554,493 |
b) Depreciation for the period is allocated as follows:
31/12/2017 | 31/12/2016 | |
L.E. | L.E. | |
Cost of sales | 4,487,256 | 4,360,203 |
Selling & marketing expenses (Note 25) | 142,712 | 68,055 |
General and administrative expenses (Note 26) | 3,596,035 | 2,817,150 |
8,226,003 | 7,245,408 |
4/2 PROJECTS UNDER CONSTRUCTION
31/12/2017 | 31/12/2016 | |
L.E. | L.E. | |
Balance at the beginning of the year | 375,308 | 724,938 |
Additions | 12,215,592 | 400,228 |
Transferred to fixed assets (Note 4/1) | (303,103) | (749,858) |
Balance at the end of the year (Parent Co.) | 12,287,797 | 375,308 |
Al Nasr Company for Civil Works | 639,583 | 15,370,774 |
12,927,380 | 15,746,082 |
4/3 ASSETS HELD FOR SALE
Al Nasr Company for Civil Works
31/12/2017 | 31/12/2016 | |
L.E. | L.E. | |
Land and building of administrative building at Nasr City | 14,731,191 | - |
The land and building has been transferred from projects under construction to assets held for sale based on Board of Directors' decision to sell the building.
5. INVESTMENTS
5/1 Held to maturity investments
31/12/2017 | 31/12/2016 | |
L.E. | L.E. | |
Investments in Governmental bonds | 672,200 | 672,200 |
5/2 Available for sale investments
Contribution | 31/12/2017 | 31/12/2016 | |
% | L.E. | L.E. | |
Egyptian Kuwaiti Real Estate Development | 7.503 | 4,314,110 | 4,314,110 |
High Education House ( S.A.E.) | 1.76 | 300,000 | 300,000 |
Investments in other companies | 215,192 | 206,612 | |
4,829,302 | 4,820,722 |
5.3 Investment properties
31/12/2017 | 31/12/2016 | |
L.E. | L.E. | |
Allocated land for Developing and Housing Projects | 5,919,456 | 5,021,353 |
Title held land on sold properties (*) | 3,427,691 | 3,427,691 |
Rental building - Net (**) | 872,919 | 928,904 |
10,220,066 | 9,377,948 |
(*) Fair value of investment properties is not less than its book value.
(**) Rental building - Net
Residential units | None residential units | Total | |
L.E. | L.E. | L.E. | |
Cost: | |||
At 1 January 2017 and | |||
at 31 December 2017 | 545,997 | 2,882,169 | 3,428,167 |
Accumulated depreciation: | |||
At 1 January 2017 | 439,871 | 2,059,391 | 2,499,261 |
Provided during the year | 8,087 | 47,898 | 55,985 |
At 31 December 2017 | 447,958 | 2,107,289 | 2,555,246 |
Net book value: | |||
At 31 December 2017 | 98,039 | 774,880 | 872,919 |
At 31 December 2016 | 106,126 | 822,778 | 928,904 |
5. INVESTMENTS - Continued
5.4 Investments at fair value through profit and loss
31/12/2017 | 31/12/2016 | |
L.E. | L.E. | |
Investment certificates in: | ||
QNB Investment Fund | 992,307 | 20,485,037 |
Bank Misr Investment Fund (Day-By-Day) | 240,662 | 209,910 |
Banque Du Caire Investment Fund | 859,676 | 10,309,968 |
Arab African International Bank Investment Fund | - | 61,845,230 |
Arab Investment Bank Investment Fund | - | 635,154 |
United Bank Investment Fund | 8,693,005 | 30,493,146 |
Arab Banking Corporation (ABC Bank) | 21,959 | 19,236 |
Egyptian Gulf Bank Investment Fund | - | 29,046,199 |
10,807,609 | 153,043,880 |
6. INVENTORIES
31/12/2017 | 31/12/2016 | |
L.E. | L.E. | |
Materials | 47,528,173 | 56,686,253 |
Fuel and oil | 319,803 | 42,254 |
Spare parts and supplies | 957,739 | 657,018 |
Others (materials on site & WIP) | 5,550,896 | 4,228,561 |
54,356,611 | 61,614,086 | |
Less: Inventory Impairment Allowance | (135,000) | (135,000) |
54,221,611 | 61,479,086 |
7. HOUSING & DEVELOPMENT PROJECTS
31/12/2017 | 31/12/2016 | |
L.E. | L.E. | |
Uncompleted units and lands: | ||
El Waha Project | 141,766,889 | 58,739,776 |
6th October Project | 133,832,030 | 81,297,193 |
Tag City Project | 608,086,720 | 515,839,022 |
Nasr City (Main City) Project | 2,297,896 | 2,192,807 |
Sarai City | 393,723,014 | 275,550,211 |
1,279,706,549 | 933,619,009 | |
Completed units: | ||
El Waha Project | 6,420,410 | 6,860,307 |
Nasr City (Main City) Project | 11,563,454 | 11,510,718 |
6th October Project | 60,278,442 | 60,278,442 |
78,262,306 | 78,649,467 | |
Total lands, incomplete and completed units | 1,357,968,855 | 1,012,268,476 |
8. TRADE AND NOTES RECEIVABLE
31/12/2017 | 31/12/2016 | |
L.E. | L.E. | |
Long term notes receivable | ||
Tag Sultan Project | 450,606,088 | 683,511,420 |
Tag City (Zone T) Project | 2,467,547,802 | 1,816,367,743 |
Tag City (Zone B) Project | 257,133,516 | - |
Premira Project | 82,497,978 | 111,979,819 |
Capital Gardens | 370,059,492 | 290,698,766 |
Sarai City | 2,791,411,454 | 802,957,659 |
Total long term notes receivables | 6,419,256,330 | 3,705,515,407 |
less: Discount to present value | ||
Tag Sultan Project | (72,679,392) | (114,904,766) |
Tag City (Zone T) Project | (447,929,785) | (335,359,378) |
Tag City (Zone B) Project | (41,881,651) | - |
Premira Project | (29,156,749) | (39,094,440) |
Capital Gardens | (130,856,066) | (95,573,596) |
Sarai City | (551,758,086) | (147,663,456) |
Total present value discount | (1,274,261,729 ) | (732,595,636 ) |
Net long term notes receivable at present value | 5,144,994,601 | 2,972,919,771 |
Short term notes receivable | ||
Tag Sultan Project | 239,698,796 | 286,266,213 |
Tag City (Zone T) Project | 548,036,867 | 327,976,263 |
Tag City (Zone B) Project | 57,907,386 | - |
Premira Project | 51,796,263 | 42,057,701 |
Sarai City | 679,168,766 | 168,100,972 |
1,576,608,078 | 824,401,148 | |
Trade receivables (Net) | ||
Tag Sultan Project | 4,830,678 | 12,168,438 |
Tag City (Zone T) Project | 59,461,906 | 60,778,760 |
Premira Project | 516,394 | 452,172 |
Sarai City | 54,767,667 | 15,147,537 |
El Waha and Nasr City project' customers | 242,857,571 | 310,462,472 |
Land | 51,471,905 | 93,971,588 |
Rent | 1,128,196 | 801,521 |
Construction contracts | 356,186,354 | 306,306,584 |
771,220,671 | 800,089,072 | |
Less: Impairment of trade receivables | (51,451,785) | (47,618,284) |
719,768,886 | 752,470,788 |
9. TRADE PAYABLES - DEBIT BALANCES - NET
31/12/2017 | 31/12/2016 | |
L.E. | L.E. | |
Trade payables & contractors | 262,653,259 | 220,815,911 |
Less: Impairment in trade payables - debit balances | (36,614,192) | (38,613,836) |
226,039,067 | 182,202,075 |
10. DEBTORS AND OTHER DEBIT BALANCES - NET
31/12/2017 | 31/12/2016 | |
L.E. | L.E. | |
Margin of letter of credit | 4,464,558 | - |
Cheques under collection | 1,826,132 | 4,751,577 |
Prepaid expenses | 160,601,026 | 62,714,026 |
Accrued revenue | 2,180,029 | 1,187,539 |
Refundable deposits | 3,373,402 | 6,959,260 |
Employees stock option system | - | 19,781,206 |
Employees loans | 84,623 | 4,492 |
Other debit balances | 1,793,425 | 6,215,580 |
174,323,195 | 101,613,680 | |
Less: Impairment in debtors and other debit balances | (63,160) | (171,160) |
174,260,035 | 101,442,520 |
11. CASH AND BANK BALANCES
31/12/2017 | 31/12/2016 | |
L.E. | L.E. | |
Bank balances | 62,508 | 2,656,627 |
Cash on hand | 544,923 | 98,193 |
Bank current accounts with return | 201,676,230 | 82,064,142 |
Time deposits (*) | 66,699,158 | 67,743,551 |
268,982,819 | 152,562,513 |
(*) Time deposit on 31 December 2017 included L.E. 65,691,426 (31/12/2015: L.E. 66,735,819) pledged time deposits against letters of guarantee.
12. UNEARNED REVENUES
31/12/2017 | 31/12/2016 | |
L.E. | L.E. | |
Tag Sultan Project customers | 518,912,026 | 914,074,338 |
Premira Project customers | 133,437,248 | 132,802,873 |
Zone T Project customers | 2,010,245,953 | 1,284,084,678 |
Zone B Project customers | 198,573,733 | - |
Capital Gardens customers | 99,520,063 | 74,858,322 |
Sarai City customers | 2,158,419,742 | 536,878,946 |
Rental customers | 18,586 | 36,067 |
5,119,127,351 | 2,942,735,224 |
13. PROVISIONS
Balance at 1/1/2017 | Provided during the year | Used during the year | No longer required | Balance at 31/12/2017 | |
L.E. | L.E. | L.E. | L.E. | L.E. | |
Disputed taxes provision | 14,229,668 | - | (2,000,962) | - | 12,228,706 |
Claims provision | 44,928,668 | 3,445,870 | (465,172) | - | 47,909,366 |
Legal provision | 25,444,446 | 262,644 | (1,177,073) | (3,563,290) | 20,966,727 |
Early retirement provision | 28,000,000 | - | (28,000,000) | - | - |
Projects contingency provision | - | 13,000,000 | - | - | 13,000,000 |
General provision | 765,000 | 15,000,000 | - | (765,000) | 15,000,000 |
Other provisions | 18,524,723 | 1,012,148 | (966) | - | 19,535,905 |
131,892,505 | 32,720,662 | (31,644,173) | (4,328,290) | 128,640,704 |
14. PROJECT INFRASTRUCTURE COMPLETION LIABILITIES
Balance at 1/1/2017 | Additions | Work executed | Balance at 31/12/2017 | |
L.E. | L.E. | L.E. | L.E. | |
Tag City project | 98,109,732 | 96,721,974 | (115,507,842) | 79,323,864 |
Sarai City project | 55,160,315 | 183,289,417 | (164,294,598) | 74,155,134 |
Capital Gardens project | 1,571,707 | 1,287,553 | - | 2,859,260 |
El Waha Project | 13,764,829 | 119,056 | (81,000) | 13,802,885 |
Nasr City project | 822,357 | - | (136,141) | 686,216 |
169,428,940 | 281,418,000 | (280,019,581) | 170,827,359 |
15. DEFERRED PROFIT & INTEREST ON OUTSTANDING INSTALLMENTS
Land | Property | Total | |
L.E. | L.E. | L.E. | |
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 |
31/12/2016 | |||
Balance at beginning of the year | 74,879,792 | 275,185,395 | 350,065,187 |
Additions during the year | 34,759,564 | 3,167,144 | 37,926,708 |
Due during the year | (29,094,977) | (50,714,208) | (79,809,185) |
Disposals during the year | - | (3,232,489) | (3,232,489) |
Balance at the end of the year | 80,544,379 | 224,405,842 | 304,950,221 |
16. CREDITORS AND OTHER CREDIT BALANCES
31/12/2017 | 31/12/2016 | |
L.E. | L.E. | |
Notes payable | 9,131,934 | 6,431,070 |
Support to National Housing Project | 880,000 | 880,000 |
Final retention and other refundable deposits | 222,190,231 | 207,692,116 |
Down payment for land & property sales (El Waha & 6th October) | 6,069,741 | 6,374,405 |
Down payment for land & property sales (Tag Sultan) - T Zone - Premira | 7,781,757 | 1,703,311 |
Selling commissions | 23,304,415 | 31,320,065 |
Payments from residents of El Haggana and El Arab | - | 1,249,049 |
Employees' bonus accrued | 12,886,045 | 6,315,009 |
Remain cost from construction contracts | 19,337,418 | 14,166,450 |
Engineering stamp for Building Union | 107,356 | 48,067 |
Customers' balances for canceled reservations | 12,004,283 | 12,004,283 |
Proceeds for maintenance expenses and counters | 9,886,005 | 8,441,753 |
Accrued interest on long term loans | 19,222,292 | - |
Governmental authorities | 34,108,271 | 15,386,255 |
Accrued expenses | 45,748,121 | 21,713,524 |
Early retirement benefits and others | 25,253,493 | 5,425,746 |
447,911,362 | 339,151,103 |
17. SHARE CAPITAL
Authorized capital:
The authorized capital is five billion Egyptian Pounds.
31/12/2017 | 31/12/2016 | |
L.E. | L.E. | |
Issued and paid up | 997,100,389 | 500,000,000 |
18. EMPLOYEES STOCK OPTIONS
The Extraordinary General Assembly Meeting approved on 29/3/2017 the discontinuation of employee stock options and written off the remaining 2,899,611 shares for an amount of L.E. 2,899,611. On 10/07/2017 the commercial register was updated for the decrease in the share capital.
19. NON-CONTROLLING INTEREST
31/12/2017 | 31/12/2016 | ||
Minority interest in net assets | Minority interest share in net assets | Minority interest share in net assets | |
% | L.E. | L.E. | |
Al Nasr Company for Civil Works | 47.54 | 72,064,471 | 70,863,021 |
Al Nasr Company for Utilities & Erection | 2.48 | (1,537,422) | (1,190,577) |
Total non-controlling interest | 70,527,049 | 69,672,444 |
20. TERM LOANS
Madinet Nasr for Housing & Development S.A.E.
National Investment Bank | Arab Investment Bank | Commercial International Bank | Total | |
L.E. | L.E. | L.E. | L.E. | |
31/12/2017 | ||||
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 to balance sheet as follows: | ||||
Current liabilities: | ||||
Current portion of term loans | 456,524 | 2,026,971 | 175,409,025 | 177,892,520 |
Non-current liabilities: | ||||
Term loans | 1,237,813 | - | 205,914,961 | 207,152,774 |
31/12/2016 | ||||
Balance at the beginning of the year | 2,543,087 | 10,168,154 | 60,535,422 | 73,246,663 |
Proceeds during the year | - | - | 193,032,788 | 193,032,788 |
Payments of installments duringthe year | (414,011) | (2,284,224) | - | (2,698,235) |
Balance at the end of the year | 2,129,076 | 7,883,930 | 253,568,210 | 263,581,216 |
Classification to balance sheet as follows: | ||||
Current liabilities: | ||||
Current portion of term loans | 434,739 | 3,863,636 | - | 4,298,375 |
Non-current liabilities: | ||||
Term loans | 1,694,337 | 4,020,294 | 253,568,210 | 259,282,841 |
21. CASH AND CASH EQUIVALENTS
Cash and cash equivalents included in the statement of cash flows comprise the following balance sheet amounts:
31/12/2017 | 31/12/2016 | |
L.E. | L.E. | |
Cash and bank balances (Note 11) | 268,982,819 | 152,562,513 |
Investment at fair value through profit and loss (Note 5/4) | 10,807,609 | 153,043,880 |
Less: | ||
Credit banks - credit facilities | (130,804,575) | (25,259,659) |
Cash and cash equivalents at the end of the year | 148,985,853 | 280,346,734 |
Less: | ||
Pledged time deposits against letters of guarantee | (65,691,426) | (66,735,819) |
Cash and cash equivalents at the end of the year | 83,294,427 | 213,610,915 |
21. CASH AND CASH EQUIVALENTS - Continued
(*) The balance of credit banks are summarized as follows:
31/12/2017 | 31/12/2016 | |
L.E. | L.E. | |
Madinet Nasr for Housing Development - Parent company | 91,216,797 | - |
Al Nasr Company for Utilities & Erection (Subsidiary) | - | 121,837 |
Al Nasr Company for Civil Works (Subsidiary) | 39,587,778 | 25,137,822 |
130,804,575 | 25,259,659 |
Short term loans
31/12/2017 | 31/12/2016 | |
L.E. | L.E. | |
Balance at the beginning of the year | 19,333,333 | 26,610,474 |
Proceeds during the year | 156,570,506 | 58,340,930 |
Installments and interests paid during the year | (119,028,092) | (65,618,071) |
Balance at the end of the year | 56,875,747 | 19,333,333 |
22. PROJECT MAINTENANCE DEPOSITS AND LIABILITIES
31/12/2017 | 31/12/2016 | |
L.E. | L.E. | |
Bank current accounts | 5,656,271 | 19,067,884 |
Time deposits | 169,258,322 | 91,100,000 |
Notes receivable of project maintenance deposit | 17,418,372 | 1,239,100 |
Project maintenance deposit liabilities | 192,332,965 | 111,406,984 |
Others | 68,828 | - |
Project maintenance deposit and liabilities | 192,401,793 | 111,406,984 |
The checks received from the customers for the project management, operation and maintenance account amounted to LE 776,641,173. The sum of LE 192,401,793 was collected and invested in deposits and interest-bearing bank accounts. The remaining balance amounting to LE 584,239,380 at 31 December 2017 will be collected on maturity dates during the following periods.
23. SALES AND COST OF SALES
23-a Net Revenues
31/12/2017 | 31/12/2016 | |
L.E. | L.E. | |
Property sales revenue | ||
El Waha Project | 1,930,459 | 9,213,000 |
Tag Sultan Project | 395,061,991 | 324,571,929 |
Premira Project | 1,813,600 | 19,217,959 |
Tag city (Zone T) Project | 351,753,211 | 642,540,403 |
Tag city (Zone B) Project | 82,791,267 | - |
Capital Garden project | 66,574,239 | 195,673,343 |
Sarai City project | 982,378,415 | 336,537,053 |
Property sales revenue | 1,882,303,182 | 1,527,753,687 |
Land sales revenue - El Waha Project | - | 93,187,308 |
Total property and land sales revenues | 1,882,303,182 | 1,620,940,995 |
Contracting revenues - Al Nasr Company for Civil Works | 185,918,859 | 161,462,671 |
Contracting revenues - Al Nasr Company for Utilities & Erections | 123,475,930 | 102,989,848 |
Less: Property sales returns | ||
El Waha Project | (1,051,980) | - |
Tag Sultan Project | (595,813) | (5,596,679) |
Premira Project | (1,268,155) | (2,063,301) |
Tag City (Zone T) | (14,596,545) | (1,304,191) |
Capital Garden | (2,453,717) | (1,041,702) |
Tag Sultan Project | (15,852,210) | - |
Net sales | 2,155,879,551 | 1,875,387,641 |
Amortization of discount of present value of notes receivable | 196,193,872 | 89,431,784 |
Recognized profit and interest on installment-sales | 74,783,687 | 79,809,185 |
Rental land and properties | 1,160,060 | 1,217,337 |
Less/add: | ||
Profit on installment-sale returns and deferred profit on installment sales | 240,786 | (31,421,347) |
Net revenue | 2,428,257,956 | 2,014,424,600 |
23. SALES AND COST OF SALES - Continued
23-b Cost of Revenues
31/12/2017 | 31/12/2016 | |
L.E. | L.E. | |
Cost of sold property | ||
El Waha Project | 439,897 | 5,734,454 |
Tag Sultan Project | 326,193,018 | 264,989,272 |
Premira Project | 426,196 | 4,425,949 |
Tag City (Zone T) project | 37,657,692 | 62,633,588 |
Tag City (Zone B) project | 9,039,691 | - |
Capital Garden project | 2,401,916 | 6,917,298 |
Sarai City project | 198,773,684 | 61,154,340 |
574,932,094 | 405,854,901 | |
Cost of land sold - El Waha project | - | 9,573,833 |
Total of cost of lands and property sales | 574,932,094 | 415,428,734 |
Revenue cost - Al Nasr Company for Civil Works | 153,270,200 | 141,160,590 |
Revenue cost - Al Nasr Company for Utilities & Erections | 116,343,047 | 104,019,552 |
Less: Cost of sold property sales returns: | ||
Tag Sultan project | (106,559) | (1,388,892) |
Premira project | (307,140) | (484,133) |
El Waha Project | (52,736) | - |
Tag City (Zone T) project | (671,254) | (174,400) |
Sarai City project | (2,848,677) | - |
Capital Garden project | (82,286) | (31,815) |
Net cost of sales | 840,476,689 | 658,529,636 |
Depreciation of investments properties | 55,985 | 54,648 |
Cost of revenues | 840,532,674 | 658,584,284 |
24. CONSTRUCTIONS COMMITMENTS
Al Nasr Co. for Civil Works - (Subsidiary Company)
Contracts for executing utilities and civil constructions amounted to L.E. 2,836 million at 31/12/2017, executed amount at 31/12/2017 amounted to L.E. 2,424 million.
Al Nasr Utilities and Erections Co. - (Subsidiary Company)
Contracts for executing utilities and civil constructions amounted to L.E. 304 million at 31/12/2017, executed amount at 31/12/2017 amounted to L.E. 123 million.
25. SELLING AND MARKETING EXPENSES
31/12/2017 | 31/12/2016 | |
L.E. | L.E. | |
Salaries, wages and equivalent | 1,633,530 | 811,008 |
Selling and marketing commissions | 79,123,161 | 72,798,179 |
Advertisements | 156,090,872 | 52,992,090 |
Rent | 7,838,789 | 3,818,648 |
Professional fees | 6,796,724 | 3,227,006 |
Depreciation (Note 4/1) | 142,712 | 68,055 |
Sundry expenses | 1,184,628 | 222,150 |
252,810,416 | 133,937,136 |
26. GENERAL AND ADMINISTRATIVE EXPENSES
31/12/2017 | 31/12/2016 | |
L.E. | L.E. | |
Salaries, wages and equivalent | 59,389,096 | 35,371,092 |
Board of Directors salaries and allowances | 10,212,206 | 5,197,138 |
Depreciation (Note 4/1) | 3,596,035 | 2,817,150 |
Other expenses | 38,965,668 | 32,707,641 |
112,163,005 | 76,093,021 |
27. FINANCE REVENUE
31/12/2017 | 31/12/2016 | |
L.E. | L.E. | |
Revenue from investments at fair value | 5,288,485 | 12,306,793 |
Income from interest and bank deposit | 25,965,663 | 7,799,375 |
31,254,148 | 20,106,168 |
28. OTHER REVENUES
31/12/2017 | 31/12/2016 | |
L.E. | L.E. | |
Administrative fees | 18,319,866 | 7,980,956 |
Customers delay payment penalties | 18,845,767 | 3,622,604 |
Contractor delivery delay penalties | 4,112,118 | 5,633,674 |
Sundry revenue | 4,948,365 | 3,123,438 |
Foreign exchange gain | - | 2,649,804 |
Capital gains | 190 | 174,947 |
46,226,306 | 23,185,423 |
29. OTHER EXPENSES
31/12/2017 | 31/12/2016 | |
L.E. | L.E. | |
Compensations and fines | 9,707,861 | 7,093,624 |
Donations for others | 26,003,642 | 20,027,970 |
Foreign exchange loss | 44,216 | - |
Sundry expenses | 2,913,672 | 2,142,981 |
38,669,391 | 29,264,575 |
30. CONSOLIDATED STATEMENT OF INCOME
31/12/2017 | 31/12/2016 | |
L.E. | L.E. | |
Net profit from Madinet Nasr for Housing & Development S.A.E. | 943,297,203 | 738,770,573 |
Group portion in net profits of subsidiaries companies | (11,675,974) | (45,015,724) |
Reversal of impairment in investment in subsidiaries | - | 72,820,563 |
931,621,229 | 766,575,412 |
31. CONTINGENT LIABILITIES
Letters of guarantee
National Bank of Egypt, Banque Misr, United Bank and others, have issued letters of guarantee amounting to L.E. 290.99 million at 31 December 2017 (2016: L.E. 241.8 million), in favor of third parties, which are secured by part of the company's time deposits amounting to L.E. 65,691,426 (2016: L.E. 66,735,810) and cash margin on letters of guarantee by L.E. 10,426,555 (2016: L.E. 10,865,252).
32. DEFERRED TAX
Madinet Nasr for Housing and Development (Parent company)
31/12/2017 | 31/12/2016 | |||
Assets | (Liabilities) | Assets | (Liabilities) | |
L.E. | L.E. | L.E. | L.E. | |
Deferred tax assets/(liabilities) | - | (3,046,807) | - | (2,533,385) |
Deferred tax assets provisions | 4,712,404 | - | 4,900,608 | - |
Total deferred tax (liabilities)/ assets | 4,712,404 | (3,046,807) | 4,900,608 | (2,533,385) |
Net deferred tax assets | 1,665,597 | - | 2,367,223 | - |
Charged to the statement of income | - | (701,626) | - | 934,824 |
32. DEFERRED TAX - Continued
31/12/2017 | 31/12/2016 | |
L.E. | L.E. | |
Unrecorded deferred tax assets (provisions) | 14,594,957 | 19,523,110 |
Al Nasr Co. for Civil Works - (Subsidiary Company)
31/12/2017 | 31/12/2016 | |||
Assets | (Liabilities) | Assets | (Liabilities) | |
L.E. | L.E. | L.E. | L.E. | |
Deferred tax assets/(liabilities) | - | (267,557) | 476,385 | - |
Deferred tax assets provisions | 8,078,410 | - | 3,854,655 | - |
Total deferred tax (liabilities)/ assets | 8,078,410 | (267,557) | 4,331,040 | - |
Net deferred tax assets | 8,078,410 | - | 4,331,040 | - |
Charged to the statement of income | 3,479,813 | - | 952,325 | - |
Al Nasr for Utilities and Erections Co. - (Subsidiary Company)
31/12/2017 | 31/12/2016 | |||
Assets | (Liabilities) | Assets | (Liabilities) | |
L.E. | L.E. | L.E. | L.E. | |
Deferred tax liabilities (fixed assets) | - | (43,868) | - | (43,868) |
Deferred tax assets (provisions) | 2,527,434 | - | 2,527,434 | - |
Tax losses brought forward | 2,527,434 | (43,868) | 2,527,434 | (43,868) |
Net deferred tax assets | 2,483,566 | - | 2,483,566 | - |
The effect on consolidated financial statements | ||||
Total deferred tax asset (balance sheet) | 11,960,016 | - | 9,181,829 | - |
Total charged to the statement of income | 2,778,187 | - | 17,501 | - |
33. TAX STATUS
Madinet Nasr for Housing and Development (Parent company)
The company submits tax returns to the Tax Authority on due dates and pays taxes according to these returns.
Al Nasr Co. for Civil Works - subsidiary
Tax returns submitted on due dates, the tax has been settled and paid.
33. TAX STATUS - Continued
Al Nasr Co. for Utilities and Erections - (Subsidiary company)
Tax returns were submitted on due dates, the company has objected on tax claims received from the Tax Authority.
34. EARNINGS PER SHARE
31/12/2017 | 31/12/2016 | |
L.E. | L.E. | |
Net profit for the year after tax | 931,621,229 | 766,575,412 |
Less: | ||
Board of Directors share in profit | (47,165,000) | (37,000,000) |
Employees share in profit | (48,000,000) | (36,000,000) |
836,456,229 | 693,575,412 | |
Weighted average numbers of shares outstanding during the year | 996,991,857 | 996,426,230 |
Earnings per share | 0.84 | 0.70 |
35. FINANCIAL INSTRUMENTS AND RELATED RISKS
On-balance sheet financial instruments comprise cash and bank balances, financial investments, debtors, creditors, and amounts due from/to subsidiaries. Notes to the 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:
· 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 charges customers for delay penalties 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.
35. FINANCIAL INSTRUMENTS AND RELATED RISKS - Continued
The following are due dates of the financial liabilities:
Book value | Less than one year | 1 - 2 years | More than 2 years | |
L.E. | L.E. | L.E. | L.E. | |
31/12/2017 | ||||
Term loans | 385,045,294 | 177,892,520 | 207,152,774 | - |
Trade and other payables | 447,911,362 | 447,911,362 | - | - |
Short term loans | 56,875,747 | 56,875,747 | - | - |
Creditors and tax | 444,729,708 | 444,729,708 | - | - |
1,334,562,111 | 1,127,409,337 | 207,152,774 | - | |
31/12/2016 | ||||
Term loans | 263,581,216 | 4,298,375 | 177,892,520 | 81,390,321 |
Trade and other payables | 339,151,103 | 339,151,103 | - | - |
Short term loans | 19,333,333 | 19,333,333 | - | - |
Creditors and tax | 333,614,417 | 333,614,417 | - | - |
955,680,069 | 696,397,228 | 177,892,520 | 81,390,321 |
· 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 gap between debit and credit interest rates takes place in order to reduce this risk to the minimum as possible.
The following are the financial assets and liabilities according interest rate type:
31/12/2017 | 31/12/2016 | |
L.E. | L.E. | |
Financial assets instruments with fixed interest rate | ||
Financial assets - trade receivable | 8,756,459,021 | 5,330,500, 627 |
Financial liabilities instruments with floating interest rate | ||
Financial liabilities- short term loans | 572,752,616 | 308,174,208 |
· 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 not to take a loan in foreign currencies nor keep significant balances in currencies other than Egyptian pound.
36. CONTRACTUAL COMMITMENTS
Madinet Nasr for Housing and Development - (Parent Company)
The value of contracts with contractors for the implementation of housing and development projects amounted to L.E. 984 million as of 31/12/2017 executed by amount L.E. 772 million. Contractors' dues have been paid in accordance with the contracts.
37. FAIR VALUE
The fair values of financial assets and liabilities are not materially different from their carrying value at the financial position date, except for fixed assets.
38. COMPARATIVE FIGURES
Certain prior year figures have been reclassified to conform to the financial statement presentation for the current year.
39. 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.
Related Shares:
Madinet Nasr S