please show excel formulas

QuestioIT & TMNT Consulting Services has the following capital structure: Source Common Stock Preferred Stock Debt Current Maturity Coupon Rate Frequency Par Value Debt is represented by bonds issued 5 years ago with an original maturity of 12 years, a coupon rate of 6%, and a current price of $750. The bonds pay interest semiannually. The preferred stock pays a 55 dividend annually and is currently priced at $70 per share. The common stock is currently priced at $30 and is expected to pay a dividend of $1.25 next year. It is also expected to increase the dividend by 4% a year from here on out. Assume that TMNT pays a marginal tax rate of 35% Price Yield to Maturity After-Tax Cost of Debt Source Common Stock Preferred Stock Debt Bonds A-Calculate the book-value weights for each source of capital Source Common Stock Preferred Stock Debt Book Value $ 700,000.00 $1,050,000.00 $5,000,000.00 Source Common Stock Preferred Stock Debt B-Calculate the market value weights for each source of capital. Weight Method Book Value Market Value Quantity 4,000 15,000 5,000 Weight C-Calculate the component costs of capital for each source of capital. Cost WACC Preferred Stock D-Calculate the weighted average cost of capital uning both the book value and market value weights Dividend Price Cost of Preferred Equity Common Stock Dividend Growth Rate Price Cost of Common Stock