Brief Introduction
Learn to build and analyze the single most common model in investment banking. Includes a complete comps model in Excel.Description
"Comps" analysis is the most widely used valuation methodology and an essential piece of the core valuation skill set of investment bankers and finance professionals. In this course, you will learn how to select and "scrub" comparables, pick the right multiples, and build complete comps models in Excel from scratch, using a real case study the exact way it's done ay financial institutions.
Lessons include:
- Learn to select appropriate comparable companies by evaluating operational, financial, size, and other similarities
- Set evaluation benchmarks & select comparable companies
- Gather appropriate financial history and projections
- Normalizing operating results and calculating LTM operating results to reflect nonrecurring charges and stock option expenses
- Standardize various expense classifications including FIFO to LIFO inventory accounting
- Calculate shares outstanding using the treasury stock method
- Input financial data & calculate and interpret financial and market ratios
- Presenting trading comps by structuring output schedule
- Selecting key valuation multiples using the VLOOKUP function and generating multiple tables
Requirements
- Requirements
- Wall Street Prep's Financial Statement Modeling Course, an introductory knowledge of accounting and corporate finance, as well as proficiency in Excel.
Wall Street Prep
4.7 Raiting
Build a Trading Comps Valuation Model
- 4.7
-
![]()
![]()
![]()
![]()
![]()
Learn to build and analyze the single most common model in investment banking. Includes a complete comps model in Excel. Lessons include:...
Advanced Stock Options for Serious Equity Investors!
- 3.6
-
![]()
![]()
![]()
![]()
![]()
Master secrets of controlled leverage investing. Use techniques employed by masters like Warren Buffet or George Soros. How's this for Stellar Profits?...
The Complete Domino's Pizza Stock Analysis Training Course
- 4.7
-
![]()
![]()
![]()
![]()
![]()
Learn stock analysis, investing, financial modeling and valuation with a professional Analyst Shorten your learning curve. The course has been designed with “on the job” experience....
Investments I: Fundamentals of Performance Evaluation
- 4.7
-
![]()
![]()
![]()
![]()
![]()
In this course, we will discuss fundamental principles of trading off risk and return, portfolio optimization, and security pricing. The course emphasizes real-world examples and applications in Excel throughout....
