Solar PV Project and Tax Equity Financial Excel Model
Originally published: 19/02/2019 07:38
Last version published: 01/09/2021 08:52
Publication number: ELQ-47207-7
View all versions & Certificate

Solar PV Project and Tax Equity Financial Excel Model

A full & professional 17 sheets Solar PV project and tax equity finance mode in Microsoft Excel.

Get 33% discount with code "RENEW33"


This Solar PV (photovoltaic) Project Finance Excel Model Template was created in Microsoft Excel and consists of 17 separate sheets. It is ideal for anyone evaluating Solar Project in USA. The model has capacity to calculate returns for a tax efficient investor as well as for any company using third party tax equity.

The Model’s building blocks are distributed between Summary sheets (Dashboard), input sheets, calculation sheets and output sheets.

Model inputs

All the green tabs are model input sheets. The model has a capability to run 8 different scenario or 8 different projects in the single workbook. It can also combine all the 8 projects and create a portfolio summary report, where one can see individual project return as well as project return on a portfolio basis. Further, it gives the flexibility to include or exclude certain project in the portfolio.

The Model also allows you to pinput project cost in 2 ways; 1 - high level and 2 - detailed. further the model has a feature to determine an automatic spend schedule which will follow a S-Curve. alternatively you can also use a manual spend schedule.
The Start page of the model is a readme sheet where all the details about operating this model is highlighted.

Model Outputs

Lenders and Credit analysis
Lenders main concern is whether the future cash flows of the project are sufficient to fund operating costs and the debt service. The following metrics can answer these questions:
DSCR – debt service coverage ratio
Maximum, minimum and average Periodic Senior DSCR
Investor Return
Equity IRR

Questions answered by “Solar PV Project Finance Model”

• What is the impact of paying an acquisition fee in tranches during the development and construction stage.
• What is the impact of receiving the development fees in different tranches during construction?
• What are the expected return to project developers?
• What are the expected return to equity providers?
• Does cash flow meet debt service requirements?

Model functionality
In order to operate the Model, please ensure that the VBA add-ins are enabled.

There are multiple macros which can be used to carry out various function of the model, of which 3 important macro are provided in the input sheet which is essential to carry out accurate analysis.
1. Circularities – this macro will take care of circularities due to IDC
2. Debt sizing – this macro will take care of sizing the debt for the project based on few criteria
3. Tax equity – this macro will accurately calculate after tax returns of tax equity investor and sponsor
4. Apart from above there are another macro which will help in generating a portfolio report.

This Best Practice includes
1 Excel Workbook

Acquire business license for $299.00

Add to cart

Add to bookmarks



  • Rate this Downloadable Best Practice

    Write a review

  • Agron Shapllo(last updated: 01/02/2021 18:14)
  • Edmon Rakipi(last updated: 03/09/2020 15:50)
  • Aarav Gupta(last updated: 15/04/2020 14:28)
    Efficient and accurate financial model
    Perfect for analyzing solar project in US, covers Tax equity in detail and also flexible enough to run numerous scenario and projects


Discussion feed for Solar PV Project And Tax Equity Financial Excel Model

The user community and author are here to help. Go ahead!

  • Peter B
    Macros // Do you allow users to see the macro / VBA for all that are used?
    arrow_drop_uparrow_drop_downReply reply
    • MACH BS
      Yes. Once you have the tool, you can access the Macros from the Developer tab.
      arrow_drop_uparrow_drop_downReply reply
    • Tomoichi Yamaguchi
      Is it possible to use it for Indonesian IPP project?
      arrow_drop_uparrow_drop_downReply reply
      • MACH BS
        No, this is specific for US projects. If you are interested in Indonesian IPP, i already have a model analysing Indonesian thermal project. Let me know if you are interested. i can upload that tool here for you to download.
        arrow_drop_uparrow_drop_downReply reply
      • Kirkland Allen,  CPA
        What support is offered post purchase to ensure that the user has a solid foundation for getting the most out of the model? Bought one for a global project. Had tons of questions with nowhere to turn. We're evaluating installing a 30 acre farm in rural GA.
        arrow_drop_uparrow_drop_downReply reply
        • MACH BS
          Apologies for delay. I am also a consultant, so if you have questions about the model which i can answer quickly, happy to do that. If you want me to walk you through or if you want me to run the model for you, you can hire me as a consultant.
          arrow_drop_uparrow_drop_downReply reply
        • MACH BS
          * comment deleted *
          1arrow_drop_uparrow_drop_downReply reply

          5.0 / 5 (3 votes)

          please wait...