TMNT Consulting Services has the following capltal 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 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$[[$Sour$,,$Cost$],[$Common Stock$],[$Preferred$.$Stock$],[D,$Instructions,Your Info$]]$

Ready

Accessibility: Investigate

Could i get the EXCEL functions for this please