Spreadsheet: jeffrey_a_shankman__13926__WA5yr
Sheet: Quick and Dirty

 |  |  |  | WALLARAH - 5YR PLAN
 |  |  |  | COAL SALES AND REVENUE PLAN
 |  |  | 00/01 | 01/02 | 02/03 | 03/04 | 04/05 | 05/06 | 5 Yr
 |  | Year | Actual | Budget | Plan | Plan | Plan | Plan | Plan
 | [NAME] | Kt
 | Chain Valley Exports | Kt
 | [NAME] | Kt
 | Total Exports | Kt
 | [NAME] | Kt
 | Chain Valley Domestic | Kt
 | [NAME] | Kt |  | 0 | 0 | 0 | 0 | 0
 | Total Domestic | Kt
 | Total Sales | Kt
 |  | US$/t |  | 32 | 30 | 30 | 30 | 30
 | Export Coal Price | FX Rate |  | 0.5 | 0.55 | 0.6
 |  | A$/t
 | Domestic Coal Price | A$/Gj |  | 1.55
 |  | A$/t
 | Average Coal Price | A$/t
 | Export Revenue | A$000
 | Domestic Revenue | A$000
 | Total Revenue | A$000
 |  |  |  | PRODUCTION PLAN
 |  |  | 00/01 | 01/02 | 02/03 | 03/04 | 04/05 | 05/06 | 5 Yr
 |  | Year | Actual | Budget | Plan | Plan | Plan | Plan | Plan
 | Chain Valley Unit 1 | Kt ROM |  | 450 | 450 | 450 | 450 | 450
 | Chain Valley Unit 2 | Kt ROM |  | 0 | 450 | 450 | 450 | 450
 | Total Chain Valley | Kt ROM
 | [NAME] | Kt ROM |  | 0 | 400 | 400 | 400 | 400
 | Moonee | Kt ROM |  | 700 | 0 | 0 | 0 | 0
 | Total GNS Production | Kt ROM
 | Raw Coal to Vales Point | Kt ROM |  | 380 | 500 | 500 | 500 | 500
 | [NAME] | Kt ROM
 | Export Coal Yield | % |  | 0.8 | 0.92 | 0.92 | 0.92 | 0.92
 | BPF Yield | % |  | 0.15 | 0 | 0 | 0 | 0
 | Total Yield | %
 | Export Product | Kt
 | BPF Product | Kt
 | Total Product | Kt
 | Trucked to PWCS | Kt
 | Trucked to Chain Valley | Kt
 |  |  |  | UNIT COSTS OF PRODUCTION AND SALES
 |  |  | 00/01 | 01/02 | 02/03 | 03/04 | 04/05 | 05/06
 |  | Year | Actual | Budget | Plan | Plan | Plan | Plan
 | [NAME] | $/t ROM | 22
 | Chain [NAME] | $/t ROM | 25
 | [NAME] | $/t ROM | 25
 | Average Pit-Top Cost | $/t ROM
 | Chain Valley to Vales Point Cost | $/t ROM | 1
 | Chain Valley to CPP or Return | $/t ROM | 2.5
 | [NAME] to CPP Cost | $/t ROM | 1.5
 | CPP/Handling Cost | $/t ROM | 5
 | NSW Royalty | $/t Sales | 1.7
 | Truck to PWCS Cost | $/t Sales | 5.66
 | Port Costs | $/t Sales | 2.83
 |  |  |  | DOMESTIC PROFITABILITY
 | Cost of CV ROM Domestic Coal | $000
 | Cost of CV Washed Domestic Coal | $000 |  |  | 0 | 0 | 0 | 0
 | [NAME] to CPP | $000
 | CPP/Handling Costs | $000
 | [NAME] to Chain Valley | $000
 | Truck Chain Valley to Vales Point | $000
 | Royalty | $000
 | Overhead | $000 | 2000
 | Total Cost of Domestic Sales | $000
 | Domestic Sales Revenue | $000
 | Domestic PBITD | $000
 | Total Cost of Domestic Sales | $/t
 | Domestic Sales Revenue | $/t
 | Domestic PBITD | $/t
 |  |  |  | EXPORT PROFITABILITY
 |  |  | 00/01 | 01/02 | 02/03 | 03/04 | 04/05 | 05/06 | 5 Yr
 |  | Year | Actual | Budget | Plan | Plan | Plan | Plan | Plan
 | Moonee P-t-Top Cost | $000
 | Chain [NAME] | $000
 | [NAME] | $000
 | Total Pit-Top Cost | $000
 | Truck Chain Valley to CPP | $000
 | [NAME] to CPP | $000
 | CPP/Handling Costs | $000
 | Cost of Product Coal | $000
 | NSW Royalty | $000
 | Overhead | $000
 | Truck to PWCS Cost | $000
 | Port Costs | $000
 | Total FOB Cost of Export Coal | $000
 | Export Sales Revenue | $000
 | Export PBITD | $000
 | Total FOB Cost of Export Coal | $/t
 | Export Sales Revenue | $/t
 | Export PBITD | $/t
 |  |  |  | PROFIT SUMMARY
 | Domestic Coal PBITD | $000
 | Export Coal PBITD | $000
 | Total PBITD | $000
 | Depreciation/Amortisation | $000 |  | 0 | 0 | 0 | 0 | 0
 | PROFIT CONTRIBUTION | $000
 |  |  |  | CASHFLOW SUMMARY
 |  |  | 00/01 | 01/02 | 02/03 | 03/04 | 04/05 | 05/06 | 5 Yr
 |  | Year | Actual | Budget | Plan | Plan | Plan | Plan | Plan
 | PBITD | $000
 | Working Capital | $000 |  | -5000 | 0 | 0 | 0 | 0
 | Capital Expenditure | $000 |  | -2000 | -1500 | -1500 | -1500 | -1500
 | NET CASHFLOW | $000