Introduction to Project Finance (Online)

Certificates

Subscribe Now

Course curriculum

1. Course Instructions
2. Intro Lesson to Course
3. Course Downloads
4. Glossary of Terms
1. 0.1 Best Practices - Principles
2. 0.2 Best Practices - Formulas
3. 0.3 Best Practices - Styles
4. 0.4 Named Ranges
5. 0.5 Financial Modeling Guidelines
6. 0.6 Basic Functions - Anchoring
7. 0.7 Basic Functions - IF
8. 0.8 Best Practices - Flags and Conditional Formatting
9. 0.9 Excel Shortcuts (Downloads)
10. 0.10 Basic Excel Shortcuts
11. Chapter 0 Slides
12. Chapter 0 Downloads
1. 1.1 Chapter Introduction: Initial Model Setup
2. 1.2 Introduction to MWTs
3. 1.3 Model Familiarization
4. 1.4 MWT (S1) - Introduction to Workbook
5. 1.5 MWT (S2) - Setting Up Inputs Sheet
6. 1.6 MWT (S3) Model Timing
7. 1.7 MWT (S4) - Setting Up Calculation and Dashboard Sheet
8. 1.8 MWT (S5) - Operations Period and Timing Flag
9. Chapter 1 Downloads
1. 2.1 What is Project Finance?
2. 2.2 Investment Structure & Liability Management
3. 2.3 Role of Parties & Contractual Cashflow
4. 2.4 Allocation of Risk
5. 2.5 Recap and Summary of Total Cashflows
6. Chapter 2 Quiz
7. Chapter 2 Slides
1. 3.1 Chapter Introduction: Project Finance Model & Relationships
2. 3.2 Present Value Math
3. 3.3 NPV function
4. 3.4 Internal Rate of Return (IRR)
5. 3.5 Intro to Debt & Equity
6. 3.6 Benefits of Leverage
7. 3.7 Refresh on impact of leverage
8. 3.8 Impacts of Leverage (Demo)
9. 3.9 Benefits of Leverage Pt. 2
10. Chapter 3 Quiz
11. Chapter 3 Quiz Solution
12. 3.10 Lender Returns and Risk Appetite
13. 3.11 How Lenders set Interest Rates and DSCRs
14. Chapter 3 Slides
15. Chapter 3 Downloads
1. 4.1 Chapter Introduction: Scenarios and Sensitivities
2. 4.2 Sensitivities and Scenarios
3. 4.3 Data tables
4. 4.4 Scenario Demo (Demo 2A)
5. 4.5 Data Table Demo (Demo 2B)
6. Chapter 4 Quiz
7. Chapter 4 Slides
8. Chapter 4 Downloads
1. 5.1 Chapter Introduction: Legal Agreements in PF
2. 5.2 Types of Credit Facilities
3. 5.3 Recitals and Definitions
4. 5.4 Reps and Warranties
5. 5.5 Conditions Precedent
6. 5.6 Covenants
7. 5.7 The Waterfall
8. 5.8 Events of Default and Remedies
9. 5.9 Amendments, Waivers, and Consents
10. Chapter 5 Quiz
11. Chapter 5 Slides
1. 6.1 Chapter Introduction: Energy Generation
2. 6.2 Capacity vs energy
3. 6.3 Capacity Factors
4. 6.4 MWT (S6) Gross Generation Inputs
5. 6.5 MWT (S7) Gross Generation Calculations
6. 6.6 MWT (S8) Net Generation Inputs
7. 6.7 MWT (S9) Net Generation Calculations
8. 6.8 MWT (S10) Setting Up Inputs Scenarios
9. Chapter 6 Quiz
10. Chapter 6 Slides
11. Chapter 6 Downloads
1. 7.1 Chapter Introduction: Forecasting Revenue and Operating Costs
2. 7.2 PPA Overview
3. 7.3 MWT (S11) - Escalation Inputs and Calculations
4. 7.4 MWT (S12) - Revenue Inputs
5. 7.5 MWT (S13) - Revenue Calculations
6. 7.6 PPA Risk
7. 7.7 Operating costs
8. 7.8 O&M Agreements
9. 7.9 MWT (S14) - Operating Cost Inputs
10. 7.10 MWT (S15) - Operating Cost Calculations
11. 7.11 MWT (S16) - CADS / Unlevered Forecast Summary
12. 7.12 MWT (S17) - Initial Graphing to Review Model
13. Chapter 7 Quiz
14. Chapter 7 Slides
15. Chapter 7 Downloads
1. 8.1 EPC Contracts 1 - General Structure
2. 8.2 EPC Contracts 2 - Risk Allocation Part 1
3. 8.3 EPC Contracts 3 - Risk Allocation Part 2
4. 8.4 EPC Contracts 4 - Damages and Remedies
5. 8.5 EPC Contracts 5 - Other Legal Provisions
6. Chapter 8 Quiz
7. Chapter 8 Slides
1. 9.1 MWT (S18) Unlevered Returns
2. 9.2 MWT (S19) Improving Returns
3. 9.3 MWT (S20) Setting Up 1-D Data Table
4. 9.4 MWT (S21) Creating 1-D Data Table
5. 9.5 MWT (S22) Creating 2-D Data Table
6. 9.6 MWT (S23) Conditionally Formatting 2-D Data Table
7. 9.7 MWT (S24) - Goal Seek to Determine Offtake Price
8. 9.8 MWT (S25) - Grouping
9. 9.9 MWT (S26) - Reviewing Model to Date
10. Chapter 9 Quiz One
11. Chapter 9 Quiz One Solution
12. 9.10 Project & Concession agreements
13. Chapter 9 Quiz Two
14. Chapter 9 Slides
15. Chapter 9 Downloads
1. 10.1 Chapter Introduction: Project Finance Term Loans
2. 10.2 Modeling Debt Inputs
3. 10.3 MWT (S27) Adding Debt Inputs
4. 10.4 Linear, Mortgage Style, and DSCR Sculpted Repayment Types
5. 10.5 MWT (S28) - DSCR Debt Sculpting, Part A
6. 10.6 MWT (S29) - DSCR Debt Sculpting, Part B
7. 10.7 MWT (S30) - DSCR Output Calculation
8. 10.8 DSCR Debt Sizing Part 1 - Fixed Interest Rate
9. 10.9 MWT (S31) - DSCR Debt Sizing Intro and Calculation
10. 10.11 Drivers of Debt Size
11. 10.12 MWT (S33) - Debt Repayment Flag
12. 10.13 Model Checks
13. 10.14 MWT (S34) - Model Checks
14. 10.15 Sources of debt
15. Chapter 10 Quiz
16. Chapter 10 Slides
17. Chapter 10 Downloads
1. 11.1 Chapter Introduction: Levered Returns and Operating Risks
2. 11.2 Waterfall structure
3. 11.3 MWT (S35) - Levered Returns
4. 11.4 MWT (S36) - Updating Data Table for Levered Outputs
5. 11.5 MWT (S37) - Levered Return Funding Sensitivities
6. Chapter 11 Quiz
7. Chapter 11 Slides
8. Chapter 11 Downloads
1. 12.1 Chapter Introduction: Tax and Depreciation
2. 12.2 Book and Tax Depreciation
3. 12.3 MWT (S38) - Tax Depreciation Inputs
4. 12.4 MWT (S39) - Tax Depreciation Calculations
5. 12.5 Taxable income
6. 12.6 MWT (S40) - Taxable Income Calculations
7. 12.7 MWT (S41) Efficient Taxpayer Calculations
8. 12.8 Net Operating Losses Carried Forward (NOLs)
9. 12.9 MWT (S42) - Self-Sheltered Taxpayer Calculations (NOLs)
10. 12.10 MWT (S43) - Adding Tax Check to Master Checks
11. Chapter 12 Quiz
12. Chapter 12 Slides
13. Chapter 12 Downloads
1. 13.1 Chapter Introduction: Post-Tax Returns
2. 13.2 MWT (S44) - Post-Tax Returns Calculation
3. 13.3 MWT (S45) - Taxable Entity Considerations
4. 13.4 MWT (S46) - Goal Seeking Post-Tax Levered Returns for PPA Price
5. 13.5 Optimizing your model
6. 13.6 MWT (S47) - What Matters Most?
7. Chapter 13 Quiz
8. Chapter 13 Downloads
1. 14.1 Chapter Introduction: Outputs
2. 14.2 Intro to Graphing
3. 14.3 MWT (S48) - Model Dashboard
4. Final Quiz
5. Chapter 14 Downloads
1. 15.1 Chapter Introduction: Career Advice
2. 15.2 Becoming a Better Modeler
3. 15.3 Role Levels
4. 15.4 Role Types
5. 15.5 How to Get a Role
1. 16.1 Chapter Introduction - Tax Credits
2. 16.2 Intro to US Tax Credits
3. 16.3 US Tax Credits (ITC)
4. 16.4 US Tax Credits (PTC)
5. Chapter 16 Quiz
6. Chapter 16 Slides
1. Survey To Complete the Course

About this course

$600.00 first payment, $100.00 / year onwards
177 lessons
16.5 hours of video content

Introduction to Project Finance (Online)

Course curriculum

Course Introduction

0. Pre-Course: Intro to Excel & Best Practices

1. Initial Model Setup

2. Essential Project Finance Concepts

3. High-Level Project Finance Model and Relationships

4. Scenarios and Sensitivities

5. Legal Agreements in PF

6. Energy Generation

7. Forecasting Revenue and Operating Costs

8. Construction Contracts

9. Construction Costs, Unlevered Returns and Sensitivities

10. Project Finance Term Loans

11. Levered Returns and Review of Operating Risk

12. Tax and Depreciation

13. Post-Tax Returns and Model Optimization

14. Outputs

15. Career Advice

16. US Tax Credits

17. Survey

About this course