Spreadsheet: vkaminski__40914__LJM Simulation1
Sheet: Input and Calc

The following are the inputs to the programs (in the order of enumeration in the sheet "Assumptions and Methodology")
Swap Portfolio Strike Value
 | ENE | PUBR1 | PRIVR1 | Hanover | BRASR2 | NPW |  |  |  |  | WhiteWing Assets and Liabilities |  |  | Years from t = 0
 |  |  |  |  |  |  |  |  |  |  | # of ENE on WW |  | 50000000
Price | 81 |  |  | 0 |  | 10 |  |  |  |  | Debt on WW |  | 2500000000
Drift |  |  | 0.1 | 0.1 |  |  |  |  |  |  | Closure Date | 2003-02-15 00:00:00
Dividend Yield | 0 | 0 | 0 |  | 0 | 0
Portfolio Value |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Years | Maximum
Volatility | 0.4213965682822496 | 0.4778401600472146 | 0.4778401600472146 | 0 | 0.6861269714685546 | 1 |  |  |  |  |  | Closing | Shares | since the | LMJ | Notes
Portfolio Strike Price |  |  |  |  |  |  |  |  |  |  | Raptor Charactieristics | Date | from WW | [NAME] | Payoff | Due
 |  |  |  |  |  |  |  |  |  |  | Raptor1 | 2003-04-18 00:00:00 | 3876755 |  | 36000000 | 350000000
Riskless Rate | 0.05 |  |  |  |  |  |  |  |  |  | Raptor2 | 2003-06-29 00:00:00 | 7809790 |  | 31100000 | 375000000
 |  |  |  |  |  |  |  |  |  |  | Raptor3 | 2003-07-31 00:00:00 | 0 |  | 30000000 | 40000000
Correlation Matrix |  |  |  |  |  |  |  |  |  |  | Raptor4 | 2003-08-31 00:00:00 | 6326045 |  | 30000000 | 350000000
ENE | 1
PUBR1 | 0.06213353778015577 | 1 |  |  |  |  |  |  |  |  | Today's Date
PRIVR1 | 0.2579753163382474 | 0.1553263343867703 | 1 |  |  |  |  |  |  |  | Divisor | 365
Hanover | 0 | 0 | 0 | 1
BRASR2 | 0.0633452584293176 | 0.0153258106338016 | 0.2432201670399814 | 0 | 1 |  |  |  |  |  | ENE Price Points for the pay-off of each Raptor from the Waterfall
TNPC | 0.2198619587642717 | 0.283576465840696 | 0.2654714946679398 | 0 | 0.2006314470259266 | 1 |  |  |  |  | Beg. of R1 payout
 |  |  |  |  |  |  |  |  |  |  | Beg. of R2 payout
Cholesky Factorization |  |  |  |  |  |  |  |  |  |  | Beg. of R4 payout
 |  |  |  |  |  |  |  |  |  |  | Complete R4 payout
 |  |  |  |  |  |  |  |  |  |  | ENE Shares
 |  |  |  |  |  |  |  |  |  |  | Raptor 1 | 3739175
Discount Rate (Risky) | 0.12
[NAME] choice (risky = 0) | 1 |  |  |  |  |  |  |  |  |  | TNPC Shares
Compounding Rate choice (risky = 0) | 0 |  |  |  |  |  |  |  |  |  | Raptor 3 | 24117800
Random Shock Main (to WW) | -0.8087399202531632 | -0.6820692852663628 | 1.70948815265191 | -0.3134303578272773 | 0.2149509500905561 | 0.1006964967301661 |  |  |  |  | No. of NPW in TRS | 19000000 | at | 21 | per share
Random Shock 1 (to R1) | -0.2364510358390696 | 0.9856344037873348 | -0.6991280087019812 | 1.627420564728461 | 1.320991710523046 | 0.1257937365669427 |  |  |  |  | Merlin Put(Raptor 1)
Random Shock 2 (to R2) | -0.00601262285869022 | 0.4132861840546053 | -3.017614612754391 | 0.06243148022585045 | 1.774216474425383 | -0.08404715231658348 |  |  |  |  | Units | 0
Random Shock 3 (to R3) | 0.968669094680199 | 0.6131645668414124 | -1.329845321200131 | 0.4207428972316881 | -1.132411600814761 | -0.7916190524036486 |  |  |  |  | Strike Price | 0
Random Shock 4 (to R4) | -0.3760667639410232 | 1.09926582562061 | -1.150655879232594 | 0.2704306560434999 | 0.5956545414549022 | -0.9033224172569676 |  |  |  |  | Collars |  | Units equal shares held and maximum from Waterfall
Correlated Random Shock (Main) |  |  |  |  |  |  |  |  |  |  | Raptor 1 Call Price | 116
Correlated Random Shock 1 (to R1) |  |  |  |  |  |  |  |  |  |  | Raptor 1 Put Price | 81
Correlated Random Shock 2 (to R2) |  |  |  |  |  |  |  |  |  |  | Raptor 2 Call Price | 111.8633 | Raptor 4 Call Price | 1000000000
Correlated Random Shock 3 (to R3) |  |  |  |  |  |  |  |  |  |  | Raptor 2 Put Price | 78.875 | Raptor 4 Put Price | 0
Correlated Random Shock 4 (to R4)
Compunding Rate Chosen
Discount Rate Chosen |  |  |  |  |  |  |  |  |  |  | Waterfall Structure |  | Number of Shares | Residual
 |  |  |  |  |  |  |  |  |  |  |  |  | Paid | after paying
 |  |  |  |  |  |  |  |  |  |  | WhiteWing
 |  |  |  |  |  |  |  |  | Interim Period
 | ENE Stock Price | PUBR1 | PRIVR1 | Hanover | BRASR2 | NPW Stock Price |  | Closing Date | (Years) |  | Raptor 1
