please show all work in excel

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 return on the S&P 500 is 12.5%.

1. What are the market value weights for equity, debt, and preferred stock?
2. What are the required returns for equity, debt, and preferred stock?