please answer the question in excel formula.

B '7) ' C, ' 3 ' : Preferred stock-Excel ? iii X FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In H 'n$,11*A'A' E g?" Paste c B I u - b- A - Alignment Number conditional Formatas C9" Cells Editing \\ v ' _ v v Formatting ' Table ' Styles ' v Clipboard i?- Font i?- Styles A IAI v|= > r: H . A B C D E F G H I J K . I 2 3 Moraine, Inc., has an issue of preferred stock outstanding that pays a $3.50 dividend every year in perpetuity. If this issue currently sells for $85 per share, what is the required return? 4 5 6 Annual dividend 7 Current price 8 9 10 Complete the following analysis. Do not hard code values in your calculations. 11 12 Required return 13 14 15 16 Using the PE ratio - Excel ? 2 5 X FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri 11 A A % Paste V BIU - A Alignment Number Conditional Format as Cell Formatting Table Styles Cells Editing Clipboard Font G Styles Al X V A B C D E F G H I J K- N 3 The Perfect Rose Co. has earnings of $2.35 per share. The benchmark PE for the company is 18. What stock price would you consider appropriate? What if the benchmark PE were 21? U EPS $ 2.35 Benchmark PE 18 Benchmark PE 21 9 10 11 Complete the following analysis. Do not hard code values in your calculations. 12 13 Stock price at a PE of 18 14 15 Stock price at a PE of 21 16 17