CER 0.00% 32.0¢ centro retail group

detailed cer nta est as at 31 dec 09 - 38c

  1. 5,714 Posts.
    lightbulb Created with Sketch. 1761


    Hey all

    Happy New Year!

    Ive just completed my most comprehensive, most complete and most conservative NTA analysis for the period ending 31 Dec 09.

    There are total of 7 worksheets in my spreadsheet with particular emphasis on the following:

    - How US assets and liabilities exclusing SuperLLC are affected by the increase of the AUD from 80.64 to 89.69 as at 31 December 2009

    - How asset sales affect the NTA, discounting the proceeds received from the 3 asset sales within SuperLLC

    - Reduction in size of Australian debt facilities

    - Equity Hedges writeup with detailed commentary

    - Estimated writeup in Interest Rate Swaps

    - Commentary of Australian Portfolio performance with sensitivity analysis. Estimated no change in value of portfolio. Explained in detail in spreadsheet

    - Commentary of US Portfolio performance with sensitivity analysis. Estimated a writedown in US assets of 5%. Explained in detail in spreadsheet

    - Detailed NTA calculation


    I believe my estimate of 38c is fairly conservative.

    Quixis if you could please place my spreadsheet online thatd be great mate

    Id be happy to email my spreadsheet to those who request it in the meantime

    Once again happy new year all.

    CER will prosper in 2010 but more importantly stay safe and enjoy life!

    Please let me know if you have any queries

    Cheers


 
watchlist Created with Sketch. Add CER (ASX) to my watchlist

Currently unlisted public company.

arrow-down-2 Created with Sketch. arrow-down-2 Created with Sketch.