can you show me how each cell is done in excel. thank you

F13 P14-11M (change the current market price to $32 per share and the dividend percentage to 8.0%) Cost of Proferred Stock Market Price Par Value Dividend Percent Dividend Amount 9 10 1 Cost of Preferred Stock 12 11 14 15 16 17 18 19 21 23 26 26 27 29 0 31 12 11 33 36 19 18 (Computing the cost of preferred stock) The preferred stock of Walter Industries Inc. currently sells for $36 a share and pays a 10 percent dividend on the $25 par value of the shares annually. What is the firm's cost of capital for the preferred stock