Financial Modeling Project Finance Infrastructure

Learn how build a project finance model & support infrastructure finance deals around the globe!

Last updated 2022-01-10 | 4.2

- Build an advanced financial model to analyse project finance & infrastructure deals
- Understand distinguishing features of project financing
- Use Excel VBA to solve common financial modelling problems

What you'll learn

Build an advanced financial model to analyse project finance & infrastructure deals
Understand distinguishing features of project financing
Use Excel VBA to solve common financial modelling problems

* Requirements

* Be able to build a basic 3-statement model in Excel
* Excel 2013 and later is highly recommended.

Description

Want to work on project finance and infrastructure deals?
Want to break into private equity? Show you can build "complex financial models from scratch"?
Want to make a quantum leap in your financial modeling skills?
Want to learn Excel VBA and other tips to save you HOURS of work?


THIS is the course for YOU!

This course takes an application-led approach which will guide you through an ENTIRE project finance model build in Excel! 

That's right - you'll learn how to build one of the most complex financial modeling tools in the industry... from scratch!


You'll prepare yourself for to work on infrastructure deals ALL AROUND THE WORLD with:

  • Banks

  • Advisory teams

  • Private equity funds

  • Debt funds

  • Industrial developers

  • Asset managers


You'll cover the theory and financial modeling for:

  • SPV financings

  • Flexible capital structuring

  • Debt sizing

  • Debt sculpting/tailoring/payment structuring

  • Construction standby facilities

  • DSRA DSRF and other reserve provisions

  • VAT funding

  • Lender covenants

  • Complex cash waterfalls

  • Project finance ratios: DSCR & LLCR

  • Circular calculations  common to project finance modelling


Your financial model will:

  • Handle all the complex financial engineering and analysis applicable to almost ANY infrastructure finance deal

  • Calculate returns for debt and equity infrastructure investors

  • Give you flexibility to assess multiple financing and capital structure arrangements

  • Have clean, efficient VBA code to speed up your analysis and free up your time

  • Follow the very best practices actually used by professionals in the industry

 

This course gives you all the pro tips you'd other have to pay $1,000s to access as part of a corporate training programme!! 

DON'T WAIT ON YOUR BOSS TO APPROVE THE TRAINING YOU DESERVE!!

ENROLL NOW - there's ZERO RISK as you're covered by a 30-day money-back guarantee!

(https://support.udemy.com/hc/en-us/articles/229604248-Refund-a-Course)



Who this course is for:

  • Students and young professionals interested in infrastructure finance!

Course content

7 sections • 29 lectures

All course materials Preview 00:16

Students have requested that all course materials be made available in a single download, so I am facilitating that here.

Course materials are still made available lecture by lecture -- this is the way I recommend you to progress through the course as you are likely to feel swamped if you jump straight in to the final, finished product.

Happy learning!

About your instructor Preview 01:28

About the Project Finance Modeling course Preview 02:41

What is project finance? Preview 04:51

Model route-map and study materials guide Preview 04:55

Introduction to the financial model layout and practices Preview 09:02

Funding the construction budget - part 1 Preview 02:42

Funding the construction budget - part 2 Preview 09:54

Quick review: fixed assets, depreciation, & basic financial statements Preview 04:38

Construction cost overruns and the standby facility Preview 05:18

Modeling VAT expenses and refunds Preview 06:08

Funding VAT expenses with a VAT facility Preview 03:36

Modeling lender fees - part 1 Preview 04:59

Modeling lender fees - part 2 Preview 05:30

Modeling lender fees - part 3 Preview 05:54

Interest during construction Preview 06:23

Interest rate swaps and interest during operations Preview 05:26

Quick review: operating cashflows and the cash waterfall Preview 03:00

Part 1 - project debt capacity and repayment structuring Preview 09:10

Part 2 - time varying DSCRs & risk-tiered debt sizing Preview 03:51

Part 3 - sizing debt to meet multiple scenario criteria Preview 10:18

Part 4 - building multiple case testing into the model Preview 03:24

Part 5 - using cash sweep calculations to shorten repayment tenor Preview 06:08

Lender returns Preview 01:21

Project ratios and debt repayment performance Preview 05:37

Distributions to sponsors & equity cures Preview 10:14

Debt service reserve provisions - part 1 - DSRA Preview 10:11

Debt service reserve provisions - part 2 - DSRF Preview 07:07

BONUS Preview 00:49

A special video I recorded for students completing this course!