Please provide Excel formulas

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

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

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

TMNT Consulting Services has the following capital structure:

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\%.$

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