| Stock Analysis Spreadsheet to be used for Activity #4 |
| Last price check is on Wednesday, December 5th. |
| Directions: To Begin: You only need to enter the Stock Symbol, the Original Stock Purchase Price as of 10/31/18, the Number of Shares. (Under the light blue region.) |
| On a daily basis, Enter the Day's Closing Price for each of your stocks. (Under the darker blue region.) Everything else will be calculated for you. |
| There is a Summary of your gains or losses at the bottom of these spreadsheets. These are protected cells. Do not attempt to change them. |
| This first spreadsheet is a example using The Walt Disney Company (DIS). Use the other spreadsheets for your stocks. Prices for DIS are estimates and are used for demonstration purposes. |
| | | | | | | | | Stock I |
| Stock Symbol | Original Stock Purchase Price a/o 10/31/18 | Number of Shares Purchased | Total Purchase Price | | | | | Stock Symbol | Original Stock Purchase Price a/o 10/31/18 | Number of Shares Purchased | Total Purchase Price |
| DIS | $ 109.79 | 50 | $ 5,489.50 | | | | | | | | $ - 0 |
| Date | Day's Closing Price | Amount Change Per Share from Day of Purchase | % Change Per Share from Day of Purchase | Total Gain or (Loss) from Purchase Price | Current Value | Total % Change | | Date | Day's Closing Price | Amount Change Per Share from Day of Purchase | % Change Per Share from Day of Purchase | Total Gain or (Loss) from Purchase Price | Current Value | Total % Change |
| 10/31/18 | 109.79 | $ - 0 | 0.00% | $ - 0 | $ 5,489.50 | 0.00% | | 10/31/18 | 0.00 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| 11/7/18 | 115.21 | $ 5.42 | 4.94% | $ 271.00 | $ 5,760.50 | 4.94% | | 11/7/18 | | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| 11/14/18 | 116.91 | $ 7.12 | 6.49% | $ 356.00 | $ 5,845.50 | 6.49% | | 11/14/18 | | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| 11/21/18 | 112.86 | $ 3.07 | 2.80% | $ 153.50 | $ 5,643.00 | 2.80% | | 11/21/18 | | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| 11/28/18 | 117.13 | $ 7.34 | 6.69% | $ 367.00 | $ 5,856.50 | 6.69% | | 11/28/18 | | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| 12/5/18 | 111.61 | $ 1.82 | 1.66% | $ 91.00 | $ 5,580.50 | 1.66% | | 12/5/18 | | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| Stock II | | | | | | | | Stock III |
| Stock Symbol | Original Stock Purchase Price a/o 10/31/18 | Number of Shares Purchased | Total Purchase Price | | | | | Stock Symbol | Original Stock Purchase Price a/o 10/31/18 | Number of Shares Purchased | Total Purchase Price |
| | | | $ - 0 | | | | | | | | $ - 0 |
| Date | Day's Closing Price | Amount Change Per Share from Day of Purchase | % Change Per Share from Day of Purchase | Total Gain or (Loss) from Purchase Price | Current Value | Total % Change | | Date | Day's Closing Price | Amount Change Per Share from Day of Purchase | % Change Per Share from Day of Purchase | Total Gain or (Loss) from Purchase Price | Current Value | Total % Change |
| 10/31/18 | 0.00 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | ERROR:#DIV/0! | | 10/31/18 | 0.00 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| 11/7/18 | | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | ERROR:#DIV/0! | | 11/7/18 | | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| 11/14/18 | | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | ERROR:#DIV/0! | | 11/14/18 | | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| 11/21/18 | | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | ERROR:#DIV/0! | | 11/21/18 | | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| 11/28/18 | | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | ERROR:#DIV/0! | | 11/28/18 | | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| 12/5/18 | | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | ERROR:#DIV/0! | | 12/5/18 | | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| Stock IV | | | | | | | | Stock V |
| Stock Symbol | Original Stock Purchase Price a/o 10/31/18 | Number of Shares Purchased | Total Purchase Price | | | | | Stock Symbol | Original Stock Purchase Price a/o 10/31/18 | Number of Shares Purchased | Total Purchase Price |
| | | | $ - 0 | | | | | | | | $ - 0 |
| Date | Day's Closing Price | Amount Change Per Share from Day of Purchase | % Change Per Share from Day of Purchase | Total Gain or (Loss) from Purchase Price | Current Value | Total % Change | | Date | Day's Closing Price | Amount Change Per Share from Day of Purchase | % Change Per Share from Day of Purchase | Total Gain or (Loss) from Purchase Price | Current Value | Total % Change |
| 10/31/18 | | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | ERROR:#DIV/0! | | 10/31/18 | 0.00 | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| 11/7/18 | | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | ERROR:#DIV/0! | | 11/7/18 | | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| 11/14/18 | | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | ERROR:#DIV/0! | | 11/14/18 | | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| 11/21/18 | | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | ERROR:#DIV/0! | | 11/21/18 | | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| 11/28/18 | | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | ERROR:#DIV/0! | | 11/28/18 | | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| 12/5/18 | | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | ERROR:#DIV/0! | | 12/5/18 | | $ - 0 | ERROR:#DIV/0! | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| Summary |
| Stock Symbol | Original Purchase Price | Gain or (Loss) from Purchase Price | Current Value | Total % Change |
| 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| 0 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! |
| Value of Portfolio a/o 12/5/18 | $ - 0 | $ - 0 | $ - 0 | ERROR:#DIV/0! |
Beth_n1976!
StockAnalysisSpreadsheetFall2018-875final.xlsx
