• Post category:StudyBullet-13
  • Reading time:5 mins read


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

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.


Get Instant Notification of New Courses on our Telegram channel.


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.

English
language

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