9th May 2018 17:25
REPORT OF THE INDEPENDENT AUDITOR ON THE SUMMARY
INTERIM CONSOLIDATED FINANCIAL STATEMENTS
TO THE Board of Directors OF
MADINET NASR FOR HOUSING & DEVELOPMENT- S.A.E.
We have reviewed the interim consolidated 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 consolidated financial statements are derived, in accordance with the Egyptian Standards on Auditing and the relevant laws and regulations. As stated in our Arabic review report dated 8 May 2018, we expressed an unqualified review conclusion, with an emphasis of matter regarding going concern for a subsidiary, on the interim consolidated financial statements for the period then ended, from which the attached summary consolidated financial statements are derived.
In our opinion, the attached summary consolidated financial statements are consistent in all material respects, with the interim consolidated financial statements for the period then ended.
In order to obtain a comprehensive understanding of the company's interim consolidated 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 consolidated 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, 8 May 2018
Madinet Nasr for Housing & Development - S.A.E.
CONSOLIDATED STATEMENT OF FINANCIAL POSITION
At 31 March 2018
31/3/2018 | 31/12/2017 | ||
Note | L.E. | L.E. | |
Assets | |||
Non-Current Assets | |||
Fixed assets (Net) | 4/1 | 56,831,564 | 54,660,510 |
Projects under Construction | 4/2 | 11,229,929 | 12,927,380 |
Held to maturity investments | 5/1 | 672,200 | 672,200 |
Available for sale investments | 5/2 | 4,829,302 | 4,829,302 |
Investments in properties | 5/3 | 10,482,763 | 10,220,066 |
Long term notes receivable (Net) | 8 | 5,482,534,860 | 5,144,994,601 |
Deferred tax asset | 31 | 11,969,936 | 11,960,016 |
Total Non-Current Assets | 5,578,550,554 | 5,240,264,075 | |
Current Assets | |||
Inventories | 6 | 59,145,156 | 54,221,611 |
Housing & development projects - WIP | 7 | 1,386,147,785 | 1,279,706,549 |
Housing & development projects - Finished properties | 7 | 78,545,714 | 78,262,306 |
Short term notes receivable | 8 | 1,734,336,960 | 1,576,608,078 |
Trade and notes receivables (Net) | 8 | 802,341,024 | 719,768,886 |
Trade payables - debit balances (Net) | 9 | 208,265,373 | 226,039,067 |
Debtors and other debit balances (Net) | 10 | 195,231,353 | 174,260,035 |
Cash margin on letters of guarantee | 10,329,638 | 10,329,638 | |
Investments at fair value through profit or loss | 5/4 | 11,013,802 | 10,807,609 |
Deposits for projects' maintenance | 21 | 200,650,109 | 192,332,965 |
Cash and bank balances | 11 | 324,130,048 | 268,982,819 |
5,010,136,962 | 4,591,319,563 | ||
Assets held for sale | 4/3 | 14,731,191 | 14,731,191 |
Total Current Assets | 5,024,868,153 | 4,606,050,754 | |
Total Assets | 10,603,418,707 | 9,846,314,829 | |
EQUITY AND LIABILITIES | |||
Equity | |||
Issued and paid up capital | 17 | 997,100,389 | 997,100,389 |
Legal reserve | 123,313,788 | 123,313,788 | |
Retained earnings | 1,263,461,126 | 332,036,186 | |
Net profit for the period/year | 313,506,629 | 931,621,229 | |
Issued capital and reserves attributable to owners of the parent | 2,697,381,932 | 2,384,071,592 | |
Non-controlling interest | 18 | 70,342,710 | 70,527,049 |
Total Equity | 2,767,724,642 | 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 FINANCIAL POSITION - Continued
At 31 March 2018
31/3/2018 | 31/12/2017 | ||
Note | L.E. | L.E. | |
Non-Current Liabilities | |||
Unearned revenues | 12 | 5,644,197,394 | 5,119,127,351 |
Term loans | 19 | 180,460,094 | 207,152,774 |
Total Non-Current Liabilities | 5,824,657,488 | 5,326,280,125 | |
Current Liabilities | |||
Creditors - customers | 66,584,790 | 79,187,826 | |
Provisions | 13 | 122,941,721 | 128,640,704 |
Creditors | 89,248,903 | 150,410,550 | |
Project infrastructure completion liabilities | 14 | 160,777,273 | 170,827,359 |
Deferred profit & interest on outstanding installments | 15 | 210,859,957 | 226,811,160 |
Dividends payable | 2,666,518 | 6,962,447 | |
Creditors & other credit balances | 16 | 433,971,905 | 447,911,362 |
Current portion of long term loans | 19 | 177,603,852 | 177,892,520 |
Short term loans | 20 | 30,256,428 | 56,875,747 |
Liabilities for projects' maintenance | 21 | 200,590,445 | 192,401,793 |
Credit banks (credit facilities) | 20 | 127,650,772 | 130,804,575 |
Tax Authority | 387,884,013 | 296,710,020 | |
Total current liabilities | 2,011,036,577 | 2,065,436,063 | |
Total Liabilities | 7,835,694,065 | 7,391,716,188 | |
Total Equity and Liabilities | 10,603,418,707 | 9,846,314,829 |
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 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 | 610,802,468 | 747,986,399 |
Less: | |||
Cost of revenue | 22-b | (122,294,428) | (154,777,075) |
Gross Profit | 488,508,040 | 593,209,324 | |
Less: | |||
Selling and marketing expenses | 24 | (36,714,383) | (64,151,554) |
General and administrative expenses | 25 | (24,700,543) | (19,772,178) |
Impairment of inventory | (700,000) | - | |
Provisions | 13 | (1,210,001) | (3,854,265) |
Provisions no longer required | - | 63,290 | |
Finance expenses | (29,352,296) | (2,798,394) | |
Add: | |||
Finance revenue | 26 | 6,946,377 | 10,367,620 |
Profit from operations | 402,777,194 | 513,063,843 | |
Revenue from investment available for sale | 41,716 | - | |
Other revenue | 27 | 11,188,080 | 14,144,355 |
Other expenses | 28 | (5,076,451) | (1,436,430) |
Net profit for the period before tax | 408,930,539 | 525,771,768 | |
Income tax | (95,440,288) | (118,714,910) | |
Deferred tax | 31 | 9,920 | 115,309 |
Net profit for the period | 313,500,171 | 407,172,167 | |
Add/(Less): Non-controlling interest | 6,458 | (1,738,668) | |
Attributable to owners of the parent | 29 | 313,506,629 | 405,433,499 |
Earnings per share for the period | 33 | 0.28 | 0.37 |
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 period ended 31 March 2018
31/3/2018 | 31/3/2017 | |
L.E. | L.E. | |
Net profit for the period | 313,500,171 | 407,172,167 |
Other comprehensive income | - | - |
Total other comprehensive income | 313,500,171 | 407,172,167 |
Add:/(Less): Non-controlling interest | 6,458 | (1,738,668) |
Owners of the parent | 313,506,629 | 405,433,499 |
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 period ended 31 March 2018
Issued and paid up Capital | Treasury stocks | Legal reserve | Retained earnings | Net profit for the period | Total | Non-controlling interest | Total | |
L.E. | L.E. | 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 | 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 | (759,938,529) | - | (723,000,000) | - | (723,000,000) |
Retained earnings used for Al Nasr for Civil Works | - | - | - | (2,387,211) | - | (2,387,211) | (2,163,325) | (4,550,536) |
Total comprehensive income for the period | - | - | - | 405,433,499 | 405,433,499 | 1,738,668 | 407,172,167 | |
Balance at 31 March 2017 | 500,000,000 | - | 123,313,788 | 347,167,674 | 405,433,499 | 1,375,914,961 | 69,247,787 | 1,445,162,748 |
Balance at 1 January 2018 | 997,100,389 | - | 123,313,788 | 332,036,186 | 931,621,229 | 2,384,071,592 | 70,527,049 | 2,454,598,641 |
Transferred to retained earnings | - | - | - | 931,621,229 | (931,621,229) | - | - | - |
Retained earnings used for Al Nasr for Civil Works | - | - | - | (196,289) | - | (196,289) | (177,881) | (374,170) |
Total comprehensive income for the period | - | - | - | - | 313,506,629 | 313,506,629 | (6,458) | 313,500,171 |
Balance at 31 March 2018 | 997,100,389 | - | 123,313,788 | 1,263,461,126 | 313,506,629 | 2,697,381,932 | 70,342,710 | 2,767,724,642 |
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 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 | 408,930,539 | 525,771,768 | |
Adjustments for: | |||
Depreciation of fixed assets and investments in properties | 4/1, 5/3 | 2,442,486 | 2,019,389 |
Provisions | 13 | 1,210,001 | 3,854,265 |
Provisions no longer required | - | (63,290) | |
Revenue of investments held to maturity | (41,716) | - | |
(Gain)/Loss on sale of fixed assets | 13,260 | - | |
Net recognized installment sale profit and interest profits and interests due during the period | (14,913,093) | (23,422,017) | |
(Gain)/Loss on foreign exchange | (2,116) | 123,327 | |
Operating profit before working capital changes | 397,639,361 | 508,283,442 | |
Inventory and housing and development projects | (111,648,189) | (70,574,953) | |
Trade receivables, trade payables debit balances and notes receivable | (581,167,395) | (1,416,979,833) | |
Trade payables, unearned revenue, creditorsand utilities' liabilities | 426,277,704 | 1,046,645,719 | |
Provisions used and transferred | 13 | (6,908,984) | (1,216,528) |
Dividends paid to directors and employees | (4,492,215) | (129,170) | |
Income tax paid | (4,266,295) | (5,598,073) | |
Net cash from operating activities | 115,433,987 | 60,430,604 | |
INVESTING ACTIVITIES: | |||
Payments for purchase of fixed assets & projectsin progress | (2,915,883) | (2,745,008) | |
Payments for investments in properties | (276,163) | (4,633) | |
Revenue from other investments held to maturity | 41,716 | - | |
Net cash used in investing activities | (3,150,330) | (2,749,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 - Continued
For the period ended 31 March 2018
31/3/2018 | 31/3/2017 | ||
Note | L.E. | L.E. | |
FINANCING ACTIVITIES: | |||
Purchase of treasury stocks | - | 73,200,001 | |
Non-controlling interest | (177,881) | (117,056) | |
Proceeds from long term loans | 19 | - | 51,332,431 |
Repayments for long term loans | 19 | (26,981,348) | (1,960,136) |
Repayments for short term loans | 20 | (26,619,319) | (14,500,000) |
Net cash (used in)/from financing activities | (53,778,548) | 107,955,240 | |
Change in cash and cash equivalents | 58,505,109 | 165,636,203 | |
Cash and cash equivalents at the beginning of the period | 148,985,853 | 280,346,734 | |
Gain/(Loss) on foreign exchange | 2,116 | (123,327) | |
Total cash and cash equivalents at the endof the period | 207,493,078 | 445,859,610 | |
Less: Pledged time deposits against letters of guarantee | (66,747,182) | (67,503,632) | |
Cash and cash equivalents at the end of the period | 20 | 140,745,896 | 378,355,978 |
NON-CASH TRANSACTIONS:
The statement of cash flows does not include the following non-cash transactions:
- An amount of L.E. 1,823,508 represents amount transferred from projects under construction to fixed assets during the period.
- An amount of L.E. 200,650,109 (2017: L.E. 192,332,965) represents bank accounts and deposits against liabilities for projects maintenance.
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 was registered in the Commercial Registry under 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 period ended 31 March 2018 on 2 May 2018.
1. COMPANY BACKGROUND - Continued
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.
§ 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 | Activity |
Al Nasr for Civil Works S.A.E. | 52.46% | Civil construction |
Al Nasr for Utilities and Erection S.A.E. | 97.52% | 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.
2. USE OF ESTIMATES AND JUDGMENTS
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
Fixed assets expected useful lives are reviewed regularly.
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.
3. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued
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.
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) Investments in 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.
3. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued
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
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) Trade receivables, notes receivables and other debit balances
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.
3. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued
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 credit balances
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.
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 stocks
Treasury stocks 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.
3. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued
§ 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:
· 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.
3. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued
s) Direct and indirect cost
Direct and indirect costs incurred for the constructions of the real estate are accumulated in the housing and development projects inventory account. Cost of the completed units are comprises of land cost, cost of building constructed and other indirect costs.
t) Rent expenses
Rent expenses are recorded in the statement of income on a straight line method over the rent period.
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 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.
3. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES - Continued
w) 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.
x) 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.
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 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 2018 | 1,660,315 | 27,309,432 | 34,189,173 | 18,918,416 | 3,916,640 | 15,353,286 | 18,956,461 | 120,303,723 |
Additions during the period | - | 618,121 | 1,122,015 | - | 3,267 | 595,382 | 451,041 | 2,789,826 |
Transferred from projects under construction (4/2) | - | - | 1,823,508 | - | - | - | - | 1,823,508 |
Disposals | - | - | - | - | - | (3,442) | (29,670) | (33,112) |
At 31 March 2018 | 1,660,315 | 27,927,553 | 37,134,696 | 18,918,416 | 3,919,907 | 15,945,226 | 19,377,832 | 124,883,945 |
Accumulated depreciation: | ||||||||
At 1 January 2018 | - | 5,243,742 | 25,306,511 | 17,157,637 | 3,482,875 | 9,288,610 | 5,163,838 | 65,643,213 |
Provided during the period | - | 525,762 | 918,534 | 196,273 | 17,755 | 301,524 | 469,172 | 2,429,020 |
Related to disposals | - | - | - | - | - | (2,436) | (17,416) | (19,852) |
At 31 March 2018 | - | 5,769,504 | 26,225,045 | 17,353,910 | 3,500,630 | 9,587,698 | 5,615,594 | 68,052,381 |
Net book value: | ||||||||
At 31 March 2018 | 1,660,315 | 22,158,049 | 10,909,651 | 1,564,506 | 419,277 | 6,357,528 | 13,762,238 | 56,831,564 |
At 31 December 2017 | 1,660,315 | 22,065,690 | 8,882,662 | 1,760,779 | 433,765 | 6,064,676 | 13,792,623 | 54,660,510 |
(*) 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 operating are as follows:
31/3/2018 | 31/12/2017 | |
L.E. | L.E. | |
Buildings and constructions | 636,848 | 527,078 |
Motor vehicles | 14,993,032 | 14,982,407 |
Furniture and office equipment | 4,621,588 | 4,607,708 |
Machinery & equipment | 17,645,939 | 17,617,372 |
Tools | 3,258,960 | 3,254,703 |
41,156,367 | 40,989,268 |
b) Depreciation for the period is allocated as follows:
31/3/2018 | 31/3/2017 | |
L.E. | L.E. | |
Cost of sales | 1,227,555 | 1,063,422 |
Selling & marketing expenses (Note 24) | 358,586 | 31,984 |
General and administrative expenses (Note 25) | 842,879 | 910,516 |
2,429,020 | 2,005,922 |
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 | 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 (Parent Co.) | 10,590,346 | 12,287,797 |
Al Nasr Company for Civil Works | 639,583 | 639,583 |
11,229,929 | 12,927,380 |
4/3 ASSETS HELD FOR SALE - Al Nasr Company for Civil Works
31/3/2018 | 31/12/2017 | |
L.E. | L.E. | |
Land and building of administrative building in Nasr City | 3,665,877 | 3,665,877 |
Cost of work executed for administrative building in Nasr City | 11,065,314 | 11,065,314 |
14,731,191 | 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/3/2018 | 31/12/2017 | |
L.E. | L.E. | |
Investments in Governmental bonds | 672,200 | 672,200 |
5/2 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.76 | 300,000 | 300,000 |
Investments in other companies | 215,192 | 215,192 | |
4,829,302 | 4,829,302 |
5/3 Investments in properties
31/3/2018 | 31/12/2017 | |
L.E. | L.E. | |
Allocated land for Development and Housing Projects | 6,195,619 | 5,919,456 |
Held land ownership on sold properties | 3,427,691 | 3,427,691 |
Rented building - Net (*) | 859,453 | 872,919 |
10,482,763 | 10,220,066 |
Fair value of investment properties is not less than its book value.
(*) Rented 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/4 Investments at fair value through profit and loss
31/3/2018 | 31/12/2017 | |
L.E. | L.E. | |
Investment certificates in: | ||
QNB Investment Fund | 1,026,362 | 992,307 |
Bank Misr Investment Fund (Day-By-Day) | 249,231 | 240,662 |
Banque Du Caire Investment Fund | 700,113 | 859,676 |
United Bank Investment Fund | 9,016,137 | 8,693,005 |
SAIB Investment Fund | 21,959 | 21,959 |
11,013,802 | 10,807,609 |
6. INVENTORIES
31/3/2018 | 31/12/2017 | |
L.E. | L.E. | |
Materials | 55,711,164 | 47,528,173 |
Fuel and oil | 205,851 | 319,803 |
Spare parts and supplies | 872,713 | 957,739 |
Others (materials on site & WIP) | 3,190,428 | 5,550,896 |
59,980,156 | 54,356,611 | |
Less: Inventory Impairment Allowance | (835,000) | (135,000) |
59,145,156 | 54,221,611 |
7. HOUSING & DEVELOPMENT PROJECTS
31/3/2018 | 31/12/2017 | |
L.E. | L.E. | |
Uncompleted properties and lands: | ||
El Waha Project | 170,201,878 | 141,766,889 |
6th October Project | 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 | |
Finished properties: | ||
El Waha Project | 6,680,048 | 6,420,410 |
Nasr City (Main City) Project | 11,587,224 | 11,563,454 |
6th October Project | 60,278,442 | 60,278,442 |
78,545,714 | 78,262,306 | |
Total lands, uncompleted and finished properties | 1,464,693,499 | 1,357,968,855 |
8. TRADE AND NOTES RECEIVABLE
31/3/2018 | 31/12/2017 | |
L.E. | L.E. | |
Long term notes receivable | ||
Tag Sultan Project | 391,864,149 | 450,606,088 |
Tag City (Zone T) Project | 2,446,163,884 | 2,467,547,802 |
Tag City (Zone B) Project | 708,020,977 | 257,133,516 |
Premira Project | 76,285,642 | 82,497,978 |
Capital Gardens | 421,998,377 | 370,059,492 |
Sarai City | 2,748,695,869 | 2,791,411,454 |
Total long term notes receivables | 6,793,028,898 | 6,419,256,330 |
Less: Discount to present value | ||
Tag Sultan Project | (61,477,284) | (72,679,392) |
Tag City (Zone T) Project | (429,465,385) | (447,929,785) |
Tag City (Zone B) Project | (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 receivable at present value | 5,482,534,860 | 5,144,994,601 |
Short term notes receivable | ||
Tag Sultan Project | 233,057,029 | 239,698,796 |
Tag City (Zone T) Project | 579,802,648 | 548,036,867 |
Tag City (Zone B) Project | 162,797,529 | 57,907,386 |
Premira Project | 55,410,058 | 51,796,263 |
Sarai City | 703,269,696 | 679,168,766 |
1,734,336,960 | 1,576,608,078 | |
Trade receivables (Net) | ||
Tag Sultan Project | 4,518,411 | 4,830,678 |
Tag City (Zone T) Project | 70,782,664 | 59,461,906 |
Tag City (Zone B) Project | 691,488 | - |
Premira Project | 682,811 | 516,394 |
Sarai City | 78,128,031 | 54,767,667 |
El Waha and Nasr City project | 228,190,831 | 242,857,571 |
Land | 115,107,839 | 51,471,905 |
Rent | 1,250,735 | 1,128,196 |
Construction contracts | 355,759,999 | 356,186,354 |
855,112,809 | 771,220,671 | |
Less: Impairment of trade receivables | (52,771,785) | (51,451,785) |
802,341,024 | 719,768,886 |
9. TRADE PAYABLES - DEBIT BALANCES - NET
31/3/2018 | 31/12/2017 | |
L.E. | L.E. | |
Trade payables & contractors | 249,879,565 | 262,653,259 |
Less: Impairment in trade payables - debit balances | (41,614,192) | (36,614,192) |
208,265,373 | 226,039,067 |
10. DEBTORS AND OTHER DEBIT BALANCES - NET
31/3/2018 | 31/12/2017 | |
L.E. | L.E. | |
Margin of letter of credit | 2,461,375 | 4,464,558 |
Cheques under collection | 2,938,119 | 1,826,132 |
Prepaid expenses | 180,880,994 | 160,601,026 |
Accrued revenue | 2,123,092 | 2,180,029 |
Refundable deposits | 3,422,651 | 3,373,402 |
Other debit balances | 3,468,282 | 1,878,048 |
195,294,513 | 174,323,195 | |
Less: Impairment in debtors and other debit balances | (63,160) | (63,160) |
195,231,353 | 174,260,035 |
11. CASH AND BANK BALANCES
31/3/2018 | 31/12/2017 | |
L.E. | L.E. | |
Bank balances | 79,110 | 62,508 |
Cash on hand | 250,063 | 544,923 |
Bank current accounts with return | 256,045,961 | 201,676,230 |
Time deposits (*) | 67,754,914 | 66,699,158 |
324,130,048 | 268,982,819 |
(*) Time deposit on 31 March 2018 included L.E. 66,747,182 (31/12/2017: L.E. 65,691,426) pledged time deposits against letters of guarantee.
12. UNEARNED REVENUES
31/3/2018 | 31/12/2017 | |
L.E. | L.E. | |
Tag Sultan Project customers | 487,908,558 | 518,912,026 |
Premira Project customers | 138,960,848 | 133,437,248 |
Zone T Project customers | 2,101,912,372 | 2,010,245,953 |
Zone B Project 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 |
13. PROVISIONS
Balance at 1/1/2018 | Provided during the period | Used during the period | Transferred during the period | Balance at 31/3/2018 | |
L.E. | L.E. | L.E. | L.E. | L.E. | |
Disputed taxes provision | 12,228,706 | - | - | - | 12,228,706 |
Claims provision | 47,909,366 | - | - | (8,320,000) | 39,589,366 |
Legal provision | 20,966,727 | 10,001 | - | - | 20,976,728 |
Projects contingency provision | 13,000,000 | - | - | - | 13,000,000 |
General provision | 15,000,000 | - | - | - | 15,000,000 |
Other provisions | 19,535,905 | 1,200,000 | (588,984) | 2,000,000 | 22,146,921 |
128,640,704 | 1,210,001 | (588,984) | (6,320,000) | 122,941,721 |
14. PROJECT INFRASTRUCTURE COMPLETION LIABILITIES
Balance at 1/1/2018 | Formed for the sales of the period | Work executed during the period | 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 |
15. DEFERRED PROFIT & INTEREST 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 |
16. 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 | 221,155,900 | 222,190,231 |
Down payment for land & property sales (El Waha & 6th October) | 6,064,580 | 6,069,741 |
Down payment for land & property sales (Tag Sultan, T Zone and Premira) | 9,157,426 | 7,781,757 |
Selling and marketing commissions | 33,562,157 | 23,304,415 |
Employees' bonus accrued | 9,125,411 | 12,886,045 |
Contractors under settlement | 27,200,706 | 19,337,418 |
Engineering stamp and Building Union stamp | 114,469 | 107,356 |
Customers' balances for canceled reservations | 12,957,883 | 12,004,283 |
Proceeds for maintenance expenses and counters | 9,597,042 | 9,886,005 |
Accrued interest on term loans | 19,137,118 | 19,222,292 |
Governmental authorities | 34,469,346 | 34,108,271 |
Accrued commercials expenses | 23,037,232 | 45,748,121 |
Early retirement benefits and others | 11,397,895 | 21,010,313 |
Creditors of fixed assets purchases | 861,539 | 1,395,353 |
Deposits from customers under reconciliation | 2,045,518 | 1,205,209 |
Other | 1,057,866 | 897,398 |
433,971,905 | 447,911,362 |
17. 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 | 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% |
18. NON-CONTROLLING INTEREST
31/3/2018 | 31/12/2017 | ||
Non-controlling interest in net assets | Non-controlling interest share in net assets | Non-controlling interest share in net assets | |
% | L.E. | L.E. | |
Al Nasr Company for Civil Works | 47.54 | 71,984,485 | 72,064,471 |
Al Nasr Company for Utilities & Erection | 2.48 | (1,641,775) | (1,537,422) |
Total non-controlling interest | 70,342,710 | 70,527,049 |
19. 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/3/2018 | ||||
Balance at the beginning of the period | 1,694,337 | 2,026,971 | 381,323,986 | 385,045,294 |
Installments paid 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 |
Classified to financial positionas follows: | ||||
Current liabilities: | ||||
Current portion of term loans | 456,524 | 1,738,303 | 175,409,025 | 177,603,852 |
Non-current liabilities: | ||||
Term loans | 1,237,813 | - | 179,222,281 | 180,460,094 |
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 |
Installments paid during the 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 |
Classified to financial positionas 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 |
20. CASH AND CASH EQUIVALENTS
Cash and cash equivalents included in the statement of cash flows comprise the following consolidated financial position amounts:
31/3/2018 | 31/12/2017 | |
L.E. | L.E. | |
Cash and bank balances (Note 11) | 324,130,048 | 268,982,819 |
Investment at fair value through profit and loss (Note 5/4) | 11,013,802 | 10,807,609 |
Less: | ||
Credit banks - credit facilities | (127,650,772 ) | (130,804,575) |
207,493,078 | 148,985,853 | |
Less: | ||
Pledged time deposits against letters of guarantee | (66,747,182) | (65,691,426) |
Cash and cash equivalents at the end of the period | 140,745,896 | 83,294,427 |
The balance of credit banks are summarized as follows:
31/3/2018 | 31/12/2017 | |
L.E. | L.E. | |
Madinet Nasr for Housing Development (Parent company) | 85,928,330 | 91,216,797 |
Al Nasr Company for Civil Works (Subsidiary) | 41,722,442 | 39,587,778 |
127,650,772 | 130,804,575 |
Short term loans
31/3/2018 | 31/12/2017 | |
L.E. | L.E. | |
Balance at the beginning of the period/year | 56,875,747 | 19,333,333 |
Proceeds during the period/year | - | 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 |
21. PROJECT'S MAINTENANCE DEPOSITS AND LIABILITIES
31/3/2018 | 31/12/2017 | |
L.E. | L.E. | |
Bank current saving 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 |
Others | (59,664) | 68,828 |
Project maintenance deposit and liabilities | 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 (2017: L.E. 776,641,173). The sum of L.E. 200,650,109 (2017: L.E. 192,401,793) was collected and invested in deposits and interest-bearing bank accounts. The remaining balance amounting to L.E. 655,751,944 (2017: L.E. 584,239,380) at 31 March 2018 will be collected on maturity dates during the following periods.
22. SALES AND COST OF SALES
22-a Net Revenues
31/3/2018 | 31/3/2017 | |
L.E. | L.E. | |
Property sales revenue | ||
El Waha Project | 31,360,393 | 22,521,240 |
Tag Sultan Project | 3,682,400 | - |
Premira Project | 56,941,158 | 17,508,051 |
Tag city (Zone T) Project | 152,331,788 | - |
Capital Gardens project | 39,357,928 | 2,550,431 |
Sarai project | 58,598,688 | 573,568,939 |
El Waha Project | 120,000 | 160,000 |
Property sales revenue | 342,392,355 | 616,308,661 |
Land sales - El Waha and Original City | 120,019,750 | - |
Total property and land sales revenues | 462,412,105 | 616,308,661 |
Total revenues - Al Nasr Company for Civil Works | 40,448,134 | 39,999,353 |
Total revenues - Al Nasr Company for Utilities& Erections | 25,051,146 | 20,287,420 |
Less: Property sales returns | ||
Tag Sultan Project | (216,410) | (35,000) |
Premira Project | - | (1,065,599) |
Tag City - Zone T Project | (8,325,491) | - |
Capital Gardens Project | (2,704,607) | - |
Sarai Project | (7,322,605) | - |
El Waha Project | (1,613,493) | (1,051,980) |
Total property sales returns | (20,182,606) | (2,152,579) |
Net sales | 507,728,779 | 674,442,855 |
Amortization of the present value of notes receivable | 87,860,443 | 49,842,111 |
Profit and interest from deferred sales installment during the period | 14,913,093 | 23,422,017 |
Land and property rent | 300,153 | 279,416 |
Net sales | 610,802,468 | 747,986,399 |
22. SALES AND COST OF SALES - Continued
22-b Cost of Revenues
31/3/2018 | 31/3/2017 | |
L.E. | L.E. | |
Cost of sold property | ||
Tag Sultan Project | 26,913,255 | 18,304,819 |
Premira Project | 869,037 | - |
Tag City (Zone T) project | 4,604,089 | 1,314,671 |
Tag City (Zone B) project | 16,710,835 | - |
Capital Garden project | 1,234,023 | 80,570 |
Sarai project | 10,131,671 | 80,981,715 |
Cost of buildings sold | 60,462,910 | 100,681,775 |
Cost of land sold - El Waha project | 2,168,052 | - |
Total cost of buildings and land sold | 62,630,962 | 100,681,775 |
Cost of revenue for El Nasr Company forCivil Works | 37,301,876 | 32,562,688 |
Cost of revenue for El Nasr Company for Utilities and Erections | 24,914,422 | 21,822,021 |
Less: Cost of sold property returns: | ||
Tag Sultan project | (45,006) | - |
Premira project | - | (250,139) |
Tag City (Zone T) project | (574,147) | - |
Sarai project | (1,577,251) | - |
Capital Garden project | (86,487) | - |
El Waha project | (283,407) | (52,736) |
Total cost of property sales returns | (2,566,298) | (302,875) |
Net cost of sales | 122,280,962 | 154,763,609 |
Depreciation of property investments | 13,466 | 13,466 |
Cost of activity revenues | 122,294,428 | 154,777,075 |
23. CONSTRUCTIONS COMMITMENTS
Al Nasr Co. for Civil Works - (Subsidiary Company)
Contracts for executing utilities and civil constructions amounted to L.E. 2,870 million at 31/3/2018, executed amount at that date amounted to L.E. 2,469 million.
Al Nasr Utilities and Erections Co. - (Subsidiary Company)
Contracts for executing utilities and civil constructions amounted to L.E. 304 million at 31/3/2018, executed amount at that date amounted to L.E. 147 million.
24. SELLING AND MARKETING EXPENSES
31/3/2018 | 31/3/2017 | |
L.E. | L.E. | |
Salaries and wages | 356,537 | 225,829 |
Selling and marketing commissions | 10,962,314 | 29,744,673 |
Advertisements (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 |
Sundry expenses | 964,810 | 962,476 |
36,714,383 | 64,151,554 |
25. GENERAL AND ADMINISTRATIVE EXPENSES
31/3/2018 | 31/3/2017 | |
L.E. | L.E. | |
Salaries, wages and equivalent | 8,855,924 | 9,663,953 |
Board of Directors wages and allowances | 2,516,345 | 1,725,556 |
Depreciation (Note 4/1) | 842,879 | 910,516 |
Other expenses | 12,485,395 | 7,472,153 |
24,700,543 | 19,772,178 |
26. FINANCE REVENUE
31/3/2018 | 31/3/2017 | |
L.E. | L.E. | |
Revenue from investments at fair value through profit and loss | 396,794 | 3,759,077 |
Income from interest and bank deposit | 6,549,583 | 6,608,543 |
6,946,377 | 10,367,620 |
27. OTHER REVENUES
31/3/2018 | 31/3/2017 | |
L.E. | L.E. | |
Administrative expenses from customers (for redemption, assignment, etc.) | 7,163,833 | 2,837,597 |
Reconciled fees for non construction | 1,844,900 | 9,198,013 |
Deviation from construction conditions | - | 897,843 |
Sundry revenue | 2,177,231 | 466,881 |
Prior years' revenues | - | 744,021 |
Foreign exchange gain | 2,116 | - |
11,188,080 | 14,144,355 |
28. OTHER EXPENSES
31/3/2018 | 31/3/2017 | |
L.E. | L.E. | |
Compensations and fines | 3,461,878 | 26,754 |
Donations for others | 425,000 | 311,861 |
Foreign exchange loss | - | 123,327 |
Capital loss | 13,260 | - |
Sundry expenses | 1,176,313 | 974,488 |
5,076,451 | 1,436,430 |
29. CONSOLIDATED STATEMENT OF INCOME
31/3/2018 | 31/3/2017 | |
L.E. | L.E. | |
Net profit from Madinet Nasr for Housing& Development S.A.E. | 328,895,667 | 406,170,254 |
Group portion in net profits of subsidiaries companies | (3,995,392) | (736,755) |
Exclude the effect of impairment in value of investments | (19,518,646) | - |
Exclude the effect of impairment in value of suppliers- credit balances | 8,125,000 | - |
313,506,629 | 405,433,499 |
30. CONTINGENT LIABILITIES
Letters of guarantee
National Bank of Egypt, Banque Misr, United Bank and others, have issued letters of guarantee amounting to L.E. 314.440 million at 31 March 2018 (31/12/2017: L.E. 290.994 million), in favor of third parties, which are secured by part of the company's time deposits amounting to L.E. 66,747,182 (31/12/2017: L.E. 65,691,426) and cash margin on letters of guarantee by L.E. 10,329,638 (31/12/2017: L.E. 10,329,638).
31. DEFERRED TAX
Madinet Nasr for Housing and Development (Parent company)
31/3/2018 | 31/12/2017 | |||
Assets | (Liabilities) | Assets | (Liabilities) | |
L.E. | L.E. | L.E. | L.E. | |
Deferred tax liabilities for fixed assets | - | (3,039,137) | - | (3,046,807) |
Deferred tax assets for provisions | 4,714,654 | - | 4,712,404 | - |
Total deferred tax (liabilities)/ assets | 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) |
31. DEFERRED TAX - Continued
31/3/2018 | 31/12/2017 | |
L.E. | L.E. | |
Unrecorded deferred tax assets (provisions) | 14,570,657 | 14,594,957 |
Al Nasr Co. for Civil Works - (Subsidiary Company)
31/3/2018 | 31/12/2017 | |||
Assets | (Liabilities) | Assets | (Liabilities) | |
L.E. | L.E. | L.E. | L.E. | |
Deferred tax liabilities for fixed assets | - | (267,557) | - | (267,557) |
Deferred tax assets for provisions | 8,078,410 | - | 8,078,410 | - |
Total deferred tax (liabilities)/ assets | 8,078,410 | (267,557) | 8,078,410 | (267,557) |
Net deferred tax assets | 7,810,853 | - | 7,810,853 | - |
Charged to the statement of income | - | - | 3,479,813 | - |
Al Nasr for Utilities and Erections Co. - (Subsidiary Company)
31/3/2018 | 31/12/2017 | |||
Assets | (Liabilities) | Assets | (Liabilities) | |
L.E. | L.E. | L.E. | L.E. | |
Deferred tax liabilities for fixed assets | - | (43,868) | - | (43,868) |
Deferred tax assets for 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
31/3/2018 | 31/12/2017 | |||
Assets | (Liabilities) | Assets | (Liabilities) | |
L.E. | L.E. | L.E. | L.E. | |
Total deferred tax asset (balance sheet) | 11,969,936 | - | 11,960,016 | - |
Total charged to the statement of income | - | 9,920 | 2,778,187 | - |
32. TAX STATUS
Madinet Nasr for Housing and Development S.A.E. (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 - S.A.E. (Subsidiary company)
Tax returns submitted on due dates, the tax has been settled and paid.
32. TAX STATUS - Continued
Al Nasr Co. for Utilities and Erections - S.A.E. (Subsidiary company)
Tax returns were submitted on due dates, the company has objected on tax claims received from the Tax Authority.
33. EARNINGS PER SHARE
31/3/2018 | 31/3/2017 | |
L.E. | L.E. | |
Net profit for the period after tax | 313,506,629 | 405,433,499 |
Less: Estimated employees and Board of Directors share | (29,000,000) | (32,000,000) |
Shareholders' share in net profit for the period | 284,506,629 | 373,433,499 |
Weighted average numbers of sharesoutstanding during the year | 997,100,389 | 996,991,858 |
Earnings per share | 0.28 | 0.37 |
34. 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.
34. 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 March 2018 | ||||
Term loans | 358,063,946 | 177,603,852 | 180,460,094 | - |
Trade and other payables | 433,971,905 | 433,971,905 | - | - |
Short term loans | 30,256,428 | 30,256,428 | - | - |
Creditors and tax | 477,132,916 | 477,132,916 | - | - |
1,299,425,195 | 1,118,965,101 | 180,460,094 | - | |
31 December 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 | 447,120,570 | 447,120,570 | - | - |
1,336,952,973 | 1,129,800,199 | 207,152,774 | - |
· 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 to interest rate type:
31/3/2018 | 31/12/2017 | |
L.E. | L.E. | |
Financial assets instruments with fixed interest rate | ||
Financial assets (trade and notes receivable) | 9,382,478,667 | 8,756,459,021 |
Financial liabilities instruments with floating interest rate | ||
Financial liabilities (Long and short term loans and credit banks) | 515,971,146 | 572,725,616 |
· 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.
35. CONTRACTUAL COMMITMENTS
The value of contracts with contractors for the implementation of housing and development projects amounted to L.E. 984 million as of 31/3/2018 executed of which by an amount of L.E. 868 million. Contractors' dues have been paid in accordance with the contracts.
36. 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.
37. COMPARATIVE FIGURES
Certain prior year figures have been reclassified to conform to the financial statement presentation for the current year.
38. 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