TMNT Consulting Services has the following capital structure:

$\backslash$table$[[$Source$,$Book Value,Quantity$],[$Common Stock,$$700,000\mathrm{.}00,4,000],[$Preferred Stock,$$1,050,000\mathrm{.}00,15,000],[$Debt$,$$$5,000,000\mathrm{.}00,5,000]]$

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 $$5$ 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\mathrm{.}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\%$

$\backslash$table$[[$Bonds$],[$Current Maturity,$],[$Coupon Rate,$],[$Frequency$,],[$Par Value,$],[$Price$,],[$Yield to Maturity,$],[$After$-$Tax Cost of Debt,$]]$

$\backslash$table$[[$Preferred Stock$],[$Dividend$,],[$Price$,],[$Cost of Preferred Equity,$]]$

$\backslash$table$[[$Common Stock$],[$Dividend$,],[$Growth Rate,$],[$Price$,],[$Cost of Common Stock,$]]$

A $-$ Calculate the book$-$value weights for each source of capital.

$\backslash$table$[[$Source$,$Weight$],[$Common Stock,$],[$Preferred Stock,$],[$Debt$,]]$

B $-$ Calculate the market$-$value weights for each source of capital.

$\backslash$table$[[$Source$,$Weight$],[$Common Stock,$],[$Preferred Stock,$],[$Debt$,]]$

C$.$ Calculate the component costs of capital for each source of capital.

$\backslash$table$[[$Source$,$cost$],[$Common Stock,$],[$Preferred Stock,$],[$Debt$,]]$

D$-$ Calculate the weighted average cost of capital using both the book value and market value weights.

$\backslash$table$[[$Method$,$WACC$],[$Book Value,$],[$Market Value,$]]$

With excel formulas please