Question: I am needing some assistance with Excel formulas ONLY - Please see all data for the below: HD Average Projected share price 2012 2013 2014

 I am needing some assistance with Excel formulas ONLY - Please

I am needing some assistance with Excel formulas ONLY - Please see all data for the below:

see all data for the below: HD Average Projected share price 2012

HD Average Projected share price 2012 2013 2014 2015 2016 2017 Price 61.85 $ 82.34 104.97 $ 132.25 $ 134.08 $ 189.53 Revenuse ($M) 70,395 74,754 78,812 83,176 88,519 94,595 Net Income ($M) 3,883 4,535 5,385 6,345 7,009 7,957 # of shares out (M) 1,570 1,511 1,434 1,346 1,283 1,234 Operating Cash Flows ($M) 6,651 6,975 7,628 8,242 9,373 9,783 EPS SPS CFPS P/E P/SPS P/CFPS Growth Rate EPS_G 21.12% SPS_G 11.32% CFPS_G 13.35% P/E method 211.38 P/SPS methd 163.70 P/CFPS method 173.78

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!