Complete Financial Modeling for Project Finance in Excel

Complete Financial Modeling for Project Finance in Excel

.MP4, AVC, 1280x720, 30 fps | English, AAC, 2 Ch | 10h 18m | 5.95 GB

Instructor: Greg Ahuy



Learn Financial Modeling for Project Finance and Infrastructure Valuation ( DCF and IRR ).







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.



Requirements



You will need previous exposure to Excel in a financial modelling context and basic knowledge of investment concepts such as NPV and cash flows.





Description



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.



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.



More Info

https://www.udemy.com/course/project-finance-modeling/