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.
See my website on stocks or see my blog at the following sites.  www.spbrunner.com/stocks.html www.spbrunner.blogspot.com/
Barclays Bank PLC ADR BCS-N www.barclays.com Fiscal Yr: Dec-31 UK:BARC
Year 12/31/99 12/31/00 12/31/01 12/31/02 12/31/03 12/31/04 12/31/05 12/31/06 12/31/07 12/31/08 12/31/09 12/31/10 12/31/11 12/30/12
Accting Rules UK GAAP IFRS IFRS IFRS IFRS IFRS IFRS
**Note that each ADR represents 4 ordinary shares 4
Split 4
USD - CDN$ 1.4733 1.4995 1.5926 1.5796 1.2924 1.2048 1.1630 1.1652 0.9881 1.2240 1.0501 0.9970 0.9507 0.9507
  1.457 1.5926 1.5796 1.2924 1.2048 1.1630 1.1652 0.9881 1.2240 1.0501 0.9970 0.9507
9 Mar 2000  -1.457 0 0 0 0 0 0 0 0 0 0 0.9507 -3.81% <-IRR #YR-> 11 currency
  -1.1652 0 0 0 0 0.9507 -3.99% <-IRR #YR-> 5 currency
         
UK£ -US$  1.6131 1.4622 1.4542 1.6098 1.7785 1.9266 1.7188 1.9586 1.9843 1.4619 1.6221 1.5524 1.6350 1.6350
Revenue* £8,364 £9,598 £11,177 £11,379 £12,411 £13,945 £17,978 £22,170 £23,492 £23,352 £29,954 £32,204 235.53% <-Total Growth 10 Revenue UK£ 
Increase 12.8% 14.8% 16.5% 1.8% 9.1% 12.4% 28.9% 23.3% 6.0% -0.6% 28.3% 7.5% 12.87% <-IRR #YR-> 10 Revenue UK£ 
Rev per Share £1.40 £1.59 £1.68 £1.72 £1.89 £2.16 £2.77 £3.39 £3.56 £2.79 £2.62 £2.64 12.37% <-IRR #YR-> 5 Revenue UK£ 
P/S (Price/Sales) 3.11 3.29 3.11 2.18 2.62 2.71 2.21 2.15 1.42 0.55 1.05 0.99 5.25% <-IRR #YR-> 10 Rev Per Share UK£ 
Median P/S 10 yr  2.17 5 yr  1.05 -0.93% <-IRR #YR-> 5 Rev Per Share UK£ 
*Total Income from Income Statement (IFRS) 2005 and on (Operating Income (UK GAAP) before 2005)          
         
-£9,598 £0 £0 £0 £0 £0 £0 £0 £0 £0 £32,204
-£17,978 £0 £0 £0 £0 £32,204
-£2 £0 £0 £0 £0 £0 £0 £0 £0 £0 £3
-£3 £0 £0 £0 £0 £3
Revenue* $13,492 $14,034 $16,254 $18,318 $22,073 $26,866 $30,901 $43,422 $46,615 $34,138 $48,589 $49,993 207.58% <-Total Growth 9 Revenue UK£ 
Increase 8.9% 4.0% 15.8% 12.7% 20.5% 21.7% 15.0% 40.5% 7.4% -26.8% 42.3% 2.9% 13.55% <-IRR #YR-> 10 Revenue UK£ 
Rev per Share $9.01 $9.27 $9.78 $11.06 $13.45 $16.65 $19.05 $26.58 $28.25 $16.31 $17.03 $16.42 10.10% <-IRR #YR-> 5 Revenue UK£ 
P/S (Price/Sales) 3.19 3.47 3.44 2.23 2.70 2.74 2.21 2.19 1.43 0.60 1.03 1.01 5.88% <-IRR #YR-> 10 Rev Per Share UK£ 
Median P/S 10 yr  2.20 5 yr  1.03 -2.93% <-IRR #YR-> 5 Rev Per Share UK£ 
*Total Income in US$           
         
