Complete Financial Modeling for Project Finance in Excel
What you'll learn
- How to build project finance model from scratch in excel based on the toll road project case study;
- What is project finance, how infrastructure projects financing is arranged and who are the players in project finance;
- How to do financial modeling of complex, real-life project finance transactions;
- How to sculpt debt to a target DSCR;
- How to create best practice macro’s and Excel VBA codes to break circularities;
- How to model Debt Service Reserve Account and Maintenance Reserve Account;
- How to model Shareholder Loan, Revolver and Blended Equity IRR;
- How to carry out valuation analysis based on Discounted Cash Flow (DCF) and Internal Rate of Return (IRR) methods;
- How to carry out sensitivity and scenario analysis;
- How to build integrated, 3 financial statements model;
- How to integrate monthly construction sheets into semi-annual operations sheets;
- How to prepare trusted project finance models tailored to investors and financiers.
- You will need previous exposure to Excel in a financial modelling context and basic knowledge of investment concepts such as NPV and cash flows.
Master the high-end financial modeling skills pivotal to developing, modifying and analyzing financial models for projects in infrastructure sector.
In an online environment you will go from a blank Excel workbook to a financial model suitable for investment analysis, debt structuring and operational scenario evaluation. This course will provide step-by-step instructions on how to build financial model suitable for analyzing project finance transactions.
What this course is about?
Project finance models are used to assess the risk-reward of lending to and investing in an infrastructure project. The project's debt capacity, valuation and financial feasibility depend on expected future cash flows generated by the project itself and a financial model is built to analyze this.
In The Project Finance Modeling course we will model complex greenfield toll road project finance transactions from scratch in excel.
You will learn about:
- what is project finance;
- financial modeling of complex, real-life project finance transactions;
- how to sculpt debt to a target DSCR;
- how to create best practice macro’s and VBA codes to break circularities;
- how to model Debt Service Reserve Account and Maintenance Reserve Account;
- how to model Shareholder Loan, Revolver and Blended Equity IRR;
- building project finance models in excel that cover the entire life of the project;
- carry out valuation analysis based on the discounted cash flow (DCF) and internal rate of return (IRR) methods;
- preparing trusted project finance models tailored to investors and financiers, with a focus on valuation and risk
- financial models that are designed according to the F.A.S.T standards.
This is the same comprehensive financial training used to prepare analysts and managers at top financial institutions and infrastructure funds.
Why you should enroll in the Complete Project Finance Modeling Course?
Realistic project finance training - The Project Finance Modeling in Excel course includes over 9 hours of instructor-led video content to learn at your own pace. After completing this course you will be able to build complex, real-life project finance and valuation models.
Affordability - a similar course, which provides realistic project finance modeling training will cost you anywhere from US$1000 to US$2500 per course.
Learn anytime and anywhere - The Project Finance Modeling course is 100% online so you can learn the modeling when it is convenient for you.
How does it work?
The course length is over 9 hours.
First, we will review basic project finance theory, so you understand all essential components of project finance transaction.
Then, in the second part, we will go over the toll road project case study and review modeling methods to improve our productivity in excel. We will then dive into building our project finance model. We will work on the construction costs, funding and financing fees.
In the third part, we will build fully integrated, 3 statements financial model which will include income statement, balance sheet and cash flow statement.
In the forth part, we will model such items as coverage ratios, debt sculpting, debt service reserve account and maintenance reserve account, revolver, shareholder loan. We will also carry out valuation of the project using discounted cash flow ( DCF ) and internal rate of return ( IRR ) methods. This is a core part of any project finance model.
Finally, in the fifth part, we will introduce advanced financial modeling topics such as equity first funding method, debt sizing automation, debt service reserve account automation and scenario analysis.
Is this course for you?
Yes, if you need to build, review or analyse project finance models within the infrastructure, oil & gas or mining sectors. Typical students include analysts, managers, senior managers, associate directors, financial advisors, financiers and CFOs from project companies, investment banks, private equity and infrastructure funds.
This course prerequisites:
You will need previous exposure to Excel in a financial modelling context and basic knowledge of investment concepts such as NPV and cash flows.
Who this course is for:
- Typical students include finance students, recent graduates, analysts, managers, senior managers, associate directors, advisers, financiers and CFOs from financial and infrastructure companies.
The courses are taught by Gregory Ahuy.
Greg started his career in investment banking as M&A analyst in London at Renaissance Capital - a leading Russian investment banking firm. He was later relocated to Moscow to help with some of the biggest Russian M&A deals in the mining and infrastructure sectors. Gregory continued his career at InfraRed Capital Partners, one of the largest infrastructure funds, focused on sourcing and executing greenfield and brownfield infrastructure projects in Eastern Europe. Later, Mr. Ahuy joined Eneco, one of the largest energy companies in the Netherlands where he led several renewable energy projects.