RenewTrack Methodology
Technical Documentation for Financial Models, Calculation Methods, and Data Quality Standards
1. Overview
RenewTrack is a renewable energy deal tracking and analytics platform focused on European grid-scale projects. The platform aggregates financing data from multiple authoritative sources, applies standardised calculation methodologies, and provides benchmarking analytics for institutional investors, project finance lenders, and energy sector advisors.
This document describes the calculation methodologies, data quality standards, and modelling assumptions used throughout the platform. It covers the cash flow waterfall engine, benchmarking calculations, valuation models, and confidence interval methodology. All financial calculations follow industry-standard project finance conventions used by European infrastructure funds and development finance institutions.
2. Data Sources & Quality
2.1 Data Collection
The platform aggregates data from the following primary sources, each assigned a confidence classification:
| Source | Type | Coverage | Confidence |
|---|---|---|---|
| PitchBook | Commercial database | Debt financing amounts, ~979 records | Medium |
| European Investment Bank | Public institution | Project finance terms, government co-financing | High |
| Company IR / Annual Reports | Corporate disclosures | Total investment, capacity, COD dates | High |
| National Registries (REPD, MaStR) | Government registries | Capacity, location, grid connection | High |
| Press Releases | Public announcements | Financial close, consortium details | Medium |
2.2 Quality Classification
Each data point carries a confidence classification that determines its inclusion in calculations:
- High Confidence -- Government registries, official filings, audited annual reports. Included in all calculations without caveats.
- Medium Confidence -- Commercial databases (PitchBook), press releases, industry reports. Included in calculations with sample size disclosure.
- Lower Confidence -- Industry estimates, analyst projections. Flagged with amber indicators and excluded from gearing benchmarks when estimated.
2.3 Estimated Values
Some financing values are estimated using industry-standard assumptions when exact figures are not publicly available. These are flagged with is_estimated: true in the data model and displayed with an amber indicator in the user interface.
As of February 2026, 123 of 1,432 financings are marked as estimated. Estimated values are excluded from gearing benchmarking calculations to preserve statistical integrity. PitchBook data reports debt financing amounts only (not total project investment), so these entries are excluded from gearing ratio calculations where both debt and total investment are required.
3. Cash Flow Waterfall Engine
3.1 Model Structure
The waterfall engine implements a bank-grade project finance cash flow model supporting annual, semi-annual (default), and quarterly periodicity. The model follows the standard project finance waterfall convention where each cash flow level is calculated sequentially:
1. Gross Revenue = Production (MWh) x Price (EUR/MWh) 2. Net Revenue = Gross Revenue - Grid Charges 3. EBITDA = Net Revenue - Total Operating Costs 4. EBIT = EBITDA - Depreciation 5. Tax = max(0, EBIT x Corporate Tax Rate) 6. CFADS = EBITDA - Tax - Working Capital Changes 7. Debt Service = Interest + Principal Repayment 8. CADS = CFADS - Debt Service 9. DSRA Movements = Funding / Release of Debt Service Reserve 10. Pre-Distribution Cash = CADS +/- DSRA Movements 11. Cash Sweep (if applicable) = Excess Cash x Sweep % 12. Distributable Cash = Pre-Distribution Cash - Cash Sweep
Convention: inflows are positive, outflows are negative. The model uses ACT/360 or 30/360 day count conventions for interest calculations, configurable per deal.
3.2 Revenue Model
Revenue is modelled as a blend of contracted (PPA) and merchant volumes:
Gross Production = Capacity (MW) x Capacity Factor x 8,760 hrs Net Production = Gross x Availability x (1 - Electrical Losses) x (1 - Curtailment) x (1 - Other Losses) Degradation: Year 1 step-down + annual linear degradation PPA Revenue = Net Production x PPA% x PPA Price x (1 + Escalation)^t Merchant Revenue = Net Production x (1 - PPA%) x Merchant Price x Capture Ratio x (1 + Escalation)^t Total Revenue = PPA Revenue + Merchant Revenue
The capture ratio reflects the discount to baseload prices that intermittent generators receive, with an annual degradation factor as market penetration increases (cannibalization effect).
3.3 Operating Expenditure
Operating costs are modelled as a combination of fixed and variable components, each with independent escalation rates:
| Component | Unit | Solar Default | Onshore Wind Default |
|---|---|---|---|
| Fixed O&M | EUR/MW/yr | 12,000 | 18,000 |
| Variable O&M | EUR/MWh | 0 | 2.0 |
| Insurance | EUR/MW/yr | 4,000 | 6,000 |
| Land Lease | EUR/MW/yr | 5,000 | 5,000 |
| Grid Charges | EUR/MW/yr | 2,000 | 3,000 |
| Asset Management | EUR/MW/yr | 3,000 | 4,000 |
All fixed costs escalate at the inflation rate (default 2.0% p.a.). Variable O&M is applied to net production volumes.
3.4 Debt Service
Four repayment profiles are supported:
Sculpted: Principal = CFADS / Target DSCR - Interest (Debt sized to maintain constant DSCR across all periods) Annuity: Equal total payments (interest + principal) Straight-line: Equal principal payments + declining interest Bullet: Interest-only with full principal at maturity Interest = Outstanding Balance x (Reference Rate + Margin) x Day Count Fraction DSCR = CFADS / (Interest + Principal) LLCR = NPV(CFADS over remaining debt life) / Outstanding Debt
The default configuration uses sculpted repayment with a target DSCR of 1.30x, reflecting market standard for European renewable energy project finance. Senior debt is assumed at 70% gearing with 160 bps margin over the reference rate.
3.5 Cash Sweep & Lock-up
Cash Sweep triggers when DSCR > Trigger DSCR (default 1.20x): Sweep Amount = Excess Cash x Sweep Percentage (default 50%) Holiday Period: No sweep for first N years (default 2) Distribution Lock-up triggers when: Historical DSCR (lookback) < Lock-up DSCR (default 1.15x) OR Projected DSCR (forward) < Lock-up DSCR
4. Benchmarking Methodology
4.1 Gearing Calculation
Gearing (%) = (Debt Amount / Total Investment) x 100 Inclusion criteria: - Both debt_amount_eur AND total_investment_eur must be non-null - total_investment_eur must be > 0 (no division by zero) - Gearing must be within [0%, 100%] (values outside indicate data error) - is_estimated entries are excluded Current statistics (Jan 2026): - 243 financings with verified gearing data - Median gearing: 74.8% - Average gearing: 70.8% - 79% of deals in 70-80% range
4.2 Debt Margin Benchmarks
Debt margins are reported in basis points (bps) above the reference rate. Benchmarks are computed by technology, country, deal size, and time period. For each grouping:
Mean = Sum(margins) / N Median = 50th percentile (interpolated) Standard Deviation = sqrt(Sum((x - mean)^2) / (N-1)) [Bessel's correction] Percentiles: P10, P25 (Q1), P50 (median), P75 (Q3), P90 IQR = P75 - P25 Missing data: Financings without pricing_margin_bps are excluded (not treated as zero). Sample size (N) is disclosed alongside every metric.
4.3 Confidence Intervals
Every benchmarking metric is accompanied by a sample-size-aware confidence interval. The method adapts to sample size to provide the most appropriate statistical measure:
n >= 10: Parametric 95% CI CI = mean +/- 1.96 x (stddev / sqrt(n)) Label: "95% CI" 3 <= n < 10: Bootstrap CI (1000 resamples) 1. Draw n samples with replacement (1000 times) 2. Compute mean of each resample 3. Sort bootstrap means 4. Lower = 2.5th percentile, Upper = 97.5th percentile Label: "Indicative (n=X)" n < 3: Insufficient data No CI displayed; metric marked "Insufficient data for CI"
The parametric method assumes approximately normal distribution, which holds well for debt margins and gearing ratios with sufficient sample sizes. For small samples, the bootstrap method makes no distributional assumptions and provides a more robust interval. Metrics derived from small samples are labelled “Indicative” to signal to users that the precision is limited.
5. Valuation Models
5.1 DCF Variants (FCFF, FCFE, APV)
Three institutional-grade DCF approaches are implemented following CFA Institute Level II valuation standards and IPEV Guidelines:
FCFF = NOPAT + Depreciation - Capex - Change in NWC NOPAT = EBIT x (1 - Tax Rate) Discount at WACC: WACC = (E/V) x Re + (D/V) x Rd x (1 - T) Enterprise Value = PV(FCFF) + PV(Terminal Value) Equity Value = Enterprise Value - Net Debt
FCFE = Net Income + Depreciation - Capex - Change in NWC - Principal + New Debt Discount at Cost of Equity: Re = Rf + Beta(levered) x ERP + Premiums Equity Value = PV(FCFE) directly
APV = Unlevered Firm Value + PV(Tax Shields) - PV(Distress Costs) Unlevered Value = PV of FCFF at unlevered cost of equity Tax Shields discounted at cost of debt
6. Worked Example
The following worked examples use RenewTrack default inputs to demonstrate the waterfall calculation methodology.
6.1 100 MW Solar PV Project
| Parameter | Value | Source |
|---|---|---|
| Capacity | 100 MW | Input |
| Capacity Factor | 13% | RenewTrack default |
| Gross Annual Production | 113,880 MWh | 100 x 0.13 x 8,760 |
| Net Annual Production | 106,640 MWh | 113,880 x 0.97 x 0.98 x 0.99 x 0.995 |
| CAPEX | EUR 60,000,000 | 100 MW x EUR 600,000/MW |
| Senior Debt (70%) | EUR 42,000,000 | 60M x 0.70 |
| PPA Price | EUR 72/MWh | 80% contracted |
| Merchant Price | EUR 55/MWh | 20% merchant, capture ratio 0.85 |
PPA Revenue = 106,640 x 0.80 x EUR 72 = EUR 6,142,000 Merchant Revenue = 106,640 x 0.20 x EUR 55 x 0.85 = EUR 996,000 Total Revenue = EUR 7,138,000 Operating Costs (Year 1): Fixed O&M: 100 x 12,000 = EUR 1,200,000 Insurance: 100 x 4,000 = EUR 400,000 Land Lease: 100 x 5,000 = EUR 500,000 Grid Charges: 100 x 2,000 = EUR 200,000 Asset Management: 100 x 3,000 = EUR 300,000 Total Opex: EUR 2,600,000 EBITDA = EUR 7,138,000 - EUR 2,600,000 = EUR 4,538,000 Depreciation = EUR 60,000,000 / 20 = EUR 3,000,000 EBIT = EUR 4,538,000 - EUR 3,000,000 = EUR 1,538,000 Tax = EUR 1,538,000 x 25% = EUR 384,500 CFADS = EUR 4,538,000 - EUR 384,500 = EUR 4,153,500 Debt Service (sculpted to 1.30x DSCR): Target DS = EUR 4,153,500 / 1.30 = EUR 3,195,000 Interest (Year 1) = EUR 42,000,000 x (2.75% + 1.60%) = EUR 1,827,000 Principal = EUR 3,195,000 - EUR 1,827,000 = EUR 1,368,000 Equity IRR target: ~7-9% (market range for operational solar)
6.2 100 MW Onshore Wind Project
| Parameter | Value | Source |
|---|---|---|
| Capacity | 100 MW | Input |
| Capacity Factor | 28% | Northern European average |
| Gross Annual Production | 245,280 MWh | 100 x 0.28 x 8,760 |
| Net Annual Production | 229,680 MWh | 245,280 x 0.97 x 0.98 x 0.99 x 0.995 |
| CAPEX | EUR 130,000,000 | 100 MW x EUR 1,300,000/MW |
| Senior Debt (70%) | EUR 91,000,000 | 130M x 0.70 |
| PPA Price | EUR 72/MWh | 80% contracted |
| Merchant Price | EUR 55/MWh | 20% merchant, capture ratio 0.85 |
| Variable O&M | EUR 2/MWh | Applied to net production |
PPA Revenue = 229,680 x 0.80 x EUR 72 = EUR 13,230,000 Merchant Revenue = 229,680 x 0.20 x EUR 55 x 0.85 = EUR 2,148,000 Total Revenue = EUR 15,378,000 Operating Costs (Year 1): Fixed O&M: 100 x 18,000 = EUR 1,800,000 Variable O&M: 229,680 x 2 = EUR 459,000 Insurance: 100 x 6,000 = EUR 600,000 Land Lease: 100 x 5,000 = EUR 500,000 Grid Charges: 100 x 3,000 = EUR 300,000 Asset Management: 100 x 4,000 = EUR 400,000 Total Opex: EUR 4,059,000 EBITDA = EUR 15,378,000 - EUR 4,059,000 = EUR 11,319,000 Depreciation = EUR 130,000,000 / 20 = EUR 6,500,000 EBIT = EUR 11,319,000 - EUR 6,500,000 = EUR 4,819,000 Tax = EUR 4,819,000 x 25% = EUR 1,204,750 CFADS = EUR 11,319,000 - EUR 1,204,750 = EUR 10,114,250 Debt Service (sculpted to 1.30x DSCR): Target DS = EUR 10,114,250 / 1.30 = EUR 7,780,000 Interest (Year 1) = EUR 91,000,000 x (2.75% + 1.60%) = EUR 3,958,500 Principal = EUR 7,780,000 - EUR 3,958,500 = EUR 3,821,500
7. Limitations & Disclaimers
- Data completeness. Only 243 of 1,432 financings have verified gearing data (both debt and total investment). PitchBook records report debt only, limiting gearing analysis to a subset of the database.
- Survivorship bias. The dataset over-represents successfully financed projects. Projects that failed to reach financial close are not captured.
- Temporal lag. Financing terms are recorded at financial close and may not reflect current market conditions, particularly in volatile interest rate environments.
- Geographic concentration. Coverage varies by country. UK, Germany, and Spain have the deepest datasets; smaller markets may have insufficient data for reliable benchmarks.
- Estimated values. Where exact figures are unavailable, industry-standard assumptions (e.g., 75% gearing) are applied. These are flagged but may introduce systematic bias if the assumed ratios differ from actual market terms.
- Planned enhancements. Working capital facilities, LC fees, swap breakage costs, and currency hedging are on the development roadmap and will be incorporated into future waterfall engine releases for full cross-border transaction modeling.
- Not investment advice. RenewTrack provides analytical tools and data aggregation. Output should not be construed as investment advice or recommendation. Users should perform their own due diligence and consult qualified advisors.
8. References
- IRENA (2024), Renewable Power Generation Costs in 2023. International Renewable Energy Agency.
- IPEV Guidelines (2022), International Private Equity and Venture Capital Valuation Guidelines.
- CFA Institute (2024), CFA Program Curriculum Level II: Equity Valuation.
- Yescombe, E.R. (2014), Principles of Project Finance, 2nd edition. Academic Press.
- Basel Committee on Banking Supervision (2023), IRB approach: treatment of expected losses and eligible provisions.
- European Investment Bank (2024), EIB Climate Bank Roadmap Progress Report.
- PitchBook Data, Inc. (2025), European Infrastructure Debt Report.
This methodology document is maintained by the RenewTrack team and updated with each major platform release. For questions or feedback, contact the platform administrators.
Last updated: February 2026 | Version 2.0 | RenewTrack Europe