Can you calculate on an excel worksheet? Daves Inc. recently hired you as a consultant to estimate the companys WACC. You have obtained the following information. (1) The firm's bonds have a YTM of 6%. (2) The companys tax rate is 40%. (3) The risk-free rate is 3.5%, the market risk premium is 6.5%, and the stocks beta is 1.1. (4) The target capital structure has a debt to equity ratio equals to 2. The firm uses the CAPM to estimate the cost of common stock, and it does not expect to issue any new shares.

What is its WACC? What is the weighted average cost of capital for a firm with the following sources of funds and corresponding required rates of return: $6 million common stock at 12%, $1 million preferred stock at 8%, and $5 million debt at 6%. All amounts are listed at market values and the firm's tax rate is 35%.