Finance professional · Wiesbaden, Germany
Igor Sabodakha
Audit, transaction advisory, valuation and financial modelling — more than 15 years of international experience, seven of them at Grant Thornton.
This site publishes an open project-finance model of a German onshore wind farm. Every input has a public source, every formula is documented, and the whole calculation runs in your browser.
Featured model
Wind Farm Investment Calculator
Fictional wind farm “Musterhöhe” · 5 × 6.3 MW · Hesse, Germany · base case at the tender price of August 2026
- Equity IRR
- 3.01%
- Project IRR after tax
- 3.67%
- LCOE (real)
- 7.25 ct/kWh
- Minimum DSCR
- 1.37x
What the base case shows
At the average award of the August 2026 tender, 4.79 ct/kWh, a site of average Hessian quality earns 3.0% a year on equity — well below a typical 8% cost of equity. Lenders size the loan on the guaranteed EEG floor, so debt covers only 37% of the investment. An equity return of 8% would need an award of about 7.46 ct/kWh — above the 2026 ceiling of 7.25 ct/kWh.
What the model covers
Revenue under EEG 2023
Sliding market premium on the annual market value, the § 36h correction factor, no premium at negative prices, market sales or a PPA after support ends — and the two-sided premium of the EEG 2027 draft as a switch.
Debt the way German lenders size it
KfW programme 270 at the current rate, linear repayment after grace years, DSCR targets for P50 and P90 on the EEG floor, a gearing cap, a debt service reserve and a distribution lock-up.
German taxes
Trade tax with add-backs, allowance and loss carry-forward; corporate tax and solidarity surcharge for a GmbH; 16-year depreciation and a tax provision for decommissioning.
Construction and funding
Monthly capex with payment profiles, a VAT bridge loan, upfront and commitment fees and interest during construction. Sources equal uses to the cent.
Risk views
P90 and downside cases with the loan held fixed, a tornado of twelve drivers and a bid calculator that finds the award price for a target return.
Open and checked
Every input has a unit, a hint and a dated public source. Fifteen integrity checks run on every recalculation, and the results export to Excel.
Also built by me: Storywell
Illustrated stories and audiobooks for children in eight languages. I designed, built and published the app from scratch.