-$14,034 $0 $0 $0 $0 $0 $0 $0 $0 $0 $49,993
-$30,901 $0 $0 $0 $0 $49,993
-$9.27 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $16.42
-$19.05 $0.00 $0.00 $0.00 $0.00 $16.42
Diluted EPS
Presplit £1.18 £1.63 £1.48
EPS* UK£  £0.29 £0.41 £0.37 £0.33 £0.42 £0.51 £0.53 £0.70 £0.67 £0.58 £0.23 £0.29 $0.35 $0.43 -30.19% <-Total Growth 10 Earnings UK£ 
Increase 34.7% 39.0% -9.2% -9.9% 26.0% 21.6% 2.7% 32.7% -4.4% -13.8% -60.5% 25.6% 23.4% 22.6% -3.53% <-IRR #YR-> 10 Earnings UK£ 
* ESP per ordinary share in pence. -11.53% <-IRR #YR-> 5 Earnings UK£ 
-0.408 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.285
-0.526 0.000 0.000 0.000 0.000 0.285
EPS* US$ $1.90 $2.39 $2.16 $2.15 $2.99 $3.95 $3.62 $5.47 $5.29 $3.36 $1.47 $1.77 $2.30 $2.82 D -25.88% <-Total Growth 10 Earnings US$
Increase 30.1% 26.0% -9.7% -0.2% 39.3% 31.7% -8.3% 51.2% -3.2% -36.5% -56.2% 20.2% 30.0% 22.6% -2.95% <-IRR #YR-> 10 Earnings US$
* ESP per ADR -13.32% <-IRR #YR-> 5 Earnings US$
-2.388 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 1.770
-3.616 0.000 0.000 0.000 0.000 1.770
Presplit £0.500 £0.580 Dividends US$
Exch in UK£  £0.11 £0.15 £0.17 £0.18 £0.18 £0.20 £0.27 £0.26 £0.32 £0.45 £0.01 £0.04 £0.10 £0.10 Reconcilation Dividends UK£ 
Exch in US$ $0.81 $0.85 $0.97 $1.18 $1.46 $1.85 $1.72 $2.19 $2.54 $1.99 $0.06 $0.28 $0.65 $0.65 Reconcilation Dividends US$
Div* £0.13 £0.15 £0.17 £0.18 £0.21 £0.24 £0.25 £0.28 £0.32 £0.34 £0.01 £0.05 £0.10 £0.10 -68.97% <-Total Growth 10 Dividends UK£ 
Increase 16.3% 16.0% 14.7% 10.4% 11.7% 17.1% 4.0% 11.8% 14.7% 6.3% -97.1% 350.0% 122.2% 0.0% 11.77% <-Median-> 10 Dividends UK£ 
Yield H/L 3.43% 3.44% 3.39% 3.74% 4.85% 4.63% 4.40% 4.24% 5.06% 10.69% 0.46% 1.41% 4.32% <-Median-> 10 Dividends UK£ 
Yield on Cl 2.88% 2.78% 3.18% 4.90% 4.13% 4.09% 4.08% 3.82% 6.35% 22.16% 0.36% 1.72% 3.32% 3.32% 4.08% <-Median-> 10 Dividends UK£ 
Payout Ratio 42.55% 35.52% 44.87% 54.94% 48.69% 46.88% 47.43% 39.97% 47.98% 59.13% 4.41% 15.79% 28.43% 23.19% -11.04% <-IRR #YR-> 10 Dividends UK£ 
Payout Ratio CF 8.39% 10.35% 29.11% 18.02% -58.75% 25.44% -15.42% 18.15% -19.65% 8.44% 0.27% 2.93% -29.00% <-IRR #YR-> 5 Dividends UK£ 
Median 5 Yrs Div Yd $0.04 in 5 yrs 5.94% in 10 yrs Yield  4.24% 3.82% Payout 39.97% 2.93%
* Dividends Dividends paid, not dividends declared 6.0% 5 6.0% 10
-0.145 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.045
-0.250 0.000 0.000 0.000 0.000 0.045
             
I am earning             # yrs are----> 11 UK£  £4.18 2000 2.39%                                  
H/LYield held 5 yrs 8.04% 7.78% 5.30% 5.73% 6.59% 5.92% 5.69% 6.52% 8.05% 0.19% 0.79% Ave H/L Yield on your    UK£  Dividends                    
H/LYield held 10 yrs   13.84% 13.05% 9.25% 9.51% 0.27% 1.07% Ave H/L original money   UK£  Dividends                    
                                                             
