This is an extract from our tax equity modeling course.
The input sheet includes all of the assumptions for our project, including scenario management and the macros required to optimize the size of our tax equity investment. The modeling includes calculations for both a wind project as well as for a you base flip and a fixed time based, often called a calculated flip for a solar project. The cons tab builds up the construction costs and calculates the funding required from the sponsor, from tax equity and from back leverage for our project. The SPV tab is where all of our operational project calculations are included. This includes the timing calculations i.e what year operations were in the generation, the sale of energy, cost and the summary of all of our project cash flows. It also includes the project level benefits derived from depreciation and tax credits, as well as a total summary of all benefits from the SPV and our undelivered returns. The partnerships tab includes the calculations allocating the different benefits between the sponsor and tax equity as well as the section 704 B tax capital accounts, and out outside basis tax capital accounts. It also includes a summary of the benefits to each partner after adjustments due to the capital accounts, the tax equity partner returns, and the analysis of the sponsored buyout option. Finally, we include a balance sheet for the total partnership. The sponsor tab includes everything from the whole core level up. This includes the benefits derive from the partnership, the back level loan, debt sculpting and sizing and our senior debt ratios. It also includes the sponsor tax calculations, for both a whole and a buyout scenario, as well as the returns to the sponsor. The HLBV tab includes the hypothetical liquidation at book value that’s the HLBV, required in order to calculate the book value to each partner. The Cap Acc sheet includes a summary of the section 704 B tax capital accounts, the outside basis tax capital accounts, and the HLBV accounts by partner. It also includes some important graphs of the capital account balances over time. Finally, our dashboard page includes all of the important outputs required to make an investment decision. And that’s the purpose of them all after all. Now, tax equity is not easy. It’s a really complicated subject. And we try and make it as easy as possible. But there’s still some assumed knowledge going into this course. It’s much harder than our renewable energy project financial modeling course. We assume in this course, that you already know how to size debt and sculpt debt, how to calculate net operating losses carried forward, how to run scenarios and how to create a basic macro to optimize a model. So if you don’t know that, we encourage you to look at the new energy project finance course.
– The order in which we’ll build this model is included in a PDF file called model checklist, which we strongly recommend that you download. The model checklist includes the order of each section that we’ll model with a checklist so you can tick off each item as you complete it. It also includes the name and number of the relevant lessons relating to the concepts required for that section to make it easier for you to find the corresponding videos if you wanna watch them. And it also includes each individual row that you’ll need to model in order. So it’s a fantastic guide if you want to rebuild the model yourself without guidance. Note that the shortcuts that we’re typing will also appear in the top right hand corner of the spreadsheet right next to the formula bar.