5 Excel Mistakes That Kill Solar + Storage Project Finances (And How to Fix Them)
You've built the model. The numbers look great. IRR hits your hurdle rate, DSCR clears the lender covenant, and NPV is positive. You send it to the investment committee.
Then someone asks: "Did you account for the step-up in O&M after year 5?"
And your model falls apart.
We've seen dozens of solar + storage financial models — built by experienced developers, consultants, and analysts. The same mistakes show up again and again. Not because people are bad at Excel. Because renewable energy finance has specific traps that general financial modeling doesn't prepare you for.
Here are 5 mistakes that quietly destroy project returns — and how to fix each one.
Mistake 1: Using Flat O&M Assumptions
The problem: Most models assume solar O&M stays constant at $15/kW-year for 25 years. In reality, O&M costs have escalation clauses, inverter replacements at years 10-12, and major maintenance events that spike costs by 40-60%.
What happens: Your Year 15 cash flow is 20-30% lower than modeled. DSCR drops below 1.0x. Debt service coverage fails.
The fix: Build an O&M schedule that includes:
- Base O&M with annual escalation (2-3%)
- Inverter replacement at years 10-12 (budget $0.05-0.08/W)
- Battery augmentation at year 10 (budget 15-20% of initial battery cost)
- Major maintenance reserves ($2-4/kW-year starting year 8)
Year 1-5: Base O&M × (1 + escalation)^year
Year 6-10: Base O&M × (1 + escalation)^year + maintenance reserve
Year 11-12: Above + inverter replacement amortized over 2 years
Year 13+: Above + battery augmentation reserve
Why it matters: A 25-year model with flat O&M overstates project returns by 200-400 bps of IRR. That's the difference between "funded" and "passed."
Mistake 2: Applying the ITC to Total CapEx Instead of Eligible CapEx
The problem: The 30% Investment Tax Credit (ITC) applies to eligible costs, not your total project budget. Interconnection costs, grid upgrades, and certain soft costs may not qualify. And the ITC basis rules changed significantly under the Inflation Reduction Act.
What happens: You overstate the tax credit by 10-20% of actual eligible basis. Your equity check is higher than modeled. Returns come in below expectations.
The fix: Separate your CapEx schedule into ITC-eligible and non-eligible categories:
| Cost Category | ITC Eligible? | Notes |
|---|---|---|
| Modules, inverters, racking | ✅ Yes | Core equipment |
| Battery system | ✅ Yes | If paired with solar (standby rules apply) |
| Installation labor | ✅ Yes | Direct installation costs |
| Interconnection & grid upgrades | ⚠️ Partial | Utility-specific rules apply |
| Development fees | ❌ No | Not direct equipment/install |
| Financing costs | ❌ No | Not eligible |
| Land acquisition | ❌ No | Not eligible |
For 2026+ projects, also model:
- Domestic content bonus: +10% ITC (40% total) for US-made equipment
- Energy community bonus: +10% ITC for projects in qualified communities
- Low-income bonus: +10-20% ITC for qualifying community solar
Why it matters: On a $100M project, a 5% ITC basis error = $1.5M less tax credit. That's real money.
Mistake 3: Ignoring Battery Degradation in Revenue Projections
The problem: You model a 4-hour battery at 100% capacity for 25 years. In reality, lithium-ion batteries degrade 2-3% per year, and you lose capacity long before the project ends.
What happens: Your arbitrage revenue model assumes 4 hours of discharge every day for 25 years. Actual discharge duration drops to ~3.2 hours by year 15 and ~2.5 hours by year 20. Revenue from capacity payments and energy arbitrage drops accordingly.
The fix: Build a degradation schedule into your revenue model:
Year 1: 100% capacity → 4.0 hours discharge → full revenue
Year 5: 88% capacity → 3.5 hours discharge → ~88% revenue
Year 10: 78% capacity → 3.1 hours discharge → ~78% revenue
Year 15: 70% capacity → 2.8 hours discharge → ~70% revenue
Year 20: 64% capacity → 2.5 hours discharge → ~64% revenue
And model augmentation:
- Budget for a cell replacement or augmentation at year 10-12
- This restores capacity to ~90% and extends economic life
- Cost: typically 40-50% of original battery cost (prices dropping ~8%/year)
Why it matters: Ignoring degradation overstates cumulative battery revenue by 25-35% over project life. For a project counting on storage revenue for debt service, this is existential.
Mistake 4: Using a Single Discount Rate Instead of a Term Structure
The problem: You discount all cash flows at 8% (or 10%, or your WACC). But renewable energy projects have dramatically different risk profiles in years 1-5 (construction + ramp-up) vs years 15-25 (technology + market risk).
What happens: You overvalue long-dated cash flows and undervalue near-term construction risk. Your NPV looks better than it should, especially for merchant tail revenue.
The fix: Use a risk-adjusted discount rate schedule:
| Period | Risk Profile | Discount Rate |
|---|---|---|
| Construction (years 0-2) | High — cost overruns, delays, permit risk | 12-15% |
| Ramp-up (years 3-5) | Medium — production variance, offtake risk | 9-11% |
| Stable PPA (years 6-15) | Low — contracted revenue, known costs | 7-9% |
| Merchant tail (years 16-25) | High — market price risk, recontracting | 10-14% |
For the discount rate nerds: this is equivalent to using a risk-adjusted NPV approach where each cash flow bucket gets its own risk premium. It's standard in project finance but rarely done in spreadsheet models.
Why it matters: A single 8% discount rate on a 25-year solar project produces an NPV that's 15-25% higher than a properly risk-adjusted model. That's the difference between "green light" and "needs more equity."
Mistake 5: Hardcoding Debt Sizing Instead of Using DSCR Constraints
The problem: You set debt at 60% of CapEx because "that's what lenders offer." But debt sizing in project finance is driven by DSCR — not LTV. A project with strong cash flows can support more debt than one with weak cash flows, regardless of the CapEx ratio.
What happens: You leave money on the table. A project that could support 65% debt at 1.30x DSCR is modeled at 55% debt because you hard-coded a conservative ratio. Your equity return is lower than it should be.
The fix: Size debt from the bottom up using minimum DSCR:
For each year of the debt tenor:
Max Debt Service = Cash Flow Available for Debt Service / Min DSCR
Max Annual Debt Service = Minimum across all years
Max Debt = PV of Max Annual Debt Service at the lending rate
Debt Ratio = Max Debt / Total CapEx
This gives you the maximum debt the project can support while maintaining your DSCR covenant. If the resulting ratio is above 50%, lenders will generally be comfortable.
Key inputs that affect debt sizing:
- Minimum DSCR: 1.20x for investment-grade offtake, 1.40x for merchant exposure
- Debt tenor: 15-18 years for solar, up to 20 for solar + storage with contracted revenue
- Interest rate: Current 5.5-7.5% for project finance debt
- Sculpting: Match debt service to cash flow shape (high year 1 = high payment, low year = low payment)
Why it matters: On a $100M project, optimizing debt sizing can add 200-500 bps to equity IRR. That's the difference between a deal that gets done and one that doesn't.
Want a Model That Gets These Right?
We built a financial model template specifically for solar + battery storage projects that handles all of these issues and more:
- Dynamic O&M schedules with escalation, replacement reserves, and augmentation
- ITC calculation engine with domestic content, energy community, and low-income bonuses
- Battery degradation model with augmentation timing and cost
- Risk-adjusted discount rates by period
- DSCR-based debt sizing with sculpting
- Sensitivity analysis on 12 key variables
- Investor-ready presentation outputs
🛠️ Solar + Storage Financial Model — $197 CAD on Gumroad
Includes: Excel model + playbook + 5 AI prompts for building project financials.
We're transparent: we're building tools for renewable energy developers and sharing what we learn. The model is built from real project finance experience, not generic templates.
What's the biggest modeling mistake you've seen in solar + storage projects? Drop a comment — I read every one.
Top comments (0)