Kyle Chaning Pearce – Wall Street Prep – The Ultimate Project Finance Modeling Package

Description

Kyle Chaning Pearce – Wall Street Prep – The Ultimate Project Finance Modeling Package

What You’ll Learn
Project Finance theory and its implementation
Best-practice financial modeling
How to create a project finance model starting from scratch
Advanced debt & equity modeling: debt service reserve accounts, refinancing, shareholder loans
Modeling Financial statements, including depreciation, taxes, working capital, and tax
How to extend the financial model beyond infrastructure to include other deal terms and multiple phases, with different periodicities

What’s Included
Boot Module and Case Study
Section 1 of our Project Finance Modeling Program. Learn about project finance from the perspective of an airport. The theory of Project Finance, Heathrow Airport expansion and the business case are all discussed. Then, we will dive into the details of project finance. Step by step, go through the case study. Calculate CFADS, tax, debt ratios like DSCR & LLCR, and eq …

Excel DNA for Modelers
Section 2 of our Project Finance Modeling Package. Learn Excel’s DNA to become a bulletproof modeler. We will break down the skillsets of financial modeling and then piece it together with financial modeling best practices layered throughout. Learn how formulas work and what happens when they break down, and the top 50 shortcuts for…

Depreciation, Tax & Financial Statements
Section 5 of out Project Finance Modeling Program. This section focuses on the accounting rigor of a project finance model. Each module starts with the same as the previous sections. “Why”Before diving into the details, here is a brief overview of the theory. “How” – the implementation in the model. Continue from the Blueprint model and pull together the elemen

Blueprint of the Model
Section 3 of our Project Finance Modeling Program. With a wind-farm case study, this course guides you in building – from scratch – your very own infrastructure model. Model a greenfield asset, calculate revenue, fixed & variable expenses. Review the relevant parts of a term sheet and model paying down debt with annuity & sculpted repayment …

Advanced Debt & Equity
Section 4 of our Project Finance Modeling Program. This section will help you get the most from a project finance agreement. It uses advanced material and expands on the work of Blueprint. It asks questions like: How does DSCR target debt sizing? How do I re-How to profile debt to maximize equity returns? How does a model determine if a model is inte…

Bringing It All Together & Model Extensions
Section 6 of our Project Finance Modeling Program. This section brings together everything we’ve learned so far and delivers a complete project finance model. We look at ways to extend the model by adding material such as changing the construction period from quarterly to a monthly frequency in a best-practice manner.

Get Kyle Chaning Pearce – Wall Street Prep – The Ultimate Project Finance Modeling Package Download