finance

profilejack12
Part1A.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