Financial Modeling Project Finance Infrastructure
Tags: Financial Modeling
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
* 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!