Project Finance & Excel: Build Financial Models from Scratch

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

4.49 (169 reviews)
Udemy
platform
English
language
Financial Modeling & Ana
category
instructor
Project Finance & Excel: Build Financial Models from Scratch
31,179
students
3.5 hours
content
Jan 2024
last update
$49.99
regular price

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

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.


Content

A Quick Refresher on the Basics

Project finance in one sentence
Transactions eligible for project finance

Building a Project Finance Model from Absolute Scratch

Introduction to the Case Study

Laying Down the Foundations

Anatomy of a multi-scenario Input sheet
Building the Input Assumptions sheet

Project Timeline & Time-based Assumptions

The Mechanics behind Timing Flags

Visualizing the Construction Phase

Sources & Uses of Funds during Construction
Debt Sizing & Circularity Breakdown

Modeling the Operational Phase: Total Revenues & Costs

Building the Operations sheet

Building the three key financial statements

Setting up the template for the P&L statement
Building the amortization table
EBIT calculation in the P&L statement
Laying out the Debt Repayment Schedule
Completing the P&L statement
Cash Flow Waterfall & CFADS computation
Building the Balance Sheet

Cash Flows, Returns & Target IRR

Return Metrics & Conclusion

Reviews

Dr.
January 29, 2024
Thanks for your wonderful explanation and structured teaching methodology. I just have one query. Can I use the Excel sheet shared by you in the beginning of the course (in resources) to teach my students face to face (in person)?
Ramakrishna
January 12, 2024
Having just completed "Project Finance & Excel: Build Financial Models from Scratch" by Mr. Meta Brains, I am thoroughly impressed. The course provides a comprehensive understanding of building financial models in Excel, starting from the basics. The focus on Infrastructure Project Finance and Public-Private Partnerships adds a practical dimension, equipping learners with essential knowledge crucial for success in the project finance industry. Mr. Meta Brains' expertise shines through, making complex concepts accessible. I highly recommend this course for anyone seeking to master financial modeling and excel in project finance interviews.
Eddie
November 3, 2023
Questions posted in the Q&A section have gone unanswered. Explanations of topics are very broad in nature and far too simplistic.
Syed
September 12, 2023
Thank you for the peer knowledge and experience shared in this course, I can assume that now I can work in a construction company too, that too right from the start :-)

Coupons

DateDiscountStatus
1/29/2023100% OFF
expired
1/29/2023100% OFF
expired
1/29/2023100% OFF
expired
2/6/2023100% OFF
expired
2/20/2023100% OFF
expired
3/18/2023100% OFF
expired
3/21/2023100% OFF
expired
4/14/2023100% OFF
expired
5/3/2023100% OFF
expired
5/19/2023100% OFF
expired
5/27/2023100% OFF
expired
6/7/2023100% OFF
expired
6/15/2023100% OFF
expired
6/29/2023100% OFF
expired
7/30/2023100% OFF
expired
7/30/2023100% OFF
expired
8/5/2023100% OFF
expired
8/14/2023100% OFF
expired
8/28/2023100% OFF
expired
9/3/2023100% OFF
expired
9/10/2023100% OFF
expired
10/14/2023100% OFF
expired
10/28/2023100% OFF
expired
11/11/2023100% OFF
expired
12/11/2023100% OFF
expired
12/23/2023100% OFF
expired
1/1/2024100% OFF
expired
1/5/2024100% OFF
expired
1/19/2024100% OFF
expired
2/18/2024100% OFF
expired

Charts

Price

Project Finance & Excel: Build Financial Models from Scratch - Price chart

Rating

Project Finance & Excel: Build Financial Models from Scratch - Ratings chart

Enrollment distribution

Project Finance & Excel: Build Financial Models from Scratch - Distribution chart
5119210
udemy ID
1/28/2023
course created date
1/29/2023
course indexed date
Bot
course submited by