The following Excel File contains fundamental information on the 9338
Advanced Tutor1. 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....
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...
- 8 years ago