Wall Street Prep – The Ultimate Project Finance Modeling Package
Project Finance Modeling requires complexity not seen in typical corporate finance models. This program breaks down everything you need to build and interpret project finance models for a transaction. Learn project finance financial statement modeling, debt sizing mechanics, running upside & downside cases and more.
Learn to Build a Real-World Project Finance Model Step-By-Step
- Complete Project Finance Modeling Training
This course builds up each layer step by step, from how deals are put together to building best practice financial models through advanced analysis using macro powered data tables & scenario managers.
- Real World Case Study
Learn by doing – go through a case study to walk through building and optimizing a model from scratch.
- Used Widely at Investment Banks, Developers and Funds
This is the same comprehensive training program delivered to some of the world’s leading banks, developers and funds.
What You’ll Learn In The Ultimate Project Finance Modeling Package?
- Project finance theory and implementation
- Best-practice financial modeling
- How to build a project finance model from scratch
- Advanced debt & equity modeling: debt service reserve accounts, refinancing, shareholder loans
- Modeling depreciation, tax, working capital, and financial statements
- How to extend the financial model to different types of infrastructure, incorporate other sophisticated deal terms and multiple phases with different periodicity
What’s Included:
Boot Module and Case Study
- Section 1 of our Project Finance Modeling Program. Learn project finance through the lens of an airport. Review the theory of PF, discuss the business case of Heathrow Airport expansion, then dive into the particulars of the project finance model. Go through the case study step by step. Calculate CFADS, tax, debt ratios like DSCR & LLCR, and equity and project returns. Get hands on in the model. Run different cases to optimize the project and meet stakeholders criteria.
Excel DNA for Modelers
- Section 2 of our Project Finance Modeling Package. Learn the DNA of Excel and become a bulletproof financial modeler. Here, we break down the skillset of financial modeling and piece it together step by step with financial modeling best practices layered throughout. You’ll learn how formula works and when they break down and the top 50 shortcuts to make you a speed demon. By the end of this course, you’ll get up to 3x quicker at developing robust, transparent financial models.
Depreciation, Tax & Financial Statements
- Section 5 of out Project Finance Modeling Program. This section advances the accounting rigor around a project finance model. Like the other sections, each module begins with the “Why”, giving you the theoretical background, before diving into the “How” – the implementation in the model. Continuing from the Blueprint model, pull together the elements to deliver a bankable financial model. Calculate working capital using multiple methodologies, discuss and calculate corporate tax, calculate depreciation using straight line, reducing balance or MACRS methodology, bring together a P&L and Balance sheet. Improve the model robustness by adding checks.
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 mechanisms, and analyze lender covenants. Bring the model together into a Cashflow Waterfall. Using equity & project returns, DSCR and other outputs, trace the drivers of performance with a scenario manager, and run a debt and equity type process as a window to how stakeholders might view the deal.
Advanced Debt & Equity
- Section 4 of our Project Finance Modeling Program. This section will challenge you to get the most out of a project finance deal. Using advanced material, it expands on our work in Blueprint and asks questions such as: How does DSCR target or gearing driven debt sizing work? How do I re-profile debt to optimize equity returns? How does a model integrate advanced funding features like a DSRA? Go further by adding in sophisticated funding structures, like the option to refinance debt and shareholder loans. Automate debt sizing and the scenario manager to solve the debt case, or run a debt process by evaluating multiple lender terms.
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 start to look into ways of extending the model with material such as how to change the construction timeframe from quarterly to monthly periodicity in a best practice manner, while keeping operations quarterly.
More courses from the same author: Wall Street Prep