LCOE Calculator — Solar PV · Wind · Offshore · BESS | Free Tool

Description
Stop estimating LCOE in your head or rebuilding the formula from scratch every time.
This free Excel calculator computes the Levelised Cost of Energy (LCOE) for any renewable energy project — Solar PV (utility, C&I, residential), Wind Onshore, Wind Offshore and BESS — using the correct discounted methodology with NPV of costs and generation.


Three sheets included:
LCOE Calculator Enter your project inputs in the blue cells — CAPEX, OPEX, annual generation, useful life, WACC, degradation rate, OPEX escalation and any upfront grant or ITC. The calculator outputs:

• Discounted LCOE (€/MWh) — NPV-based, accounting for time value of money, OPEX escalation and annual generation degradation
• Simple LCOE — straight-line approximation for quick estimates
• Net CAPEX after grant/ITC, lifetime generation, NPV of OPEX, CapEx/MW, OPEX/MWh Year 1 and implied capacity factor

A benchmark table shows indicative LCOE ranges for 14 technology/market combinations (H1 2026 data) so you can immediately compare your result against the market. Four pre-set configurations load typical values for Solar PV Italy, Wind Germany, Offshore Wind UK and BESS Italy with one click.


Methodology Full explanation of the discounted LCOE formula, the difference between discounted and simple LCOE, how to interpret LCOE for BESS, and the key limitations of LCOE as a decision metric. Sources cited.
Compare Projects Enter up to 5 projects side by side and compare LCOE, CapEx/MW and Simple LCOE across different technologies, markets or scenarios.
Markets covered in the benchmark table: Italy · Germany · UK · USA · Australia · Netherlands · Taiwan
Technologies: Solar PV (Utility · C&I · Residential) · Wind Onshore · Wind Offshore (Fixed-Bottom) · BESS (2hr and 4hr)
What this is — and what it isn't


This calculator gives you a fast, accurate LCOE for any project configuration. It does not replace a full financial model — it has no debt schedule, no IRR, no NPV at the project level and no revenue modelling beyond a simple energy price input. For complete 25-year DCF models with project finance, DSCR and multilingual guides, see the paid models in this channel.


Indicative tool for strategic evaluation. Not investment advice.