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

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…

Contents