Please show your work in excel.

LO 11-3 11.11 Calculating the Cost of Capital. Whirlpool manufactures and sells home appliances under various brand names. IBM develops and manufactures computer hardware and offers related technology services. Target operates a chain of general merchandise discount retail stores. The data in the following table apply to these companies (dollar amounts in millions). For each firm, assume that the market value of the debt equals its book value. Whirlpool IBM Target $44,106 $13,532 $ 2,597 6.196 $109,524 $ 33,925 4.3% $18,752 4.9% Total assets Interest-bearing debt Average pretax borrowing cost Common equity: Book value Market value Income tax rate Market equity beta $ 3,006 $ 2,959 35.0% 2.27 $ 13,465 $110,984 35.0% 0.78 $13,712 $22,521 35.0% 1.20 Required a. Assume that the intermediate-term yields on U.S. government Treasury securities are 3.5%. Assume that the market risk premium is 5.0%. Compute the cost of equity capital for each of the three companies. b. Compute the weighted average cost of capital for each of the three companies. c. Compute the unlevered market (asset) beta for each of the three companies. d. Assume that each company is a candidate for a potential leveraged buyout. The buyers intend to implement a capital structure that has 75% debt (with a pretax borrowing cost of 8.0%) and 25% common equity. Project the weighted average cost of capital for each company based on the new capital structure. To what extent do these revised weighted average costs of capital differ from those computed in Requirement b