Asset Values (Today) |  |  |  |  |  |  |  |  |  |  | Raptor 2
Asset Values at the close of WW |  |  |  |  |  |  |  |  |  |  | Raptor 3
Asset Values at the close of Raptor 1 |  |  |  |  |  |  |  |  |  |  | Raptor 4
Asset Values at the close of Raptor 2
Asset Values at the close of Raptor 3
Asset Values at the close of Raptor 4 |  |  |  |  |  |  |  |  |  |  | Carryforward rate | 0.07
 |  |  |  |  |  |  |  |  |  |  | for Raptor Gains/Losses
Raptor 1 Closing Value
Value of ENE Stocks (Held+Waterfall) |  |  |  |  |  |  |  |  |  |  | Drift Term Calculation:
Collar Gains/Losses
Public Swap Gains/Losses |  |  |  |  |  |  |  |  |  |  | Rm = | 0.16
Private Swap Gains/Losses |  |  |  |  |  |  |  |  |  |  | Rf = | 0.06
Merlin
Note Resolution |  |  |  |  |  |  |  |  |  |  | Asset | beta | drift
Assets minus Liabilities |  |  |  |  |  |  |  |  |  |  | ENE | 0.53
LJM's Payoff (R1) |  |  | PV |  |  |  |  |  |  |  | NPW | 1.68
 |  |  |  |  |  |  |  |  |  |  | BRAZIL | 0.81
Raptor [NAME] |  |  |  |  |  |  |  |  |  |  | pubr1 | 0.36
Value of ENE Stocks (Waterfall)
Collar Gains/Losses
Brazilian Swap Gains/Losses |  |  |  |  |  |  |  |  |  |  | Hawaii Structure
[NAME] |  |  |  |  |  |  |  |  |  |  | Maturity Date |  |  |  | Value at | float minus
Note Resolution |  |  |  |  |  |  |  |  |  |  |  | NPW Shares | Debt | Equity | 21 | fixed
 |  |  |  |  |  |  |  |  |  |  | Series A
Assets minus Liabilities |  |  |  |  |  |  |  |  |  |  | Series B/D
LJM's Payoff (R2) |  |  | PV |  |  |  |  |  |  |  | Series C
Raptor 3 Closing Value |  |  |  |  |  |  |  |  |  |  | Number of Shares | 19000000
TNPC Stocks |  |  |  |  |  |  |  |  |  |  | Future Value of Debt | 134767608.7644933 | 0.1
Note Resolution |  |  |  |  |  |  |  |  |  |  | Future Value of Equity | 6901586.51416667 | 0.15
TRS (Series A, B, C, and D)
Assets minus Liabilities |  |  |  |  |  |  |  |  |  |  | Fixed Payment |  | at price = | 21
LJM's Payoff (R3) |  |  | PV
Raptor [NAME]
Value of ENE Stocks (Waterfall)
Collar Gains/Losses
Note Resolution
Assets minus Liabilities
LJM's Payoff (R4) |  |  | PV
LJM's Payoff (w/o cross-guarantees)
CrossGuarantees (Two-sided for LJM)
Combined A/L Position - close of Raptor4 |  |  | << Simple sum
LJM's Cross-Guaranteed Payoff |  |  | PV
 | Are we compounding the payments for LJM as they are being paid later as a result of the cross-guarantees?
 | Early payoffs from cross-guarantees (not LJM's terminal payment)are being compunded at 7%.  Should we make it equal to risky or risk-free discount rate?
Sum of individual note shortfalls
Extracted Sum from LJM
LJM's CrossGuaranteed Payoff (One-sided)
ENE's payoff (under 1-sided cross-guarantee)