This report is for educational purposes only, and not to provide investment advice.Before making any investment decision, you should always do your own research or consult a investment professional.
While I try to be accurate, I assume no responsibility for any figure in this spreadsheet. Estimates Estimates Estimates
See my website on stocks or see my blog at the following sites. www.spbrunner.com/stocks.html www.spbrunner.blogspot.com/
Barclays PLC ADR LSE BARC NYSE: BCS www.barclays.com Fiscal Yr: Dec-31
Year 12/31/05 12/31/06 12/31/07 12/31/08 12/31/09 12/31/10 12/31/11 12/31/12 12/31/13 12/31/14 12/31/15 12/31/16 12/31/17 12/31/18 12/31/19 Value Description #Y Item Currency
Accounting Rules IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS Accounting Rules
**Note that each ADR represents 4 ordinary shares 4
Split
USD - CDN$ 1.1659 1.1653 0.9881 1.2246 1.0466 0.9946 1.0170 0.9949 1.0636 1.1601 1.3847 1.3427 1.3397 1.3397 1.3397 1.43% <-IRR #YR-> 10 Currency USD - CDN$ 35.58%
Change -3.1% -0.1% -15.2% 23.9% -14.5% -5.0% 2.3% -2.2% 6.9% 9.1% 19.4% -3.0% -0.2% 0.0% 0.0% 5.71% <-IRR #YR-> 5 Currency USD - CDN$ 34.66%
-1.1653 0 0 0 0 0 0 0 0 0 1.3427 2012 only Fixed
-1.0170 0 0 0 0 1.3427
UK£ -US$ 1.7188 1.9586 1.9843 1.4619 1.6221 1.5609 1.5536 1.6259 1.6573 1.5577 1.4763 1.2336 1.2398 1.2398 1.2398 -4.52% <-IRR #YR-> 10 Currency UK£ -US$ -37.52%
Change -10.8% 14.0% 1.3% -26.3% 11.0% -3.8% -0.5% 4.7% 1.9% -6.0% -5.2% -16.4% 0.5% 0.0% 0.0% -4.51% <-IRR #YR-> 5 Currency -23.75%
-1.9586 0 0 0 0 0 0 0 0 0 1.2336
-1.5536 0 0 0 0 1.2336
UK£ -CDN$ 2.00343 2.2822 1.9607 1.7894 1.7034 1.5477 1.5821 1.6208 1.7627 1.8071 2.0443 1.6564 1.6609 1.6609 1.6609 -3.15% <-IRR #YR-> 10 Currency UK£ -US$ -15.29%
Change -13.1% 13.9% -14.1% -8.7% -4.8% -9.1% 2.2% 2.4% 8.8% 2.5% 13.1% -19.0% 0.3% 0.0% 0.0% 0.92% <-IRR #YR-> 5 Currency 2.48%
-2.28216 0 0 0 0 0 0 0 0 0 1.6564
-1.5821 0 0 0 0 1.6564
Revenue* £17,978 £22,170 £23,492 £23,352 £29,954 £32,204 £33,033 £25,291 £28,444 £25,768 £25,987 £21,451 £22,175 £22,853 £23,443 -3.24% <-Total Growth 10 Revenue UK£
Increase 28.9% 23.3% 6.0% -0.6% 28.3% 7.5% 2.6% -23.4% 12.5% -9.4% 0.8% -17.5% 3.4% 3.1% 2.6% -0.33% <-IRR #YR-> 10 Revenue UK£ -3.24%
5 year Running Average £13,378 £15,577 £17,999 £20,187 £23,389 £26,234 £28,407 £28,767 £29,785 £28,948 £27,705 £25,388 £24,765 £23,647 £23,182 -8.27% <-IRR #YR-> 5 Revenue UK£ -35.06%
Revenue per Share £2.77 £3.39 £3.56 £2.79 £2.62 £2.64 £2.71 £2.07 £1.77 £1.56 £1.55 £1.26 £1.31 £1.35 £1.38 5.01% <-IRR #YR-> 10 5 yr Running Average UK£ 62.99%
Increase 28.22% 22.46% 4.92% -21.64% -5.90% 0.72% 2.43% -23.71% -14.55% -11.52% -0.99% -18.22% 3.38% 3.06% 2.58% -2.22% <-IRR #YR-> 5 5 yr Running Average UK£ -10.63%
5 year Running Average £2.04 £2.39 £2.75 £2.93 £3.03 £3.00 £2.86 £2.57 £2.36 £2.15 £1.93 £1.64 £1.49 £1.41 £1.37 -9.40% <-IRR #YR-> 10 Revenue per Share UK£ -62.72%
P/S (Price/Sales) Med 2.05 1.94 1.78 1.14 0.83 1.21 0.88 1.01 1.63 1.62 1.45 1.45 -14.13% <-IRR #YR-> 5 Revenue per Share UK£ -53.30%
P/S (Price/Sales) Close 2.21 2.15 1.42 0.55 1.05 0.99 0.65 1.27 1.54 1.56 1.43 1.85 1.64 1.59 1.55 -3.68% <-IRR #YR-> 10 5 yr Running Average UK£ -31.24%
*Total Income from Income Statement (IFRS) 2005 and on (Operating Income (UK GAAP) before 2005) P/S Med 10 yr 1.33 5 yr 1.45 23.29% Diff M/C -10.55% <-IRR #YR-> 5 5 yr Running Average UK£ -42.73%
-£22,170 £0 £0 £0 £0 £0 £0 £0 £0 £0 £21,451
-£33,033 £0 £0 £0 £0 £21,451
-£15,577 £0 £0 £0 £0 £0 £0 £0 £0 £0 £25,388
-£28,407 £0 £0 £0 £0 £25,388
-£3.39 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £1.26
-£2.71 £0.00 £0.00 £0.00 £0.00 £1.26
-£2.39 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £1.64
-£2.86 £0.00 £0.00 £0.00 £0.00 £1.64
Revenue* $30,901 $43,422 $46,615 $34,138 $48,589 $50,268 $51,322 $41,121 $47,140 $40,139 $38,366 $26,462 $27,493 $28,333 $29,065 -39.06% <-Total Growth 10 Revenue US$
Increase 15.0% 40.5% 7.4% -26.8% 42.3% 3.5% 2.1% -19.9% 14.6% -14.9% -4.4% -31.0% 3.9% 3.1% 2.6% -4.83% <-IRR #YR-> 10 Revenue US$ -39.06%
5 year Running Average $22,882 $28,316 $33,975 $36,389 $40,733 $44,607 $46,186 $45,088 $47,688 $45,998 $43,618 $38,646 $35,920 $32,158 $29,944 -12.41% <-IRR #YR-> 5 Revenue US$ -48.44%
Revenue per Share $19.05 $26.58 $28.25 $16.31 $17.03 $16.51 $16.83 $13.44 $11.70 $9.73 $9.13 $6.24 $6.48 $6.68 $6.85 3.16% <-IRR #YR-> 10 5 yr Running Average US$ 36.48%
Increase 14.39% 39.54% 6.30% -42.27% 4.42% -3.08% 1.95% -20.16% -12.90% -16.84% -6.16% -31.67% 3.89% 3.06% 2.58% -3.50% <-IRR #YR-> 5 5 yr Running Average US$ -16.33%
5 year Running Average $14.00 $17.36 $20.80 $21.37 $21.44 $20.94 $18.99 $16.02 $15.10 $13.64 $12.17 $10.05 $8.66 $7.65 $7.08 -13.49% <-IRR #YR-> 10 Revenue per Share US$ -76.52%
P/S (Price/Sales) Med 2.21 1.91 1.80 1.19 0.84 1.17 0.90 1.00 1.48 1.70 1.69 1.52 -18.00% <-IRR #YR-> 5 Revenue per Share US$ -62.92%
P/S (Price/Sales) Close 2.21 2.19 1.43 0.60 1.03 1.00 0.65 1.29 1.55 1.54 1.42 1.76 1.64 1.59 1.55 -5.32% <-IRR #YR-> 10 5 yr Running Average US$ -42.11%
*Total Income in US$ P/S Med 10 yr 1.34 5 yr 1.52 23.03% Diff M/C -11.95% <-IRR #YR-> 5 5 yr Running Average US$ -47.07%
-$43,422 $0 $0 $0 $0 $0 $0 $0 $0 $0 $26,462
-$51,322 $0 $0 $0 $0 $26,462
-$28,316 $0 $0 $0 $0 $0 $0 $0 $0 $0 $38,646
-$46,186 $0 $0 $0 $0 $38,646
-$26.58 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $6.24
-$16.83 $0.00 $0.00 $0.00 $0.00 $6.24
-$17.36 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $10.05
-$18.99 $0.00 $0.00 $0.00 $0.00 $10.05
EPS Basic £0.54 £0.72 £0.69 £0.59 £0.86 £0.30 £0.25 -£0.085 £0.038 -£0.007 -£0.019 £0.104 -85.54% <-Total Growth 10 EPS Basic UK£
Pre-split 02
EPS Diluted* UK£ £0.53 £0.70 £0.67 £0.58 £0.82 £0.29 £0.24 -£0.085 £0.037 -£0.007 -£0.019 £0.103 £0.137 £0.214 £0.248 -85.24% <-Total Growth 10 EPS Diluted UK£
Increase 2.73% 32.70% -4.44% -13.79% 41.91% -65.07% -15.79% -135.42% 143.53% -118.92% -171.43% 642.11% 33.01% 56.20% 15.89% -18.75% <-IRR #YR-> 10 Earnings per Share UK£ -85.24% 0 #VALUE!
Earnings Yield 8.6% 9.6% 13.2% 37.5% 29.6% 10.9% 13.6% -3.2% 1.4% -0.3% -0.9% 4.4% 6.4% 10.0% 11.6% -18.28% <-IRR #YR-> 5 Earnings per Share UK£ -57.08%
5 year Running Average £0.433 £0.498 £0.565 £0.596 £0.656 £0.608 £0.517 £0.366 £0.259 £0.094 £0.033 £0.006 £0.050 £0.086 £0.137 #NUM! <-IRR #YR-> 10 5 yr Running Average UK£ -98.84%
10 year Running Average £0.393 £0.397 £0.445 £0.481 £0.533 £0.520 £0.507 £0.466 £0.427 £0.375 £0.321 £0.261 £0.208 £0.172 £0.115 -59.26% <-IRR #YR-> 5 5 yr Running Average UK£ -98.88%
* ESP per ordinary share in pence. E/P 10 Yrs 10.23% 5Yrs -0.29% -0.29%
-£0.698 £0.000 £0.000 £0.000 £0.000 £0.000 £0.000 £0.000 £0.000 -£0.019 £0.103
-£0.240 £0.000 £0.000 £0.000 -£0.019 £0.103
-£0.498 £0.000 £0.000 £0.000 £0.000 £0.000 £0.000 £0.000 £0.000 £0.000 £0.006
-£0.517 £0.000 £0.000 £0.000 £0.000 £0.006
EPS Basic US$ $3.74 $5.63 $5.47 $3.47 $5.59 $1.90 $1.56 -$0.55 $0.25 -$0.04 -$0.11 $0.51 -90.89% <-Total Growth 10 EPS Basic US$
EPS Diluted* US$ $3.62 $5.47 $5.29 $3.36 $5.29 $1.78 $1.49 -$0.55 $0.25 -$0.04 -$0.11 $0.51 $0.68 $1.06 $1.23 -90.71% <-Total Growth 10 EPS Diluted US$
Increase -8.35% 51.21% -3.19% -36.49% 57.47% -66.39% -16.18% -137.06% 144.37% -117.78% -157.25% 552.97% 33.68% 56.20% 15.89% -21.15% <-IRR #YR-> 10 Earnings per Share US$ -90.71% 0 #VALUE!
Earnings Yield 8.6% 9.4% 13.1% 34.3% 30.1% 10.8% 13.6% -3.2% 1.4% -0.3% -0.9% 4.6% 6.4% 10.0% 11.5% -19.37% <-IRR #YR-> 5 Earnings per Share US$ -65.92%
5 year Running Average $2.97 $3.64 $4.26 $4.34 $4.61 $4.24 $3.44 $2.28 $1.65 $0.58 $0.21 $0.01 $0.26 $0.42 $0.67 #NUM! <-IRR #YR-> 10 5 yr Running Average US$ -99.75%
10 year Running Average $2.62 $2.73 $3.14 $3.33 $3.67 $3.61 $3.54 $3.27 $2.99 $2.60 $2.22 $1.73 $1.27 $1.04 $0.63 #NUM! <-IRR #YR-> 5 5 yr Running Average US$ -99.74%
* ESP per ADR E/P 10 Yrs 7.70% 5Yrs -0.29%
-5.468 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.508
-1.492 0.000 0.000 0.000 0.000 0.508
-$3.64 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.01
-$3.44 $0.00 $0.00 $0.00 $0.00 $0.01
Dividend Estimates £0.031 £0.081 £0.104 Dividend Estimates
Dividend Estimates 3.0% 162.8% 28.1% Dividend Estimates
Special Dividends $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 <-Median-> 10 Special Dividends UK£
Presplit Dividends US$
Exch in UK£ £0.249 £0.279 £0.320 £0.340 £0.010 £0.045 £0.055 £0.065 £0.065 £0.065 £0.065 £0.030 £0.030 £0.030 £0.030 Reconcilation Dividends UK£
Exch in US$ $1.72 $2.19 $2.54 $1.99 $0.06 $0.28 $0.34 $0.42 $0.43 $0.41 $0.38 $0.15 $0.15 $0.15 $0.15 Reconcilation Dividends US$
Dividend* £0.250 £0.279 £0.320 £0.340 £0.010 £0.045 £0.055 £0.065 £0.065 £0.065 £0.065 £0.030 £0.030 £0.030 £0.030 -89.25% <-Total Growth 10 Dividends UK£
Increase 4.0% 11.8% 14.7% 6.3% -97.1% 350.0% 22.2% 18.2% 0.0% 0.0% 0.0% -53.8% 0.0% 0.0% 0.0% 3.13% <-Median-> 10 Dividends UK£
Dividends 5 Yr Running $0.21 $0.23 $0.26 $0.29 $0.24 $0.20 $0.15 $0.10 $0.05 $0.06 $0.06 $0.06 $0.05 $0.04 $0.04 -74.94% <-Total Growth 10 Dividends 5 Yr Running UK£
Yield H/L Price 4.40% 4.24% 5.06% 10.69% 0.46% 1.41% 2.31% 3.12% 2.26% 2.58% 2.89% 1.64% 1.32% 2.44% <-Median-> 10 Dividends UK£
Yield on HighPrice 4.06% 3.82% 4.05% 6.69% 0.26% 1.17% 1.65% 2.44% 1.99% 2.19% 2.84% 1.26% 1.25% 2.09% <-Median-> 10 Dividends UK£
Yield on Low Price 4.80% 4.76% 6.74% 26.62% 1.95% 1.76% 3.87% 4.32% 2.61% 3.13% 2.94% 2.36% 1.39% 3.03% <-Median-> 10 Dividends UK£
Yield on Close Price 4.08% 3.82% 6.35% 22.16% 0.36% 1.72% 3.12% 2.48% 2.40% 2.67% 2.95% 1.29% 1.40% 1.40% 1.40% 2.57% <-Median-> 10 Dividends UK£
Payout Ratio EPS 47.43% 39.97% 47.98% 59.13% 1.23% 15.79% 22.92% -76.47% 175.68% -928.57% -342.11% 29.13% 21.90% 14.02% 12.10% 19.35% <-Median-> 10 DPR EPS UK£
DPR EPS 5 Yr Running 48.27% 46.45% 45.80% 47.97% 36.52% 32.69% 29.81% 28.13% 18.56% 62.77% 189.76% 1000.00% 101.59% 51.40% 27.09% 41.16% <-Median-> 10 DPR EPS 5 Yr Running UK£
Payout Ratio CFPS -15.42% 18.15% -19.65% 8.44% 0.27% 2.93% 2.31% -5.80% -4.16% -10.27% 6.77% 4.51% 7.37% 6.37% 7.79% 1.29% <-Median-> 10 DPR CF UK£
DPR CF 5 Yr Running 184.41% 75.50% -116.10% 43.79% 20.02% 10.88% 7.71% 4.91% 4.90% 48.98% 1128.42% -17.15% -156.29% 11.76% 6.41% 9.30% <-Median-> 10 DPR CF 5 Yr Running UK£
Payout Ratio CFPS WC -15.42% 20.52% 31.11% 30.92% 0.67% 9.82% 5.42% 7.06% 13.27% 16.96% 11.87% -4.54% 7.37% 6.37% 7.79% 10.85% <-Median-> 10 DPR CF WC UK£
DPR CF WC 5 Yr Running 184.41% 85.42% 94.77% 50.77% 35.63% 18.27% 15.11% 10.33% 5.48% 9.03% 9.39% 17.26% 21.86% 19.17% 16.09% 16.19% <-Median-> 10 DPR CF WC 5 Yr Running UK£
Median Values 5 Yr Med 5 Yr Cl 2.58% 2.48% 5 Yr Med Payout -76.47% -4.16% 11.87% -19.99% <-IRR #YR-> 10 Dividends UK£ -89.25%
* Dividends Dividends paid, not dividends declared 5 Yr Med and Cur. -45.60% -43.41% Last Div Inc ---> £0.07 £0.07 0.0% -11.42% <-IRR #YR-> 5 Dividends UK£ -45.45%
-0.279 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.030
-0.055 0.000 0.000 0.000 0.000 0.030
Historical Dividends Historical High Div 6.59% Low Div 1.20% Ave Div 3.90% Med Div 3.41% Close Div 3.14% Historical Dividends
High/Ave/Median Values Curr diff Exp. -78.73% Exp 16.82% Exp. -64.01% Exp. -58.89% Exp. -55.31% High/Ave/Median
Future Dividend Yield Div Yd 1.40% earning in 5 Years at IRR of 0.00% Div Inc. 0.00% Future Dividend Yield
Future Dividend Yield Div Yd 1.40% earning in 10 Years at IRR of 0.00% Div Inc. 0.00% Future Dividend Yield
Future Dividend Yield Div Yd 1.40% earning in 15 Years at IRR of 0.00% Div Inc. 0.00% Future Dividend Yield
Cost covered if held 5 years 24.79% 23.61% 26.35% 33.81% 23.12% 17.52% 11.70% 8.15% 7.54% 13.56% 9.87% 12.19% 12.23% 7.63% 7.33% 12.88% <-Median-> 10 Paid Median Price UK£
Cost covered if held 10 years 88.38% 83.87% 58.38% 63.01% 58.72% 48.39% 39.33% 36.84% 39.49% 28.81% 23.07% 16.11% 12.18% 14.46% 22.07% 39.41% <-Median-> 10 Paid Median Price UK£
Cost covered if held 15 years 143.52% 119.88% 73.26% 69.72% 66.82% 55.86% 45.24% 42.04% 44.70% 32.38% 69.72% <-Median-> 7 Paid Median Price UK£
Cost covered if held 20 years 161.00% 133.45% 80.63% 75.87% 71.91% 147.22% <-Median-> 2 Paid Median Price UK£
Yield if held 5 yrs 5.92% 5.69% 6.52% 8.05% 0.19% 0.79% 0.84% 1.03% 2.04% 2.99% 2.04% 1.26% 1.44% 1.04% 1.19% 1.65% <-Median-> 10 Paid Median Price UK£
Yield if held 10 yrs 13.84% 13.05% 9.25% 9.51% 0.27% 1.07% 1.12% 1.32% 1.54% 1.25% 1.15% 0.46% 0.47% 0.94% 1.38% 1.20% <-Median-> 10 Paid Median Price UK£
Yield if held 15 yrs 2.50% 2.57% 1.88% 1.82% 1.79% 1.54% 0.61% 0.61% 0.71% 0.58% 1.82% <-Median-> 7 Paid Median Price UK£
Yield if held 20 yrs 3.61% 1.40% 0.87% 0.84% 0.82% 2.50% <-Median-> 2 Paid Median Price UK£
Special Dividends $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 <-Median-> 10 Special Dividends US$
Dividend US$ $1.85 $2.03 $2.54 $1.99 $0.06 $0.28 $0.34 $0.42 $0.43 $0.41 $0.38 $0.15 $0.15 $0.15 $0.15 -92.71% <-Total Growth 10 Dividends US$
What I got Div $1.85 $2.04 $2.57 $2.64 $0.07 $0.27 $0.35 $0.38 $0.40 $0.43 $0.39 $0.34 $0.34 $0.34 $0.34 US$
Check on Div $740.00 US$
Increase 18.6% 9.7% 25.1% -21.7% -96.7% 333.0% 21.7% 23.7% 1.9% -6.0% -5.2% -61.4% 0.5% 0.0% 0.0% -1.65% <-Median-> 10 Dividends US$
Dividends 5 Yr Running $1.36 $1.57 $1.86 $1.99 $1.69 $1.38 $1.04 $0.62 $0.31 $0.38 $0.40 $0.36 $0.30 $0.25 $0.20 -77.23% <-Total Growth 10 Dividends 5 Yr Running US$
Yield H/L Price 4.40% 4.01% 4.99% 10.23% 0.46% 1.45% 2.26% 3.16% 2.49% 2.45% 2.48% 1.56% 1.32% 2.46% <-Median-> 10 Dividends US$
Yield on HighPrice 3.94% 3.49% 4.11% 6.31% 0.26% 1.23% 1.58% 2.42% 2.28% 2.07% 2.13% 1.23% 1.25% 2.10% <-Median-> 10 Dividends US$
Yield on Low Price 4.98% 4.70% 6.37% 26.98% 2.11% 1.77% 4.00% 4.54% 2.75% 3.00% 2.96% 2.11% 1.39% 2.98% <-Median-> 10 Dividends US$
Yield on Close Price 4.40% 3.49% 6.29% 20.29% 0.37% 1.70% 3.11% 2.44% 2.38% 2.70% 2.96% 1.35% 1.40% 1.40% 1.40% 2.57% <-Median-> 10 Dividends US$
Payout Ratio EPS 51.16% 37.12% 47.98% 59.13% 1.23% 15.79% 22.92% -76.47% 175.68% -928.57% -342.11% 29.13% 21.90% 14.02% 12.10% 19.35% <-Median-> 10 DPR EPS US$
DPR EPS 5 Yr Running 45.81% 43.26% 43.51% 45.96% 36.78% 32.57% 30.29% 27.24% 18.66% 64.44% 193.00% 3988.49% 118.75% 58.98% 29.06% 40.15% <-Median-> 10 DPR EPS 5 Yr Running US$
Payout Ratio CFPS -16.63% 16.85% -19.65% 8.44% 0.27% 2.93% 2.31% -5.80% -4.16% -10.27% 6.77% 4.51% 7.37% 6.37% 7.79% 1.29% <-Median-> 10 DPR CF US$
DPR CF 5 Yr Running 192.03% 64.10% -128.59% 52.97% 23.98% 12.32% 8.87% 4.81% 5.05% 67.06% -179.54% -14.17% -45.52% 13.19% 6.43% 6.96% <-Median-> 10 DPR CF 5 Yr Running US$
Payout Ratio CFPS WC -16.63% 19.06% 31.11% 30.92% 0.67% 9.82% 5.42% 7.06% 13.27% 16.96% 11.87% -4.54% 7.37% 6.37% 7.79% 10.85% <-Median-> 10 DPR CF WC US$
DPR CF WC 5 Yr Running 192.03% 72.32% 74.32% 46.59% 35.58% 18.27% 15.59% 9.91% 5.49% 9.05% 9.38% 15.45% 19.89% 18.39% 15.69% 15.52% <-Median-> 10 DPR CF WC 5 Yr Running US$
Median Values 5 Yr Med 5 Yr Cl 2.48% 2.44% 5 Yr Med Payout -76.47% -4.16% 11.87% -23.04% <-IRR #YR-> 10 Dividends US$ -92.71%
Dividends received in US$. 5 Yr Med and Cur. -43.70% -42.77% Last Div Inc ---> $0.15 $0.15 0.5% -15.41% <-IRR #YR-> 5 Dividends US$ -56.69%
-$2.030 $0.000 $0.000 $0.000 $0.000 $0.000 $0.000 $0.000 $0.000 $0.000 $0.148
-$0.342 $0.000 $0.000 $0.000 $0.000 $0.148
Historical Dividends Historical High Div 6.36% Low Div 1.23% Ave Div 3.80% Med Div 3.06% Close Div 2.93% Historical Dividends
High/Ave/Median Values Curr diff Exp. -78.04% Exp 13.57% Exp. -63.19% Exp. -54.35% Exp. -52.33% High/Ave/Median
Future Div Yield Div Yd 1.88% earning in 10 Years at IRR of 3.0% Div Inc. 34.39% Future Div Yield
Future Div Yield Div Yd 2.18% earning in 15 Years at IRR of 3.0% Div Inc. 55.80% Future Div Yield
I am earning GC Div Gr -84.00% 3/9/00 # yrs -> 16 2000 $24.29 Cap Gain -56.15% I am earning GC
I am earning Div org yield 3.83% 12/31/14 US$ Trade Div G Yrly -11.63% Div start $0.93 -3.83% 0.61% I am earning Div
Cost covered if held 5 years 24.78% 26.66% 30.83% 35.01% 21.52% 16.41% 10.29% 6.09% 7.93% 13.22% 10.23% 11.86% 11.33% 7.13% 5.91% 12.54% <-Median-> 10 Paid Median Price US$
Cost covered if held 10 years 61.17% 63.47% 53.19% 49.91% 44.34% 41.12% 40.42% 26.30% 21.12% 13.82% 9.08% 14.29% 20.10% 42.73% <-Median-> 10 Paid Median Price US$
Cost covered if held 15 years 159.02% 121.30% 75.00% 69.99% 60.18% 57.13% 50.41% 46.16% 44.75% 28.78% 69.99% <-Median-> 7 Paid Median Price US$
Cost covered if held 20 years 177.42% 134.10% 81.77% 75.22% 63.81% 155.76% <-Median-> 2 Paid Median Price US$
Yield if held 5 yrs 6.73% 6.88% 8.44% 6.98% 0.16% 0.67% 0.67% 0.83% 2.22% 2.85% 1.98% 0.98% 1.11% 0.86% 0.90% 1.48% <-Median-> 10 Paid Median Price US$
Yield if held 10 yrs 11.34% 8.42% 0.24% 1.02% 1.16% 1.40% 1.51% 1.03% 0.91% 0.29% 0.29% 0.77% 1.05% 1.09% <-Median-> 10 Paid Median Price US$
Yield if held 15 yrs 2.61% 2.44% 1.89% 1.82% 1.50% 1.40% 0.50% 0.49% 0.52% 0.38% 1.82% <-Median-> 7 Paid Median Price US$
Yield if held 20 yrs 3.56% 1.06% 0.66% 0.63% 0.55% 2.31% <-Median-> 2 Paid Median Price US$
Dividends CDN $ $2.16 $2.37 $2.54 $3.23 $0.07 $0.27 $0.36 $0.37 $0.42 $0.49 $0.54 $0.45 $0.45 $0.45 $0.45 -15.23% <-IRR #YR-> 10 Dividends CDN$
Increase 15.3% 9.9% 6.9% 27.3% -97.9% 296.1% 32.8% 4.0% 12.9% 16.8% 9.7% -16.1% -0.2% 0.0% 0.0% 4.77% <-IRR #YR-> 5 Dividends CDN$
-$2.37 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.45
-$0.36 $0.00 $0.00 $0.00 $0.00 $0.45
Close Cdn$ $49.06 $67.75 $39.89 $12.00 $18.42 $16.43 $11.18 $17.23 $19.28 $17.41 $17.95 $14.77 $14.27 $14.27 $14.27 -78.20% <-Total Growth 10 Stock Price CDN$
Increase -10.8% 38.1% -41.1% -69.9% 53.5% -10.8% -32.0% 54.2% 11.9% -9.7% 3.1% -17.7% -3.4% 0.0% 0.0% -14.13% <-IRR #YR-> 10 Stock Price CDN$ -78.20%
5 yr Period ending 12/31/05 12/31/06 12/31/07 12/31/08 12/31/09 12/31/10 12/31/11 12/31/12 12/31/13 12/31/14 12/31/15 12/31/16 5.73% <-IRR #YR-> 5 Stock Price CDN$ 32.15%
5 year IRR 3.21% 8.15% 5.79% -14.48% -14.02% -14.89% -27.34% -12.87% 11.91% 1.01% 4.34% 9.38% -11.98% <-IRR #YR-> 10 Price & Div CDN$
Since 2000. -2.93% 9.38% <-IRR #YR-> 5 Price & Div CDN$
As a Canadian, would I have made money on this stock? Looking at 5 year periods to, including Dividends
$2.16 $2.37 $2.54 $3.23 $0.07 $0.27 $0.36 $0.37 $0.42 $0.49 $0.54 $15.22
Dates
-$67.75 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $14.77 Stock Price CDN$
-$11.18 $0.00 $0.00 $0.00 $0.00 $14.77 Stock Price CDN$
-$67.75 $2.54 $3.23 $0.07 $0.27 $0.36 $0.37 $0.42 $0.49 $0.54 $15.22
-$11.18 $0.37 $0.42 $0.49 $0.54 $15.22
-$11.18 $0.37 $0.42 $0.49 $0.54 $15.22 12/31/16 Price & Div CDN$
-$16.43 $0.36 $0.37 $0.42 $0.49 $18.49 12/31/15 Price & Div CDN$
-$18.42 $0.27 $0.36 $0.37 $0.42 $17.91 12/31/14 Price & Div CDN$
-$12.00 $0.07 $0.27 $0.36 $0.37 $19.71 12/31/13 Price & Div CDN$
-$39.89 $3.23 $0.07 $0.27 $0.36 $17.61 12/31/12 Price & Div CDN$
-$67.75 $2.54 $3.23 $0.07 $0.27 $11.54 Cut & 12/31/11 Price & Div CDN$
-$49.06 $2.37 $2.54 $3.23 $0.07 $16.70 Paste 12/31/10 Price & Div CDN$
$2.16 $2.37 $2.54 $3.23 $18.49 These 12/31/09 Price & Div CDN$
$2.16 $2.37 $2.54 $15.23 Dates 12/31/08 Price & Div CDN$
$2.16 $2.37 $42.43 12/31/07 Price & Div CDN$
$2.16 $70.12 12/31/06 Price & Div CDN$
$49.06 12/31/05 Price & Div CDN$
12/31/04 Price & Div CDN$
12/31/03 Price & Div CDN$
12/31/02 Price & Div CDN$
Graham Price UK£ £5.64 £6.90 £7.28 £7.52 £8.72 £5.17 £4.96 £4.86 £1.66 £1.67 £2.74 £2.83 £3.26 £4.07 £4.38 -59.04% <-Total Growth 10 Graham Price UK£
Price/GP Ratio Med 1.01 0.95 0.87 0.42 0.25 0.62 0.48 0.43 1.74 1.51 0.82 0.65 0.70 0.63 <-Median-> 10 Price/GP Ratio UK£
Price/GP Ratio High 1.09 1.06 1.09 0.68 0.44 0.74 0.67 0.55 1.97 1.78 0.84 0.85 0.73 0.79 <-Median-> 10 Price/GP Ratio UK£
Price/GP Ratio Low 0.92 0.85 0.65 0.17 0.06 0.49 0.29 0.31 1.50 1.25 0.81 0.45 0.66 0.47 <-Median-> 10 Price/GP Ratio UK£
Price/GP Ratio Close 1.09 1.06 0.69 0.20 0.32 0.51 0.35 0.54 1.63 1.46 0.80 0.83 0.66 0.53 0.49 0.62 <-Median-> 10 Price/GP Ratio UK£
Prem/Disc Close 8.57% 5.83% -30.74% -79.61% -68.35% -49.43% -64.51% -46.03% 63.33% 45.84% -19.50% -17.37% -34.32% -47.45% -51.19% -38.39% <-Median-> 10 Graham Price
US$ Price / curr / 4 £2.66 £2.73 £2.41 £2.19 £2.23 £2.15 £2.15 £2.15
UK£ Close £6.12 £7.30 £5.04 £1.53 £2.76 £2.62 £1.76 £2.62 £2.71 £2.44 £2.21 £2.33 £2.14 £2.14 £2.14 -68.02% <-Total Growth 10 Stock Price UK£
Increase 4.36% 19.27% -30.96% -69.56% 79.92% -5.20% -32.72% 49.05% 3.32% -10.18% -9.36% 5.78% -8.33% 0.00% 0.00% -10.77% <-IRR #YR-> 10 Stock Price UK£ -68.02%
P/E 11.64 10.46 7.56 2.67 3.38 9.18 7.34 -30.87 73.27 -347.86 -116.16 22.67 15.62 10.00 8.63 5.81% <-IRR #YR-> 5 Stock Price UK£ 32.60%
Trailing P/E 11.95 13.88 7.22 2.30 4.80 3.21 6.18 10.93 -31.89 65.81 -315.29 -122.87 20.78 15.62 10.00 -8.68% <-IRR #YR-> 10 Price & Dividend UK£
Median 10, 5 Yrs D.per yr 2.10% 3.02% % Tot Ret -24.16% 34.21% Price Inc 3.32% P/E: 5.36 -30.87 8.83% <-IRR #YR-> 5 Price & Dividend UK£
-£7.30 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £2.33
-£1.76 £0.00 £0.00 £0.00 £0.00 £2.33
-£7.30 £0.32 £0.34 £0.01 £0.05 £0.06 £0.07 £0.07 £0.07 £0.07 £2.36
-£1.76 £0.07 £0.07 £0.07 £0.07 £2.36
UK£ H/L Med £5.68 £6.58 £6.32 £3.18 £2.17 £3.19 £2.38 £2.09 £2.88 £2.52 £2.25 £1.83 £2.27 -72.17% <-Total Growth 10 Stock Price UK£
Increase 9.5% 15.9% -3.9% -49.7% -31.6% 46.8% -25.5% -12.3% 38.2% -12.5% -10.8% -18.6% 24.1% -12.01% <-IRR #YR-> 10 Stock Price UK£ -72.17%
P/E 10.79 9.43 9.48 5.53 2.67 11.20 9.91 -24.54 77.89 -360.36 -118.41 17.78 16.59 -5.10% <-IRR #YR-> 5 Stock Price UK£ -23.01%
Trailing P/E 11.08 12.51 9.06 4.77 3.78 3.91 8.34 8.69 -33.90 68.18 -321.39 -96.37 22.07 -9.56% <-IRR #YR-> 10 Price & Dividend UK£
Median 10, 5 Yrs D.per yr 2.45% 2.69% % Tot Ret -25.61% -111.92% Price Inc -12.31% P/E: 7.51 -24.54 -2.40% <-IRR #YR-> 5 Price & Dividend UK£
-£6.58 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £1.83
-£2.38 £0.00 £0.00 £0.00 £0.00 £1.83
-£6.58 £0.32 £0.34 £0.01 £0.05 £0.06 £0.07 £0.07 £0.07 £0.07 £1.86
-£2.38 £0.07 £0.07 £0.07 £0.07 £1.86
High Month Apr Feb Dec Feb Jan Jul Dec Feb
UK£ High £6.15 £7.30 £7.90 £5.09 £3.84 £3.83 £3.33 £2.67 £3.27 £2.97 £2.29 £2.39 £2.39 -67.26% <-Total Growth 10 Stock Price UK£
Increase 3.62% 18.70% 8.22% -35.63% -24.53% -0.16% -13.00% -20.04% 22.81% -9.42% -22.78% 4.39% 0.10% Stock Price UK£
Exch Rt £6.84 £7.42 £7.79 £5.39 £3.91 £3.67 £3.48 £2.69 £2.86 £3.14 £3.04 £2.43 £2.40 -67.26% <-Total Growth 10 Stock Price UK£
Increase 15.3% 8.6% 5.0% -30.9% -27.3% -6.2% -5.1% -22.9% 6.3% 10.0% -3.1% -20.2% -1.3% -10.57% <-IRR #YR-> 10 Stock Price UK£ -67.26%
P/E 11.69 10.46 11.84 8.84 4.70 13.44 13.89 -31.36 88.47 -423.57 -120.50 23.20 17.46 -6.44% <-IRR #YR-> 5 Stock Price UK£ -28.30%
Trailing P/E 12.01 13.88 11.32 7.62 6.67 4.70 11.70 11.11 -38.51 80.14 -327.07 -125.79 23.23 12.11 P/E Ratio Historical Median
Median 10, 5 Yrs Price Inc -3.11% P/E: 10.34 -31.36 20.54 P/E Ratio Historical High
-£7.300 £0.000 £0.000 £0.000 £0.000 £0.000 £0.000 £0.000 £0.000 £0.000 £2.390
-£3.334 £0.000 £0.000 £0.000 £0.000 £2.390
Low Month Jul Sep Jul Nov Jul Jul Jun Apr
UK£ Low £5.20 £5.86 £4.75 £1.28 £0.51 £2.55 £1.42 £1.51 £2.49 £2.08 £2.21 £1.27 £2.15 -78.29% <-Total Growth 10 Stock Price UK£
Increase 17.33% 12.69% -19.03% -73.09% -59.91% 398.73% -44.27% 5.80% 65.39% -16.47% 6.25% -42.44% 69.26% Stock Price UK£
Exch Rt £5.40 £5.52 £5.02 £1.26 £0.47 £2.54 £1.38 £1.43 £2.37 £2.17 £2.19 £1.42 £2.15 -74.18% <-Total Growth 10 Stock Price UK£
Increase 26.0% 2.1% -9.0% -74.9% -62.5% 437.2% -45.9% 4.0% 65.3% -8.5% 1.3% -35.1% 51.2% -14.17% <-IRR #YR-> 10 Stock Price UK£ -78.29%
P/E 9.9 8.4 7.1 2.2 0.6 9.0 5.9 -17.7 67.3 -297.1 -116.3 12.3 15.7 -2.22% <-IRR #YR-> 5 Stock Price UK£ -10.61%
Trailing P/E 10.2 11.1 6.8 1.9 0.9 3.1 5.0 6.3 -29.3 56.2 -315.7 -66.9 20.9 8.40 P/E Ratio Historical Median
Median 10, 5 Yrs Price Inc 1.29% P/E: 4.08 -17.71 1.26 P/E Ratio Historical Low
-£5.86 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £1.27
-£1.42 £0.00 £0.00 £0.00 £0.00 £1.27
Graham Price US$ $38.76 $54.04 $57.76 $43.99 $56.59 $32.31 $30.83 $30.91 $11.00 $10.73 $14.80 $13.94 $16.12 $20.14 $21.69 -74.20% <-Total Growth 10 Graham Price US$
Change -9.8% 39.4% 6.9% -23.8% 28.6% -42.9% -4.6% 0.3% -64.4% -2.5% 37.9% -5.8% 15.6% 25.0% 7.7% 0.94 <-Median-> 10 Historical P/GP Ratio US$
Price/GP Ratio Med 1.09 0.94 0.88 0.44 0.25 0.60 0.49 0.43 1.57 1.54 1.05 0.68 0.70 0.64 <-Median-> 10 Price/GP Ratio Med US$
Price/GP Ratio High 1.21 1.08 1.07 0.72 0.45 0.71 0.70 0.57 1.72 1.82 1.21 0.86 0.74 0.79 <-Median-> 10 Price/GP Ratio High US$
Price/GP Ratio Low 0.96 0.80 0.69 0.17 0.05 0.49 0.28 0.30 1.43 1.26 0.88 0.50 0.66 0.50 <-Median-> 10 Price/GP Ratio Low US$
Price/GP Ratio Close 1.09 1.08 0.70 0.22 0.31 0.51 0.36 0.56 1.65 1.40 0.88 0.79 0.66 0.53 0.49 0.63 <-Median-> 10 Price/GP Ratio Close US$
Prem/Disc Close 8.57% 7.58% -30.11% -77.72% -68.90% -48.86% -64.35% -43.96% 64.77% 39.88% -12.43% -21.10% -33.93% -47.13% -50.89% -37.04% <-Median-> 10 Graham Price US$
Pre-split 02
UK£ Price x currency x 4 $42.08 $57.19 $40.00 $8.97 $17.91 $16.34 $10.94 $17.07 $17.97 $15.17 $13.03 $11.52 $10.61 $10.61 $10.61 -79.86% <-Total Growth 10 Stock Price UK£
US$ Close $42.08 $58.14 $40.37 $9.80 $17.60 $16.52 $10.99 $17.32 $18.13 $15.01 $12.96 $11.00 $10.65 $10.65 $10.65 -81.08% <-Total Growth 10 Stock Price US$
Increase -7.88% 38.17% -30.56% -75.72% 79.59% -6.14% -33.47% 57.60% 4.68% -17.21% -13.66% -15.12% -3.18% 0.00% 0.00% -15.34% <-IRR #YR-> 10 Stock Price US$ -81.08%
P/E 11.64 10.63 7.63 2.91 3.32 9.28 7.37 -31.33 73.92 -344.14 -115.51 21.64 15.68 10.04 8.66 0.02% <-IRR #YR-> 5 Stock Price US$ 0.09%
Trailing P/E 10.66 16.08 7.38 1.85 5.23 3.12 6.18 11.61 -32.80 61.20 -297.14 -98.04 20.95 15.68 10.04 -13.30% <-IRR #YR-> 10 Price & Dividend US$
Median 10, 5 Yrs D.per yr 2.04% 3.29% % Tot Ret 61.56% 99.45% Price Inc -13.66% P/E: 5.35 -31.33 3.31% <-IRR #YR-> 5 Price & Dividend US$
-$58.14 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $11.00
-$10.99 $0.00 $0.00 $0.00 $0.00 $11.00
-$58.14 $2.54 $1.99 $0.06 $0.28 $0.34 $0.42 $0.43 $0.41 $0.38 $11.15
-$10.99 $0.42 $0.43 $0.41 $0.38 $11.15
US$ H/L Med $42.08 $50.69 $50.85 $19.43 $14.23 $19.39 $15.10 $13.39 $17.31 $16.54 $15.47 $9.51 $11.29 -81.24% <-Total Growth 10 Stock Price US$
Increase 6.88% 20.45% 0.33% -61.79% -26.76% 36.26% -22.12% -11.32% 29.28% -4.45% -6.47% -38.53% 18.66% -15.41% <-IRR #YR-> 10 Stock Price US$ -81.24%
P/E 11.64 9.27 9.61 5.78 2.69 10.90 10.12 -24.22 70.57 -379.22 -137.88 18.71 16.61 -8.83% <-IRR #YR-> 5 Stock Price US$ -37.02%
Trailing P/E 10.66 14.02 9.30 3.67 4.23 3.66 8.49 8.98 -31.31 67.43 -354.69 -84.76 22.20 -13.06% <-IRR #YR-> 10 Price & Dividend US$
P/E on Running 5 yr Average 14.16 13.94 11.93 4.48 3.09 4.57 4.38 5.89 10.48 28.32 75.23 1059.20 44.18 -6.03% <-IRR #YR-> 5 Price & Dividend US$
P/E on Running 10 yr Average 16.04 18.56 16.21 5.84 3.88 5.38 4.27 4.10 5.78 6.37 6.96 5.51 8.92 10.05 P/E Ratio Historical Median
Median 10, 5 Yrs D.per yr 2.35% 2.80% % Tot Ret -18.00% -46.44% Price Inc -6.47% P/E: 7.69 -24.22
-$50.69 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $9.51
-$15.10 $0.00 $0.00 $0.00 $0.00 $9.51
-$50.69 $2.54 $1.99 $0.06 $0.28 $0.34 $0.42 $0.43 $0.41 $0.38 $9.66
-$15.10 $0.42 $0.43 $0.41 $0.38 $9.66
High Month Jan-Mar Jul Feb Feb Sep May Feb Dec Feb Jan Jul Dec Feb
Pre-split 02
High US$ $47.00 $58.14 $61.84 $31.49 $25.39 $22.91 $21.65 $17.47 $18.93 $19.58 $17.98 $11.99 $11.89 -79.38% <-Total Growth 10 Stock Price US$
Increase 2.89% 23.70% 6.36% -49.08% -19.37% -9.77% -5.50% -19.31% 8.36% 3.43% -8.17% -33.31% -0.83% -14.60% <-IRR #YR-> 10 Stock Price US$ -79.38%
P/E 13.00 10.63 11.68 9.37 4.80 12.87 14.52 -31.60 77.18 -448.92 -160.25 23.59 17.50 -11.15% <-IRR #YR-> 5 Stock Price US$ -44.62%
Trailing P/E 11.91 16.08 11.31 5.95 7.55 4.33 12.17 11.71 -34.24 79.83 -412.24 -106.86 23.39 12.87 P/E Ratio Historical Median
Median 10, 5 Yrs Price Inc -8.17% P/E: 10.52 -31.60 23.54 P/E Ratio Historical High
-$58.14 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $11.99
-$21.65 $0.00 $0.00 $0.00 $0.00 $11.99
Low Month Oct-Dec Nov Nov Jan Jun Sep Jul Jul Oct Dec Jun Apr
Pre-split 02
Low US$ $37.16 $43.23 $39.86 $7.37 $3.07 $15.87 $8.55 $9.31 $15.69 $13.50 $12.96 $7.03 $10.68 -83.74% <-Total Growth 10 Stock Price US$
Increase 12.40% 16.33% -7.80% -81.51% -58.34% 416.94% -46.12% 8.89% 68.53% -13.96% -4.00% -45.76% 51.92% -16.61% <-IRR #YR-> 10 Stock Price US$ -83.74%
P/E 10.28 7.91 7.53 2.19 0.58 8.92 5.73 -16.84 63.97 -309.52 -115.51 13.83 15.72 -3.84% <-IRR #YR-> 5 Stock Price US$ -17.78%
Trailing P/E 9.42 11.95 7.29 1.39 0.91 3.00 4.80 6.24 -28.38 55.04 -297.14 -62.66 21.01 8.38 P/E Ratio Historical Median
Median 10, 5 Yrs Price Inc -4.00% P/E: 3.96 -16.84 -95.77 P/E Ratio Historical Low
-$43.23 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $7.03
-$8.55 $0.00 $0.00 $0.00 $0.00 $7.03
Long Term Debt £418,242 £423,178 Cus Accts Debt
Change 1.18% Change
Debt/Market Cap Ratio 11.28 10.69 10.98 <-Median-> 2 Debt/Market Cap Ratio
Goodwill & Intangibles £7,915 £7,685 £8,180 £8,222 £7,726 Intangibles Goodwill
Change -2.91% 6.44% 0.51% -6.03% Change
% of Market Cap 0.25 0.18 0.20 0.22 0.20 0.20 <-Median-> 5 Intangible/Market Cap Ratio
Market Cap CDN$ $79,595 $110,687 $65,818 $25,118 $52,553 $50,040 $34,087 $52,742 $77,677 $71,820 $75,397 $62,635 $60,506 $60,506 $60,506 -43.41% <-Total Growth 10 Market Cap CDN $
Market Cap US$ $68,270 $94,986 $66,611 $20,511 $50,213 $50,312 $33,517 $53,012 $73,032 $61,909 $54,448 $46,648 $45,164 $45,164 $45,164 -50.89% <-Total Growth 10 Market Cap US$
Market Cap UK£ £39,719 £47,706 £33,264 £12,843 £31,497 £31,874 £21,476 £32,126 £43,682 £40,173 £37,089 £39,600 £36,301 £36,301 £36,301 -16.99% <-Total Growth 10 Market Cap UK£
ADRs Ave Diluted 1,622 1,627 1,647 1,894 2,871 3,113 3,132 3,154 3,667 4,156 4,264 4,261 ADRs Ave Diluted US
Diluted # of Shares in Million 6,486 6,507 6,587 7,577 11,484 12,452 12,526 12,614 14,668 16,625 17,054 17,044 # of Sh in M UK
Increase -0.3% 0.3% 1.2% 15.0% 51.6% 8.4% 0.6% 0.7% 16.3% 13.3% 2.6% -0.1% Increase UK
ADRs Ave basic 1,584 1,589 1,603 1,847 2,723 2,930 2,997 3,056 3,577 4,082 4,172 4,215 ADRs Ave basic US
Basic # of Shares in Millions 6,337 6,357 6,410 7,389 10,890 11,719 11,988 12,225 14,308 16,329 16,687 16,860 # of Sh in M UK
Change -0.69% 0.32% 0.83% 15.27% 47.38% 7.61% 2.30% 1.98% 17.04% 14.12% 2.19% 1.04% Increase UK
Difference 2.4% 2.8% 3.0% 13.3% 4.8% 4.0% 1.8% 0.1% 12.6% 1.0% 0.7% 0.6% Difference UK
ADRs 1,622 1,634 1,650 2,093 2,853 3,046 3,050 3,061 4,028 4,125 4,201 4,241 4,241 4,241 4,241 Called up Share Capital Shares US$ 159.57%
# of Share in Millions 6,490 6,535 6,600 8,372 11,412 12,182 12,199 12,243 16,113 16,498 16,805 16,963 16,963 16,963 16,963 10.01% <-IRR #YR-> 10 Shares UK£ 159.57%
Change 0.55% 0.70% 0.99% 26.85% 36.31% 6.75% 0.14% 0.36% 31.61% 2.39% 1.86% 0.94% 0.00% 0.00% 0.00% 6.82% <-IRR #YR-> 5 Shares UK£ 39.05%
CF fr Op $MUK£ -£10,498 £10,047 -£10,747 £33,716 £41,844 £18,688 £29,079 -£13,716 -£25,174 -£10,441 £16,128 £11,286 £6,904 £7,990 £6,531 12.33% <-Total Growth 10 Cash Flow UK£
Increase -272.41% 195.70% -206.97% 413.72% 24.11% -55.34% 55.60% -147.17% -83.54% 58.52% 254.47% -30.02% -38.83% 15.72% -18.26% SO, Share Iss Conv. Of Notes Rights, Warrents Scrip Div Prog.
5 year Running Average £769 £2,019 -£1,480 £5,721 £12,872 £18,710 £22,516 £21,922 £10,144 -£313 -£825 -£4,383 -£259 £6,373 £9,768 -317.11% <-Total Growth 10 CF 5 Yr Running UK£
CFPS -£1.62 £1.54 -£1.63 £4.03 £3.67 £1.53 £2.38 -£1.12 -£1.56 -£0.63 £0.96 £0.67 £0.41 £0.47 £0.39 -56.72% <-Total Growth 10 Cash Flow per Share UK£
Increase -271.47% 195.04% -205.91% 347.32% -8.95% -58.16% 55.39% -147.00% -39.46% 59.49% 251.65% -30.67% -38.83% 15.72% -18.26% 1.17% <-IRR #YR-> 10 Cash Flow UK£ 12.33%
5 year Running Average £0.11 £0.31 -£0.22 £0.65 £1.20 £1.83 £2.00 £2.10 £0.98 £0.12 £0.01 -£0.34 -£0.03 £0.37 £0.58 -17.25% <-IRR #YR-> 5 Cash Flow UK£ -61.19%
P/CF on Med Price -3.51 4.28 -3.88 0.79 0.59 2.08 1.00 -1.86 -1.84 -3.99 2.34 2.75 5.58 -8.03% <-IRR #YR-> 10 Cash Flow per Share UK£ -56.72%
P/CF on Closing Price -3.78 4.75 -3.10 0.38 0.75 1.71 0.74 -2.34 -1.74 -3.85 2.30 3.51 5.26 4.54 5.56 -22.53% <-IRR #YR-> 5 Cash Flow per Share UK£ -72.09%
660.38% Diff M/C #NUM! <-IRR #YR-> 10 CFPS 5 yr Running UK£ -210.31%
Excl.Working Capital CF £0 -£1,163 £17,536 -£24,510 -£24,799 -£13,108 -£16,693 £24,984 £33,065 £16,765 -£6,928 -£22,499 £0 £0 £0 #NUM! <-IRR #YR-> 5 CFPS 5 yr Running UK£ -116.93%
CF fr Op $M WC -£10,498 £8,884 £6,789 £9,206 £17,045 £5,580 £12,386 £11,268 £7,891 £6,324 £9,200 -£11,213 £6,904 £7,990 £6,531 -226.22% <-Total Growth 10 Cash Flow less WC UK£
Increase -272.41% 184.63% -23.58% 35.60% 85.15% -67.26% 121.97% -9.03% -29.97% -19.86% 45.48% -221.88% 161.57% 15.72% -18.26% #NUM! <-IRR #YR-> 10 Cash Flow less WC UK£ -226.22%
5 year Running Average £769 £1,786 £1,795 £4,094 £6,285 £9,501 £10,201 £11,097 £10,834 £8,690 £9,414 £4,694 £3,821 £3,841 £3,882 #NUM! <-IRR #YR-> 5 Cash Flow less WC UK£ -190.53%
CFPS Excl. WC -£1.62 £1.36 £1.03 £1.10 £1.49 £0.46 £1.02 £0.92 £0.49 £0.38 £0.55 -£0.66 £0.41 £0.47 £0.39 10.14% <-IRR #YR-> 10 CF less WC 5 Yr Run UK£ 162.76%
Increase -271.47% 184.04% -24.33% 6.90% 35.83% -69.33% 121.66% -9.35% -46.79% -21.73% 42.82% -220.75% 161.57% 15.72% -18.26% -14.38% <-IRR #YR-> 5 CF less WC 5 Yr Run UK£ -53.99%
5 year Running Average £0.11 £0.27 £0.27 £0.56 £0.67 £1.09 £1.02 £1.00 £0.88 £0.65 £0.67 £0.34 £0.23 £0.23 £0.23 #NUM! <-IRR #YR-> 10 CFPS - Less WC UK£ -148.62%
P/CF on Med Price -3.51 4.84 6.15 2.89 1.46 6.97 2.34 2.27 5.88 6.58 4.11 -2.77 5.58 0.00 0.00 #NUM! <-IRR #YR-> 5 CFPS - Less WC UK£ -165.10%
P/CF on Closing Price -3.78 5.37 4.90 1.40 1.85 5.71 1.73 2.85 5.54 6.35 4.03 -3.53 5.26 4.54 5.56 2.18% <-IRR #YR-> 10 5 yr Running UK£ 24.02%
CF/-WC P/CF Med 10 yr 0.69 5 yr -1.84 P/CF Med 10 yr 3.50 5 yr 4.11 50.18% Diff M/C -19.90% <-IRR #YR-> 5 5 yr Running UK£ -67.03%
CF fr Op $M -$18,044 $19,678 -$21,325 $49,289 $67,876 $29,171 $45,179 -$22,301 -$41,721 -$16,264 $23,810 $13,922 $8,560 $9,905 $8,097 -29.25% <-Total Growth 10 Cash Flow US$
Increase -253.81% 209.06% -208.37% 331.13% 37.71% -57.02% 54.88% -149.36% -87.08% 61.02% 246.40% -41.53% -38.52% 15.72% -18.26% SO, Share Iss Conv. Of Notes US$
5 year Running Average $1,200 $4,031 -$2,407 $8,266 $19,495 $28,938 $34,038 $33,843 $15,641 -$1,187 -$2,259 -$8,511 -$2,339 $7,987 $12,859 -311.14% <-Total Growth 10 CF 5 Yr Running US$
CFPSUS$ -$11.12 $12.04 -$12.92 $23.55 $23.79 $9.58 $14.81 -$7.29 -$10.36 -$3.94 $5.67 $3.28 $2.02 $2.34 $1.91 -72.74% <-Total Growth 10 Cash Flow per Share US$
Increase -252.97% 208.30% -207.30% 282.21% 1.03% -59.74% 54.66% -149.18% -42.15% 61.93% 243.73% -42.07% -38.52% 15.72% -18.26% -3.40% <-IRR #YR-> 10 Cash Flow US$ -29.25%
5 year Running Average $0.71 $2.45 -$1.44 $3.76 $7.07 $11.21 $11.76 $12.89 $6.11 $0.56 -$0.22 -$2.53 -$0.67 $1.87 $3.04 -20.98% <-IRR #YR-> 5 Cash Flow US$ -69.18%
P/CF on Med Price -3.78 4.21 -3.93 0.83 0.60 2.02 1.02 -1.84 -1.67 -4.19 2.73 2.90 5.59 0.00 0.00 -12.19% <-IRR #YR-> 10 Cash Flow per Share US$ -72.74%
P/CF on Closing Price -3.78 4.83 -3.12 0.42 0.74 1.72 0.74 -2.38 -1.75 -3.81 2.29 3.35 5.28 4.56 5.58 -26.02% <-IRR #YR-> 5 Cash Flow per Share US$ -77.84%
641.50% Diff M/C #NUM! <-IRR #YR-> 10 CFPS 5 yr Running US$ -203.00%
Excl.Working Capital CF $0 -$2,278 $34,797 -$35,831 -$40,227 -$20,461 -$25,935 $40,622 $54,799 $26,115 -$10,228 -$27,755 $0.00 $0.00 $0.00 #NUM! <-IRR #YR-> 5 CFPS 5 yr Running US$ -121.49%
CF fr Op $M WC -$18,044 $17,400 $13,471 $13,458 $27,649 $8,710 $19,243 $18,321 $13,078 $9,851 $13,582 -$13,832 $8,560 $9,905 $8,097 -179.50% <-Total Growth 10 Cash Flow less WC US$
Increase -253.81% 196.43% -22.58% -0.10% 105.44% -68.50% 120.94% -4.79% -28.62% -24.67% 37.88% -201.84% 161.88% 15.72% -18.26% #NUM! <-IRR #YR-> 10 Cash Flow less WC US$ -179.50%
5 year Running Average $1,200 $3,575 $4,097 $7,603 $10,787 $16,138 $16,506 $17,476 $17,400 $13,841 $14,815 $8,200 $6,248 $5,613 $5,262 #NUM! <-IRR #YR-> 5 Cash Flow less WC US$ -171.88%
CFPS Excl. WC -$11.12 $10.65 $8.16 $6.43 $9.69 $2.86 $6.31 $5.99 $3.25 $2.39 $3.23 -$3.26 $2.02 $2.34 $1.91 8.66% <-IRR #YR-> 10 CF less WC 5 Yr Run US$ 129.36%
Increase -252.97% 195.76% -23.34% -21.24% 50.72% -70.49% 120.63% -5.14% -45.76% -26.43% 35.36% -200.89% 161.88% 15.72% -18.26% -13.06% <-IRR #YR-> 5 CF less WC 5 Yr Run US$ -50.32%
5 year Running Average $0.71 $2.17 $2.50 $4.28 $4.76 $7.56 $6.69 $6.26 $5.62 $4.16 $4.23 $2.32 $1.52 $1.34 $1.25 #NUM! <-IRR #YR-> 10 CFPS - Less WC US$ -130.63%
P/CF on Med Price -3.78 4.76 6.23 3.02 1.47 6.78 2.39 2.24 5.33 6.93 4.79 -2.92 5.59 0.00 0.00 #NUM! <-IRR #YR-> 5 CFPS - Less WC US$ -151.69%
P/CF on Closing Price -3.78 5.46 4.94 1.52 1.82 5.78 1.74 2.89 5.58 6.28 4.01 -3.37 5.28 4.56 5.58 0.64% <-IRR #YR-> 10 CFPS 5 yr Running US$ 6.61%
*Operational Cash Flow per share CF/-WC P/CF Med 10 yr 0.71 5 yr -1.67 P/CF Med 10 yr 3.90 5 yr 4.79 35.18% Diff M/C -19.10% <-IRR #YR-> 5 CFPS 5 yr Running US$ -65.35%
NYSE:BCS is in pounds
-6,535.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 16,963.0 Shares
-12,199.0 0.0 0.0 0.0 0.0 16,963.0 Shares
-£10,047 £0 £0 £0 £0 £0 £0 £0 £0 £0 £11,286 Cash Flow UK£
-£29,079 £0 £0 £0 £0 £11,286 Cash Flow UK£
-£1.54 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.67 Cash Flow per Share UK£
-£2.38 £0.00 £0.00 £0.00 £0.00 £0.67 Cash Flow per Share UK£
-£0.31 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 -£0.34 CFPS 5 yr Running UK£
-£2.00 £0.00 £0.00 £0.00 £0.00 -£0.34 CFPS 5 yr Running UK£
-£8,884 £0 £0 £0 £0 £0 £0 £0 £0 £0 -£11,213 Cash Flow less WC UK£
-£12,386 £0 £0 £0 £0 -£11,213 Cash Flow less WC UK£
-£1,786 £0 £0 £0 £0 £0 £0 £0 £0 £0 £4,694 CF less WC 5 Yr Run UK£
-£10,201 £0 £0 £0 £0 £4,694 CF less WC 5 Yr Run UK£
-£1.36 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 -£0.66 CFPS - Less WC UK£
-£1.02 £0.00 £0.00 £0.00 £0.00 -£0.66 CFPS - Less WC UK£
OPM 21.4% 23.4% 21.7% 22.6% 34.3% 11.1% 9.1% -4.1% 1.9% -0.7% -1.5% 7.6% -67.71% <-Total Growth 10 OPM UK£
Increase -8.83% 9.68% -7.44% 4.39% 51.70% -67.78% -17.75% -145.22% -146.12% -135.57% 124.53% -599.03% Should increase or be stable. UK£
Diff from Ave 156.3% 181.1% 160.2% 171.6% 312.1% 32.8% 9.2% -149.4% -77.2% -108.1% -118.2% -9.2% 0.00 <-Median-> 10 OPM UK£
*Operational Profit Margin (Earnings/Revenue) Ratio for banks OPM 10 Yrs 8.33% 5 Yrs -0.68% should be zero, it is a check on calculations UK£
Assets £924,357 £996,787 £1,227,631 £2,052,980 £1,378,929 £1,489,645 £1,563,527 £1,490,321 £1,312,267 £1,357,906 £1,120,012 £1,213,126 Net ratio of 1.5 and up Assets UK£
Liabilities £906,931 £969,397 £1,194,885 £2,005,569 £1,320,451 £1,427,383 £1,427,383 £1,427,364 £1,248,318 £1,291,948 £1,054,148 £1,141,761 1.05 <-Median-> 10 Liabilities UK£
Debt Ratio 1.02 1.03 1.03 1.02 1.04 1.04 1.10 1.04 1.05 1.05 1.06 1.06 1.05 <-Median-> 5 Ratio UK£
Above is net of non-controlling interest.
Total Book Value £17,426 £27,390 £32,746 £47,411 £58,478 £62,262 £136,144 £62,957 £63,949 £65,958 £65,864 £71,365 Total Book Value UK£
Non-Controlling £11,201 £11,404 £9,607 £9,371 £8,564 £6,391 £6,054 £6,492 Non-Controlling UK£
Other Equity £2,063 £4,322 £5,305 £6,449 Other Equity UK£
Book Value US$ $18.46 $23.74 $28.01 $25.58 $26.88 $26.07 $28.32 $28.47 $21.94 $20.86 $19.15 $17.00 $17.00 $17.00 $17.00 -28.40% <-Total Growth 10 Book Value US$
Book Value £17,426 £19,799 £23,291 £36,618 £47,277 £50,858 £55,589 £53,586 £53,322 £55,245 £54,505 £58,424 £58,424 £58,424 £58,424 195.09% <-Total Growth 10 Book Value UK£
Book Value per Share £2.69 £3.03 £3.53 £4.37 £4.14 £4.17 £4.56 £4.38 £3.31 £3.35 £3.24 £3.44 £3.44 £3.44 £3.44 13.68% <-Total Growth 10 Book Value per Share UK£
Change -0.50% 12.83% 16.48% 23.94% -5.28% 0.77% 9.15% -3.95% -24.39% 1.19% -3.14% 6.19% 0.00% 0.00% 0.00% -12.54% P/B Ratio Current/10 Year Median UK£
P/B Ratio (Median) 2.11 2.17 1.79 0.73 0.52 0.76 0.52 0.48 0.87 0.75 0.69 0.53 1.74 P/B Ratio Historical Median UK£
P/B Ratio (Close) 2.28 2.41 1.43 0.35 0.67 0.63 0.39 0.60 0.82 0.73 0.68 0.68 0.62 0.62 0.62 1.29% <-IRR #YR-> 10 Book Value per Share UK£ 13.68%
Change 4.88% 5.71% -40.73% -75.44% 89.96% -5.93% -38.36% 55.18% 36.65% -11.24% -6.42% -0.39% -8.33% 0.00% 0.00% -5.44% <-IRR #YR-> 5 Book Value per Share UK£ -24.42%
Leverage (A/BK) 53.04 36.39 37.49 43.30 23.58 23.93 11.48 23.67 20.52 20.59 17.00 17.00 22.08 <-Median-> 10 A/BV UK£
Debt/Equity Ratio 52.04 35.39 36.49 42.30 22.58 22.93 10.48 22.67 19.52 19.59 16.00 16.00 21.08 <-Median-> 10 Debt/Eq Ratio UK£
Median P/BV 10 yr Med 0.71 5 yr Med 0.69 -12.54% Diff M/C
Book Value US$ $29,952 $38,778 $46,216 $53,532 $76,689 $79,385 $86,366 $87,127 $88,371 $86,055 $80,468 $72,072 $72,072 $72,072 $72,072 85.86% <-Total Growth 10 Book Value US$
Book Value per Share $18.46 $23.74 $28.01 $25.58 $26.88 $26.07 $28.32 $28.47 $21.94 $20.86 $19.15 $17.00 $17.00 $17.00 $17.00 -28.40% <-Total Growth 10 Book Value per Share US$
Change -11.23% 28.57% 18.01% -8.69% 5.10% -3.03% 8.64% 0.52% -22.93% -4.89% -8.20% -11.27% 0.00% 0.00% 0.00% -16.64% P/B Ratio Current/10 Year Median US$
P/B Ratio (Median) 2.28 2.14 1.82 0.76 0.53 0.74 0.53 0.47 0.79 0.79 0.81 0.56 1.71 P/B Ratio Historical Median US$
P/B Ratio (Close) 2.28 2.45 1.44 0.38 0.65 0.63 0.39 0.61 0.83 0.72 0.68 0.65 0.63 0.63 0.63 -3.29% <-IRR #YR-> 10 Book Value per Share US$ -28.40%
P/BV 10 yr Med 0.75 5 yr Med 0.79 -16.64% Diff M/C -9.71% <-IRR #YR-> 5 Book Value per Share US$ -39.99%
Comprehensive Income UK£ £5,586 £7,336 £10,744 £4,512 £4,907 -£511 -£3,294 £3,447 £237 £6,816 Comprehensive Income UK£
NCI £732 £1,123 £1,188 £1,537 £331 £596 £112 £691 £192 £1,583 NCI UK£
Other Equity £0 £0 £0 Other Equity UK£
Shareholders £4,854 £6,213 £9,556 £2,975 £4,576 -£1,107 -£3,406 £2,756 £45 £5,233 7.81% <-Total Growth 9 Shareholders UK£
Increase 28.00% 53.81% -68.87% 53.82% -124.19% -207.68% 180.92% -98.37% 11528.89% -98.4% <-Median-> 5 Comprehensive Income UK£
5 Yr Running Average £5,635 £4,443 £2,519 £1,159 £573 £704 0.84% <-IRR #YR-> 9 Comprehensive Income UK£ -15.77%
ROE 20.8% 17.0% 20.2% 5.8% 8.2% -2.1% -6.4% 5.0% 0.1% 9.0% 2.72% <-IRR #YR-> 5 Comprehensive Income UK£ 14.36%
5Yr Median 17.0% 8.2% 5.8% 5.0% 0.1% 0.1% #NUM! <-IRR #YR-> 9 5 Yr Running Average UK£ #DIV/0!
% Difference from NI -4.7% 17.5% -7.1% -16.5% 52.2% 6.3% -730.7% -1683.9% -111.4% 222.4% -34.03% <-IRR #YR-> 5 5 Yr Running Average UK£ -87.50%
Median Values Diff 5, 10 yr -5.9% -111.4% 0.1% <-Median-> 5 Return on Equity UK£
Asset Efficiency Ratio UK£ -1.14% 0.89% 0.55% 0.45% 1.24% 0.37% 0.79% 0.76% 0.60% 0.47% 0.82% -0.92% CFO / Total Assets UK£
5 year Median 1.11% 0.89% 0.55% 0.55% 0.55% 0.55% 0.55% 0.76% 0.76% 0.60% 0.76% 0.60% 0.6% <-Median-> 5 Return on Assets UK£
Return on Assets ROA UK£ 0.42% 0.52% 0.42% 0.26% 0.75% 0.24% 0.19% -0.07% 0.04% -0.01% -0.04% 0.13% Net Income/Assets Return on Assets UK£
5Yr Median 0.63% 0.56% 0.52% 0.42% 0.42% 0.42% 0.26% 0.24% 0.19% 0.04% -0.01% -0.01% 0.0% <-Median-> 5 Asset Efficiency Ratio UK£
Return on Equity ROE UK£ 22.04% 26.24% 21.88% 14.44% 21.76% 7.01% 5.41% -1.94% 1.01% -0.31% -0.72% 2.78% Net Inc/ Shareholders' equity Return on Equity UK£
5Yr Median 16.99% 18.76% 21.88% 21.88% 21.88% 21.76% 14.44% 7.01% 5.41% 1.01% -0.31% -0.31% -0.3% <-Median-> 5 Return on Equity UK£
Net Income £5,773 £6,192 £11,183 £4,549 £3,951 -£236 £1,297 £845 £623 £2,828 Net Income UK£
NCI £678 £905 £895 £985 £944 £805 £757 £769 £672 £748 NCI UK£
Other Equity £250 £345 £457 Other Equity UK£
Shareholders £3,841 £5,195 £5,095 £5,287 £10,288 £3,564 £3,007 -£1,041 £540 -£174 -£394 £1,623 £2,168 £3,373 £4,171 -68.76% <-Total Growth 10 Net Income UK£
Increase 17.53% 35.25% -1.92% 3.77% 94.59% -65.36% -15.63% -134.62% 151.87% -132.22% -126.44% 511.93% 33.58% 55.58% 23.66% EPS/CF Ratio should not be higher than 1.00 UK£
5 Yr Running Average £2,910 £3,456 £4,029 £4,537 £5,941 £5,886 £5,448 £4,221 £3,272 £1,179 £388 £111 £753 £1,319 £2,188 #NUM! <-IRR #YR-> 10 Net Income UK£ -68.76%
Operating Cash Flow -£10,498 £10,047 -£10,747 £33,716 £41,844 £18,688 £29,079 -£13,716 -£25,174 -£10,441 -£8,434 -£8,434 #NUM! <-IRR #YR-> 5 Net Income UK£ -46.03%
Investment Cash Flow -£5,181 -£1,154 £10,064 £8,755 -£825 -£5,627 -£5,627 -£7,099 -£22,645 £10,655 £10,655 £36,707 -29.11% <-IRR #YR-> 10 5 Yr Running Ave. UK£ -96.79%
Total Accruals £19,520 -£3,698 £5,778 -£37,184 -£30,731 -£9,497 -£20,445 £19,774 £48,359 -£388 -£2,615 -£26,650 -54.12% <-IRR #YR-> 5 5 Yr Running Ave. UK£ -97.97%
Total Assets £924,357 £996,787 £1,227,631 £2,052,980 £1,378,929 £1,489,645 £1,563,527 £1,490,321 £1,312,267 £1,357,906 £1,120,012 £1,213,126 Balance Sheet Assets UK£
Accruals Ratio 2.11% -0.37% 0.47% -1.81% -2.23% -0.64% -1.31% 1.33% 3.69% -0.03% -0.23% -2.20% -0.03% <-Median-> 5 Ratio UK£
EPS/CF Ratio -0.33 0.51 0.65 0.52 0.55 0.62 0.24 -0.09 0.08 -0.02 -0.03 -0.16 0.16 <-Median-> 10 EPS/CF Ratio UK£
Financial Cash Flow £1,083 £692 £3,358 £12,272 £671 £159 £159 -£2,842 £5,910 -£3,058 -£441 -£1,317 C F Statement Financial CF UK£
Total Accruals £18,437 -£4,390 £2,420 -£49,456 -£31,402 -£9,656 -£20,604 £22,616 £42,449 £2,670 -£2,174 -£25,333 Accruals UK£
Accruals Ratio 1.99% -0.44% 0.20% -2.41% -2.28% -0.65% -1.32% 1.52% 3.23% 0.20% -0.19% -2.09% 0.20% <-Median-> 5 Ratio UK£
Cash £131,400 £149,673 £121,907 £80,185 £78,479 £86,556 £144,110 Cash UK£
Cash Per Share £10.79 £12.27 £9.96 £4.98 £4.76 £5.15 £8.50 £5.15 <-Median-> 5 Cash per Share UK£
Percentage of Stock Price 412.25% 696.92% 379.47% 183.56% 195.35% 233.38% 363.91% 233.38% <-Median-> 5 % of Stock Price UK£
Notes:
April 9, 2017.Last estimates were for UK£ 2016, 2017 amd 2018 of £22125M, £23165M and £22607M for Revenue, £0.089, £0.188 and £0.221 for EPS, £0.52, £0.59 and £0.44 for CFPS, and £1567M, £3156M and £3669M for Net Income.
April 16, 2016.Last estunaes were for in UK£ 2015, 2016 and 2017 of25994M, 26749M and 27493MRevenue in UK£ , 0.17, 0.26 and .303EPS in UK£ , $0.73, $0.78 CFPS in UK£ for 2015 and 2016 and 3008M, 4478M and 5321M UK£ for Net Income.
April 21, 2015.Last estimes were for 2014, 2015 and 2016 in UK£ 28.474M, 29441M and 30127M, 0.237, 0.314 and 0.361 for EPS, 0.67, 0.72and 0.78 for CFPS and 4214M, 5512M and 6516M for Net Income.
April 5, 2014.Last estimates were for 2013, 2014 and 2015 all in UK£ 29192M, 9939M and 30968M for Revenue, 0.32, 0.39 and 0.49 for EPS and 0.93, 1.01 and 0.86 for CFPS.
March 30, 2013.Last estimates were for 2012 and 2013 of £27700M and £31500M (and £32526M) for Revenue £0.31 and £0.38 for EPS and $2.10 and $2.50 US$ for EPS and £0.83 and £0.89 (and £0.95 for CFPS)
A number of sites show that there is more outstanding shares than the annual report says.I get 12,246M shares and 3061M ADRs.Others get 3.2B ADRs.
Is the problems just in rounding the number of ADRs?It makes a difference in Capitalization.
Apr 15, 2012.Lastestimates I got were for 2011 and 2012 at $2.18 US and $2.86 US.
Apr 10, 2011.Last I looked at got earnings of $1.97 and $3.06 US for 2010 and 2011.
According to Reuters, diluted earnings of£.816 include extraordinary items and without these it would be £.227.However, they also have normalized earnings of £.140 and diluted of £.132. I cannot reconcile
earnings for ADRs (re US reports) and earnings from Barclays Reports.In the end I used Reuters diluted earnings excluding extraordinary items of £.227. Dividend for 2009 assumes 4 payments of dividends, not
just the one paid.This is to have a handle on the dividend rate.
2009 and 2010 Barclays issued warrents and Mandatorily Convertible Notes (MCNs) to rise money.Shares increased substantially in both years.
I bought this stock in 2000.In US$ terms, I have made a 4.9% per year return on this investment.Between 2000 and now I have lost some 4% per year due to currency exchange rates.Stock is worth less in
US$ than when I bought it.However, it is not that simple.40% of my return is due to dividend payments, which were made between 2000 and now when the exchange rate fluctuated, but basically was coming down.
Apr 24, 2010.When I last looked at this stock I got estimates for 2009 and 2010 for earnings in US$ of $1.38 and $1.95 and 2009 earnings in UK£ of £.705.
2008.†† Qatar Holding LLC and entities representing the beneficial interests of HH Sheikh Mansour Bin Zayed Al Nahyan who agreed on 31st October 2008 to invest substantial funds into Barclays.††
AP 2006. Accting info is much better now.I have made IRR since I bought 16% and 14% 5 years.S & P rate it a buy with low risk.
AR2005.Last year this stock lost IRR 4%, how since I bought it in Mar 2000 I have IRR of 15%, last 12 months IRR is 18%.Stock not doing badly for me.
AR 2005.I note that S & P has a sell rating on this stock, but looking at other anaylst one has sell and one strong buy????
It is always hard to get the accounting on this stock.Seems to be major changes in 2005 as accounting has changed from UK GAAP to International Reporting Standards and
International Accounting Standands (IFRS).I am getting statement amounts from the annual report 2005.I am also getting what I can from TD's S&P report.
There is a lot of differences in US$ and UK£ gains in stock price.However, I think that stock is doing fine.†† I checked US$ dividends with what I actually got.
For Charts, use UK:BARC; most sites quote in pence so 160.40 would be UK£1.6040.
Sector:
Bank, Financial Services
What should this stock accomplish?
Would I buy this company and Why.
What should this stock accomplish?
Dividends
Currently dividends are paid in Cycle 3, in March, June, September and December. Dividends are not even, with the first one of the year being much higher than the last 3 dividends.
When I first bought this stock, dividends were paid semi-annuallly with a larger one paid in April and a smaller one in October.
The third interim dividend for the year ending 31 December 2013 of 1p per ordinary share was paid on Friday, 13 December 2013 to shareholders holding shares on the register on Friday, 8 November 2013.
Dividend going back to semi-annual in April and September.
Why am I following this stock.
I am following this stock because I own it, having bought it in 2000.
Why I bought this stock.
I bought this stock when Barrett took over in 2000. Barrett used to run Bank of Montreal in Canada.†† At that time it was a good dividend paying stock and I thought it would give me some geographical diversifications.
How they make their money.
One of the largest financial services groups in the United Kingdom, Barclays is
engaged in banking, investment banking and asset management worldwide.
For most ratios, lower is better when looking for a good stock price.However, there are exceptions such as for yield and asset/liability ratios and here you want a higher ratios to indicate a good stock price.††
Also, for the Operational Profit Margin, a higher percentage is better.With the OPM, you should only compare companies in similar industries.
Non-cash Cash Flow 2006 2007 2008 2009 2010 2011
-£27,385 -£77,987 -£58,431 £25,482 -£63,212 £38,340
£46,944 £91,451 £77,743 -£49,203 £63,711 -£11,554
£1,196 -£2,144 -£17,529 £3,321 -£1,298 £3,730
-£18,333 -£18,245 £26,919 £34,334 -£17,505 £21,360
£310 -£6,472 -£5,928 -£8,222 £21,441 -£26,899
£1,538 -£4,379 £5,229 £20,459 £11,126 -£4,255
-£1,527 £1,296 -£3,016 -£465 £1,366 £119
-£1,580 -£1,056 -£477 -£907 -£2,521 -£4,148
£1,163 -£17,536 £24,510 £24,799 £13,108 £16,693
2,161.83 -39,969.97 42,269.88 38,832.75 18,014.39 26,782.24
£1,332.72 -£25,606.63 £27,206.86 £24,878.07 £11,105.46 £16,472.01
Got some esitmates from
http://www.4-traders.com/BARCLAYS-PLC-9583556/financials/
markets
http://markets.ft.com/Research/Markets/Tearsheets/Forecasts?s=BARC:LSE†††
Get stock quotes from Yahoo
http://ca.finance.yahoo.com/q?s=BARC.L
Shares; '%, Value $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M cannot find info
Date 2008 2009 Apr 15 2012 Mar 30 2013 Apr 05 2014 Apr 26 2015 Apr 16 2016 Apr 9 2017
Staley, James Edward since 2015
CEO - Shares - Amount
Options - percentage
Options - amount
Morzaria, Tushar since 2013
Group Finance Director - Shares - Amount
Options - percentage
Options - amount
Jenkins, Anthony 1.580 0.01% 4.162 0.02%
Director - Shares - Amount £4.147 £9.185 $0.000
Options - percentage 6.815 0.06% 5.948 0.04%
Options - amount £17.883 £13.128
Ashley, Michael 0.018 0.00% 0.000 0.00%
Director - Shares - Amount £0.039 £0.000
Options - percentage 0.000 0.00% 0.000 0.00%
Options - amount £0.000 £0.000
Jeffery, Reuben 0.176 0.00% 0.000 0.00%
Director - Shares - Amount £0.389 £0.000
Options - percentage 0.000 0.00% 0.000 0.00%
Options - amount £0.000 £0.000
McFarlane, John 0.000 0.00% 0.794 0.02% 0.000 0.00%
Chairman - Shares - Amount £0.000 $8.739 $0.000 $0.000
Options - percentage 0.000 0.00% 0.000 0.00%
Options - amount £0.000 £0.000
McFarlane, John 0.000 0.00% 3.178 0.02% 0.000 0.00%
Chairman - Shares - Amount £0.000 £7.419 £0.000 $0.000
Options - percentage 0.000 0.00% 0.000 0.00% 0.000 0.00%
Options - amount £0.000 £0.000 £0.000
Walker, David 0.139 0.00%
Chairman - Shares - Amount £0.306
Options - percentage 0.000 0.00%
Options - amount £0.000
Chris Lucas 0.913 0.01%
Group Fin. Director £2.395
Options - percentage 6.058 0.05%
Options - amount £15.895
Increase in O/S Shares 29.000 0.44% 5.000 0.06% 17.000 0.14% 44.000 0.36% 257.000 1.59% 320.000 1.94% 253.000 1.51% 116.000 0.68%
due to SO £146.160 £7.670 £29.929 £115.456 £696.727 £779.200 £558.371 £256.012
Book Value £110.000 £19.000 £41.000 £97.000 £790.000 £772.000 £640.000 £30.000
Insider Buying £0.068 £0.000 £0.000 £0.000
Insider Selling £18.597 £0.000 £0.000 £0.000
Net Insider Selling £18.665 £0.000 £0.000 £0.000
% of Market Cap 0.05% 0.00% 0.00% 0.00%
Increase in O/S Shares 80.000 1.94% 63.250 1.53% 29.000 0.70%
due to SO US$ $290.025 $11.213 $46.498 $187.723 $1,154.686 $1,213.760 $824.344 $377.960
Book Value US$ $218.273 $27.776 $63.700 $157.715 $1,309.267 $1,202.544 $944.856 $44.290
Insider Buying $0.106 $0.000 $0.000 $0.000
Insider Selling $28.968 $0.000 $0.000 $0.000
Net Insider Selling $29.074 $0.000 $0.000 $0.000
% of Market Cap 0.08% 0.00% 0.00% 0.00%
Directors 12 13 13 13 14
Women 2 17% 3 23% 3 23% 3 23% 4 29%
Minorities 1 8% 2 15% 2 15% 2 15% 2 14%
Institutions/Holdings 219 2.56% 234 114 2.85% 261 3.01% 267 2.46%
Total Shares Held 82.347 1.96% 234.000 5.67% 119.377 2.89% 127.270 3.00% 104.650 2.47%
Increase/Decrease -0.587 -0.72% 2.471 1.07% 15.839 15.30% -4.410 -3.35% -0.057 -0.05%
Starting No. of Shares 81.760 231.529 NASDAQ 103.538 NASDAQ 131.680 NASDAQ 104.708 NASDAQ
Institutions/Holdings UK 219 54.96% 521 65.94% 540 63.40% 471 60.99%
Total Shares Held 7069.365 42.85% 11042.568 65.71% 10715.972 63.17% 10384.802 61.22%
Increase/Decrease 102.812 1.43% 1517.718 12.08% 176.540 1.62% -251.517 -2.48%
Starting No. of Shares 7172.178 12560.286 Reuters 10892.512 Reuters 10133.285 Reuters BARC
Institutions/Holdings 273 2.47%
Total Shares Held 104.979 2.48%
Increase/Decrease 0.202 0.19%
Starting No. of Shares 105.181 Reuters BCS
Copyright © 2008 Website of SPBrunner. All rights reserved.
My Stock