MODULE 1: Introduction, Course Aims & Structure
Detailed Course Breakdown
Build up a best practice cashflow model with a case study of a Greenfieled Wind Farm
- Intro
3mins
MODULE 2: Principles of Project Finance
- 2a Project Finance Mechanics: Discuss the
Characteristics, Complexity and Players
10mins
MODULE 3: Foundations of Best Practice
- 3a Discover Financial Modeling
Best Practices and See
Examples of What Not To Do!
12mins
MODULE 4:The Case Study and The End Game
- 4a Introduction to Case Study & the
Purpose of a Financial Model
4mins
- 4b The End Game of Project Finance:
Using the Scenario Manager to Analyse the Deal
9mins
MODULE 5: The Timing Sheet: Transform a
Spreadsheet into a Financial Model
- 5a Introduction to
Timing & timing sheet setup
11mins
- 5b Creating the Timing Strip
with Dates & Flags
16mins
- 5c Counters: The Connective
Tissue of a Model
9mins
- 5d Rounding out the Timing Sheet with
Escalation & Base Rate Interest
11mins
- 5e Finishing the Timing Sheet & Copy Sheet
15mins
MODULE 6: Constructing a Greenfield Infrastructure
Project and Calculating Sources Of Funds
- 6a Introduction & Calculating Construction
Spend Profile
9mins
- 6b Creating A Robust Structure for Sources &
Uses of Construction Funds
15mins
- 6c The Cost of Debt: Calculating Interest
During Construction and Financing Fees
22mins
MODULE 7: Operations Over the Lifetime of the Asset -
Revenue and Costs
- 7a Introduction and Review the Inputs
5mins
- 7b Calculating Revenue of a
Windfarm with Merchant Revenues
14mins
- 7c Split Opex into Fixed and Variable,
Escalating Fixed Opex
12mins
- 7d Grouping, Recap & Explanations
6mins
MODULE 8: Explore the Cashflow Waterfall; Theory and Bring In Cash Items to One Central Location
- 8a Theory, Criticial Line Items, Hierarchy
of CFW and Difference Between CFW and CFS
8mins
- 8b Modeling the CFW in Excel
8mins
MODULE 9: Learn about Project Finance Debt Modeling through Annuity, Sculpting & Debt Metrics
- 9a Intro & Theory: Components of a
Term Sheet, Evaluating
Debt Tenor & Four Repayme
8mins
- 9b Setup & Modeling the Debt Account
9mins
- 9c Calculating Interest Expense
6mins
- 9d Modeling the Annuity Calculation
from First Principles
9mins
- 9e Modeling Debt Sculpting through
the Target Ratio
12mins
- 9f Debt Ratios: Understanding and
Calculating the Debt Service
Coverage Ratio; Pulling
18mins
- 9g Debt Ratios: Understanding and
Calculating the Loan Life Coverage Ratio
14mins
MODULE 10: Equity Account, Distributions and Returns to Project and Equity Holders
- 10a Introduction and Calculating
Distributions to Equity Holders
9mins
- 10b Setting up Equity Returns Cashflows
3mins
- 10c Theory and Calculation of Net Present
Value from First Principles and XNPV Function
11mins
- 10d Theory of IRR and Calculation using XIRR
4mins
- 10e Calculating Project Returns
7mins
MODULE 11: Using The Scenario Manager
To Turbocharge Your Analysis
- 11a Introduction to the Scenario Manager;
What It Does & How it Works
5mins
- 11b Setting up the Scenario Manager in
Excel to Sensitise Key Variables
Throughout
11mins
- 11c Creating a Data Table to Simultaneously
Output Results for All Cases
15mins
