New York

Helmsley Building
212-380-7027


Boston
10 Post Office Sq
617-938-3775


Washington
Washington Sq Ctr
202-558-2289


Chicago
Rosemont
312-698-9725


San Francisco
424 Clay
415-738-2527


Los Angeles
Century Blvd
310-591-8218


Atlanta
Fidelity Bank Bldg
404-806-7632


Dallas
320 Decker
214-774-4891


Houston
Intl Energy Center
713-344-0154


Philadelphia
Centre Square
215-279-8475

Financial Training Syllabus

CLASS FORMAT: All sessions are tailored for personalized instruction; each student follows the banker teaching the class and builds the financial models along with him. The financial models are projected on a large screen in our Boardroom/Training Room for easy viewing. Each session is 3.5 hours long for a total of 28 hours of in-class live training.

DELIVERING VALUE BEYOND THE LIVE CLASSES

In addition to the 8 in-class financial modeling sessions attended, we also offer the following services (included in the tuition at no extra charge):

A) Pre-class materials developed by our bankers/instructors and transmitted electronically to aid you in preparing for the live training. Included are overviews of corporate finance and financial accounting as well as Excel basics and Excel shortcuts
B) One-on-one resume revision and mock interviews with industry professionals (including common interview questions) during and after course completion
C) Access to Reuters Knowledge, the premier source for industry news and financial data, through our Investment Banker Development Partnership

These are just three of the many ways we endeavor to "go the extra mile" for our trainees.


IBI Live Training Program



8 SESSION IN-CLASS FINANCIAL MODELING COURSE SYLLABUS



  SESSION 1 - INTRODUCTION AND FINANCIAL STATEMENT ANALYSIS
    A. Introduction of Banker/Instructor
    B. Discussion of Financial Modeling Syllabus
    C. Introduction of Students and their Desired Goals
    D. Financial Markets Overview
    E. What are the Investment Banks & Private Equity Firms looking for in a potential      candidate?
    F. SEC Filings, including Annual Reports (10-K) and Quarterly Reports (10-Q)
    G. Historical - Income Statement, Balance Sheet and Cash Flow
    H. Financial Statement Analysis (Ratio Analysis)
  SESSION 2 - COMPREHENSIVE VALUATION ANALYSIS
    A. Why do we value companies?
    B. Difference between Book Value and Market Value
    C. Understanding Equity Value vs. Total Enterprise Value (TEV)
    D. The three (3) Generally Accepted Valuation Methodologies
      1. Discounted Cash Flow Analysis (DCF)
      2. Trading Multiples
      3. Precedent Transactions
    E. Spreading Comps
    F. Combining all three (3) Valuation Methodologies
  SESSIONS 3 / 4 - INTEGRATED CASH FLOW MODELING
    A. Uses for a Financial Model on Sell-side and Buy-side
    B. Tips for Setting up a Financial Model
    C. Spreading Historic Financial Statements
    D. Deriving Historic Ratios, Trends and Variables
    E. Creating Five Year Projections for Income Statement, Balance Sheet, Cash Flows
    F. Debt and Interest Schedule
    G. Integration of Projected Income Statement, Balance Sheet and Cash Flow
    H. Revolver Modeling
    I.  Sensitivities on Financial Model
  SESSIONS 5 / 6 - COMPLETE LBO MODELING
    A. Uses for An LBO Model on Sell-side and Buy-side
    B. Review of LBO Model Structure
      1. Purchase Price Calculations and Considerations
      2. Capital Structure Options / Reviews
      3. Discussion of Typical Financing Sources for LBO
      4. Creation of a Sources and Uses Worksheet
      5. Proforma Income Statement, Balance Sheet, Cash Flow
      6. Goodwill Calculation
      7. Integration of Income Statement, Balance Sheet, Cash Flow
      8. Debt and Interest Schedule
      9. Revolver and mandatory / option debt prepayment and impact on returns
      10. Returns Analysis - IRR on debt, hybrid instruments and equity investments
    C. Sensitivities on LBO model and Return Analyses
  SESSIONS 6 / 7 - MERGER (ACQUISITION) MODELING
    A. Uses for a Merger Model
    B. How to build a Merger Model
      1. Calculation of Equity Value and Purchase Price
      2. Explanation of Consideration used in Purchase (stock, cash, assumed debt)
      3. Discussion of Multiples Paid
      4. Post-Merger Control Issues
      5. Synergies and pre-tax Synergies required to Breakeven
      6. Revenue and EBITDA contribution
      7. Proforma Income Statement
      8. EPS Dilution for Acquirer
      9. Discussion of Goodwill and other accounting treatment issues
      10. Sensitivities
  SESSION 8 - INVESTMENT BANKING PROCESS AND BEST PRACTICES,
