Scribd
Upload
412 views17 pages

Stock Performance Spreadsheet

The document provides information on a stock market investment portfolio including: - Details of 5 companies purchased in the NYSE and Chinese markets with a total investment of $1,000,000. - A spreadsheet tracking the share price and value of each holding over 11 weeks showing the portfolio increased in value by over 9%. - Transactions made in weeks 11 and 13 where one stock was sold and replaced and another small holding was sold. - An updated portfolio tracking the performance over the following 3 weeks showing the value remained over $1,000,000.

Uploaded by

후봉봉
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
412 views17 pages

Stock Performance Spreadsheet

The document provides information on a stock market investment portfolio including: - Details of 5 companies purchased in the NYSE and Chinese markets with a total investment of $1,000,000. - A spreadsheet tracking the share price and value of each holding over 11 weeks showing the portfolio increased in value by over 9%. - Transactions made in weeks 11 and 13 where one stock was sold and replaced and another small holding was sold. - An updated portfolio tracking the performance over the following 3 weeks showing the value remained over $1,000,000.

Uploaded by

후봉봉
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/ 17

STOCK MARKET PERFORMANCE SPREADSHEET

INVESTMENT PURCHASE INFORMATION

STOCK
COMPANY INDUSTRY TICKER BETA EPS
EXCHANGE

China mobile Communication NYSE CHL 0.94 4.08

NYSE
BP Energy BP 0.75 3.68

NYSE
Coca cola companDrink KO 0.58 2.7

NYSE
WALMART Merchandise WMT 0.21 3.39

Shandong Airlines Air transport SHE 200152 0.38


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$)

＄15007.12
12.16 49.54

14.25 53.61 $200,018.91

20.13 53.31 $349,980.15

14.61 49.23 $249,989.94

14.92 59527 5.71 $50,002.68

TOTAL
INVESTMENT $1,000,000
PRINCIPLE
nies.
the other companies.
SHARE P
INVESTMENT PURCHASE INFORMATION
COMPANY STOCK EXCHANGE TICKER SHARES

China mobile NYSE CHL 3028

BP NYSE BP 3731

Coca cola company


NYSE KO 6565

WALMART NYSE WMT 5078

Shandong Airlines SHE 200152 59527

TOTAL PRINCIPLE
SHARE PRICE TREND: 11 WEEK MOVEMENT
Week of 9/21 Week of 9/28
PRINCIPLE DATE PRICE PRINCIPLE DATE

$150,007.12 30-Sep

＄200018.91
30-Sep

$349,980.15 30-Sep

$249,989.94 30-Sep

$50,002.68 30-Sep

$999,999 TOTAL PRINCIPLE $ TOTAL PRINCIPLE


GAIN/LOSS $
T
Week of 9/28 Week of 10/05
PRICE PRINCIPLE DATE PRICE PRINCIPLE

$49.54 $150,007.12 5-Oct $50.13 $151,793.64

$53.61 $200,018.91 10-Oct $52.27 $195,019.37

$53.31 $349,989.94 5-Oct $54.81 $359,827.65

$49.23 $249,989.94 5-Oct $49.97 $253,747.66

￥5.71(＄0.
￥5.97(＄0.8
8366) $50,002.68 5-Oct $52,068.27
747）

TOTAL PRINCIPLE $999,998.80 TOTAL PRINCIPLE $1,012,456.59


GAIN/LOSS $0 GAIN/LOSS 1.25%
Week of 10/12 Week of 10/19
DATE PRICE PRINCIPLE DATE PRICE

15-Oct $51.26 $155,215.28 20-Oct $51.37

15-Oct $53.66 $200,205.46 20-Oct $56.40

15-Oct $54.84 $360,024.60 19-Oct $55.01

14-Oct $50.34 $255,626.52 20-Oct $51.89

15-Oct ￥6.10(＄0.89 $53,193.33 23-Oct ￥6.23(＄0.


36) 9126)

TOTAL PRINCIPLE $1,024,265.19 TOTAL PRINCIPLE


GAIN/LOSS 2.43% GAIN/LOSS
Week of 10/19 Week of 10/26 Week of 11/02
PRINCIPLE DATE PRICE PRINCIPLE DATE

$155,548.36 26-Oct $49.29 $149,250.12 8-Nov

$210,428.40 28-Oct $57.82 $215,726.42 8-Nov

$361,140.65 26-Oct $54.07 $354,969.55 8-Nov

$263,497.42 26-Oct $50.49 $256,388.22 8-Nov

$54,324.34 28-Oct ￥6.31(＄0.9 $55,020.81 3-Nov


243)
3-Nov
$1,044,939.17 TOTAL PRINCIPLE $1,031,355.12 TOTAL PRINCIPLE
4.49% GAIN/LOSS 3.14%
Week of 11/02 Week of 11/09
PRICE PRINCIPLE DATE PRICE PRINCIPLE

$47.63 $144,223.64 11-Nov $49.12 $148,735.36

$58.43 $218,002.33 10-Nov $59.93 $223,598.83

$54.49 $357,726.85 11-Nov $56.16 $368,690.40

$51.25 $260,247.50 13-Nov $53.24 $270,352.72

￥6.05(＄0.8
$52,752.82 13-Nov ￥6.81(＄0.9 $59,384.14
862) 976)

TOTAL PRINCIPLE $1,032,953.15 TOTAL PRINCIPLE $1,070,761.45


GAIN/LOSS 3.30% GAIN/LOSS 7.08%
Company Date Share Price Total Shares

(sell) China Mobile 11-Nov $49.12 3028

(buy)stryker corporatio 11-Nov $49.46 3007

(sell) Shandong Air 13-Nov ￥6.81(＄0.9976) 59527

(buy)Microsoft Corpora 13-Nov $29.36 2023


INVESTMENT PURCHASE INFORMATION
Principle COMPANY STOCK EXCHANGE TICKER

$148,735.36 stryker corporation NYSE SYK

$148,735.36 BP NYSE BP

Coca cola company


$59,384.14 NYSE KO

$59,384.14 WALMART NYSE WMT

Microsoft Corporation NASDAQ MSFT

TOTAL PRINCIPLE
ASE INFORMATION Week of 11/16
SHARES PRINCIPLE DATE PRICE

3007 $148,735.36 18-Nov $49.46

3731 $223,598.83 18-Nov $59.55

6565 $368,690.40 18-Nov $56.87

5078 $270,352.72 19-Nov $54.15

2023 $59,384.14 19-Nov $30.11

$1,070,761.45 TOTAL PRINCIPLE


GAIN/LOSS
Week of 11/16 Week of 11/23 Week of 11/30
PRINCIPLE DATE PRICE PRINCIPLE DATE

$148,726.22 25-Nov $50.38 $151,492.66 2-Dec

$222,181.05 25-Nov $59.22 $220,949.82 2-Dec

$373,351.55 23-Nov $58.24 $382,345.60 2-Dec

$274,973.70 24-Nov $54.96 $279,086.88 2-Dec

$60,912.53 24-Nov $29.98 $60,649.54 2-Dec

$1,080,145.05 TOTAL PRINCIPLE $1,094,524.50 TOTAL PRINCIPLE


8.01% GAIN/LOSS 9.45%
Week of 11/30
PRICE PRINCIPLE

$51.24 $154,078.68

$58.96 $219,979.76

$57.96 $380,507.40

$54.47 $276,598.66

$29.78 $60,244.94

TOTAL PRINCIPLE $1,091,409.44


GAIN/LOSS 9.14%
INVESTMENT PERFORMANCE CH
T PERFORMANCE CHARTS

You might also like