Div US$ $0.73 $0.90 $0.98 $1.13 $1.30 $1.56 $1.85 $2.03 $2.57 $2.64 $0.07 $0.27 $0.65 $0.65 -69.58% <-Total Growth 10 Dividends US$
checking what $0.98 $456.14 $740.88 $1,027.26 $1,055.50 $26.19 $109.15
I got in Div $451.05 $740.00
Increase 4.3% 22.9% 8.7% 15.6% 14.9% 20.4% 18.6% 9.7% 26.5% 2.7% -97.5% 316.8% 136.4% 0.0% 15.29% <-Median-> 10 Dividends US$
Yield H/L 2.71% 3.27% 3.31% 3.75% 4.55% 3.96% 4.40% 4.01% 5.05% 13.58% 0.46% 1.41% 3.98% <-Median-> 10 Dividends US$
Yield on Cl 2.54% 2.79% 2.90% 4.57% 3.57% 3.42% 4.40% 3.49% 6.36% 26.93% 0.37% 1.65% 3.28% 3.28% -11.22% <-IRR #YR-> 10 Dividends US$
Payout Ratio E 38.51% 37.57% 45.24% 52.43% 43.27% 39.54% 51.16% 37.12% 48.51% 78.48% 4.45% 15.42% 28.05% 22.88% -31.80% <-IRR #YR-> 5 Dividends US$
Median 5 Yrs Div Yd 4.39% in 5 yrs 5.87% in 10 yrs Yield  4.01% 3.49% 7.72% Payout 34.98%
Dividends received in US$.  6.0% 5 6.0% 10
 
-0.897 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.273
-1.850 0.000 0.000 0.000 0.000 0.273
 
I am earning             # yrs are----> 11 US$ $24.29 2000 2.66%                                  
H/LYield held 5 yrs   5.49% 5.79% 6.73% 6.88% 8.53% 9.27% 0.17% 0.65% 1.27% 1.27% Ave H/L Yield on your    US$ Dividends                    
H/LYield held 10 yrs   11.46% 11.17% 0.24% 0.99% 2.19% 2.14% Ave H/L original money   US$ Dividends                    
                                                             
Div CDN $ $1.08 $1.35 $1.55 $1.78 $1.67 $1.88 $2.15 $2.37 $2.54 $3.23 $0.07 $0.27 $0.61 $0.61 -14.77% <-IRR #YR-> 10 Stock Price CDN$
Increase -0.4% 25.1% 15.4% 14.7% -6.0% 12.2% 14.5% 9.9% 7.3% 27.3% -97.9% 295.7% 125.5% 0.0% -33.87% <-IRR #YR-> 5 Stock Price CDN$
-$1.35 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.27
          -$2.15 $0.00 $0.00 $0.00 $0.00 $0.27
                     
Close Cdn$ $42.40 $48.27 $53.57 $39.02 $46.98 $55.04 $48.94 $67.74 $39.89 $12.00 $18.48 $16.47 $18.71 $18.71 -10.19% <-IRR #YR-> 10 Stock Price CDN$
Increase 22.2% 13.8% 11.0% -27.2% 20.4% 17.1% -11.1% 38.4% -41.1% -69.9% 54.1% -10.9% 13.6% 0.0% -19.57% <-IRR #YR-> 5 Stock Price CDN$
5 yr Period ending       12/31/02 12/31/03 12/31/04 12/31/05 12/31/06 12/31/07 12/31/08 12/31/09 12/31/10 12/31/11   -4.47% <-IRR #YR-> 10 Price & Div CDN$
5 year IRR       3.51% 9.99% 8.83% 3.15% 8.13% 5.77% -14.49% -14.00% -14.81%     -14.81% <-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          
  -$48.27 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $16.47           Stock Price CDN$
            -$48.94 $0.00 $0.00 $0.00 $0.00 $16.47           Stock Price CDN$
  -$48.27 $1.55 $1.78 $1.67 $1.88 $2.15 $2.37 $2.54 $3.23 $0.07 $16.74         Dates   Price & Div CDN$
            -$48.94 $2.37 $2.54 $3.23 $0.07 $16.74         12/31/11   Price & Div CDN$
          -$55.04 $2.15 $2.37 $2.54 $3.23 $18.55         Cut & 12/31/10   Price & Div CDN$
        -$46.98 $1.88 $2.15 $2.37 $2.54 $15.23           Paste 12/31/09   Price & Div CDN$
      -$39.02 $1.67 $1.88 $2.15 $2.37 $42.43             These  12/31/08   Price & Div CDN$
    -$53.57 $1.78 $1.67 $1.88 $2.15 $70.11               Dates 12/31/07   Price & Div CDN$
  -$48.27 $1.55 $1.78 $1.67 $1.88 $48.94                   12/31/06   Price & Div CDN$
