Show your work using EXCEL SPREADSHEET. Suppose that you have the following Information:

The cost of debt {rd} is 3.75% {before tax}, Flotation costs (F) = T96 of issue price, The debt is trading at $1,022.00, There are 7,250 bonds outstanding, The tax rate is .32, The LAST dividend paid yesterday {Du }i = $4.66, The expected constant growth rate {g} = 2.15%, Beta = 1.65, rRF = 1.04%, RP... = 4.?5%, (market risk premium} The firm has 200,000 shares of common stock outstanding, Common stock shares are trading at 55?.34lshare {PD}