8.5% levered IRR. Calculate net present value, also NPV/MW and NPV/MWh
Calculated unlevered IRRProvide a data table of npv based on different levered IRR assumptions (row), and Feed-in-Tariff price (column)
Statements
Prepare Cash Flow, Income Statement and Balance Sheet.

Production

Windfarm with 50 MW

Production - P50: 3000h per MW per year

Production - P75: 92% of P50. Add a toggle to switch between P-Levels.

Lifetime: 30 years

 

Revenues

Feed-in-Tariff of EUR 70/MWh, for first 20 years

Thereafter merchant power prices, assuming EUR 40/MWh starting point today, inflated by 2%

 

Cost

Operations & Maintenance: EUR 15/MWh

Other costs: EUR 5/MWh

 

Debt

EUR 0.7m/MW total debt volume

Amortised over 15 years

Interest rate: 2.5%

 

Net Working Capital

30 days for payables and receivables

 

Taxes

Depreciation: cost of EUR 1.2m/MW depreciated over 10 years

Tax rate: 25%