Wall Street Prep

New York City
Introduction to Project Finance Modeling|New York City

Build a full-scale project finance model in this intensive 3-day boot camp

What You'll Learn

  • Learn the key principles of Project Finance
  • Build a project finance transaction model from the ground up
  • Understand commonly used project financing structures
  • Includes Excel Project Finance model templates

Perfect for finance professionals and those looking to break into the project finance industry, our Introduction to Project Finance Modeling Boot Camp will teach you how to build models from the ground up- the way it's done on the job.

Taught by experienced project finance professionals, this is the same intensive training used to prepare incoming analysts at top financial institutions and infrastructure funds who will be analyzing project finance transactions.

Pricing

Enrollment
$1,599
Group Rates
discount
available
Earlybird price(s) of $1,599 in effect until November 18, 2019 and will subsequently increase to $1,799.

Agenda

Day 1
8am - 5pm
Project Finance Principles; Modeling Best Practices

You will learn the principles for project finance and the key drivers for structuring transactions in order to maximize the benefits for debt lenders, equity investors and public agencies. Our instructors will walk you though project finance modeling best practices and how to set up your model to maximize efficiency. Students will begin the process of building a project finance model.

Day 2
8am - 5pm
Building the Project Finance Model

Trainees continue the project finance model building process with a focus on building operational calculations and financing structure calculations involving multiple tranches of debt and equity. These calculations will take into consideration accounting principles by providing students with hands on experience in building 3-statement accounting sheets to track project performance.

Day 3
8am - 5pm
Project Finance Model Completion

Trainees complete the project finance model and build model outputs to analyze the impact of various scenarios to key project metrics (ie: debt service coverage ratio, equity IRR, Project WACC) and financial statements. This day will allow for students to take a step back and understand the implications of various project assumptions to project performance.

Online
Pre-Seminar Excel 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?

  • Investment banking analysts and associates
  • Private equity, asset management and infrastructure fund associates
  • Financial, technical, and legal professionals working in the infrastructure sector
  • MBA students and business undergraduates
  • Anyone seeking to improve their financial modeling skill set

Boot Camp Overview

This boot camp is an intensive instructor-led training program where trainees learn project finance modeling in Excel using an intuitive, step-by-step approach. Participants will use real case studies to build models from scratch the way it is done at financial institutions. The program is a synthesis of Excel modeling, navigating through various financial reports, and the application of accounting, corporate finance, and valuation courses.

Schedule

Each day begins at 8am and ends at 5pm with a 1-hour lunch break as well as a midmorning and mid-afternoon break.

What’s Included?

Comprehensive training materials (manuals and online exercises), Detailed reusable modifiable Excel model templates, Unlimited e-mail support for content-related questions for 12 months post-seminar.

What to Bring

Laptop, Notepad, and Calculator.

Prerequisites

This seminar presumes knowledge of financial accounting (at least 1 semester or equivalent). Participants without this background must enroll in and complete the Accounting Crash Course prior to attending the seminar.

CPE Credit

CPE logoWall Street Prep is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have the final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.learningmarket.org.

Cancellation Policy

Participants may cancel up to 3 weeks prior to the event for a full refund. A 20% cancellation fee will apply up to 1 week prior to the event. No refunds will be granted for cancellations made within 1 week of the event. Wall Street Prep reserves the right to cancel the seminar if enrollment is insufficient. Trainees will be refunded in full in the event of a cancellation.

Seminar Location

Exact New York City location TBD. Wall Street Prep conducts seminars at multiple event spaces in this city. We will determine the event space and email enrolled trainees no later than 2 months prior to the seminar date.

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

Introduction to Project Finance Modeling

Introduction to Project Finance

This section provides a conceptual overview of project finance and is intended to provide students with the basic understanding of the financial structure of the Project Finance Model Case Study.

  • What is project finance
  • Difference between project finance and corporate finance
  • Project finance structure
  • Project finance risks and risk changes over time
  • Constraints to project finance investment
  • Sources of project finance
    • Project revenues and costs
    • Debt financing instruments and characteristics
    • Equity financing and characteristics
  • Introduction to key project finance metrics
  • Types of project documentation

Project Finance Modeling Best Practices

This section discusses and provides practical excel exercises for formats, functions, and formulas which will be used in the Project Finance Model Case Study

  • Features of the financial model
  • Importance of financial models
  • Modeling best practices (12 rules)

Project Finance Model Case Study, Phase 1

This section is a step by step hands on excel exercise which will build upon the previous exercise to arrive at a final project finance model for a single project. Each part is intended to be additive where answers to each part will be provided in the proceeding part.

  • Project Finance Model Part 1: Introduction to the Project Finance Model Case Study
    • Overview of case study project
    • Baseline financial structure of case study (eg: revenue, cost, capital structure)
  • Project Finance Model Part 2: Setting Up A Template Worksheet
    • Formatting a template sheet for easy viewing
    • Introduce model headings, output messages, units, and timelines
  • Project Finance Model Part 3: Setting Up the Timing Sheet
    • Set up the proper model periodicity using key excel functions
  • Project Finance Model Part 4: Setting Up Inputs Sheets
    • Categorically set up input sheets which can run multiple scenarios
    • Create flexibility for revenues, expenses, leverage, and financing assumptions
    • Set up static and time-based inputs for model calculations

Project Finance Model Case Study, Phase 2

This section is the continuation of a step by step hands on excel exercise which will build upon the previous exercise to arrive at a final project finance model for a single project. Each part is intended to be additive where answers to each part will be provided in the proceeding part.

  • Project Finance Model Part 5: Creating Timing Flags
    • Code flexible timing flags for triggers, construction, and operational periods
    • Calculate flexible percent completion flags
  • Project Finance Model Part 6: Integrating Financial Statements
    • Set up an integrated Cashflow Statement, Balance Sheet, and Income Statement
    • Understand dependences between the 3 financial statements and calculations
  • Project Finance Model Part 7: Capital Costs Calculations
    • Code control accounts for project expenditures
    • Calculate fixed assets during construction
    • Develop depreciation calculations and integrate into financial statements
  • Project Finance Model Part 8: Implementing a Checks Sheet
    • Build a project checks sheet with a tolerance level
  • Project Finance Model Part 9: Reserve Accounts
    • Develop working capital accounts to account for timing differences of cash received and expended
    • Code operational period calculations including routine operations and major maintenance expenditures
    • Link operational period calculations to financial statements
  • Project Finance Model Part 10: Debt Financing Calculations
    • Code senior debt and subordinated debt calculations
    • Understand the impact of cashflow available or debt service to repayment of debt financing
    • Calculate debt drawdown, debt principal, and debt interest
  • Project Finance Model Part 11: Equity and Dividend Calculations
    • Calculate equity injections and redemptions
    • Create a dividends control account and constraints to equity distributions

Project Finance Model Case Study, Phase 3

This section is the continuation of a step by step hands on excel exercise which will build upon the previous exercise to arrive at a final project finance model for a single project. Each part is intended to be additive where answers to each part will be provided in the proceeding part.

  • Project Finance Model Part 12: Project Taxation
    • Calculate profit chargeable to corporation tax
    • Set up a corporation tax control account to link to financial statements
  • Project Finance Model Part 13: Ratios and Returns
    • Develop a debt service coverage ratio calculation, NPV Calculation, Project and Equity IRR calculation
    • Create project outputs and management overviews including a sources and uses table and management dashboard
  • Project Finance Model Part 14: Final Project Finance Model Review
    • Code in VBA to analyze project and equity IRRs of multiple scenarios simultaneously
    • Learn summary and perform sensitivity analysis

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.