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. 6/30/11
See my website on stocks or see my blog at the following sites.  www.spbrunner.com/stocks.html www.spbrunner.blogspot.com/
ARC Resources Ltd. www.arcresources.com TSX: ARX Fiscal Yr: Dec 31 YR 2011 YR 2012
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 #Y
Accting rules C GAAP IFRS
Revenue* $155.2 $316.3 $515.5 $444.8 $731.2 $901.8 $1,165.2 $1,230.5 $1,251.6 $1,706.4 $978.2 $1,213.7 $1,398.0 $1,601.0 283.75% <-Total Growth 10
Increase 131.21% 103.79% 62.99% -13.71% 64.38% 23.32% 29.21% 5.60% 1.71% 36.34% -42.67% 24.07% 15.18% 14.52% 14.39% <-IRR #YR-> 10 Revenue
Rev per Share $2.90 $4.36 $4.66 $3.61 $4.09 $4.85 $5.85 $6.02 $5.95 $7.78 $4.13 $4.27 $4.92 $5.63 0.82% <-IRR #YR-> 5 Revenue
P/S (Price/Sales) 3.06 2.61 2.52 3.35 3.47 3.67 4.53 3.70 3.43 2.58 4.82 5.95 4.29 3.74 -0.22% <-IRR #YR-> 10 Per Share
*Revenue in M CDN $ before Royalties P/S 10 yr  3.57 5 yr  3.70 -6.12% <-IRR #YR-> 5 Per sahre
-$316.3 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $1,213.7
-$1,165.2 $0.0 $0.0 $0.0 $0.0 $1,213.7
Payout R Dis 77.6% 71.3% 90.6% 83.4% 70.3% 73.5% 59.4% 66.9% 71.6% 61.1% 61.6% 50.6% 42.7% -6.69% <-IRR #YR-> 5 Distri Cash
EPS* $0.64 $1.74 $1.38 $0.59 $1.82 $1.31 $1.90 $2.28 $2.39 $2.50 $0.96 $0.99 $1.32 $1.14 -43.10% <-Total Growth 10 Earnings
Increase -216.36% 171.88% -20.69% -57.25% 208.47% -28.02% 45.04% 20.00% 4.82% 4.60% -61.60% 3.13% 33.33% -13.64% -5.48% <-IRR #YR-> 10 Earnings
Earnings Yield 7.2% 15.3% 11.8% 4.9% 12.8% 7.4% 7.2% 10.2% 11.7% 12.4% 4.8% 3.9% 6.3% 5.4% -12.22% <-IRR #YR-> 5 Earnings
* ESP per share (Cdn GAAP) E/P 10 Yrs 8.79% 5Yrs 10.22%
-$1.74 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.99
-$1.90 $0.00 $0.00 $0.00 $0.00 $0.99
Distri* $1.35 $2.01 $2.31 $1.56 $1.80 $1.80 $1.99 $2.40 $2.40 $2.67 $1.30 $1.20 $1.20 $1.20 -40.30% <-Total Growth 10 Dividends
Increase 12.50% 48.89% 14.93% -32.47% 15.38% 0.00% 10.56% 20.60% 0.00% 11.25% -51.31% -7.69% 0.00% 0.00% 5.28% <-Median-> 10 Dividends
Yield H/L 17.59% 19.66% 19.50% 12.78% 14.16% 11.11% 8.99% 9.50% 11.23% 10.91% 7.73% 5.33% 11.01% <-Median-> 10 Dividends
Yield on High 14.75% 16.82% 17.50% 11.76% 12.69% 10.10% 7.32% 7.87% 10.06% 7.86% 5.94% 4.62% 8.97% <-Median-> 10 Dividends
Yield on Low 21.77% 23.65% 22.02% 13.98% 16.00% 12.34% 11.64% 11.99% 12.70% 17.79% 11.08% 6.30% 12.52% <-Median-> 10 Dividends
Yield on Cl 15.25% 17.63% 19.68% 12.89% 12.69% 10.10% 7.51% 10.76% 11.76% 13.28% 6.53% 4.72% 5.70% 5.70% 11.26% <-Median-> 10 Dividends
Payout Ratio 210.9% 115.5% 167.4% 264.4% 98.9% 137.4% 104.7% 105.3% 100.4% 106.8% 135.4% 121.2% 90.9% 105.3% 114.01% <-Median-> 10 Dividends
Payout Ratio 103.9% 87.9% 100.6% 85.5% 79.4% 74.9% 64.2% 66.8% 71.6% 62.0% 61.8% 50.6% 39.2% 38.7% 69.19% <-Median-> 10 Dividends
Average 5 Yrs Div Yd 6.60% 5 7.65% 10 Yield  9.50% 10.76% Payout 106.80% 61.97% -5.03% <-IRR #YR-> 10 Dividends
* Dividends per share. 3.0% Years 3.0% Years Last Div Inc ---> $0.12 $0.10 -16.7% -9.62% <-IRR #YR-> 5 Dividends
-$2.01 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.20
-$1.99 $0.00 $0.00 $0.00 $0.00 $1.20
H/LYield held 5 yrs 20.22% 13.33% 21.18% 23.45% 19.46% 20.26% 19.66% 21.00% 8.02% 5.42% 4.75% 5.61% 19.94% <-Median-> 10 Dividends
H/LYield held 10 yrs 21.01% 20.51% 31.41% 16.94% 11.74% 10.13% 9.83% 20.51% <-Median-> 5 Dividends
Graham No. $9.33 $16.13 $15.16 $9.74 $18.63 $15.49 $19.65 $21.78 $22.61 $23.21 $14.61 $15.82 $18.31 $17.01 -1.97% <-Total Growth 10 Graham Price
Prem /Disc.Med H/L -17.73% -36.63% -21.84% 25.39% -31.75% 4.59% 12.70% 15.95% -5.46% 5.46% 15.05% 42.31% 9.08% <-Median-> 10 Graham Price
Prem /Disc. High -1.92% -25.94% -12.90% 36.17% -23.89% 15.02% 38.43% 40.01% 5.48% 46.26% 49.82% 64.19% 37.30% <-Median-> 10 Graham Price
Prem /Disc. Low -33.54% -47.32% -30.78% 14.61% -39.62% -5.83% -13.02% -8.11% -16.41% -35.34% -19.72% 20.44% -14.72% <-Median-> 10 Graham Price
Prem /Disc. Cl -5.14% -41.53% -29.09% 19.52% -31.39% 13.05% 25.88% 2.35% -10.83% -15.48% 26.62% 37.75% 13.12% 19.26% 7.70% <-Median-> 10 Graham Price
Price Cl $8.85 $11.40 $11.74 $12.10 $14.18 $17.82 $26.51 $22.30 $20.40 $20.10 $19.91 $25.41 $21.07 $21.07 122.89% <-Total Growth 10 Stock Price
Increase 45.08% 28.81% 2.98% 3.07% 17.19% 25.67% 48.77% -15.88% -8.52% -1.47% -0.95% 27.62% -17.08% 0.00% 8.35% <-IRR #YR-> 10 Stock Price
P/E 13.83 6.55 8.51 20.51 7.79 13.60 13.95 9.78 8.54 8.04 20.74 25.67 15.96 18.48 -0.84% <-IRR #YR-> 5 Stock Price
Trailing P/E -16.09 17.81 6.75 8.77 24.03 9.79 20.24 11.74 8.95 8.41 7.96 26.47 21.28 15.96 21.65% <-IRR #YR-> 10 Price & Div
Median 5 Yrs 7.82% 13.30% Div %  5, 10 yrs Price Inc -1.5% P/E: Y-T 9.8 8.9 6.97% <-IRR #YR-> 5 Price & Div
-$11.40 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $25.41
-$26.51 $0.00 $0.00 $0.00 $0.00 $25.41
-$11.40 $2.31 $1.56 $1.80 $1.80 $1.99 $2.40 $2.40 $2.67 $1.30 $26.61
-$26.51 $2.40 $2.40 $2.67 $1.30 $26.61
Price H/L Median $7.68 $10.23 $11.85 $12.21 $12.72 $16.21 $22.15 $25.25 $21.38 $24.48 $16.81 $22.51 120.15% <-Total Growth 10 Stock Price
Increase -9.71% 33.22% 15.84% 3.08% 4.14% 27.45% 36.66% 14.02% -15.35% 14.53% -31.33% 33.91% 8.21% <-IRR #YR-> 10 Stock Price
P/E 11.99 5.88 8.58 20.69 6.99 12.37 11.66 11.07 8.94 9.79 17.51 22.74 0.33% <-IRR #YR-> 5 Stock Price
Trailing P/E -13.95 15.98 6.81 8.85 21.55 8.90 16.90 13.29 9.38 10.24 6.72 23.45 23.22% <-IRR #YR-> 10 Price & Div
Median 5 Yrs 9.23% 15.01% Div %  5, 10 yrs Price Inc 14.0% P/E: Y-T 11.1 10.2 9.56% <-IRR #YR-> 5 Price & Div
-$10.23 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $22.51
-$22.15 $0.00 $0.00 $0.00 $0.00 $22.51
-$10.23 $2.31 $1.56 $1.80 $1.80 $1.99 $2.40 $2.40 $2.67 $1.30 $23.71
-$22.15 $2.40 $2.40 $2.67 $1.30 $23.71
Hi Mths Sep Sep May Apr Dec Dec Dec Aug May Jun Oct Dec
Price Hi $9.15 $11.95 $13.20 $13.26 $14.18 $17.82 $27.20 $30.49 $23.85 $33.95 $21.89 $25.97 117.32% <-Total Growth 10 Stock Price
Increase -16.06% 30.60% 10.46% 0.45% 6.94% 25.67% 52.64% 12.10% -21.78% 42.35% -35.52% 18.64% 8.07% <-IRR #YR-> 10 Stock Price
P/E 14.30 6.87 9.57 22.47 7.79 13.60 14.32 13.37 9.98 13.58 22.80 26.23 -0.92% <-IRR #YR-> 5 Stock Price
Trailing P/E -16.64 18.67 7.59 9.61 24.03 9.79 20.76 16.05 10.46 14.21 8.76 27.05
Median 5 Yrs Price Inc 12.1% P/E: Y-T 13.6 14.2
-$11.95 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $25.97
-$27.20 $0.00 $0.00 $0.00 $0.00 $25.97
Low Mths Mar Jan-Mar Sep/Nov Dec Mar Jun Mar Dec Nov Oct Mar  Aug
Price Low $6.20 $8.50 $10.49 $11.16 $11.25 $14.59 $17.09 $20.01 $18.90 $15.01 $11.73 $19.05 124.12% <-Total Growth 10 Stock Price
Increase 1.64% 37.10% 23.41% 6.39% 0.81% 29.69% 17.14% 17.09% -5.55% -20.58% -21.85% 62.40% 8.40% <-IRR #YR-> 10
P/E 9.69 4.89 7.60 18.92 6.18 11.14 8.99 8.78 7.91 6.00 12.22 19.24 2.20% <-IRR #YR-> 5
Trailing P/E -11.27 13.28 6.03 8.09 19.07 8.02 13.05 10.53 8.29 6.28 4.69 19.84
Median 5 Yrs Price Inc -5.5% P/E: Y-T 8.8 8.3
-$8.50 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $19.05
Market Cap $474 $827 $1,299 $1,492 $2,535 $3,311 $5,278 $4,556 $4,289 $4,406 $4,711 $7,226 $5,992 $5,992
# of Sh in M 53.607 72.524 110.609 123.305 178.780 185.822 199.104 204.289 210.232 219.200 236.615 284.379 284.379 284.379 Unit Holders Capital Shares
Increase 109.37% 35.29% 52.51% 11.48% 44.99% 3.94% 7.15% 2.60% 2.91% 4.27% 7.94% 20.19% 0.00% 0.00% 15.80% <-Average 10 Shares
CF fr Op $M 69.7 165.9 253.9 225.0 405.3 446.4 616.7 734.0 704.9 944.4 497.4 673.9 870.2 881.6 Cash Flow
OPS $1.30 $2.29 $2.30 $1.82 $2.27 $2.40 $3.10 $3.59 $3.35 $4.31 $2.10 $2.37 $3.06 $3.10 3.59% <-Total Growth 10 Cash Flow
Non-Cash CF $11.2 $13.4 $6.4 -$1.0 -$9.1 -$1.6 $17.9 $16.0 $5.7 -$20.3 $11.9 -$1.1 $0.0 $0.0 0.35% <-IRR #YR-> 10 Cash Flow
OPS non-cash $1.51 $2.47 $2.35 $1.82 $2.22 $2.39 $3.19 $3.67 $3.38 $4.22 $2.15 $2.37 $3.06 $3.10 -5.22% <-IRR #YR-> 5 Cash Flow
P/O on Cl 5.87 4.61 4.99 6.66 6.40 7.44 8.32 6.07 6.04 4.77 9.25 10.74 6.89 6.80 -0.44% <-IRR #YR-> 10 Cash Flow
*Operational Cash Flow per share P/CF 10 Yrs 7.07 5 Yrs 7.37 -5.79% <-IRR #YR-> 5 Cash Flow
-$2.29 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.37
-$3.10 $0.00 $0.00 $0.00 $0.00 $2.37
-$2.47 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.37
-$3.19 $0.00 $0.00 $0.00 $0.00 $2.37
OPM 44.89% 52.46% 49.25% 50.57% 55.42% 49.50% 52.93% 59.65% 56.32% 55.34% 50.85% 55.52% should be zero, it is a check on calculations
Increase -17.08% -3.10% -9.03% -6.58% 2.38% -8.56% -2.23% 10.19% 4.03% 2.23% -6.07% 2.56% 0.00 <-Median-> 10 OPM
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 54.14% 5 Yrs 55.52%
Curr Assets $43.19 $52.14 $58.55 $57.43 $91.46 $109.47 $140.10 $176.70 $201.60 $195.10 $147.10 $243.10 $200.40 Liq ratio of 1.5 and up, best Assets
Curr Liab. $27.42 $45.81 $52.75 $67.50 $130.18 $166.52 $195.59 $237.40 $280.30 $250.40 $203.30 $273.50 $353.40 0.73 <-Median-> 10 Liabilities
Liquidity 1.57 1.14 1.11 0.85 0.70 0.66 0.72 0.74 0.72 0.78 0.72 0.89 0.57 0.74 <-Median-> 5 Ratio
Assets $505.62 $662.85 $1,382.1 $1,494.6 $2,281.7 $2,305.0 $3,251.2 $3,479.0 $3,533.0 $3,766.7 $3,914.5 $4,946.5 $5,053.4 A/L ratio of 1.5 and up, best Assets
Liab. $181.61 $180.60 $563.88 $613.90 $729.9 $755.6 $1,415.6 $1,550.6 $1,491.3 $1,624.6 $1,540.1 $1,752.4 $1,844.6 2.44 <-Median-> 10 Liabilities
Liquidity 2.78 3.67 2.45 2.43 3.13 3.05 2.30 2.24 2.37 2.32 2.54 2.82 2.74 2.37 <-Median-> 5 Ratio
Liab. Inc NCI CK $564 $614 $766 $792 $1,752 $1,845
Non-Cont Int $0 $0 $0 $0 $36 $36 $38 $40 $43 $42 $36 $0 $0
Book Value $324 $482 $818 $881 $1,515 $1,513 $1,798 $1,888 $1,999 $2,100 $2,338 $3,194 $3,209 562.33% <-Total Growth 10 Book Value
BV per share $6.04 $6.65 $7.40 $7.14 $8.48 $8.14 $9.03 $9.24 $9.51 $9.58 $9.88 $11.23 $11.28 $11.28 68.91% <-Total Growth 10 Book Value
Change -7.51% 10.02% 11.24% -3.44% 18.67% -3.92% 10.89% 2.36% 2.84% 0.76% 3.17% 13.65% 0.46% 0.8799 Current/Historical Book Value
P/BV (CL) 1.46 1.71 1.59 1.69 1.67 2.19 2.94 2.41 2.15 2.10 2.01 2.26 1.87 5.38% <-IRR #YR-> 10 Book Value
Change 56.86% 17.09% -7.42% 6.73% -1.25% 30.80% 34.16% -17.82% -11.05% -2.21% -3.99% 12.29% -17.46% 4.46% <-IRR #YR-> 5 Book Value
Leverage (A/BK) 1.56 1.37 1.69 1.70 1.51 1.52 1.81 1.84 1.77 1.79 1.67 1.55 1.57 1.69 <-Median-> 10 A/BV
Debt/Equity Ratio 0.56 0.37 0.69 0.70 0.48 0.50 0.79 0.82 0.75 0.77 0.66 0.55 0.57 0.69 <-Median-> 10 Debt/Eq Ratio
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Ave 2.12 5 yr Ave 2.15
-$6.65 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $11.23
-$9.03 $0.00 $0.00 $0.00 $0.00 $11.23
ROE 24.4% 24.4% 25.6% 9.5% 8.2% 8.3% <-12 mths 24.36% <-Median-> 5 Compreh. Inc
Comprehensive Inc $460.10 $487.50 $537.80 $222.60 $261.30 $267.60 <-12 mths Compreh. Inc
ROE 9.2% 23.0% 17.2% 8.1% 19.1% 16.0% 19.9% 24.4% 24.8% 25.4% 9.5% 8.2% 12.3% <-12 mths Net Income/Shareholders' equity
5Yr Median 8.8% 9.2% 9.2% 17.2% 17.2% 17.2% 19.1% 19.9% 24.4% 24.4% 24.4% 12.3% <-12 mths
Net Income $29.84 $110.87 $140.69 $71.05 $290.20 $241.69 $356.94 $460.10 $495.30 $533.00 $222.80 $260.80 $395.80 <-12 mths 135.23% <-Total Growth 10 Net Income
Oper C. F. $69.67 $165.91 $253.87 $224.97 $405.28 $446.42 $616.71 $734.00 $704.90 $944.40 $497.40 $673.90 $680.60 <-12 mths C F Statement  Oper C. F.
Invest. C. F -$35.60 -$206.36 -$122.47 -$206.05 -$192.16 -$179.77 -$861.63 -$510.70 -$413.80 -$555.90 -$551.20 -$566.80 -$456.90 <-12 mths C F Statement  Invest. C. F
Accruals    -$4.23 $151.33 $9.28 $52.13 $77.08 -$24.96 $601.86 $236.80 $204.20 $144.50 $276.60 $153.70 $172.10 <-12 mths Accruals
Total Assets $505.62 $662.85 $1,382.1 $1,494.6 $2,281.7 $2,305.0 $3,251.2 $3,479.0 $3,533.0 $3,766.7 $3,914.5 $4,946.5 $5,053.4 <-12 mths Balance Sheet Assets
Accruals Ratio -0.84% 22.83% 0.67% 3.49% 3.38% -1.08% 18.51% 6.81% 5.78% 3.84% 7.07% 3.11% 3.41% <-12 mths Ratio
Fin C. F. $240.50 -$220.50 -$286.90 -$355.50 $13.80 -$106.80 -$351.80 <-12 mths C F Statement  Fin. C. F
Accruals    $361.36 $457.30 $491.10 $500.00 $262.80 $260.50 $523.90 <-12 mths Accruals
Accruals Ratio 11.11% 13.14% 13.90% 13.27% 6.71% 5.27% 10.37% <-12 mths Ratio
Sep 25, 2011.  Estimates I got for 2010 and 2011 when I last looked were $2.44 and $2.81 for distributable income, $1.18 and $1.22 for earnings and $2.61 and $3.09 for CF.
Company was converted from an Income Trust ARC Energy Trust (TSX-AET.UN) To ARC Resources Ltd. (TSX-ARX), January 2011.
Aug 24, 2010.  When I last looked, I got 2010 and 2011 Distri CF of $2.44 and $2.81, Earnings of $1.05 and $1.22 and CF of $2.70 and $2.90 and Dis of $1.20 and $1.20.
The company expects to convert to a corporation in 2011 with distribution depending on commodities prices.
Apr 28, 2010.  I last got estimates for 2009 and 2010 for Distributable Cash of $2.08 and $1.92, earnings of $.53 and $1.05 and cash flow of $2.00 and $2.80.
In May 2009 when I looked for DI, I got, for 2009 and 2010 $1.85 and $2.80. For earnings I got $.26 and $1.01.  For Cash Flow I got $1.85 and $2.80.
May 11, 2009 AR 2008.  when I looked at this stock in Jan 2009, I got Distributable cash flow of $4.35 and earnings of $2.48 and they came at $4.37 and $2.50.  Close.
Formed in 1966 as an Income Trust.  The shares are always increasing due to dividend reinvestment program.
 Dividends can vary due to the price of oil.
How they make their money.
ARC Resources Ltd. is one of Canada's leading conventional oil and gas companies. Its focus is on acquiring and developing long-life oil and gas properties across western Canada. 
Industry: Oil and Gas (Oil and Gas Producers) 
Taxes
Foreign 0% 0% 0% 0% 0% 0% 0% 0% 0% 0.00% <-Average 8
Cap Gain 0% 0% 0% 0% 0% 0% 0% 0% 0% 0.00% <-Average 8
Taxable Inc 21% 45% 68% 68% 85% 94% 98% 98% 97% 81.63% <-Average 8
Ret of Cap. 79% 55% 32% 32% 15% 6% 2% 2% 3% 18.38% <-Average 8
Total 100% 100% 100% 100% 100% 100% 100% 100% 100%
For Tax Cr
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.