INTERVIEW SKILLS AND RESUME REVISION

I. Conclusion of Financial Modeling
II. Investment Banking Process
    A. M&A and Private Placement
      1. Investment Bank
      2. Industry Overview
      3. Market Overview
      4. Client
      5. Valuation
      6. Process
      7. Buyer/Investor Descriptions
    B. Financing
      1. Investment Bank
      2. Industry Overview
      3. Market Overview
      4. Client - Positioning
      5. IPO Valuation
      6. Marketing
      7. Pitch Process
    C. Sell-side Process
      1. M&A Process
      2. Private Placement
III. Career Resources
    A. Guidelines for resume writing, structured for Investment Banking & Private Equity      positions
    B. Skills acquired through IBI incorporated on student's resume
    C. Top 140 interview questions and questions to ask interviewer
    D. Investment Banking & Private Equity specific insight
    E. What we looked for when hiring analysts and associates
    F. Examples of rewritten resumes, including proper format and style


DISTRESSED SECURITY ANALYSIS MODELS AND MATERIALS:
    A. Overview of Distressed Securities
      1. What are Distressed Securities
      2. How to Identify and Invest in Distressed Securities

    B. Corporate Debt Pricing
      1. Bond Math, including Yield to Maturity and Yield to Worst
      2. Difference between Revolver, Term Loans, and Bonds
      3. High Yield Debt Levels and Default Rates
      4. Corporate Debt Pricing during different stages of Distressed Company Cycle,     including Credit Deterioration, Recovery, and Restructuring

    C. How to get Control of a Distressed Asset
      1. Out-of-Court and In-Court Restructuring
      2. Chapter 7, Chapter 11, and Exchange Offers

    D. Distressed Assets Financial Modeling, including Leveraged Recapitalizations
      1. Creation of a Sources and Uses Worksheet
      2. Pro forma Income Statement, Balance Sheet, Cash Flow
      3. Pro forma Capitalization of the Company
      4. Pro forma Ownership of the Recapitalized Company and Implied Enterprise     Value of the Transaction
      5. Liquidation Analysis

    E. Extensive Leveraged Recapitalization Case Study
      1. Background and Situation Assessment of the Company
      2. Objectives of the Recapitalization Transaction
      3. Detailed Analysis of Old and New Capital Structure
      4. Valuation Analysis of the Company
      5. Pro forma Ownership of the Recapitalized Company


LOOKING TO LEARN MORE QUICKLY?

We know there is a lot of information on our website! The best way to learn about the program and how it will help you is to simply give us a call. It will only take a few minutes and one of our counselors will help answer all of your questions.

EACH FINANCIAL MODELING SESSION INCLUDES THE FOLLOWING:

(All materials are submitted to the student electronically as well as on CD-ROM)
  1. Proprietary electronic presentations outlining the structure and content of each session
  2. Proprietary Excel based financial models, templates and spreadsheets, including homework assignments
  3. Handouts prepared by the Banker/Instructor
  4. SEC filings relevant to the specific Excel based financial models built in the sessions
  5. 200 page electronic training manual, "IBI Desktop Guide to Valuation and Financial Modeling: A Practical Approach"

COURSE STRUCTURE

Learning begins with our pre-class materials, in advance of session one. These are made available as early as the student desires and are designed to acclimate trainees to the live financial modeling training course. Class presentations are always distributed electronically in advance to allow students the opportunity to review ahead of time. All materials will be provided in electronic form during class to ensure that you always have the necessary information.

Headquarters:   The Helmsley Building, 230 Park Avenue, Tenth Floor,  New York, NY 10169 
212-380-7027 
For expedited service, please call our offices

© 2002-2014 Investment Banking Institute. All rights reserved.

Toronto
First Canadian Pl
416-619-4867


London
Malet Street
+44 20 7993 4711


Hong Kong
Hutchison House
+852 8199 0489


SINGAPORE
Finexis Building
+65 3158 0445


Frankfurt
Mainzer Landstr
+49 69 5780 4951


Paris
Petits Champs
+33 1 7666 0857


Geneva
World Trade Center
+41 22 548 0820


Zurich
Stockerhof Centre
+41 44 586 5055


Madrid
Edificio EuroCentro
+34 91 829 5184


JOHANNESBURG
Country Club Estate
+27 11 083 6336