Solar Energy Financial Model

The Solar Energy Financial Model forecasts the expected financials for a Solar Park project and calculates the project’s IRR and NPV.

Solar Energy Financial Model
, ,
, , , , , , , ,

The Solar Energy Financial Model forecasts the expected financials for a Solar Park project and calculates the IRR for the Project, Equity Investors and the Project’s NPV.

The model template includes:

  • Executive Summary section with charts, key financials and the main assumptions of the solar solar park
  • Key assumptions include:
    • Installed capacity
    • Yearly yield degression factor
    • Lifespan of the project
    • Hours of sunlight captured per year
    • Pricing model with two sources of revenues
      • Market price for electricity
      • Premium for Solar Energy Certificate
  • Yearly financial projections and projected Financial Statements (Income Statement, Balance Sheet and Cash Flow Statement)
  • Debt schedule which models two layers of financial debt (junior and senior debt)
  • Fixed asset depreciation schedule
  • Forecasted financial ratios such as Debt/EBITDA, Debt Service Coverage Ratio (DSCR), current ratio, ROE, ROIC
  • Net Present Value (NPV) via the Discounted Free Cash Flow (DCF) method
  • Payback period based on Free Cash Flows to Firm (FCFF)
  • Project IRR and Equity IRR
  • Reader and print-friendly layout including charts and graphs
  • Bidding Price Calculator and Sensitivity table (for Premium Excel Version only)

The Solar Energy Financial Model provides an simple framework to quickly analyze the financial feasibility of a solar park project. The worksheet allows to evaluate the effect of any change in the assumptions on the IRRs and NPV and engineer an appropriate financing structure for a Solar Park Project. A walk-through of the model is provided here:

 

 

The model is available in four versions, a PDF Demo Version of the Full Excel Version, the Full Excel Version with all cells editable, Premium PDF Demo Version, and the Premium Excel Version. The current version of the model is 4.1 for Full Excel Version and 4.2 for the Premium Excel Version.

Filetypes:

  • PDF Adobe Acrobat Reader
  • .xlsx (Microsoft Excel)

 

Add to wish list
Purchase Excluding 0% tax
Solar Park Financial Model Summary
Solar Park Financial Model Summary
Solar Park Cash Flow Statement
Solar Park Cash Flow Statement
Solar Park Balance Sheet
Solar Park Balance Sheet
Solar Park Energy Production
Solar Park Energy Production
Solar Park Income Statement
Solar Park Income Statement

 

The following Sensitivity tables are only available in the Premium Excel Version:

Solar Park Sensitivity Analysis
Solar Park Sensitivity Analysis (Premium Version only)
Solar Park Sensitivity Analysis
Solar Park Sensitivity Analysis for Bidding Price (Premium Version only)

 

 

 

Users who purchased Solar Energy Financial Model, also purchased:
Mortgage vs Rent Template
Add to wish list
Purchase Excluding 0% tax
Start Up Solar Farm Excel Model and Valuation
Add to wish list
Purchase Excluding 0% tax
Excel Calculator: Invest Now or Pay Off Debt
Add to wish list
Purchase Excluding 0% tax

Reviews

  • Avatar Missing ITC

    You can not have a complete Solar Model in 2019 without including ITC and state incentives. Also I prefer to have all inputs on an Inputs tab and not search for them all

    1 of 2 people found this review helpful.

    Help other customers find the most helpful reviews

    Did you find this review helpful? Yes No

    • 박중완

      Thank you greatly for your feedback! As for why we didn't include the ITC and State incentives, it's because this template is not only for the USA. Plus, this is only a template which you can easily customize according to your specifications.

      1 of 2 people found this review helpful.

      Help other customers find the most helpful reviews

      Did you find this review helpful? Yes No

  • Avatar Solar Energy Financial Model

    Can this model be use for an off-grid solar project?

    1 of 2 people found this review helpful.

    Help other customers find the most helpful reviews

    Did you find this review helpful? Yes No

  • Avatar Great Support

    I had some initial difficulties with the solar model but thanks to some very prompt and helpful email support I got passed the initial issues. Thanks!

    1 of 2 people found this review helpful.

    Help other customers find the most helpful reviews

    Did you find this review helpful? Yes No

  • Avatar Question about the type

    Great Model .. is this model about : 1- photovoltaic method or 2-
    concentrated solar power method ?

    1 of 2 people found this review helpful.

    Help other customers find the most helpful reviews

    Did you find this review helpful? Yes No

    • 박중완

      Hi there, the solar energy financial model is about the photovoltaic method using solar modules to generate electricity. Normally these are installed on a field or on a rooftop of a building and the energy is fed into the energy grid.

      1 of 2 people found this review helpful.

      Help other customers find the most helpful reviews

      Did you find this review helpful? Yes No

      • Is it possible to make a model for the mother method ? i.e. : concentrated solar power method ?

        Thank you for your feedback.

  • Write a Review

    Get these templates too for a discount!

    Price: $140.00

    This is a collection of selected renewable energy model templates which are set in a bundle which will help you…

    Add to wish list
    Add to cart Excluding 0% tax

    Price: $99.00

    This is a collection of financial model templates related to real estate.

    Add to wish list
    Add to cart Excluding 0% tax

    Price: $112.00

    This is a collection of financial model templates for projects or ventures in the Renewable Energy Industry and its related…

    Add to wish list
    Add to cart Excluding 0% tax