Calculation guide
Use a consistent real or nominal basis.
lcoe = (pmt(capex,12*rate,life)+annual)/mwh
Inputs
Initial capital cost
Example entry 1000000.0 (in the selected currency).
Annual operating costs
Example entry 20000.0 (in the selected currency).
Annual net generation (MWh)
Example entry 2000.0. Minimum 1e-12.
Economic life (years)
Example entry 20.0. Minimum 1. Use whole numbers.
Annual discount rate (%)
Example entry 0.0 %. Allowed range 0 to 100.
Worked example
| Input | Value |
|---|---|
| Initial capital cost | 1,000,000 |
| Annual operating costs | 20,000 |
| Annual net generation (MWh) | 2,000 |
| Economic life (years) | 20 |
| Annual discount rate (%) | 0% |
| Result | Value |
|---|---|
| Levelized cost per MWh | 35 |
Calculation steps
Levelized cost per MWh = ((payment(Initial capital cost, (12 × Annual discount rate (%)), Economic life (years)) + Annual operating costs) ÷ Annual net generation (MWh))
((payment(1,000,000, (12 × 0), 20) + 20,000) ÷ 2,000) = 35
Interpreting the result
Compare the result with an energy price expressed per MWh on the same price basis.
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Initial capital cost | 1,000,000 | 1,100,000 | Levelized cost per MWh | 35 | 37.5 |
| Annual operating costs | 20,000 | 22,000 | Levelized cost per MWh | 35 | 36 |
| Annual net generation (MWh) | 2,000 | 2,200 | Levelized cost per MWh | 35 | 31.818182 |
| Economic life (years) | 20 | 22 | Levelized cost per MWh | 35 | 32.727273 |
| Annual discount rate (%) | 0% | 1% | Levelized cost per MWh | 35 | 37.707657 |
