Project Finance & Excel: Build Financial Models from Scratch

Focused View

Meta Brains

3:33:35

382 View

1 - A Quick Refresher on the Basics

1 - Project finance in one sentence.mp4

02:17

2 - Transactions eligible for project finance.mp4

04:14

2 - Building a Project Finance Model from Absolute Scratch

3 - Introduction to the Case Study.mp4

08:01

3 - Laying Down the Foundations

4 - Anatomy of a multiscenario Input sheet.mp4

11:12

5 - Building the Input Assumptions sheet.mp4

19:05

4 - Project Timeline Timebased Assumptions

6 - The Mechanics behind Timing Flags.mp4

13:44

5 - Visualizing the Construction Phase

7 - Sources Uses of Funds during Construction.mp4

30:49

8 - Debt Sizing Circularity Breakdown.mp4

25:14

6 - Modeling the Operational Phase Total Revenues Costs

9 - Building the Operations sheet.mp4

20:50

7 - Building the three key financial statements

10 - Setting up the template for the PL statement.mp4

07:28

11 - Building the amortization table.mp4

09:28

12 - EBIT calculation in the PL statement.mp4

03:06

13 - Laying out the Debt Repayment Schedule.mp4

16:07

14 - Completing the PL statement.mp4

03:46

15 - Cash Flow Waterfall CFADS computation.mp4

10:57

16 - Building the Balance Sheet.mp4

07:12

8 - Cash Flows Returns Target IRR

17 - Return Metrics Conclusion.mp4

20:05

Description

Learn how to build a complete project finance model in Excel from absolute scratch!

What You'll Learn?

Build a complete financial model in Excel from absolute scratch.
Learn the fundamentals of Infrastructure Project Finance and Public-Private Partnerships.
Acquire the essential knowledge needed to succeed in the project finance industry.
Ace your upcoming project finance interview at commercial and development banks, investment funds, industrial sponsors and advisors.

Who is this for?

Anyone who is curious about Infrastructure Project Finance and PPP.

Students & recent graduates who don’t want to spend $10,000s on master’s degrees.

Experienced professionals who are interested in changing careers.

Entrepreneurs interested in infrastructure project finance.

More details

Description
Whatever your educational or professional backgroundâ€”engineering, finance, or lawâ€”it can be difficult to break into the competitive field of infrastructure project finance and public-private partnerships (PPPs). A lack of technical knowledge and basic abilities may hinder your chances of getting your ideal career and breaking into the industry, and it all starts with the interview.
We can relate to your anguish since we have experienced it firsthand. Motivated by a desire to see young professionals succeed, we developed this curriculum to help them navigate this challenge. The focus of this course is more specifically towards financial modeling in Excel for project finance.
This is not your typical course; instead, it is the result of thousands of hours of research, teaching, and practice in the classroom, workplace, and interview rooms. We have extensive experience in the project financing industry, gained while working for a variety of companies, and would be pleased to share it with you.
All the insider knowledge you'd normally have to pay thousands of dollars for in a company training session is included in this course.
The project finance sector is cumbersome & complicated from a distance; however, this course will draw you closer to understanding how you can make the sector a haven for you.

Who this course is for:
Anyone who is curious about Infrastructure Project Finance and PPP.
Students & recent graduates who donâ€™t want to spend $10,000s on masterâ€™s degrees.
Experienced professionals who are interested in changing careers.
Entrepreneurs interested in infrastructure project finance.

User Reviews

Rating

average 0

Total votes0

Focused display

Meta Brains is a professional training brand developed by a team of software developers and finance professionals who have a passion for Coding, Finance & Excel.We bring together both professional and educational experiences to create world-class training programs accessible to everyone.Currently, we're focused on the next great revolution in computing: The Metaverse. Our ultimate objective is to train the next generation of talent so we can code & build the metaverse together!

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.