my revised nta calc arrives at 1.711, page-90

Hi guys,

Thought I'd bring up this old thread as it is relevant.

The Impairmant Charge now should be reversed.


Please refer to the 29 August results ann:

Should there be a default under the Super banking arrangements, ultimately the lenders

under the extension deed to Super, may seek to recover the amounts owing from any of

the properties within Super. In the event that Centro were unable to meet its obligations

in respect to Super, CER would be exposed to the extent of Centro’s negative equity in

Super, limited to CER’s equity investment in the joint venture. CER has not provided any

guarantees to the unsecured lenders of Super.

As at 30 June 2008, Centro’s negative equity was $317 million and CER has impaired its

investment in Super by this amount in recognition of this exposure.



Super LLC's future is now secure. There is no reason to believe now that SuperLLC will default under its banking agreements and as such CER will now not be liable for CNP's obligations with respect to Super.

As such, the US$300m that was written down should now be written back.

At 30 June 08, the US$300m was written down using an exchange rate of 0.96.

The US$300 will now be written back using an exchange rate of 0.6928. (Refer ot page 2 of today's ann)

In AUD terms, this equates to $433m

Therefore the accounting entry will be a writeback of A$314m + a further A$119m credit to either an asset revaluation reserve or a writeback of properties that were previously revised down. As there have already been subsyantial writedowns with respect of its US portfolio, the $119m should be written pack as profit. Refer to AASB 136 Impairment of assets.


Now, moving onto the hedges. This is sensational news. CER's ann today read as follows:

CER has historically hedged its interest rate and currency exposures with Centro and to a

lesser extent with external counterparties. As part of the arrangements to progressively

reduce CER’s counterparty risk and the interdependencies between the two organisations,

Centro and CER will terminate their interest rate swaps and forward currency contracts at no cost to CER.


The annual report showed that derivative assets were $407m and derivative liabilities were $68m. Net total $339m. Refer to note 21.

Of the $339m net derivative assets at 30 June 2008, agreements were CNP made up net derivative assets of $233m.

Agreements were external parties made up $106m.

Agreements with CNP as the counterparty make up 68.7% of total hedging agreements ($233m / $339m)

That means going by what was said in today's ann, CER will be able to terminate their interest rate swaps and forward currency contracts at zero cost to CER.

Now what was the total value of the interest rate swaps and forward currency contracts at 30 June 2008. Again referring to 30 June 2008 figures (note 21)

Net forward foreign exchange contracts - net investment hedges: $49

Net Interest rate swap agreements: $28m ($76.6m - $48.6m)

Net Forward foreign exchange contracts: $134.4m

Net total: $211m

Net total of $162m x 68.7% = $145m

Cross curreny exchange contracts do not seem to be included in the termination of the hedging contracts with CNP.

The $145m is the figure that will be automatically written down from the net derivative asset figure of $339m.

Now the difficult part is working out the writedown.

Page 36 of the annual report is a sensitivity analysis. It shows what the writedown would be if the exchange rates increases or decreases by 10%.

Of the net carrying amount of its derivative assets at 30 June 2008 in the amount of $339m, a 10% decrease in the exchange rate will decrease the value of the assets by $353m

An exchange rate of 0.96 was used at 30 June 2008 to value assets and liabilities.

Now as calculated before, approximately a net figure of $145m will automatically be written down and any derivative assets associated with that $145m can not be written down further.

So of the $339m of derivative assets at 30 June 2008, only derivative assets in the amount of $194m ($339m - $145m) are subject to be written down to zero and beyond. This means that a net liability derivative position can be shown in the accounts.

Now going back to the sensitivity analysis, a 10% decrease in the exchange rate will decrease the derivative assets by $246m ($353m x 0.697)

How much has the exchange rate weakended from 30 June 2008 to 31 Dec 08:

0.96

10% decrease = AUD/USD 0.864 = $246m decrease

10% decrease from 0.864 = AUD/USD 0.778 = total $492m decrease ($246 + $246)

10% decrease from 0.778 = AUD/USD 0.699 = total $738m decrease ($246 + $246 + $246)

The writedown in derivative assets would equal:

$145m (automatic writedown)

+ $738m

= $883m

I believe we should see a writedown of $883m in derivative assets at 31 Dec 08. Total writedown in cents per shares is $883m / 2.3b = 38.4c

The $145m is not subject to further writedowns as CER does not need to incur any additional costs to close out those contracts.

In my initial calculation I had a derivative contracts writedown of 15.4c. This should now be increased to 38.4c. That's a further 23c writedown.

The only other change I would make to the calculation would be a decrease in its Aust portfolio by 5%, which equates to $100m or 4.3c per share.

So instead of having NTA of $1.71 per share, it would now be ($1.71 -23c - 4.3c) = $1.43 per share



Anyways any comments people?

Cheers