Pivotal180 Newsletter April 2021

By Alison Leckie | April 13, 2021

In this newsletter:

  • New Course! – VBA course launching in June 2021
  • Course Portfolio – overview of current course portfolio
  • Online Courses – update on new content, and team progress reports now available
  • Free Resources – look out for Haydn’s new blog
  • Discounts – on offer
  • On Demand Training – learn in real-time, whilst on the job, and quickly move from ‘not knowing’ to ‘doing’

In other news…

We have created a PDF of excel short cuts used in our courses including PIvotal180’s top ten shortcuts. This can be found in the download section at the beginning of all courses or in our free resources.

In response to the course feedback forms we are busy working on more quizzes throughout the courses and an introduction to financial statements. These will be uploaded later this month.

Kind regards,

Haydn, Dan and Alison

New Course  – VBA

VBA course as an extension to the renewables and infrastructure course, expected to launch in June 2021. This will be an online self-paced course.

Course Portfolio

The courses in our existing portfolio have been developed to emphasize why things work the way they do and how the multi-faceted pieces fit together in the broader context of a transaction.

Join our next renewable live-streaming class beginning May 11, 2021.

Project Finance and Infrastructure Modeling

Learn the concepts to develop a financial model related to PPP/P3s for both social and economic infrastructure. The course uses a hospital PPP as the the main case study, and a toll road model is also provided with a description of the revenue and cost drivers.

Tax Equity Modeling

Gain an overview of the tax equity structures commonly used in U.S. renewable energy investments, with a focus on the development of a financial model. The course goes deep into tax capital accounts, deficit restoration obligations, stop loss allocations, and HLBV accounting.

Renewable Energy Project Finance Modeling

Learn how to develop a best-practice financial model and optimize it for both debt and equity investors for a renewable energy project finance deal.  Using a case study, participants learn the concepts required to develop a financial model related to wind and solar.

Online Courses  – New content

Renewable energy and project finance courses:

  1. Clarification of ‘Effective’ versus ‘Simple’ interest rates. The confusion between these is a common cause of confusion and can result in embarrassing mistakes.
  2. Clarification of the use of the XNPV and XIRR function in lieu of the NPV and IRR functions
  3. Operations and Maintenance (O&M) Contract overview

Renewable energy and tax equity courses

  1. Updated videos on the Production Tax Credit (PTC), reflecting changes in tax law enacted in December 2020
  2. Updated videos on the Investment Tax Credit (ITC), reflecting changes in tax law enacted in December 2020

Project finance course

  1. Concession Agreements

Upcoming Content

Tax equity course

  1. Section 754 step up
  2. Section 734(b) depreciation
  3. Hypothetical Liquidation and Book Value (HLBV) introduction
  4. Fair Market Value (FMV) step ups
  5. Tax Equity sizing
  6. Sponsor buyout call options

Free Resources

Our free resources include videos, blogs, how-to guides, webinars and course samples all curated across relevant categories such as debt concepts, Excel functions, and modeling best practice.

Coming Soon

Look out for Haydn’s next blog – on Cashflow Waterfall the most important financial statement in project finance.

Featured Content

Comparing Versions of Excel Spreadsheets

Comparing Versions of Excel Spreadsheets

If you care at all about risk, you must have the functionality to compare versions of spreadsheet

This is the single financial modeling tool we cannot live without


  • For anyone who is enrolled in our Renewable Energy Project Finance Modeling course, the fee for Project Finance and Infrastructure is $300. Contact us for a coupon code.
  • A 15% discount for all purchases of three or more licenses.
  • 50% discounts for students and not for profits.

Share This Resource

Complexity simplified.

Advisory, financial modeling, and training courses within climate change, sustainable finance, renewable energy, and infrastructure.
We don’t just teach you how to build models. We teach you how to do deals.