Wall Street Prep

Advanced Project Finance Modeling|New York City

Master the advanced modeling techniques required to drive the analysis of complex projects

Provided in partnership with Corality, the leader in project finance modeling.

What You'll Learn

  • Learn project finance modeling for a host of industries
  • Taught by experienced bankers
  • Includes Excel model templates

Successful execution of project finance transactions requires comprehensive modeling and debt analysis. Advanced Project Finance Modeling enables you to extend your debt modeling capabilities in order to drive the transaction process. This course is guaranteed to boost your project finance career!

Pricing

Enrollment
$3,000*

Agenda

    • Learn powerful techniques for alternative repayment methods for debt structuring
    • Understand critical concepts and techniques in debt sizing to support debt structuring discussions
    • Extend your debt modeling capabilities with Cash Sweep and Lock-Up Account functionality
    • Share insights into effective modeling of refinancing analysis for rapid and robust analysis
    • Learn a structured approach to comprehensive depreciation calculations
    • Understand how financial statements are constructed and how to identify common problems
    • Use advanced Excel techniques for rapid and accurate multi-dimensional sensitivities
    • Increase your capabilities in efficient multi-asset / portfolio modeling techniques
  • Pre-Seminar Excel online training

    This boot camp assumes proficiency in Excel. Enrollment includes access to our popular Excel Crash Course for those who need an Excel refresher.

Who is this boot camp for?

This course is suitable for anyone who needs to extend their modeling skills and understand the advanced aspects of project finance models. Typical attendees include Analysts, Managers, Senior Managers and Associate Directors. An existing thorough understanding of best practice modeling and project finance analysis is assumed.

Boot Camp Overview

corality-turbinesThis course is guaranteed to boost your project finance career and give you all the tools to reach financial close

Advanced Project Finance Modeling enables you to extend your debt modeling capabilities in order to drive the transaction process.

Bankers, sponsors and investors all benefit from the powerful techniques for debt sizing, covenant monitoring and development of financial statements. With a continuous focus on robustness and flexibility, and analytical techniques such as multi-asset modeling, this course is guaranteed to boost your project finance career and give you all the tools to reach financial close. You will learn the modeling principles and structured approach that are applicable across a range of industries including Mining, Oil & Gas, Power, Renewable Energy, Real Estate and Infrastructure/ PPP/P3.
This project finance modeling course will enable you to

  • Extend your project finance modeling skills to allow you to take a transaction from screening to financial close
  • Develop required techniques for debt sizing, covenant monitoring and advanced debt structures including lock-up mechanisms and debt sculpting
  • Gain a complete understanding of the modeling of Debt Service Reserve Accounts (DSRA)
  • Extend your toolkit to include alternative debt repayment methods for increased flexibility
  • Achieve consistent and accurate outputs with a proven best practice modeling approach
Who should attend this course focused on project finance models?

This course is suitable for anyone who needs to extend their modeling skills and understand the advanced aspects of project finance models. Typical attendees include Analysts, Managers, Senior Managers and Associate Directors.

Pre-course knowledge

An existing thorough understanding of best practice modeling and project finance analysis is assumed. It is expected that participants have a good handle on Excel prior to attending the course. Wall Street Prep registrants receive free access to the Excel Crash Course to satisfy this prerequisite.

Seminar Location

This boot camp will be held in an event space in New York, NY. The exact location will be emailed after enrollment.

Why attend a boot camp?

  • Comprehensive training

    Our live courses pulls no punches. Each boot camp is the same intensive training used to prepare incoming analysts at top financial institutions.

  • Learn by doing

    Attendees “learn by doing” by working through practical exercises and building financial models from scratch using real case studies.

  • Networking opportunity

    Boot camps provide an opportunity to network with MBAs and professionals from industries including investment banking, corp dev and FP&A.

  • Experienced instructors

    Our instructor-practitioners are experienced bankers who give real-world context by connecting training to their own experience on the desk.

  • Excel Mastery

    Our training reinforces speed, efficiency and consistency in Excel that investment banking analysts are expected to have on Day 1.

  • Continuing ed & webinars

    Enrollment includes lifetime access to our continuing education online training platform and our popular monthly webinar series.

Syllabus

Advanced Project Finance Modeling

Day One

Learn powerful techniques for alternative repayment methods for debt structuring

  • Understand how to effectively model debt sculpting
  • Build in switches to allow different structures to be rapidly analysed
  • Develop a Debt Service Reserve Account (‘DSRA’) from first principles

Understand critical concepts and techniques in debt sizing to support debt structuring discussions

  • Single factor optimisation to vary debt size to achieve target cover ratios
  • Dual factor optimisation to achieve target cover ratios and returns
  • Solve using both data tables and Visual Basic

Extend your debt modelling capabilities with Cash Sweep and Lock-Up Account functionality

  • Learn and discuss how cash sweeps work
  • Understand what components to model and how to test the mechanics
  • Use binary flags to set up conditions for lock-up and release

Share insights into effective modelling of refinancing analysis for rapid and robust analysis

  • Discuss the mechanics of a refinancing – amount, timing, fees and repayment
  • Learn different ways to treat the refinance fee
  • Discuss the concept of sequential refinancing

Day two

Learn a structured approach to comprehensive depreciation calculations

  • Remove the need for cumbersome tables
  • Incorporate switches for multiple depreciation methods
  • Easily replicate calculations for accounting and tax depreciation

Understand how financial statements are constructed and how to identify common problems

  • Master the structure of completed three way financial statements
  • Learn how to continuously test and debug the integrated statements
  • Incorporate all of the debt components into integrated statements

Use advanced Excel techniques for rapid and accurate multi-dimensional sensitivities

  • Produce geared and ungeared tax calculations to analyse the value of interest tax shelter
  • Explore surfaces of dual variables as they impact upon a key metric
  • Use VBA to control data tables so they do not adversely affect calculation speed

Increase your capabilities in efficient multi-asset / portfolio modelling techniques

  • Understand the differences between modelling single and multiple assets
  • Learn how to set up multi-asset calculations
  • Make changes across multiple sheets – know the easy mistakes and how to avoid

Questions? We're standing by.

To learn more about this boot camp, fill out the form below or call us at: 617-314-7685








X

The Wall Street Prep Quicklesson Series

7 Free Financial Modeling Lessons

Get instant access to video lessons taught by experienced investment bankers. Learn financial statement modeling, DCF, M&A, LBO, Comps and Excel shortcuts.