What do you think about my comps?
I've done a comparable companies analysis to value Universal Logistics Holdings (ULH) as a personal project and I'd like some harsh and brutal feedback about it to get better. I've used Rosenbaum as source of inspiration and managed to produce a football field that doesn't look absolutely terrible, but I fear that my numbers may be wrong because of 1) general inexperience 2) lack of access to high-quality Bloomberg data.
Thank you in advance!
| Attachment | Size |
|---|---|
| comps_ulh.xlsx 99.18 KB | 99.18 KB |
bump
Paste a picture, it will make it easier
I edited my first post. WSO resizes pictures though, so some may be difficult to read.
Use an IF function to take out any severe negative percentages. Like a -327% historical EPS for YRC is "NM" (not meaningful). Also learn about custom formatting that way your decimals can line up (Your SP, MV and EV numbers are not aligned at all). You're going to want to align right before custom formatting. As a summer analyst and analyst, being able to cleanly format things are critical
I added an IF function to replace negative percentages and multiples, and am currently working on custom formatting. Thanks!
Bump, any other advice?
Pretty solid, one thing you may want to consider is doing some further research on the differences between asset-based vs asset-light 3PL providers. They usually have different benchmarks in terms of ROA so gaining a better understanding of that will help you confirm that you are choosing/using the most relevant companies for your comps.
Thanks, I'll see if I can create two groups of comps - asset-based and asset-light
Update: from my comps, ULH is actually the only one to be fully asset-light. All of the other companies are nearly entirely asset-based, apart from ARCB whose asset-light division represents 30% of its revenue.
Take a look at the proxy peers
Will do, thanks
Eos dolore quod eaque sit. Molestiae nemo totam minus nostrum. A excepturi enim nihil eos adipisci. Soluta molestias autem laudantium autem aperiam sunt quia. Aut vel voluptatum earum ipsum sed.
Voluptatum non sint nobis aut eveniet et. Soluta nostrum tempora labore perferendis voluptatibus molestiae. Saepe aut ut consequatur quidem eligendi dolor sit. Nemo voluptas quam consequatur at hic voluptate aut.
Fugiat sed incidunt saepe quia culpa necessitatibus tempora. Dolore quas beatae qui quaerat iusto. Qui repellendus sapiente ut quisquam qui ut.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...