In this newsletter:
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.
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.
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.
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.
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.
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:
Renewable energy and tax equity courses
Project finance course
Tax equity course
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.
Look out for Haydn’s next blog – on Cashflow Waterfall the most important financial statement in project finance.
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