FINANCIAL MODELING SIMPLIFIED

Seeing The Matrix

 

Tutorial Overview

Have you seen a few Project Finance models before, perhaps even built one – but when you try and think of the “moving parts”, it’s all a bit hazy?

Or are you new to looking at Project Finance transactions and want to compress years of understanding into a few minutes?

Then you’re in the right place. This tutorial aims to help you to understand what are the key drivers of complexity in a Project Finance model. How do they shape the model?

Questions addressed here include

This tutorial starts off by exploring different repayment types (bullet, annuity, fixed), before diving into sculpting.

We clear up a bit of confusion about how Project Finance models are used, and the difference between the Debt Service Coverage Ratio (DSCR) as a tool to sculpt debt, versus a lender covenant that the project should not breach. This brings in the lifecycle of a Project Finance model; how is it used up to Financial Close versus in Operations?

It walks through how you sculpt debt to the Project cashflows, and sets the scene for Debt Sizing in a Project Finance model.

See The Matrix

Get the PDF to get a birds eye view on connections between the modules in a Project Finance model

Popular Tutorials

NOV  20TH  2019

Calculating Debt
Repayment

Whether you’re a company, a fund, or a project… it’s likely that you have to repay debt.

NOV  10TH  2019

De-risking Your Model

Whatever type of model you have in front of you – for Corporate Finance, Project...

NOV  17TH  2019

Working Capital

Working capital seems to be an area of confusion in financial modeling and adjusting them so we get the cash item.

FREE DOWNLOAD

Learn the Secrets of the World’s Top Financial Modelers

Get the behind-the-scenes top 15 Excel tips and shortcuts I use to build financial models known only by top financial modelers

DOWNLOAD
Close

Learn the Secrets of the World’s Top Financial Modelers

Get the behind-the-scenes top 15 Excel tips and shortcuts I use to build financial models known only by top financial modelers