0% found this document useful (0 votes)
118 views13 pages

Stock Performance Spreadsheet

The document summarizes a portfolio of stock investments totaling $1,000,010 across 5 companies over 11 weeks. It includes a spreadsheet with the company name, industry, stock exchange, ticker, number of shares purchased, purchase price, and investment principle for each holding. Charts then track the weekly share price and resulting portfolio value, showing overall gains of over $176,000 during the period.

Uploaded by

annacarolyn
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
118 views13 pages

Stock Performance Spreadsheet

The document summarizes a portfolio of stock investments totaling $1,000,010 across 5 companies over 11 weeks. It includes a spreadsheet with the company name, industry, stock exchange, ticker, number of shares purchased, purchase price, and investment principle for each holding. Charts then track the weekly share price and resulting portfolio value, showing overall gains of over $176,000 during the period.

Uploaded by

annacarolyn
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
You are on page 1/ 13

STOCK MARKET PERFORMANCE SPREADSHEET

INVESTMENT PURCHASE INFORMATION

STOCK
COMPANY INDUSTRY TICKER BETA EPS
EXCHANGE

China COSCO Ship-building industry SHA

Dior Cosmetics FTSE

Disney Theme Parks Dow Jones

Pharmaceutical
Tongrentang SHA
Industry

Hilton Hotels Hotel Industry NYSE


NOTE: 1) Total Investment Principle CANNOT EXCEED US$1.0 M for the 5 companies.
2) Each company can have a larger or smaller investment principle than the other companies.
SPREADSHEET/TEAM NAME:
E INFORMATION
TOTAL PURCHASE
NUMBER OF PRICE PER INVESTMENT
PER
SHARES SHARE PRINCIPLE (US$)
PURCHASED (US$)

23345 11.82 275,938

2075 66.48 137,946

7000 27.72 194,040

13170 16.68 219,675.60

12099 14.25 172,411

$1,000,010
nies.
the other companies.
SHARE PRI
INVESTMENT PURCHASE INFORMATION
COMPANY STOCK EXCHANGE TICKER SHARES

China COSCO SHA 601919 23345

Dior FTSE CDI 2075

Disney Dow Jones DIS 7000

Tongrentang SHA 600085 13170

Hilton Hotels NYSE HLNQ 12099

TOTAL PRINCIPLE
SHARE PRICE TREND: 11 WEEK MOVEMENT
Week of 9/29 Week of 10/5
PRINCIPLE DATE PRICE PRINCIPLE DATE PRICE

275,938 9.29 11.82 275,938 10.9 13.26

137,946 10.2 66.48 137,946 10.5 66.75

194,040 10.2 27.72 194,040 10.9 28.64

219,675.60 9.29 16.68 219,675.60 10.9 17.46

172,411 9.29 14.25 172,411 10.5 15.39

$1,000,010 TOTAL PRINCIPLE $1,000,010 TOTAL PRINCIPLE


GAIN/LOSS 0 GAIN/LOSS
Week of 10/5 Week of 10/12 Week of 10/19
PRINCIPLE DATE PRICE PRINCIPLE DATE

309554.7 10.15 13.4 312823 10.23

138506.25 10.12 71.85 149088.75 10.19

200480 10.15 29.23 204610 10.23

229948.2 10.15 17.84 234952.8 10.23

186203.61 10.15 14.55 176040.45 10.23

1064692.76 TOTAL PRINCIPLE 1077515 TOTAL PRINCIPLE


$64,683 GAIN/LOSS $77,505

23345
2075
7000
13170
12099
Week of 10/19 Week of 10/26 Week of
PRICE PRINCIPLE DATE PRICE PRINCIPLE DATE

14.37 335467.65 10.30 13.15 306986.75 11.5

72.07 149545.25 10.26 68.86 142884.5 11.2

28.89 202230 10.30 27.37 191590 11.5

18.15 239035.5 10.30 19.14 252073.8 11.5

14 169386 10.30 14.1 170595.9 11.5

TOTAL PRINCIPLE 1095664.4 TOTAL PRINCIPLE 1064130.95 TOTAL PRINCIPLE


GAIN/LOSS $95,654 GAIN/LOSS $64,121
Week of 11/02 Week of 11/09 Week
PRICE PRINCIPLE DATE PRICE PRINCIPLE DATE

14.1 329164.5 11.9 14.15 330331.75 11.16

66.89 138796.75 11.9 70.69 146681.75 11.16

29 203000 11.9 29 203000 11.16

20.9 275253 11.9 20.84 274462.8 11.16

14.25 172410.75 11.9 14.87 179912.13 11.16

TOTAL PRINCIPLE 1118625 TOTAL PRINCIPLE 1134388.43 TOTAL PRINCIPLE


GAIN/LOSS $118,615 GAIN/LOSS $134,378

23345
2075
7000
13170
12099
Week of 11/16 Week of 11/23
PRICE PRINCIPLE DATE PRICE PRINCIPLE

15.67 365816.15 11.23 15.52 362314.4

72.76 150977 11.23 69.38 143963.5

30.7 214900 11.23 30.48 213360

21.04 277096.8 11.23 22.85 300934.5

14.75 178460.25 11.23 14.6 176645.4

TOTAL PRINCIPLE 1187250.2 TOTAL PRINCIPLE 1197217.8


GAIN/LOSS $187,240 GAIN/LOSS $197,208

23345
2075
$1,000,010 7000
13170
12099
Week of 11/30
DATE PRICE PRINCIPLE

12.04 15.34 358112.3

11.30 70.91 147138.25

11.30 30.6 214200

11.30 20.77 273540.9

11.30 15.13 183057.87

TOTAL PRINCIPLE 1176049.32


GAIN/LOSS $176,039
INVESTMENT PERFORMANCE CH
T PERFORMANCE CHARTS

You might also like