+ Pillars of Wall Street – Hobart and William Smith Colleges \

Career Services

Career Services: Employers

Pillars of Wall Street

To register, please complete the form in Handshake by Sunday, December 13th.

All participants will receive personalized login instructions from our contact at Pillars of Wall Street by December 15th with login information.

Topics will include:

eLearning: Self-study videos
Pillars offers an eLearning suite of self-study videos and drills to complement and enhance live training. The Pillars suite of videos covers accounting, Excel, 3 statement financial modeling and valuation fundamentals including building a high level DCF and LBO.

ACCOUNTING
This video is designed for those participants without a prior accounting background. A Pillars instructor guides participants through the main concepts during the video.

  • Overview and key links between the 3 financial statements
  • Impact of transactions on the 3 financial statements
  • Income statement
    • Revenue and expenses
    • Profitability
    • EBIT and EBITDA
  • Balance sheet
    • Operating working capital
    • Fixed assets
    • Capital expenditures
    • Depreciation
    • Debt
    • Common stock
    • Retained earnings
  • Cash flow statement
    • Operating, investing and financing cash flows

INTRODUCTION TO EXCEL
This video is designed for those participants that have a limited background using Excel. A Pillars instructor guides participants through the main concepts during the video including formula construction, navigation and key Excel shortcuts.

  • Excel fundamentals
    • Optimal excel settings
    • Key shortcuts
    • Formula construction

3 STATEMENT MODELING
This video is designed to introduce 3 statement modeling. A Pillars instructor guides participants through the main concepts during the video which involve building out a fully integrated 3 statement model including income statement, balance sheet and cash flow statement along with supporting schedules.

  • 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

VALUATION OVERVIEW
This video is designed to introduce the concept of valuation. A Pillars instructor guides participants through the main concepts during the video including equity vs. enterprise value, along with the 4 primary valuation methodologies.

  • What is enterprise value
  • What is equity value
  • Fundamental vs. relative valuation
  • 4 primary valuation techniques
    • Trading comparables
    • Transaction comparables
    • DCF
    • LBO
  • Strengths and weaknesses of each valuation technique

VALUATION MODELING
This video is designed to put the valuation principles learned during the valuation overview module to practice in Excel.

  • DCF
  • Trading comparables
  • LBO
  • Sum of the parts

Contact

Salisbury Center for Career, Professional and Experiential Education
300 Pulteney Street
Geneva, NY 14456

Phone: (315) 781-3514
Fax: (315) 781-3515
E-Mail: cso@hws.edu

Location: The Salisbury Center for Career, Professional and Experiential Education is located on the 1st floor of Trinity Hall

Office Hours: Monday-Friday, 8:30 a.m. - 5 p.m.

For upcoming events go to Handshake.

Meet the Staff