From the course: Comparable Valuation Analysis
Unlock this course with a free trial
Join today to access over 25,600 courses taught by industry experts.
Compact model overview
From the course: Comparable Valuation Analysis
Compact model overview
Let's take a quick look at what we are working towards. Here is the completed version of the compact model that we're about to work through. As always, we recommend having a cover page, and you can see we have a table of contents, and those are actually hyperlinks. So we can click those links and it will take us directly to the appropriate worksheet. Now, let's take a look at the summary tab. On the summary tab, once our model is complete, it will look like this. This is what's known as a football field chart and it's a very standard way of presenting valuation results. In this case, we'll show our comparable trading analysis, our precedent transactions, and we also included the DCF analysis as well. This is obviously not the DCF course, but we went ahead and included it. Again, this is a standard presentation when presenting valuation. Then we'll go through our comparable trading analysis where we have our publicly traded peers and we calculate our multiples and then we'll value the…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
(Locked)
Valuation overview2m 6s
-
(Locked)
Market valuation and relative valuation4m 58s
-
(Locked)
Valuation example: Putting it all together2m 26s
-
(Locked)
Compact model overview1m 28s
-
(Locked)
Compact trading multiples4m 3s
-
(Locked)
Compact trading valuation3m 12s
-
(Locked)
Compact transaction valuation2m 35s
-
(Locked)
Football field chart2m 45s
-
(Locked)
-
-
-
-
-
-
-
-
-
-