Question: Need the blank boxes filled in using excel format. The correct answers to the lower boxes are given off the right of them, they just

 Need the blank boxes filled in using excel format. The correct

Need the blank boxes filled in using excel format. The correct answers to the lower boxes are given off the right of them, they just need to be entered using excel format. Thanks!

HD Projected share price $ Price Revenuse (SM) Net Income (SM) # of shares out (M) Operating Cash Flows (SM) 2014 104.97 $ 78,812 5,385 1,434 7,628 2015 132.25$ 83,176 6,345 1,346 8,242 2016 134.08 $ 88,519 7,009 1,283 9,373 2017 189.53 $ 94,595 7,957 1,234 9,783 2018 171.82 $ 100,904 8,630 1,184 12,031 Average 2019 218.38 108,203 11,121 1,143 13,038 EPS SPS CFPS P/E P/SPS P/CFPS Growth Rate EPS_G SPS_G CFPS_G 20.97% 11.49% 16.48% P/E method P/SPS methd P/CFPS method $ $ $ 305.96 224.96 264.95 HD Projected share price $ Price Revenuse (SM) Net Income (SM) # of shares out (M) Operating Cash Flows (SM) 2014 104.97 $ 78,812 5,385 1,434 7,628 2015 132.25$ 83,176 6,345 1,346 8,242 2016 134.08 $ 88,519 7,009 1,283 9,373 2017 189.53 $ 94,595 7,957 1,234 9,783 2018 171.82 $ 100,904 8,630 1,184 12,031 Average 2019 218.38 108,203 11,121 1,143 13,038 EPS SPS CFPS P/E P/SPS P/CFPS Growth Rate EPS_G SPS_G CFPS_G 20.97% 11.49% 16.48% P/E method P/SPS methd P/CFPS method $ $ $ 305.96 224.96 264.95

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!