From the course: Comparable Valuation Analysis
Join today to access over 25,600 courses taught by industry experts.
Completed model preview
From the course: Comparable Valuation Analysis
Completed model preview
Now, of course, our model only has one comp, so all of the multiples, the average, the median, they're all going to be the same. Of course, the football field chart does not look proper. Again, that's because we only have the one comp, Tesco. Let's take a look at the completed file, and you can see the football field chart and Sainsbury. Here we are. This is what the completed model will look like. You can see on the right-hand side, we have Tesco and then Sainsbury just beneath it. And then we have the target company implied share price, and it's a football field layout. Uh, we've also added averages as well. And what we did, we just created a fictitious target company, entered EBITDA, EPS, net debt, and shares outstanding so that we can calculate the implied share price again using either the EV to EBITDA method or the PE method. When you get Sainsbury done, this is what it will look like and it's a really, really slick chart. If you want to learn how to build really great…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.