can you show me how to do this in excel, exaxt inputs

A B D E F G H 1 J K L M 1 2 3 4 S P10-17 Modified (see problem below) a. What is the value of a preferred stock where the dividend rate is 8.5 percent on a $100 par value, and the market's required yield on similar shares is 10 percent? b. Should you acquire the stock if the current market price is $80.00/share? c. If you purchase the stock for the value $80/share what is your expected rate of return? (Hint - use the formula: Expected rate of return = Dividend dollars on preferred stock/the price of a share of preferred stock) 6 7 8 9 10 11 Preferred Stock Valuation and Expected Rate of Return 12 13 14 15 16 17 18 Par value Current market price Dividend rate Dividend $ Required Rate of Return calc A) Value 19 see page 317, equation 10-6 20 21 B) 22 23 o Expected rate of return 24 25 26 27 28 29 30 31