8th May 2018 07:00
REPORT OF THE INDEPENDENT AUDITOR ON THE
SUMMARY 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 31 March 2018, from which the attached summary separate financial statements are derived, in accordance with the Egyptian Standards on Auditing and the relevant laws and regulations. As sated in our Arabic review report dated 3 May 2018, we expressed an unqualified review conclusion on the separate financial statements for the period then ended, from which the attached summary separate financial statements are derived.
In our opinion, the attached summary 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 31 March 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, 3 May 2018
Madinet Nasr for Housing & Development S.A.E.
SEPARATE STATEMENT OF FINANCIAL POSITION
At 31 March 2018
|
| 31/3/2018 | 31/12/2017 |
| Note | L.E. | L.E. |
Non current Assets |
|
|
|
Fixed assets (Net) | 4/1 | 42,209,050 | 38,984,793 |
Projects in progress | 4/2 | 10,590,346 | 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 in properties | 5/4 | 4,335,211 | 4,348,677 |
Long term notes receivables (Net) | 7 | 5,482,534,860 | 5,144,994,601 |
Amounts due from related parties | 30 | 9,500,000 | 10,000,000 |
Deferred tax assets | 20 | 1,675,517 | 1,665,597 |
Total non current assets |
| 5,620,381,662 | 5,262,299,497 |
|
|
|
|
Current Assets |
|
|
|
Housing & development projects - WIP | 6 | 1,386,147,785 | 1,279,706,549 |
Housing & development projects - Finished properties | 6 | 78,545,714 | 78,262,306 |
Short term notes receivable | 7 | 1,734,336,960 | 1,576,608,078 |
Trade and notes receivables (Net) | 7 | 484,691,428 | 400,372,935 |
Trade payables - debit balances (Net) | 8 | 99,500,871 | 104,266,797 |
Debtors and other debit balances (Net) | 9 | 196,197,672 | 174,086,839 |
Investments at fair value through profit or loss | 5/5 | 11,013,802 | 10,807,609 |
Deposits for projects maintenance | 19 | 200,650,109 | 192,332,965 |
Cash and bank balances | 10 | 252,914,375 | 203,923,463 |
Total current assets |
| 4,443,998,716 | 4,020,367,541 |
Total assets |
| 10,064,380,378 | 9,282,667,038 |
|
|
|
|
Equity |
|
|
|
Issued and paid up capital | 16 | 997,100,389 | 997,100,389 |
Legal reserve |
| 123,313,788 | 123,313,788 |
Retained earnings |
| 1,239,875,156 | 296,577,953 |
Net profit for the period/year |
| 328,895,667 | 943,297,203 |
Total shareholders' equity |
| 2,689,185,000 | 2,360,289,333 |
|
|
|
|
Non-current Liabilities |
|
|
|
Unearned revenue | 11 | 5,644,197,394 | 5,119,127,351 |
Term loans | 17 | 180,460,094 | 207,152,774 |
Total Non-current liabilities |
| 5,824,657,488 | 5,326,280,125 |
|
|
|
|
Current Liabilities |
|
|
|
Provisions | 12 | 69,482,824 | 70,061,807 |
Project infrastructure completion liabilities | 13 | 160,777,273 | 170,827,359 |
Deferred profit & interest on outstanding installments | 14 | 210,859,957 | 226,811,160 |
Trade and other payables | 15 | 206,261,954 | 229,492,922 |
Current portion of long term loans | 17 | 177,603,852 | 177,892,520 |
Short term loans | 18 | 30,256,428 | 56,875,747 |
Bank's overdraft (credit facilities) | 18 | 85,928,330 | 91,216,797 |
Liabilities of deposits for projects maintenance | 19 | 200,590,445 | 192,401,793 |
Suppliers |
| 36,610,342 | 95,018,306 |
Tax Authority |
| 370,237,471 | 279,044,422 |
Dividends payable |
| 1,929,014 | 6,454,747 |
Total current liabilities |
| 1,550,537,890 | 1,596,097,580 |
Total liabilities |
| 7,375,195,378 | 6,922,377,705 |
Total equity and liabilities |
| 10,064,380,378 | 9,282,667,038 |
Review report "attached".
CFO | CEO | 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 ended 31 March 2018
|
| From 1/1/2018 to 31/3/2018 | From 1/1/2017 to 31/3/2017 |
| Note | L.E. | L.E. |
|
|
|
|
Net revenue | 22-a | 545,308,188 | 687,699,626 |
Less: |
|
|
|
Cost of revenue | 22-b | (60,078,130) | (100,392,366) |
Gross Profit |
| 485,225,058 | 587,307,260 |
Less: |
|
|
|
Selling & marketing expenses | 23 | (36,714,383) | (64,151,554) |
General & administrative expenses | 24 | (20,997,786) | (16,292,843) |
Impairment of trade payables - debit balances |
| (8,125,000) | - |
Provision |
| (10,001) | (3,854,265) |
Financial revenue |
| (27,246,054) | (906,873) |
Add: |
|
|
|
Interest income | 25 | 5,384,263 | 8,896,626 |
Profit from operations |
| 397,516,097 | 510,998,351 |
Investments held to maturity revenue |
| 41,716 | - |
Reverse of impairment in investments in associates | 5/1 | 19,518,646 | - |
Other revenues | 26 | 11,087,641 | 13,133,360 |
Other expenses | 27 | (3,897,848) | (466,073) |
Net profit for the period before tax |
| 424,266,252 | 523,665,638 |
Income tax | 21 | (95,380,505) | (117,610,693) |
Deferred tax | 20 | 9,920 | 115,309 |
Net profit for the period |
| 328,895,667 | 406,170,254 |
|
|
|
|
Earnings per share for the period | 28 | 0.30 | 0.37 |
CFO | CEO | 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 ended 31 March 2018
| From 1/1/2018 to 31/3/2018 | From 1/1/2017 to 31/3/2017 |
| L.E. | L.E. |
|
|
|
Net profit for the period | 328,895,667 | 406,170,254 |
Other comprehensive income | - | - |
Total comprehensive income for the period | 328,895,667 | 406,170,254 |
CFO | CEO | 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 ended 31 March 2018
| Issued and paid up capital | Treasury bonds | 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 stocks | - | 74,633,025 | - | (1,433,024) | - | 73,200,001 |
Transferred to retained earnings | - | - | - | 738,770,573 | (738,770,573) | - |
Dividends for 2016 | - | - | 36,938,529 | (759,938,529) | - | (723,000,000) |
Comprehensive income for the period | - | - | - | - | 406,170,254 | 406,170,254 |
Balance at 31 March 2017 | 500,000,000 | - | 123,313,788 | 313,459,548 | 406,170,254 | 1,342,943,590 |
|
|
|
|
|
|
|
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) | - |
Comprehensive income for the period | - | - | - | - | 328,895,667 | 328,895,667 |
Balance at 31 March 2018 | 997,100,389 | - | 123,313,788 | 1,239,875,156 | 328,895,667 | 2,689,185,000 |
CFO | CEO | 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 ended 31 March 2018
|
| 31/3/2018 | 31/3/2017 |
| Note | L.E. | L.E. |
OPERATING ACTIVITIES |
|
|
|
Net profit for the period before tax |
| 424,266,252 | 523,665,638 |
Adjustments for: |
|
|
|
Depreciation of fixed assets and investment in properties | 4/1, 5/4 | 1,344,530 | 934,433 |
Capital loss | 27 | 13,260 |
|
Provisions | 12 | 10,001 | 3,854,265 |
Impairment of trade payables - debit balances |
| 8,125,000 | - |
Reverse of impairment of investments in subsidiaries |
| (19,518,646) | - |
Revenue from investments held to maturity |
| (41,716) | - |
Net profit and interest due during the period |
| (14,913,093) | (23,422,017) |
(Gain)/Loss on foreign currencies exchange |
| (11,441) | 130,047 |
Operating profit before working capital changes |
| 399,274,147 | 505,162,366 |
|
|
|
|
Inventory of housing and development projects |
| 106,724,644 | (68,865,697) |
Trade receivables, customers, and notes receivables |
| (605,186,033) | (1,383,248,604) |
Trade payables - unearned revenue and creditors |
| 432,342,915 | 1,033,455,220 |
Provisions used |
| (588,984) | (950,665) |
Dividends paid to directors and employees |
| (4,525,733) | - |
Income tax paid |
| (4,187,456) | (5,550,640) |
Net cash from operating activities |
| 110,404,212 | 80,001,980 |
|
|
|
|
INVESTING ACTIVITIES: |
|
|
|
Payments for purchase of fixed assets & project in progress |
| (2,871,130) | (2,622,092) |
Proceeds from investments held to maturity |
| 41,716 | - |
Proceeds from amounts due from related parties |
| 500,000 | - |
Net cash used in investing activities |
| (2,329,414) | (2,622,092) |
|
|
|
|
FINANCING ACTIVITIES: |
|
|
|
Treasury bonds |
| - | 73,200,001 |
Payments of long term loans during the period | 17 | (26,981,348) | (1,960,136) |
Withdrawals of long term loans during the period | 17 | - | 51,332,431 |
Payments for short term loans during the period | 18 | (26,619,319) | (14,500,000) |
Net cash (used in)/from financing activities |
| (53,600,667) | 108,072,296 |
|
|
|
|
Change in cash and cash equivalents |
| 54,474,131 | 185,452,184 |
Cash and cash equivalents at the beginning of the period |
| 123,514,275 | 226,950,875 |
Gain/(Loss) on foreign exchange |
| 11,441 | (130,047) |
Total cash and cash equivalents at the end of the period |
| 177,999,847 | 412,273,012 |
Less: Pledged time deposits against letters of guarantee |
| (4,592,268) | (4,592,268) |
Cash and cash equivalents at the end of the period | 18 | 173,407,579 | 407,680,744 |
NON-CASH TRANSACTIONS:
The cash flows statement did not include the following non-cash transactions:
· An amount of L.E. 1,823,508 represents transfer from projects in progress to fixed assets
· An amount of L.E. 200,650,109 (2017: L.E. 192,332,965) represents bank accounts and deposits maintained against facility management, operation, and maintenance liabilities.
CFO | CEO | 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 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, tourists, 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 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 31 March 2018 on 2 May 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
- Provisions
- Impairment of assets values
- Taxation
- Liabilities for utilities completion
- Discount of present value for notes receivable consumption
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 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:
| Years |
- Buildings and constructions |
|
Buildings | 50 |
Elevators | 10 |
- Machinery & equipment for operation | 5 |
- Machinery & equipment for serving & utilities | 5 - 12.5 |
Motor vehicles | 5 |
Tools | 1 |
Furniture and office equipment | 10 |
c) Construction in progress
Construction in progress is recorded at cost which includes all the direct costs incurred on the assets to reach its final position. These are transferred to fixed assets when the asset is complete and ready for its intended use. Construction in progress is recorded at cost less impairment, if any.
d) Investment in subsidiaries
Investment in subsidiaries is accounted for using the cost method of accounting, whereby if there is an indication of impairment, such impairment loss is charged to the statement of income for each individual investment. Where an impairment loss subsequently reverses, the increased carrying amount of such investment does not exceed the carrying amount that would have been determined had no impairment loss been recognized.
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 statement of income.
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 method. When the investment is impaired, the impairment loss is adjusted against book value and included in the statement of income.
3 SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued
g) Investment properties
Investment properties are measured at cost and when such assets are impaired, the loss is included in the income statement.
h) 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 financial position 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.
i) Spare parts and supplies inventories
The spare parts inventory is stated at the lower of cost or net realizable value. Cost is determined using weighted average. Net realized value is based on estimated selling prices less selling expenses.
j) 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.
k) Cash flows statement
The cash flows statement is prepared according to the indirect method.
l) Cash and cash equivalents
Cash and cash equivalents include cash on hand, time deposits, 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.
m) 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 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 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.
3 SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued
n) Assets impairment
Asset values are reviewed at the financial position 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 statement of income on the same date.
o) 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 financial position date and adjusted (if necessary) to present the best current estimate.
p) 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 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.
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.
q) 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.
r) Dividends
Dividends are recorded as liability during the year when declared.
s) 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
Revenue on sales during the year 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:
3 SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued
- 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.
- 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 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 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 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
t) 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.
u) 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.
v) 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 separate financial statements.
The amount is determined using the tax rates applicable on the financial position date. Deferred tax assets are recognized for all temporary differences, unused deferred tax assets and losses brought forward, if taxable profit are expected 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.
w) Earnings per share
Earnings per share are calculated by dividing the net profit for the year by the weighted average number of shares outstanding during the year.
x) 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 statement of income on a time-apportioned basis using the effective interest rate.
3 SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued
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 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.
y) 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.
z) 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 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 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 | - | 618,121 | 1,119,222 | - | - | 556,689 | 451,041 | 2,745,073 |
Transferred from projects in progress (Note 4/2) | - | - | 1,823,508 | - | - | - | - | 1,823,508 |
Disposals during the period | - | - | - | - | - | (3,442) | (29,670) | (33,112) |
At 31 March 2018 | 1,351,229 | 21,558,306 | 5,620,559 | 3,186,826 | 513,777 | 10,728,790 | 19,377,832 | 62,337,319 |
|
|
|
|
|
|
|
|
|
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 | - | 469,269 | 148,942 | 6,881 | 964 | 2535,835 | 469,172 | 1,331,064 |
Disposals during the period | - | - | - | - | - | (2,436) | (17,416) | (19,852) |
At 31 March 2018 | - | 3,481,137 | 2,047,203 | 3,126,711 | 512,353 | 5,345,270 | 5,615,594 | 20,128,269 |
|
|
|
|
|
|
|
|
|
Net book value: |
|
|
|
|
|
|
|
|
At 31 March 2018 | 1,351,229 | 18,077,169 | 3,573,357 | 60,115 | 1,424 | 5,383,520 | 13,762,238 | 42,209,050 |
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 include land and building of the social club and playground for Madinet Nasr for Housing & Development Employees club, the book value is approximately L.E. 1.3 million for land and L.E. 4.5 million for building.
4/1 FIXED ASSETS - Continued
a) The fully depreciated assets and still working are as follows:
| 31/3/2018 | 31/12/2017 |
| L.E. | L.E. |
|
|
|
Buildings and constructions | 114,889 | 114,889 |
Motor vehicles | 3,054,234 | 3,043,609 |
Furniture and office equipment | 1,400,107 | 1,400,107 |
Machinery & equipment | 687,728 | 687,728 |
Tools | 509,868 | 509,868 |
| 5,766,826 | 5,756,201 |
b) Depreciation for the period/year is allocated as follows:
| 31/3/2018 | 31/3/2017 |
| L.E. | L.E. |
|
|
|
Cost of sales | 192,176 | 45,478 |
Selling & Marketing expenses (Note 23) | 358,586 | 31,984 |
General and administrative expenses (Note 24) | 780,302 | 843,504 |
| 1,331,064 | 920,966 |
4/2 PROJECTS UNDER CONSTRUCTION
| 31/3/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 | 126,057 | 12,215,592 |
Transferred to fixed assets (Note 4/1) | (1,823,508) | (303,103) |
Balance at the end of the period/year | 10,590,346 | 12,287,797 |
5. INVESTMENTS
5/1 Investments in subsidiaries
| Contribution | 31/3/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 |
5. INVESTMENTS - Continued
5/2 Held to maturities investments
| 31/3/2018 | 31/12/2017 |
| L.E. | L.E. |
|
|
|
Investments in Governmental bonds | 121,962 | 121,962 |
5/3 Available for sale investments
| Contribution | 31/3/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, so we cannot determine its fair value, so it is recorded at historical cost.
5/4 Investment properties
| 31/3/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) (*) | 859,453 | 872,919 |
| 4,335,211 | 4,348,677 |
(*) Rental buildings (Net)
| Residential units | None residential units | Total |
| L.E. | L.E. | L.E. |
Cost: |
|
|
|
At 1 January 2018 |
|
|
|
and at 31 March 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 | 2,118 | 11,348 | 13,466 |
At 31 March 2018 | 450,076 | 2,118,637 | 2,568,713 |
|
|
|
|
Net book value: |
|
|
|
At 31 March 2018 | 95,921 | 763,532 | 859,453 |
At 31 December 2017 | 98,039 | 774,880 | 872,919 |
5. INVESTMENTS - Continued
5/5 Investments at fair value through profit and loss
| 31/3/2018 | 31/12/2017 |
| L.E. | L.E. |
Investment certificates in: |
|
|
Bank Misr Investment Fund (Day-By-Day) | 249,231 | 240,662 |
QNB (NSGB) Investment Fund | 1,026,362 | 992,307 |
Banque Du Caire Investment Fund (Day-By-Day) | 700,113 | 859,676 |
United Bank Investment Fund (Rakhaa) | 9,016,137 | 8,693,005 |
Arab Investment Bank Investment Fund | 21,959 | 21,959 |
| 11,013,802 | 10,807,609 |
6. HOUSING & DEVELOPMENT PROJECTS
| 31/3/2018 | 31/12/2017 |
| L.E. | L.E. |
Uncompleted units and lands: |
|
|
El Waha Project | 170,201,878 | 141,766,889 |
6th October Project (Nasr Gardens) | 142,296,535 | 133,832,030 |
Tag City Project | 675,875,647 | 608,086,720 |
Nasr City (Main City) Project | 2,297,897 | 2,297,896 |
Sarai City | 395,475,828 | 393,723,014 |
| 1,386,147,785 | 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,442 | 60,278,442 |
| 78,545,714 | 78,262,306 |
Total lands, incomplete and completed units | 1,464,693,499 | 1,357,968,855 |
7. TRADE AND NOTES RECEIVABLES
| 31/3/2018 | 31/12/2017 |
| L.E. | L.E. |
Long term notes receivable |
|
|
Tag Sultan customers | 391,864,149 | 450,606,088 |
Tag City customers (Zone T) | 2,446,163,884 | 2,467,547,802 |
Tag City customers (Zone B) | 708,020,977 | 257,133,516 |
Premira customers | 76,285,642 | 82,497,978 |
Capital Gardens customers | 421,998,377 | 370,059,492 |
Sarai City customers | 2,748,695,869 | 2,791,411,454 |
Total long term notes receivables | 6,793,028,898 | 6,419,256,330 |
7. TRADE AND NOTES RECEIVABLES - Continued
| 31/3/2018 | 31/12/2017 |
| L.E. | L.E. |
Less: |
|
|
Tag Sultan Project | (61,477,284) | (72,679,392) |
Tag City (Zone T) | (429,465,385) | (447,929,785) |
Tag City (Zone B) | (110,957,107) | (41,881,651) |
Premira Project | (29,537,120) | (29,156,749) |
Capital Gardens | (150,121,633) | (130,856,066) |
Sarai City | (528,935,509) | (551,758,086) |
Total present value discount | (1,310,494,038) | (1,274,261,729) |
Net long term notes receivables | 5,482,534,860 | 5,144,994,601 |
|
|
|
Short term notes receivable |
|
|
|
|
|
Tag Sultan Project customers | 233,057,029 | 239,698,796 |
Zone T Project customers | 579,802,648 | 548,036,867 |
Tag City Project customers (Zone B) | 162,797,529 | 57,907,386 |
Premira Project customers | 55,410,058 | 51,796,263 |
Sarai City customers | 703,269,696 | 679,168,766 |
| 1,734,336,960 | 1,576,608,078 |
Debtors customers |
|
|
Tag Sultan customers | 4,518,411 | 4,830,678 |
Tag City customers (Zone T( | 70,782,664 | 59,461,906 |
Tag City customers (Zone B( | 691,488 | - |
Premira customers | 682,811 | 516,394 |
Sarai City customers | 78,128,031 | 54,767,667 |
El Waha and Nasr City customers | 228,190,831 | 242,857,571 |
Land customers | 115,107,839 | 51,471,905 |
Rental customers | 1,250,735 | 1,128,196 |
| 499,352,810 | 415,034,317 |
Less: |
|
|
Impairment of customers balances | (14,661,382) | (14,661,382) |
| 484,691,428 | 400,372,935 |
8. TRADE PAYABLES - DEBIT BALANCES
| 31/3/2018 | 31/12/2017 |
| L.E. | L.E. |
|
|
|
Trade payables & contractors | 157,722,964 | 154,363,890 |
Less: | (58,222,093) | (50,097,093) |
Impairment in trade payables - debit balances | 99,500,871 | 104,266,797 |
9. DEBTORS AND OTHER DEBIT BALANCES
| 31/3/2018 | 31/12/2017 |
| L.E. | L.E. |
|
|
|
Cheques under collection | 2,938,119 | 1,826,132 |
Refundable deposits | 2,697,658 | 2,653,909 |
Prepaid expenses | 180,880,994 | 160,601,026 |
Accrued revenue | 151,737 | 693,257 |
Cash margin on letters of guarantee | 6,892,374 | 6,892,374 |
Other debit balances | 2,636,790 | 1,420,141 |
| 196,197,672 | 174,086,839 |
|
|
|
10. CASH AND BANK BALANCES
| 31/3/2018 | 31/12/2017 |
| L.E. | L.E. |
|
|
|
Bank current accounts | 79,110 | 62,508 |
Cash on hand | 213,480 | 125,117 |
Bank current accounts with return | 247,021,785 | 198,135,838 |
Time deposits (3 months) (*) | 5,600,000 | 5,600,000 |
| 252,914,375 | 203,923,463 |
(*) Time deposits include L.E. 4,592,268 (2016: L.E. 4,592,268) as pledged time deposits against letters of guarantee.
11. UNEARNED REVENUE
| 31/3/2018 | 31/12/2017 |
| L.E. | L.E. |
|
|
|
Tag Sultan customers | 487,908,558 | 518,912,026 |
Premira customers | 138,960,848 | 133,437,248 |
Tag City (Zone T) customers | 2,101,912,372 | 2,010,245,953 |
Tag City (Zone B) customers | 565,136,943 | 198,573,733 |
Capital Gardens customers | 113,617,494 | 99,520,063 |
Sarai City customers | 2,236,577,658 | 2,158,419,742 |
Rental customers | 83,521 | 18,586 |
| 5,644,197,394 | 5,119,127,351 |
12. PROVISIONS
| Balance at 1/1/2018 | Provided during the period | Used during the period | Balance at 31/3/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 | Additions | Work executed | Balance at 31/3/2018 |
| L.E. | L.E. | L.E. | L.E. |
|
|
|
|
|
Tag City project | 79,323,864 | 25,011,094 | (15,107,077) | 89,227,881 |
Sarai City project | 74,155,134 | 8,673,157 | (28,179,455) | 54,648,836 |
Capital Gardens project | 2,859,260 | 620,029 | - | 3,479,289 |
El Waha Project | 13,802,885 | 869,037 | (1,936,871) | 12,735,051 |
Nasr City project | 686,216 | - | - | 686,216 |
| 170,827,359 | 35,173,317 | (45,223,403) | 160,777,273 |
This balance represents estimated amounts to complete utilities for projects that have not been completely delivered.
14. DEFERRED PROFITS & INTERESTS ON OUTSTANDING INSTALLMENTS
| Land | Property | Total |
| L.E. | L.E. | L.E. |
31/3/2018 |
|
|
|
Balance at beginning of the period | 48,852,758 | 177,958,402 | 226,811,160 |
Due during the period | (5,941,477) | (8,971,616) | (14,913,093) |
Disposals during the period | - | (1,038,110) | (1,038,110) |
Balance at the end of the period | 42,911,281 | 167,948,676 | 210,859,957 |
|
|
|
|
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
| 31/3/2018 | 31/12/2017 |
| L.E. | L.E. |
|
|
|
Notes payable | 12,149,817 | 9,131,934 |
Support to National Housing Project | 880,000 | 880,000 |
Final retention and other refundable deposits | 34,047,390 | 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) | 9,157,426 | 7,781,757 |
Selling and marketing commissions | 33,562,157 | 23,304,415 |
Employees bonus account | 9,125,411 | 8,289,465 |
Customers' balances for canceled reservations | 12,957,883 | 12,004,283 |
Proceeds for maintenance expenses and counters | 9,597,042 | 9,886,005 |
Accrued debit interest on long term loans | 19,137,118 | 19,222,292 |
Governmental authorities | 26,769,404 | 25,486,635 |
Accrued advertising expenses | 23,037,232 | 45,748,121 |
Early retirement benefits and others | 6,778,483 | 21,010,313 |
Fixed assets creditors | 861,539 | 1,395,353 |
Proceeds from customers under reconciliation | 2,045,518 | 1,205,209 |
Other | 90,954 | 745,220 |
| 206,261,954 | 229,492,922 |
16. SHARE CAPITAL
Authorized capital:
The authorized capital is five billion Egyptian Pounds.
| 31/3/2018 | 31/12/2017 |
| L.E. | L.E. |
|
|
|
Issued and paid up capital | 997,100,389 | 997,100,389 |
Following are a list of percentage of shares of issued and paid up capital for shareholders as of 31 March 2018:
Name | No. of shares | Nominal value | Contribution % |
|
| L.E. | L.E. |
|
|
|
|
BIG Investment Group Ltd. | 198,249,205 | 198,249,205 | 19.88% |
Holding Co. for Construction and Development | 151,463,911 | 151,463,911 | 15.19% |
BPE Holding for Financial Investments S.A.E. | 74,336,136 | 74,336,136 | 7.45% |
National Investment Bank | 36,746,779 | 36,746,779 | 3.69% |
Misr Banque | 34,578,982 | 34,578,982 | 3.47% |
Other shareholders | 501,725,376 | 501,725,376 | 50.32% |
| 997,100,389 | 997,100,389 | 100.00% |
17. LOANS
| 31/3/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 |
Proceeds during the period | - | (288,668) | (26,692,680) | (26,981,348) |
Balance at the end of the period | 1,694,337 | 1,738,303 | 354,631,306 | 358,063,946 |
|
|
|
|
|
Classification to financial position as follows: |
|
|
|
|
|
|
|
|
|
Current liabilities: |
|
|
|
|
Current portion of long term loans | 456,524 | 1,738,303 | 175,409,025 | 177,603,852 |
|
|
|
|
|
Non current liabilities: |
|
|
|
|
Long term loans | 1,237,813 | - | 179,222,281 | 180,460,094 |
| 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 to 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 statement of cash flows comprise the following financial position amounts:
| 31/3/2018 | 31/12/2017 |
| L.E. | L.E. |
|
|
|
Cash and bank balances (Note 10) | 252,914,375 | 203,923,463 |
Investment at fair value through profit and loss (Note 5/5) | 11,013,802 | 10,807,609 |
Less: |
|
|
Bank's overdraft - Credit facilities | (85,928,330) | (91,216,797) |
| 177,999,847 | 123,514,275 |
Less: Pledged time deposits against letters of guarantee | (4,592,268) | (4,592,268) |
Cash and cash equivalents at the end of the period/year | 173,407,579 | 118,922,007 |
Short term loan
| 31/3/2018 | 31/12/2017 |
| L.E. | L.E. |
|
|
|
Balance at the beginning of the period/year | 56,875,747 | 19,333,333 |
Withdrawals during the period/year | - | 156,570,506 |
Installments and interests paid during the period/year | (26,619,319) | (119,028,092) |
Balance at the end of the period/year | 30,256,428 | 56,875,747 |
19. PROJECT MAINTENANCE DEPOSITS AND LIABILITIES
| 31/3/2018 | 31/12/2017 |
| L.E. | L.E. |
|
|
|
Bank current accounts | 14,907,920 | 5,656,271 |
Time deposits | 174,519,800 | 169,258,322 |
Cheques under collection | 11,222,389 | 17,418,372 |
Project maintenance deposit liabilities | 200,650,109 | 192,332,965 |
Amounts under settlement | (59,664) | 68,828 |
Project maintenance creditors | 200,590,445 | 192,401,793 |
The checks received from the customers for the project management, operation and maintenance account amounted to L.E. 856,402,053. The sum of LE 200,650,109 was collected and invested in deposits and interest-bearing bank accounts. The remaining balance amounting to LE 655,751,944 at 31 December 2017 will be collected on maturity dates during the following periods.
20. DEFERRED TAX
| 31/3/2018 | 31/12/2017 | ||
| Assets | (Liabilities) | Assets | (Liabilities) |
| L.E. | L.E. | L.E. | L.E. |
|
|
|
|
|
Deferred tax (liabilities) | - | (3,039,137) | - | (3,046,807) |
Deferred tax provisions asset | 4,714,654 | - | 4,712,404 | - |
Total deferred tax assets/(liabilities) | 4,714,654 | (3,039,137) | 4,712,404 | (3,046,807) |
Net deferred tax assets | 1,675,517 | - | 1,665,597 |
|
Charged to the statement of income | - | 9,920 | - | (701,626) |
20. DEFERRED TAX - Continued
| 31/3/2018 | 31/12/2017 |
| L.E. | L.E. |
|
|
|
Unrecorded deferred tax assets (provisions) | 14,570,657 | 14,594,957 |
Deferred tax assets have not included the balances of litigation provision, as there is no expected future benefit for using the deferred tax in the future.
21. RECONCILIATIONS TO CALCULATE THE EFFECTIVE INCOME TAX RATE
| 31/3/2018 | 31/3/2017 |
| L.E. | L.E. |
|
|
|
Net accounting profit before tax | 424,266,252 | 523,665,638 |
Tax rate | 22.50% | 22.50% |
Calculated income tax according to income tax law | 95,459,907 | 117,824,769 |
Provisions effect | 2,250 | 867,210 |
Impairment effect | 1,828,125 | - |
Depreciation differences | 14,201 | (37,111) |
Tax exemptions | (87,046) | (1,059,475) |
Utilities completion liabilities | (2,261,269) | - |
Training and rehabilitation fund | 414,887 | - |
Un-deductible expenses | 9,450 | 15,300 |
Income tax according to statement of income | 95,380,505 | 117,610,693 |
Effective income tax rate | 22.48% | 22.46% |
22. REVENUES AND COST OF REVENUES
22-a Net revenues
| 31/3/2018 | 31/3/2017 |
| L.E. | L.E. |
Property sales revenue |
|
|
Tag Sultan Project | 31,360,393 | 22,521,240 |
Premira Project | 3,682,400 | - |
Tag City (Zone T) Project | 56,941,158 | 17,508,051 |
Tag City (Zone B) Project | 152,331,778 | - |
Capital Garden project | 39,357,928 | 2,550,431 |
Sarai City project | 58,598,688 | 573,568,939 |
El Waha Project | 120,000 | 160,000 |
Total property sales revenue | 342,392,355 | 616,308,661 |
Land sales revenue - El Waha and Original City project | 120,019,750 | - |
Total property and land sales revenues | 462,412,105 | 616,308,661 |
22. REVENUES AND COST OF REVENUES - Continued
| 31/3/2018 | 31/3/2017 |
| L.E. | L.E. |
Less: |
|
|
Tag Sultan Project sales returns | (216,410) | (35,000) |
Premira sales returns | - | (1,065,599) |
Tag City Zone T sales returns | (8,325,491) | - |
Capital Garden sales returns | (2,704,607) | - |
Sarai City project sales returns | (7,322,605) | - |
El Waha Project sales returns | (1,613,493) | (1,051,980) |
Total finished properties sales returns | (20,182,606) | (2,152,579) |
Net sales | 442,229,499 | 614,156,082 |
Amortization of notes receivable of present value discount | 87,860,443 | 49,842,111 |
Profit, interest and installments due during the period | 14,913,093 | 23,422,017 |
Lands and properties rentals | 300,153 | 279,416 |
Net sales revenue | 545,303,188 | 687,699,626 |
22-b Cost of revenues
| 31/3/2018 | 31/3/2017 |
| L.E. | L.E. |
Cost of sold property |
|
|
Cost of Tag Sultan Project | 26,913,255 | 18,304,819 |
Cost of Premira Project | 869,037 | - |
Cost of Zone T Project | 4,604,089 | 1,314,671 |
Cost of Zone B Project | 16,710,835 | - |
Cost of Capital Garden project | 1,234,023 | 80,570 |
Cost of Sarai City project | 10,131,671 | 80,981,715 |
Total cost of properties sales | 60,462,910 | 100,681,775 |
Cost of land sold - El Waha project | 2,168,052 | - |
Total cost of land and finished properties sales | 62,630,962 | 100,681,775 |
|
|
|
Less: |
|
|
Cost of Tag Sultan sales returns | (45,006) | - |
Cost of Premira sales returns | - | (250,139) |
Cost of Zone T Project sales returns | (574,147) | - |
Cost of Capital Garden project sales returns | (86,487) | - |
Cost of Capital Garden project sales returns | (1,577,251) | - |
Cost of El Waha sales returns | (283,407) | (52,736) |
Total cost of sales returns | (2,566,298) | (302,875) |
Net cost of sales | 60,064,664 | 100,378,900 |
Depreciation of investment in properties | 13,466 | 13,466 |
Cost of revenue | 60,078,130 | 100,392,366 |
23. SELLING AND MARKETING EXPENSES
| 31/3/2018 | 31/3/2017 |
| L.E. | L.E. |
|
|
|
Salaries and wages | 356,537 | 225,829 |
Sales and marketing concession | 10,962,314 | 29,744,673 |
Advertisement expenses (including stamp tax) | 21,433,913 | 30,036,855 |
Rent | 2,393,962 | 1,918,800 |
Professional fees | 244,261 | 1,230,937 |
Depreciation (Note 4/1) | 358,586 | 31,984 |
Transportation and sundry expenses | 964,810 | 962,476 |
| 36,714,383 | 64,151,554 |
24. GENERAL AND ADMINISTRATIVE EXPENSES
| 31/3/2018 | 31/3/2017 |
| L.E. | L.E. |
|
|
|
Salaries, wages and equivalent | 6,746,220 | 7,562,181 |
Board of Directors remuneration | 1,929,403 | 1,173,403 |
Advertisement expenses | 613,627 | 391,103 |
Transportation and communications expenses | 1,735,598 | 1,101,483 |
Professional fees | 2,076,268 | 2,191,585 |
Depreciation (Note 4/1) | 780,302 | 843,504 |
Maintenance expenses | 1,979,341 | 364,436 |
Rent of electronic data storage sites | 1,024,957 | 44,630 |
Raw materials, fuel and spare parts | 685,785 | 636,673 |
Property tax and stamp | 435,211 | 73,894 |
International deposit certificates at London Stock Exchange | 1,783,036 | 513,568 |
Other service expenses | 303,359 | 502,048 |
Security, cleaning and training expenses | 328,776 | 690,764 |
Bank charges | 575,903 | 203,571 |
| 20,997,786 | 16,292,843 |
25. FINANCIAL REVENUE
| 31/3/2018 | 31/3/2017 |
| L.E. | L.E. |
|
|
|
Revenue from investment at fair value through profit and loss | 396,794 | 3,759,077 |
Credit interest | 4,987,469 | 5,137,549 |
| 5,384,263 | 8,896,626 |
26. OTHER REVENUES
| 31/3/2018 | 31/3/2017 |
| L.E. | L.E. |
|
|
|
Reconciled fees for non construction | 7,163,833 | 2,837,597 |
Deviation from construction conditions | 1,844,900 | 9,198,013 |
Delay penalty on contractors | - | 710,839 |
Sundry revenue | 2,067,467 | 386,911 |
Foreign exchange gain | 11,441 | - |
| 11,087,641 | 13,133,360 |
27. OTHER EXPENSES
| 31/3/2018 | 31/3/2017 |
| L.E. | L.E. |
|
|
|
Compensations and fines | 3,459,588 | 24,165 |
Donations for others | 425,000 | 311,861 |
Loss on foreign exchange | - | 130,047 |
Capital losses | 13,260 | - |
| 3,897,848 | 466,073 |
28. EARNINGS PER SHARE
| 31/3/2018 | 31/3/2017 |
| L.E. | L.E. |
|
|
|
Net profit for the period after tax | 328,895,667 | 406,170,254 |
Less: Estimated employees and Board of Directors share | (29,000,000) | (32,000,000) |
Shareholders share in net profit | 299,895,667 | 374,170,254 |
|
|
|
Weighted average numbers of shares outstandingduring the period | 997,100,389 | 996,991,858 |
|
|
|
Earnings per share | 0.30 | 0.37 |
29. CONTINGENT LIABILITIES
Letters of guarantee
The balance of the letters of guarantees issued by National Bank of Egypt, Banque Misr, and United Bank as of 31 March 2018 are amounting to L.E. 93,446,885 (31/12/2017: L.E. 93,834,885) in favor of third parties, the letters are secured the company's time deposits amounting to L.E. 4,592,268 (31/12/2017: L.E. 4,592,268), and margin of letters of guarantee by L.E. 6,892,374 (31/12/2017: L.E. 6,892,374).
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 | 31/3/2018 | 31/3/2017 |
|
|
| L.E. | L.E. |
Al Nasr Co. for Utilities & Erections - S.A.E. | Subsidiary | Utilities and installation works | 16,567,675 | 1,110,367 |
Al Nasr Co. for Civil Works S.A.E. | Subsidiary | Buildings and utilities works | - | 840,764 |
Balances of related parties are as follows:
| Nature of relationship | Nature of | 31/3/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 (*) | 9,500,000 | 10,000,000 |
|
| Supplier (Debtor) | 73,177,215 | 68,148,494 |
|
| Supplier (Debtor) | 1,341,392 | 1,345,177 |
|
| Advance | 103,819 | 103,819 |
b) Al Nasr Co, for Civil Works S.A.E. | Subsidiary | Supplier (Debtor) | 592,792 | 377,824 |
|
| Advance | 12,530,294 | 5,017,784 |
Amounts due to related parties: |
|
|
|
|
a) Al Nasr Co, for Utilities & Erections S.A.E. | Subsidiary | Warranty | 7,079,325 | 6,416,618 |
|
| Supplier (Creditor) | 1,634,460 | 5,918,659 |
b) Al Nasr Co, for Civil Works S.A.E. | Subsidiary | Supplier (Creditor) | 856,621 | 815,121 |
|
| Warranty | 749,839 | 749,839 |
(*) 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.
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:
· 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:
| Book value | Less than one year | 1 - 2 years | More than 2 years |
| L.E. | L.E. | L.E. | L.E. |
31/3/2018 |
|
|
|
|
Long term loans | 358,063,946 | 177,603,852 | 180,460,094 | - |
Trade and other payables | 206,261,954 | 206,261,954 | - | - |
Short term loans | 30,256,428 | 30,256,428 | - | - |
Suppliers and taxes | 406,845,563 | 406,845,563 | - | - |
| 1,001,427,891 | 820,967,797 | 180,460,094 | - |
|
|
|
|
|
31/12/2017 |
|
|
|
|
Long term loans | 385,045,294 | 177,892,520 | 207,152,774 | - |
Trade and other payables | 229,492,922 | 229,492,922 | - | - |
Short term loans | 56,875,747 | 56,875,747 | - | - |
Suppliers and taxes | 374,062,728 | 374,062,728 | - | - |
| 1,045,476,691 | 838,323,917 | 207,152,774 | - |
32. FINANCIAL INSTRUMENTS AND RELATED RISKS - Continued
· 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:
| 31/3/2018 | 31/12/2017 |
| L.E. | L.E. |
Financial assets instruments with fixed interest rate |
|
|
Financial assets - trade receivable | 9,026,718,668 | 8,410,898,725 |
|
|
|
Financial liabilities instruments with variable interest rate |
|
|
Financial liabilities- short term loans | 474,248,704 | 533,137,838 |
· 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. 984 million out of which executed till 31 March 2018 by L.E. 868 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 31 March 2018, except for investments held for sale.
35. COMPARATIVE FIGURES
Certain of prior year figures have been amended to conform to the 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.
Related Shares:
Madinet Nasr S