STOCK MARKET WRAP-UP ACTIVITY
If you have been collecting data from the three stocks of your choice on the Stock Market spreadsheet (link to a fresh copy below), complete the exercises in this wrap-up activity and submit your results to your instructor. It is suggested that you print a copy of the worksheet below before you continue.
MAT 113
NAME:
STOCK MARKET WRAP-UP ACTIVITY WORKSHEET
1. Print a copy of the completed spreadsheet and attach it to this worksheet for submission. ( Hint: In order to get the spreadsheet to print on a single page open File Menu > Open Page Set-up> click on dot for Fit To 1 page wide by 1 page high.)
2. Use Excel to create a connected line chart that shows how the closing price of your three stocks varied over the time you collected data. The chart should include the dates along the horizontal axis and the closing daily cost data for all three stocks along the vertical axis. Label all parts appropriately and print a copy to attach to this worksheet for submission. [Excel Tip (read all steps once before you try this) - To select data in non-adjacent columns use the following steps: 1. Target first cell in column. 2. Press and hold left mouse button. 3. Drag mouse to end of data. 4. Press and hold <Ctrl> key. 5. Let go of mouse button. 6. Target first cell in next data column. 7. Press and hold left mouse button. 8. Drag mouse to the end of data. 9. Let go of mouse button. 10. Let go of <Ctrl> key.]
Summarize the performance of your stocks.
3. a. What was your initial amount to invest?
b. What was the value of your total assets on the last
day you entered data?
c. How much money did you gain/lose?
4. Calculate the Total Return for your investment activity. (show
work) Hint: See page 234 of the text.
5. Approximate the Annual Return for your investment activity
assuming that things will continue as they did for the duration of your
activity. (show work) Hint: See page 234 of the text, in the formula let Y =
the number of weeks of data you collected /52 in one year.
6. Using the Rate you calculated in #5 above how much might you expect to have in assets after 3 years? Do you think this is a good prediction? Why or why not?