-$42.40 $1.35 $1.55 $1.78 $1.67 $56.91                     12/31/05   Price & Div CDN$
$1.08 $1.35 $1.55 $1.78 $48.65                       12/31/04   Price & Div CDN$
$1.08 $1.35 $1.55 $40.80                         12/31/03   Price & Div CDN$
Graham Price US$ $19.74 $26.16 $24.80 $25.25 $34.69 $42.97 $38.76 $54.04 $57.76 $43.99 $29.85 $32.13 $36.63 $40.56   Cl Pr higher/lower by? Graham Price US$
Prem /Disc. High 23.0% 37.6% 45.3% 4.8% 6.3% 21.3% 7.6% 7.1% -28.4% -14.9% -28.7%   6.69% <-Median-> 10 Graham Price US$
Prem /Disc. Low -13.0% 0.3% -6.9% -40.6% -23.1% -4.1% -20.0% -31.0% -83.2% -89.7% -50.6%   -27.03% <-Median-> 10 Graham Price US$
Prem/Disc CL 45.8% 23.0% 35.6% -2.2% 4.8% 6.3% 8.6% 7.6% -30.1% -77.7% -41.0% -48.6% -46.3% -51.5%   1.30% <-Median-> 10 Graham Price US$
Pre-split 02 $115.12 $128.75 $134.55
US$ CL $28.78 $32.19 $33.64 $24.70 $36.35 $45.68 $42.08 $58.14 $40.37 $9.80 $17.60 $16.52 $19.68 $19.68 -48.68% <-Total Growth 10 Stock Price US$
Increase 27.9% 11.8% 4.5% -26.6% 47.2% 25.7% -7.9% 38.2% -30.6% -75.7% 79.6% -6.1% 19.1% 0.0% -6.45% <-IRR #YR-> 10 Stock Price US$
Exch Rt CL $28.04 $30.53 $30.44 $24.11 $35.30 $45.20 $42.08 $57.19 $40.00 $8.97 $17.91 $16.25 $19.73 $19.73 -17.06% <-IRR #YR-> 5 Stock Price US$
P/E 15.2 13.5 15.6 11.5 12.1 11.6 11.6 10.6 7.6 2.9 11.9 9.3 8.6 7.0 -0.52% <-IRR #YR-> 10 Price & Div US$
Trailing P/E 19.8 17.0 14.1 11.5 16.9 15.3 10.7 16.1 7.4 1.9 5.2 11.2 11.1 8.6 -12.32% <-IRR #YR-> 5 Price & Div US$
Median 5 Yrs 4.74% 5.94% Div % Gth 5, 10 yrs Price Inc -6.14% P/E: Y-T 9.33 7.38
-$32.19 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $16.52
-$42.08 $0.00 $0.00 $0.00 $0.00 $16.52
-$32.19 $0.98 $1.13 $1.30 $1.56 $1.85 $2.03 $2.57 $2.64 $0.07 $16.79
-$42.08 $2.03 $2.57 $2.64 $0.07 $16.79
Graham Price UK£  £3.06 £4.47 £4.26 £3.92 £4.88 £5.58 £5.64 £6.90 £7.28 £7.52 £4.60 £5.17 £5.75 £6.36   Cl Pr higher/lower by? Graham Price UK£ 
Prem /Disc. High 63.0% 10.5% 34.9% 56.9% 5.8% 6.4% 9.1% 5.8% 8.6% -32.4% -16.6% -25.9%       6.14% <-Median-> 10 Graham Price UK£ 
Prem /Disc. Low -25.0% -22.1% -5.1% -6.6% -32.5% -20.5% -7.8% -15.0% -34.8% -83.0% -88.9% -50.6%       -26.49% <-Median-> 10 Graham Price UK£ 
Prem/Disc CL 42.0% 16.7% 22.7% -4.5% 1.8% 5.2% 8.6% 5.8% -30.7% -79.6% -40.0% -49.4% -47.5% -52.6%   -1.37% <-Median-> 10 Graham Price UK£ 
UK£ CL £4.35 £5.22 £5.23 £3.75 £4.96 £5.87 £6.12 £7.30 £5.04 £1.53 £2.76 £2.62 £3.02 £3.02 -49.88% <-Total Growth 10 Stock Price UK£ 
Increase 33.4% 20.1% 0.2% -28.4% 32.5% 18.2% 4.4% 19.3% -31.0% -69.6% 79.9% -5.2% 15.3% 0.0% -6.67% <-IRR #YR-> 10 Stock Price UK£ 
P/E 14.8 12.8 14.1 11.2 11.8 11.5 11.6 10.5 7.6 2.7 12.2 9.2 8.6 7.0 -15.63% <-IRR #YR-> 5 Stock Price UK£ 
Trailing P/E 19.9 17.8 12.8 10.1 14.9 13.9 12.0 13.9 7.2 2.3 4.8 11.5 10.6 8.6 -1.43% <-IRR #YR-> 10 Price & Div UK£ 
Median 5 Yrs 5.24% 34.25% Div % Gth 5, 10 yrs Price Inc -5.20% P/E: Y-T 9.18 7.22 -11.46% <-IRR #YR-> 5 Price & Div UK£ 
-£5.22 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £2.62
-£6.12 £0.00 £0.00 £0.00 £0.00 £2.62
-£5.22 £0.17 £0.18 £0.21 £0.24 £0.25 £0.28 £0.32 £0.34 £0.01 £2.66
-£6.12 £0.28 £0.32 £0.34 £0.01 £2.66
US$ H/L Ave $26.94 $27.48 $29.50 $30.09 $28.48 $39.37 $42.08 $50.69 $50.85 $19.43 $14.23 $19.39 -29.43% <-Total Growth 10 Stock Price US$
Increase 14.0% 2.0% 7.4% 2.0% -5.4% 38.3% 6.9% 20.4% 0.3% -61.8% -26.8% 36.3% -3.43% <-IRR #YR-> 10 Stock Price US$
P/E 14.2 11.5 13.7 14.0 9.5 10.0 11.6 9.3 9.6 5.8 9.7 11.0 -14.36% <-IRR #YR-> 5 Stock Price US$
Trailing P/E 18.5 14.5 12.4 14.0 13.2 13.1 10.7 14.0 9.3 3.7 4.2 13.2 2.64% <-IRR #YR-> 10 Price & Div US$
Median 5 Yrs 4.53% 6.06% Div % Gth 5, 10 yrs Price Inc 0.33% P/E: Y-T 9.61 9.30 -9.82% <-IRR #YR-> 5 Price & Div US$
-$27.48 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $19.39
-$42.08 $0.00 $0.00 $0.00 $0.00 $19.39
-$27.48 $0.98 $1.13 $1.30 $1.56 $1.85 $2.03 $2.57 $2.64 $0.07 $19.66
-$42.08 $2.03 $2.57 $2.64 $0.07 $19.66
UK£ H/L Ave £3.64 £4.21 £4.90 £4.91 £4.23 £5.18 £5.68 £6.58 £6.32 £3.18 £2.17 £3.19 -24.21% <-Total Growth 10 Stock Price UK£ 
Increase 1.8% 15.7% 16.3% 0.2% -13.9% 22.7% 9.5% 15.9% -3.9% -49.7% -31.6% 46.8% -2.73% <-IRR #YR-> 10 Price & Div UK£ 
P/E 143.6 151.1 169.0 107.5 118.5 151.8 129.1 188.5 99.4 11.8 584.6 193.3 -10.87% <-IRR #YR-> 5 Price & Div UK£ 
Trailing P/E 16.7 14.3 12.0 13.2 12.6 12.3 11.1 12.5 9.1 4.8 3.8 14.1 -3.00% <-IRR #YR-> 10 Price & Div US$
Median 5 Yrs Price Inc -3.91% P/E: Y-T 188.45 9.06 -12.58% <-IRR #YR-> 5 Price & Div US$
-£4.21 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £3.19
-£5.68 £0.00 £0.00 £0.00 £0.00 £3.19
-£4.21 £0.00 £0.04 £0.10 £0.09 £0.03 £0.08 £0.06 -£0.14 -£0.14 £3.04
-£5.68 £0.08 £0.06 -£0.14 -£0.14 £3.04
Hi Month  Jun Dec Feb May Oct Dec Jan-Mar Jul Feb Feb Sep May
Pre-split 02 $129.50 $128.75 $136.50
US$ $32.38 $32.19 $34.13 $36.68 $36.35 $45.68 $47.00 $58.14 $61.84 $31.49 $25.39 $22.91 -32.86% <-Total Growth 9 Stock Price US$
Increase 0.4% -0.6% 6.0% 7.5% -0.9% 25.7% 2.9% 23.7% 6.4% -49.1% -19.4% -9.8% -3.34% <-IRR #YR-> 10 Stock Price US$
P/E 17.1 13.5 15.8 17.1 12.1 11.6 13.0 10.6 11.7 9.4 17.2 12.9 -13.39% <-IRR #YR-> 5 Stock Price US$
Trailing P/E 22.2 17.0 14.3 17.0 16.9 15.3 11.9 16.1 11.3 5.9 7.6 15.6
Median 5 Yrs Price Inc -9.77% P/E: Y-T 11.68 11.31
-$32.19 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $22.91
-$47.00 $0.00 $0.00 $0.00 $0.00 $22.91
Hi Month  Apr
UK£ Hi £4.99 £4.94 £5.75 £6.16 £5.16 £5.94 £6.15 £7.30 £7.90 £5.09 £3.84 £3.83 -22.48% <-Total Growth 10 Stock Price UK£ 
Increase 4.2% -0.9% 16.4% 7.0% -16.2% 15.1% 3.6% 18.7% 8.2% -35.6% -24.5% -0.2% Stock Price UK£ 
Exch Rt £5.02 £5.50 £5.87 £5.70 £5.11 £5.93 £6.84 £7.42 £7.79 £5.39 £3.91 £3.69 -35.23% <-Total Growth 9 Stock Price UK£ 
Increase 4.0% 9.7% 6.6% -2.9% -10.3% 16.0% 15.3% 8.6% 5.0% -30.9% -27.3% -5.7% -2.51% <-IRR #YR-> 10 Stock Price UK£ 
P/E 17.0 12.1 15.5 18.4 12.3 11.6 11.7 10.5 11.8 8.8 16.9 13.4 -9.03% <-IRR #YR-> 5 Stock Price UK£ 
Trailing P/E 22.9 16.8 14.1 16.6 15.4 14.1 12.0 13.9 11.3 7.6 6.7 16.9
Median 5 Yrs Price Inc -0.16% P/E: Y-T 11.84 11.32
-£4.943 £0.000 £0.000 £0.000 £0.000 £0.000 £0.000 £0.000 £0.000 £0.000 £3.832
-£6.150 £0.000 £0.000 £0.000 £0.000 £3.832
Low Month Jan Feb Sep Sep Mar Jul Oct-Dec Nov Nov Jan Jun
Pre-split 02 $86.00 $91.06
US$  $21.50 $22.77 $24.88 $23.50 $20.60 $33.06 $37.16 $43.23 $39.86 $7.37 $3.07 $15.87 -36.20% <-Total Growth 9 Stock Price US$
Increase 43.3% 5.9% 9.3% -5.5% -12.3% 60.5% 12.4% 16.3% -7.8% -81.5% -58.3% 416.9% -3.54% <-IRR #YR-> 10 Stock Price US$
P/E 11.3 9.5 11.5 10.9 6.9 8.4 10.3 7.9 7.5 2.2 2.1 9.0 -15.65% <-IRR #YR-> 5 Stock Price US$
Trailing P/E 14.8 12.0 10.4 10.9 9.6 11.0 9.4 12.0 7.3 1.4 0.9 10.8
Median 5 Yrs Price Inc -7.80% P/E: Y-T 7.53 7.29
-$22.77 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $15.87
-$37.16 $0.00 $0.00 $0.00 $0.00 $15.87
Low Month Jul
UK£ Low £2.30 £3.48 £4.05 £3.66 £3.29 £4.43 £5.20 £5.86 £4.75 £1.28 £0.51 £2.55 -26.68% <-Total Growth 10 Stock Price UK£ 
Increase -3.1% 51.7% 16.2% -9.5% -10.1% 34.6% 17.3% 12.7% -19.0% -73.1% -59.9% 398.7%           Stock Price UK£ 
Exch Rt £3.33 £3.89 £4.28 £3.65 £2.90 £4.29 £5.40 £5.52 £5.02 £1.26 £0.47 £2.56 -40.24% <-Total Growth 9 Stock Price UK£ 
Increase 48.5% 16.8% 9.9% -14.7% -20.7% 48.1% 26.0% 2.1% -9.0% -74.9% -62.5% 440.2% -3.06% <-IRR #YR-> 10 Stock Price UK£ 
P/E 7.8 8.5 10.9 11.0 7.8 8.7 9.9 8.4 7.1 2.2 2.3 9.0 -13.26% <-IRR #YR-> 5 Stock Price UK£ 
Trailing P/E 10.5 11.9 9.9 9.9 9.9 10.5 10.2 11.1 6.8 1.9 0.9 11.2
Median 5 Yrs Price Inc -19.03% P/E: Y-T 7.11 6.80
-£3.48 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £2.55
-£5.20 £0.00 £0.00 £0.00 £0.00 £2.55
Market Cap CDN$ $63,475 $73,061 $89,075 $64,630 $77,077 $88,799 $79,397 $110,678 $65,818 $25,106 $52,729 $50,161 $56,982 $56,982 Market Cap CDN $
Market Cap US$ $43,084 $48,724 $55,931 $40,916 $59,639 $73,705 $68,270 $94,986 $66,611 $20,511 $50,213 $50,312 $59,935 $59,935 various site agree on this US$  Market Cap US$
Market Cap UK£ £26,018 £31,607 £34,801 £24,814 £32,567 £37,853 £39,719 £47,706 £33,264 £12,843 £31,497 £31,874 £36,747 £36,747 Market Cap UK£
ADRs 1,497 1,514 1,663 1,657 1,641 1,614 1,622 1,634 1,650 2,093 2,853 3,046 3,046 3,046 Shares US
# of Sh in M 5,988 6,055 6,651 6,626 6,563 6,454 6,490 6,535 6,600 8,372 11,412 12,182 12,182 12,182 Called up Share Capital Shares UK
Increase -0.9% 1.1% 9.8% -0.4% -1.0% -1.7% 0.6% 0.7% 1.0% 26.8% 36.3% 6.7% 0.0% 0.0%   0.85% <-Median-> 10 Shares YK
CF fr Op $M £8,923 £8,486 £3,799 £6,747 -£2,290 £6,089 -£10,498 £10,047 -£10,747 £33,716 £41,844 £18,688 Cash Flow
OPS £1.49 £1.40 £0.57 £1.02 -£0.35 £0.94 -£1.62 £1.54 -£1.63 £4.03 £3.67 £1.53 9.46% <-Total Growth 10 Cash Flow UK£
Increase -773.19% -5.95% -59.24% 78.27% -134.27% -370.37% -271.47% -195.04% -205.91% -347.32% -8.95% -58.16%     0.91% <-IRR #YR-> 10 Cash Flow UK£
Non-Cash CF £0 £0 £0 £0 £0 £0 £0 £0 £0 -£23,106 -£23,622 -£11,650     -0.05% <-IRR #YR-> 4 Cash Flow UK£
OPS non-cash £1.49 £1.40 £0.57 £1.02 -£0.35 £0.94 -£1.62 £1.54 -£1.63 £1.27 £1.60 £0.58     -8.48% <-IRR #YR-> 10 Cash Flow UK£
P/O on Cl 18.81 21.78 53.29 23.68 -101.17 47.91 -26.01 37.20 -24.57 7.08 11.22 28.12 -21.70% <-IRR #YR-> 4 Cash Flow UK£
*Operational Cash Flow per share
-$1.40 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.53
-$1.54 $0.00 $0.00 $0.00 $1.53
-$1.40 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.58
-$1.54 $0.00 $0.00 $0.00 $0.58
                                                         
