NEED 8pages in 4hrs

carren45

GuidetoReportTemplate.doc

Home >Business & Finance homework help >NEED 8pages in 4hrs

image1.emf

52 Week Price Range

Average Daily Volume

Beta

Dividend Yield (Estimated)

Shares Outstanding

Market Capitalization

Institutional Holdings

Insider Holdings

Book Value per Share (12/31/XX)

Debt to Total Capital

Return on Equity

Market Profile

image2.wmf

$10

$20

$30

$40

$50

$60

GIS Daily Stock Price

Ticker: ●

Recommendation: ●

Price: ●

Price Target: $●

Earnings/Share
	Mar.	Jun.	Sept.	Dec.	Year	P/E Ratio
2011A	$0.00	$0.00	$0.00	$0.00	$0.00	0.0x
2012A	0.00	0.00	0.00	0.00	0.00	0.0
2013E	0.00	0.00	0.00	0.00	0.00	0.0
2014E	0.00	0.00	0.00	0.00	0.00	0.0

Highlights (Heading: Times New Roman 14 Bold)

· Bullet Heading: Times New Roman 9 Bold: [Text Times New Roman 9 Normal] Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla

· Bullet Heading: Times New Roman 9 Bold: [Text Times New Roman 9 Normal] Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla

image3.emf

52 Week Price Range

Average Daily Volume

Beta

Dividend Yield (Estimated)

Shares Outstanding

Market Capitalization

Institutional Holdings

Insider Holdings

Book Value per Share (12/31/XX)

Debt to Total Capital

Return on Equity

Market Profile

Jan-00

Jan-01

Jan-02

AWE

April 27, 2000

AT&T issues 360m shares of

AT&T Wireless Group

tracking stock at

$29.50/share. Starts trading

under the ticker AWE

July 9, 2001

All AT&T Wireless Group shares

converted into AT&T Wireless

Services (AWE) on 1-on-1 basis.

AT&T shareholders issued 1.136bn

AWE shares as stock dividend. AWE

becomes independent, publicly

traded company

May, 2001

AT&T completes exchange offer,

allowing shareholders to exchange 1

AT&T share for 1.176 shares in AWE.

October 25, 2000

AT&T announces plans to

create a separate company

for its mobile operations,

named AT&T Wireless

Services (AWE)

December 24, 2001

AT&T sells remaining

stake in AWE for $3bn

Investment Summary (Heading: Times New Roman 14 Bold)

[Text Times New Roman 9 Normal] Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla

Paragraph Heading: Times New Roman 9 Bold

Figure 1: Graph/Table Heading: Times New Roman 9 Bold

image5.wmf

$10

$20

$30

$40

$50

$60

GIS Daily Stock Price

Graph / table explanation / summary: Times New Roman 8 normal (gray 80%)

Source: Times New Roman 7 Italics

[Text Times New Roman 9 Normal] Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis autem vel eum iriure dolor in hendrerit in vulputate velit esse molestie consequat, vel illum dolore eu feugiat nulla

Valuation (Heading: Times New Roman 14 Bold)

Risks to Your Price Target

Business Description (Heading: Times New Roman 14 Bold)

Lorem ipsum dolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat.

Paragraph Heading: Times New Roman 9 Bold

Other Headings Relative to Company

Paragraph Heading: Times New Roman 9 Bold

Industry Overview and Competitive Positioning

Paragraph Heading: Times New Roman 9 Bold

Financial Analysis

Earnings

Cash Flow

Balance Sheet & Financing

Investment Risks

Figure 1: Income Statement

$ in millions

Figure 2: Balance Sheet

$ in millions

Figure 3: Statement of Cash Flows

$ in millions

Figure 4: Other Statements or Exhibits

Company Name

[Team Name]

Date

� EMBED Excel.Sheet.8 ��

� EMBED Excel.Chart.8 \s ��

PAGE

Stern Research 2

_1439031887.xls

Sheet1

