Pillars core classes in one bundle!
This pillar focuses on the core accounting, valuation, and modeling skills that will launch you to the next level. You will begin with Financial Statement Analysis, one of the most important financial literacy courses you can take. This highly interactive course will walk you through the key concepts every finance practitioner should know in order to prepare you for financial modeling. From there, move on to our popular Valuation Fundamentals course, where we lay down the foundation for your valuation practice. With your foundations prepared, you can bring it into Excel with four modeling courses, which will train you to build a 3-statement model, an LBO, a DCF, and a comparable companies analysis.
No prior experience is required.
Key learning points:
- Financial statement analysis
- Excel shortcuts and optimal formula construction
- 3 statement modeling
- Enterprise and equity value
- Four primary valuation methodologies
- DCF
- LBO
- Transaction comps
- Trading comps
Courses included:
Advanced Excel Charting
Move past basic charts – make them pop with Adv. Excel Charting
Advanced Excel: Formula Mastery
Learn how to maximize productivity by mastering advanced Excel formulas in easy to use examples
Quick M&A Analysis
Learn high level M&A analysis by building a quick introductory M&A model
Short-Form M&A Modeling
Master M&A fundamentals by building a short-form M&A model
Short-Form LBO Modeling
Master the fundamentals of leveraged buyouts and PE value creation by building a short-form LBO model
Valuation Modeling
Model the primary valuation techniques by building comps, DCF and LBO models in Excel
Financial Statement Analysis (FSA)
Learn the fundamentals of accounting and the relationships between the 3 financial statements with Pillars’ most popular course
Real Company: Mandatory Cash Sweep Modeling
Build a fully integrated 3 statement operating model incorporating a cash sweep debt schedule with mandatory payments
Real Company Modeling
Build a 3 statement (non-cash sweep) operating model for a real company
Real Company: Cash Sweep Modeling
Build a fully integrated 3 statement operating model incorporating a cash sweep debt schedule
Excel Modeling Fundamentals
Master the fundamentals of Excel including key shortcuts and formula construction
DCF Modeling
Learn DCF theory and complete a full DCF model including a detailed WACC analysis
3 Statement Modeling
Construct a 3 statement model including supplementary calculation and debt schedules
Valuation Fundamentals
Distinguish enterprise value from equity value and identify the pros and cons of the 4 primary valuation methodologies
Intro to Modeling
Learn the fundamentals of 3 statement modeling while constructing an income statement, balance sheet, and cash flow statement