Financials and estimate changes
A look through the accounting noise
As indicated above, operational progress in the period has been partly masked by changes to Egyptian GAAP and the IFRS basis on which our forecasts are based.
The most significant change affecting both IFRS and GAAP is that revenues from the sale of standalone units, including the associated land (typically 50% of the contract value), are recognised on a percentage of completion method; land revenues and profits had previously been recognised up front. The treatment of apartments is essentially the same, although as a practical matter there is a 100% completion hurdle, meaning that all revenue and cost is recognised when the unit is delivered to the customer. It is very important to note that the changes have no impact on cash flows or ultimate profits, but have deferred some profit recognition into the future. The company has provided a full comparison of the 9M16 results under both old and new GAAP for 9M16 and 9M15, which is replicated below. The effects on IFRS numbers will be similar and we await publication of the IFRS accounts in the next few weeks.
Exhibit 1: Palm Hills’ 9M16 results year-on-year comparison under old and new GAAP
EGPm |
9M16 new GAAP |
9M15 new GAAP |
9M16 old GAAP |
9M15 old GAAP |
Y-o-y change under new GAAP |
New sales |
5,454 |
4,618 |
5,454 |
4,618 |
18% |
Revenue |
3,628 |
2,586 |
3,833 |
2,627 |
40% |
Gross profit |
1,106 |
911 |
1,354 |
983 |
21% |
Gross profit margin |
30% |
35% |
35% |
37% |
(5 pp) |
EBITDA |
700 |
592 |
948 |
665 |
18% |
EBITDA margin |
19% |
23% |
25% |
25% |
(4 pp) |
Net profit before tax and minorities |
682 |
798 |
930 |
871 |
(15%) |
Net profit |
404 |
747 |
593 |
820 |
(46%) |
Net profit margin |
11% |
29% |
15% |
31% |
(18pp) |
Source: Company data, Edison Investment Research
■
Sales (or reservations), as referred to above, are unaffected by the accounting change. Revenues grew strongly under both the old and new methods, at 46% and 40% respectively, with the new method effectively deferring some revenue recognition until future periods.
■
The 9M15 EBITDA margin is restated at 23% or 2pp below the 25% reported under the old method. For 9M16, the margin under the old basis falls 6pp to 19% under the new GAAP. We think this is a reasonable indication of the mix and first sold/first delivered effects detailed above, particularly the delivery of lower margin apartments sold pre-2011. Hence, the unusually low EBITDA margin of 19% recorded on the new basis includes both the accounting change impacts/profit deferral and the mix effects. Management indicates that the mix effects should erode by the year end and we expect that the gross profit margin, on a GAAP basis, will be in the range of 29-32% for the year as a whole and 36% over the medium term.
■
Not directly related to accounting changes, 9M16 also saw the anticipated increase in the tax rate (there had been a corporate tax holiday until 31 December 2015), as well as an increase in the share of profits attributable to minorities. The latter reflects the current construction and delivery of projects (such as Palm Hills Katameya Extension) that have a higher minority ownership than is the average across the pipeline.
As indicated above, our estimates are on an IFRS basis (the main difference with GAAP is that provisions are taken as part of general and administrative expenses, reducing EBITDA; the PBT and net profit figures are the same under both regimes) and we are now taking the opportunity to shift these from an old to a new IFRS basis. Although a comparison of old and new IFRS similar to the GAAP analysis above is not available for 9M16, we believe the accounting revenue deferral effects will be similar.
Estimate revisions (new IFRS basis)
Looking forward, we have adjusted our estimates for the new accounting method and for the mix of deliveries in 9M16, which is a temporary effect that management expects to finish before 2017. This has reduced our 2016 EBIT and earnings forecasts, reducing cash, with a concomitant effect on NAV. Our new estimates, on the new IFRS basis, are shown in Exhibit 2. We have not yet included the effects of the securitisation of receivables, meaning that the interest rate rise has increased the cost of borrowing in our estimate for 2017, reducing EPS. Once the pricing and quantum of the first tranche of the securitisation are known we will seek to take it into account.
Exhibit 2: Changes to forecasts
|
Revenue (EGPm) |
EBIT (EGPm) |
NAV/share (EGP) |
EPS (EGP) |
|
Old |
New |
Change |
Old |
New |
Change |
Old |
New |
Change |
Old |
New |
Change |
2016e |
4,280 |
4,733 |
11% |
1,022 |
863 |
-16% |
2.86 |
2.64 |
-8% |
0.28 |
0.22 |
-21% |
2017e |
4,318 |
4,832 |
12% |
970 |
973 |
0% |
3.07 |
2.83 |
-8% |
0.21 |
0.20 |
-7% |
Source: Edison Investment Research
Cash flow and balance sheet
Having accelerated construction and delivery over the past couple of years, management still aims to complete all construction projects that had been started before 2016 by the end of 2017. In addition to faster recognition of revenues and profits (although, as seen in 9M16, some older projects have slimmer margins) this will free management resources to focus on new projects. In cash terms, having paid a c 10% deposit when reserving a property (a sale for Palm Hills), customers typically pay an additional 10% of the value at contract and the balance in instalments over four to seven years. Accelerated construction increases the outflow of cash (to fund construction and land purchases) relative to inflows and has been the main driver for negative operational cash flow at Palm Hills over the past couple of years, despite (or because of) the strong growth in sales.
In the nine months to October, Palm Hills spent EGP1.5bn on construction and received EGP2.3bn in customer payments. However, there was an operating cash outflow as a result of land payments and general and administrative expenses. The cash balance ended the period at EGP929m, similar to the 2015 year-end position of EGP966m. While we await the IFRS figures, the exact net debt number cannot be determined from the GAAP accounts (because the definitions of various balance sheet items differ between the two sets of accounting standards), but we expect it to be in the region of EGP2.8bn (47% of shareholder equity) compared with EGP2,145m (34%) at the end of FY15. Obviously the dividend distribution is a significant factor, but so was the EGP0.5bn increase in working capital to fund construction, which came from a drawdown of credit. We expect positive operating cash flow to emerge in 2017, in line with our previous forecasts.
To improve gearing and bring forward positive cash flow, Palm Hills plans to securitise up to EGP2.5bn of customer receivables attached to units that have already been delivered, beginning with an EGP350-450m bond in Q416. The bond will be without recourse to Palm Hills and is secured on the delivered properties, so there is no construction risk and some security against default for bondholders. From Palm Hills’ perspective, it is a low-risk source of capital and makes use of what is now its largest balance sheet asset (Exhibit 3).
Exhibit 3: Notes receivable as % of assets (IFRS)
|
|
Source: Company data, Edison Investment Research. Note: Notes receivable are customer receivables.
|
We have not yet included the securitisation programme in our estimates, but we believe the likely cost will be in line with our assumed weighted average cost of capital (21%); this is in line with management indications.