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 open project-finance models: a German onshore wind farm and a battery storage plant in Ukraine. Every input has a public source or a documented assumption, 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.09%
- Project IRR after tax
- 3.67%
- LCOE (real)
- 7.25 ct/kWh
- Minimum DSCR
- 1.44x
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.1% a year on equity — well below a typical 8% cost of equity. The model’s lender sizes the loan on the guaranteed EEG floor — a conservative view — so debt covers only 35% of the investment. An equity return of 8% would need an award of about 7.41 ct/kWh — above the 2026 ceiling of 7.25 ct/kWh.
New model
Battery Storage Investment Calculator
Fictional battery “Zoria Storage” · 50 MW / 100 MWh · Kyiv region, Ukraine · day-ahead trading only
- Investor IRR (€)
- −6.9%
- Investor NPV at 15%
- −€16.8m
- Net revenue 2029, per MW
- €86k
- Break-even spreads
- × 1.96
What the base case shows
Trading on the day-ahead market alone, a two-hour battery that starts in 2028 keeps €86k per MW of its trading margin in the first full year. After operating costs, network tariffs and the expected war loss, that does not carry a €23.1m investment: the investor loses 6.9% a year in euros. Daily price spreads would have to be about 2.0 times the reference path to reach the 15% hurdle. The next version adds balancing services and Ukrenergo’s auctions, the other income a battery in Ukraine can earn.
Excel templates
Startup Finance Kit
Fictional fintech start-up “Mirovest GmbH” · Berlin · 60 months from January 2027 · 10 Excel workbooks
- Excel workbooks
- 10
- Monthly plan
- 60 months
- Scenarios × versions
- 3 × 2
- Values cross-checked
- 458,562
What the kit contains
An integrated financial model with P&L, balance sheet, cash flow, KPIs, a dashboard and an indicative exit; a quick model for top-down what-ifs; an assumptions register, a KPI dictionary and a chart of accounts; unit economics, a headcount and payroll plan and a frozen annual budget; and burn, runway and cost reports on six months of invented actuals. An independent re-implementation of the model agreed with it on 458,562 values.
Fictional company. Illustrative calculation — not investment, tax or legal advice.
What the wind farm model covers
Revenue under EEG 2023
Sliding market premium on the annual market value, the § 36h correction factor, no premium at negative prices, advances and final settlement under § 26, market sales or a PPA after support ends — and a simplified two-sided premium stress as a switch.
Debt sized like a KfW project loan
KfW programme 270 at the current rate, quarterly instalments after the grace years, DSCR targets for P50 and one-year P90 on the EEG floor — a conservative lender view — a gearing cap, a debt service reserve and a 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, interest during construction and start-up liquidity. Sources equal uses to the cent.
Risk views
The lender’s one-year P90 stress, a ten-year P90 and a downside case with the loan held fixed, a tornado of twelve drivers and a bid calculator that checks whether a price is financeable and within the ceiling.
Open and checked
Every input has a unit, a hint and a dated public source or a documented assumption. Checks on the calculation, funding, covenant and model scope run on every recalculation, and the model downloads as an Excel workbook with live formulas.
Also built by me: Storywell
Illustrated stories and audiobooks for children in eight languages. I designed, built and published the app from scratch.