Share
Explore BrainMass

Use a regression to estimate Industry P/E ratios while controlling for risk, growth and payout. Do you recommend manipulating this data in any way prior to your estimation?

A. Use a regression to estimate Industry P/E ratios while controlling for risk, growth and payout. Choose and justify your choice of which P/E ratio you estimate.
Do you recommend manipulating this data in any way prior to your estimation?

b. Your boss, the research director, wants his analysts to concentrate on companies in the Coal Industry, which he feels is undervalued. Using your calculations, can you confirm his opinion on the Coal Industry?

c. What are the drawbacks or hesitations you have about the ability of your analysis to find undervalued industries?

d. There are a vastly different number of firms within each industry, which you have essentially ignored to this point. Should you be concerned about this? Why or why not?

** See ATTACHED file(s) for more information **

Attachments

Solution Preview

** See ATTACHED file(s) for more information **

a. Use a regression to estimate Industry P/E ratios while controlling for risk, growth and payout. Choose and justify your choice of which P/E ratio you estimate.
Do you recommend manipulating this data in any way prior to your estimation?

I would use the current PE ratio. The growth, Payout and Beta are related to the current P/E ratio.
The trailing earnings may have had growth that is already captured in the current earnings, using this PE with the growth expected from here forward would not capture the growth that has occurred between the trialing period and the current period. Similarly, you wouldn't use a trailing price to see if the industry was overvalued, because you would only find how the industry is valued relative to its old valuation, not what it is currently worth.
The forward earnings are estimates that likely reflected the ...

Solution Summary

You will find the answer to this puzzling assignment inside...

$2.19