CEA Analytical Tool
CEA Power Dashboard
An analytical tool for tracking renewable energy market signals, capture prices and project economics in Serbia.
Data sources
- SEEPEX day-ahead market — hourly clearing prices, treated as the reference market price for Serbia.
- ENTSO-E Transparency Platform — day-ahead prices (A44), actual generation per production type (A75 + psrType B16 solar / B19 wind), actual load, cross-border flows and installed capacity.
- PVGIS (JRC, European Commission) — hourly PV output simulation based on coordinates, tilt and azimuth, used for solar generation profiles in the calculator.
- AERS, EMS, Ministry of Mining and Energy, Energy Community — regulatory and policy context.
- Demo data — synthetic SEEPEX-shaped series used wherever live data is not yet connected. Clearly labelled with a "Demo data" badge.
Formulas
Baseload price
baseload = mean(hourly_price[period])Simple average of all hourly prices in the selected period.
Peakload price
peakload = mean(hourly_price[weekday & hour ∈ 08–20])Negative price hours
neg_hours = count(hourly_price < 0)Solar capture price
capture_solar = Σ(price_h × solar_h) / Σ(solar_h)Generation-weighted average price actually realised by solar.
Wind capture price
capture_wind = Σ(price_h × wind_h) / Σ(wind_h)Capture rate
capture_rate = capture_tech / baseloadBelow 100% indicates RES cannibalisation.
Merchant revenue
merchant_rev = Σ(generation_h × price_h)LCOE
LCOE = (CAPEX + Σ OPEX_y/(1+r)^y) / Σ Gen_y/(1+r)^yNPV
NPV = Σ CF_y / (1 + r)^yIRR
IRR = r such that NPV(r) = 0Solved by bisection over [-99%, +1000%].
Payback
first year where cumulative cashflow ≥ 0DSCR
DSCR_y = EBITDA_y / debt_service_yAssumptions & limitations
- The dashboard treats negative prices as a meaningful market signal, not an error. Negative prices on SEEPEX became technically possible in May 2026.
- Solar generation profiles use PVGIS hourly PV output for the selected coordinates and array configuration. Wind profiles use ENTSO-E actual generation where available, otherwise a clearly-marked estimate.
- Capture price and capture rate calculations assume hourly profiles fully co-align with hourly market prices (no intra-hour resolution effects).
- The Solar Project Calculator uses simplified financial mechanics: linear degradation, single tariff escalation, no inflation adjustment for OPEX. It is intended for indicative analysis, not bankable due diligence.
- This tool provides indicative analysis only and should not be interpreted as financial or investment advice.
