Available as lessons are released (see website)
Course Instructions
Downloads
0.1 Anchoring
0.2 Function - IF
0.3 Function - IF(OR), IF(AND)
0.4 Function - SUMIF
0.5 Function - Lookup
0.6 Best practice - Principles
0.7 Best Practice Formulas
0.8 Best practice - flag and conditional formatting
0.9 Best practice - styles
0.10 Best practice - account
0.11 Data validation
0.12 Named ranges
0.13 Intro to debt & equity
0.14 Benefits of Leverage
0.15 Benefits of Leverage Extended
0.16 Present value math
0.17 NPV function
0.18 IRR
0.19 Basic Excel Shortcuts
Precourse assignment
3-Way Statements Slides
Slides
Glossary of Terms
Microsoft Excel Shortcuts Key
1.1 What is Project Finance?
1.2 Investment structure and liability management
1.3 Passthroughs and blockers (USA)
1.4 Introduction to parties
1.5 Government contributions
1.6 EPC and O&M
1.7 Project & Concession agreements
1.8 Cash proceeds
1.9 Allocation of risk
1.10 Project finance recap and summary of total cashflows
Chapter 1 Quiz
Slides
2.1 MWT - model familiarization
2.2 Sensitivities and scenarios
2.3 Data tables
2.4 DATE functions and timeline
2.5 MWT - instructions
2.6 MWT (S1) - Model setup and timing
2.7 MWT (S2) - Model quarterly timeline
2.8 Model Checks
2.9 Chapter 2 Quiz
Slides
Chapter 2 Downloads (including MWT)
3.1 Refresh on impact of leverage
3.2 Effects of leverage extended
Term loans quiz: Project benefits
Term loans quiz: benefits of leverage
3.3 WACC
3.4 Lender returns and risk appetite
3.5 How lenders set interest rates and DSCRs
3.6 Modeling debt inputs
3.7 MWT (S3) - Funding sheet timing
3.8 MWT (S4) - Term loan timing flags
3.9 Linear, mortgage style, and DSCR sculpted repayment types
3.10 DSCR debt sculpting demo
3.11 MWT (S5) - debt sculpting
3.12 Bullet, balloon, and mini-perms repayments
3.13 DSCR debt sizing part 1 - fixed interest rate
3.14 DSCR debt sizing part 2 - variable interest rate
3.15 DSCR debt sizing part 2 - variable interest rate DEMO
3.16 DSCR debt sizing part 3 - variable interest rate and grace period
3.17 DSCR debt sizing part 3 - variable interest rate and grace period DEMO
3.18 MWT (S6) - debt sizing
Term loan quiz: DSCR and interest rate vs debt size
3.19 Drivers of debt size
3.20 Interest Rate Day Count
3.21 Effective vs. nominal interest
3.22 MWT (S7) - DSCR calculation
3.23 LLCR
3.24 LLCR demo
3.25 MWT (S8) - LLCR calculation
Term loan quiz:
3.26 Sources of debt
3.27 Cash sweeps
3.28 Types of Credit Facilities
3.29 Recitals and Definitions
3.30 Reps and Warranties
3.31 Conditions Precedent
3.32 Covenants
3.33 The Waterfall
3.34 Events of Default and Remedies
3.35 Amendments, Waivers, and Consents
3.36 XNPV & XIRR
3.37 Chapter 3 Quiz
Slides
Chapter 3 Downloads (including MWT)
4.1 Inflation
4.2 MWT (S9) - model counters
4.3 Reasons for private sector involvement
4.4 Power Purchase Agreements
4.5 Project Agreement
4.6 Concession Agreement
4.7 MWT (S10) - Revenue
4.8 Changing the Scenario Input from Any Sheet
4.9 O&M Agreements
4.10 Operating costs
4.11 MWT (S11) - Operating costs
4.12 MWT (S12) - Operations and construction capex
4.13 Seasonality
4.14 Chapter 4 Quiz 1
4.15 Chapter 4 Quiz 2
Slides
Chapter 4 Downloads (including MWT)
