Solar + BESS Project Finance Model Pro (ITC & MACRS)

Battery Energy Storage Systems (BESS), Financial Model, Infrastructure, Renewable Energy, Solar

10-year Financial Projections, Cash Flow Analysis, Dashboard, DCF Model, Debt Schedule, Debt Service Coverage, Excel, Financial Analysis, Financial Model, Financial Modeling, Financial modelling, Financial Planning, Financial Projections, Financial Reporting, Financial Statements, IRR (Internal Rate of Return), LLCR (Loan Life Coverage Ratio), NPV (Net Present Value), PLCR (Project Life Coverage Ratio), Private Equity Waterfall Distribution Models, Project Finance, Scenario Analysis, Sensitivity Analysis, Three Statement Model | Three Financial Statements, Uses and Sources of Funds, WACC (Weighted Average Cost of Capital)

Overview

FinModelAI Solar + BESS Project Finance Model Pro is an institutional-grade Excel template purpose-built for modeling the full project lifecycle of a utility-scale solar photovoltaic facility co-located with a Battery Energy Storage System (BESS) — from greenfield construction through 10-year operations and exit. Whether you are underwriting a standalone solar PV project, a solar+storage hybrid, or a merchant energy storage play, this model provides the analytical rigor that tax equity investors, lenders, infrastructure funds, and development teams require.

The model covers 10-year projections across 14 fully linked worksheets, with approximately 1,400 auto-calculating formulas, zero macros, and zero circular references. It delivers three complete financial statements, a detailed construction budget with S-curve draws, a fully parameterizable debt structure (including construction-to-permanent loan with IO period and optional refi), a GP/LP equity waterfall, a DCF valuation with dual exit, and an executive dashboard — all driven from a single Assumptions tab.

Why This Solar Financial Model

Most renewable energy models available online treat solar as a simple revenue-times-price spreadsheet. This model was built from first principles with utility-scale solar and battery storage fundamentals at its core:

• Generation with annual degradation modeled explicitly — energy output declines year over year as panels age, impacting every revenue stream automatically
• Five distinct revenue streams — PPA (70% of revenue at base case), merchant/spot sales, BESS arbitrage revenue, capacity payments, and REC (Renewable Energy Certificate) sales — reflecting how modern solar+storage projects are actually contracted, dispatched, and monetized
• ITC (Investment Tax Credit) at 30% fully modeled and monetizable, with a toggle to enable or disable — critical for any US renewable project underwrite
• True MACRS 5-year depreciation with the 50% ITC basis reduction — when the ITC is claimed, the depreciable basis is reduced by half of the credit, exactly as US tax rules require — plus a parameterizable bonus depreciation rate. This is what separates a US-grade after-tax model from a pre-tax cash-flow sheet
• BESS augmentation capex in Year 8 to restore degraded battery capacity, modeled as a separate capex event with its own financing assumptions
• Construction S-curve with IDC (Interest During Construction) capitalized and flowing to the Balance Sheet automatically
• Construction-to-permanent loan with IO period and optional refinancing event — the actual financing structure used in project finance
• Full 3-statement integration (P&L, Cash Flow, Balance Sheet) with automatic balance check — not just a cash flow IRR model
• GP/LP equity waterfall with preferred return and two IRR-based promote tiers reflecting infrastructure JV economics

What’s Inside (Tab by Tab)

1) START HERE — Workflow guide, color code legend (blue = inputs, black = formulas, green = cross-sheet links), model structure overview, and key assumptions summary. Start here before touching anything else.

2) Dashboard — Executive summary with 4 auto-updating charts: annual energy generation and degradation curve, revenue by stream over time, DSCR covenant visualization, and project cash flow waterfall. Key metrics displayed at a glance: Project IRR, Equity IRR, MOIC, LP IRR, NPV, and Yield on Cost.

