Project Finance and Excel - Build Financial Models from Scratch

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.

What You Will 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

Audience

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.

About The Author

Meta Brains: Meta Brains is a team of passionate software developers and finance professionals. They provide professional training programs that combine their expertise in coding, finance, and Excel.

With a focus on the Metaverse, they aim to equip learners with the necessary skills to participate in the next computing revolution. Their inclusive approach ensures accessibility to everyone, fostering a community that collaboratively codes and builds the future of the Metaverse.