CDC datacentres: Land value vs Improvements value
Quote:
Originally Posted by
Snoopy
It has been pointed out to me that I have made an error in my depreciation estimate calculation. The error being that I have ignored the owned land on which the datacentres are built and onto which any expansions are going to be built. We do have a bit of an obsession in NZ with 'land'. But the vast majority of the CDC land is of course in Australia where most of their business is located.
The interesting thing about datacentres is that when signals are being fired back and forth to them along optical fibres at up to 70% of the speed of light the distance from the point of data use to the point of data storage becomes less relevant. IOW whether the datacentre structure is 5km away or 50km away, the operator on the end is not going to to be able to tell much difference. This means datacentre builders can be a bit less choosy about where they build their structures. They do not have to compete with logistics distribution houses for prime space.
Looking at Googlemaps, it appears the Canberra CDC datacentre there is about 20km out of the city 'in the middle of nowhere'. So I suspect the land bank value of CDC is actually not that high - probably no more than 10% of the value of all CDC long term assets. This means my correction to overall depreciation to take account of land (which does not depreciate) is likely relatively small. Maybe applying to only 10% of the value of the long term assets?
Non current assets at EOFY2023 (the time point used for setting depreciation rates) were $A5,762.3m. 90% of that value (being the non-land assets) amounts to $A5,186m.
The above post is on the side of being 'poorly researched' by my standards. Assuming that land makes up 10% of the long term asset portfolio was just a guess. Can I back it up?
'Oneroof' has an estimated value of 23 Popes Road at Takinini, which is the home of Spark's Takanini data centre
https://www.oneroof.co.nz/property/a...pes-road/JRyhD
The June 2021 estimated value was $29.5m, made up of land $10.2m (c.f. $5.6m in 2017) and improvements $19.3m (c.f. $17.5m in 2017). Interestingly 'Oneroof' records the property being sold as a bare land purchase in 2014 for $4.42m. This would have been the time that Spark bought the property for the development of the first stage of their Takanini datacentre in 2014.
https://www.reseller.co.nz/article/1...ta-centre.html
The reported total development cost was reported as $60m back in 2014 (which would have included the land cost). Now $4.42m/ $60m = 7.4%. That means the land purchase was just 7.4% of the project cost at the time. Since opening, the Spark Takanini datacentre has undergone a multi-million dollar capability upgrade. So as far as book value goes, the value of long term assets at the Takainini site that are land may be as low as 5%.
One can't be sure that such development costs are indicative of the relative long term assets values of a new datacentre portfolio built by CDC today. It looks like land in Auckland at least has shot up in value in relative terms since the Spark Takanini datacentre was conceived. Yet despite this increasing land price effect, I believe this Spark Takanini site data is good supporting evidence that my overall guess of the land part of the CDC long term asset portfolio - being no more than 10% of the total long term assets on the books - is reasonable, and maybe even a little high.
SNOOPY
Calculating Operational CDC NPAT: Attempt 7
When you knocked down with yet another intellectual 'sucker punch', the only thing to do is to get up again. With the latest information and interpretations flowing through the knowledgometer, time for another crack at this exercise.
We know that Infratil own a 48.24% stake of CDC. Rather than create possible extra confusion by trying to adjust for the Infratil share all the way through, I will use the raw CDC numbers and make any Infratil ownership share adjustments right at the end.
.
Interest Calculation
Interest which is used to finance construction projects is subject to 'capitalisation of interest' in any net profit calculation. If interest is capitalised, it no longer becomes an expense.
Starting from the Infratil capital raising presentation:
https://infratil.com/news/infratil-a...-equity-raise/
Slide 14 shows a key CDC metric is 7-10 times leverage. I will use the larger number (10), because that will give me the largest interest capitalisation effect. A leverage ratio of 10 means $10m of debt for every $1m of equity is CDC's preferred new project 'funding balance'.
If we look at the limited CDC balance sheet information we are given (AR2024 p80) total assets rose from $5,872.4m (EOFY2023) to $6,820.7m (EOFY2024), which is a rise of $948.3m.
Let's assume that all of that increment represents new data centre builds, being constructed over FY2024. Now, new assets are funded by a combination of debt and equity. With a 10:1 leverage ratio, we are looking at 'new project funding units' of $948.3m/11= $86.2m. In this instance this means $86.2m of equity funding, with the balance $948.3m-$86.2m = $857.1m funded by debt. Interest which is associated with this $857.1m in debt funding is interest that becomes capitalised.
As before, I assume total debt, across the year had a representative value of $4,251.1m. Let's say that USPP funding and other bank funding was secured at a rate of 4.5% (a revised pure guess on my part). That means the annual interest charge for CDC would be: 0.045 x $A4,251.1m = $191.3m.
However, this calculation does not take into account the proportion of interest that was capitalised. The amount of interest capitalised represents $857.1m/$4,251.1m = 20.2% of the outstanding debt. 20.2% of the representative interest bill is: 0.202 x $191.3m = $38.6m. So $38.6m is the amount of the pool of net interest that I would expect to be capitalised, following on from all of my assumptions.
Depreciation and Amortisation calculation
My average modelled depreciation time remains at 40 years. The buildings may be on the books with a longer life than that, perhaps 50 years. But all of the cooling equipment will depreciate much faster than 40 years. So 40 years is my compromise 'combined total depreciation schedule number'. Amortisation is assumed to be zero over the period, as no goodwill would have been booked on the balance sheet for a 'green field build' data centre.
https://infratil.com/news/infratil-a...-equity-raise/
From slide 7:
"388MW under construction across current footprint"
From slide 13:
"Operating capacity 302MW", "388MW expected to be completed by the end of FY2026."
So we can think of the 'under construction' section of future data centre roll outs as being completed over 3 years. That averages out at 388MW/3= 129MW to be completed over each of FY2024, FY2025 and FY2026. So we could say the paid for work under construction represents ( 129MW/(129MW+302MW) =) 30% of 'long term datacentre assets'.
Non current assets at EOFY2023 (the time point used for setting depreciation rates) were $A5,762.3m. 90% of that value (being the estimated non-land assets) amounts to $A5,186m. 70% of that non land value (being the depreciable assets that have finished construction) is $3,630m. Assuming these assets depreciate on average over 40 years, this gives an annual depreciation charge of ($3,630m/40=)$90.8m.
iif/ Recalculating Net CDC Profit after once again revising interest charges
According to 'forest' who attended the Infratil capital raising presentation, CDC presently earns between 10-15% on its different assets. So I will 'plumb down the middle' and take my asset return percentage being 12.5% as my estimate. I therefore estimate the income generating ability of those CDC assets on the books at EOFY2024, which I will call EBITDAF, to be: 0.125 x $1,403.4m = $175m. However, it seems that in reality the EBITDAF earning ability of CDC was a little above this lofty goal, coming in at $271m (although this is admittedly a definitively before tax figure. It could be that the return touted by 'forest' of $175m is NPAT).
I now have two operational NPAT figures for CDC over FY2024 to present:
Using NPAT = 0.7 (EBITDAF - I - DA); (assuming the Australian corporate tax rate of 30%)
For no capitalisation of interest charges, I get:
'Operational NPAT' = 0.7 ( $271m - $191.3m - $90.8m ) = -$7.8m, of which the IFT share is 0.4824 x -$7.8m = -$3.3m
For capitalisation of interest allowed, I get:
'Operational NPAT' = 0.7 ( $271m - ($191.3m - $38.6m) - $90.8m ) = $19.3m, of which the IFT share is 0.4824 x $19.3m = $9.3m
I am -still- not guaranteeing that I have got my operational profit calculation right. But even with some more imagined future tweaks, I see no way to turn a $9.3m profit into a (0.4824x$201.9m=)$97.4m profit (the NPAT declared in AR2024 p80). That means the $97.4m that Infratil 'earned' from CDC must be largely (over 90%) from asset revaluations, based on what CDC 'expects to earn' when the current CDC datacentre construction program is complete.
(The actual operational NPAT is adjustable and determinable by the gearing of CDC, which will have been decided upon by Infratil and its ownership partners. It could easily become more profitable by having less debt in its underlying structure. But to avoid paying back some of Infratil's injected capital as a 'tax bill', Infratil have kept the interest bill high. This is what accountants call 'tax efficiency'.)
SNOOPY