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
- Forums
- ASX - By Stock
- CER
- detailed cer nta est as at 31 dec 09 - 38c
detailed cer nta est as at 31 dec 09 - 38c
-
- There are more pages in this discussion • 27 more messages in this thread...
You’re viewing a single post only. To view the entire thread just sign in or Join Now (FREE)
Featured News
Add CER (ASX) to my watchlist
Currently unlisted public company.
The Watchlist
FHE
FRONTIER ENERGY LIMITED
Adam Kiley, CEO
Adam Kiley
CEO
SPONSORED BY The Market Online