DCF - WACC
- 02:43
Showing how to get the numbers for WACC from Felix.
Glossary
WACC Weighted Average Cost of CapitalTranscript
We've got our free cash flows done. We've checked some ratios. Now we need to move on to the wack. We can get these figures from Felix. There are two ways I could start to build these up. I could start by going to data then for United States because we're looking at a US company and then go to discount rates. Here I can see I've got my risk-free rate here for the 10 year government bond yield 4.16, and I could start to pick up figures from here. Alternatively though, I can go straight to ATI's page and on ATI's page, I go to the valuation tab and we've got a calculating WAC table here. I just need to make sure that I've got the right settings. The government bond yield of 10 years, that's exactly what we wanted. That's the 4.16 that we saw on the previous data tab. But the equity risk premium, we were told in the handout to use a custom 5%. If I go down to custom, and I've typed the 5% in there already. Next up for the adjusted beta, you might have yours on company. You'd have to change that to industry. But if I scroll down to the list of companies included in the industry, we've only got Texas in here so far. If I go back to the handout and remind myself which companies should be in here, we should have How Mets Reliance and Carpenter Tech core. So let's put Halme Aerospace in together. So HWM. So I go down to there, take a type in HWM or just type in the name, click on it and the comps updates. Let's do the other two. So RS was for Alliance and CRS Carpenter Technology, and now my industry is correct, and if I scroll back up, my adjusted beta has updated. I've now got all the figures that I need. They've all been calculated. My WAC updates as all these numbers at the top updates. I now just need to copy these into Excel. So here I am. I've copied all of those figures from Felix into my calculating WAC section here. It's the WAC at the bottom. That's the important one that we needed, but it's nice to have the figures there if you wanted to build up this wack yourself and check that it was correct. The last one is the terminal growth rate, and we need to make a decision here. I'm going to link this up to the growth in invested capital that we had that was 2.6%. Linking to this 2.6% is going to make sure that our growth and free cash flows is consistent with our growth that goes into the terminal value calculation.