CCGT Economics Capacity MW 0 Load Factor % 0% -30% -15% 0% 15% 30% Annual output TWh 0.00 Gas Price MWh 0 Electricity Price kW 0 Carbon Price Construction time years 0 Project life years 0 Fuel Efficiency 0% Fuel consumed MWh #DIV/0! NPV #DIV/0! Gas cost US$/mmbtu 0 US$/MWh 0.00 Convert mmbtu to MWh 3.413 US$=€1 1.13 EIA Estimates €mm Capital Cost US$/kW 0 0 US$mm 0 Fixed Cost US$/kW 0 0.00 US$mm 0 Variable Costs US$/MWh 0 0.00 US$mm 0 Gas Cost US$/MWh 0.00 #DIV/0! US$mm #DIV/0! Carbon output per MWh Tonnes 0.18 Carbon price US$/t 0.00 Corporate Tax Rate 0% Electricity Price US$/MWh 0 €/MWh 100 Capacity Payment US$/kW 0 Project Economics 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 Utilisation 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% Output MWh 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Price $/MWh 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Revenues $mm 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 Capacity Payment $mm 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 Capex $mm 0.0 0.0 0.0 Total $mm 0.0 Variable Cost $mm 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 Fixed Cost $mm 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 Fuel Cost $mm #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Cost of Carbon $mm #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Total Costs $mm #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Operating Cashflow €mm #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Depreciation 20 years 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 Pre-tax profit €mm #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Corporation Tax 0% #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Net Income €mm #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Post-tax Cashflow €mm #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Net Cashflow €mm 0.0 0.0 0.0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Cumulative Net Cashflow 0.0 0.0 0.0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Discount Rate 0.00% Discount Factor 1 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 Discounted Cashflow €mm 0.0 0.0 0.0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! NPV €mm #DIV/0! IRR % #HODNOTA! Payback (Years) Breakeven Utilisation Breakeven Gas Price Breakeven Electricity Price Breakeven Carbon Price Discount Rate Cost of Interest 0% Tax Rate 0% Cost of Debt 0.0% Cost of Equity 0% Share of Debt 50% Share of Equity 50% WACC 0.00% Load Factor 20% 30% 40% 50% 60% 70% 80% Capacity Payment ##### Sheet/List 2 ##### WACC Cost of Equity Equity market return 8.00% Risk Free Rate 1.75% Beta 0.49 Cost of Equity 4.81% Interest Rate 4.00% Tax Rate 20% Cost of Debt 3.20% WACC 4.01% % Debt 50% % Equity 50% ##### Sheet/List 3 ##### Capital Costs US$/kW Gas CCGT 978 Onshore Wind 1877 Solar PV 2534 Hydro 3123 Coal (USC) 3636 Biomass 4985 Nuclear 5945 Offshore Wind 6628 Waste 8843 Operating Costs Fixed (LHS) Variable (RHS) Gas CCGT 11 3.5 Solar PV 23.4 0 Onshore Wind 39.7 0 Coal (USC) 42.1 4.6 Offshore Wind 54 0 Nuclear 100.3 2.3 Biomass 110 4.2 ##### Sheet/List 4 ##### 2.205 Pounds per mmBtu Tonnes per mmbtu Tonnes per MWh Gas 117.0 0.053 0.181 Gasoline 157.2 0.071 0.243 Diesel 161.3 0.073 0.250 Lignite 215.4 0.098 0.333 Coal 228.6 0.104 0.354