CER centro retail group

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

  1. 5,874 Posts.
    lightbulb Created with Sketch. 1801


    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


 
Add to My Watchlist
What is My Watchlist?
A personalised tool to help users track selected stocks. Delivering real-time notifications on price updates, announcements, and performance stats on each to help make informed investment decisions.

Currently unlisted public company.

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