Renewable Energy Financial Model

Comprehensive financial model designed for analyzing renewable energy projects, such as solar or wind farms. It can be a useful tool for stakeholders, offering a structured framework to assess various scenarios and make informed decisions to check the financial viability and risks associated with the project over its construction and operation phases.

Renewable Energy Financial Model
, , ,
, , , , , , , , , , , , , , , , , , , , , , ,

Inputs:

  • Ability to build and compare up to 10 different scenarios.
  • Two input tabs: one for non-time-dependent inputs and another for time-dependent inputs.

Calculations:

  • Operations:
    • Revenue: Analysis of revenue streams from contracted and uncontracted Power Purchase Agreements (PPAs), as well as merchant sales.
    • Opex: Analysis of fixed costs (e.g., grid fees, operations and maintenance expenses, insurance) as well as variable costs (e.g., grid charges).
  • Debt:
    • Calculation of interest payments and debt repayments.
  • Equity:
    • Analysis of dividends and returns.
  • Tax & Depreciation (T&D):
    • Computation of taxes payable, deferred taxes, and treatment of tax losses.

Output:

  • Financial Statements: Profit and Loss (P&L), Balance Sheet, and Cash Flow statements
  • Sensitivities: Visualization of variations against the base case concerning Revenue, Opex, EBITDA, Debt Service, and Dividends.
  • Graphs: Revenue and Opex breakdown, Capex profile, and Funding mix analysis

Model Features:

  • Monthly construction phase followed by quarterly operational periods.

Purpose of the Model:

  • Facilitating financial analysis and decision-making for renewable energy projects by providing insights into their financial viability and associated risks across both construction and operation phases.

File Types: .xlsx and .pdf

You must log in to submit a review.