Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

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

image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Options Futures and Other Derivatives

Authors: John C. Hull

10th edition

013447208X, 978-0134472089

More Books

Students also viewed these Finance questions