OPM 21.0% 25.8% 22.1% 19.6% 22.1% 23.4% 21.4% 23.4% 21.7% 22.6% 34.3% 14.1%             OPM UK£
Diff from Ave -4.8% 16.7% -0.1% -11.3% 0.1% 6.1% -3.2% 6.1% -1.8% 2.5% 55.5% -36.0%       0.00 <-Median-> 10 OPM UK£  
*Operational Profit Margin (Earnings/Revenue) Ratio for banks OPM 10 Yrs 22.08% 5 Yrs 22.64%                          
                                                             
Assets £246,790 £301,025 £342,305 £398,763 £428,660 £522,089 £924,357 £996,787 £1,227,631 £2,052,980 £1,378,929 £1,489,645       Net ratio of 1.5 and up   Assets UK£                    
Liab. £238,307 £287,838 £327,797 £385,203 £412,187 £504,672 £906,931 £969,397 £1,194,885 £2,005,569 £1,320,451 £1,427,383       1.03 <-Median-> 10 Liabilities UK£                    
Liquidity 1.04 1.05 1.04 1.04 1.04 1.03 1.02 1.03 1.03 1.02 1.04 1.04       1.03 <-Median-> 5 Ratio UK£                    
Above is net of non-controlling interest.                                                      
                                                             
