Spreadsheet: vkaminski__40739__syntheticStorage
Sheet: PriceMod

 |  | NG Storage Valuation Model
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | Factor of Loadings
 | Valuation Date | 2000-02-24 00:00:00 |  | Contact: |  |  |  |  |  |  |  | No. Month Out | Contract | NYMEX | Forward Price | NYMEX Vol | [NAME] | Season Sprd | [NAME] | Level | Steepness | Curvature
 | Price [NAME] |  |  | [NAME] |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 0.017843 | -0.01016 | 0.003935
 | Basis Location | NGI/CHI. GATE |  | x36388 |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  | 0.016071 | -0.00612 | -0.00081
 |  |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  | 0.015355 | -0.00295 | -0.00215
 |  |  |  |  |  |  |  |  |  |  |  | 4 |  |  |  |  |  |  |  | 0.010145 | -0.00042 | -0.00194
 |  |  |  |  |  | CurvePts |  |  |  |  |  | 5 |  |  |  |  |  |  |  | 0.01174 | 0.001002 | -0.00246
 |  |  |  | Injection / Withdraw Curve |  | 2 |  | Simulation Inputs |  |  |  | 6 |  |  |  |  |  |  |  | 0.011762 | 0.00226 | -0.00228
 |  |  |  |  |  |  |  |  |  |  |  | 7 |  |  |  |  |  |  |  | 0.009151 | 0.002538 | -0.00129
 | Financial / Opeartion Inputs |  |  | W Gas | Injection Rate | Withdraw Rate |  | nRun | 2000 |  |  | 8 |  |  |  |  |  |  |  | 0.010314 | 0.003397 | -0.00093
 |  |  |  | 0 | 0.02 | 0.02 |  | Tsteps/Month | 30 |  |  | 9 |  |  |  |  |  |  |  | 0.010773 | 0.004021 | -0.00022
 |  |  |  | 1 | 0.02 | 0.02 |  | Vol Scale | 0.6 |  |  | 10 |  |  |  |  |  |  |  | 0.010012 | 0.00422 | 0.000332
 | to StartMonth | 0 |  | 2 | 0.2 | 0.4 |  | No. Factors | 3 |  |  | 11 |  |  |  |  |  |  |  | 0.007353 | 0.003395 | 0.000691
 | No. of Months | 11 |  | 3 | 0.2 | 0.4 |  | [NAME] | 50 |  |  | 12 |  |  |  |  |  |  |  | 0.00622 | 0.002998 | 0.000963
 | Spot Price | 2.59 |  | 4 | 0.2 | 0.4 |  | 2nd [NAME] | 3 |  |  | 13 |  |  |  |  |  |  |  | 0.007667 | 0.003692 | 0.001289
 | Interest Rate | 0.1 |  | 4 | 0.2 | 0.4 |  | DLL | H:\1ziminlu\1zimin\storage\investOpt\sytheticStorage\debug\sytheticStorage.dll |  |  | 14 |  |  |  |  |  |  |  | 0.003793 | 0.001835 | 0.000704
 | Starting Volume | 0 |  | 4 | 0.2 | 0.4 |  | Module | StorageVal |  |  | 15 |  |  |  |  |  |  |  | 0.001707 | 0.000877 | 0.000341
 | Penalty | 5 |  |  |  |  |  | Format | BJJJJJjKKBKKKKBJBBBBbbbjjjkkk! |  |  | 16 |  |  |  |  |  |  |  | 0.001689 | 0.000885 | 0.000372
 | Injection Fee | 0 |  |  |  |  |  | toEndInj | 3 |  |  | 17 |  |  |  |  |  |  |  | 0.001667 | 0.000888 | 0.000431
 | Withdraw Fee | 0 |  |  |  |  |  | toStartW | 10 |  |  | 18 |  |  |  |  |  |  |  | 0.003267 | 0.001778 | 0.000874 |  |  |  |  |  |  |  |  |  |  | True
 | Injection Fee Esc | 0 |  |  |  |  |  |  |  |  |  | 19 |  |  |  |  |  |  |  | 0.003282 | 0.00177 | 0.000892 |  |  |  |  |  |  |  |  |  |  | True
 | Withdraw Fee Esc | 0 |  |  |  |  |  |  |  |  |  | 20 |  |  |  |  |  |  |  | 0.003296 | 0.001762 | 0.000911
 |  |  |  |  |  |  |  |  |  |  |  | 21 |  |  |  |  |  |  |  | 0.003311 | 0.001754 | 0.000929
 |  |  |  |  |  |  |  |  |  |  |  | 22 |  |  |  |  |  |  |  | 0.003326 | 0.001746 | 0.000948
 | Unit Storage Price | 0.5134163181235727 |  |  |  |  |  |  |  |  |  | 23 |  |  |  |  |  |  |  | 0.003341 | 0.001739 | 0.000966
 |  |  |  |  |  |  |  |  |  |  |  | 24 |  |  |  |  |  |  |  | 0.003356 | 0.001731 | 0.000984
 | Monthly Storage Value |  |  |  |  |  |  |  |  |  |  | 25 |  |  |  |  |  |  |  | 0.003318 | 0.001759 | 0.001015
 |  |  |  |  |  |  |  |  |  |  |  | 26 |  |  |  |  |  |  |  | 0.00328 | 0.001788 | 0.001045
 |  |  |  |  |  |  |  |  |  |  |  | 27 |  |  |  |  |  |  |  | 0.003243 | 0.001817 | 0.001075
 |  |  |  |  |  |  |  |  |  |  |  | 28 |  |  |  |  |  |  |  | 0.003205 | 0.001845 | 0.001105
 |  |  |  |  |  |  |  |  |  |  |  | 29 |  |  |  |  |  |  |  | 0.003167 | 0.001874 | 0.001135
 |  |  |  |  |  |  |  |  |  |  |  | 30 |  |  |  |  |  |  |  | 0.003129 | 0.001902 | 0.001166 |  |  | Seasonality Table
 |  |  |  |  |  |  |  |  |  |  |  | 31 |  |  |  |  |  |  |  | 0.003114 | 0.001873 | 0.001163 |  |  | Month | [NAME] | Correl
 |  |  |  |  |  |  |  |  |  |  |  | 32 |  |  |  |  |  |  |  | 0.003098 | 0.001844 | 0.001161 |  |  | 1 | 0.02 | 0.7
 |  |  |  |  |  |  |  |  |  |  |  | 33 |  |  |  |  |  |  |  | 0.003082 | 0.001815 | 0.001159 |  |  | 2 | 0.02 | 0.7
 |  |  |  |  |  |  |  |  |  |  |  | 34 |  |  |  |  |  |  |  | 0.003066 | 0.001785 | 0.001157 |  |  | 3 | 0.02 | 0.75
 |  |  |  |  |  |  |  |  |  |  |  | 35 |  |  |  |  |  |  |  | 0.003051 | 0.001756 | 0.001155 |  |  | 4 | 0 | 0.85
 |  |  |  |  |  |  |  |  |  |  |  | 36 |  |  |  |  |  |  |  | 0.003035 | 0.001727 | 0.001153 |  |  | 5 | -0.01 | 0.85
 |  |  |  |  |  |  |  |  |  |  |  | 37 |  |  |  |  |  |  |  | 0.002943 | 0.001712 | 0.001161 |  |  | 6 | -0.01 | 0.85
 |  |  |  |  |  |  |  |  |  |  |  | 38 |  |  |  |  |  |  |  | 0.00285 | 0.001697 | 0.00117 |  |  | 7 | -0.01 | 0.85
 |  |  |  |  |  |  |  |  |  |  |  | 39 |  |  |  |  |  |  |  | 0.002758 | 0.001682 | 0.001178 |  |  | 8 | -0.01 | 0.85
 |  |  |  |  |  |  |  |  |  |  |  | 40 |  |  |  |  |  |  |  | 0.002666 | 0.001667 | 0.001186 |  |  | 9 | -0.01 | 0.85
 |  |  |  |  |  |  |  |  |  |  |  | 41 |  |  |  |  |  |  |  | 0.002574 | 0.001652 | 0.001194 |  |  | 10 | 0 | 0.85
 |  |  |  |  |  |  |  |  |  |  |  | 42 |  |  |  |  |  |  |  | 0.002482 | 0.001637 | 0.001202 |  |  | 11 | 0.02 | 0.7
 |  |  |  |  |  |  |  |  |  |  |  | 43 |  |  |  |  |  |  |  | 0.00243 | 0.001582 | 0.001165 |  |  | 12 | 0.02 | 0.7
 |  |  |  |  |  |  |  |  |  |  |  | 44 |  |  |  |  |  |  |  | 0.002378 | 0.001528 | 0.001129
 |  |  |  |  |  |  |  |  |  |  |  | 45 |  |  |  |  |  |  |  | 0.002326 | 0.001473 | 0.001093
 |  |  |  |  |  |  |  |  |  |  |  | 46 |  |  |  |  |  |  |  | 0.002274 | 0.001419 | 0.001056
 |  |  |  |  |  |  |  |  |  |  |  | 47 |  |  |  |  |  |  |  | 0.002222 | 0.001364 | 0.00102
 |  |  |  |  |  |  |  |  |  |  |  | 48 |  |  |  |  |  |  |  | 0.00217 | 0.00131 | 0.000983
 |  |  |  |  |  |  |  |  |  |  |  | 49 |  |  |  |  |  |  |  | 0.002636 | 0.001669 | 0.001291
 |  |  |  |  |  |  |  |  |  |  |  | 50 |  |  |  |  |  |  |  | 0.003102 | 0.002028 | 0.001598
 |  |  |  |  |  |  |  |  |  |  |  | 51 |  |  |  |  |  |  |  | 0.003568 | 0.002388 | 0.001905
 |  |  |  |  |  |  |  |  |  |  |  | 52 |  |  |  |  |  |  |  | 0.004034 | 0.002747 | 0.002213
 |  |  |  |  |  |  |  |  |  |  |  | 53 |  |  |  |  |  |  |  | 0.0045 | 0.003106 | 0.00252
 |  |  |  |  |  |  |  |  |  |  |  | 54 |  |  |  |  |  |  |  | 0.004966 | 0.003466 | 0.002827
 |  |  |  |  |  |  |  |  |  |  |  | 55 |  |  |  |  |  |  |  | 0.004998 | 0.00343 | 0.002796
 |  |  |  |  |  |  |  |  |  |  |  | 56 |  |  |  |  |  |  |  | 0.00503 | 0.003395 | 0.002765
 |  |  |  |  |  |  |  |  |  |  |  | 57 |  |  |  |  |  |  |  | 0.005062 | 0.00336 | 0.002734
 |  |  |  |  |  |  |  |  |  |  |  | 58 |  |  |  |  |  |  |  | 0.005094 | 0.003325 | 0.002703
 |  |  |  |  |  |  |  |  |  |  |  | 59 |  |  |  |  |  |  |  | 0.005126 | 0.003289 | 0.002672
 |  |  |  |  |  |  |  |  |  |  |  | 60 |  |  |  |  |  |  |  | 0.005159 | 0.003254 | 0.002641
 |  |  |  |  |  |  |  |  |  |  |  | 61 |  |  |  |  |  |  |  | 0.005159 | 0.003254 | 0.002641
 |  |  |  |  |  |  |  |  |  |  |  | 62 |  |  |  |  |  |  |  | 0.005159 | 0.003254 | 0.002641
 |  |  |  |  |  |  |  |  |  |  |  | 63 |  |  |  |  |  |  |  | 0.005159 | 0.003254 | 0.002641
 |  |  |  |  |  |  |  |  |  |  |  | 64 |  |  |  |  |  |  |  | 0.005159 | 0.003254 | 0.002641
 |  |  |  |  |  |  |  |  |  |  |  | 65 |  |  |  |  |  |  |  | 0.005159 | 0.003254 | 0.002641
 |  |  |  |  |  |  |  |  |  |  |  | 66 |  |  |  |  |  |  |  | 0.005159 | 0.003254 | 0.002641
 |  |  |  |  |  |  |  |  |  |  |  | 67 |  |  |  |  |  |  |  | 0.005159 | 0.003254 | 0.002641
 |  |  |  |  |  |  |  |  |  |  |  | 68 |  |  |  |  |  |  |  | 0.005159 | 0.003254 | 0.002641
 |  |  |  |  |  |  |  |  |  |  |  | 69 |  |  |  |  |  |  |  | 0.005159 | 0.003254 | 0.002641
 |  |  |  |  |  |  |  |  |  |  |  | 70 |  |  |  |  |  |  |  | 0.005159 | 0.003254 | 0.002641
 |  |  |  |  |  |  |  |  |  |  |  | 71 |  |  |  |  |  |  |  | 0.005159 | 0.003254 | 0.002641
 |  |  |  |  |  |  |  |  |  |  |  | 72 |  |  |  |  |  |  |  | 0.005159 | 0.003254 | 0.002641
 |  |  |  |  |  |  |  |  |  |  |  | 73 |  |  |  |  |  |  |  | 0.005159 | 0.003254 | 0.002641
 |  |  |  |  |  |  |  |  |  |  |  | 74 |  |  |  |  |  |  |  | 0.005159 | 0.003254 | 0.002641
 |  |  |  |  |  |  |  |  |  |  |  | 75 |  |  |  |  |  |  |  | 0.005159 | 0.003254 | 0.002641
 |  |  |  |  |  |  |  |  |  |  |  | 76 |  |  |  |  |  |  |  | 0.005159 | 0.003254 | 0.002641
 |  |  |  |  |  |  |  |  |  |  |  | 77 |  |  |  |  |  |  |  | 0.005159 | 0.003254 | 0.002641
 |  |  |  |  |  |  |  |  |  |  |  | 78 |  |  |  |  |  |  |  | 0.005159 | 0.003254 | 0.002641
 |  |  |  |  |  |  |  |  |  |  |  | 79 |  |  |  |  |  |  |  | 0.005159 | 0.003254 | 0.002641
 |  |  |  |  |  |  |  |  |  |  |  | 80 |  |  |  |  |  |  |  | 0.005159 | 0.003254 | 0.002641
 |  |  |  |  |  |  |  |  |  |  |  | 81 |  |  |  |  |  |  |  | 0.005159 | 0.003254 | 0.002641
 |  |  |  |  |  |  |  |  |  |  |  | 82 |  |  |  |  |  |  |  | 0.005159 | 0.003254 | 0.002641
 |  |  |  |  |  |  |  |  |  |  |  | 83 |  |  |  |  |  |  |  | 0.005159 | 0.003254 | 0.002641
 |  |  |  |  |  |  |  |  |  |  |  | 84 |  |  |  |  |  |  |  | 0.005159 | 0.003254 | 0.002641
 |  |  |  |  |  |  |  |  |  |  |  | 85 |  |  |  |  |  |  |  | 0.005159 | 0.003254 | 0.002641
 |  |  |  |  |  |  |  |  |  |  |  | 86 |  |  |  |  |  |  |  | 0.005159 | 0.003254 | 0.002641
 |  |  |  |  |  |  |  |  |  |  |  | 87 |  |  |  |  |  |  |  | 0.005159 | 0.003254 | 0.002641
 |  |  |  |  |  |  |  |  |  |  |  | 88 |  |  |  |  |  |  |  | 0.005159 | 0.003254 | 0.002641
 |  |  |  |  |  |  |  |  |  |  |  | 89 |  |  |  |  |  |  |  | 0.005159 | 0.003254 | 0.002641
 |  |  |  |  |  |  |  |  |  |  |  | 90 |  |  |  |  |  |  |  | 0.005159 | 0.003254 | 0.002641
 |  |  |  |  |  |  |  |  |  |  |  | 91 |  |  |  |  |  |  |  | 0.005159 | 0.003254 | 0.002641
 |  |  |  |  |  |  |  |  |  |  |  | 92 |  |  |  |  |  |  |  | 0.005159 | 0.003254 | 0.002641
 |  |  |  |  |  |  |  |  |  |  |  | 93 |  |  |  |  |  |  |  | 0.005159 | 0.003254 | 0.002641
 |  |  |  |  |  |  |  |  |  |  |  | 94 |  |  |  |  |  |  |  | 0.005159 | 0.003254 | 0.002641
 |  |  |  |  |  |  |  |  |  |  |  | 95 |  |  |  |  |  |  |  | 0.005159 | 0.003254 | 0.002641
 |  |  |  |  |  |  |  |  |  |  |  | 96 |  |  |  |  |  |  |  | 0.005159 | 0.003254 | 0.002641
 |  |  |  |  |  |  |  |  |  |  |  | 97 |  |  |  |  |  |  |  | 0.005159 | 0.003254 | 0.002641
 |  |  |  |  |  |  |  |  |  |  |  | 98 |  |  |  |  |  |  |  | 0.005159 | 0.003254 | 0.002641
 |  |  |  |  |  |  |  |  |  |  |  | 99 |  |  |  |  |  |  |  | 0.005159 | 0.003254 | 0.002641
 |  |  |  |  |  |  |  |  |  |  |  | 100 |  |  |  |  |  |  |  | 0.005159 | 0.003254 | 0.002641
 |  |  |  |  |  |  |  |  |  |  |  | 101 |  |  |  |  |  |  |  | 0.005159 | 0.003254 | 0.002641
 |  |  |  |  |  |  |  |  |  |  |  | 102 |  |  |  |  |  |  |  | 0.005159 | 0.003254 | 0.002641
 |  |  |  |  |  |  |  |  |  |  |  | 103 |  |  |  |  |  |  |  | 0.005159 | 0.003254 | 0.002641
 |  |  |  |  |  |  |  |  |  |  |  | 104 |  |  |  |  |  |  |  | 0.005159 | 0.003254 | 0.002641
 |  |  |  |  |  |  |  |  |  |  |  | 105 |  |  |  |  |  |  |  | 0.005159 | 0.003254 | 0.002641
 |  |  |  |  |  |  |  |  |  |  |  | 106 |  |  |  |  |  |  |  | 0.005159 | 0.003254 | 0.002641
 |  |  |  |  |  |  |  |  |  |  |  | 107 |  |  |  |  |  |  |  | 0.005159 | 0.003254 | 0.002641
 |  |  |  |  |  |  |  |  |  |  |  | 108 |  |  |  |  |  |  |  | 0.005159 | 0.003254 | 0.002641
 |  |  |  |  |  |  |  |  |  |  |  | 109 |  |  |  |  |  |  |  | 0.005159 | 0.003254 | 0.002641
 |  |  |  |  |  |  |  |  |  |  |  | 110 |  |  |  |  |  |  |  | 0.005159 | 0.003254 | 0.002641
 |  |  |  |  |  |  |  |  |  |  |  | 111 |  |  |  |  |  |  |  | 0.005159 | 0.003254 | 0.002641
 |  |  |  |  |  |  |  |  |  |  |  | 112 |  |  |  |  |  |  |  | 0.005159 | 0.003254 | 0.002641
 |  |  |  |  |  |  |  |  |  |  |  | 113 |  |  |  |  |  |  |  | 0.005159 | 0.003254 | 0.002641
 |  |  |  |  |  |  |  |  |  |  |  | 114 |  |  |  |  |  |  |  | 0.005159 | 0.003254 | 0.002641
 |  |  |  |  |  |  |  |  |  |  |  | 115 |  |  |  |  |  |  |  | 0.005159 | 0.003254 | 0.002641
 |  |  |  |  |  |  |  |  |  |  |  | 116 |  |  |  |  |  |  |  | 0.005159 | 0.003254 | 0.002641
 |  |  |  |  |  |  |  |  |  |  |  | 117 |  |  |  |  |  |  |  | 0.005159 | 0.003254 | 0.002641
 |  |  |  |  |  |  |  |  |  |  |  | 118 |  |  |  |  |  |  |  | 0.005159 | 0.003254 | 0.002641
 |  |  |  |  |  |  |  |  |  |  |  | 119 |  |  |  |  |  |  |  | 0.005159 | 0.003254 | 0.002641
 |  |  |  |  |  |  |  |  |  |  |  | 120 |  |  |  |  |  |  |  | 0.005159 | 0.003254 | 0.002641