Project Finance and Excel - Build Financial Models from Scratch

Description

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.

Approach

The focus of this course is more specifically toward financial modeling in Excel for project finance. This complete hands-on course helps you build a complete financial model in Excel from absolute scratch.

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

Github Repo

https://github.com/PacktPublishing/Project-Finance-and-Excel---Build-Financial-Models-from-Scratch

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 are 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!

Course Outline

1. A Quick Refresher on the Basics

2. Building a Project Finance Model from Absolute Scratch

3. Laying Down the Foundations

4. Project Timeline & Time-based Assumptions

5. Visualizing the Construction Phase

6. Modeling the Operational Phase: Total Revenues & Costs

7. Building the three key financial statements

8. Cash Flows, Returns & Target IRR