Non-Controlling                     £11,201 £11,404                                    
Book Value US$ $9.14 $12.74 $12.69 $13.18 $17.86 $20.80 $18.46 $23.74 $28.01 $25.58 $26.88 $25.92 $25.92 $25.92 103.52% <-Total Growth 10 Book Value US$                    
Book Value £8,483 £13,187 £14,508 £13,560 £16,473 £17,417 £17,426 £19,799 £23,291 £36,618 £47,277 £50,858 £50,858 £50,858 285.67% <-Total Growth 10 Book Value UK£                    
BV per share £1.42 £2.18 £2.18 £2.05 £2.51 £2.70 £2.69 £3.03 £3.53 £4.37 £4.14 £4.17 £4.17 £4.17 91.69% <-Total Growth 10 Book Value UK£                    
Change 8.00% 53.73% 0.16% -6.18% 22.65% 7.51% -0.50% 12.83% 16.48% 23.94% -5.28% 0.77% 0.00% 0.00%   0.0803 Current/Historical   Book Value UK£                    
P/BV (CL) 3.07 2.40 2.40 1.83 1.98 2.17 2.28 2.41 1.43 0.35 0.67 0.63 0.72 0.72 6.72% <-IRR #YR-> 10 Book Value UK£                    
Change 23.51% -21.85% 0.08% -23.71% 8.04% 9.93% 4.88% 5.71% -40.73% -75.44% 89.96% -5.93% 15.29% 0.00% 9.23% <-IRR #YR-> 5 Book Value UK£                    
Leverage (A/BK) 29.09 22.83 23.59 29.41 26.02 29.98 53.04 50.35 52.71 56.06 29.17 29.29       29.69 <-Median-> 10 A/BV UK£                    
Debt/Eq Ratio 28.09 21.83 22.59 28.41 25.02 28.98 52.04 48.96 51.30 54.77 27.93 28.07       28.69 <-Median-> 10 Debt/Eq Ratio UK£                    
Median               P/BV 10 yr Ave 1.90 5 yr Ave 0.67                                  
                                                           
