please show work in excel

2. The Yakuza Corporation has 3 million shares of common stock outstanding with a current price of $26 and per share; 450,000 shares of preferred stock currently trading at $62 and paying an $8 annual dividend per share; and 50,000 bonds outstanding with 15 years to maturity, a 7% semiannual coupon, $1,000 par value and $900 price per bond. The firm also has $8.6 million in marketable securities listed on their balance sheet; a beta of 1.67 ; and a tax rate of 40%. U.S. Treasuries are currently yielding 3% per year and the expected retum on the S\&P 500 is 12.5%. a. What are the market value weights for equity, debt, and preferred stock? b. What are the required returns for equity, debt, and preferred stock? c. What is the firm's weighted average cost of capital, WACC? d. What is the intrinsic value per share using the corporate valuation method if the firm eamed $16 million in free cash flow last year and expects this to grow at a constant annual rate of 3% going forward? Hint: use the market values of debt and preferred sharer computed in part (a) to find the implied value of equity and use the given number of shares outsianding fo find the implied share price