RenewTrack Methodology
Technical Documentation for Financial Models, Calculation Methods, and Data Quality Standards
1. Overview
RenewTrack tracks and analyses US grid-scale renewable energy project financings. The platform aggregates data from government registries, commercial databases (PitchBook, DealScan, Preqin), and corporate disclosures, then applies standardized calculation methodologies to produce benchmarking analytics for institutional investors, project finance lenders, and energy sector advisors.
This document covers the cash flow waterfall engine, benchmarking calculations, valuation models (FCFF, FCFE, APV), and confidence interval methodology. All financial calculations follow project finance conventions used by US infrastructure funds and development finance institutions; formulas, assumptions, and limitations are documented inline.
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 | Commercial database | Debt financing amounts, ~2,600 US records | Medium |
| DealScan | Institutional database | Syndicated loan terms, spreads, lender details | High |
| Preqin | Institutional database | 2,700+ 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, DealScan), 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 ~1,400 financings are marked as estimated. Estimated values are excluded from gearing benchmarking calculations to preserve statistical integrity. PitchBook and 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 quarterly, semi-annual (default), and annual periodicity. The model follows the standard project finance waterfall convention where each cash flow level is calculated sequentially across 13 steps:
1. Production = Capacity x Capacity Factor x Hours (adjusted for degradation, availability, losses) 2. Revenue = PPA Revenue + Merchant Revenue (with capture ratio and escalation) 3. OpEx = Fixed O&M + Variable O&M + Insurance + Land Lease + Grid Charges + Asset Management 4. EBITDA = Revenue - OpEx 5. Tax = max(0, (EBITDA - Depreciation) x Corporate Tax Rate) 6. Working Capital = Change in receivables, payables, and inventory 7. CFADS = EBITDA - Tax - Working Capital Changes 8. Senior Debt Service = Interest + Principal Repayment (sculpted, annuity, straight-line, or bullet) 9. DSCR = CFADS / Senior Debt Service 10. DSRA = Funding / Release of Debt Service Reserve Account 11. Mezzanine Debt Service (if applicable) = Mezz Interest + Mezz Principal 12. Cash Sweep (if applicable) = Excess Cash x Sweep % (subject to trigger DSCR and holiday) 13. Distributions = Residual cash available to equity after all senior and mezzanine claims
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
3.6 Cash Flow Available for Debt Service (CFADS) Definitions
RenewTrack uses three CFADS definitions, each appropriate for the analytical context in which it appears:
Debt Sizing: CFADS = Revenue - Operating Expenses Cash Flow Waterfall: CFADS = EBITDA +/- Tax Adjustments - Working Capital Changes DCF Valuation: CFADS = NOPAT + Depreciation (unlevered free cash flow)
These definitions reflect different industry conventions for different analytical purposes. Debt sizing uses a simplified CFADS appropriate for indicative sizing; the waterfall uses the full cash flow waterfall standard in project finance lending; the DCF uses unlevered free cash flow per standard corporate finance valuation.
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 (March 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 < 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. Note: The One Big Beautiful Bill Act (Public Law 119-21, July 2025) terminates ITC/PTC eligibility for wind and solar projects placed in service after December 31, 2027, unless construction begins before July 4, 2026 (with 4-year continuity safe harbor). Battery/storage, geothermal, nuclear, clean hydrogen (45V), and carbon capture (45Q) credits remain available through at least 2033 under OBBBA.
Base ITC = 6% of eligible project cost (or 30% with prevailing wage & apprenticeship)
Base PTC = $0.0055/kWh (or $0.0275/kWh with prevailing wage & apprenticeship)
Note: PTC $5.50/MWh = 1992 statutory base; inflation-adjusted 2025 = ~$6.00/MWh
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)
Note: Energy Community and Low-Income Community bonuses are mutually
exclusive per IRS guidance. The calculator currently allows stacking
both; users should select only the applicable adder for their project.
Technology Eligibility:
Solar: ITC or PTC -- taxpayer election
Wind: PTC preferred
Battery/BESS: ITC only -- standalone storage eligible post-IRA
Offshore Wind: ITC or PTC with enhanced base rates
For projects with BOC >= Jan 1, 2025: technology-neutral credits apply
ITC = Section 48E (replaces legacy Section 48)
PTC = Section 45Y (replaces legacy Section 45)
Rates and adders are unchanged; this is a statutory labeling change.
OBBBA Phase-Down (One Big Beautiful Bill Act, Public Law 119-21, signed July 4, 2025):
The OBBBA supersedes the original IRA phase-down schedule for wind and
solar. Credit availability is now determined by Beginning of Construction
(BOC) date. Battery/storage, geothermal, nuclear, clean hydrogen (45V),
carbon capture (45Q), and clean fuels credits remain through at least 2033.
BOC before July 4, 2026: 100% of full credit value
BOC July 4 – Dec 31, 2026: 80% of full credit value
BOC in 2027: 60% of full credit value
BOC in 2028: 40% of full credit value
BOC in 2029 or later: 0% (credits eliminated)
Placed-in-Service Deadlines:
Full-value projects (BOC < July 4, 2026): PIS by Dec 31, 2027
Phase-down projects: PIS within 4 years of BOC date
The calculator applies this phase-down automatically when a BOC date
is provided. The phase-down multiplier reduces both ITC and PTC values.
ITC Recapture (IRC §50(a)):
If property is disposed of or ceases to qualify within 5 years of PIS:
Year 1: 100% recapture | Year 2: 80% | Year 3: 60%
Year 4: 40% | Year 5: 20% | Year 6+: 0%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. Capacity factors in these examples represent national or regional averages and vary significantly by location: solar PV ranges from 10-14% in Northern Europe to 18-22% in Southern Europe (or 20-28% across the US Southwest), while onshore wind ranges from 22% in low-wind regions to 40%+ in the US Great Plains or Northern European coastal sites. Users should substitute site-specific capacity factors from resource assessments or historical generation data when modeling actual projects.
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; subject to OBBBA timeline -- see Section 5.3): ITC (30% with prevailing wage) = $80,000,000 x 30% = $24,000,000 OR PTC ($30.00/MWh x 10 years) = 196,880 x $30.00 = $5,906,400/yr Note: Wind/solar credits require BOC before July 4, 2026 and PIS by Dec 31, 2027 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; subject to OBBBA timeline -- see Section 5.3): PTC ($30.00/MWh x 10 years) = 311,790 x $30.00 = $9,353,700/yr Note: Wind credits require BOC before July 4, 2026 and PIS by Dec 31, 2027 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 ~1,400 financings have verified gearing data (both debt and total investment). PitchBook and 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.
- Refinitiv / LSEG, DealScan Syndicated Loans Database. Accessed 2026.
- 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