Interactive Calendar


« JUL     « AUG September 2017 OCT »     NOV »
SunMonTueWedThuFriSat
         1
2
3
4
5
6
7
8
9
10
11

12

13

14

15

16
17
18
19
20
21
22
23
24
25
26
27
28
29
30

Day 1: Fundamentals of Financial Statement Analysis


Sep 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:

$ 699.00 Early Registration
$ 750.00 Standard Registration


Registration is closed for this event.
For more information or questions, please email:

Day 2: Excel and 3 Statement Forecasting


Sep 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:

$ 699.00 Early Registration
$ 750.00 Standard Registration


Registration is closed for this event.
For more information or questions, please email:

Day 3: Real Company and Cash Sweep Modeling


Sep 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:

$ 699.00 Early Registration
$ 750.00 Standard Registration


Registration is closed for this event.
For more information or questions, please email:

Day 4: Valuation Overview and DCF Analysis


Sep 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:

$ 699.00 Early Registration
$ 750.00 Standard Registration


Registration is closed for this event.
For more information or questions, please email:

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


Sep 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:

$ 699.00 Early Registration
$ 750.00 Standard Registration


Registration is closed for this event.
For more information or questions, please email: