Please solve the problem on excel and show me all of the formulas used, thank you

- Skip part a - For part b change market price to $32, dividend paid last year to $2.15 and the growth rate to 3.8% - For part c change the coupon rate to 7.5%, the current market price to $1,085 and the tax rate to 25% - For part d change the dividend percentage to 6.5% and the price the shares would sell for to $78 per share Part B Market Price Dividend paid last year Growth Rate $ $ 32.00 2.15 3.80% Part C Coupon Rate Current Market Price Tax Rate 7.50% $ 1,085.00 25.00% Part D Dividend Percentage Price share (sell) 6.50% 78.00 $ - Skip part a - For part b change market price to $32, dividend paid last year to $2.15 and the growth rate to 3.8% - For part c change the coupon rate to 7.5%, the current market price to $1,085 and the tax rate to 25% - For part d change the dividend percentage to 6.5% and the price the shares would sell for to $78 per share Part B Market Price Dividend paid last year Growth Rate $ $ 32.00 2.15 3.80% Part C Coupon Rate Current Market Price Tax Rate 7.50% $ 1,085.00 25.00% Part D Dividend Percentage Price share (sell) 6.50% 78.00 $