Question: please help BIU.L.A. ESSE Merge & Center - $ %, Painter 8 6 Conditional Format -0.0 Cell Formatting as Table - Styles Styles Font Alignment

please help
please help BIU.L.A. ESSE Merge & Center - $ %, Painter 8

BIU.L.A. ESSE Merge & Center - $ %, Painter 8 6 Conditional Format -0.0 Cell Formatting as Table - Styles Styles Font Alignment Number for B D E F G H $ Year Price EPS CFPS SPS 2014 2015 2016 2017 2018 92.00 $ 97.40 $ 103.00 $ 104.50 $ 110.00 $ 4.10 4.15 4.90 5.20 6.80 6.50 7.80 8.40 9.25 11.60 52.60 $ 58.52 $ 57.90 $ 60.69 $ 71.60 $ 2019 120.00 8.00 12.25 78.70 $ Output Area: 21.02 20.10 16.18 PE ratios 22.44 23.47 Average PE EPS growth rate 1.22% Average EPS 5-year growth rate Expected share price using PE ratio 15.00 19.70 17.65% 14.77% 18.07% 6.12% 30.77% 12.26 11.30 9.48 P/CFPS 14.15 12.49 Average P/CFPS CFPS growth rate 20.00% Average CFPS 5-year growth rate Expected share price using P/CFPS 9.80 11.58 5.60% 13.76% 7.69% 10.12% 25.41% 1.664 1.779 1.722 1.536 P/S 1.749 Average P/S SPS growth rate Average sales 5-year growth rate Expected share price using P/S 1.525 1.663 9.92% 8.58% 11.25% -1.06% 4.82% 17.98%

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!