Build a Trading Comps Valuation Model
4.8 (60 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,048 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Build a Trading Comps Valuation Model to your Wishlist.

Add to Wishlist

Build a Trading Comps Valuation Model

Learn to build and analyze the single most common model in investment banking. Includes a complete comps model in Excel.
4.8 (60 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,048 students enrolled
Created by Wall Street Prep
Last updated 9/2014
English
Current price: $10 Original price: $50 Discount: 80% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 7 hours on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • At course completion, you will have developed a comprehensive "Wall Street quality" Trading Comps model from scratch.
View Curriculum
Requirements
  • Wall Street Prep's Financial Statement Modeling Course, an introductory knowledge of accounting and corporate finance, as well as proficiency 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
Who is the target audience?
  • Investment banking professionals
  • Students seeking a lucrative finance career
Students Who Viewed This Course Also Viewed
Curriculum For This Course
55 Lectures
06:47:35
+
Trading Comps Modeling Introduction
8 Lectures 55:00



Trading Comps Overview
05:18

Reading Comps FAQs & Common Misconceptions
07:46

PE & PEG Ratios
08:01

P/B. EV/Rev, EV/EBIT, EV/EBITDA & Industry Multiples
10:45

Comps Process & Simple Exercise
08:28
+
Spreading EXTR
23 Lectures 02:45:25
Comps Screening
08:16

Extreme Networks & Peer Group
07:01

Comps Template Preview
09:54

Modeling Exercise: Inputting General Info
09:45

Shares Outstanding Overview
08:40

Shares Outstanding - Options
07:02

Shares Outstanding - Splits & Dual Classes
03:46

Shares Outstanding - Convertible Preferred Stock
11:27

Shares Outstanding - Convertible Debt
00:55

Shares Outstanding - Convertible Exercise
11:12

Shares Outstanding - Restricted Stock
02:48

Modeling Exercise: Inputting Shares Data
06:04

Modeling Exercise: Inputting Shares Data, Part 2
07:25

Modeling Exercise: Inputting Historicals
03:08

Modeling Exercise: Inputting Historicals, Part 2
04:56

Modeling Exercise: Non-GAAP Adjustments
11:10

Modeling Exercise: Non-GAAP Adjustments, Part 2
12:33

Modeling Exercise: Non-GAAP Adjustments, Part 3
08:21

Net Debt Concepts
05:06

Modeling Exercise: Non-GAAP Adjustments, Part 4
04:30

Modeling Exercise: Net Debt & Estimates
07:30

Calendarization Concepts
02:44

Modeling Exercise: Calendarization
11:12
+
Spreading BRCD
5 Lectures 43:02
Modeling Exercise: Inputting General & Shares Data
09:22

Modeling Exercise: Inputting Financials
05:23

Modeling Exercise: Non-GAAP Adjustments, Part 1
13:20

Modeling Exercise: Non-GAAP Adjustments, Part 2
08:37

Modeling Exercise: Calendarization, Net Debt & Estimates
06:20
+
Spreading JNPR
3 Lectures 25:44
Modeling Exercise: Inputting General & Shares Data
09:45

Modeling Exercise: Inputting Financials & Non-GAAP Adjustments
11:25

Modeling Exercise: Calendarization, Net Debt & Estimates
04:34
+
Spreading CSCO
3 Lectures 22:01
Modeling Exercise: Inputting General & Shares Data
06:42

Modeling Exercise: Inputting Financials & Non-GAAP Adjustments
09:05

Modeling Exercise: Net Debt & Estimates
06:14
+
Comps Output
4 Lectures 39:25
Modeling a Dynamic Comps Output Sheet, Part 1
17:40

Modeling a Dynamic Comps Output Sheet, Part 2
09:18

Modeling a Dynamic Comps Output Sheet, Part 3
06:55

Building a Football Field Matrix
05:32
+
Additional Comps Exercises, ARUN & FFIV
3 Lectures 13:31
Exercise Introduction
00:42

Exercise Review
12:29

Conclusion
00:20
+
Appendix - GAAP to Non-GAAP Adjustments
6 Lectures 43:19
Introduction & Stock Based Compensation
05:46

Unusual or Infrequent Items
04:30

Non-GAAP Presentation on Financial Statements
04:16

Normalizing Earnings Exercise, Part 1
07:35

Normalizing Earnings Exercise, Part 2
11:47

Nonrecurring Items Overview
09:25
About the Instructor
Wall Street  Prep
4.5 Average rating
444 Reviews
3,128 Students
4 Courses
The global leaders in financial training

Wall Street Prep was founded in 2003 by a group of JP Morgan investment bankers with a simple goal: To make the “investment banking skill-set” available to anyone who wants to learn it. Each year, our innovative courses are used by over 5,000 professionals and students. Over 150 investment banks, private equity firms, and investment funds use Wall Street Prep to train new and experienced analysts and associates. In addition, over 50 business schools, including Wharton, Oxford, INSEAD, LSE, Kellogg, Booth, MIT, and Cornell use Wall Street Prep to better prepare their students for careers in finance.