Spreadsheet: benjamin_rogers__1205__Retail Shorts version Debt-Equity 60-40 version2-Jin
Sheet: Scenarios

 | Maximizing DSCR Scenario:
 | [NAME] (kW) |  | Energy Price |  | Correlation |  | Return |  | Curve Shift |  | Debt |  | Equity
 | 250 |  | 43.55 |  | 0.7 |  | 0.14 |  | 0 |  | 0.7 |  | 0.3
 | 200 |  | 44.18 |  | 0.7 |  | 0.14 |  | 0 |  | 0.73 |  | 0.27
 | 150 |  | 44.82 |  | 0.7 |  | 0.14 |  | 0 |  | 0.75 |  | 0.25
 | [NAME] (kW) |  | Energy Price |  | Correlation |  | Return |  | Curve Shift |  | Debt |  | Equity
 | 250 |  | 42.45 |  | 0.7 |  | 0.12 |  | 0 |  | 0.67 |  | 0.33
 | 200 |  | 43.22 |  | 0.7 |  | 0.12 |  | 0 |  | 0.7 |  | 0.3
 | 150 |  | 43.98 |  | 0.7 |  | 0.12 |  | 0 |  | 0.72 |  | 0.28
 | [NAME] (kW) |  | Energy Price |  | Correlation |  | Return |  | Curve Shift |  | Debt |  | Equity
 | 250 |  | 41.15 |  | 0.7 |  | 0.1 |  | 0 |  | 0.63 |  | 0.37
 | 200 |  | 42.07 |  | 0.7 |  | 0.1 |  | 0 |  | 0.66 |  | 0.34
 | 150 |  | 42.99 |  | 0.7 |  | 0.1 |  | 0 |  | 0.69 |  | 0.31
 | Curve Shift |  | Energy Price |  | Correlation |  | Return |  | [NAME] (kW) |  | Debt |  | Equity
 | -0.1 |  | 39.25 |  | 0.7 |  | 0.12 |  | 250 |  | 0.67 |  | 0.33
 | 0 |  | 42.45 |  | 0.7 |  | 0.12 |  | 250 |  | 0.67 |  | 0.33
 | 0.1 |  | 45.65 |  | 0.7 |  | 0.12 |  | 250 |  | 0.67 |  | 0.33
 | Correlation |  | Energy Price |  | Return |  | Curve Shift |  | [NAME] (kW) |  | Debt |  | Equity
 | 0.7 |  |  |  | 0.12 |  | 0 |  | 250
 | 0.6 |  |  |  | 0.12 |  | 0 |  | 250
 | 0.5 |  |  |  | 0.12 |  | 0 |  | 250
 | Debt/Equity = 60%/40% Scenario: |  |  |  |  |  |  |  |  |  |  |  | Energy Payment ($/Mwh) Scenario
 | [NAME] (kW) |  | Energy Price |  | Correlation |  | Return |  | Curve Shift |  |  |  |  | IRR
 | 250 |  | 48.66 |  | 0.7 |  | 0.14 |  | 0 |  |  | Residual Value (kW) |  | 0.1 | 0.12 | 0.14
 | 200 |  | 49.9 |  | 0.7 |  | 0.14 |  | 0 |  |  |  | 250 | 42.86 | 45.67 | 48.66
 | 150 |  | 51.1 |  | 0.7 |  | 0.14 |  | 0 |  |  |  | 200 | 44.36 | 47.02 | 49.9
 |  |  |  |  |  |  |  |  |  |  |  |  | 150 | 45.79 | 48.39 | 51.1
 | [NAME] (kW) |  | Energy Price |  | Correlation |  | Return |  | Curve Shift |  |  |  | * With 70% correlation and no curve shift
 | 250 |  | 45.67 |  | 0.7 |  | 0.12 |  | 0
 | 200 |  | 47.02 |  | 0.7 |  | 0.12 |  | 0 |  |  |  |  | Curve Shift
 | 150 |  | 48.39 |  | 0.7 |  | 0.12 |  | 0 |  |  | Residual Value (kW) |  | -10% | 0 | +10%
 |  |  |  |  |  |  |  |  |  |  |  |  | 250 | 44.83 | 45.67 | 46.18
 | [NAME] (kW) |  | Energy Price |  | Correlation |  | Return |  | Curve Shift |  |  |  | 200 | 46.19 | 47.02 | 47.54
 | 250 |  | 42.86 |  | 0.7 |  | 0.1 |  | 0 |  |  |  | 150 | 47.56 | 48.39 | 48.91
 | 200 |  | 44.36 |  | 0.7 |  | 0.1 |  | 0 |  |  |  | * With 12% IRR and 70% correlation
 | 150 |  | 45.79 |  | 0.7 |  | 0.1 |  | 0 |  |  |  | * Curve shift of serving EES Load and spread option value
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Correlation
 | Curve Shift |  | Energy Price |  | Correlation |  | Return |  | [NAME] (kW) |  |  | Residual Value (kW) |  | 0.7 | 0.6 | 0.5
 | -0.1 |  | 42.47 |  | 0.7 |  | 0.12 |  | 250 |  |  |  | 250 | 45.67 | 44.9 | 44.19
 | 0 |  | 45.67 |  | 0.7 |  | 0.12 |  | 250 |  |  |  | 200 | 47.02 | 46.27 | 45.57
 | 0.1 |  | 48.87 |  | 0.7 |  | 0.12 |  | 250 |  |  |  | 150 | 48.39 | 47.63 | 46.92
 |  |  |  |  |  |  |  |  |  |  |  |  | * With 12% IRR and no curve shift
 | Correlation |  | Energy Price |  | Return |  | Curve Shift |  | [NAME] (kW)
 | 0.7 |  | 45.67 |  | 0.12 |  | 0 |  | 250
 | 0.6 |  | 44.9 |  | 0.12 |  | 0 |  | 250
 | 0.5 |  | 44.13 |  | 0.12 |  | 0 |  | 250