Felix Company Tear Sheet
- 03:25
A guide to Felix Company Tear Sheet.
Downloads
No associated resources to download.
Glossary
Company Tear Sheet FelixTranscript
Now let's take a look at our company tear sheets.
We have company tear sheets for almost 7,000 companies. So let's go into Kellanova, which is the new name for Kellogg. Here you can see that we've got the Kellanova tear sheet. It gives us a little description. At the very top, it's got the latest financial filings, and then underneath it's got our 52 week high and low. We can download the last five years of the price earnings multiple, and the closing share price. We have a dividend yield and a volume weighted average share price. And I can tweak that between 12 months, six months, three months, or one month. Underneath that, we've got some economic data benchmarks, GDP growth, both historic and forecast, and some benchmark funding rates, the secured overnight funding rate and the 3 month treasury yield. Now, in some situations, new analysts don't understand what the item is, so you can click on the label and it will jump you to an explainer of how that item is actually calculated. So this is a great way for an analyst to be able to find data, but also understand it. Now, in addition, we've got an equity to enterprise value bridge here, and we've got the clickable labels as normal. But if I click on one of the numbers, that will take me to the filing where that number comes from, but not just the filing, the exact place in the filing where that number is picked up from. And again, this is a really great tool for new analysts to find out where things come from. We have a WACC calculator on the right, and if your firm has a specific equity risk premium, you can make sure that the WACC calculator uses that, and you can change the risk-free rate, and you can use the use company or industry beta, and that's a great way of just benchmarking a WACC calculation too. Underneath there, we've got our comparables, and this will give you a list of comparables. In this case, Kellogg. And it's given me a few companies here. Some of them are quite small ones and I can manipulate this, so I'm going to remove the small ones, and I'm gonna add another one called General Mills, And that will just add it to the table. Now the table is laid out to help people understand what drives multiples. We've got margins as a proxy for returns, growth rates, and beta as a proxy for risk. And then on the right, we've got some credit comparables too. So this is not just a great tool, it's also laid out to help people understand how to learn. Underneath the very bottom, we've got our consensus estimates, and this gives us revenue estimates, EBITDA estimates, and some margins and EPS estimates as well. So these are really, really great tools. This is just what you need to have as an investment banking analyst.