Pivotal180

Course instructions

Downloads

0.1 Best Practice - Principles

0.2 Best Practice Formulas

0.3 Best Practice - Flags and Conditional Formats

0.4 Best Practice - Styles

0.5 Best Practice - Accounts

0.6 Data Validation

0.7 Named Ranges

0.8 MWT - Model Familiarization

0.9 Model Checks

Precourse chapter slides

Precourse Downloads

Glossary of Terms

Microsoft Excel Shortcuts Key

1.1 Model walk-through (MWT) instructions

1.2 MWT (S1) - SPV calculation overview

1.3 US Depreciation

1.4 Tax - assembling the pieces

1.5 MWT (S2) - Project level tax and accounting depreciation

1.6 Intro to US Tax Credits

1.7 US Tax Credits (ITC)

1.8 US Tax Credits (PTC)

1.9 US Tax Credit Structure

1.10 Prevailing wage & apprenticeship

1.11 Domestic content

1.12 Energy community

1.13 Low-income communities

1.14 MWT (S3) - US tax credit modeling

1.15 Fair Market Value (FMV)

1.16 Project benefits

1.17 MWT (S4) - Summary of project level benefits

1.18 IRA Introduction

1.19 Chapter 1 Quiz

Chapter 1 slides

Chapter 1 Downloads (including MWT)

2.1 Introduction to tax equity and back-leverage

2.2 Disproportionate allocations

2.3 MWT (S5) - Disproportionate allocation calculations

2.4 MWT (S6) - Initial returns to tax equity investors

2.5 Changing the Scenario Input from Any Sheet

2.6 Overall back-leverage structure example (demo)

2.7 Linear, mortgage style, and DSCR sculpted repayment types

2.8 DSCR sculpting demo

2.9 DSCR debt sizing (part 1) - fixed interest rate

2.10 MWT (S7) - Back-leverage debt repayments and debt sizing

2.11 Net operating losses carried forward

2.12 MWT (S8) - Sponsor tax calculations

2.13 MWT (S9) - Sponsor returns

2.14 Sensitivities and Scenarios

2.15 Data Tables

2.16 MWT (S9b) - Initial model sensitivities

2.17 Chapter 2 Quiz

Chapter 2 slides

Chapter 2 Downloads (including MWT)

3.1 Introduction to partnership capital accounts

3.2 MWT (S10) - Total partnership capital account

3.3 Tax equity s704(b) capital account

3.4 MWT (S11) - s704(b) tax capital account (part 1, introduction)

3.5 Tax equity s704(b) capital account reallocations

3.6 MWT (S12) - s704(b) tax capital account (part 2, reallocations)

3.7 Tax equity s704(b) capital account DROs

3.8 MWT (S13) - s704(b) tax capital account (part 3, DRO)

3.9 Tax equity s704(b) sponsor capital account and checks

3.10 MWT (S14) - s704(b) sponsor tax capital account

3.11 Chapter 3 Quiz

Chapter 3 slides

Chapter 3 Downloads (including MWT)

4.1 Outside basis tax capital accounts

4.2 MWT (S15) - Tax equity outside basis capital account

4.3 Tax capital accounts interim summary

4.4 MWT (S16) - Sponsor equity outside basis capital account

4.5 Chapter 4 Quiz

Chapter 4 slides

Chapter 4 Downloads (including MWT)