| ← Back to Cover | |||||||
| EXECUTIVE DASHBOARD | |||||||
| Power Price Model Summary — European Market (Nordpool) | |||||||
| KEY METRICS | |||||||
| Current Spot (Base) | 48.5 | 5Y Fwd Avg (Base) | 53.5 | Prob-Wtd Price | 57.8 | ||
| EUR/MWh | EUR/MWh | EUR/MWh | |||||
| Hist. Vol (Base, Ann.) | 81.0% | GARCH Vol (Latest) | 47.4% | Avg Fwd Spread (Pk-OP) | 20.3 | ||
| EUR/MWh | |||||||
| HISTORICAL PRICE SUMMARY (2021-2025) | |||||||
| Year | Avg Base | Avg Peak | Avg Off-Peak | YoY Change | Volatility | ||
| 2021 | 41.28 | 47.45 | 30.97 | 0.0% | 35.0% | ||
| 2022 | 131.03 | 150.66 | 98.33 | 217.4% | 35.0% | ||
| 2023 | 74.39 | 85.52 | 55.78 | -43.2% | 35.0% | ||
| 2024 | 45.93 | 52.81 | 34.46 | -38.3% | 35.0% | ||
| 2025 | 38.74 | 44.54 | 29.06 | -15.6% | 35.0% | ||
| 5-Year Average | 66.27 | 76.19 | 49.72 | 30.1% | 35.0% | ||
| FORWARD CURVE SUMMARY (2026-2030) | |||||||
| Year | Base Fwd | Peak Fwd | Off-Peak Fwd | Spread | vs Spot | ||
| 2026 | 50.00 | 59.00 | 40.00 | 19.00 | 3.1% | ||
| 2027 | 52.50 | 61.95 | 42.00 | 19.95 | 8.2% | ||
| 2028 | 54.00 | 63.72 | 43.20 | 20.52 | 11.3% | ||
| 2029 | 55.00 | 64.90 | 44.00 | 20.90 | 13.4% | ||
| 2030 | 56.00 | 66.08 | 44.80 | 21.28 | 15.5% | ||
| 5-Year Average | 53.50 | 63.13 | 42.80 | 20.33 | 10.3% | ||
| SCENARIO COMPARISON | |||||||
| Scenario | Probability | Avg Price | vs Base | Contribution | Range (Min-Max) | ||
| Base Case | 50.0% | 53.50 | 0.0% | 26.75 | 34 - 79 | ||
| Bull Case | 20.0% | 66.88 | 25.0% | 13.38 | 43 - 99 | ||
| Bear Case | 20.0% | 40.13 | -25.0% | 8.03 | 26 - 60 | ||
| Stress Case | 10.0% | 96.30 | 80.0% | 9.63 | 62 - 143 | ||
| Probability-Weighted | 100.0% | 57.78 | 57.78 | ||||
| VOLATILITY SUMMARY | |||||||
| Metric | Base | Peak | Off-Peak | ||||
| Historical Annualized Vol | 81.0% | 42.0% | 38.0% | ||||
| GARCH Avg Vol (Ann.) | 59.3% | ||||||
| GARCH Latest Vol (Ann.) | 47.4% | ||||||
| GARCH Max Vol (Ann.) | 116.9% | ||||||
| GARCH Min Vol (Ann.) | 12.2% | ||||||
| GARCH Half-Life (months) | 17.0 | ||||||
| SEASONAL PRICE PATTERN (5-Year Monthly Average, Base Load) | |||||||
| Month | Avg Base | Seasonal Index | Deviation from Avg | ||||
| Jan | 89.75 | 1.35x | 23.48 | ||||
| Feb | 81.87 | 1.24x | 15.59 | ||||
| Mar | 72.30 | 1.09x | 6.02 | ||||
| Apr | 60.36 | 0.91x | (5.91) | ||||
| May | 51.86 | 0.78x | (14.41) | ||||
| Jun | 48.66 | 0.73x | (17.61) | ||||
| Jul | 45.53 | 0.69x | (20.74) | ||||
| Aug | 48.95 | 0.74x | (17.32) | ||||
| Sep | 55.10 | 0.83x | (11.17) | ||||
| Oct | 67.48 | 1.02x | 1.20 | ||||
| Nov | 79.42 | 1.20x | 13.15 | ||||
| Dec | 93.99 | 1.42x | 27.72 | ||||
| MODEL STATUS | |||||||
| Check | Status | Detail | |||||
| Scenario Probabilities Sum | PASS | 100.0% | |||||
| GARCH Stationarity | PASS | 0.96 | |||||
| Seasonal Shape Sum | PASS | 12.000 | |||||
| Forward Prices Positive | PASS | 34.35 | |||||
| Historical Data Complete | PASS | 60 of 60 months | |||||
| Correlation Matrix Valid | PASS | Diagonal = 1.000 | |||||
| Note: All values are dynamically linked to model sheets. Update Assumptions to see real-time changes across all sections. Sample data used throughout — replace with actual market data for production use. | |||||||