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