Wall Street Prep
The Ultimate Project Finance Modeling Package
You don't have access to this course, but you can purchase it below.
Step-By-Step Video Course and Certification Program

The Ultimate Project Finance Modeling Package

6 Courses
18h 21m
62,422 Students

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.

"As a past M&A advisor and latterly a direct investor I can safely say that this project finance course is the best I’ve ever seen. It's been able to take my team, some with little knowledge of modeling, to a highly competent level in a short period of time."

Jason Frank,
Group Director of Data Analytics, European Tyre

What You Will Learn

  • 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

1

Project Finance Modeling 1: 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 ...
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 int ...
Section 1 of our Project Finance Modeling Program. Learn project finance through the lens of an airp ...
View Course TOC
2

Project Finance Modeling 2: 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 t ...
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 ...
Section 2 of our Project Finance Modeling Package. Learn the DNA of Excel and become a bulletproof f ...
View Course TOC
3

Project Finance Modeling 5: 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 finan ...
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 ...
Section 5 of out Project Finance Modeling Program. This section advances the accounting rigor around ...
View Course TOC
4

Project Finance Modeling 3: 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 lende ...
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, calcul ...
Section 3 of our Project Finance Modeling Program. With a wind-farm case study, this course guides y ...
View Course TOC
5

Project Finance Modeling 4: 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 feature ...
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 ...
Section 4 of our Project Finance Modeling Program. This section will challenge you to get the most o ...
View Course TOC
6

Project Finance Modeling 6: 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.
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 t ...
Section 6 of our Project Finance Modeling Program. This section brings together everything we’ve lea ...
View Course TOC

Get the Project Finance Modeling Certification

Trainees are eligible to take the WSP Project Finance Modeling Certification Exam for 24 months from the date of enrollment. Those who complete the exam and score above 80% will receive the certification. The exam is a challenging 2-hour online examination covering the most difficult concepts covered in the program.

Who is this program for?

This course is designed for professionals (analysts, associates and VPs) and those pursuing the following careers:

  • Investment Banking
  • Project Development
  • Private Equity
  • Infrastructure Funds
  • Infra Operating Entities
  • Credit Research

Course Samples

watch video
Project Finance Primer
watch video
Construction Sources & Uses
watch video
Project Finance Debt
watch video
Creating Timing Flags
watch video
Pre-Modeling Concepts: Construction & Operation Calculations
watch video
Basic Project Finance Modeling Walk Through
watch video
Calculating Project Returns
watch video
Extensions - Adjusting Construction to Monthly
watch video Excel Logo
Project Finance Model Template (Values O...

"This is a really well designed course. I would recommend this course for both those looking to build their first model as well as experienced modelers looking to take the next step."

Chris Gavin,
Someva Renewables

Project Finance Modeling Package Highlights


  • Intuitive, Self-Paced and Comprehensive

    Wall Street Prep's Project Finance Modeling Package is intuitive and self-paced. Using a combination of videos, Excel model templates and financial reports, this course teaches students and professionals how to build, analyze, and interpret project finance models in a step-by-step fashion at their own pace. The program utilizes a case study format, as students work along with the instructor using Excel model templates, full case study inputs and term sheet excerpts in order to build comprehensive models the way it's done on the job.


  • Support Center

    Upon enrollment, students gain free and unlimited access to Wall Street Prep's Online Support Center, where they receive answers to questions, free downloads, and important updates from a support staff comprised entirely of experienced former investment bankers


  • Private Online Tutoring (Additional Fee Applies)

    Want a little extra attention? Live video-chat tutoring is available with experienced project finance professionals (additional fee applies). In addition, your tutoring sessions enable you and your tutor to share models, a virtual whiteboard and any other files via an integrated web and phone platform that enhances the learning experience.


  • Macabacus Excel Plugin

    Free access to Macabacus, all-in-one suite of time-saving tools designed for people who build financial models in Excel. Use keyboard shortcuts for common number formats, to cycle rapidly through different font and color schemes and to navigate a formula's inputs across worksheets and workbooks. Easily understand long formulas with the powerful ‘Precedents’ and ‘Dependents’ Tool, and much more. This 6-month free access is for the full version of Macabacus that also includes essential tools for Powerpoint and Word!

"Great course — detailed but also clear enough to follow. I work in project finance and I’m wishing I had taken this course when I started out!"

Karthik Panicker,
Westpac Institutional Bank
CPE logo

Earn CPE Credits with WSP Online Courses

CPE logo Wall Street Prep is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.
X

The Wall Street Prep Quicklesson Series

7 Free Financial Modeling Lessons

Get instant access to video lessons taught by experienced investment bankers. Learn financial statement modeling, DCF, M&A, LBO, Comps and Excel shortcuts.