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.