Project Finance & Excel Build Financial Models From Scratch

Published 1/2023
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.51 GB | Duration: 3h 34m
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.

Homepage

www.udemy.com/course/project-finance-excel-build-financial-models-from-scratch/