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 find out in Complete Monetary Modeling for Project Money in Excel

  1. Just how to build task money model from square one in excel based upon the interstate task study;
  2. What is project finance, just how facilities jobs funding is set up and who are the gamers in project financing;
  3. Exactly how to do economic modeling of facility, real-life job financing purchases;
  4. How to form financial debt to a target DSCR;
  5. Just how to create finest practice macro’s and Excel VBA codes to damage circularities;
  6. Exactly how to model Debt Service Reserve Account as well as Upkeep Book Account;
  7. Just how to model Shareholder Funding, Revolver and also Blended Equity IRR;
  8. How to perform evaluation analysis based on Reduced Capital (DCF) as well as Inner Price of Return (IRR) techniques;
  9. How to perform level of sensitivity and situation analysis;
  10. Just how to develop integrated, 3 monetary declarations model;
  11. Just how to incorporate month-to-month construction sheets into semi-annual procedures sheets;
  12. Just how to prepare relied on project financing models tailored to financiers and also investors.

Description

Master the premium financial modeling skills crucial to creating, customizing and evaluating economic models for jobs in framework field.

In an on the internet environment you will certainly go from an empty Excel workbook to a monetary model suitable for investment analysis, debt structuring as well as operational scenario evaluation. This training course will provide step-by-step guidelines on exactly how to construct monetary version appropriate for assessing job financing purchases.

What this training course has to do with?

Project finance versions are used to evaluate the risk-reward of offering to and also purchasing a framework project. The project’s financial obligation capability, appraisal as well as financial expediency rely on expected future capital generated by the project itself and a financial version is built to examine 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 :3.23 gb
Publisher :Greg Ahuy
Updated and Published:07 Jul,2022

Related post

File name: Complete-Financial-Modeling-for-Project-Finance-in-Excel.rar
File Size:3.23 gb
Course duration:6 hours
Instructor Name:Greg Ahuy
Language:English
Direct Download: