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.05 (112 reviews)
1,233
students
7 hours
content
Sep 2014
last update
$39.99
regular price
What you will learn
At course completion, you will have developed a comprehensive "Wall Street quality" Trading Comps model from scratch.
Why take this course?
"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
Screenshots
Reviews
Marcelo
December 26, 2020
Estou tendo problemas para baixar o material do curso e não obtive nenhum retorno ao solicitar uma ajuda quanto a este
Awad
October 5, 2020
I have a big problem with regard to the course resources since my PC could not recognize the type of the file so can you tell me what is the extension of the resources files?
Patrick
April 2, 2019
Ein wenig "stotterig" und nicht wirklich stringent über die gesamte Argumentation. Warum ein Haus als Beispiel? Ein Haus erwirtschaftet nichts - und ist in keinster Weise zu einer Firma in Verbindung zu bringen.
Darüber hinaus zu wenig konzeptionell und zu "hands on" - zu beispiellastig und zu wenig präzise wenn es dann wirklich darauf ankommt.
Grady
August 14, 2018
It is good; but not worth 5 stars yet. It is hard to retain some of the information based on how he explains it with very little examples at times. We shall see how it continues!
Paul
April 7, 2016
As with the other courses I've taken from Wall Street Prep, the delivery is really good. They resent topics in a clear, unintimidating manner following a sound logical progression.
Charts
Price
Rating
Enrollment distribution
Related Topics
297762
udemy ID
9/10/2014
course created date
10/14/2023
course indexed date
Bot
course submited by