EN
|
TR
FINANCIAL MODELING WITH EXCEL

Project Finance is a very important funding technique to finance variety of infrastructure investments such as power, oil and gas, hotels, hospitals, toll roads, airports and even prisons. Every project finance transaction is exposed to wide range risks through the life cycle of the project starting from construction period up until the end of the economic life of the project. Taking into account varied risks of the project, volatilities in project parameters and different structures of bank loan into the model is critical to create a bankable project. The financial model has a vital importance as a tool to be used to understand the business in depth, analyze risks and to be a reliable guide at the negotiation phase. Project Finance Financial Modeling Program focuses uniquely on project and structured finance and their related modeling and financial issues. After reviewing some basic elements of project finance, course participants will be building a full-fledged financial model from scratch going through various phases of the financial model themselves. Many factors that are critical to project finance decision will be also be included in the model like tariff rate, reserve accounts, cash sweep and cash trap. Once the model completed various sensitivity and scenario analysis will be performed on the model to check the strength of the model under adverse circumstances. Once completed, participants review the model from a due-diligence analysis, usually taken from a investor, lender or third party equity perspective. The final phase of this module uses sophisticated model techniques to help the practitioner stress test the project and “negotiate off the financial model”. Major emphasis of the program is to use the model as a highly-developed financial analysis tool that reviews the appropriate risk-versus-reward profiles of project finance.

OBJECTIVES

  • To provide participants with skills and techniques to develop a project finance model for different types of investment projects
  • Create models that are easy to navigate without sacrificing the major parameters of the transaction and analysis.
  • Produce a robust model from feasibility stages through project documentation to financial close
  • Identify and quantify the risks of the project through the model -­‐ from sponsor and lender viewpoints
  • Learn the power of using the financial model
  • Enhance spreadsheet analysis, presentation, and negotiations
  • Engage in current commercial discussions with active project developer / financial advisor

WHO SHOULD ATTEND

Financial Analysts, Investment & Evaluation Professionals, Government officials related to PPP and project finance, Business Development Planners, Mergers & Acquisitions Specialists, Accountants, Infrastructure Heads, Corporate & Structured Finance Teams, Joint Ventures Specialists, CFOs, Financial Directors.

DURATION

2 – 3 or 4 Days

RELATED TRAINING

RELATED DOCUMENTS

RELATED VIDEO