In this module, we will delve into a real-world case study, "Express Fiji," a project involving the construction and operation of a highway in Fiji. This section sets the stage for building a complete project finance model from scratch, helping you gain insights into the real-world applications of the skills you're about to learn.

In this module, we will focus on creating the foundation of a robust financial model by first understanding the anatomy of a multi-scenario input sheet. We will then proceed to build the input assumptions sheet, which forms the backbone for the rest of our financial model.

In this module, we will build a sheet dedicated to the project's timing and explore the mechanics behind timing flags. These are essential for organizing the project phases and performing detailed computations across different time periods in the financial model.

In this module, we will focus on visualizing the construction phase of a project, starting with the sources and uses of funds. We will then dive into debt sizing and the circularity of funds, ensuring a deep understanding of how these elements interact during construction.

In this module, we will begin modeling the operational phase by building the operations sheet. Here, we will connect the financial data from the construction phase to track revenue generation and operating costs for the project's lifecycle.

In this module, we will build the core financial statements, including the profit and loss statement, balance sheet, and cash flow statement. We will cover crucial aspects like debt repayment schedules, cash flow waterfalls, and amortization, giving you a complete understanding of financial statement construction.

In this module, we will compute important return metrics, including the Internal Rate of Return (IRR), and analyze all cash flows for the project. This final step will tie together the work done across previous modules, helping you assess the financial viability of the Express Fiji project.