Stock Performance Spreadsheet

  • July 2020
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Stock Performance Spreadsheet as PDF for free.

More details

  • Words: 475
  • Pages: 14
STOCK MARKET PERFORMANCE SPREADSH

INVESTMENT PURCHASE INFORMA COMPANY

INDUSTRY

STOCK EXCHANGE

TICKER

BETA

China Petroleum & Chemical

chemical

NYSE

SNP

1.63

Toyota

motor

NYSE

TM

0.72

HP

IT

NYSE

HP

1.16

haier

household appliances

SHA

Microsoft corporation

IT

NASDAQ

600690

MSFT

0.97

NOTE: 1) Total Investment Principle CANNOT EXCEED US$1.0 M for the 5 companies. Each company can have a larger or smaller investment principle than the other companies.

ANCE SPREADSHEET/TEAM NAME:

URCHASE INFORMATION EPS

9.08

PER

9.76

-6.02

4.02

10.21

0.73

1.54

18.55

TOTAL NUMBER OF SHARES PURCHASED

PURCHASE INVESTMENT PRICE PER PRINCIPLE (US$) SHARE (US$)

4265

82.05

350,000

3325

75.19

250,000

5343

37.43

200,000

6414

15.59

100,000

4006

24.96 100,00

TOTAL INVESTMENT PRINCIPLE

$1,000,000

panies. r companies.

2)

S INVESTMENT PURCHASE INFORMATION COMPANY

STOCK EXCHANGE

TICKER

SHARES

China Petroleum & Chemical

NYSE

SNP

4265

Toyota

NYSE

TM

3325

HP

NYSE

HP

5343

Haier

SHA

Microsoft corporation

NASDAQ

600690 MSFT

6414 4006

TOTAL PRINCIPLE

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

DATE

PRICE

Week of 9/ PRINCIPLE

DATE

350,000

9/21/2009

¥87.87

374,765

9/28/2009

250,000

9/21/2009

¥82.69

274,944

9/28/2009

200,000

9/21/2009

¥38.93

208,002

9/28/2009

100,000

9/21/2009

¥16.90

108,396

9/28/2009

100,000

9/21/2009

¥25.30

101,351

9/28/2009

104045

TOTAL PRINCIPLE

$1,000,000

TOTAL PRINCIPLE GAIN/LOSS

0.41%

Week of 9/28 PRICE

Week of 10/05 PRINCIPLE

DATE

PRICE

PRINCIPLE

87.44

372,931

10/5/2009

83.66

356,810

80.63

268,094

10/5/2009

75.07

249,608

38.76

207,094

10/5/2009

38.98

208,270

16.08

107,755

10/5/2009

16.88

108,268

25.83

103,475

10/5/2009

24.64

98,708

TOTAL PRINCIPLE GAIN/LOSS

1 1,059,349 5.93%

TOTAL PRINCIPLE GAIN/LOSS

1O21,664 21,664

Week of 10/12 DATE

PRICE

Week of 10/19 PRINCIPLE

DATE

PRICE

10/12/2009

88.41

377,069

###

¥91.55

10/12/2009

78.93

262,442

###

¥80.40

10/12/2009

42.26

225,795

###

¥44.07

10/12/2009

17.85

114,490

###

¥17.80

10/12/2009

25.72

103,034

###

¥26.36

TOTAL PRINCIPLE GAIN/LOSS

1,082,830 82,830

TOTAL PRINCIPLE GAIN/LOSS

Week of 10/19

Week of 10/26

PRINCIPLE

DATE

PRICE

Week of

PRINCIPLE

DATE

390,461

###

¥86.68

369,690 11/2/2009

267,330

###

¥78.20

260,015 11/2/2009

235,466

###

¥41.59

222,215 11/2/2009

114,169

###

¥18.80

120,583 11/2/2009

105,598

###

¥28.02

112,248 11、6

1,113,024 113,024

TOTAL PRINCIPLE GAIN/LOSS

1,084,751 84,751

TOTAL PRINCIPLE

Week of 11/02 PRICE

Week of 11/09

PRINCIPLE

DATE

PRICE

PRINCIPLE

¥85.60

356,084 11、11

¥89.25

308,651.25

¥78.99

262,641.75 11、11

¥78.49

260,979.25

¥38.06

203,354.58 11、11

¥39.11

208,964.73

¥20.90

134,052.60 11、11

¥22.26

142,775.64

¥28.60

114,571.60 11、11

¥28.90

115,773.40

TOTAL PRINCIPLE GAIN/LOSS

1,070,704.53 7.07%

TOTAL PRINCIPLE GAIN/LOSS

1,037,144.27 3.71%

Week of 11/16 DATE

PRICE

Week of 11/23

PRINCIPLE

DATE

PRICE

11.18

¥89.50

381,718

11.25

¥86.92

11.19

¥79.26

263,539.50

11.25

¥77.69

11.16

¥38.20

204,102.60

11.25

¥38.54

11.19

¥22.05

141,428.70

11.26

¥23.05

11.19

¥30.11

120620.66

11.25

¥30.00

TOTAL PRINCIPLE GAIN/LOSS

1,111,409.46 11.14%

TOTAL PRINCIPLE GAIN/LOSS

Week of 11/23

Week of 11/30

PRINCIPLE

DATE

PRICE

PRINCIPLE

370,713.80

12.2

¥87.72

374,125.80

258,319.25

12.2

¥82.63

274,744.75

205,919.22

12.1

¥39.17

209,285.31

147,842.70

12.2

¥25.34

162,530.76

120,180

12.1

¥30.02

120,260.12

1,102,974.97 10.30%

TOTAL PRINCIPLE GAIN/LOSS

1,140,946.74 14.09%

INVESTMENT PERFORMAN

T PERFORMANCE CHARTS

Related Documents