Solar Energy Power Plant Financial Model

Description
This Solar Power Plant Financial Model template will help you estimates the Solar project’s finances and determines earnings and returns. The Excel spreadsheet model is made to help you better understand whether your upcoming Photovoltaic (PV) park project is financially feasible.
The solar PV model provides a flexible tool to run scenarios by modifying the input assumption and produces the key essential financial ratios as required by investors and banks to understand the solar energy project. A Three Statement Model, including Income Statement, Balance Sheet, and Cash Flow Statement forecasts for up to 30 years, is part of the solar project finance model.
The financial model template includes an executive summary section with graphics, major financial summaries, and the solar park’s primary assumptions.
Important presumptions to use are:
I-Installed power in kiloWatt or Mega Watt terms
-Monthly solar output
-Annual yield degression coefficient
-Years of the project’s lifecycle
-Phasing strategy to mimic a phased construction strategy
-Revenue streams
-Model 1: Power Purchase Agreements (PPAs) for the sale of energy
-Model 2: Energy Sold at Market Rate Plus Potential Premium From Sale of Certificate
-Pricing suppositions include the starting price, annual price increases/decreases, and pricing assumptions for each revenue model.
-Years of PPA/Certified CAPEX Assumptions Duration
-Operations and Maintenance Cost projections (to be entered as either set sums or as a percentage of revenues, cost per kWh)
-Phase Debt projections, such as loan amounts, interest rates, and payback schedules
-Discount Rate or Weighted Average Cost of Capital (WACC)
-Comprehensive annual computation of volumes, prices, etc.
-For a period of 30 years into the future, financial tables with predicted income statements, balance sheets, and cash flow statements are provided.
-Debt schedule that simulates the drawdowns, repayments, and interest on two levels of financial debt (junior and senior debt)
-Schedule for depreciating fixed assets
-Tables with projected yearly financial statistics, such as Debt/EBITDA, LTV, Debt Service Coverage Ratio (DSCR), Interest Coverage statistics, etc., that are important to banks and investors.
-Leveraged and Unlevered Free Cash Flow Calculation
-Calculation of Project Metrics Relevant to Financial Feasibility Analysis and Project Finance, such as Total Profits, Investment Multiples, and IRRs for Unlevered and Levered Returns
-Calculating the Project Payback Period’s Net Present Value (NPV)
-Uses and Sources of Fund table Calculation of Required Equity Funding Amount
Please reach out to us in case of any queries or help regarding the working of the model. Your feedback is valuable to us and helps us to develop better products.