Project Finance & Excel: Build Financial Models From Scratch

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.

Requirements

Readiness, flexibility, and passion for learning.

Passion for real assets, development, and finance.

Basic knowledge about finance.

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.

Overview

Section 1: A Quick Refresher on the Basics

Lecture 1 Project finance in one sentence

Lecture 2 Transactions eligible for project finance

Section 2: Building a Project Finance Model from Absolute Scratch

Lecture 3 Introduction to the Case Study

Section 3: Laying Down the Foundations

Lecture 4 Anatomy of a multi-scenario Input sheet

Lecture 5 Building the Input Assumptions sheet

Section 4: Project Timeline & Time-based Assumptions

Lecture 6 The Mechanics behind Timing Flags

Section 5: Visualizing the Construction Phase

Lecture 7 Sources & Uses of Funds during Construction

Lecture 8 Debt Sizing & Circularity Breakdown

Section 6: Modeling the Operational Phase: Total Revenues & Costs

Lecture 9 Building the Operations sheet

Section 7: Building the three key financial statements

Lecture 10 Setting up the template for the P&L statement

Lecture 11 Building the amortization table

Lecture 12 EBIT calculation in the P&L statement

Lecture 13 Laying out the Debt Repayment Schedule

Lecture 14 Completing the P&L statement

Lecture 15 Cash Flow Waterfall & CFADS computation

Lecture 16 Building the Balance Sheet

Section 8: Cash Flows, Returns & Target IRR

Lecture 17 Return Metrics & Conclusion

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.