Public Courses


Public Courses ContentOur public curriculum spans 5 days in length and provides the flexibility to choose the modules best suited for you and your organization. We highly recommend that participants without a prior financial background attend all 5 days.

We offer these courses in the following locations:

  • New York
  • Chicago
  • San Francisco
  • Boston
  • Washington, D.C.

Please Contact Us directly to register for courses.

Click on Event Name for description/registration
EVENTSTART-END
Day 1: Fundamentals of Financial Statement Analysis
Open Seats UNLIMITED
2017-12-11
9:00 am
-5:00 pm
Day 2: Excel and 3 Statement Forecasting
Open Seats UNLIMITED
2017-12-12
9:00 am
-5:00 pm
Day 3: Real Company and Cash Sweep Modeling
Open Seats UNLIMITED
2017-12-13
9:00 am
-5:00 pm
Day 4: Valuation Overview and DCF Analysis
Open Seats UNLIMITED
2017-12-14
9:00 am
-5:00 pm
Day 5: Short-Form LBO and M&A Modeling
Open Seats UNLIMITED
2017-12-15
9:00 am
-5:00 pm

Day 1: Fundamentals of Financial Statement Analysis


Dec 11,2017 - Time: 9:00 am - 5:00 pm
This session provides participants with the “nuts and bolts” of accounting and focuses on the interrelationships between the 3 financial statements. As a solid accounting foundation is critical to grasping more advanced finance concepts, the course prepares participants for subsequent modeling and valuation modules. During the course, actual company annual reports are analyzed to show real examples of accounting treatment and disclosure notes.
  • Introduction to financial statement analysis
    • What’s in an annual report and where to look
    • Structure of and relationships between the 3 financial statements
  • Income statement
    • Revenue recognition and the matching principle
    • Accrual vs. cash accounting
    • EBIT and EBITDA
    • Effective tax rate vs. marginal tax rate
    • Normalized net income
    • Earnings per share
    • Profitability ratios
  • Balance Sheet
    • Net working capital
    • Days ratios and cash conversion cycle
    • Tangible vs. intangible assets
    • Depreciation and amortization
    • Goodwill and impairments
    • Capital expenditures
    • Debt vs. other liabilities
    • Leverage and coverage ratios
    • Common vs. preferred stock
    • Authorized, issued and outstanding shares
    • Par value and additional paid-in capital
    • Share issuances and repurchases
    • Retained earnings
    • Dividends
  • Cash flow statement
    • Operating, investing and financing cash flows
    • Building a cash flow statement from scratch
    • Best practices to always ensure your model will balance

Location


100 Park Avenue
New York, New York 10017

Event Fees:

Early Registration $ 699.00
Standard Registration $ 750.00

Day 2: Excel and 3 Statement Forecasting


Dec 12,2017 - Time: 9:00 am - 5:00 pm
This session will introduce participants to Excel and the fundamentals of 3 statement modeling. Participants will learn how to forecast the 3 financial statements, balance a model and handle issues related to circularities. Best practices will be incorporated throughout the course.
  • Excel and modeling fundamentals
    • Optimal excel settings
    • Key shortcuts
    • Formula construction
    • Matrix integrity
  • 3 statement modeling
    • Steps to building a model
    • Income statement construction
    • Supporting calculations and debt schedule
    • Balance sheet and cash flow statement construction
    • Balancing the model
    • Understanding circular references and building a circ breaker

Location


100 Park Avenue
New York, New York 10017

Event Fees:

Early Registration $ 699.00
Standard Registration $ 750.00

Day 3: Real Company and Cash Sweep Modeling


Dec 13,2017 - Time: 9:00 am - 5:00 pm
This course builds upon the Day 2 session by introducing participants to a real company model and incorporating a cash sweep debt schedule.
  • Incorporating complex assumptions associated with a real company
  • Steps to building a cash sweep model
  • Handling mandatory and accelerated debt payments
  • Identifying errors and checking the model

Location


100 Park Avenue
New York, New York 10017

Event Fees:

Early Registration $ 699.00
Standard Registration $ 750.00

Day 4: Valuation Overview and DCF Analysis


Dec 14,2017 - Time: 9:00 am - 5:00 pm
The goal of this session is to introduce participants to corporate valuation. The first half of the session focuses on the strengths and weaknesses of the 4 primary valuation methodologies as well as the calculation of equity and enterprise value. The second half of the course focuses specifically on discounted cash flow analysis and the construction of a DCF model.
  • Valuation overview
    • Enterprise value vs. equity value
    • Diluted shares outstanding
    • Fundamental versus relative valuation
    • 4 primary valuation methodologies
      • Trading comparables
      • Transaction comparables
      • DCF
      • LBO
    • Strengths and weaknesses of each valuation methodology
    • Minority versus majority stake valuation
    • Key multiples
    • Valuation football field
  • Discounted cash flow analysis
    • Unlevered free cash flow
    • WACC
      • Cost of debt
      • Cost of equity using CAPM
    • Terminal value
      • Perpetuity growth method
      • Exit multiple method
    • Mid-year adjustments
    • Calculating enterprise and equity values
    • Implied multiples and perpetuity growth rates
    • Sensitivity analysis via data tables

Location


100 Park Avenue
New York, New York 10017

Event Fees:

Early Registration $ 699.00
Standard Registration $ 750.00

Day 5: Short-Form LBO and M&A Modeling


Dec 15,2017 - Time: 9:00 am - 5:00 pm
This session focuses on LBO and M&A structuring, modeling and analysis. During the first half of the course, principles of LBO valuation will be covered and participants will build a short-form LBO model. The second half of the session introduces participants to modeling M&A transactions, with an emphasis on accretion/dilution analysis.
  • Short-form LBO modeling
    • LBO valuation fundamentals
    • What makes a good LBO target
    • Building a flexible sources and uses of funds table
    • Determining debt capacity
    • Calculating the exit value
    • Calculating the IRR and deriving football field valuation range
    • Sensitivity analysis
  • Short-form M&A modeling
    • Key assumptions and drivers needed to build a short-form M&A model
    • Building a flexible sources and uses of funds table
    • Stock vs. cash financing
    • Earnings accretion/dilution analysis
    • Relative P/E’s: acquirer P/E vs. debt P/E vs. acquisition P/E
    • Snergies-to-break-even analysis
    • Sensitivity analysis
    • Analysis at various prices
    • Ability to pay analysis

Location


100 Park Avenue
New York, New York 10017

Event Fees:

Early Registration $ 699.00
Standard Registration $ 750.00