Spreadsheet: stacey_white__38769__0709  Alcoa Model
Sheet: Alcoa

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Average Contract Price |  |  |  |  | Average Sales Price |  |  |  |  |  |  |  |  |  |  | Pis/Cofins Tax (on Revenue Only) |  |  |  |  |  | CPMF (on Operating Expense Only) |  |  |  |  |  |  | IOF
 |  |  |  |  |  |  |  |  |  |  |  | YEARLY NOTIONAL MWH's |  |  | YEARLY NOTIONAL MWH's |  |  | YEARLY NOTIONAL MWH's |  |  |  |  | YEARLY PV'd MWH's |  | YEARLY PV'd MWH's |  |  | Contract | Total |  |  |  | Contract | Total |  |  |  | Gross Margin |  |  | Total Costs |  |  |  | Not. Volume | Est. Revenue | Amount | Amount |  | Purh. Price | T&D | ANEEL/PisCofins | Operating Cost | Amount | Amount |  | Mwh Base |  | Amount | Amount |  | Total Taxes |  |  | Total Alcoa Value |  |  | Total Alcoa Value
 |  |  |  |  |  |  |  |  |  |  |  | Total |  |  | Total |  |  | Total |  |  |  |  | Total |  | Total |  |  | Price | Not. Volume | Amount | Amount |  | Price | Not. Volume | Amount | Amount |  | Amount | MTM Value |  | Amount | MTM Value |  |  |  | (Notional) | Notional | (PV'd) |  | (Notional) | (Notional) | (Notional) | (Notional) | Notional | (PV'd) |  |  |  | Notional | (PV'd) |  | Amount | MTM Value |  | Amount | MTM Value |  | Amount | MTM Value
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (Notional) | (PV'd) |  |  |  | (Notional) | (PV'd)
 |  |  |  |  |  |  |  |  |  |  | Check
 | 2000
 | 2001
 | 2002
 | Fwd Start Date: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NOT APPLICABLE  -  on purchase transaction
 |  |  |  |  |  |  |  |  |  |  | Notional Mwh (Contracted) |  |  | Notional Mwh (Purchase) |  |  | Notional Mwh (Sales) |  |  |  |  |  | PV'd Mwh (Purchase) |  | PV'd Mwh (Sale) |  |  | Purchase |  |  |  |  | Sale |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CPMF (on Operating Expense Only)
 |  |  | 1 = Unrealized |  |  | # of Days | # of | Firm |  |  |  | Monthly |  |  | Monthly |  |  | Monthly |  |  | Discount |  | Monthly |  | Monthly |  |  | Contract | Total |  |  |  | Curve | Total |  |  |  | Gross Margin |  |  | Total Costs |  |  | Pis/Cofins Tax (on Revenue Only) |  |  |  |  |  | Purchase |  |  | Estimated |  |  |  | IOF Tax on Financial Transaction |  |  |  |  | Total Taxes |  |  | Total Alcoa Value |  |  | Total Alcoa Value
 | From | To | 0 = Realized | Year | Year | in Month | Flow Days | Mwh | Hours/Day |  | Daily | Total |  | Daily | Total |  | Daily | Total |  | BRZ IR | Factor |  | Total |  | Total |  |  | Price | Not. Volume | Amount | Amount |  | Price | Not. Volume | Amount | Amount |  | Amount | MTM Value |  | Amount | MTM Value |  | Contract | Not. Volume | Est. Revenue | Tax | Tax |  | Price |  |  | Operating Cost | Tax | Tax |  | Base |  | Tax | Tax |  | Amount | MTM Value |  | Amount | MTM Value |  | Amount | MTM Value
 |  |  |  |  |  |  |  |  |  |  | 1 |  |  | 1 |  |  | 1 |  |  |  |  |  | 1 |  |  |  |  | 280 | 1 | (Notional) | (PV'd) |  |  | 1 | (Notional) | (PV'd) |  | (Notional) | (PV'd) |  | (Notional) | (PV'd) |  | Price |  | (Notional) | 0.0365 | (PV'd) |  | (Notional) | (Notional) | (Notional) | (Notional) | 0.0038 | (PV'd) |  |  |  | 0 | (PV'd) |  | (Notional) | (PV'd) |  | (Notional) | (PV'd) |  | (Notional) | (PV'd)
2001 |  |  |  |  |  |  |  | 20 | 24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  | 0
 |  |  |  |  |  |  |  | 25 | 24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  | 0
 |  |  |  |  |  |  |  | 25 | 24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  | 0
 |  |  |  |  |  |  |  | 25 | 24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  | 0
 |  |  |  |  |  |  |  | 25 | 24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  | 0
 |  |  |  |  |  |  |  | 25 | 24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 | 0 |  |  |  |  | 0