Financial Model

All modelled on annual basis.

Put all inputs on one tab, also show the results here in a summary.

All calculations on a second tab (no inputs on this tab!)

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%

Valuation

8.5% levered IRR. Calculate net present value, also NPV/MW and NPV/MWh

Calculated unlevered IRR

Provide 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