ROE                   19.6% 22.9% 8.9%       19.64% <-Median-> 3 Compreh. Inc UK£                    
Comprehensive Inc                   £7,190 £10,836 £4,512             Compreh. Inc UK£                    
                                                           
ROE 20.7% 18.8% 17.0% 16.4% 16.7% 18.8% 22.0% 26.2% 21.9% 14.4% 21.8% 8.9%       Net Income/Shareholders' equity     ROE UK£                    
5Yr Median   18.8% 17.0% 17.0% 17.0% 17.0% 17.0% 18.8% 21.9% 21.9% 21.9% 21.8%             ROE UK£                    
                                                           
Net Income £1,759 £2,473 £2,465 £2,230 £2,744 £3,268 £3,841 £5,195 £5,095 £5,287 £10,288 £4,549       83.95% <-Total Growth 10 Net Income UK£                    
Oper C. F. £6,747 -£2,290 £6,089 -£10,498 £10,047 -£10,747 £33,716 £41,844 £18,688       Cash Flow Statement     UK£                    
Invest. C. F -£3,224 -£4,560 -£3,612 -£5,181 -£1,154 £10,064 £8,755 -£825 -£5,627       Cash Flow Statement     UK£                    
Total Accruals -£1,293 £9,594 £791 £19,520 -£3,698 £5,778 -£37,184 -£30,731 -£8,512               UK£                    
Total Assets £398,763 £428,660 £522,089 £924,357 £996,787 £1,227,631 £2,052,980 £1,378,929 £1,489,645       Balance Sheet     UK£                    
Accruals Ratio       -0.32% 2.24% 0.15% 2.11% -0.37% 0.47% -1.81% -2.23% -0.57%               UK£                    
                                                           
Fin. C. F             £1,083 £692 £3,358 £12,272 £671 £159               UK£                    
Total Accruals             £18,437 -£4,390 £2,420 -£49,456 -£31,402 -£8,671               UK£                    
Accruals Ratio             1.99% -0.44% 0.20% -2.41% -2.28% -0.58%       Oper C. F. Covers Investing C.F. and dividends? UK£                    
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.                                  
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.                                      
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.                              
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.                                    
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.
AR  2005.  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.
                                                             
I bought this stock when Barrett took over in 2000.  It is a good dividend paying stock and it gives me some geographical diversifications.
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
How they make their money.
This is a bank.  Barclays is a global financial services provider, engaged in retail and commercial banking, credit cards, investment banking, wealth management and investment management services all over the world.
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.
 
Copyright © 2008 Website of SPBrunner. All rights reserved.