write a memo 13
Case IV is due at the end of this week.
Prepare a memo in Word, which addresses the questions in the Chapter 12 Case: Cost of Capital For Hubbard Computer, Inc., page 418 of the textbook.
Use Excel to solve any financial calculations and include your original calculations in your Word document Memo.
You will be graded on correct financial analysis, proper use of technology, and a business-like presentation of your assessment of the problem.
You have recently been hired by Hubbard Computer, Inc. (HCI), in its relatively new treasury management department. HCI was founded eight years ago by Bob Hubbard and currently operates 74 stores in the Southeast. HCI is privately owned by Bob and his family, and had sales of $97 million last year.
HCI primarily sells to in-store customers who come to the store and talk with a sales representative. The sales representative 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 made to fill the order. Delivery of the computer averages 15 days, and it is guaranteed in 30 days.
HCIâ€™s growth to date has been financed by its profits. When the company had sufficient capital, it would open a new store. Other than scouting locations, relatively little formal analysis has been used in its capital budgeting process. Bob has just read about capital budgeting techniques and has come to you for help. For starters, the company has never attempted to determine its cost of capital, and Bob 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. Bob wants you to use the pure play approach to estimating the cost of capital for HCI, and he has chosen Dell as a representative company. The following steps will allow you to calculate this estimate.
1.Most publicly traded corporations are required to submit quarterly (10Q) and annual reports (10K) to the SEC detailing the financial operations of the company over the past quarter or year, respectively. These corporate filings are available on the SEC website at www.sec.gov. Go to the SEC website and search for SEC filings made by Dell. Find the most recent 10Q or 10K and download the form. 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 â€œLong-term Debt and Interest Rate Risk Managementâ€ that will provide 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 answer 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 most recent annual dividend? Can you use the dividend discount model in this case? What is the beta for Dell? Now go back finance.yahoo.com to finance.yahoo.com and find 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.You now need to calculate the cost of debt for Dell. Go to www.nasdbondinfo.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?
4.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. Assume Dell has a 35 percent marginal tax rate. Which cost of capital number is more relevant?