Case 032Sector economicsHard
Ambrosa Developers pre-sold Rs 5,000 crore of flats this year but books revenue on completion, so reported revenue is Rs 2,200 crore. Value it on net asset value instead of P/E.
1The situation
Ambrosa Developers builds residential towers. It sells flats while they are under construction, collecting instalments as work progresses, but books revenue only when a project is completed and handed over, two to three years after the sale. Pre-sales over the last five years were Rs 1,900, 2,100, 2,300, 3,400 and 5,000 crore. Reported revenue this year is Rs 2,200 crore at a 14% net margin, Rs 308 crore of profit on 25 crore shares, and the shares trade at Rs 240.
From the project disclosures: on flats sold but not yet booked, customers still owe Rs 5,000 crore and Ambrosa still has Rs 3,200 crore to spend building them. Unsold flats in ongoing projects are worth Rs 6,000 crore at current prices with Rs 2,400 crore still to spend. The land bank, already paid for, can support Rs 20,000 crore of sales at a building cost of Rs 13,000 crore, launched over about five years. Net debt, after the customer advances already collected, is Rs 900 crore. Tax is 25% of profit and the discount rate is 12%.
2Your task
Why does P/E mislead here, and what does a net asset value give per share?
Quick check
Ambrosa trades at about 19.5x this year's earnings. What happens to that P/E on year 7's earnings if nothing more is sold?
Worked solution
Try it on paper, then open one step at a time.
30-second answerThe answer to give first
On net asset value Ambrosa is worth about Rs 5,597 crore, Rs 224 a share, so at Rs 240 it trades near 1.07x NAV. P/E misleads because booked revenue reflects flats sold two to three years ago: the same price is 19.5x this year's earnings and about 10x year 7's. NAV discounts the cash still to come from sold flats, unsold flats and the land bank, then subtracts net debt.
Step 1Why does a developer's P/E tell you so little?
A tailor who takes orders in January and delivers suits in March books nothing in January, however busy the shop is. A developer is the same tailor with a two to three year gap. Pre-sales measure the business being done today; booked revenue measures the business done two or three years ago, so any multiple of booked earnings is a multiple of old news. When pre-sales jump, as Ambrosa's did from Rs 2,300 crore to Rs 5,000 crore in two years, the P/E looks expensive now and cheap later with no change in the company.
Step 2How do you build the net asset value?
Split the business into buckets of future cash, value each, and subtract what is owed. For every bucket the cash to count is money still to come in, less money still to spend, less tax on the profit, discounted for how long it takes. Customer advances already collected are in the cash balance, which is why net debt is taken after them and why only the Rs 5,000 crore still owed counts for sold flats. Tax is on accounting profit: a 28% margin on the Rs 9,550 crore of sold flats not yet booked, 32% on unsold flats, and Rs 5,500 crore on the land bank after its book cost. This is net asset valueFor a developer, the present value of the cash its projects and land will produce, less its net debt; it values the business as a pipeline rather than as a stream of reported profits. in its simplest form.
| Bucket, Rs crore | Still to collect | Still to spend | Tax | Cash | Years | PV at 12% |
|---|---|---|---|---|---|---|
| Sold flats not yet booked | 5,000 | 3,200 | 669 | 1,132 | 1.5 | 955 |
| Unsold flats in ongoing projects | 6,000 | 2,400 | 480 | 3,120 | 2.5 | 2,350 |
| Land bank, already paid for | 20,000 | 13,000 | 1,375 | 5,625 | 5.0 | 3,192 |
| Net debt after advances | (900) | |||||
| Net asset value | 5,597 | |||||
| Per share, 25 crore shares | Rs 224 |
Step 3What is the judgement, and what moves it?
At Rs 240 the market pays about 1.07x NAV, a small premium that amounts to paying for land Ambrosa has not bought yet. The land bank is the largest and least certain bucket: it is five years away and its value depends on prices and building costs no one knows today. A 10% fall in the land bank's sale value removes Rs 2,000 crore of inflow, about Rs 34 a share after tax and discounting. Close with that sensitivity and with the pre-sales trend, the leading indicator the NAV quietly assumes will continue.
Where candidates lose it
The common loss is counting the full value of sold flats and also counting the advances already collected in cash, which values the same rupees twice. Net debt after advances and only the money still owed is the consistent pair.
The second is calling the stock expensive at nearly 20x earnings. Booked profit trails selling by years here, and the interviewer wants you to switch to the pipeline before you reach a view.
What the interviewer asks next
- How would a 5% rise in construction costs change the land bank value?
- Why might a developer with strong pre-sales still run short of cash?
- When would you prefer price to book or EV/EBITDA for a property company?
Company names and figures are illustrative.
