Project Finance & Excel: Build Financial Models from Scratch
Beginner LevelFinance & AccountingFinancial Modeling

Project Finance & Excel: Build Financial Models from Scratch

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

Created by Meta Brains, Finance Builders
3.5 hours
Video Content
20
Lectures
50,618
Students
4.3
Rating
4.3
(50,618 students enrolled)

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.

Course Content

10 sections • 20 lectures • 03:34:48 total length

A Quick Refresher on the Basics

2 lectures • 06:31

Project finance in one sentence02:17
Transactions eligible for project finance04:14

Building a Project Finance Model from Absolute Scratch

2 lectures • 07:37

Introduction to the Case Study07:32
Course Materials00:05

Laying Down the Foundations

2 lectures • 30:17

Anatomy of a multi-scenario Input sheet11:12
Building the Input Assumptions sheet19:05

Project Timeline & Time-based Assumptions

1 lectures • 13:44

The Mechanics behind Timing Flags13:44

Visualizing the Construction Phase

2 lectures • 56:03

Sources & Uses of Funds during Construction30:49
Debt Sizing & Circularity Breakdown25:14

Modeling the Operational Phase: Total Revenues & Costs

1 lectures • 20:50

Building the Operations sheet20:50

Building the three key financial statements

7 lectures • 58:04

Setting up the template for the P&L statement07:28
Building the amortization table09:28
EBIT calculation in the P&L statement03:06
Laying out the Debt Repayment Schedule16:07
Completing the P&L statement03:46
+2 more lectures

Cash Flows, Returns & Target IRR

1 lectures • 20:05

Return Metrics & Conclusion20:05

BONUS Section - Don't Miss Out

1 lectures • 01:12

BONUS Section - Don't Miss Out01:12

BONUS Section - Don't Miss Out

1 lectures • 00:24

BONUS Section - Don't Miss Out00:24

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.

This course includes:

  • 3.5 hours on-demand video
  • 3 articles
  • 2 downloadable resources
  • Access on mobile and TV
  • Full lifetime access
  • Certificate of completion

Instructors

Meta Brains

Finance Builders

Students also download

Explore related courses to expand your learning journey.