fx equity spreadsheet

Guys I have updated my FX equity liability spreadsheet to include all asset sales since 31 Dec 08 and included a 'what if' analysis if the AUD goes to 85.

The spreadsheet takes into account the decrease in both assets and liabilities due to the higher AUD using 31 Dec 08 figures.

My previous spreadsheet only took into account the AUD going to 80.

The spreadsheet does not take into account the following factors:

- Increase in value in all other derivative positions (excluding FX equity which the spreadsheet takes into account)
- Operating profit for period (which would be used to pay down debt)
- Further possible writedowns in assets

The first two points will see an increase in NTA whereas the third point will see a decrease in NTA.

I may also do a sensitivity analysis incorporating the above variables.

If AUD is 81 at 30 June 2008 (which is around current figure), this will result in an increase around 8.5c in NTA before taking into account the three points mentioned above.

Anyway if you would like a copy please let me know

Cheers