Wall Street Prep

Welcome back to the Wall Street Prep Quick Lesson Series!

In the two-part lesson below, we’re going to walk through the single most common model in investment banking: the trading comparables (comps) model. The comps model is at once the most ubiquitous and the most straight-forward model you’ll likely be asked to build as an investment banking analyst or associate.

Ready to Model? Before diving in to the videos below, be sure to download this lesson's Excel model template: Simple Comps Template.

The Comps Model, Video 1

The Comps Model, Video 2

Comments
avatar
  Subscribe  
newest oldest most voted
Notify of
Michelle Trinh
Michelle Trinh

I have been following all the tutorials. They are very helpful! I am also interested in finding out how best a financial forecast model can be set up if one is considering to establish a new business. It should cover set up capital, cash flow, 10 year financial forecast, income… Read more »

CHARLES YOMEKPE
CHARLES YOMEKPE

Thanks very much, its very useful

Carlos Gutierrez
Carlos Gutierrez

if analyzing with Q3, the LTM would be the YTD Q3 current year + LY - YTD Q3 previous year?

Arihant
Arihant

So I have seen the first video of this tutorial. My doubt is how do we arrive at Year 1 forecast and Year 2 forecast of the comparable companies? Are they the previous year financials data or are these projected on certain assumptions?

Emmanuel Egqu
Emmanuel Egqu

Thank you for this tutorial. It is very educating. Keep it up.

Krishnakamal Paul
Krishnakamal Paul

Really the lesson is very helpful to take decision for investment.

Thanks a lot.
Regards,

KK Paul

X

The Wall Street Prep Quicklesson Series

7 Free Financial Modeling Lessons

Get instant access to video lessons taught by experienced investment bankers. Learn financial statement modeling, DCF, M&A, LBO, Comps and Excel shortcuts.