Solar PV + Battery Storage Financial Model - EU Edition (Excel)

Description
Investor-grade Excel model for planning a solar PV installation with optional battery storage in Europe, designed to evaluate the 25-year life of a solar investment.


Model Inputs
Enter the following to generate a complete investment case:

• System size
  
• Installer quotes
  
• Yield study
  
• Tariffs
  
  
  

Core Features
The model includes a 25-year annual engine with:

• Production degradation over time
  
• Monthly year-1 seasonality
  
• Self-consumption savings and export revenue modelled separately
  
• Operating costs
  
• Inverter and battery replacements charged as capex in user-specified years
  
• Full annuity debt schedule
  
• Corporate tax with loss carryforward
  

Returns are expressed as:

• NPV
  
• Project IRR
  
• Equity IRR
  
• Payback period
  
• LCOE (Levelized Cost of Energy)
  
  
  

EU-Specific Features
The model incorporates EU-specific details:

• Capex-percentage grant schemes that automatically adjust financing and the depreciable base
  
• Per-kWh tariffs net of VAT
  
• Distinction between on-site consumption and export:
  
  • Every kWh consumed on-site saves the full retail electricity price
    
  • Exported kWh earn only the feed-in tariff, usually a fraction of the retail price
    
    
    

Flexibility

• Set battery capacity to zero for a PV-only case
  
• Model higher self-consumption share with storage
  
• One-click scenario engine (Base, Upside, Downside) with editable multipliers
  
• Sensitivity matrix across electricity price and self-consumption share for stress-testing
  
  
  

Transparency & Accessibility

• No macros, nothing locked
  
• Every formula visible and editable
  
• Compatible with:
  
  • Excel 2016+
    
  • Excel for Mac
    
  • Excel Online
    
  • LibreOffice
    
    
    

Documentation & Support

• Includes an illustrated User Guide and FAQ
  
• Free PDF preview showing every sheet before purchase
  
• All v1.x updates free to buyers
  
  
  

Typical Users

• Solar installers and EPCs preparing client proposals
  
• Commercial and industrial site owners
  
• Energy consultants
  
• Investors screening rooftop portfolios
  
• Applicants preparing grant or financing submissions