GIS Equity
Date	Px Last
12/31/01	52.01
1/2/02	50.95
1/3/02	50.97
1/4/02	50.11
1/7/02	49.35
1/8/02	49.34
1/9/02	48.57
1/10/02	48.48
1/11/02	48.48
1/14/02	48.93
1/15/02	49.5
1/16/02	49.17
1/17/02	49.38
1/18/02	49.95
1/22/02	49.92
1/23/02	49.45
1/24/02	48.68
1/25/02	48.46
1/28/02	48.27
1/29/02	48.05
1/30/02	49.37
1/31/02	49.55
2/1/02	48.83
2/4/02	48.67
2/5/02	48.71
2/6/02	43.55
2/7/02	44.9
2/8/02	46
2/11/02	46.21
2/12/02	46.63
2/13/02	45.97
2/14/02	46.85
2/15/02	46.87
2/19/02	46.6
2/20/02	47.5
2/21/02	46.28
2/22/02	47.27
2/25/02	47.53
2/26/02	47.76
2/27/02	47.36
2/28/02	46.23
3/1/02	45.94
3/4/02	44
3/5/02	45.01
3/6/02	45.44
3/7/02	45.39
3/8/02	46
3/11/02	46.27
3/12/02	46.8
3/13/02	46.86
3/14/02	47.37
3/15/02	48.27
3/18/02	48.03
3/19/02	48
3/20/02	47.23
3/21/02	48
3/22/02	48.29
3/25/02	48.53
3/26/02	49.14
3/27/02	48.88
3/28/02	48.85
4/1/02	48.25
4/2/02	48.28
4/3/02	48.17
4/4/02	49.19
4/5/02	49.18
4/8/02	49.21
4/9/02	49.65
4/10/02	49.84
4/11/02	49.8
4/12/02	50.18
4/15/02	49.16
4/16/02	50
4/17/02	49.01
4/18/02	49.3
4/19/02	49.8
4/22/02	49.9
4/23/02	50.03
4/24/02	49.07
4/25/02	45.3
4/26/02	42.93
4/29/02	43.02
4/30/02	44.05
5/1/02	44.55
5/2/02	45.58
5/3/02	45.17
5/6/02	44.63
5/7/02	44
5/8/02	44.29
5/9/02	44.41
5/10/02	44.44
5/13/02	44.42
5/14/02	44.6
5/15/02	44.12
5/16/02	44.68
5/17/02	44.5
5/20/02	44.1
5/21/02	44.36
5/22/02	45.24
5/23/02	45.06
5/24/02	45.1
5/28/02	44.65
5/29/02	45
5/30/02	44.93
5/31/02	45.5
6/3/02	44.99
6/4/02	44.65
6/5/02	45.18
6/6/02	44.51
6/7/02	44.32
6/10/02	44.09
6/11/02	43.72
6/12/02	43.61
6/13/02	43.47
6/14/02	42.91
6/17/02	43.6
6/18/02	43.8
6/19/02	43.89
6/20/02	43.5
6/21/02	43.28
6/24/02	42.95
6/25/02	42.85
6/26/02	44.36
6/27/02	45.2
6/28/02	44.08
7/1/02	44.05
7/2/02	43.91
7/3/02	43.41
7/5/02	44.25
7/8/02	44.33
7/9/02	43.54
7/10/02	43.35
7/11/02	43.2
7/12/02	42.16
7/15/02	43.36
7/16/02	42.26
7/17/02	42.8
7/18/02	40.23
7/19/02	38.99
7/22/02	38.4
7/23/02	38.53
7/24/02	39.9
7/25/02	39.7
7/26/02	39.85
7/29/02	40.27
7/30/02	40.47
7/31/02	41.45
8/1/02	41.15
8/2/02	41.16
8/5/02	41.04
8/6/02	40.65
8/7/02	41.7
8/8/02	42.74
8/9/02	42.86
8/12/02	42.61
8/13/02	42.37
8/14/02	43.4
8/15/02	42.85
8/16/02	42.39
8/19/02	42.11
8/20/02	41.43
8/21/02	41.41
8/22/02	41.52
8/23/02	41.72
8/26/02	42.26
8/27/02	42.7
8/28/02	42.73
8/29/02	41.6
8/30/02	42.09
9/3/02	41.11
9/4/02	41.38
9/5/02	41.34
9/6/02	41.58
9/9/02	42.13
9/10/02	41.96
9/11/02	42.04
9/12/02	41.56
9/13/02	42.25

Sheet1

Px Last

GIS Daily Stock Price

Sheet2

Market Profile

52 Week Price Range

Average Daily Volume

Beta

Dividend Yield (Estimated)

Shares Outstanding

Market Capitalization

Institutional Holdings

Insider Holdings

Book Value per Share (12/31/XX)

Debt to Total Capital

Return on Equity

Sheet3

_1261903302.xls

Chart1

