This is for business. Thank you!

Cost of preferred stock. Determine the cost for each of the following preferred stocks. Important: Do not use cell references to cells in rows 6 to 10 . For all required answers, use cell references to values starting in row 15. Solution Stock B Par value Sale price Flotation cost Annual dividend Dividend payment Proceed from sale Cost of preferred stock \begin{tabular}{|c|c|} \hline$ & 40 \\ \hline$ & 38 \\ \hlineS & 3.50 \\ \hline & 8% \\ \hline & \\ \hline & \\ \hline & \\ \hline \end{tabular} Stock C Par value Sale price Flotation cost Annual dividend Cost of preferred stock \begin{tabular}{|lr|} \hline$ & 35 \\ \hline$ & 37 \\ \hline$ & 4.00 \\ \hline$ & 5.00 \\ \hline \\ \hline \end{tabular} Stock D Par value Sale price Flotation cost ( % of par) \begin{tabular}{|ll|} \hlineS & 30 \\ \hlineS & 26 \\ \hline & 5% \\ \hline \end{tabular} Flotation cost Annual dividend S3.00 Proceed from sale Cost of preferred stock Stock E Par value Sale price Flotation cost Annual dividend Dividend payment Proceed from sale Cost of preferred stock \begin{tabular}{|lr|} \hline$ & 20 \\ \hline$ & 20 \\ \hline$ & 2.50 \\ \hline & 9% \\ \hline & \\ \hline & \\ \hline & \\ \hline \end{tabular}