Tax Equity Financial Model for Renewable Energy Projects

$549+
0 ratings

Introduction:

The US Tax Credit and IRA-Ready Financial Model for Renewable Projects is an invaluable template designed for individuals seeking to evaluate the returns of renewable energy projects accounting for all the tax credits and incentives available in the USA, such as:

  • Incentive Tax Credit
  • Production Tax Credit
  • Investment Based Incentive
  • Capacity Based Investment
  • Production Based Investment
  • Bonus Depreciation
  • Federal and State Taxes

With this model, you can determine:

  1. Equity Internal Rate of Return (IRR),
  2. Net Present Value (NPV),
  3. Levelized Cost of Electricity (LCoE)  

This financial model is specifically designed for individuals who want a straightforward and user-friendly approach to analyze renewable energy projects particularly focused for USA based projects.

The model is divided into the following sheets:

  1. Inputs
  2. Cash Flow
  3. Debt
  4. Tax
  5. Incentives
  6. ITC
  7. Depreciation Calculations
  8. Depreciation Schedules
  9. Reserve Accounts
  10. Technical
  11. Timeline


The sheets included in the model.

The Inputs Sheet:

Period of Analysis: The number of years the analysis will run for.

Generation: The model allows the user to set the different values for generation per year in kWh and the in depreciation of the generation as %/year for different periods. 

In the example above, the generation is set for:

  • 876,000 KWh per year from years 1 to 10 with a degradation of 1%year
  • 880,00 KWh per year from years 11 to 21 with a degradation of 1%year, and
  • 875,000 KWh per year from years 21 to 30  with a degradation of 1%year.

CAPEX & OPEX: These can be added to the model as a function of:

  • Fixed cost per year: USD
  • Based on the installed capacity: USD/kW
  • Based on the energy produced: USD/kWh

The OPPEX can also be broken down in different periods and have individual escalations.

Revenues: The inputs for the revenues are shown in the figure below.

The "Other Revenues" fields are added individually for each one of the years.

Financial Parameters: Inflation, Insurances, property tax, and salvage values are the inputs of this sheet.

Debt: 

The model offers flexibility in determining the size of debt, allowing you to choose between two methods:

Percentage of Total Installed Cost:
Specify the debt size as a percentage of the total installed cost, inclusive of any additional fees and incentives. The annual debt-service coverage ratio (DSCR) varies from year to year.

Debt-Service Coverage Ratio (DSCR) & Debt Sculpted:
Specify the desired DSCR, and let the model calculate the debt size based on the annual cash available for debt service from the project cash flow. This approach ties the size of debt to annual revenue and operating costs rather than the total installed cost.

Amortization Methods: When the percentage of total installed costs is activated, there is the possibility to pay the principal either through:

  • Equal Payments: debt payments constant over the tenor of the debt
  • Fixed Principal, declining interest: constant principal payment size and reducing annual interest payment.

Construction Financing Calculation: To prevent circularity in the model and eliminate reliance on macros, the assumption governing the model posits that the entire construction balance remains outstanding for half of the construction period. This assumption aligns with a uniform monthly draw schedule, thereby yielding an average loan life equivalent to half of the construction period. If you need to simulate a different draw schedule, you have the option to adjust the loan's interest rate accordingly.

Tax & Depreciation: For tax, the user can input federal and state tax percentages. 

In the depreciation section, users can choose from various commonly utilized depreciation schedules in the USA, such as:

  • MACRS 5 & 15 years 
  • Straight Line 5, 15, 20, 39 years

If you need a specific depreciation, you can use the "Custom" input and define a schedule in %/year as per your requirements.

Reserve Accounts: The model has the following reserve accounts available:

  • Working Capital
  • Major Replacement Account

Tax Credits: Investment & Production Tax Credit at Federal and State levels.

Direct Cash Incentives: Investment Based Incentives, Capacity Based Incentive and Production Based Incentives.



$
I want this!
0 sales

Refund and Return

Due to the inherent nature of digital products and the impracticality of returning a digital file, we do not accept returns or refunds.

To ensure transparency, we strive to provide comprehensive information about our templates. This allows buyers to make informed decisions, understanding the content and anticipated use of the digital document before making a purchase.

If you have any inquiries about the product, please feel free to contact us before completing your transaction. We appreciate your understanding.

Last updated Nov 11, 2023

Size
708 KB
Copy product URL
$549+

Tax Equity Financial Model for Renewable Energy Projects

0 ratings
I want this!