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 / baseload

Below 100% indicates RES cannibalisation.

Merchant revenue
merchant_rev = Σ(generation_h × price_h)
LCOE
LCOE = (CAPEX + Σ OPEX_y/(1+r)^y) / Σ Gen_y/(1+r)^y
NPV
NPV = Σ CF_y / (1 + r)^y
IRR
IRR = r such that NPV(r) = 0

Solved by bisection over [-99%, +1000%].

Payback
first year where cumulative cashflow ≥ 0
DSCR
DSCR_y = EBITDA_y / debt_service_y

Assumptions & 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.