Demanda Communications has $4,681,000$ shares outstanding of common stock, $550,000$ shares outstanding of preferred stock, and $160,000$ bonds issued. The current prices of the securities are: common stock, $$40\mathrm{.}62$; preferred stock, $$84\mathrm{.}37$; bonds, $$1053.$ What weight does preferred stock hold in the firm's capital structure?

Please show work in excel spreadsheet

$36\mathrm{.}05\%$

$31\mathrm{.}17\%$

$11\mathrm{.}46\%$

$23\mathrm{.}10\%$

$48\mathrm{.}99\%$