Calculate the industry average beta for Dell, and then using the industry average beta compute the cost of equity for Dell. Does it matter if you use the beta for Dell or the beta for the industry in this case?
Acer Incorporated 1.05
Lenovo Group Limited 1.76
Samsung Electronics Co. LTD 005930.KS .61
Samsung Electronics Co. LTD 005935.KS .61
EMC Corporation 1.08
Assume risk-free rate (Rf) as 5% and expected market return (Rm) as 10% .© BrainMass Inc. brainmass.com October 17, 2018, 3:23 am ad1c9bdddf
To compute the industry average beta, we will compute the average of beta values of Dell and it's competitors.
Industry average beta = (1.37 + 1.29 + 1.15 + 1.05 + 1.45 + 1.63 + 1.76 + 0.76 + 0.61 + 0.61 + 1.08) / 11
= 12.76 / 11
The cost of equity is computed using Capital Asset Pricing Model.
Goff Computer cost of capital, cost of equity and cost of debt
Goff Computer, Inc (GCI): Determine the cost of capital
You have recently been hired by Goff Computer, Inc (GCI), in the finance area. GCI was founded eight years ago by Chris Goff and currently operates 74 stores in the Southeast. GCI is privately owned by Chris and his family and had sales of $97 million last year.
GCI primarily sells to in-store customers. Customers come to the store and talk with a sales representative. The sales rep assists the customer in determining the type of computer and peripherals that are necessary for the individual customer's computing needs. After the order is taken, the customer pays for the order immediately, and the computer is assembled to fill the order. Delivery of the computer averages 15 days, but is guaranteed in 30 days.
GCI's growth to date has been financed from its profits. Whenever the company had sufficient capital, it would open a new store. Relatively little formal analysis has been used in the capital budgeting process. Chris has just read about capital budgeting techniques and has come to you for help. The company has never attempted to determine its cost of capital, and Chris would like you to perform the analysis. Since the company is privately owned, it is difficult to determine the cost of equity for the company. You have determined that to estimate the cost of capital for GCI, you will use Dell as a representative company. The following steps will allow you to calculate this estimate.
1. Most publicly traded corporations are required to submit 10Q (quarterly) and 10K (annual) reports to the SEC detailing their financial operations over the previous quarter or year, respectively. These corporate filings are available on the SEC website at www.sec.gov. Go to the SEC website, follow the "Search for Company Filings" link, the "Companies & Other Filers" link, enter "Dell Computer", and search for SEC filings made by Dell. Find the most recent 10Q and 10K and download the forms. Look on the balance sheet to find the book value of debt and the book value of equity. If you look further down the report, you should find a section titled either "Long-term Debt" or "Long-term Debt and Interest Rate Risk Management" that will list a breakdown of Dell's long-term debt.
2. To estimate the cost of equity for Dell, go to finance.yahoo.com and enter the ticker symbol "DELL". Follow the various links to find answers to the following questions: What is the most recent stock price listed for Dell? What is the market value of equity, or market capitalization? How many shares of stock does Dell have outstanding? What is the beta for Dell? Now go back to finance.yahoo.com and follow the "Bonds" link. What is the yield on 3-month Treasury bills? Using the historical market risk premium, what is the cost of equity for Dell using the CAPM?
3. Go to investor.reuters.com and find the list of competitors in the industry. Find the beta for each of these competitors, and then calculate the industry average beta. Using the industry average beta, what is the cost of equity? Does it matter if you use the beta for Dell or the beta for the industry in this case?
4. You now need to calculate the cost of debt for Dell. Go to www.finra.org/marketdata.com, enter Dell as the company and find the yield to maturity for each of Dell's bonds. What is the weighted average cost of debt for Dell using the book value weights and the market value weights? Does it make a difference in this case if you use book value weights or market value weights?
5. You now have all the necessary information to calculate the weighted average cost of capital for Dell. Calculate the weighted average cost of capital for Dell using book value weights and market value weights assuming Dell has a 35% marginal tax rate. Which cost of capital number is more relevant?
6. You used Dell as a representative company to estimate the cost of capital for GCI. What are some of the potential problems with this approach in this situation? What improvements might you suggest?
(Hint: The most current Dell 10K that needs to be used for this, can be found at this link:
Also, can you provide an excel spreadsheet for all calculations involved?