Question: For an answer to be graded as correct, you must use an Excel formula: 1. Begin each formula with an = sign. 2. Reference cells,


For an answer to be graded as correct, you must use an Excel formula: 1. Begin each formula with an = sign. 2. Reference cells, instead of entering values. Example: =B3+C3 The Dahlia Flower Co. has earnings of $3.64 per share. The benchmark PE for the company is 18 . What stock price would you consider appropriate? What if the benchmark PE were 21 ? Input area: \begin{tabular}{|lr|} \hline EPS & $3.64 \\ Benchmark PE & 18 \\ Benchmark PE & 21 \\ \hline \end{tabular} (Use cells A6 to B8 from the given information to complete this question.) Output area: \begin{tabular}{|l|l|l|} \hline Stock price at PE of 18 & & \\ \cline { 1 - 2 } Stock price at PE of 21 & & \\ \hline \end{tabular} Students: The scratchpad area is for you to do any additional work you need to solve this question or can be used to show your work. Nothing in this area will be graded, but it will be submitted with your assignment
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
