The following Excel File contains fundamental information on the 9338

| November 13, 2015
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

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

Sign up to view the entire interaction

Hi Please find the… View the full answer

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…

Get a 5 % discount on an order above $ 150
Use the following coupon code :
2018DISC
Interest Rates and Bond Valuation Case Worksheet
Week 8 : Wk8 - Final Exam Time Remaining: Question 1.1. (TCO 7) Assume that 550 units were worked on during a period 67504

Category: Homework Help

Our Services:
Order a customized paper today!