37256
37258
37259
37260
37263
37264
37265
37266
37267
37270
37271
37272
37273
37274
37278
37279
37280
37281
37284
37285
37286
37287
37288
37291
37292
37293
37294
37295
37298
37299
37300
37301
37302
37306
37307
37308
37309
37312
37313
37314
37315
37316
37319
37320
37321
37322
37323
37326
37327
37328
37329
37330
37333
37334
37335
37336
37337
37340
37341
37342
37343
37347
37348
37349
37350
37351
37354
37355
37356
37357
37358
37361
37362
37363
37364
37365
37368
37369
37370
37371
37372
37375
37376
37377
37378
37379
37382
37383
37384
37385
37386
37389
37390
37391
37392
37393
37396
37397
37398
37399
37400
37404
37405
37406
37407
37410
37411
37412
37413
37414
37417
37418
37419
37420
37421
37424
37425
37426
37427
37428
37431
37432
37433
37434
37435
37438
37439
37440
37442
37445
37446
37447
37448
37449
37452
37453
37454
37455
37456
37459
37460
37461
37462
37463
37466
37467
37468
37469
37470
37473
37474
37475
37476
37477
37480
37481
37482
37483
37484
37487
37488
37489
37490
37491
37494
37495
37496
37497
37498
37502
37503
37504
37505
37508
37509
37510
37511
37512

Px Last

GIS Daily Stock Price

52.01

50.95

50.97

50.11

49.35

49.34

48.57

48.48

48.93

49.5

49.17

49.38

49.95

49.92

49.45

48.68

48.46

48.27

48.05

49.37

49.55

48.83

48.67

48.71

43.55

44.9

46.21

46.63

45.97

46.85

46.87

46.6

47.5

46.28

47.27

47.53

47.76

47.36

46.23

45.94

45.01

45.44

45.39

46.27

46.8

46.86

47.37

48.27

48.03

47.23

48.29

48.53

49.14

48.88

48.85

48.25

48.28

48.17

49.19

49.18

49.21

49.65

49.84

49.8

50.18

49.16

49.01

49.3

49.8

49.9

50.03

49.07

45.3

42.93

43.02

44.05

44.55

45.58

45.17

44.63

44.29

44.41

44.44

44.42

44.6

44.12

44.68

44.5

44.1

44.36

45.24

45.06

45.1

44.65

44.93

45.5

44.99

44.65

45.18

44.51

44.32

44.09

43.72

43.61

43.47

42.91

43.6

43.8

43.89

43.5

43.28

42.95

42.85

44.36

45.2

44.08

44.05

43.91

43.41

44.25

44.33

43.54

43.35

43.2

42.16

43.36

42.26

42.8

40.23

38.99

38.4

38.53

39.9

39.7

39.85

40.27

40.47

41.45

41.15

41.16

41.04

40.65

41.7

42.74

42.86

42.61

42.37

43.4

42.85

42.39

42.11

41.43

41.41

41.52

41.72

42.26

42.7

42.73

41.6

42.09

41.11

41.38

41.34

41.58

42.13

41.96

42.04

41.56

42.25

Price Graph

