Financial modeling | Project Finance & Infrastructure

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

4.05 (1390 reviews)
Udemy
platform
English
language
Financial Modeling & Ana
category
Financial modeling | Project Finance & Infrastructure
6,000
students
2.5 hours
content
May 2020
last update
$19.99
regular price

What you will 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

Why take this course?

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)



Content

Course materials

All course materials

Welcome to the Project Finance course!

About your instructor
About the Project Finance Modeling course
What is project finance?
Model route-map and study materials guide
Introduction to the financial model layout and practices

Core project costs and funding in the construction period

Funding the construction budget - part 1
Funding the construction budget - part 2
Quick review: fixed assets, depreciation, & basic financial statements
Construction cost overruns and the standby facility
Modeling VAT expenses and refunds
Funding VAT expenses with a VAT facility

Financing costs during construction

Modeling lender fees - part 1
Modeling lender fees - part 2
Modeling lender fees - part 3
Interest during construction
Interest rate swaps and interest during operations

Setting up the operational period

Quick review: operating cashflows and the cash waterfall

Debt sizing calculations

Part 1 - project debt capacity and repayment structuring
Part 2 - time varying DSCRs & risk-tiered debt sizing
Part 3 - sizing debt to meet multiple scenario criteria
Part 4 - building multiple case testing into the model
Part 5 - using cash sweep calculations to shorten repayment tenor

Investment performance & contingency funding during operations

Lender returns
Project ratios and debt repayment performance
Distributions to sponsors & equity cures
Debt service reserve provisions - part 1 - DSRA
Debt service reserve provisions - part 2 - DSRF

Screenshots

Financial modeling | Project Finance & Infrastructure - Screenshot_01Financial modeling | Project Finance & Infrastructure - Screenshot_02Financial modeling | Project Finance & Infrastructure - Screenshot_03Financial modeling | Project Finance & Infrastructure - Screenshot_04

Our review

🫢 **Course Overview:** The course in Project Finance Modeling has received a global rating of 4.05, with recent reviews indicating a mix of positive and constructive feedback. The course is described as an "overview lecture on project finance & infrastructure," which suggests it provides a comprehensive understanding of the subject matter but may not guide students through building a model from scratch. **Pros:** - **Quality Content:** Reviews consistently praise the course content as being excellent, comprehensive, and valuable. - **Real-Life Application:** The course is appreciated for its real-life experience, insights, and tips into creating models with all complexities peculiar to Project Finance. - **Hands-On Approach:** Many students find the course to be very good, hands-on, and useful for understanding step by step how to build a model from scratch. - **Expert Instructors:** The instructors are considered very knowledgeable in the subject. - **Practical Focus:** The course is described as a great use of time for project finance analysts and is practical in nature, with materials provided being thorough. - **Visual Aids:** The use of animations and visual aids is noted to make sessions lively and aid in the explanation of concepts. - **Recommendation for Intermediate Learners:** It is recommended for intermediate to advanced financial analysts with some experience. - **Good Teaching Style:** The teaching style is generally considered good, with simplified explanations of concepts. 🔍 **Considerations and Areas for Improvement:** - **Pacing:** Some students find the course a bit quick for their pace, suggesting that they had to pause and review the model to keep up. - **Model Complexity:** The course may be too fast-paced for beginners or those seeking a more step-by-step guide to building a model from scratch. - **Theoretical vs. Practical:** There is feedback indicating a desire for more practical application or a more in-depth theoretical explanation, with some students feeling that the course is just a drive-through overview of an already prepared Excel model. - **VBA and Pre-requisites:** Some students suggest that the course could benefit from an introduction to VBA and other concepts through references like books or links. - **Model Customization:** A few reviews indicate that the course is not what was expected for those looking to build a project finance model from scratch. - **Detailed Guidance:** The explanations provided are seen as quick summaries rather than detailed guides for building a model, which could be a point of dissatisfaction for some learners. **Recommendation:** For students who have some background in finance or accounting and are looking for an overview of Project Finance Modeling with real-life application, this course seems to offer great value. However, if you are seeking a detailed, step-by-step guide to building a project finance model from the ground up, you might want to consider additional resources or different courses that cater specifically to that need. **Final Thoughts:** Overall, the Project Finance Modeling course is well-received for its comprehensive content and real-world application. It is particularly beneficial for those with intermediate knowledge who wish to enhance their skills in financial modeling within the context of project finance. To get a complete hands-on experience from scratch, students may need to complement this course with additional learning resources or seek out other courses specializing in model construction.

Charts

Price

Financial modeling | Project Finance & Infrastructure - Price chart

Rating

Financial modeling | Project Finance & Infrastructure - Ratings chart

Enrollment distribution

Financial modeling | Project Finance & Infrastructure - Distribution chart
1472580
udemy ID
12/17/2017
course created date
5/29/2019
course indexed date
Bot
course submited by