Project Finance & Excel: Build Financial Models from Scratch
- Offered byUDEMY
Project Finance & Excel: Build Financial Models from Scratch at UDEMY Overview
Duration | 4 hours |
Total fee | ₹399 |
Mode of learning | Online |
Difficulty level | Beginner |
Credential | Certificate |
Project Finance & Excel: Build Financial Models from Scratch at UDEMY Highlights
- 30-Day Money-Back Guarantee
- Certificate of completion
- Full lifetime access
- Learn from 2 downloadable resources and 2 articles
Project Finance & Excel: Build Financial Models from Scratch at UDEMY Course details
- 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.
- Whatever your educational or professional background in 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.
Project Finance & Excel: Build Financial Models from Scratch at UDEMY Curriculum
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
Course Materials
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
BONUS Section - Don't Miss Out
BONUS Section - Don't Miss Out