GIS Equity
Date	Px Last
12/31/01	52.01
1/2/02	50.95
1/3/02	50.97
1/4/02	50.11
1/7/02	49.35
1/8/02	49.34
1/9/02	48.57
1/10/02	48.48
1/11/02	48.48
1/14/02	48.93
1/15/02	49.5
1/16/02	49.17
1/17/02	49.38
1/18/02	49.95
1/22/02	49.92
1/23/02	49.45
1/24/02	48.68
1/25/02	48.46
1/28/02	48.27
1/29/02	48.05
1/30/02	49.37
1/31/02	49.55
2/1/02	48.83
2/4/02	48.67
2/5/02	48.71
2/6/02	43.55
2/7/02	44.9
2/8/02	46
2/11/02	46.21
2/12/02	46.63
2/13/02	45.97
2/14/02	46.85
2/15/02	46.87
2/19/02	46.6
2/20/02	47.5
2/21/02	46.28
2/22/02	47.27
2/25/02	47.53
2/26/02	47.76
2/27/02	47.36
2/28/02	46.23
3/1/02	45.94
3/4/02	44
3/5/02	45.01
3/6/02	45.44
3/7/02	45.39
3/8/02	46
3/11/02	46.27
3/12/02	46.8
3/13/02	46.86
3/14/02	47.37
3/15/02	48.27
3/18/02	48.03
3/19/02	48
3/20/02	47.23
3/21/02	48
3/22/02	48.29
3/25/02	48.53
3/26/02	49.14
3/27/02	48.88
3/28/02	48.85
4/1/02	48.25
4/2/02	48.28
4/3/02	48.17
4/4/02	49.19
4/5/02	49.18
4/8/02	49.21
4/9/02	49.65
4/10/02	49.84
4/11/02	49.8
4/12/02	50.18
4/15/02	49.16
4/16/02	50
4/17/02	49.01
4/18/02	49.3
4/19/02	49.8
4/22/02	49.9
4/23/02	50.03
4/24/02	49.07
4/25/02	45.3
4/26/02	42.93
4/29/02	43.02
4/30/02	44.05
5/1/02	44.55
5/2/02	45.58
5/3/02	45.17
5/6/02	44.63
5/7/02	44
5/8/02	44.29
5/9/02	44.41
5/10/02	44.44
5/13/02	44.42
5/14/02	44.6
5/15/02	44.12
5/16/02	44.68
5/17/02	44.5
5/20/02	44.1
5/21/02	44.36
5/22/02	45.24
5/23/02	45.06
5/24/02	45.1
5/28/02	44.65
5/29/02	45
5/30/02	44.93
5/31/02	45.5
6/3/02	44.99
6/4/02	44.65
6/5/02	45.18
6/6/02	44.51
6/7/02	44.32
6/10/02	44.09
6/11/02	43.72
6/12/02	43.61
6/13/02	43.47
6/14/02	42.91
6/17/02	43.6
6/18/02	43.8
6/19/02	43.89
6/20/02	43.5
6/21/02	43.28
6/24/02	42.95
6/25/02	42.85
6/26/02	44.36
6/27/02	45.2
6/28/02	44.08
7/1/02	44.05
7/2/02	43.91
7/3/02	43.41
7/5/02	44.25
7/8/02	44.33
7/9/02	43.54
7/10/02	43.35
7/11/02	43.2
7/12/02	42.16
7/15/02	43.36
7/16/02	42.26
7/17/02	42.8
7/18/02	40.23
7/19/02	38.99
7/22/02	38.4
7/23/02	38.53
7/24/02	39.9
7/25/02	39.7
7/26/02	39.85
7/29/02	40.27
7/30/02	40.47
7/31/02	41.45
8/1/02	41.15
8/2/02	41.16
8/5/02	41.04
8/6/02	40.65
8/7/02	41.7
8/8/02	42.74
8/9/02	42.86
8/12/02	42.61
8/13/02	42.37
8/14/02	43.4
8/15/02	42.85
8/16/02	42.39
8/19/02	42.11
8/20/02	41.43
8/21/02	41.41
8/22/02	41.52
8/23/02	41.72
8/26/02	42.26
8/27/02	42.7
8/28/02	42.73
8/29/02	41.6
8/30/02	42.09
9/3/02	41.11
9/4/02	41.38
9/5/02	41.34
9/6/02	41.58
9/9/02	42.13
9/10/02	41.96
9/11/02	42.04
9/12/02	41.56
9/13/02	42.25

Price Graph

Px Last

GIS Daily Stock Price

Market Profile

Market Profile
52 Week Price Range	$20-$50
Average Daily Volume	1.3m
Beta	1.1
Dividend Yield (Estimated)	2.60%
Shares Outstanding	100m
Market Capitalization	$12,938m
Institutional Holdings	40%
Insider Holdings	2%
Book Value per Share (12/31/96)	$10.40
Debt to Total Capital	50%
Return on Equity	15%

NEED 8pages in 4hrs

Earnings/Share

Highlights (Heading: Times New Roman 14 Bold)

Investment Summary (Heading: Times New Roman 14 Bold)

Valuation (Heading: Times New Roman 14 Bold)

Business Description (Heading: Times New Roman 14 Bold)

Other Headings Relative to Company

Industry Overview and Competitive Positioning

Financial Analysis

Investment Risks

Figure 1: Income Statement

Figure 2: Balance Sheet

Figure 3: Statement of Cash Flows

Figure 4: Other Statements or Exhibits

_1439031887.xls

Sheet1

Sheet1

Sheet2

Sheet3

_1261903302.xls

Chart1

Price Graph

Price Graph

Market Profile

Sheet3