The Ultimate Project Finance Modeling Package
$499Add to Cart
You don't have access to this course, but you can purchase it below.
Wall Street Prep Certification Program
- 6 Courses
- 18h 21m
- 74,354 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.
$499 Add to Cart Training a Team?
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
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
What's Included
8 Lessons
0h 43m
Boot Module and Case Study
8 Lessons0h 43m
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 eq ...
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 ...
1
View Course TOC
Course TOC
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 CF ...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.MoreLess
Boot Module and Case Study
1. Section Overview 1:14
2. Course Downloads Files
3. Project Finance Primer 10:57
4. Case Study Overview 6:02
5. Case Study Timeline and Process 4:52
6. Construction and Operations - calculations 5:37
7. Operations - Cashflow & Metrics 6:13
8. Boot Module Negotiations & Optimizations 7:52
43 Lessons
3h 44m
Excel DNA for Modelers
43 Lessons3h 44m
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 ...
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 ...
2
View Course TOC
Course TOC
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 an ...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.MoreLess
Excel DNA for Modelers
1. Welcome to the Course 1:33
2. Course Downloads Files
3. Section Overview 1:26
4. Course Structure 2:14
5. Putting the Course Content in Context 4:17
6. End Game 15:48
7. End Game - Best Practice Financial Modeling 12:52
8. Navigation and Anchoring 14:57
9. Formula Top Ten Functions 4:03
10. Position Calculated 4:26
11. Position Input 5:09
12. LOOKUP 6:11
13. HLOOKUP 2:43
14. LOOKUP Challenges 4:38
15. INDEX and OFFSET 4:50
16. MATCH 3:56
17. INDEX MATCH 4:21
18. MATCH, INDEX, CHOOSE 5:44
19. OFFSET, SUMPRODUCT 4:37
20. SUMIF, LOOKUP 3:59
21. OFFSET Extended 5:24
22. Call-Ups Summary 0:59
23. Create Flags To Massively Simplify Timing Formula - IF & AND 7:34
24. Create the Timing Strip - EOMONTH & YEAR 5:17
25. Introduction to Expand Your Excel Toolkit 4:44
26. Tools Which Enhance Robustness - Named Ranges & Data Validation 6:29
27. Tools Which Enhance Presentation - Cell Styles, Custom Formats & Conditional Formatting 16:35
28. Introduction to Shortcuts 8:25
29. 5 Shortcuts to NAVIGATE the Model 2:43
30. 17 Shortcuts for BUILDING the Model 8:12
31. 12 Shortcuts for FORMATTING the Model 9:44
32. 7 Shortcuts for CHECKING the Model 7:41
33. 4 Shortcuts for AMENDING the Model 3:07
34. THE ONE Shortcut for AUDITING the Model 2:12
35. 4 Shortcuts for MS Office 1:29
36. Recap - THE TOP 30 SHORTCUTS 0:51
37. Exercises - Honing your Skills with Shortcuts 2:15
38. Summary 0:23
39. Introduction to the Memory Retention Exercises 6:19
40. Memory Retention Exercises 1 6:03
41. Memory Retention Exercises 2 6:07
42. MRE1 Speed Run 1:28
43. MRE2 Speed Run 2:02
35 Lessons
3h 33m
Depreciation, Tax & Financial Statements
35 Lessons3h 33m
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 elemen ...
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 ...
3
View Course TOC
Course TOC
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 ...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.MoreLess
Depreciation, Tax & Financial Statements
1. Welcome to this Section 1:11
2. Course Downloads Files
3. Course Overview 2:18
4. Working Capital - Corporate Finance vs Project Finance 1:36
5. Introduction to Working Capital 7:07
6. Debtors & Working Capital Adjustments 6:02
7. Creditors & Working Capital Adjustments 5:34
8. Introduction to the P&L 4:45
9. Modeling the P&L 6:59
10. Introduction & Tax vs Accounting Depreciation 3:23
11. Types of Depreciation 3:05
12. Challenges of Depreciation & Introduction to the Old School Depreciation Table 6:26
13. The Depreciation Setup in The Model 1:56
14. Calculate Maintenance Capex 4:39
15. Depreciation Inputs - Categories & Useful Life 2:44
16. How to Summarize Capex into Additions Categories 12:04
17. Creating Template Account & Depreciation Base 18:38
18. Linking Additions & Depreciation and Reviewing Depreciation 6:00
19. Replicating the Templates, Updating for Tax Depreciation & Summarizing 11:20
20. Introduction to Tax 8:06
21. Calculating Taxable Income & Modeling the Tax Loss Account 8:20
22. Calculating Tax Payable & Tax Paid 4:21
23. Ungeared Tax Calculations for Stripping Out the Capital Structure 2:21
24. Recap of Tax 1:08
25. Introduction to the Balance Sheet 7:12
26. Establishing the Balance Sheet Framework & Linking in Balances 11:24
27. Balance Sheet Checks and Correcting Errors Using Timing & Magnitude 9:26
28. Using the Scalpel Method to Isolate Errors 6:13
29. Correcting Errors to Balance the Balance Sheet 3:53
30. Setting up & Creating Alerts 6:21
31. Creating Warnings, and Using Rounding & Formatting 4:57
32. Setting up the Ribbon for Best Practice Transparency 5:40
33. Extensions - Tax Depreciation - Introduction to MACRS Depreciation 5:01
34. Extensions - Tax Depreciation - MACRS Depreciation in the End Model 21:36
35. Closing 1:26
39 Lessons
6h 9m
Blueprint of the Model
39 Lessons6h 9m
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 ...
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 ...
4
View Course TOC
Course TOC
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 payi ...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.MoreLess
Blueprint of the Model
1. Course Welcome 1:24
2. Course Downloads Files
3. Course Aims & Structure 2:57
4. Project Finance Mechanics 10:07
5. Types of Project Finance Deals 7:31
6. Timeline of a Project Finance Deal 14:07
7. Introduction to Case Study & the Purpose of a Financial Model 4:19
8. The End Game of Project Finance 9:17
9. Introduction to the Start model 10:51
10. Introduction to Timing & timing sheet setup 11:25
11. Creating the Timing Strip with Dates & Flags 16:27
12. Counters - The Connective Tissue of a Model 9:57
13. Rounding out the Timing Sheet with Escalation & Base Rate Interest 11:03
14. Finishing the Timing Sheet & Copy Sheet 6:45
15. Introduction & Calculating Construction Spend Profile 9:47
16. Creating A Robust Structure for Sources & Uses of Construction Funds 16:35
17. The Cost of Debt - Calculating Interest During Construction and Financing Fees 21:54
18. Introduction to Operations and Reviewing the Inputs 5:28
19. Calculating Revenue of a Wind Farm with Merchant Revenues 14:33
20. Splitting Opex into Fixed and Variable, Escalating Fixed Opex 12:05
21. Grouping, Recap & Explanations 6:08
22. Theory, Critical Line Items, Hierarchy of CFW and Difference Between CFW and CFS 8:00
23. Modeling the CFW in Excel 8:02
24. Intro & Theory of PF Debt - Components of a Term Sheet, Evaluating Debt Tenor & Four Repayment Types 8:14
25. Setup & Modeling the Debt Account 9:20
26. Calculating Interest Expense 6:43
27. Modeling the Annuity Calculation from First Principles 9:12
28. Modeling Debt Sculpting through the Target Ratio 12:37
29. Debt Ratios - Understanding and Calculating the Debt Service Coverage Ratio Pulling out Key Metrics Like Min, Min Date & Avg 18:23
30. Debt Ratios - Understanding and Calculating the Loan Life Coverage Ratio 13:55
31. Putting Equity in Context - Cashflow Available for Equity 2:29
32. Introduction and Calculating Distributions to Equity Holders 9:25
33. Setting up Equity Returns Cashflows 3:16
34. Theory and Calculation of Net Present Value from First Principles and XNPV Function 11:43
35. Theory of IRR and Calculation using XIRR 4:55
36. Calculating Project Returns 7:19
37. Introduction to the Scenario Manager 5:30
38. Setting up the Scenario Manager in Excel to Sensitize Key Model Variables 11:45
39. Creating a Data Table to Simultaneous Output Results for All Cases 15:34
48 Lessons
3h 49m
Advanced Debt & Equity
48 Lessons3h 49m
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 inte ...
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 ...
5
View Course TOC
Course TOC
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 ...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.MoreLess
Advanced Debt & Equity
1. Welcome to the Course 1:27
2. Course Downloads Files
3. Course Overview 1:34
4. Introduction to the Model 5:46
5. Sculpting & Sizing - Intro 4:57
6. Mini-model I - Setup, Sculpting & Tenor vs Sizing 3:39
7. Mini-model II - Debt Sizing 3:42
8. Mini-model III - Circularities 2:44
9. Mini-model III - Manual Sizing, Bisection Method, Recap 4:06
10. Capital Structure - Macro Sheet & Max Permissible Debt Size 5:26
11. Capital Structure - The Calculated-Applied Structure & Linking 5:16
12. Introduction to Macros 3:23
13. Macro - Recording & Triggering a Macro to Get Started 6:25
14. Getting into VBA & Refining Code 5:31
15. Using the For Loop to Iterate the Macro 5:49
16. Improving Robustness & Using Named Ranges 2:40
17. Using the Do While Loop to Iterate the Macro 2:48
18. Basic Improvements to Speed up the Macro 3:56
19. Recap to Understand the Role of Loops, Using Shortcuts and Speed Improvements 6:28
20. Introduction to the DSRA 4:36
21. Overview of the DSRA - The Logic Behind Additions & Releases of Cash 5:00
22. Setting up the DSRA & Establishing the Target Balance 7:37
23. Funding the DSRA from Sources of Cash 5:38
24. How to Break the Circularity & Creating a DSRA Macro 5:36
25. Funding from Cashflows to Top-Up the DSRA 11:57
26. Release from DSRA in the Event of CFADS Shortfall 4:01
27. Release from DSRA for DSRA in Excess of Target Balance 3:12
28. Review of DSRA, Linking to Financial Statements and Distribution Lock-Up Flag 7:47
29. Introduction - Motivations for Refinancing Debt & Types of Refinancing 2:23
30. Inputs for Refinancing Debt 3:38
31. Timing of Refinancing Debt & Modifying the Senior Debt Structure 2:33
32. Calculating the Refinancing Fee 4:43
33. Calculating the Refinancing Margin & Incorporating it into the Debt Structure 5:02
34. Introduction to Shareholder Loan - Purpose and Order of Repayment 3:25
35. Creating Inputs for the Shareholder Loan and Building an Account 4:48
36. SHL Drawdowns - Integrating the SHL into Funding Sources & Updating the Capital Structure 7:28
37. Calculating SHL Interest CapitaliZed and Interest Paid 4:21
38. Calculating SHL Principal Repayment and Updating Distributions 6:07
39. Updating the CFW - Testing and Recap 3:50
40. Introduction to Automating Debt Sizing & Equity Calculations with Macros 5:25
41. Introducing the Debt Sizing Switch & Scheduling Repayment 5:21
42. Creating a Master Macro to Run All Macro's Once 9:36
43. Testing & Updating Scenario Manager 5:34
44. Setting up the Data Table for a Macro 4:05
45. Writing the Data Table Macro to Run All Cases AND Run Debt Sizing Macros 8:32
46. Performing Debt and Equity Analysis 4:20
47. Re-profiling Debt to Improve Equity Returns 5:37
48. Conclusion 0:56
4 Lessons
0h 22m
Bringing It All Together & Model Extensions
4 Lessons0h 22m
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 ...
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 ...
6
View Course TOC
Course TOC
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 pe ...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.MoreLess
Bringing It All Together & Model Extensions
1. Bringing the Models Together 5:12
2. Course Downloads Files
3. Investigating the DSRA Circularity 5:06
4. Extensions - Adjusting Construction to Monthly 11:41
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.
Course Samples
Blueprint of the Project Finance Model Overview
Advanced Debt & Equity Overview
Project Finance Debt
Creating Timing Flags
Pre-Modeling Concepts: Construction & Operation Calculations
Basic Project Finance Modeling Walk Through
Calculating Project Returns
Extensions - Adjusting Construction to Monthly
Project Finance Model Template (Values Only)
"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.
"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
Earn CPE Credits with WSP Online Courses
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.
I am an expert in project finance modeling, having an extensive background in the field with hands-on experience as an M&A advisor and direct investor. I've successfully trained teams with varying levels of modeling knowledge, elevating them to highly competent levels in a short period.
In the provided article about "The Ultimate Project Finance Modeling Package," the content covers a comprehensive program offered by Wall Street Prep for individuals interested in mastering project finance modeling. The package is priced at $499 and includes 6 courses with a total duration of 18 hours and 21 minutes. The program caters to professionals in various fields such as Investment Banking, Project Development, Private Equity, Infrastructure Funds, Infra Operating Entities, and Credit Research.
Key concepts covered in the program include:
-
Project Finance Theory and Implementation:
- Understanding the theory of project finance.
- Implementation of best-practice financial modeling.
-
Building a Project Finance Model from Scratch:
- Learning how deals are put together.
- Constructing a project finance model layer by layer.
-
Advanced Debt & Equity Modeling:
- Handling complex debt sizing mechanics.
- Running upside & downside cases.
- Incorporating advanced debt and equity structures.
-
Modeling Depreciation, Tax, Working Capital, and Financial Statements:
- Advanced accounting rigor for project finance models.
- Theoretical background and practical implementation of depreciation, tax, and financial statements.
-
Blueprint of the Model:
- Building a project finance model from scratch using a wind-farm case study.
- Analyzing revenue, fixed and variable expenses, debt repayment, and equity returns.
-
Excel DNA for Modelers:
- Learning the essential skills of financial modeling using Excel.
- Utilizing formulas, shortcuts, and macro-powered data tables.
-
Bringing It All Together & Model Extensions:
- Integrating all learned concepts into a complete project finance model.
- Exploring ways to extend the model, such as changing construction timeframes.
-
Certification and Support:
- Trainees have the option to take the WSP Project Finance Modeling Certification Exam.
- Access to Wall Street Prep's Online Support Center for additional assistance.
The program emphasizes practical learning through a real-world case study, making it valuable for professionals at different career levels. It has received positive feedback from industry experts, attesting to its effectiveness in building modeling skills.
Overall, this project finance modeling package aims to provide a comprehensive and practical understanding of the complexities involved in project finance transactions, making it suitable for a wide range of professionals in the finance and investment sector.