finance
jack12Part1A.xlsx
Companies
Company Name | Ticker Symbol | Number Of Shares Purchased | Closing Price Of Stock on 1/22/2021 | ||||
Expedia Inc | EXPE | 1500 | 136.52 | ||||
Tripadvisor Inc | TRIP | 2000 | 33.19 | ||||
Lyft Inc | LYFT | 2000 | 47.81 | ||||
Moderna Inc | MRNA | 2000 | 131.02 | ||||
Netflix | NFLX | 400 | 565.17 | ||||
That is not all you want to know about your stock; | |||||||
What was the purchase price? What was the total value of your stock holdings at the beginning and after each tracking week? What exchange | |||||||
is the stock traded on? The assignment require you to invest at least $900K of the million. Do you know how much you have invested? What about | |||||||
the value of a comparable investment in the S&P 500? You need to know and track that for Part 3 and 4 of the Project; track the S$P 500 close just as | |||||||
the stocks so you can compare performances and graph the comparison. |
Expedia
Expedia | ||
Last Dividend | ||
Next Dividend | ||
Date | Closing Price | |
1/22/21 | 205 | |
1/29/21 | 186 | |
2/5/21 | 212 | |
2/12/21 | ||
2/19/21 | ||
2/26/21 | ||
3/5/21 | ||
3/12/21 | ||
3/19/21 | ||
3/26/21 | ||
4/2/21 | ||
4/9/21 | ||
Tripadvisor
Tripadvisor | |
Last Dividend | |
Next Dividend | |
Date | Closing Price |
1/22/21 | 66 |
1/29/21 | 62 |
2/5/21 | 72 |
2/12/21 | |
2/19/21 | |
2/26/21 | |
3/5/21 | |
3/12/21 | |
3/19/21 | |
3/26/21 | |
4/2/21 | |
4/9/21 |
Lyft
Lyft | ||
Last Dividend | ||
Next Dividend | ||
Date | Closing Price | |
1/22/21 | 96 | |
1/29/21 | 89 | |
2/5/21 | 106 | |
2/12/21 | ||
2/19/21 | ||
2/26/21 | ||
3/5/21 | ||
3/12/21 | ||
3/19/21 | ||
3/26/21 | ||
4/2/21 | ||
4/9/21 |
Moderna
Moderna | |||
Last Dividend | |||
Next Dividend | |||
Date | Closing Price | ||
1/22/21 | 262 | ||
1/29/21 | 346 | ||
2/5/21 | 352 | ||
2/12/21 | |||
2/19/21 | |||
2/26/21 | |||
3/5/21 | |||
3/12/21 | |||
3/19/21 | |||
3/26/21 | |||
4/2/21 | |||
4/9/21 |
Sheet1
Netflix
Netflix | ||
Last Dividend | ||
Next Dividend | ||
Date | Closing Price | |
1/22/21 | 226 | |
1/29/21 | 213 | |
2/5/21 | 220 | |
2/12/21 | ||
2/19/21 | ||
2/26/21 | ||
3/5/21 | ||
3/12/21 | ||
3/19/21 | ||
3/26/21 | ||
4/2/21 | ||
4/9/21 |