Project Finance and Excel - Build Financial Models from Scratch

Preview this course

Welcome to this comprehensive video course on project finance, where we will delve into various aspects of transactions eligible for project finance. Throughout this course, we will explore real-world examples and dive deep into a captivating case study on Express Fiji. We will guide you through building a comprehensive balance sheet, incorporating all relevant assets, liabilities, and equity components.

Unlimited access to 750+ courses.
Enjoy a Free Trial. Cancel Anytime.

- OR -

30-Day Money-Back Guarantee
Full Lifetime Access.
24 on-demand videos & exercises
Level: Beginner
3hrs 34mins

Access on mobile, web and TV

What to know about this course

We will start by introducing project finance, highlighting the transactions that are eligible for this type of financing. Understanding the criteria for project finance is crucial for assessing the feasibility of infrastructure projects and identifying potential funding sources.

The case study on Express Fiji will serve as our guiding example throughout the course. We will dissect the multi-scenario input sheet, examining each component and its role in the financial modeling process. We will walk you through the essential elements to consider when constructing this sheet, ensuring accuracy and reliability in your financial projections. Additionally, we will explore the mechanics behind timing flags, providing insights into their significance and how they impact the project’s financial analysis. Next, we will shift our focus to building the operations sheet, which plays a crucial role in projecting the project’s performance over its operational life. We will guide you through setting up the template for the profit and loss (P&L) statement, demonstrating how to calculate EBIT (Earnings Before Interest and Taxes) and integrate it into the financial model. You will also learn how to create an amortization table and lay out the debt repayment schedule. Finally, we will delve into return metrics and conclude the course by analyzing the project’s financial performance.

By the end of the course, you will be able to unravel the intricacies of project finance, using the captivating case study on Express Fiji to enhance your understanding.

Who's this course for?

This course caters to a diverse audience, including students and recent graduates who are curious about infrastructure project finance and Public-Private Partnerships (PPP).

Experienced professionals who are interested in exploring new career opportunities in the field of infrastructure project finance and entrepreneurs who have an interest in understanding the intricacies of infrastructure project finance to support their business ventures will benefit from this course.
Basic knowledge about finance will be an add-on.

What you'll learn

  • Understand what project finance is
  • Learn to build the input assumptions sheet
  • Understand the mechanism behind timing flags
  • Understand debt sizing and circularity breakdown
  • Learn the three key financial statements
  • Learn to build the amortization table

Key Features

  • Build a complete financial model in Excel from scratch
  • Learn the fundamentals of infrastructure project finance and public-private partnerships
  • Acquire the essential knowledge needed to succeed in the project finance industry

Course Curriculum

About the Author

Meta Brains

Meta Brains is a professional training brand developed by a team of software developers and finance professionals who have a passion for finance, coding, and Excel. They bring together both professional and educational experiences to create world-class training programs accessible to everyone. Currently, they're focused on the next great revolution in computing: The Metaverse. Their ultimate objective is to train the next generation of talent so that we can code and build the metaverse together!

40% OFF! Unlimited Access to 750+ Courses. Redeem Now.