This report should not be construed as providing investment advice. It is for educational purposes only.  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/ Q2 2017
Equitable Group Inc. TSX: EQB OTC: EQGPF www.equitablebank.ca 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 Total G
Accounting Rules IFRS  IFRS  IFRS  IFRS  IFRS  IFRS  IFRS  IFRS 
$304.9 <-12 mths 8.92%
Net Interest Income $37.9 $51.6 $61.0 $64.3 $73.2 $94.0 $133.8 $154.2 $174.5 $204.5 $242.2 $279.9 $311 $335 $373 442.08% <-Total Growth 10 Net Int, Other Income
Increase 31.91% 36.22% 18.07% 5.54% 13.72% 28.53% 42.24% 15.26% 13.20% 17.18% 18.44% 15.56% 11.11% 7.72% 11.34% 18.41% <-IRR #YR-> 10 Net Interest Income 442.08%
5 year Running Average $41.1 $48.7 $57.6 $68.8 $85.3 $103.9 $125.9 $152.2 $181.8 $211.1 $242.4 $274.5 $308.2 15.91% <-IRR #YR-> 5 Net Interest Income 109.25%
Revenue per Share $3.22 $4.33 $4.71 $4.32 $4.91 $6.29 $8.91 $10.15 $11.37 $13.25 $15.59 $17.01 $18.87 $20.33 $22.64 19.95% <-IRR #YR-> 9 5 yr Running Average #DIV/0!
Increase 30.78% 34.60% 8.70% -8.15% 13.56% 28.19% 41.53% 13.95% 11.99% 16.57% 17.65% 9.09% 10.99% 7.72% 11.34% 19.88% <-IRR #YR-> 5 5 yr Running Average 147.57%
5 year Running Average $3.45 $3.81 $4.30 $4.91 $5.83 $6.92 $8.33 $9.99 $11.85 $13.47 $15.22 $17.01 $18.89 14.66% <-IRR #YR-> 10 Revenue per Share 292.70%
P/S (Price/Sales) Med 7.53 6.08 6.64 4.50 3.21 3.66 3.02 2.87 3.68 4.43 3.65 3.21 2.88 0.00 0.00 13.81% <-IRR #YR-> 5 Revenue per Share 90.92%
P/S (Price/Sales) Close 7.65 7.20 6.11 2.72 4.33 3.97 2.81 3.22 4.47 4.96 3.30 3.56 3.08 2.86 2.57 16.35% <-IRR #YR-> 9 5 yr Running Average #DIV/0!
Net Interest Income is what analysts seem to be looking at. P/S Med 10 yr  3.65 5 yr  3.65 -15.78% Diff M/C 18.24% <-IRR #YR-> 5 5 yr Running Average 131.16%
$713.9 <-12 mths 7.53%
Interest Income $509.5 $565.2 $637.5
Other Income $13.4 $16.8 $26.5
Revenue* $100.4 $143.2 $185.9 $226.8 $207.8 $211.1 $439.0 $483.1 $508.6 $523.0 $582.0 $663.9 363.57% <-Total Growth 10 Revenue
Increase 34.39% 42.60% 29.82% 21.96% -8.35% 1.58% 107.94% 10.06% 5.26% 2.83% 11.29% 14.08% 16.58% <-IRR #YR-> 10 Revenue 363.57%
5 year Running Average $88.4 $114.0 $146.2 $172.8 $195.0 $254.1 $313.6 $369.9 $433.0 $507.1 $552.1 8.63% <-IRR #YR-> 5 Revenue 51.24%
Revenue per Share $8.52 $12.01 $14.35 $15.24 $13.94 $14.13 $29.23 $31.81 $33.12 $33.88 $37.45 $40.34 20.11% <-IRR #YR-> 10 5 yr Running Average 524.62%
Increase 33.24% 40.90% 19.52% 6.15% -8.48% 1.31% 106.90% 8.81% 4.13% 2.30% 10.55% 7.69% 16.79% <-IRR #YR-> 5 5 yr Running Average 117.26%
5 year Running Average $6.65 $9.52 $11.30 $12.81 $13.93 $17.38 $20.87 $24.45 $28.43 $33.10 $35.32 12.88% <-IRR #YR-> 10 Revenue per Share 235.83%
P/S (Price/Sales) Med 2.84 2.19 2.18 1.28 1.13 1.63 0.92 0.92 1.26 1.73 1.52 1.35 6.65% <-IRR #YR-> 5 Revenue per Share 37.99%
P/S (Price/Sales) Close 2.89 2.60 2.00 0.77 1.52 1.77 0.86 1.03 1.53 1.94 1.37 1.50 18.17% <-IRR #YR-> 10 5 yr Running Average 430.83%
*Intertest Income and Other Income. in M CDN $  P/S Med 10 yr  1.31 5 yr  1.35 -100.00% Diff M/C 15.24% <-IRR #YR-> 5 5 yr Running Average 103.23%
-$143.2 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $663.9
-$439.0 $0.0 $0.0 $0.0 $0.0 $663.9
-$88.4 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $552.1
-$254.1 $0.0 $0.0 $0.0 $0.0 $552.1
-$12.01 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $40.34
-$29.23 $0.00 $0.00 $0.00 $0.00 $40.34
$9.55 <-12 mths 12.49%
EPS Basic $1.68 $2.30 $2.47 $2.79 $3.37 $3.39 $3.91 $5.15 $5.89 $6.63 $7.83 $8.57 272.61% <-Total Growth 10 EPS Basic
EPS Diluted* $1.65 $2.26 $2.44 $2.78 $3.36 $3.38 $3.88 $5.11 $5.82 $6.53 $7.73 $8.49 $9.07 $9.40 $10.50 275.66% <-Total Growth 10 EPS Diluted
Increase 26.92% 36.97% 7.96% 13.93% 20.86% 0.60% 14.79% 31.70% 13.89% 12.20% 18.38% 9.83% 6.83% 3.64% 11.70% 14.15% <-IRR #YR-> 10 Earnings per Share 275.66%
Earnings Yield 6.7% 7.2% 8.5% 23.7% 15.8% 13.5% 15.5% 15.7% 11.5% 9.9% 15.0% 14.0% 15.6% 16.2% 18.1% 16.95% <-IRR #YR-> 5 Earnings per Share 118.81%
5 year Running Average $1.26 $1.46 $1.71 $2.09 $2.50 $2.84 $3.17 $3.70 $4.31 $4.94 $5.81 $6.74 $7.53 $8.24 $9.04 7.50% <-IRR #YR-> 10 5 yr Running Average 360.74%
10 year Running Average $2.71 $3.20 $3.72 $4.33 $4.95 $5.62 $6.28 $6.99 16.28% <-IRR #YR-> 5 5 yr Running Average 112.63%
* Diluted ESP per share  E/P 10 Yrs 14.53% 5Yrs 14.04%
-$2.26 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $8.49
-$3.88 $0.00 $0.00 $0.00 $0.00 $8.49
-$1.46 $0.00 -$2.09 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $6.74
-$3.17 $0.00 $0.00 $0.00 $0.00 $6.74
Special Dividend $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
Dividend* $0.31 $0.38 $0.40 $0.40 $0.40 $0.40 $0.43 $0.50 $0.58 $0.66 $0.74 $0.82 $0.92 $0.96 $0.96 115.79% <-Total Growth 10 Dividends
Increase 22.58% 5.26% 0.00% 0.00% 0.00% 7.50% 16.28% 16.00% 13.79% 12.12% 10.81% 12.20% 4.35% 0.00% Count 12 Years of data
Dividends 5 Yr Running $0.38 $0.40 $0.41 $0.43 $0.46 $0.51 $0.58 $0.66 $0.74 $0.82 $0.88 66.67% <-Total Growth 7 Dividends 5 Yr Running
Yield H/L Price 1.28% 1.44% 1.28% 2.06% 2.54% 1.74% 1.60% 1.72% 1.38% 1.13% 1.30% 1.50% 1.69% 1.55% <-Median-> 10 Yield H/L Price
Yield on High  Price 1.15% 1.31% 1.15% 1.37% 1.83% 1.56% 1.32% 1.51% 1.14% 0.93% 1.14% 1.30% 1.27% 1.31% <-Median-> 10 Yield on High  Price
Yield on Low Price 1.44% 1.61% 1.44% 4.11% 4.17% 1.95% 2.02% 2.00% 1.76% 1.43% 1.53% 1.78% 2.52% 1.86% <-Median-> 10 Yield on Low Price
Yield on Close Price 1.26% 1.22% 1.39% 3.40% 1.88% 1.60% 1.72% 1.53% 1.14% 1.01% 1.44% 1.36% 1.58% 1.65% 1.65% 1.48% <-Median-> 10 Yield on Close Price
Payout Ratio EPS 18.79% 16.81% 16.39% 14.39% 11.90% 11.83% 11.08% 9.78% 9.97% 10.11% 9.57% 9.66% 10.14% 10.21% 9.14% 10.59% <-Median-> 10 DPR EPS
DPR EPS 5 Yr Running 15.13% 13.92% 12.82% 11.51% 10.72% 10.40% 10.01% 9.80% 9.88% 9.95% 9.74% 11.11% <-Median-> 8 DPR EPS 5 Yr Running
Payout Ratio CFPS 14.02% 18.58% 11.79% 18.98% 13.31% 10.48% 53.40% -5.45% -3.20% -17.85% 4.71% -65.43% #DIV/0! #DIV/0! #DIV/0! 7.60% <-Median-> 10 DPR CF
DPR CF 5 Yr Running 12.58% 10.38% 50.42% -4.65% -2.55% -13.90% 3.71% -52.66% #DIV/0! #DIV/0! #DIV/0! 0.58% <-Median-> 8 DPR CF 5 Yr Running
Payout Ratio CFPS WC 16.30% 15.59% 11.39% 17.29% 13.15% 9.92% -1.34% -0.58% -0.66% -0.84% -1.76% -1.01% #DIV/0! #DIV/0! #DIV/0! -0.62% <-Median-> 10 DPR CF WC
DPR CF WC 5 Yr Running 12.43% 9.82% -1.27% -0.50% -0.52% -0.65% -1.38% -0.81% #DIV/0! #DIV/0! #DIV/0! -0.59% <-Median-> 8 DPR CF WC 5 Yr Running
Median Values 5 Yr Med 5 Yr Cl 1.38% 1.36% 5 Yr Med Payout 9.78% -5.45% -0.84% 7.99% <-IRR #YR-> 10 Dividends 115.79%
* Dividends per share  5 Yr Med and Cur. 19.35% 21.87% Last Div Inc ---> $0.22 $0.23 4.5% 13.78% <-IRR #YR-> 5 Dividends 90.70%
-$0.38 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.82
-$0.43 $0.00 $0.00 $0.00 $0.00 $0.82
Historical Dividends Historical High Div 4.14% Low Div 0.37% Ave Div 2.26% Med Div 1.44% Close Div 1.39% Historical Dividends
High/Ave/Median Values Curr diff Exp. -60.08%     346.73% Exp. -26.70% Cheap 14.78% Cheap 18.80% High/Ave/Median 
Future Dividend Yield Div Yd 2.33% earning in 5 Years at IRR of 7.10% Div Inc. 40.91% Future Dividend Yield
Future Dividend Yield Div Yd 3.28% earning in 10 Years at IRR of 7.10% Div Inc. 98.56% Future Dividend Yield
Future Dividend Yield Div Yd 4.62% earning in 15 Years at IRR of 7.10% Div Inc. 179.80% Future Dividend Yield
Yield if held 5 years 1.95% 1.65% 1.63% 1.60% 2.98% 4.19% 3.21% 3.05% 3.16% 2.29% 1.64% 2.46% <-Median-> 8 Paid Median Price
Yield if held 10 years 3.21% 3.05% 3.11% 2.94% 4.94% 6.09% 3.11% <-Median-> 3 Paid Median Price
Yield if held 15 years 4.67% #NUM! <-Median-> 0 Paid Median Price
Yield if held 20 years #DIV/0! #NUM! <-Median-> 0 Paid Median Price
Yield if held 25 years #DIV/0! #NUM! <-Median-> 0 Paid Median Price
Cost covered if held 5 years 9.20% 8.17% 7.71% 6.81% 11.88% 16.31% 12.62% 12.27% 12.78% 9.79% 7.50% 10.54% <-Median-> 8 Paid Median Price
Cost covered if held 10 years 21.70% 20.19% 20.25% 18.71% 32.96% 44.24% 20.25% <-Median-> 3 Paid Median Price
Cost covered if held 15 years 43.11% #NUM! <-Median-> 0 Paid Median Price
Cost covered if held 20 years #DIV/0! #NUM! <-Median-> 0 Paid Median Price
Cost covered if held 25 years #DIV/0! #NUM! <-Median-> 0 Paid Median Price
Graham No. $19.82 $25.27 $29.35 $33.32 $40.62 $43.68 $46.88 $58.56 $67.85 $77.52 $92.93 $102.46 $110.63 $113.99 $120.48 305.48% <-Total Growth 10 Graham Price
Price/GP Ratio Med 1.22 1.04 1.07 0.58 0.39 0.53 0.57 0.50 0.62 0.76 0.61 0.53 0.49 0.58 <-Median-> 10 Price/GP Ratio
Price/GP Ratio High 1.36 1.15 1.18 0.87 0.54 0.59 0.69 0.57 0.75 0.92 0.70 0.62 0.65 0.70 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Low 1.09 0.93 0.95 0.29 0.24 0.47 0.45 0.43 0.49 0.60 0.52 0.45 0.33 0.46 <-Median-> 10 Price/GP Ratio
Price/GP Ratio Close 1.24 1.23 0.98 0.35 0.52 0.57 0.53 0.56 0.75 0.85 0.55 0.59 0.52 0.51 0.48 0.56 <-Median-> 10 Price/GP Ratio
Prem/Disc Close 24.15% 23.47% -2.03% -64.74% -47.69% -42.79% -46.68% -44.25% -25.19% -15.28% -44.58% -40.99% -47.50% -49.05% -51.79% -43.52% <-Median-> 10 Graham Price
Month, Year Dec-05 Dec-06 Dec-07 Dec-08 Dec-09 Dec-10 Dec-11 Dec-12 Dec-13 Dec-14 Dec-15 Dec-16 Dec-17 Dec-18 Dec-19
Price Close $24.60 $31.20 $28.75 $11.75 $21.25 $24.99 $25.00 $32.65 $50.76 $65.67 $51.50 $60.46 $58.08 $58.08 $58.08 93.78% <-Total Growth 10 Stock Price
Increase 10.46% 26.83% -7.85% -59.13% 80.85% 17.60% 0.04% 30.60% 55.47% 29.37% -21.58% 17.40% -3.94% 0.00% 0.00% 6.84% <-IRR #YR-> 10 Stock Price 93.78%
P/E 14.91 13.81 11.78 4.23 6.32 7.39 6.44 6.39 8.72 10.06 6.66 7.12 6.40 6.18 5.53 19.32% <-IRR #YR-> 5 Stock Price 141.84%
Trailing P/E 18.92 18.91 12.72 4.82 7.64 7.44 7.40 8.41 9.93 11.28 7.89 7.82 6.84 6.40 6.18 8.07% <-IRR #YR-> 10 Price & Dividend
Median 10, 5 Yrs D.  per yr 1.23% 1.83% % Tot Ret 15.21% 8.67% T P/E 8.41 P/E:  6.89 7.12 21.15% <-IRR #YR-> 5 Price & Dividend
-$31.20 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $60.46
-$25.00 $0.00 $0.00 $0.00 $0.00 $60.46
-$31.20 $0.40 $0.40 $0.40 $0.40 $0.43 $0.50 $0.58 $0.66 $0.74 $61.28
-$25.00 $0.50 $0.58 $0.66 $0.74 $61.28
Price H/L Median $24.23 $26.33 $31.27 $19.45 $15.76 $23.05 $26.90 $29.12 $41.88 $58.64 $56.83 $54.58 $54.38 107.31% <-Total Growth 10 Stock Price
Increase 17.88% 8.67% 18.77% -37.81% -18.98% 46.30% 16.68% 8.25% 43.84% 40.02% -3.10% -3.96% -0.36% 7.56% <-IRR #YR-> 10 Stock Price 107.31%
P/E 14.68 11.65 12.81 6.99 4.69 6.82 6.93 5.70 7.20 8.98 7.35 6.43 6.00 15.20% <-IRR #YR-> 5 Stock Price 102.92%
Trailing P/E 18.63 15.95 13.83 7.97 5.67 6.86 7.96 7.50 8.20 10.08 8.70 7.06 6.41 8.97% <-IRR #YR-> 10 Price & Dividend
P/E on Run. 5 yr Ave 9.32 6.31 8.10 8.49 7.86 9.72 11.86 9.77 8.10 7.22 17.03% <-IRR #YR-> 5 Price & Dividend
P/E on Run. 10 yr Ave 10.76 13.10 15.76 13.13 11.02 9.68 7.20 P/E Ratio Historical Median
Median 10, 5 Yrs D.  per yr 1.41% 1.82% % Tot Ret 15.71% 10.71% T P/E 8.20 P/E:  6.96 7.20 Count 13 Years of data
-$26.33 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $54.58
-$26.90 $0.00 $0.00 $0.00 $0.00 $54.58
-$26.33 $0.40 $0.40 $0.40 $0.40 $0.43 $0.50 $0.58 $0.66 $0.74 $55.40
-$26.90 $0.50 $0.58 $0.66 $0.74 $55.40
High Months Sep Mar May Jan Oct Apr May Dec Dec Dec May Dec Feb
Price High $26.95 $29.10 $34.75 $29.15 $21.91 $25.60 $32.48 $33.19 $50.76 $71.00 $65.15 $63.02 $72.27 116.56% <-Total Growth 10 Stock Price
Increase 15.91% 7.98% 19.42% -16.12% -24.84% 16.84% 26.88% 2.19% 52.94% 39.87% -8.24% -3.27% 14.68% 8.03% <-IRR #YR-> 10 Stock Price 116.56%
P/E 16.33 12.88 14.24 10.49 6.52 7.57 8.37 6.50 8.72 10.87 8.43 7.42 7.97 14.18% <-IRR #YR-> 5 Stock Price 94.03%
Trailing P/E 20.73 17.64 15.38 11.95 7.88 7.62 9.61 8.55 9.93 12.20 9.98 8.15 8.51 8.72 P/E Ratio Historical Median
Median 10, 5 Yrs T P/E 9.93 P/E:  8.40 8.43 14.66 P/E Ratio Historical High
-$29.10 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $63.02
-$32.48 $0.00 $0.00 $0.00 $0.00 $63.02
Low Months Jan Feb Nov Dec Mar Feb Oct May Jan Feb Aug Jan Apr
Price Low $21.50 $23.55 $27.78 $9.74 $9.60 $20.50 $21.31 $25.04 $33.00 $46.28 $48.50 $46.13 $36.49 95.88% <-Total Growth 10 Stock Price
Increase 20.45% 9.53% 17.96% -64.94% -1.44% 113.54% 3.95% 17.50% 31.79% 40.24% 4.80% -4.89% -20.90% 6.95% <-IRR #YR-> 10 Stock Price 95.88%
P/E 13.03 10.42 11.39 3.50 2.86 6.07 5.49 4.90 5.67 7.09 6.27 5.43 4.02 16.70% <-IRR #YR-> 5 Stock Price 116.47%
Trailing P/E 16.54 14.27 12.29 3.99 3.45 6.10 6.30 6.45 6.46 7.95 7.43 5.97 4.30 6.07 P/E Ratio Historical Median
Median 10, 5 Yrs T P/E 6.46 P/E:  5.58 5.67 4.62 P/E Ratio Historical Low
-$23.55 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $46.13
Long Term Debt $6,109.4 $7,762.6 $7,750.4 Debt Securitization
Change 27.06% -0.16% 27.06% <-Median-> 1 Change Liab.
Debt/Market Cap Ratio 7.63 7.80 8.10 7.72 <-Median-> 2 % of Market C.
Goodwill & Intangibles Yes --> $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 Intangibles Goodwill
Change #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! <-Median-> 0 Change
Intangible/Market Cap Ratio 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00 <-Median-> 5 % of Market C.
Market Cap $290 $372 $372 $175 $317 $373 $375 $496 $779 $1,014 $800 $995 $957 $957 $957 167.49% <-Total Growth 10 Market Cap
Diluted # of Shares in Million 11.95 12.08 12.79 13.90 14.93 15.00 15.10 15.18 15.45 15.65 15.67 15.73 16.59 30.25% <-Total Growth 10 Diluted
Change 3.35% 1.09% 5.95% 8.62% 7.42% 0.47% 0.68% 0.55% 1.76% 1.27% 0.16% 0.36% 5.49% 0.98% <-Median-> 10 Change
Basic # of Shares in Millions 11.75 11.88 12.61 13.84 14.89 14.92 14.98 15.08 15.27 15.40 15.47 15.59 16.47 31.25% <-Total Growth 10 Basic
Change 4.24% 1.12% 6.12% 9.80% 7.56% 0.22% 0.37% 0.65% 1.31% 0.83% 0.44% 0.80% 5.64% 0.82% <-Median-> 10 Change
Difference 0.3% 0.4% 2.7% 7.5% 0.1% 0.1% 0.3% 0.8% 0.5% 0.2% 0.5% 5.6% 0.0% 0.50% <-Median-> 10 Difference
$421.67 <-12 mths 2143.98%
# of Share in Millions 11.782 11.924 12.953 14.883 14.904 14.943 15.018 15.190 15.355 15.435 15.539 16.460 16.478 16.478 16.478 3.28% <-IRR #YR-> 10 Shares 38.04%
Change 0.87% 1.21% 8.62% 14.90% 0.14% 0.27% 0.50% 1.14% 1.09% 0.52% 0.67% 5.93% 0.11% 0.00% 0.00% 1.85% <-IRR #YR-> 5 Shares 9.60%
CF fr Op $M $26.1 $24.4 $43.9 $31.4 $44.8 $57.0 $12.1 -$139.3 -$278.3 -$57.1 $243.9 -$20.6 -184.60% <-Total Growth 10 Cash Flow
Increase 23.54% -6.43% 80.24% -28.63% 42.83% 27.30% -78.79% -1252% 99.78% -79.49% -527.47% -108.46% S. Issues SO
5 year Running Average $25.2 $29.4 $34.1 $40.3 $37.8 $1.2 -$60.7 -$81.1 -$43.7 -$50.3 -271.14% <-Total Growth 9 CF 5 Yr Running
CFPS $2.21 $2.04 $3.39 $2.11 $3.01 $3.82 $0.81 -$9.17 -$18.12 -$3.70 $15.70 -$1.25 -161.29% <-Total Growth 10 Cash Flow per Share
Increase 22.48% -7.55% 65.93% -37.89% 42.63% 26.96% -78.90% -1239% 97.63% -79.60% -524.63% -107.98% #NUM! <-IRR #YR-> 10 Cash Flow -184.60%
5 year Running Average $2.10 $2.31 $2.55 $2.87 $2.63 $0.11 -$3.93 -$5.27 -$2.90 -$3.31 #NUM! <-IRR #YR-> 5 Cash Flow -270.58%
P/CF on Med Price 10.95 12.87 9.21 9.23 5.24 6.04 33.40 -3.18 -2.31 -15.86 3.62 -43.54 #NUM! <-IRR #YR-> 10 Cash Flow per Share -161.29%
P/CF on Closing Price 11.12 15.26 8.47 5.58 7.07 6.55 31.05 -3.56 -2.80 -17.77 3.28 -48.24 #NUM! <-IRR #YR-> 5 Cash Flow per Share -255.64%
#NUM! <-IRR #YR-> 9 CFPS 5 yr Running #DIV/0!
Excl.Working Capital CF -$3.7 $4.7 $1.6 $3.1 $0.5 $3.2 -$494.0 -$1,167.3 -$1,075.7 -$1,162.5 -$896.9 -$1,320.6 #NUM! <-IRR #YR-> 5 CFPS 5 yr Running -226.02%
CF fr Op $M WC $22.4 $29.1 $45.5 $34.4 $45.3 $60.3 -$481.9 -$1,306.6 -$1,353.9 -$1,219.5 -$653.0 -$1,341.3 -4715.45% <-Total Growth 10 Cash Flow less WC
Increase -4.46% 29.69% 56.58% -24.31% 31.62% 32.95% -900% 171.11% 3.62% -9.93% -46.45% 105.39% #NUM! <-IRR #YR-> 10 Cash Flow less WC -4715.45%
5 year Running Average $26.3 $31.0 $35.3 $42.9 -$59.3 -$329.7 -$607.4 -$860.3 -$1,003.0 -$1,174.9 22.72% <-IRR #YR-> 5 Cash Flow less WC -178.30%
CFPS Excl. WC $1.90 $2.44 $3.51 $2.31 $3.04 $4.03 -$32.09 -$86.02 -$88.17 -$79.01 -$42.03 -$81.48 #NUM! <-IRR #YR-> 9 CF less WC 5 Yr Run #DIV/0!
Increase -5.28% 28.14% 44.15% -34.13% 31.43% 32.60% -896% 168.05% 2.51% -10.40% -46.81% 93.89% 81.73% <-IRR #YR-> 5 CF less WC 5 Yr Run -1881.88%
5 year Running Average $2.18 $2.43 $2.64 $3.07 -$3.84 -$21.74 -$39.84 -$56.25 -$65.46 -$75.34 #NUM! <-IRR #YR-> 10 CFPS - Less WC -3443.64%
P/CF on Med Price 12.74 10.80 8.90 8.40 5.18 5.72 -0.84 -0.34 -0.47 -0.74 -1.35 -0.67 20.49% <-IRR #YR-> 5 CFPS - Less WC -153.93%
P/CF on Closing Price 12.93 12.80 8.18 5.08 6.99 6.20 -0.78 -0.38 -0.58 -0.83 -1.23 -0.74 #NUM! <-IRR #YR-> 9 CFPS 5 yr Running #DIV/0!
*Operational Cash Flow per share P/CF Med 10 yr -0.41 5 yr  -0.67 -100.00% Diff M/C 81.38% <-IRR #YR-> 5 CFPS 5 yr Running -1863.21%
-$2.04 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 -$1.25 Cash Flow per Share
-$0.81 $0.00 $0.00 $0.00 $0.00 -$1.25 Cash Flow per Share
-$2.10 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 -$3.31 CFPS 5 yr Running
-$2.63 $0.00 $0.00 $0.00 $0.00 -$3.31 CFPS 5 yr Running
-$29.1 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 -$1,341.3 Cash Flow less WC
$481.9 $0.0 $0.0 $0.0 $0.0 -$1,341.3 Cash Flow less WC
-$26.3 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 -$1,174.9 CF less WC 5 Yr Run
$59.3 $0.0 $0.0 $0.0 $0.0 -$1,174.9 CF less WC 5 Yr Run
-$2.44 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 -$81.48 CFPS - Less WC
$32.09 $0.00 $0.00 $0.00 $0.00 -$81.48 CFPS - Less WC
OPM 25.95% 17.03% 23.64% 13.83% 21.56% 27.01% 2.75% -28.83% -54.71% -10.91% 41.91% -3.11% -113.15% <-Total Growth 10 OPM
Increase -8.07% -34.39% 38.83% -41.48% 55.85% 25.31% -89.80% -1146% 89.79% -80.06% -484.11% -107.41% Should increase or be stable.
Diff from Median 212.9% 105.3% 185.0% 66.8% 159.9% 225.7% -66.8% -447.6% -759.7% -231.6% 405.3% -137.5% 0.00 <-Median-> 10 OPM
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 8.29% 5 Yrs -10.91% should be zero, it is a check on calculations
Current Assets $77.21 $107.84 $31.35 $58.54 $400.84 $172.76 $254.00 $443.05 $331.02 $297.75 $531.35 $111.18 $1,223.50 Liquidity ratio of 1.5 and up, best
Current Liabilities $27.25 $26.26 $17.42 $36.43 $54.72 $63.82 $36.38 $46.43 $66.08 $76.81 $109.99 $173.03 $249.47 4.35 <-Median-> 10 Ratio
Liquidity Ratio 2.83 4.11 1.80 1.61 7.32 2.71 6.98 9.54 5.01 3.88 4.83 0.64 4.90 4.83 <-Median-> 5 Ratio
Liq. with CF aft div 3.66 4.86 4.03 2.30 8.03 3.51 7.14 8.20 4.41 3.42 6.94 0.60 4.41 <-Median-> 5 Ratio
Liq. CF re  Inv+Div  0.22 0.21 0.08 0.13 8.03 0.25 7.14 8.20 4.41 3.42 5.88 0.60 4.41 <-Median-> 5 Ratio
Assets $2,012 $2,626 $3,410 $4,088 $3,846 $4,453 $10,257 $11,601 $11,816 $12,855 $17,148 $18,974 $19,796 Debt Ratio of 1.5 and up, best
Liabilities $1,888 $2,476 $3,206 $3,823 $3,472 $4,030 $9,830 $11,100 $11,228 $12,151 $16,304 $17,996 $18,735 1.06 <-Median-> 10 Ratio
Debt Ratio 1.07 1.06 1.06 1.07 1.11 1.11 1.04 1.05 1.05 1.06 1.05 1.05 1.06 1.05 <-Median-> 5 Ratio
Book Value $124.61 $149.74 $203.17 $264.15 $373.86 $423.46 $426.64 $501.57 $588.32 $703.69 $843.92 $977.15 $1,060.85 $1,060.85 $1,060.85 552.58% <-Total Growth 10 Book Value
Preferred Shares $0.00 $0.00 $0.00 $0.00 $48.52 $48.52 $48.49 $48.49 $48.49 $72.41 $72.41 $72.56 $72.56 $48.49 $48.49
Net Book Value $124.61 $149.74 $203.17 $264.15 $325.34 $374.94 $378.15 $453.08 $539.82 $631.28 $771.51 $904.59 $988.30 $1,012.36 $1,012.36 504.13% <-Total Growth 10 Book Value
Book Value per share $10.58 $12.56 $15.69 $17.75 $21.83 $25.09 $25.18 $29.83 $35.16 $40.90 $49.65 $54.96 $59.98 $61.44 $61.44 337.66% <-Total Growth 10 Book Value per Share
Change 14.86% 18.73% 24.91% 13.15% 22.99% 14.94% 0.35% 18.46% 17.86% 16.34% 21.40% 10.69% 9.14% 2.43% 0.00% -10.49% P/B Ratio Current/10 Year Median
P/B Ratio (Median) 2.29 2.10 1.99 1.10 0.72 0.92 1.07 0.98 1.19 1.43 1.14 0.99 0.91 1.12 P/B Ratio Historical Median
P/B Ratio (Close) 2.33 2.48 1.83 0.66 0.97 1.00 0.99 1.09 1.44 1.61 1.04 1.10 0.97 0.95 0.95 15.91% <-IRR #YR-> 10 Book Value 337.66%
Change -3.83% 6.82% -26.23% -63.88% 47.04% 2.31% -0.31% 10.25% 31.91% 11.21% -35.40% 6.06% -11.98% -2.38% 0.00% 16.90% <-IRR #YR-> 5 Book Value 118.26%
Leverage (A/BK) 16.15 17.54 16.78 15.47 10.29 10.52 24.04 23.13 20.09 18.27 20.32 19.42 18.66 18.84 <-Median-> 10 A/BV
Debt/Equity Ratio 15.15 16.54 15.78 14.47 9.29 9.52 23.04 22.13 19.09 17.27 19.32 18.42 17.66 17.84 <-Median-> 10 Debt/Eq Ratio
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Med 1.08 5 yr Med 1.14 -10.49% Diff M/C 17.16 Historical Leverage (A/BK)
-$12.56 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $54.96
-$25.18 $0.00 $0.00 $0.00 $0.00 $54.96
$182.66 <-12 mths 25.44%
Comprehensive Income $25.84 $67.22 $57.80 $53.07 $81.67 $95.48 $104.85 $105.40 $145.62 463.52% <-Total Growth 8 Comprehensive Income
Increase 160.11% -14.01% -8.18% 53.90% 16.91% 9.82% 0.52% 38.17% 16.91% <-Median-> 5 Comprehensive Income
5 Yr Running Average $57 $71 $79 $88 $107 24.13% <-IRR #YR-> 8 Comprehensive Income #DIV/0!
ROE 9.8% 18.0% 13.6% 12.4% 16.3% 16.2% 14.9% 12.5% 14.9% 22.37% <-IRR #YR-> 5 Comprehensive Income 174.41%
5Yr Median 13.6% 16.2% 14.9% 14.9% 14.9% 16.88% <-IRR #YR-> 4 5 Yr Running Average #DIV/0!
% Difference from NI -33.1% 30.7% 6.5% -14.7% 0.6% 2.1% -1.7% -16.3% 5.3% 16.88% <-IRR #YR-> 4 5 Yr Running Average #DIV/0!
Diff 5, 10 yr 0.6% 0.6% 14.9% <-Median-> 5 Return on Equity
-$25.8 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $145.6
-$57.8 -$53.1 $0.0 $0.0 $0.0 $0.0 $145.6
-$57.1 $0.0 $0.0 $0.0 $106.6
-$57.1 $0.0 $0.0 $0.0 $106.6
Current Liability Coverage Ratio 0.82 1.11 2.61 0.95 0.83 0.94 -13.25 -28.14 -20.49 -15.88 -5.94 -7.75   CFO / Current Liabilities
5 year Median 1.07 1.07 0.95 0.95 0.94 0.83 -13.25 -15.88 -15.88 -15.88 -15.88 <-Median-> 5 Current Liability Cov Ratio
Asset Efficiency Ratio 1.11% 1.11% 1.33% 0.84% 1.18% 1.35% -4.70% -11.26% -11.46% -9.49% -3.81% -7.07% CFO / Total Assets
5 year Median 1.11% 1.11% 1.11% 1.18% 1.18% 0.84% -4.70% -9.49% -9.49% -9.49% -9.5% <-Median-> 5 Return on Assets 
Return on Assets ROA 1.0% 1.0% 0.9% 0.9% 1.3% 1.2% 0.6% 0.7% 0.8% 0.8% 0.7% 0.7% Net  Income/Assets Return on Assets
5Yr Median 1.0% 1.0% 1.0% 1.0% 1.0% 1.0% 0.9% 0.9% 0.8% 0.8% 0.7% 0.7% 0.7% <-Median-> 5 Asset Efficiency Ratio
Return on Equity ROE 15.9% 18.3% 15.3% 14.6% 13.8% 12.8% 14.6% 16.2% 15.9% 15.2% 14.9% 14.2% Net Inc/ Shareholders' equity Return on Equity
5Yr Median 13.9% 14.9% 15.3% 15.3% 15.3% 14.6% 14.6% 14.6% 14.6% 15.2% 15.2% 15.2% 15.2% <-Median-> 5 Return on Equity
$159.21 <-12 mths 15.09%
Net Income $19.76 $27.34 $31.17 $38.61 $51.44 $54.27 $62.20 $81.20 $93.53 $106.72 $125.87 $138.33 $152 $157 $175 406.00% <-Total Growth 10 Net Income
Increase 31.91% 38.37% 14.02% 23.87% 33.22% 5.50% 14.62% 30.55% 15.18% 14.10% 17.94% 9.90% 9.88% 3.29% 11.46% EPS/CF Ratio should not be higher than 1.00
5 Yr Running Average $16.5 $20.5 $26.4 $33.7 $40.6 $47.5 $57.5 $68.5 $79.6 $93.9 $109.1 $123.3 $136.0 $149.6 17.60% <-IRR #YR-> 10 Net Income
Operating Cash Flow $26.06 $24.38 $43.95 $31.37 $44.80 $57.03 $12.09 -$139.28 -$278.25 -$57.06 $243.90 -$20.63 17.33% <-IRR #YR-> 5 Net Income
Investment Cash Flow -$432.29 -$580.49 -$885.47 -$613.43 $626.53 -$826.68 $12.04 $290.15 $189.38 $44.73 -$19.80 $6.75 20.78% <-IRR #YR-> 10 5 Yr Running Average
Total Accruals $425.99 $583.44 $872.70 $620.68 -$619.89 $823.92 $38.06 -$69.67 $182.40 $119.04 -$98.24 $152.21 18.08% <-IRR #YR-> 5 5 Yr Running Average
Total Assets $2,012 $2,626 $3,410 $4,088 $3,846 $4,453 $10,257 $11,601 $11,816 $12,855 $17,148 $18,974 Balance Sheet Assets
Accruals Ratio 21.17% 22.22% 25.60% 15.18% -16.12% 18.50% 0.37% -0.60% 1.54% 0.93% -0.57% 0.80% 0.80% <-Median-> 5 Ratio
EPS/CF Ratio 0.87 0.93 0.69 1.20 1.10 0.84 -0.12 -0.06 -0.07 -0.08 -0.18 -0.10 -0.06 <-Median-> 10 EPS/CF Ratio
-$27.3 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $138.3
-$62.2 $0.0 $0.0 $0.0 $0.0 $138.3
-$16.5 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $109.1
-$47.5 $0.0 $0.0 $0.0 $0.0 $109.1
Change in Close 10.46% 26.83% -7.85% -59.13% 80.85% 17.60% 0.04% 30.60% 55.47% 29.37% -21.58% 17.40% -3.94% 0.00% 0.00% Count 14 Years of data
up/down down down down down down up down Count 8 57.14%
Meet Prediction? yes yes yes % right Count 4 50.00%
Financial Cash Flow $443.50 $586.73 $749.61 $616.26 -$325.62 $537.62 -$8.54 $57.73 -$46.93 -$1.26 -$30.80 $34.69 C F Statement  Financial Cash Flow
Total Accruals -$17.52 -$3.29 $123.09 $4.42 -$294.28 $286.31 $46.60 -$127.40 $229.33 $120.30 -$67.44 $117.52 Accruals
Accruals Ratio -0.87% -0.13% 3.61% 0.11% -7.65% 6.43% 0.45% -1.10% 1.94% 0.94% -0.39% 0.62% 0.62% <-Median-> 5 Ratio
Cash $77.21 $107.84 $15.93 $50.12 $395.84 $163.80 $170.85 $379.45 $243.65 $230.06 $423.37 $444.18 $811.47 Cash
Cash per Share $6.55 $9.04 $1.23 $3.37 $26.56 $10.96 $11.38 $24.98 $15.87 $14.90 $27.25 $26.99 $49.25 $24.98 <-Median-> 5 Cash per Share
Percentage of Stock Price 26.64% 28.99% 4.28% 28.66% 124.98% 43.86% 45.50% 76.51% 31.26% 22.70% 52.91% 44.63% 84.79% 44.63% <-Median-> 5 % of Stock Price
Notes:
October 22, 2017.  Last estimates were for 273M, $308M and $342M for Net Income Income, $8.07, $9.02 and $9.68 for EPS and $127M, $142M and $153M for Net Income.
October 25, 2016.  Last estimates were for 2015, 2016 and 2017 of $241, $269 and $303 for Net Interest Income, $7.52, $8.01 and $8.88 for EPS and $117, $125 and $139 for Net Income.
November 25, 2015.  Last estimates were for 2014, 2015 and 2016 of $205M, $230M and $261M for Net Income, $6.54, $7.38 and $8.50 for EPS, $103M, $115M and $133M for Net Income.
October 20, 2014.  Last estimates were for 2013, 2014 and 2015 of $172.5M, $194.4M and $222.0M for Net Interest Income and $5.60, $6.17 and $7.13 for EPS
Aug 29, 2013.  Symbol Change from ETC to EQB for this stock effective September 3, 2013.
The change to the ticker symbol follows the conversion of Equitable's wholly owned subsidiary, The Equitable Trust Company, to a Schedule I Bank called Equitable Bank in English and Banque Équitable in French effective July 1st, 2013.
Company went publis in 2004 (March).
Equitable Bank is a wholly owned subsidiary of Equitable Group. It was founded in 1970 as The Equitable Trust Company.
Sector:
Financial Service, Financials
What should this stock accomplish?
Would I buy this company and Why.
If I was looking for an financial services stock, I would consider this stock.  It is an unusal bank and it is a dividend growth stock. 
Why am I following this stock. 
I had read a glowing report on investing on this company in 2013, so I decided to check it out.  It was interesting as it was loaning money to new immigrants, a class of people who generally have a 
difficult time getting loans and mortgages from our regular banks.  It sounded intriguing.
Dividends
Cycle 1,  where payment is in January, April, July and October. Dividends are declared in one month for the shareholders of record and paid in the following month.  
For example, the dividend declared for shareholders of record of June 13, 2014 was payable on July 3, 2014.
How they make their money.
Equitable Group Inc. is a niche mortgage lender. The company's primary business is first charge mortgage financing, which offer through company's wholly owned subsidiary, Equitable Bank (formerly The Equitable Trust Company). 
Equitable Bank is a Schedule I bank pursuant to the Bank Act, it actively originates mortgages across Canada and serves single family, small & large commercial borrowers.
For most ratios, lower is better when looking for a good stock price.  However, there are exceptions such as for yield (dividends and erarnings) 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.
Shares; '%, Value $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M
Date 2013 Oct 20 2014 Oct 25 2015 Oct 26 2016 Oct 22 2017
Moor, Andrew 0.080 0.52% 0.093 0.60% 0.000 0.00% 0.141 0.86%
CEO - Shares - Amount $5.232 $4.780 $0.000 $8.190
Options - percentage 0.260 1.69% 0.286 1.84% 0.000 0.00% 0.272 1.65%
Options - amount $17.086 $14.750 $0.000 $15.784
Wilson, Timothy James 0.000 0.00% 0.003 0.02% 0.000 0.00% 0.003 0.02%
CFO - Shares - Amount $0.021 $0.134 $0.000 $0.161
Options - percentage 0.059 0.39% 0.061 0.39% 0.000 0.00% 0.077 0.47%
Options - amount $3.907 $3.149 $0.000 $4.475
Braude, Aviva 0.000 0.00% 0.002 0.01%
Officer - Shares - Amount $0.000 $0.121
Options - percentage 0.000 0.00% 0.005 0.03%
Options - amount $0.000 $0.304
Cole, Michelle Lynn 0.000 0.00% 0.000 0.00%
Officer - Shares - Amount $0.000 $0.001
Options - percentage 0.006 0.04% 0.006 0.04%
Options - amount $0.394 $0.309
Downie, David 0.020 0.13% 0.025 0.16%
Officer - Shares - Amount $1.333 $1.285
Options - percentage 0.013 0.09% 0.010 0.06%
Options - amount $0.877 $0.519
Beutel, Eric Marshall 2.007 13.00% 2.007 12.91% 0.000 0.00% 2.009 12.19%
Director - Shares - Amount $131.767 $103.335 $0.000 $116.683
Options - percentage 0.004 0.03% 0.005 0.03% 0.000 0.00% 0.006 0.04%
Options - amount $0.293 $0.258 $0.000 $0.363
LeGresley, David Malcolm Balfour 0.017 0.11% 0.017 0.11% 0.000 0.00% 0.016 0.10%
Chairman - Shares - Amt $1.116 $0.876 $0.000 $0.935
Options - percentage 0.002 0.02% 0.004 0.02% 0.000 0.00% 0.006 0.04%
Options - amount $0.152 $0.187 $0.000 $0.374
Increase in O/S Shares 0.142 0.94% 0.142 0.92% 0.070 0.45% 0.103 0.66% 0.112 0.68%
due to SO $4.648 $7.194 $4.590 $5.317 $6.769
Book Value $3.636 $2.896 $1.746 $2.473 $2.877
Insider Buying -$0.393 -$0.299 -$0.326
Insider Selling $0.628 $2.516 $1.902
Net Insider Selling $8.001 $0.235 $2.217 $1.576
% of Market Cap 0.79% 0.03% 0.22% 0.16%
Directors 10 10 10 10
Women 3 30% 3 30% 3 30% 3 30%
Minorities 0 0% 0 0% 0 0% 1 10% Indian Male
Institutions/Holdings 0 0.00% 31 45.69% 35 48.31% 44 39.13%
Total Shares Held 0.000 0.00% 7.068 45.79% 7.520 45.69% 6.448 39.13%
Increase/Decrease 0.000 #DIV/0! -0.059 -0.82% 0.038 0.51% -0.037 -0.57%
Starting No. of Shares 0.000 7.126 7.482 6.485
Copyright © 2008 Website of SPBrunner. All rights reserved.