Complete Financial Modeling is for Project Finance in Excel - Greg Ahuy Master the high-end financial modeling skills pivotal to developing, modifying and analyzing financial models for projects in infrastructure sector..
Complete Financial Modeling for Project Finance in Excel - Greg Ahuy Master the high-end financial modeling skills pivotal to developing, modifying and analyzing financial models for projects in infrastructure sector.
an online environment is In you will go from a blank Excel workbook to a financial model suitable for investment analysis, debt structuring and operational scenario evaluation..
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 is will provide step-by-step instructions on how to build financial model suitable for analyzing project finance transactions..
This course will provide step-by-step instructions on how to build financial model suitable for analyzing project finance transactions.
this course is What is about?.
What this course is about?
finance models is Project are used to assess the risk-reward of lending to and investing in an infrastructure project..
Project finance models are used to assess the risk-reward of lending to and investing in an infrastructure project.
The project's debt capacity, is valuation and financial feasibility depend on expected future cash flows generated by the project itself and a financial model is built to analyze this..
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.
The Project Finance Modeling course is In we will model complex greenfield toll road project finance transactions from scratch in excel..
In The Project Finance Modeling course we will model complex greenfield toll road project finance transactions from scratch in excel.
You is 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..
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.
the same comprehensive financial training is This is used to prepare analysts and managers at top financial institutions and infrastructure funds..
This is the same comprehensive financial training used to prepare analysts and managers at top financial institutions and infrastructure funds.
you is Why should enroll in the Complete Project Finance Modeling Course?.
Why you should enroll in the Complete Project Finance Modeling Course?
Realistic project finance is training - The Project Finance Modeling in Excel course includes over 9 hours of instructor-led video content to learn at your own pace..
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.
this course is After completing you will be able to build complex, real-life project finance and valuation models..
After completing this course you will be able to build complex, real-life project finance and valuation models.
Affordability - is Affordability - a similar course, which provides realistic project finance modeling training will cost you anywhere from US$1000 to US$2500 per course..
Affordability - a similar course, which provides realistic project finance modeling training will cost you anywhere from US$1000 to US$2500 per course.
anytime is Learn and anywhere - The Project Finance Modeling course is 100% online so you can learn the modeling when it is convenient for you..
Learn anytime and anywhere - The Project Finance Modeling course is 100% online so you can learn the modeling when it is convenient for you.
it is How does work?.
How does it work?
The course length is is over 9 hours..
The course length is over 9 hours.
we is First, will review basic project finance theory, so you understand all essential components of project finance transaction..
First, we will review basic project finance theory, so you understand all essential components of project finance transaction.
the second part, is Then, in we will go over the toll road project case study and review modeling methods to improve our productivity in excel..
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 is will then dive into building our project finance model..
We will then dive into building our project finance model.
We is will work on the construction costs, funding and financing fees..
We will work on the construction costs, funding and financing fees.
the third part, is In we will build fully integrated, 3 statements financial model which will include income statement, balance sheet and cash flow statement..
In the third part, we will build fully integrated, 3 statements financial model which will include income statement, balance sheet and cash flow statement.
the forth part, is In we will model such items as coverage ratios, debt sculpting, debt service reserve account and maintenance reserve account, revolver, shareholder loan..
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 is will also carry out valuation of the project using discounted cash flow ( DCF ) and internal rate of return ( IRR ) methods..
We will also carry out valuation of the project using discounted cash flow ( DCF ) and internal rate of return ( IRR ) methods.
a core part of any project finance model. is This is.
This is a core part of any project finance model.
the fifth part, is Finally, in we will introduce advanced financial modeling topics such as equity first funding method, debt sizing automation, debt service reserve account automation and scenario analysis..
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.
this course is Is for you?.
Is this course for you?
you is Yes, if need to build, review or analyse project finance models within the infrastructure, oil & gas or mining sectors..
Yes, if you need to build, review or analyse project finance models within the infrastructure, oil & gas or mining sectors.
Typical students is include analysts, managers, senior managers, associate directors, financial advisors, financiers and CFOs from project companies, investment banks, private equity and infrastructure funds..
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: is You will need previous exposure to Excel in a financial modelling context and basic knowledge of investment concepts such as NPV and cash flows..
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.
this course is Who is for: Typical students include finance students, recent graduates, analysts, managers, senior managers, associate directors, advisers, financiers and CFOs from financial and infrastructure companies..
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.
you is Are interested in?.
Are you interested in?
Complete Financial Modeling is for Project Finance in Excel - Greg Ahuy Download, complete financial modeling, complete financial modeling for project finance in excel, financial modeling process, financial modeling programs, financial modeling best course..
Complete Financial Modeling for Project Finance in Excel - Greg Ahuy Download, complete financial modeling, complete financial modeling for project finance in excel, financial modeling process, financial modeling programs, financial modeling best course.
Complete Financial Modeling is Purchasing for Project Finance in Excel - Greg Ahuy course now, You can get it with the LIFETIME SUPPORT and UNLIMITED DOWNLOAD..
Purchasing Complete Financial Modeling for Project Finance in Excel - Greg Ahuy course now, You can get it with the LIFETIME SUPPORT and UNLIMITED DOWNLOAD.