Suppose that in August 1997 you purchased shares in Staples, Inc. (NASDAQ: SPLS). It is now five
Question:
Suppose that in August 1997 you purchased shares in Staples, Inc. (NASDAQ: SPLS). It is now five years later and you decide to evaluate your holdings to see if you have done well with this investment. The table below shows the market prices of SPLS.
a. Enter the data, as shown, into a worksheet and format the prices to display as fractions in sixteenths.
b. Create a formula to calculate your rate of return for each year.
c. Create a line chart showing the stock price from August 1997 to August 2002. Make sure to title the chart and label the axes.
d. Experiment with the formatting possibilities of the chart.
For example, you might try changing the line to a three dimensional line and fill the plot area with a marble background.
Step by Step Answer:
Financial Analysis With Microsoft Excel 2002
ISBN: 9780324178241
3rd Edition
Authors: Timothy R. Mayes, Todd M. Shank