The following Excel File contains fundamental information on the 9338

profileAdvanced Tutor
 (Not rated)
 (Not rated)
Chat
The following Excel File contains fundamental information on the 240 largest market cap (non-financial service) companies listed anywhere in the world. You have two tasks:

1. Please identify the 5 most undervalued firms in this sample, using a Relative Valuation Method. In making this analysis:

You can pick any multiple you want to make this judgment. This multiple can either be an existing multiple (like PE or EV/EBITDA), a modified version of an existing multiple (like PEGY) or a multiple that you invent. (Just make sure that you put it through the consistency test)

2. Search Online and other resources and identify why are these companies undervalued?

3. Recommend and discuss several corrective actions that management of these companies can take in order to improve the valuation of their firms.

4. Assume that you are an activist investor (Blackstone and KKR's competitor) and are interested in acquiring one of the firms in the sample, which you plan to take private, restructure (operating and financing, if necessary) and take public again. Which company would you pick and why? (Note that it does not have to come from your list of 5 most undervalued companies).
Passive Portfolio Investment Project (1).xls

Passive Portfolio Investment Project (1).xls

Company Name/ Symbol

Company Name

Exchange:T icker
LSE:RDSA
NYSE:WMT

Company Details

Year Founded
-

Primary Indust ry
Integrated Oil and Gas

Market Data

Netherlands

Primary Sect or
Energy

87,000.0

$208,619.70

Ownership Details

$32.69

$4 3.33

$30.10

72.19

-

31.4 3

0.01

Beta Estimates

0.00

2 Year Bet a [Lat est ] 5 Year Bet a [Lat est ]
0.75
0.55

Total SA (ENXTPA:FP)

Hypermarkets and Super Centers

United States

Consumer Staples

2,200,000.0

$256,119.10

$77.79

$78.4 6

$57.20

4 8.90

2.15

0.04

0.38

1870

Integrated Oil and Gas

United States

Energy

76,900.0

$399,74 5.70

$89.22

$93.67

$77.10

50.78

-

0.22

0.04

0.99

0.51

4 4 80.50

SEHK:386

Volkswagen AG (DB:VOW)

194 5

NYSE:XOM

BP plc (LSE:BP.)

0.36

Shares outstanding & Trading data

6309.70

2000

Integrated Oil and Gas

China

Energy

376,201.0

$103,606.50

$1.15

$1.23

$0.82

15.11

73.92

-

-

0.50

0.76

89665.50

LSE:BP.
SEHK:857

1889
1988

Integrated Oil and Gas
Integrated Oil and Gas

United Kingdom
China

Energy
Energy

85,700.0
54 8,355.0

$132,993.30
$252,561.90

$6.96
$1.29

$7.4 3
$1.53

$5.54
$1.16

4 3.4 6
6.96

86.52

0.09
0.00

0.01
-

0.83
0.75

0.73
0.96

19121.70
183021.00

3292.4 0

22.00

2.97

$67.60

Estimates for future earnings/growth

Float % [Lat est ]
100.00

$4 64 ,653.60

$61,951.60

$4 .23

Historic (Past) Growth

5.10

10.60

9.4 6
7.66

8.25
8.10

11.10
7.32

-3.23
5.95

-0.10

4 .4 7

28.60
5.76

Income Statement numbers (last twelve months)

32.80

10.20

9.11

$554 .50

4 8.00

$4 90,935.80

$37,784 .00

$5.35

9.56

7.89

2.36

14 .20

$1,336.50

99.70

$4 78,650.30

$84 ,304 .00

$7.98

0.36

14 .60

13.30

11.50

9.03

0.12

3.4 4

-

78.00

$72.90

26.10

$4 51,153.10

$34 ,34 2.80

$0.14

4 .64

14 .60

12.20

11.4 0

23.00

2.4 7

2.56

5.53

18.30

0.39

-0.07

25.4 0
65.60

$114 .10
$4 6.60

99.90
13.50

$338,4 4 2.4 0
$354 ,4 62.20

$38,199.00
$59,358.4 0

$0.83
$0.12

6.52
8.09

5.4 8
9.4 1

3.26
8.95

4 .24
11.90

7.71
24 .50

-11.10
-4 .71

-13.50
-2.68

-5.78
4 .77

5.72
21.30

-11.30
3.71

-15.30
6.4 5

-1.08

4 .97

5.60

324 .10
-

2.02

4 .64

0.4 8

32.50

21.50

18.90
4 .76

-14 .00
8.28

-14 .20

4 .97

$4 67,153.00
$4 69,162.00

$52,114 .00

4 .64

4 .93
24 .4 0

15.80

-0.50

-2.12

$4 28,376.00

3.32

27.50

-12.80

-7.85

-1.57

11.20

$4 4 6,879.80

$26,858.30

-5.97
12.80

16.10
29.10

-54 .90
-13.30

-56.80
-7.59

-34 .4 0
1.68

0.02
9.55

$375,580.00
$352,188.4 0

$28,34 7.00
$54 ,291.60

-1.15

4 .65

-0.64

29.90

9.30

4 .68

-6.85

$37,656.00

$26,592.00

4 6.6

$32,576.00

$17,720.00

-

$14 ,4 58.00

Balance Sheet- Most recent quarter

$37,656.00

-$1,757.00
-$2,251.00

$1,013.00

$36,302.00

$27,801.00

$16,999.00

31.0

$12,898.00

$88,873.00

-

-

$27,801.00

$73,4 31.00

$57,54 3.00

$4 4 ,880.00

39.4

$34 ,271.00

$14 ,968.00

-

$15,888.00

$57,54 3.00

-$327.00

$15,393.80

$10,24 8.00

26.3

$25,197.90

$20,610.90

-

$11,4 64 .60

$15,393.80

-$1,799.50

$13,364 .00
$28,156.00

$11,582.00
$18,501.60

37.2
21.7

$23,078.00
$50,012.70

$14 ,631.00
$32,864 .30

-

$12,4 81.00
$24 ,223.80

$13,364 .00
$28,156.00

-$84 2.00
-$2,914 .00

$1,003.00
$331.00

-$39.00

$50,289.00

$23,4 4 9.00

-

$18,550.00

$172,293.00

$2,615.00

$360,325.00

$7,781.00

$116,681.00

$20,4 97.00

$203,105.00

$9,582.00

$226,94 9.00

$37,754 .00

$188,4 94 .00

-

$76,34 3.00

-

$165,863.00

$4 0,210.00

$30,781.00

$6,768.00

$4 3,803.00

$28,373.00

$14 ,54 2.00

$9,191.00

Balance Sheet - Four quarters prior

$325,753.00

$153,4 60.00

$4 2,4 4 8.00

$55,04 3.00

$38,080.00

$1,798.00
$6,805.00

$21,770.00

$26,054 .00

-

$1,4 33.00

$37,175.00

$1,4 86.00

$11,292.00

$2,620.00
$20,651.00

R&D Expenses (Current & last 5 years)

-

-

$25,737.00

$7,981.00

$557.00

$171,724 .00

$38,4 85.00

$5,914 .00

$53,537.00

$4 ,850.00

$6,550.00

-

-

$78,726.00

$31,04 5.00

-

$333,795.00

$11,581.00

$5,34 9.00

$4 09,314 .00

$182,365.00

$33,789.00

$2,628.00

$12,809.00

$7,4 97.00

$5,797.00

$17,033.00

$6,34 8.00

$12,664 .00

$238.90

-

$14 ,54 1.60

$3,825.60

-

$1,677.4 0

$121,596.30

$1,003.80

$203,213.90

$4 4 ,614 .90

-

$81,965.30

$16,273.90

$35,015.50

$4 ,906.60

$224 ,610.20

$103,014 .00

$35,660.70

$16,079.4 0

$14 ,800.00

$26,008.10

$5,955.4 0

$37,250.4 0

$5,554 .50

$3,909.70

$1,302.60

-

$74 ,923.90

-

$18,809.00
$26,761.30

$6,993.00
$5,806.10

$2.00
-

$19,54 8.00
$6,961.80

$120,4 4 8.00
$251,855.00

$11,861.00
$1,216.4 0

$300,193.00
$34 7,953.10

$4 8,797.00
$71,394 .10

$21.00
-

$118,393.00
$170,697.70

$27,4 21.00
$10,339.60

$27,867.00
$34 ,350.50

$23,822.00
$10,292.90

$24 1,055.00
$4 11,4 99.70

$120,607.00
$159,64 4 .70

$29,703.00
$21,165.00

$632.00
$23,006.90

$27,307.00
$10,705.10

$38,4 12.00
$4 7,129.80

$1,206.00
$18,728.10

$4 4 ,213.00
$50,502.50

$1,017.00
$12,658.60

$14 ,067.00
$9,703.50

$12,100.00
$1,155.10

$21.00
-

$111,4 4 4 .00
$159,062.4 0

-

-

$169,517.00

$187.00

-

$54 ,227.00

-

-

$11,292.00

$1,314 .00

$1,299.00

$1,24 1.00

$1,201.00

Per Share numbers

$1,125.00

$1,14 3.00

$4 .25

$4 .25

$4 .57

$4 .24

Operating Lease expenses: Current year & Future commitments

$4 .24

$1.72

$12,200.00

$2,950.00

$2,950.00

$3,950.00

$9,373.00

$1,24 6.00

$1,384 .00

$1,4 80.00

$3,950.00

Statement of Cash Flow numbers: Last twelve months

$4 ,900.00

$3,4 4 8.00
$2,600.00

-$5,500.00

-$7,390.00

-$1,526.00

-

-$1,4 78.00

$5,108.00
$2,965.00

-$2,223.00

Last fiscal year numbers

-

-

-$9,008.00

-$1,74 6.00

$71.00

-

$1,015.00

$7,655.00

$14 ,14 5.00

-$316.00

$1,061.00

-$2,759.00

-$614 .00

$4 67,153.00
$4 69,162.00

$52,114 .00

Corporate governance measures

$26,592.00

29.4 1

0.26

4 .76

0.20

$71,315.00

$6,550.00

-

-

-

-

-

-

$5.04

$5.04

$4 .54

$5.02

$5.02

$1.59

$1,598.00

$1,722.00

-

-$5,361.00

-$7,600.00

$36,302.00

$16,999.00

$12,664 .00

-

$1,04 4 .00

$1,04 4 .00

$1,04 4 .00

$1,04 4 .00

$1,012.00

$9.70

$9.70

$9.15

$9.70

$9.70

$2.18

$1,4 67.00

$350.00

$688.00

$1,381.00

$2,04 1.00

$2,254 .00

-

-$10,092.00

-$21,068.00

$193.00

-$4 ,861.00

$1,953.00

-

$3,624 .00

-$1,873.00

-$1,082.00

$4 28,376.00

$73,4 31.00

$4 4 ,880.00

7.69

0.21

$3,909.70

-

$773.30

$764 .90

$771.60

$771.20

$757.50

$0.12

$0.12

$0.10

$0.11

$0.11

$0.05

$52,337.30

$2,34 1.90

$2,365.50

$2,381.4 0

$2,4 03.70

$2,54 1.80

$2,337.30

$524 .4 0

-

-$4 ,088.70

-

-

-$14 2,551.60

$14 9,24 9.50

-$875.30

-

-

$6,196.70

-$2,381.60

-$3,637.60

$4 4 6,879.80

$26,858.30

$10,24 8.00

33.33

0.26

$14 ,067.00
$9,703.50

-

$636.00
$2,103.30

$636.00
$1,664 .30

$636.00
$2,098.70

$636.00
$2,097.70

$780.00
$1,854 .90

$0.61
$0.10

$0.61
$0.10

$0.59
$0.08

$0.61
$0.10

$0.61
$0.10

$0.34
$0.05

$4 ,195.00
-

$1,566.00
-

$2,007.00
-

$2,666.00
-

$3,4 94 .00
-

$4 ,531.00
-

$4 ,94 8.00
$1,930.30

$15,603.00
$7,34 8.4 0

-$2.00
-

-$5,292.00
-$9,311.4 0

-

$122.00
-

-$7,851.00
-$72,021.4 0

$11,087.00
$92,336.00

-$1,214 .00
-$3,327.00

$1,4 55.00
-

-$116.00
-$38.00

-$3,036.60

-$1,797.00
-$5,227.70

-$2,151.70

$375,580.00
$352,188.4 0

$28,34 7.00
$54 ,291.60

$11,582.00
$18,501.60

21.4 3
4 0.0

0.23
0.16
0.20
0.13

$3,887.00

-

-$5,125.00

$154 ,396.00

$3,807.00

$560.00

-

DB:VOW
TSE:7203

1937
1933

Automobile Manufacturers
Automobile Manufacturers

Germany
Japan

Consumer Discretionary
Consumer Discretionary

54 9,763.0
-

$90,228.70
$179,380.4 0

$190.13
$56.64

$230.34
$56.94

$14 2.80
$28.10

16.03
30.97

32.4 1
6.90

0.16

0.15

1.21
0.61

-0.26
0.64

4 65.20
3167.20

12.50

0.00
8.4 8

$0.15
$1,568.00

38.50
92.90

$266,322.00
$24 0,189.10

$31,076.30
$25,878.30

$28.80
$4 .36

4 8.80
4 4 .90

23.70
-0.66

11.50
-2.23

8.15
-0.22

7.91
3.50

39.4 0
-16.00

14 .00
-15.4 0

11.80
-11.60

12.10
-3.39

182.80
-

187.4 0
-

53.70
38.50

22.4 0
8.4 2

4 0.90
309.30

6.58
54 7.70

16.20
70.50

20.90
25.10

$254 ,039.20
$253,536.4 0

$25,865.90
$24 ,64 8.00

$15,861.30
$12,220.60

$28,633.4 0
$8,893.20

14 .2
36.7

$13,834 .80
$21,4 61.30

$31,4 4 7.00
$24 ,039.90

-

-

$15,861.30
$12,220.60

-$2,362.70
-$313.00

$1,112.80
$1,209.00

-

$33,612.00
$16,255.50

$4 ,757.10
$5,967.4 0

-

$20,386.30
$14 ,353.4 0

$70,975.00
$74 ,006.80

$31,556.50
-

$4 08,258.90
$371,779.20

$123,602.10
$150,835.60

-

$102,201.90
$130,201.60

$13,315.30
$18,129.00

$37,806.10
$18,773.70

$1,097.00
$7,916.80

$171,721.30
$201,4 70.50

$100,74 6.30
$127,4 63.70

$20,650.00
$19,787.80

$4 6,750.60

$25,699.80
$18,856.90

$19,868.20
$75,554 .10

$5,682.60
$6,4 07.00

$91,254 .30
$152,035.00

$7,554 .4 0
$7,533.80

$18,790.50
$19,932.10

$5,630.4 0
-

-

$74 ,750.20
$130,281.60

$18,790.50
$19,932.10

-

$9,290.4 0
$10,011.60

$9,965.10
$9,756.10

$9,915.4 0
$9,4 62.50

$9,397.90
$9,4 92.30

$2,288.70
-

$61.20
$2.81

$61.20
$2.81

$23.10
$2.89

$61.20
$2.81

$61.20
$2.81

$4 .61
$0.93

$2,851.90
$250.60

$657.90
$61.80

$657.90
$69.70

$657.90
$79.00

$657.90
$96.90

$1,061.4 0
$125.90

$1,534 .70
-

$1,187.90
$5,700.50

-

-$1,853.80
-$2,196.80

-$570.20

$2,697.60
-

-$22,524 .90
-$35,161.10

$4 2,833.4 0
$36,768.30

-$7,663.00
-$15,679.20

-

-$4 ,680.60
-$1.70

-$311.20
$8,74 4 .60

$606.50
-$3,987.80

-$73.80
-$6,768.80

$254 ,039.20
$225,502.4 0

$25,865.90
$17,272.90

$28,633.4 0
$3,4 4 0.80

4 0.63

ENXTPA:FP
NYSE:CVX

1924
1879

Integrated Oil and Gas
Integrated Oil and Gas

France
United States

Energy
Energy

97,126.0
62,000.0

$111,092.50
$234 ,969.30

$4 9.21
$120.95

$55.10
$121.56

$4 3.80
$95.70

38.83
65.4 7

8.65
-

0.01
0.02

0.01
0.01

0.87
1.13

0.4 9
0.79

2257.50
194 2.70

32.50
71.90

5.18
6.11

$182.00
$736.90

79.10
100.00

$24 4 ,295.20
$261,716.90

$4 3,585.90
$56,183.60

$7.03
$12.70

1.16
2.27

6.05
36.90

9.13
17.60

7.69
14 .90

5.92
9.32

-4 .10
6.97

-1.17
6.4 4

1.73
7.12

5.91
1.76

8.18
35.70

15.20
34 .70

15.00
22.4 0

17.60
11.80

-12.90
-2.66

-3.54
-8.58

4 .35
-5.4 4

9.4 6
-5.80

$24 0,357.30
$222,580.00

$4 4 ,678.00
$4 8,4 26.00

$31,321.80
$35,013.00

$14 ,099.80
$26,179.00

54 .7
4 3.2

$26,24 4 .30
$30,938.00

$1,906.50
$6,4 52.00

-

$10,615.10
$13,4 13.00

$31,321.80
$35,013.00

-$884 .70
-

$4 25.90
$166.00

-$14 .50
-

$31,520.90
$4 6,332.00

$17,227.20
$19,996.00

-

$20,395.50
$20,939.00

$91,4 12.70
$14 1,34 8.00

$1,172.10
$4 ,64 0.00

$226,552.80
$232,982.00

$4 4 ,002.90
$12,192.00

-

$96,132.90
$136,524 .00

$25,322.70
$20,94 0.00

$22,937.60
$6,14 4 .00

$5,635.20
$1,4 22.00

$206,587.10
$263,4 81.00

$115,174 .4 0
$122,133.00

$28,54 2.4 0
$22,776.00

$8,4 27.70
$69.00

$9,858.30
-

$28,928.70
$11,966.00

$1,689.00
$1,308.00

$4 1,925.30
$10,152.00

$1,756.4 0
$799.00

$18,220.20
$15,864 .00

$1,182.20
$4 ,64 2.00

-

$88,388.4 0
$121,382.00

$18,220.20
$15,864 .00

-

$996.60
$627.00

$983.70
$627.00

$1,034 .50
$627.00

$1,008.10
$627.00

$961.50
$526.00

$6.25
$13.4 0

$6.25
$13.4 0

$9.19
$13.50

$6.22
$13.30

$6.22
$13.30

$3.09
$3.51

$1,280.20
$617.00

$4 4 4 .30
$4 01.00

$581.4 0
$528.00

$677.70
$618.00

$750.20
$657.00

$1,029.70
$727.00

$1,028.4 0
$94 8.00

$874 .20
-$181.00

-

-$6,835.00
-$6,84 4 .00

-$89.70
-$4 ,14 2.00

$4 2.20
-

-$3,631.10
-$2,224 .00

$6,960.20
$4 ,271.00

$1,653.4 0
$3,365.00

$4 64 .10
-

-$251.80
-

$4 54 .90
$54 4 .00

$4 90.50
-$233.00

$1,011.30
$1,153.00

$24 0,357.30
$222,580.00

$4 4 ,678.00
$4 8,4 26.00

$14 ,099.80
$26,179.00

17.65
25.0

15.70

22.70

26.30

-75.20

-10.50

$160.00

-$1,066.00

Daimler AG (XTRA:DAI)

Diversified Metals and Mining

1974

Switzerland

Materials

61,000.0

$38,4 4 6.00

$5.4 2

$6.77

$4 .4 6

21.91

2.17

37.74

15.4 0

1.09

0.94

7099.50

-

60.10

$227,512.30

$7,4 02.90

$0.57

15.60

-

-

-

-

-1.95

104 .50

53.80

8.54

0.71

18.60

1.22

15.20

$214 ,4 36.00

$4 ,4 77.00

$3,004 .00

$1,004 .00

-

$3,117.00

$997.00

-

-

$3,004 .00

-$1,371.00

$4 18.00

-

$1,076.00

-$76.00

-

$2,782.00

$23,238.00

$1,4 20.00

$105,537.00

$38,175.00

-

$31,266.00

$19,4 17.00

$20,682.00

$8,602.00

$28,990.00

$5,752.00

$21,4 4 2.00

$10,203.00

$5,64 1.00

$18,795.00

$3,034 .00

$28,159.00

$3,070.00

$1,305.00

$169.00

-

$29,265.00

$1,305.00

-

-

-

-

-

-

$0.14

$0.14

$0.20

$0.14

$0.14

$0.16

$99.00

$2,015.00

-

-

-$1,14 8.00

$9,297.00

-$352.00

$281.00

-$6,4 63.00

$1,618.00

-$1,611.00

$720.00

$214 ,4 36.00

$4 ,4 77.00

$1,004 .00

1938

Semiconductors

South Korea

Information Technology

-

$178,735.60

$1,365.98

$1,4 05.01

$967.70

54 .77

4 .58

10.58

0.00

0.77

0.4 0

130.80

0.12

0.30

$306.10

84 .80

$210,716.00

$51,24 1.00

$186.90

17.10

12.60

12.30

13.30

13.10

25.60

26.50

20.50

15.30

34 .30

38.60

26.60

13.80

73.30

85.70

53.00

21.90

$189,082.60

$4 1,785.60

$27,312.90

$21,799.50

20.3

$21,592.50

$31,096.60

-

$74 8.4 0

$27,312.90

-$563.20

$894 .70

-$192.50

$28,126.80

$5,706.90

$2,872.70

$17,668.20

$64 ,391.10

$539.50

$170,24 8.00

$14 ,004 .80

$112.30

$109,982.4 0

$22,4 34 .90

$16,686.60

$2,992.70

$14 1,330.20

$76,939.20

$15,879.80

$7,939.00

$7,4 11.70

$5,030.80

$4 ,124 .00

$12,618.80

$3,657.80

$12,657.70

$4 50.90

$102.90

$83,984 .10

$12,657.70

$10,84 3.4 0

$10,34 2.80

$9,599.50

$9,319.80

$8,764 .50

$8,34 4 .90

$14 4 .80

$14 4 .80

$132.4 0

$14 4 .70

$14 4 .70

$7.52

-

-

-

-

-

-

-

$2,287.50

-

-

-

$83.20

-$1,24 4 .4 0

$1,750.90

-$8,025.80

-

-$4 36.50

-$4 37.60

-$3,771.80

-$1,910.70

$189,082.60

$4 1,785.60

$21,799.50

-

-

NYSE:PSX
BIT:ENI
NasdaqGS:AAPL
NYSE:GM

1875
1953
1977
1908

Oil and Gas Refining and Marketing
Integrated Oil and Gas
Computer Hardware
Automobile Manufacturers

United States
Italy
United States
United States

Energy
Energy
Information Technology
Consumer Discretionary

13,500.0
213,000.0

$38,4 56.20
$94 ,74 6.4 0
$4 07,861.10
$4 0,631.50

$62.01
$23.72
$4 34 .33
$29.72

$70.52
$25.70
$705.07
$30.68

$28.80
$19.60
$4 19.00
$18.70

72.62
31.06
65.04
66.4 8

-

0.03
0.01
0.04
0.09

0.00
0.00
0.00
0.02

1.21
1.07
0.93
1.31

2.19
0.58
1.03
1.68

620.20
3994 .00
939.10
1367.10

8.36
6.55
-

4 .4 7
15.80
18.4 0
9.60

$384 .80
$223.70
$5,091.90
$662.90

100.00
69.90
100.00
4 1.4 0

$202,355.10
$153,372.20
$185,230.20
$158,4 22.30

$8,54 3.10
$37,4 56.4 0
$59,927.80
$14 ,002.00

$7.4 7
$2.58
$4 4 .90
$3.36

8.30
5.11
15.00
15.80

5.4 2
115.90
-

9.20
128.80
-

8.34
84 .50
-

10.20
39.60
-

-4 .90
59.30
-

0.86
60.30
-

2.4 2
60.60
-0.05

8.04
4 4 .10
-3.29

105.4 0
21.30
64 .60
-61.10

15.4 0
60.4 0
-

126.50
10.70
61.30
-

18.70
15.50
52.20
13.30

-13.60
13.50
26.60
-32.70

82.4 0
8.65
27.30
-62.10

61.00
10.60
30.30
-35.60

-8.77
17.00
28.80
1.32

$166,169.00
$169,84 6.4 0
$164 ,687.00
$152,256.00

$5,592.00
$39,112.70
$59,255.00
$8,534 .00

$4 ,679.00
$26,537.00
$55,111.00
$2,855.00

$4 ,124 .00
$10,268.30
$4 1,74 7.00
$6,188.00

37.7
70.2
25.4
NM

$1,721.00
$14 ,796.00
$9,291.00
$9,118.00

$1,667.00
$6,057.10
$10,275.00
$11,793.00

-

$913.00
$12,575.60
-

$4 ,679.00
$26,537.00
$55,111.00
$2,855.00

-$24 6.00
-$10,909.10
-$4 89.00

$18.00
$12,737.80
$1,088.00
$4 4 1.00

-$27,095.00

$6,631.00
$21,886.70
$55,958.00
-$28,695.00

$2,500.00
$15,372.10
$14 ,211.00
-$34 ,831.00

$2.00
$1,329.00

$3,4 74 .00
$10,325.00
$16,154 .00
$17,133.00

$15,4 07.00
$83,678.60
$15,4 22.00
$24 ,196.00

$3,34 4 .00
$1,381.00
$695.00

$4 8,073.00
$185,04 0.50
$196,088.00
$14 9,4 22.00

$6,974 .00
$32,253.90
$0.00
$16,050.00

$10,391.00

$20,775.00
$78,052.60
$127,34 6.00
$25,853.00

$10,4 03.00
$38,598.50
$11,598.00
$10,395.00

$3,4 30.00
$11,178.10
$1,4 55.00
$14 ,714 .00

$2,14 1.20
$9,539.00
$12,967.00

$23,829.00
$23,214 .00
$29,752.00

$8,4 22.00
$7,792.00
$5,556.00

$10,710.00
$31,998.20
$26,398.00
$25,166.00

$2,931.00
$1,098.00

$16.00
$2,370.60
$2,310.00
$7,169.00

$6,956.00
$25,4 18.90
$2,569.00

$31.00
$4 ,633.10
$756.00

$391.00
$38,793.10
$0.00
$13,833.00

$29.00
$6,393.00
$871.00

$1,94 8.70
$10,310.00
$15,4 99.00

$3,332.00
$5,226.4 0
$896.00
$27,74 1.00

$10,391.00

$23,264 .00
$72,065.00
$90,054 .00
$27,729.00

$1,94 8.70
$10,310.00
$15,4 99.00

$3,633.00
-

$74 .00
$24 5.30
$3,381.00
$8,124 .00

$74 .00
$24 2.10
$3,150.00
$8,124 .00

$74 .00
$254 .60
$2,902.00
$8,124 .00

$74 .00
$24 8.10
$2,612.00
$8,124 .00

$56.00
$297.20
$2,4 29.00
$6,962.00

$6.56
$1.53
$4 4 .60
$3.10

$6.56
$1.53
$4 4 .60
$3.10

$7.59
$4 .65
$37.20
$1.81

$6.4 8
$2.84
$4 4 .10
$2.92

$6.4 8
$1.53
$4 4 .10
$2.92

$0.4 5
$1.4 2
$5.30
-

$381.00
$1,801.00
$595.00

$151.00
$4 86.00
$125.00

$173.00
$513.00
$192.00

$315.00
$54 2.00
$24 6.00

$399.00
$556.00
$312.00

$4 24 .00
$516.00
$394 .00

$4 69.00
$4 74 .00

$4 25.00
$5,610.10
-$4 ,359.00
$9,899.00

-$859.00

-$282.00
-$5,063.00
-$4 ,981.00
-

-$356.00
-$1,950.00
-$5,098.00

$4 7.00
$650.00
$4 .00

-$1,210.00
-$5,981.90
-$7,624 .00

$7,794 .00
$13,822.90
$9,036.00

-$100.00
-$2,163.60
-$34 ,695.00
$5,580.00

$4 ,633.10
$18.00

-$234 .70
-$634 .00
-$4 4 .00

-$985.00
$2,795.20
$6,298.00
$162.00

$55.00
-$1,839.30
-$219.00
-$326.00

-$14 3.00
-$4 ,171.70
-$2,658.00
-$4 60.00

$166,169.00
$169,84 6.4 0
$156,508.00
$152,256.00

$5,592.00
$39,112.70
$58,518.00
$8,534 .00

$4 ,124 .00
$10,268.30
$4 1,733.00
$6,188.00

12.5
15.0
12.5
13.33

0.4 8
0.16
0.23
0.31

XTRA:DAI
NYSE:GE

1883
1892

Automobile Manufacturers
Industrial Conglomerates

Germany
United States

Consumer Discretionary
Industrials

275,087.0
305,000.0

$57,787.80
$24 4 ,650.10

$54 .13
$23.59

$62.02
$23.90

$4 3.10
$18.00

50.77
56.93

10.91
-

0.06

0.02

1.4 2
1.18

1.17
1.63

1067.60
10370.90

2.70
4 67.80

4 .88
4 3.30

$333.90
$638.90

81.4 0
99.90

$152,4 81.80
$14 8,551.60

$16,993.90
$31,4 4 7.30

$6.08
$1.68

4 .4 8
10.50

2.59
-0.38

7.14
-0.37

3.60
1.4 1

-2.51
1.13

8.90
-9.29

-2.29
-8.95

3.89
-5.79

2.39
-3.18

7.36

18.70

81.70
7.24

13.10
-1.68

7.55
-3.60

-6.12
2.69

1.98
1.75

7.28
2.30

$150,698.10
$14 6,785.00

$19,181.20
$28,84 6.00

$10,086.4 0
$17,885.00

$8,036.10
$13,64 1.00

15.8
14 .4

$6,364 .30
$15,126.00

$19,657.20
-

-

-

$10,086.4 0
$17,885.00

-$779.20
-$1,353.00

$298.00
-

-

$10,176.00
$17,4 06.00

$1,612.50
$2,504 .00

-

$13,035.80
$77,356.00

$58,537.80
$16,070.00

$961.20
$4 6,14 3.00

$214 ,883.00
$685,328.00

$100,535.30
$4 14 ,060.00

-

$57,853.50
$123,026.00

$9,94 5.30
$21,500.00

$23,363.4 0
$15,295.00

$890.00
$9.00

$116,851.50
$35,919.00

$58,313.70
$19,84 9.00

$11,226.80
$15,675.00

$101,392.00

$16,032.70
$17,222.00

$14 ,4 37.30
$236,084 .00

$2,150.4 0
$5,4 4 4 .00

$80,762.60
$4 53,4 4 3.00

$2,225.4 0
$1,696.00

$11,572.60
$84 ,501.00

$956.20
$4 5,395.00

-

$51,4 76.50
$116,4 38.00

$11,572.60
$84 ,501.00

$5,4 84 .90
-

$6,680.80
$5,389.00

$6,566.50
$5,389.00

$6,786.60
$5,389.00

$6,4 99.50
$5,389.00

$6,153.4 0
$4 ,918.00

$7.53
$1.30

$7.53
$1.4 0

$5.51
$0.99

$7.53
$1.29

$7.53
$1.39

$2.90
$0.70

$1,011.30
$929.00

$288.10
$4 10.00

$288.10
$4 95.00

$379.10
$594 .00

$379.10
$74 4 .00

$4 74 .70
$885.00

$696.20
$1,731.00

-$1,571.60
-$21,366.00

-

-$3,093.20
-$7,189.00

-$33.00
-$5,115.00

$85.70
$951.00

-$29,874 .10
-$106,173.00

$4 8,657.10
$63,019.00

-$5,581.10
$18,066.00

$3,618.00

-$1,4 56.00

-$818.80
-$4 24 .00

-$1,107.50
-$1,274 .00

$182.00
-$774 .00

$150,698.10
$14 6,785.00

$19,181.20
$28,84 6.00

$8,036.10
$13,64 1.00

7.69
5.0

0.16
0.25

37.11

$133,826.80

$18,94 5.90

$14 .00

$139,171.00

$18,872.00

$14 ,04 0.00

$11,004 .00

20.4

$11,64 7.00

$4 ,832.00

$14 ,04 0.00

$13,723.00

$599.00

-$1,122.00

-$886.00

$1,001.00

$139,171.00

$18,872.00

$11,004 .00

$4 7,192.50

$62.52

$66.94

$50.20

2.11

29.4 0

-

0.65

0.4 9

754 .90

$64 .00

68.50

0.01

19.60

18.20

18.50

25.70

4 .36

11.20

11.20

19.70

1.74

4 .13

$4 ,119.00

-

-$538.00

$257.00

$2,798.00

-

$2,914 .00

$6,621.00

-

$73,207.00

$6,4 31.00

$8,098.00

$7,263.00

$126.00

-$172.00

$2,753.00

$612.00

-

$67,638.00

$2,753.00

-

-

-

-

-

-

$14 .50

$14 .50

$11.4 0

$14 .20

$14 .20

$218.00

-$2,025.00

-

Taiwan

Information Technology

-

$31,827.20

$2.69

$3.51

$2.4 0

25.12

-

26.37

-

0.82

1.01

11834 .60

-

39.50

$90.60

67.00

$135,689.10

$6,339.10

$0.30

9.84

17.50

17.70

19.60

30.00

4 .05

3.51

7.30

18.10

7.78

9.11

12.60

25.90

16.10

30.90

29.60

13.10

$134 ,326.00

$5,74 4 .10

$3,730.20

$3,259.4 0

22.5

$2,4 12.60

$6,038.10

-

-

$3,730.20

-$330.10

$4 64 .10

-

$4 ,071.60

$914 .60

-

$17,387.60

$13,4 24 .30

$17.4 0

$70,317.20

$15,872.60

-

$22,237.50

$21,74 7.00

$12,034 .20

$264 .80

$20,002.20

$6,577.90

$21,956.80

$10,509.90

$3,4 21.00

$3,635.20

$1,210.70

$12,793.10

$1,227.80

$10,888.20

$23.00

-

$19,077.30

$10,888.20

$1,569.30

$1,4 93.00

$1,4 24 .70

$1,4 21.50

$1,34 8.60

$1,313.60

$0.28

$0.28

$0.23

$0.27

$0.27

-

-

-

-

-

-

-

$13.50

-$3,117.80

-

-$551.50

-

-

-$332.00

$3,04 2.00

$721.00

-

-

$3,091.30

$650.70

-$5,4 33.80

$134 ,326.00

$5,74 4 .10

$3,259.4 0

-

-

United States
France
United States
United States

Consumer Discretionary
Utilities
Telecommunication Services
Healthcare

171,000.0
219,330.0
24 1,810.0
-

$53,24 1.50
$50,183.10
$211,64 6.60
$25,333.70

$13.55
$21.29
$38.54
$108.78

$14 .30
$26.70
$38.80
$111.55

$8.82
$18.4 0
$30.50
$84 .70

54 .52
24 .78
56.75
88.74

0.57
-

1.55
0.00
0.07
0.36

0.15
0.00
0.02
0.26

1.4 0
1.11
0.63
0.70

2.26
0.56
0.53
0.77

3929.30
2357.30
54 91.60
232.90

108.00
26.90
17.00
8.00

4 2.90
5.15
26.4 0
1.53

$697.50
$123.00
$982.50
$126.60

90.70
56.00
99.90
99.60

$133,825.70
$111,703.30
$129,039.90
$127,036.20

$11,021.70
$18,038.80
$4 2,384 .50
$3,390.30

$1.4 4
$1.78
$2.52
$7.89

26.60
2.52
6.01
14 .00

2.54
12.30

13.70
13.10
4 .24
9.60

-3.4 8
12.00
5.39
10.20

-1.88
8.64
11.50
8.39

-17.00
-9.4 8
11.20

13.20
-8.63
10.4 0

-2.02
18.30
-7.13
10.90

-4 .68
15.4 0
1.39
4 .39

27.80
-29.80
-15.70
10.20

4 .66
-14 .80
5.86

29.10
7.32
-10.50
6.16

4 .91
6.69
1.32
4 .4 9

-72.00
-61.30
84 .20
22.70

-18.70
5.77
-20.30
0.93

-4 .74
3.64
-10.60
1.4 3

-1.4 8
7.02
0.56
3.04

$134 ,252.00
$127,94 2.50
$127,4 34 .00
$123,534 .00

$11,871.00
$22,017.30
$29,010.00
$2,84 6.00

$6,667.00
$12,865.70
$12,997.00
$2,275.00

$5,665.00
$2,04 3.60
$7,264 .00
$1,600.00

26.6
4 2.7
27.8
26.9

$5,4 88.00
$12,099.70
$19,728.00
$206.00

$12,175.00
$17,134 .90
$4 1,079.00
$4 ,096.00

-

$9,378.30
$18,14 3.00
-

$6,667.00
$12,865.70
$12,997.00
$2,275.00

-$713.00
-$2,888.80
-$3,4 4 4 .00
-$229.00

$272.00
$300.60
$61.00
$19.00

$81.00

$7,720.00
$6,34 0.60
$10,4 39.00
$2,190.00

$2,056.00
$2,708.20
$2,900.00
$590.00

-

$6,24 7.00
$15,008.20
$4 ,868.00
$2,726.00

$26,228.00
$114 ,979.20
$109,767.00
$1,24 7.00

$39,600.50
$69,773.00
$5,310.00

$190,554 .00
$270,94 4 .70
$272,315.00
$33,4 33.00

$105,058.00
$75,796.70
$69,84 4 .00
$4 ,4 79.00

-

$15,94 7.00
$78,772.50
$92,362.00
$7,64 9.00

$5,361.00
$33,220.4 0
$12,657.00
$9,962.00

$7,362.00
$7,150.10
$1,036.00
$10,390.00

$4 13.00
$16,262.10
$3,024 .00
-

$59,063.00
$172,224 .90
$270,907.00
-

$32,835.00
$57,24 5.70
$161,14 0.00
-

$15,107.00
$23,707.60
$12,076.00
$15,04 7.00

$4 84 .00
$8,839.10
$1.00
-

$13,029.00
$34 ,682.60
$5,355.00
-

$12,870.00
$58,750.10
$66,358.00
$3,973.00

$364 .00
$15,112.4 0
$333.00
-

$99,4 88.00
$74 ,04 3.50
$64 ,753.00
$3,987.00

$4 3.00
$22,526.80
$263.00
-

$7,965.00
$19,064 .60
$3,04 5.00
$4 ,191.00

$4 0,74 3.10
$70,84 2.00
$4 ,4 97.00

-

$15,028.00
$81,753.80
$105,534 .00
$7,4 56.00

$7,965.00
$19,064 .60
$3,04 5.00
$4 ,191.00

$4 4 0.00

$5,300.00
$299.90
$1,197.00
$4 93.00

$5,300.00
$292.80
$1,197.00
$4 93.00

$5,300.00
$307.90
$1,197.00
$4 93.00

$5,300.00
$300.10
$1,307.00
$554 .00

$5,000.00
$304 .60
$1,280.00
$554 .00

$1.4 9
$0.90
$1.25
$6.73

$1.4 9
$0.90
$1.25
$6.73

$1.16
$1.95
$1.08
$5.4 9

$1.4 2
$0.88
$1.25
$6.60

$1.4 2
$0.88
$1.25
$6.60

$0.20
$1.98
$1.77
$0.80

$196.00
$2,4 62.90
$11,755.00
$233.00

$96.00
$633.90
$2,165.00
$75.00

$129.00
$633.90
$2,337.00
$92.00

$178.00
$633.90
$2,4 86.00
$123.00

$230.00
$633.90
$2,616.00
$157.00

$269.00
$1,168.20
$2,706.00
$188.00

$510.00
$1,936.80
$3,709.00
-

$3,565.00
$2,295.50
-$3,050.00
$939.00

-

-$763.00
-$2,791.20
-$10,24 1.00
-$196.00

-$125.00
-$4 72.00
-$12,752.00
-$1,615.00

$301.90
$4 77.00
$157.00

-$29,210.00
-$9,965.10
-$8,733.00
-$1,936.00

$33,64 4 .00
$15,277.20
$13,4 87.00
$2,4 17.00

-$9,059.00
$14 1.10
$64 .00
-$121.00

$66.00
$708.00
$74 0.00
-

$191.00
-$135.80
-$828.00
-$1,529.00

$4 85.00
$1,798.00
-$690.00

-$1,4 01.00
$9.00

-$1,622.00
-$1,365.00
-$138.00

$134 ,252.00
$127,94 2.50
$127,4 34 .00
$122,734 .00

$11,871.00
$22,017.30
$29,010.00
$2,880.00

$5,665.00
$2,04 3.60
$7,264 .00
$1,4 03.00

26.32
7.69
11.11

0.34
0.16
0.28
0.23

1892

Drug Retail

United States

Consumer Staples

24 1,500.0

$71,113.80

$57.76

$58.29

$4 3.10

87.25

-

0.18

0.06

0.68

0.78

1231.20

4 0.90

6.85

$377.80

99.80

$125,292.70

$9,758.4 0

$3.96

12.80

18.4 0

19.60

19.50

17.70

8.01

7.36

7.83

10.00

1....

This is the end of the preview. Download to see the full text
 
AdmiralAtomSnake9137 posted a question · Dec 05, 2014 at 9:15am

Sign up to view the entire interaction

Hi Please find the... View the full answer

8651301.doc

8651301.doc

Solutions: We have used Price Earnings Ratio (PER) in order to calculate, whether the stock
price is overpriced or underpriced. While calculating the under priced or overpriced stock, we
have...

    • 8 years ago