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 US 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 US 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 |
|---|---|---|---|
| EIA (Form 860/923) | US government | ~6,900 US renewable generators, capacity, fuel type | High |
| EIA Annual Energy Outlook (AEO) | US government | Long-term energy price and capacity projections through 2050 | High |
| LBNL | US national lab | Utility-scale solar/wind cost and performance benchmarks | High |
| EPA eGRID | US government | ~96,000 US generator records, emissions, capacity factors | High |
| DOE Loan Programs Office (LPO) | US government | Federal loan guarantees and direct loans for clean energy projects | High |
| NREL | US national lab | Annual Technology Baseline (ATB), capacity factors, regional resource data | High |
| ISO/RTO Queue Data | US grid operators | ~3,750 interconnection queue projects (CAISO, ERCOT, PJM, MISO, SPP, NYISO, ISO-NE) | High |
| CEBA (Clean Energy Buyers Alliance) | Industry association | US corporate PPA deal tracker, buyer/seller data | High |
| PitchBook (via WRDS) | Commercial database | Debt financing amounts, ~2,600 US records | Medium |
| WRDS DealScan | Institutional database | Syndicated loan terms, spreads, lender details | High |
| Preqin (via WRDS) | Institutional database | 72,500+ PE/VC/infrastructure fund records | High |
| Company IR / Annual Reports | Corporate disclosures | Total investment, capacity, COD dates | High |
| IRENA / Lazard | International / research | LCOE benchmarks by technology and region | 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 March 2026, 462 of ~4,900 financings are marked as estimated. Estimated values are excluded from gearing benchmarking calculations to preserve statistical integrity. PitchBook and WRDS DealScan data often 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 (USD/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 | USD/MW/yr | 12,000 | 18,000 |
| Variable O&M | USD/MWh | 0 | 2.0 |
| Insurance | USD/MW/yr | 4,000 | 6,000 |
| Land Lease | USD/MW/yr | 5,000 | 5,000 |
| Grid Charges | USD/MW/yr | 2,000 | 3,000 |
| Asset Management | USD/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 US 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
5.2 LCOE Calculation
The Levelized Cost of Energy (LCOE) model calculates the all-in cost of electricity generation over the project lifetime, discounted to present value. This is the standard metric used by IRENA, Lazard, and LBNL for cross-technology comparison.
LCOE = (Total Lifecycle Costs) / (Total Lifecycle Energy Production) Total Lifecycle Costs = CAPEX + PV(Annual O&M) + PV(Fuel, if applicable) where PV = sum of annual cost / (1 + WACC)^t for t = 1 to project life Total Lifecycle Energy Production = sum of (Capacity x CF x 8,760 x (1 - degradation)^t) / (1 + WACC)^t Inputs by technology (defaults from IRENA/Lazard/LBNL): Solar PV: CAPEX $800-1,200/kW, CF 20-28%, 25-year life, 0.5%/yr degradation Onshore Wind: CAPEX $1,100-1,600/kW, CF 25-45%, 25-year life, 0.2%/yr degradation Offshore Wind: CAPEX $2,500-4,500/kW, CF 40-55%, 25-year life, 0.2%/yr degradation Battery (4hr): CAPEX $800-1,400/kW, no CF (charged/discharged), 15-20yr life
5.3 IRA Tax Credit Calculator (US Market)
The IRA Tax Credit Calculator implements the Inflation Reduction Act of 2022 provisions for renewable energy projects. It computes applicable Investment Tax Credits (ITC) and Production Tax Credits (PTC) including base rates, bonus adders, and phase-down schedules.
Base ITC = 6% of eligible project cost (or 30% with prevailing wage & apprenticeship) Base PTC = $0.55/kWh (or $2.75/kWh with prevailing wage & apprenticeship) Bonus Adders (stackable): Domestic Content: +10% ITC or +10% PTC multiplier Energy Community: +10% ITC or +10% PTC multiplier Low-Income Community: +10-20% ITC (solar only, competitive allocation) Technology Eligibility: Solar: ITC (Section 48) or PTC (Section 45) -- taxpayer election Wind: PTC (Section 45) preferred Battery/BESS: ITC (Section 48E) -- standalone storage eligible post-IRA Offshore Wind: ITC or PTC with enhanced base rates Phase-Down Schedule: Projects begun construction by 2032: Full credit 2033: 75% of full credit 2034: 50% of full credit After 2034: Technology-neutral clean energy credits (Section 45Y/48E)
5.4 BESS Revenue Stacking
The battery storage revenue model estimates annual revenue from multiple market services, reflecting the operational reality that BESS projects stack revenue across several markets simultaneously. Revenue streams vary by market (EU vs US) and are modeled with technology-specific degradation.
Total Annual Revenue = Arbitrage + Ancillary Services + Capacity Payments Arbitrage Revenue: = Cycles/day x Usable Capacity (MWh) x Spread (peak-offpeak) x RTE x 365 Round-trip efficiency (RTE): LFP ~92%, NMC ~88%, NCA ~87%, LTO ~95% Ancillary Services (EU: FFR, DCL/DCH, EFA; US: RegD, spinning reserve): = Availability (hrs/day) x Capacity (MW) x Service Price ($/MW/hr) x 365 Capacity Payments: EU: T-4/T-1 auction clearing price x de-rating factor x capacity US: PJM RPM, NYISO ICAP, ISO-NE FCM clearing prices Degradation Modeling: Calendar aging: 1-3% capacity loss per year (chemistry-dependent) Cycle aging: Additional degradation based on DOD and cycle count Augmentation schedule: Capacity top-up at years 7-10 (typical) End-of-life: 70-80% of initial capacity (typically year 15-20)
6. Worked Example
The following worked examples use RenewTrack default inputs to demonstrate the waterfall calculation methodology.
6.1 100 MW Solar PV Project (Texas)
| Parameter | Value | Source |
|---|---|---|
| Capacity | 100 MW | Input |
| Capacity Factor | 24% | ERCOT West Texas average (LBNL) |
| Gross Annual Production | 210,240 MWh | 100 x 0.24 x 8,760 |
| Net Annual Production | 196,880 MWh | 210,240 x 0.97 x 0.98 x 0.99 x 0.995 |
| CAPEX | $80,000,000 | 100 MW x $800,000/MW |
| Senior Debt (70%) | $56,000,000 | 80M x 0.70 |
| PPA Price | $35/MWh | 80% contracted |
| Merchant Price | $28/MWh | 20% merchant, capture ratio 0.85 |
PPA Revenue = 196,880 x 0.80 x $35 = $5,512,640 Merchant Revenue = 196,880 x 0.20 x $28 x 0.85 = $937,491 Total Revenue = $6,450,131 Operating Costs (Year 1): Fixed O&M: 100 x 12,000 = $1,200,000 Insurance: 100 x 4,000 = $ 400,000 Land Lease: 100 x 5,000 = $ 500,000 Grid Charges: 100 x 2,000 = $ 200,000 Asset Management: 100 x 3,000 = $ 300,000 Total Opex: $2,600,000 EBITDA = $6,450,131 - $2,600,000 = $3,850,131 Depreciation = $80,000,000 / 20 = $4,000,000 EBIT = $3,850,131 - $4,000,000 = -$149,869 Tax = max(0, -$149,869 x 21%) = $0 CFADS = $3,850,131 - $0 = $3,850,131 IRA Tax Credits (if applicable): ITC (30% with prevailing wage) = $80,000,000 x 30% = $24,000,000 OR PTC ($27.50/MWh x 10 years) = 196,880 x $27.50 = $5,414,200/yr Debt Service (sculpted to 1.30x DSCR): Target DS = $3,850,131 / 1.30 = $2,961,639 Interest (Year 1) = $56,000,000 x (5.25% + 1.75%) = $3,920,000 Principal = deferred (interest exceeds sculpted target in Year 1) Equity IRR target: ~8-11% (market range for US utility-scale solar)
6.2 100 MW Onshore Wind Project (Iowa)
| Parameter | Value | Source |
|---|---|---|
| Capacity | 100 MW | Input |
| Capacity Factor | 38% | Midwest average (LBNL) |
| Gross Annual Production | 332,880 MWh | 100 x 0.38 x 8,760 |
| Net Annual Production | 311,790 MWh | 332,880 x 0.97 x 0.98 x 0.99 x 0.995 |
| CAPEX | $140,000,000 | 100 MW x $1,400,000/MW |
| Senior Debt (70%) | $98,000,000 | 140M x 0.70 |
| PPA Price | $30/MWh | 80% contracted |
| Merchant Price | $25/MWh | 20% merchant, capture ratio 0.85 |
| Variable O&M | $2/MWh | Applied to net production |
PPA Revenue = 311,790 x 0.80 x $30 = $7,482,960 Merchant Revenue = 311,790 x 0.20 x $25 x 0.85 = $1,325,108 Total Revenue = $8,808,068 Operating Costs (Year 1): Fixed O&M: 100 x 18,000 = $1,800,000 Variable O&M: 311,790 x 2 = $ 623,580 Insurance: 100 x 6,000 = $ 600,000 Land Lease: 100 x 5,000 = $ 500,000 Grid Charges: 100 x 3,000 = $ 300,000 Asset Management: 100 x 4,000 = $ 400,000 Total Opex: $4,223,580 EBITDA = $8,808,068 - $4,223,580 = $4,584,488 Depreciation = $140,000,000 / 20 = $7,000,000 EBIT = $4,584,488 - $7,000,000 = -$2,415,512 Tax = max(0, -$2,415,512 x 21%) = $0 CFADS = $4,584,488 - $0 = $4,584,488 IRA Tax Credits (PTC preferred for wind): PTC ($27.50/MWh x 10 years) = 311,790 x $27.50 = $8,574,225/yr Debt Service (sculpted to 1.30x DSCR): Target DS = $4,584,488 / 1.30 = $3,526,529 Interest (Year 1) = $98,000,000 x (5.25% + 1.75%) = $6,860,000 Principal = deferred (interest exceeds sculpted target in Year 1)
7. Limitations & Disclaimers
- Data completeness. Only 243 of ~4,900 financings have verified gearing data (both debt and total investment). PitchBook and WRDS DealScan 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 state. Texas, California, and the PJM region 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.
- WRDS (Wharton Research Data Services), DealScan Syndicated Loans Database. Accessed 2026.
- WRDS (Wharton Research Data Services), Preqin Private Capital Database. Accessed 2026.
- U.S. Energy Information Administration (2025), Form EIA-860 and EIA-923.
- Lawrence Berkeley National Laboratory (2025), Utility-Scale Solar and Wind Data Updates.
- U.S. EPA (2025), Emissions & Generation Resource Integrated Database (eGRID).
- Lazard (2024), Lazard's Levelized Cost of Energy Analysis — Version 17.0.
- U.S. Energy Information Administration (2025), Annual Energy Outlook (AEO 2025).
- Clean Energy Buyers Alliance (CEBA) (2025), Deal Tracker: Corporate Clean Energy Procurement.
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: March 2026 | Version 3.0 | RenewTrack North America