Berkshire Hathaway Look Through Earnings & Holdings
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAP
1
Enter your portfolio's native Currency symbol & Berkshire Hathaway holdings in blue cellsSymbolNo. units held(Market Value) Unit priceUnit curr- encyTrade Date/Time (Local Time)Currency :USD exchangeUnit price USDMarket Value Holding USD% of Total curr-entLow End Holding Valu'n USD% of Total Low EndLow End Unit Valu'n USDLow End Unit Valu'n in Unit CurrTypical Unit Valu'n in Unit CurrHigh End Unit Valu'n Unit CurrValueAttribNameValue Attrib DateValue Attrib AmountVal Attrib Curr- encyDivide ByValue Attrib after divideCurrent Inverse MultiplierCurrent MultiplierLow End MultiplierTypical MultiplierHigh End MultiplierHolding NameNo. of Shares OutstandingEPSEPS excl-udes errorEPS excluding error into USDEquity portfolio dividends per share (last FY)EPS less portfolio dividend income per share
2
Portfolio Owner's Currency
USD01USD15/02/2016 16:04:00110.000.00%0.000.00%1111None1USD1111111Portfolio Owner's Currency31/12/2018
3
Berkshire Hathaway Class A
BRK.A0.723114304300.00USD22/05/2019 16:01:011304300220,043.5944.28%195,853.5744.22%270847.43270847.43361129.91451412.39
Book Value/A-share (usu filed about 5 weeks after end of calendar quarter)
31/03/2019225,706USD1225706.200.74171.34821.21.62Berkshire Hathaway Class A723,11425/04/201916164.1116164.1116,164.11$2,233.2613,930.85
4
Berkshire Hathaway Class B
BRK.B1368.243498202.6000USD22/05/2019 16:02:451202.6000277,206.1355.78%247,056.8355.78%180.56180.56240.75300.94
Book Value/A-share (usu filed about 5 weeks after end of calendar quarter)
31/03/2019225,706USD1,500150.47079720.74271.34641.21.62Berkshire Hathaway Class B1,368,243,49825/04/201910.77610.77610.776071.488849.28723
5
Equivalent Holding Class B
BRK.B2452.914498202.6000USD22/05/2019 16:02:451202.6000496,960.48100.00%442,910.40100.00%180.56180.56240.75300.94
Book Value/A-share (usu filed about 5 weeks after end of calendar quarter)
31/03/2019225,706USD1,500150.47079720.74271.34641.21.62Equivalent Holding Class B2,452,914,498
Class B equivalent outstanding
6
Look Through Holdings below
Total Berkshire Hathaway Valuation:
496,960.48100.00%442,910.40100.00%
Portfolio:
442910.401181094.401476368.00
Latest chge: 2019-05-16 Updated 13-Fs. Still have proceeds of USG takeover during Q2 on sheet
Link: CNBC BRK Portfolio Tracker1,635,276.33
Class A equivalent outstanding
7
Lk-Thru holdings per BRK.B
BH.Portf
2452.91449879.4956USD22/05/2019 16:01:01179194,995.9239.24%159,387.2637.29%64.9864.9899.42165.70
Portfolio Lk-Thru EPS
22/05/20195.5232USD15.5231918970.069514.393111.764705881830Lk-Thru holdings per BRK.B2,452,914,498
Class B equivalent outstanding
8
BRK.B operating Co only
BH.Own
2452.914498123.1044USD22/05/2019 16:02:451123.1044301,964.5560.76%268,009.2562.71%109.26109.26167.17278.62
EPS less dividends
22/05/20199.2872USD19.28723220.075413.255211.764705881830BRK.B operating Co only2,452,914,498
Class B equivalent outstanding
9
Total Look-Through Class B
BRK.B-LT
2452.914498202.6000USD22/05/2019 16:02:451202.6000496,960.48100.00%427,396.52100.00%180.56174.24266.59444.31
Total Look-Thr EPS
22/05/201914.8104USD114.81042410.073113.679611.764705881830Total Look-Through Class B2,452,914,498
Class B equivalent outstanding
10
Click here to access CoBF forum thread Holding LinkSymbolEffec-tive units heldUnit priceUnit curr- encyTrade Date/Time (Local Time)Currency :USD exchangeUnit price USDHolding USD% of Total curr-entLow End Holding Valu'n USD% of Total Low EndLow End Unit Valu'n USDLow End Unit Valu'n in Unit CurrTypical Unit Valu'n in Unit CurrHigh End Unit Valu'n Unit CurrValueAttribNameValue Attrib DateValue Attrib AmountVal Attrib Curr- encyDivide ByValue Attrib after divideCurrent Inverse MultiplierCurrent MultiplierLow End MultiplierTypical MultiplierHigh End MultiplierHolding NameShares held by Berkshire HathawayShares per BRK.B shareEPS incl KHC though consolidated (excluding error)EPS excl. Kraft Heinz as consolidat-edEPS excl error & KHC into USDLook-through Earnings per BRK.B share (in USD) excl KHCCurrent Market value held per BRK.B share in USD excl KHCLook-through Earnings per BRK.B share (in USD) incl KHCCurrent Market value held per BRK.B share in USD incl KHC
11
Apple Inc.AAPL255.300329182.7800USD22/05/2019 16:00:011182.780046,663.7922.72%35,712.0127.85%139.88139.88214.02356.70EPS TTM in USD
GoogleFinance
11.89USD111.890.065115.372611.764705881830Apple Inc.255,300,3290.104080402811.8911.8911.891.23751598919.023816021.23751598919.02381602
12
Bank of America Corporation
BAC918.91928.4900USD22/05/2019 16:00:38128.490026,180.0012.75%29,081.0822.68%31.6531.6548.4280.70EPS TTM in USD
GoogleFinance
2.69USD12.690.094410.591111.764705881830Bank of America Corporation918,919,0000.3746233312.692.692.691.00773676110.67301871.00773676110.6730187
13
Wells Fargo & CoWFC432.38397346.1000USD22/05/2019 16:02:35146.100019,932.909.71%23,043.5217.97%53.2953.2981.54135.90EPS TTM in USD
GoogleFinance
4.53USD14.530.098310.176611.764705881830Wells Fargo & Co432,383,9730.17627356084.534.534.530.79851923068.1262111550.79851923068.126211155
14
Coca-Cola CoKO40049.6500USD22/05/2019 16:00:17149.650019,860.009.67%7,388.245.76%18.4718.4728.2647.10EPS TTM in USD
GoogleFinance
1.57USD11.570.031631.624211.764705881830Coca-Cola Co400,000,0000.16307131791.571.571.570.25602196928.0964909360.25602196928.096490936
15
American Express CoAXP151.6107120.0100USD22/05/2019 16:03:231120.010018,194.808.86%14,001.6910.92%92.3592.35141.30235.50EPS TTM in USD
GoogleFinance
7.85USD17.850.065415.287911.764705881830American Express Co151,610,7000.061808391667.857.857.850.48519587457.4176250830.48519587457.417625083
16
Kraft Heinz CoKHC325.44215231.8800USD22/05/2019 16:00:01131.880010,375.105.05%-31,855.04-24.84%-97.88-97.88-149.76-249.60EPS TTM in USD
GoogleFinance
-8.32USD1-8.32-0.2610-3.831711.764705881830Kraft Heinz Co325,442,1520.1326757016-8.320000-1.1038618374.229701367
17
U.S. BancorpUSB146.34699951.8500USD22/05/2019 16:01:08151.85007,588.093.69%7,196.835.61%49.1849.1875.24125.40EPS TTM in USD
GoogleFinance
4.18USD14.180.080612.404311.764705881830U.S. Bancorp146,346,9990.059662495014.184.184.180.24938922913.0935003660.24938922913.093500366
18
JPMorgan Chase & CoJPM60.059932110.8200USD22/05/2019 16:00:391110.82006,655.843.24%6,550.075.11%109.06109.06166.86278.10EPS TTM in USD
GoogleFinance
9.27USD19.270.083611.954711.764705881830JPMorgan Chase & Co60,059,9320.024485130679.279.279.270.22697716132.7134421810.22697716132.713442181
19
Moody's CorporationMCO24.669778189.8700USD22/05/2019 16:02:011189.87004,684.052.28%1,959.071.53%79.4179.41121.50202.50EPS TTM in USD
GoogleFinance
6.75USD16.750.035628.128911.764705881830Moody's Corporation24,669,7780.010057333036.756.756.750.067886997951.9095858220.067886997951.909585822
20
Bank of New York Mellon Corp
BK84.48875146.1600USD22/05/2019 16:00:21146.16003,900.001.90%3,846.723.00%45.5345.5369.66116.10EPS TTM in USD
GoogleFinance
3.87USD13.870.083811.927611.764705881830Bank of New York Mellon Corp84,488,7510.034444229943.873.873.870.13329916991.5899456540.13329916991.589945654
21
Delta Air Lines, IncDAL70.91045654.0600USD22/05/2019 16:00:47154.06003,833.421.87%4,997.103.90%70.4770.47107.82179.70EPS TTM in USD
GoogleFinance
5.99USD15.990.11089.025011.764705881830Delta Air Lines, Inc70,910,4560.028908653795.995.995.990.17316283621.5628018240.17316283621.562801824
22
Goldman Sachs Group Inc
GS18.784698195.5200USD22/05/2019 16:00:531195.52003,672.781.79%5,310.544.14%282.71282.71432.54720.90EPS TTM in USD
GoogleFinance
24.03USD124.030.12298.136511.764705881830Goldman Sachs Group Inc18,784,6980.0076581136524.0324.0324.030.1840244711.4973143810.1840244711.497314381
23
Southwest Airls CoLUV46.69271352.5700USD22/05/2019 16:02:12152.57002,454.641.20%2,318.161.81%49.6549.6575.96126.60EPS TTM in USD
GoogleFinance
4.22USD14.220.080312.457311.764705881830Southwest Airls Co46,692,7130.019035605624.224.224.220.080330255711.0007017870.080330255711.000701787
24
Charter Communications Inc
CHTR5.710711378.0800USD22/05/2019 16:00:011378.08002,159.111.05%380.270.30%66.5966.59101.88169.80EPS TTM in USD
GoogleFinance
5.66USD15.660.015066.798611.764705881830Charter Communications Inc5,710,7110.0023281329235.665.665.660.013177232340.88022049550.013177232340.8802204955
25
USG Takeover PriceUSG43.3879843.5000USD24/04/2019143.50001,887.380.92%0.000.00%0.000.000.000.00EPS TTM in USD
GoogleFinance
0USD10.00#DIV/0!#DIV/0!11.764705881830USG Corp43,387,9800.017688337700000.769442690100.7694426901
26
United Continental Holdings Inc
UAL21.93864281.8800USD22/05/2019 16:00:00181.88001,796.340.87%2,147.411.67%97.8897.88149.76249.60EPS TTM in USD
GoogleFinance
8.32USD18.320.10169.841311.764705881830
United Continental Holdings Inc
21,938,6420.0089439081628.328.328.320.074413315910.73232720030.074413315910.7323272003
27
Visa IncV10.56246164.2400USD22/05/2019 16:01:561164.24001,734.780.84%575.340.45%54.4754.4783.34138.90EPS TTM in USD
GoogleFinance
4.63USD14.630.028235.473011.764705881830Visa Inc10,562,4600.0043060856824.634.634.630.019937176710.70723151250.019937176710.7072315125
28
General Motors CoGM45.27569635.5500USD22/05/2019 16:00:57135.55001,609.550.78%3,350.402.61%74.0074.00113.22188.70EPS TTM in USD
GoogleFinance
6.29USD16.290.17695.651811.764705881830General Motors Co45,275,6960.018457918546.296.296.290.11610030760.65617900420.11610030760.6561790042
29
BYD Company Limited
SHE:002594
22548.9300CNY22/05/2019 16:29:040.144793237.08471,594.060.78%482.930.38%2.1514.8222.6837.80EPS TTM in USD
GoogleFinance
1.26CNY11.260.025838.833311.764705881830BYD Company Limited225,000,0000.091727616351.261.260.18243946980.016734737690.6498656470.016734737690.649865647
30
Sanofi (incl EuroNext equiv shares)
SNY40.43398542.0900USD22/05/2019 16:00:01142.09001,701.870.83%937.120.73%23.1823.1835.4659.10EPS TTM in USD
GoogleFinance
1.97USD11.970.046821.365511.764705881830
Sanofi (incl EuroNext equiv shares)
40,433,9850.016484058061.971.971.970.032473594380.69381400370.032473594380.6938140037
31
VeriSign IncVRSN7.905481197.6900USD22/05/2019 16:00:011197.69001,562.830.76%466.890.36%59.0659.0690.36150.60EPS TTM in USD
GoogleFinance
5.02USD15.020.025439.380511.764705881830VeriSign Inc7,905,4810.0032228930145.025.025.020.016178922930.637133720.016178922930.63713372
32
PNC Financial Services Group Inc
PNC9.771554132.0200USD22/05/2019 16:01:381132.02001,290.040.63%1,254.210.98%128.35128.35196.38327.30EPS TTM in USD
GoogleFinance
10.91USD110.910.082612.100811.764705881830
PNC Financial Services Group Inc
9,771,5540.00398365047310.9110.9110.910.043461626660.52592153540.043461626660.5259215354
33
MasterCard IncMA4.934756256.9000USD22/05/2019 16:01:171256.90001,267.740.62%347.760.27%70.4770.47107.82179.70EPS TTM in USD
GoogleFinance
5.99USD15.990.023342.888111.764705881830MasterCard Inc4,934,7560.0020117929125.995.995.990.012050639540.5168295990.012050639540.516829599
34
Costco Wholesale CorpCOST4.333363249.5100USD22/05/2019 16:00:011249.51001,081.220.53%364.000.28%84.0084.00128.52214.20EPS TTM in USD
GoogleFinance
7.14USD17.140.028634.945411.764705881830Costco Wholesale Corp4,333,3630.0017666180397.147.147.140.01261365280.44078886690.01261365280.4407888669
35
Red Hat IncRHT5.110471186.2000USD22/05/2019 16:02:231186.2000951.570.46%140.090.11%27.4127.4141.9469.90EPS TTM in USD
GoogleFinance
2.33USD12.330.012579.914211.764705881830Red Hat Inc5,110,4710.0020834281032.332.332.330.0048543874810.38793431280.0048543874810.3879343128
36
DaVita HealthCare Partners Inc
DVA18.51348249.2500USD22/05/2019 16:02:01149.2500911.790.44%154.640.12%8.358.3512.7821.30EPS TTM in USD
GoogleFinance
0.71USD10.710.014469.366211.764705881830
DaVita HealthCare Partners Inc
18,513,4820.0075475447740.710.710.710.0053587567890.37171658010.0053587567890.3717165801
37
Liberty Sirius XM Group Series C
LSXMK23.94295838.0800USD22/05/2019 16:00:01138.0800911.750.44%940.820.73%39.2939.2960.12100.20EPS TTM in USD
GoogleFinance
3.34USD13.340.087711.401211.764705881830
Liberty Sirius XM Group Series C
23,942,9580.0097610242923.343.343.340.032601821130.3716998050.032601821130.371699805
38
Amazon Com IncAMZN0.48331859.6800USD22/05/2019 16:00:0111859.6800898.780.44%136.290.11%282.00282.00431.46719.10EPS TTM in USD
GoogleFinance
23.97USD123.970.012977.583611.764705881830Amazon Com Inc483,3000.000197030919923.9723.9723.970.004722831150.36641446110.004722831150.3664144611
39
Travelers Companies Inc
TRV6.001391147.9600USD22/05/2019 16:01:221147.9600887.970.43%694.750.54%115.76115.76177.12295.20EPS TTM in USD
GoogleFinance
9.84USD19.840.066515.036611.764705881830Travelers Companies Inc6,001,3910.002446636859.849.849.840.02407490660.36200438830.02407490660.3620043883
40
M&T Bank CorpMTB5.38204165.6400USD22/05/2019 16:02:031165.6400891.480.43%158.300.12%29.4129.4145.0075.00
Wild guess future EPS
Approx2.5USD12.500.015166.256011.764705881830M&T Bank Corp5,382,0400.0021941408913.9413.9413.940.030586324010.3634374970.030586324010.363437497
41
Sirius XM Hldgs IncSIRI137.9157295.5600USD22/05/2019 16:00:0115.5600766.810.37%373.180.29%2.712.714.146.90EPS TTM in USD
GoogleFinance
0.23USD10.230.041424.173911.764705881830Sirius XM Hldgs Inc137,915,7290.056225249230.230.230.230.012931807320.31261238570.012931807320.3126123857
42
American Airlines Group Inc
AAL22.95829.9200USD22/05/2019 16:00:01129.9200686.900.33%823.790.64%35.8835.8854.9091.50EPS TTM in USD
GoogleFinance
3.05USD13.050.10199.809811.764705881830American Airlines Group Inc22,958,0000.0093594782943.053.053.050.02854640880.28003559050.02854640880.2800355905
43
Synchrony Financial SYF20.80335.2400USD22/05/2019 16:01:12135.2400733.100.36%624.090.49%30.0030.0045.9076.50
2018 EPS estimate
GoogleFinance
2.55USD12.550.072413.819611.764705881830Synchrony Financial 20,803,0000.0084809315684.474.474.470.037909764110.29886802850.037909764110.2988680285
44
Store Capital CorpSTOR18.62167434.2300USD22/05/2019 16:01:53134.2300637.420.31%221.270.17%11.8811.8818.1830.30EPS TTM in USD
GoogleFinance
1.01USD11.010.029533.891111.764705881830Store Capital Corp18,621,6740.0075916523041.011.011.010.0076675688270.25986225840.0076675688270.2598622584
45
Restaurant Brands International Inc
QSR8.43822568.7300USD22/05/2019 16:02:02168.7300579.960.28%344.480.27%40.8240.8262.46104.10EPS TTM in USD
GoogleFinance
3.47USD13.470.050519.806911.764705881830
Restaurant Brands International Inc
8,438,2250.003440081183.473.473.470.011937081690.23643677950.011937081690.2364367795
46
Axalta Coating Systems Ltd
AXTA21.8824.9800USD22/05/2019 16:00:28124.9800546.560.27%193.060.15%8.828.8213.5022.50EPS TTM in USD
GoogleFinance
0.75USD10.750.030033.306711.764705881830Axalta Coating Systems Ltd21,880,0000.0089200010920.750.750.750.0066900008190.22282162730.0066900008190.2228216273
47
Torchmark CorpTMK6.35372788.4500USD22/05/2019 16:02:05188.4500561.990.27%467.190.36%73.5373.53112.50187.50EPS TTM in USD
GoogleFinance
6.25USD16.250.070714.152011.764705881830Torchmark Corp6,353,7270.0025902765896.256.256.250.016189228680.22910996430.016189228680.2291099643
48
Home Capital Group (CANADA)
HCG4018.5700CAD22/05/2019 16:00:000.7443522213.8226552.900.27%148.870.12%3.725.0010.0015.00EPS TTM in USD
GoogleFinance
1.69CAD11.690.091010.988211.764705881830Home Capital Group (CANADA)40,000,0000.016307131791.691.691.2579552520.020513642080.22540729790.020513642080.2254072979
49
Teva Pharmaceutical Industries Ltd (ADR)
TEVA43.24929511.5400USD22/05/2019 16:00:56111.5400499.100.24%216.250.17%5.005.0010.0015.00EPS TTM in USD
GoogleFinance
-3.46USD1-3.46-0.2998-3.335311.764705881830
Teva Pharmaceutical Industries Ltd (ADR)
43,249,2950.01763179884-3.46-3.46-3.46-0.061006023990.2034709586-0.061006023990.2034709586
50
Phillips 66PSX5.55271585.6000USD22/05/2019 16:01:54185.6000475.310.23%736.220.57%132.59132.59202.86338.10EPS TTM in USD
GoogleFinance
11.27USD111.270.13177.595411.764705881830Phillips 665,552,7150.00226372138311.2711.2711.270.025512139990.19377455040.025512139990.1937745504
51
Liberty Sirius XM Group Series A
LSXMA10.55224337.8400USD22/05/2019 16:00:01137.8400399.300.19%414.640.32%39.2939.2960.12100.20EPS TTM in USD
GoogleFinance
3.34USD13.340.088311.329311.764705881830
Liberty Sirius XM Group Series A
10,552,2430.0043019204333.343.343.340.014368414250.16278466920.014368414250.1627846692
52
StoneCo Ltd.STNE14.16674827.7500USD22/05/2019 16:00:00127.7500393.130.19%250.000.19%17.6517.6527.0045.00
Wild guess future EPS
1.5USD11.500.054118.500011.764705881830StoneCo Ltd.14,166,7480.0057754756680.320.320.320.0018481522140.16026944980.0018481522140.1602694498
53
Suncor Energy Inc NewSU10.75831.9400USD22/05/2019 16:02:01131.9400343.610.17%231.610.18%21.5321.5332.9454.90EPS TTM in USD
GoogleFinance
1.83USD11.830.057317.453611.764705881830Suncor Energy Inc New10,758,0000.0043858030961.831.831.830.0080260196660.14008255090.0080260196660.1400825509
54
Liberty Global plc Class A
LBTYA11.41225.4100USD22/05/2019 16:00:01125.4100289.980.14%397.590.31%34.8434.8450.9267.00
2019 OCF estimate
Approx5.36USD15.360.21094.74076.59.512.5Liberty Global plc Class A11,412,0000.0046524247012.392.392.390.011119295040.11821811170.011119295040.1182181117
55
Lanxess AG
ETR:LXS
4.58959649.1200EUR22/05/2019 17:35:141.1155654.7963251.490.12%276.480.22%60.2454.0082.62137.70EPS TTM in USD
GoogleFinance
4.59EUR14.590.093410.701511.764705881830Lanxess AG4,589,5960.0018710786714.594.595.12042040.0095807093990.10252820170.0095807093990.1025282017
56
Liberty Global plc Class C
LBTYK7.34696824.9000USD22/05/2019 16:00:01124.9000182.940.09%216.090.17%29.4129.4145.0075.00
Wild guess future EPS
Approx2.5USD12.500.10049.960011.764705881830Liberty Global plc Class C7,346,9680.0029951993872.392.392.390.0071585265340.074580464730.0071585265340.07458046473
57
Società Cattolica di Assicurazione - Società Cooperativa
BIT:CASS
15.777.4900EUR22/05/2019 17:35:251.115568.3555131.770.06%134.530.10%8.537.6511.7019.50EPS TTM in USD
GoogleFinance
0.65EUR10.650.086811.523111.764705881830
Società Cattolica di Assicurazione - Società Cooperativa
15,770,0000.006429086710.650.650.7251140.0046618207810.053718519460.0046618207810.05371851946
58
Johnson & JohnsonJNJ0.3271138.7600USD22/05/2019 16:00:301138.760045.390.02%20.780.02%63.5363.5397.20162.00EPS TTM in USD
GoogleFinance
5.4USD15.400.038925.696311.764705881830Johnson & Johnson327,1000.00013335157035.45.45.40.00072009847940.018503863890.00072009847940.01850386389
59
Diageo P L C Spon ADR New
DEO0.22775168.5600USD22/05/2019 16:02:031168.560038.390.02%14.550.01%63.8863.8897.74162.90EPS TTM in USD
GoogleFinance
5.43USD15.430.032231.042411.764705881830Diageo P L C Spon ADR New227,7500.000092848731665.435.435.430.00050416861290.015650582210.00050416861290.01565058221
60
Proctor and GamblePG0.3154106.7200USD22/05/2019 16:01:341106.720033.660.02%15.580.01%49.4149.4175.60126.00EPS TTM in USD
GoogleFinance
4.2USD14.200.039425.409511.764705881830Proctor and Gamble315,4000.00012858173424.24.24.20.00054004328360.013722242670.00054004328360.01372224267
61
Liberty LiLAC Group A
NASDAQ:LILA
1.62518517.7700USD22/05/2019 16:00:01117.770028.880.01%8.130.01%5.005.0010.0015.00EPS TTM in USD
GoogleFinance
-1.92USD1-1.92-0.1080-9.255211.764705881830Liberty LiLAC Group A1,625,1850.0006625526496-1.92-1.92-1.92-0.0012721010870.01177356058-0.0012721010870.01177356058
62
Mondelez International Inc
MDLZ0.57852.0900USD22/05/2019 16:00:01152.090030.110.01%15.100.01%26.1226.1239.9666.60EPS TTM in USD
GoogleFinance
2.22USD12.220.042623.464011.764705881830Mondelez International Inc578,0000.00023563805442.222.222.220.00052311648080.012274386260.00052311648080.01227438626
63
Liberty LiLAC Group CLILAK1.2840217.8100USD22/05/2019 16:00:01117.810022.870.01%6.420.01%5.005.0010.0015.00EPS TTM in USD
GoogleFinance
-1.92USD1-1.92-0.1078-9.276011.764705881830Liberty LiLAC Group C1,284,0200.0005234670842-1.92-1.92-1.92-0.0010050568020.009322948769-0.0010050568020.009322948769
64
United Parcel Service Inc (UPS)
UPS0.059497.5000USD22/05/2019 16:02:20197.50005.790.00%3.660.00%61.6561.6594.32157.20EPS TTM in USD
GoogleFinance
5.24USD15.240.053718.606911.764705881830
United Parcel Service Inc (UPS)
59,4000.000024216090725.245.245.240.00012689231530.0023610688450.00012689231530.002361068845
65
Verisk Analytics IncVRSK0143.8600USD22/05/2019 16:00:011143.86000.000.00%0.000.00%42.1242.1264.44107.40EPS TTM in USD
GoogleFinance
3.58USD13.580.024940.184411.764705881830Verisk Analytics Inc003.583.583.580000
66
Verizon Communications Inc
VZ059.2500USD22/05/2019 16:00:06159.25000.000.00%0.000.00%45.5345.5369.66116.10EPS TTM in USD
GoogleFinance
3.87USD13.870.065315.310111.764705881830Verizon Communications Inc003.873.873.870000
67
Oracle CorpORCL054.2000USD22/05/2019 16:01:46154.20000.000.00%0.000.00%32.4732.4749.6882.80EPS TTM in USD
GoogleFinance
2.76USD12.760.050919.637711.764705881830Oracle Corp002.762.762.760000
68
Monsanto Co NewMON0125.5600USD
Takeover price/share less estimated 21% tax on estimate $11.72 per share gain (=$2.44 tax per share)
1125.56000.000.00%0.000.00%125.56125.56126.78128.00EPS TTM in USD
GoogleFinance
1.00E-18USD10.000.0000125560000000000000000.000011.764705881830Monsanto Co New001.00E-181.00E-181.00E-180.00E+0000.00E+000
69
Wal-Mart Stores IncWMT0102.2300USD22/05/2019 16:00:251102.23000.000.00%0.000.00%34.0034.0052.0286.70EPS TTM in USD
GoogleFinance
2.89USD12.890.028335.373711.764705881830Wal-Mart Stores Inc002.892.892.890000
70
Graham Holdings CoGHC0685.3800USD22/05/2019 16:02:021685.38000.000.00%0.000.00%680.35680.351040.941734.90EPS TTM in USD
GoogleFinance
57.83USD157.830.084411.851611.764705881830Graham Holdings Co0057.8357.8357.830000
71
International Business Machines Corp
IBM0136.3500USD22/05/2019 16:01:161136.35000.000.00%0.000.00%111.65111.65170.82284.70EPS TTM in USD
GoogleFinance
9.49USD19.490.069614.367811.764705881830
International Business Machines Corp
009.499.499.490000
72
TOTAL VALUATION:
Look Through Portfolio Valuation:
205,371.02100.00%128,234.75100.00%
Portfolio:
128234.75196350.39326920.205.52319189779.49564.41933005983.7253
73
Latest Manual Entry Date:
15/02/2016 16:04:00
at Market Price^
at Low End^
LOWTYPICALHIGH194,995,922,759205,371,018,565
74
-10123456789101105106,102,848,604
75
Colour Scale Example:LOWTYPICALHIGHLOWTYPICALHIGH
Colours chosen dark-bright-dark in adjacent columns to show visible gradations.
76
Consider buying
Consider selling to buy attractive opportunity
Consider selling
77
The idea of this worksheet is either to analyze the holdings in the Berkshire Hathaway stock portfolio (readily achieve by entering one-millionth of the total shares outstanding in cells C3 and C4). We also use it to calculate the look-through earnings and holdings attributable to us via our personal stake in Berkshire Hathaway by entering our own holdings in cells C3 and C4. As was as our main Portfolio Tracking sheet, showing each of our direct holdings and their market value, we maintain a worksheet called Look-Through Total Portfolio which adds our indirect stakes in Berkshire Hathaway's investees to our directly held stakes, helping us to gauge our overall exposure to companies we hold that are also held by Berkshire. For example, Berkshire Hathaway is likely to be a very large holding of ours most of the time (50-100%). It held a large stake in Apple and in Wells Fargo in 2016-17. The indirect holding might have added 2-5% to our rather large Apple exposure and a further 4-5% to our 4-5% Wells Fargo position. Similarly we held around 1% directly in IBM, and had significant look-through exposure to add (which declined markedly in Q4 2017, acccording to data released the week after we had sold our entire position to buy more BRK.B). Plus it holds Coke (KO), American Express, and many others which we haven't held directly as yet, but might consider holding in future, so we might wish to gauge our effective exposure.
78
Notes: (below)
79
Please note that the 13-F filing only indicates holdings roughly 45-135 days in the past and only includes stocks purchased on US markets like NYSE and NASDAQ. Foreign market holdings do not require quarterly reporting to SEC so are assumed based on
80
information contained in the Annual Report and other Berkshire Hathaway communications. Likewise the dividends already counted in GAAP EPS and deducted to avoid double-counting are usually updated only once the Annual Report is issued (see cell R8 for date).
81
Note also that unlike most reporting of Berkshire's 13-F holdings, these figures are COMBINED HOLDINGS including those Berkshire holdings held via New England Asset Management Inc and shown with code 01 02 in column 7 of their 13-F excluding pension holdings where known
82
WARNING: take care when using colour codes to make BUY and SELL decisions. It's not necessarily that simple and they may not be up-to-date.
83
The Value Attribute and the associated Low End, Typical, and High End multipliers are an approximation only to something indicicative of Intrinsic Value (IV) and various discounts to that estimated IV. EPS figures are typically based on Google Finance automated data, which may not be in
84
agreement with official records. Certain Value Attributes must be entered manually, such as Book Value, which is not available on Google Finance, so may be out of date. These atttributes tend to be historical, and the future of the company is what determines its true present value, so if
85
the business changes significantly, the value realised may differ from the projections. In Berkshire Hathaway, the buy-back program is authorised to buy and cancel its own shares at price up to 1.2x Book Value (BV) which is considered a significant discount to Intrinsic Value (IV). This tends
86
to put a soft floor below which the stock price rarely falls (but it still might, so if you need the money soon, don't rely on it as an absolute bottom). The A-share's Book Value per share is used (entered manually from the 10K or 10Q report) then divided by 1500 to arrive at the Class-B value.
87
Typical and high end valuations are very approximate figures, and what's considered High End for BRK might be nearer Typical for some other companies valued on Earnings Per Share. When new figures are published, the valuation figures may take a step-change. Sometimes one may
88
anticipate for example, a modest rise or fall in BV (though note that BRK's holdings of shares is marked-to-market, so if there is a bear market, that part of Book Value will usually decline but may be offset by an increase from profits in the trading businesses. Other elements of Book
89
Value for wholly-owned subsidiiaires are carried at historic values fixed many years ago, where the economic value is considerably higher nowadays (which is why Book Value significantly understates Intrinsic Value and 1.2 x BV is still below IV.
90
For many companies, I prefer to choose a Free Cash Flow yield, which is often similar to the Earnings Yield if they don't inflate their earnings by underplaying maintenance capital expenditure. FCF yield is defined as annual Free Cash Flow per share divided by share price, expressed as a
91
percentage. Earnings yield is Earnings Per Share divided by Share Price. I typically look for around 8.5% FCF yield to buy a company likely to grow earnings significantly over the years or perhaps 10% or more for companies with flatter earnings. The lower the price, the higher the yield
92
and this can be compared to other annual interest rates to give a feeling for the extra return being offered in exchange for the risks involved in owning shares. In practice, FCF has to be estimated by hand but EPS is available from Google Finance, so I used that. The more common
93
counterpart to Earnings Yield is P/E ratio, which is the inverse of Earnings Yield when not expressed as a percentage. For this reason I used P/E multipliers for Low End, Typical and High End. My Low End may be 1/0.085 = 11.76 and I show the inverse of the current P/E which is earnings
94
yield expressed as a decimal - so 0.081 would be 8.1% yield - and this is shown in the column Current Inverse Multiplier. Also, bear in mind that a temporarily low earnings figure may be a buying opportunity at an apparently high P/E ratio (apparently low Earning Yield). It's often better to
95
get an idea of 'normal' earnings averaged over 5 or 10 years if you believe that the earnings hit is only temporary. Using that figure for E, the E/P yield of P/E ratio may look very favourable, even though the depressed value of E currently shown in Google Finance makes the stock look
96
expensive.
97
98
99
100
Loading...