3) Assumptions — Centralized input hub for all model drivers: solar capacity (MWac, MWdc, DC:AC ratio), BESS capacity (MW/MWh), PPA rate and contract term, merchant price curve, BESS arbitrage spread, capacity payment rate, REC price and volume, degradation rate, ITC toggle and rate, MACRS schedule and bonus depreciation rate, tax rate, construction timeline, financing terms (construction loan, permanent debt, IO period, refinancing), equity structure (GP/LP split, preferred return, promote hurdles), WACC, and DCF parameters. All blue cells, all in one place.

4) Construction — Monthly construction budget with S-curve cost distribution across solar EPC, BESS EPC, balance of plant, soft costs, and financing costs. IDC is capitalized and flows automatically to the Balance Sheet. Includes the Year 8 BESS augmentation capex as a separate scheduled event.

5) Revenue — Five revenue stream build-up: (1) PPA revenue ($/MWh × contracted generation), (2) Merchant/spot revenue on uncontracted output, (3) BESS arbitrage revenue (charge/discharge spread × cycles), (4) Capacity payments ($/kW-year), and (5) REC (Renewable Energy Certificate) sales ($/MWh of qualifying generation). Generation modeled year by year with configurable annual degradation rate applied from Year 1 onward.

6) Opex — Operating expense model including O&M (fixed $/MW-year and variable $/MWh), land lease, insurance, asset management fees, transmission/interconnection charges, and general & administrative. Supports cost escalation assumptions throughout the projection period.

7) Debt — Construction loan draws and repayment, permanent debt takeout at commercial operation date (COD), interest-only period (parameterizable length), optional refinancing event, and annual DSCR (Debt Service Coverage Ratio) tracking with minimum DSCR covenant visualization.

8) P&L — Full Income Statement from revenue through EBITDA, depreciation, EBIT, interest expense, pre-tax income, taxes, and net income. Depreciation runs a true MACRS 5-year schedule on a basis reduced by 50% of the ITC when the credit is claimed (per US tax rules), plus a parameterizable bonus depreciation rate. Book and tax depreciation are tracked separately so the after-tax answer is correct. Automatically linked from Revenue, Opex, and the tax schedule.

9) Cash Flow — Operating cash flow, investing cash flow (construction capex, BESS augmentation capex, maintenance capex), financing cash flow (debt draws/repayments, ITC proceeds, equity contributions/distributions), and free cash flow to equity. Feeds the Balance Sheet automatically.

10) Balance Sheet — Fully integrated balance sheet with assets (capitalized construction costs, PP&E net of depreciation, ITC receivable), liabilities (debt schedule), and equity (contributed capital, retained earnings). Automatic balance check displayed on every period — must equal zero.

11) Returns — Project-level and equity-level return analysis: Project IRR, Equity IRR (unlevered and levered), MOIC, Cash Yield, and Yield on Cost. GP/LP equity waterfall with preferred return and two IRR-based promote tiers showing GP economics and LP net returns.

12) DCF — Discounted Cash Flow valuation with dual exit methodology: (1) EV/EBITDA exit multiple applied to Year 10 EBITDA and (2) LCOE-implied asset value. WACC calculation included. Outputs NPV and implied equity value under each exit scenario.

13) Sensitivity — Two live sensitivity tables (formula-based, no Excel Data Tables required): (1) Project IRR vs PPA Rate and Capacity Factor, (2) Equity IRR vs Leverage and ITC Toggle. Base / Bull / Bear scenario toggle built into Assumptions tab.

14) Glossary — Solar and project finance terms defined: PPA, BESS, ITC, MACRS, bonus depreciation, ITC basis reduction, REC, DSCR, COD, degradation rate, capacity factor, merchant revenue, arbitrage spread, capacity payment, IRR, MOIC, DCF, WACC, and more.

Key Outputs

