Financial Modeling & Analysis

Complete Financial Modeling for Project Finance in Excel free download

Complete Financial Modeling for Project Finance in Excel in Excel . How to build project finance model from scratch in excel based on 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 carry out valuation analysis based on Discounted Cash Flow (DCF) and Internal Rate of Return (IRR) methods .

What you’ll learn in Total Economic Modeling for Job Finance in Excel

  1. Just how to build task financing design from scratch in succeed based upon the toll road project study;
  2. What is project finance, just how infrastructure tasks financing is arranged as well as who are the players in project financing;
  3. Exactly how to do economic modeling of complicated, real-life project finance purchases;
  4. How to shape financial obligation to a target DSCR;
  5. How to create finest practice macro’s and Excel VBA codes to damage circularities;
  6. Exactly how to design Financial obligation Service Get Account and also Maintenance Get Account;
  7. Exactly how to design Shareholder Funding, Revolver and Blended Equity IRR;
  8. How to execute evaluation analysis based upon Discounted Cash Flow (DCF) and Interior Rate of Return (IRR) methods;
  9. How to execute sensitivity and also scenario analysis;
  10. Just how to construct integrated, 3 economic declarations version;
  11. Exactly how to incorporate monthly building sheets into semi-annual operations sheets;
  12. How to prepare relied on task financing designs customized to capitalists and also financiers.


Master the premium monetary modeling skills pivotal to developing, changing as well as evaluating monetary versions for tasks in facilities sector.

In an on the internet atmosphere you will certainly go from a blank Excel workbook to an economic model suitable for financial investment evaluation, debt structuring and also operational scenario assessment. This training course will certainly supply step-by-step instructions on just how to develop financial version suitable for assessing task money transactions.

What this program has to do with?

Project financing designs are utilized to examine the risk-reward of offering to and also investing in a facilities project. The job’s financial debt ability, appraisal and also financial usefulness depend on expected future capital created by the project itself and a monetary model is constructed to analyze this.

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.
File Name :Complete Financial Modeling for Project Finance in Excel free download
Content Source:udemy
Genre / Category:Finance & Accounting
File Size :5.77 gb
Publisher :Greg Ahuy
Updated and Published:06 Jun,2022

You may also like

Leave a reply

Your email address will not be published.