Metric Demo Scenario (Base Case) Project IRR 11.1% Equity IRR (Levered) 27.5% MOIC 3.56x LP Net IRR 25.1% NPV +$31.9M @ 7.5% WACC Yield on Cost 10.0% Min DSCR 1.91x Solar Capacity 100 MWac BESS Capacity 25 MW / 4-hour (100 MWh) Total Capex ~$136.6M

Who It’s For

• Renewable energy infrastructure funds and PE sponsors underwriting utility-scale solar and solar+storage investments
• Independent Power Producers (IPPs) and project developers building financial models for lender presentations, tax equity partners, and LP decks
• Investment banks and financial advisors structuring project finance transactions for solar and BESS assets
• Tax equity investors evaluating ITC monetization and after-tax return impact
• Lenders and credit analysts sizing debt, stress-testing DSCR coverage, and evaluating construction loan risk
• Offtakers and corporate sustainability teams evaluating PPA economics and long-term energy cost modeling
• MBA students and energy finance analysts learning renewable project finance and 3-statement modeling

What Makes It Different

US Tax Treatment Is the Real Differentiator (ITC + MACRS) — This is what sets the model apart from the competition. The 30% ITC is modeled as a monetizable credit that reduces the equity capital requirement at COD, with an on/off toggle so you can compare tax-equity economics against a no-credit case. Crucially, depreciation runs a true MACRS 5-year schedule on a basis reduced by 50% of the ITC — the actual US tax mechanic — plus a parameterizable bonus depreciation rate. Many solar+storage templates on the market model neither the ITC nor MACRS depreciation; on a US deal those two levers move the equity return more than almost any operational assumption.

REC Revenue Stream Added — Renewable Energy Certificate sales are modeled as a distinct revenue line ($/MWh of qualifying generation), capturing a real monetization channel that many solar templates omit entirely.

BESS Co-Located with Solar — Not Bolted On — The BESS is modeled as an integral component of the project, not as a separate spreadsheet or add-on. BESS capex, augmentation in Year 8, arbitrage revenue, and capacity payments all flow through the same set of financial statements, the same debt schedule, and the same waterfall as the solar asset.

Five Revenue Streams with Generation Degradation — PPA, merchant, BESS arbitrage, capacity payments, and REC sales are each modeled independently with separate pricing, volume, and contract assumptions. Annual panel degradation flows through every revenue stream automatically — not just a static annual adjustment.

Construction Loan + Permanent Takeout + IO Period — The debt structure follows how solar projects are actually financed: a construction facility with monthly draws, takeout to permanent debt at COD, a parameterizable IO period, and an optional refinancing event. All of this feeds the Cash Flow and Balance Sheet automatically.

Full 3-Statement Integration with Balance Check — Most project finance models stop at IRR. This model includes a fully linked P&L (with true MACRS depreciation net of ITC basis reduction), Cash Flow Statement, and Balance Sheet with an automatic balance check on every period. No black boxes.

GP/LP Waterfall with Dual Promote — The waterfall models the preferred return, return of capital, and two IRR-based promote tiers that reflect how infrastructure PE funds and family offices structure renewable energy JV economics.

Sensitivity Without Data Tables — Both sensitivity tables are formula-driven rather than Excel Data Table-dependent, ensuring full compatibility across Excel versions, operating systems, and shared workbooks.

Technical Notes / Compatibility

• Built for Microsoft Excel (Windows and Mac)
• No VBA / macros, no circular references
• Approximately 1,400 auto-calculating formulas, zero formula errors
• Automatic balance check (must equal zero every period)
• Compatible with Google Sheets (some charts may render differently)
• Currency and start year are parameterizable from the Assumptions tab

Files Included

• 1 Excel file: FinModelAI_SolarBESS_Pro.xlsx
• START HERE tab + Glossary included inside the workbook

Disclaimer

This template is provided for educational and analytical purposes only. It does not constitute financial, investment, legal, or engineering advice. Users are responsible for verifying all assumptions and outputs against project-specific data. Consult qualified professionals before making investment or financing decisions.