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/ Q1 2017
Obsidian Energy Ltd TSX: OBE NYSE: OBE www.obsidianenergy.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 Total G Currency
Accounting Rules C GAAP IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS IFRS Accounting Rules
$538 <-12 mths -11.51%
Revenue less Royalities $2,059 $1,059 $586
Revenue* $589.3 $1,770.4 $1,829.0 $4,413.0 $4,413.0 $3,054 $3,667 $3,235 $2,829 $2,433 $1,187 $608 $436 $505 $488 -65.66% <-Total Growth 10 Revenue CDN$
Increase 60.08% 200.41% 3.31% 141.28% 0.00% -30.80% 20.07% -11.78% -12.55% -14.00% -51.21% -48.78% -28.29% 15.83% -3.37% -10.14% <-IRR #YR-> 10 Revenue -65.66% CDN$
5 year Running Average $335 $651 $973 $1,794 $2,603 $3,096 $3,475 $3,756 $3,440 $3,044 $2,670 $2,058 $1,499 $1,034 $645 -30.19% <-IRR #YR-> 5 Revenue -83.42% CDN$
Revenue per Share $9.87 $7.47 $7.54 $11.42 $10.47 $6.64 $7.78 $6.75 $5.78 $4.89 $2.36 $1.21 $0.87 $1.00 $0.97 12.20% <-IRR #YR-> 10 5 yr Running Average 216.05% CDN$
Increase 16.93% -24.36% 0.95% 51.48% -8.33% -36.52% 17.09% -13.23% -14.31% -15.42% -51.68% -48.84% -28.29% 15.83% -3.37% -9.94% <-IRR #YR-> 5 5 yr Running Average -40.77% CDN$
5 year Running Average $7.94 $7.93 $8.08 $8.95 $9.35 $8.71 $8.77 $8.61 $7.48 $6.37 $5.51 $4.20 $3.02 $2.07 $1.28 -16.64% <-IRR #YR-> 10 Revenue per Share -83.80% CDN$
P/S (Price/Sales) Med 3.28 5.28 6.79 2.13 1.36 3.16 2.74 2.40 1.89 1.34 0.83 1.36 -31.08% <-IRR #YR-> 5 Revenue per Share -84.45% CDN$
P/S (Price/Sales) Close 3.46 4.76 5.36 1.19 1.77 3.59 2.60 1.56 1.53 0.50 0.49 1.96 1.73 1.49 2.26 -6.15% <-IRR #YR-> 10 5 yr Running Average -47.01% CDN$
*Sales net of Royalities in M CDN $ P/S 10 yr 1.67 5 yr 1.53 3.67% Diff M/C -13.69% <-IRR #YR-> 5 5 yr Running Average -52.10% CDN$
-$1,770 $0 $0 $0 $0 $0 $0 $0 $0 $0 $608
-$3,667 $0 $0 $0 $0 $608
-$651 $0 $0 $0 $0 $0 $0 $0 $0 $0 $2,058
-$3,475 $0 $0 $0 $0 $2,058
-$7.47 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.21
-$7.78 $0.00 $0.00 $0.00 $0.00 $1.21
-$7.93 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4.20
-$8.77 $0.00 $0.00 $0.00 $0.00 $4.20
-$0.43 <-12 mths -219.44%
Funds Flow Diluted $2.03 $1.89 $0.36 $0.36
Funds Flow $6.40 $5.78 $5.51 $6.66 $3.60 $2.65 $3.29 $2.62 $2.03 $1.89 $0.36 $0.36 -93.77% <-Total Growth 10 FFO CDN$
Increase 43.28% -9.69% -4.67% 20.87% -45.95% -26.39% 24.15% -20.36% -22.52% -6.90% -80.95% 0.00% -24.24% <-IRR #YR-> 10 FFO -93.77% CDN$
FFO Yield 18.7% 16.2% 13.6% 49.1% 19.4% 11.1% 16.3% 24.8% 22.9% 77.8% 30.8% 15.2% -35.76% <-IRR #YR-> 5 FFO -89.06% CDN$
5 year Running Average $5.08 $5.07 $5.42 $5.76 $5.59 $4.84 $4.34 $3.76 $2.84 $2.50 $2.04 $1.45 -11.76% <-IRR #YR-> 10 5 yr Running Average -71.38% CDN$
Payout Ratio 50.8% 70.1% 74.0% 61.3% 56.7% 61.1% 27.4% 41.2% 46.8% 29.6% 47.2% 0.0% -19.67% <-IRR #YR-> 5 5 yr Running Average -66.56% CDN$
Price/FFO Median 5.05 6.82 9.28 3.65 3.96 7.91 6.47 6.19 5.39 3.47 5.44 4.56 5.42 <-Median-> 10 P/FFO Med CDN$
Price/FFO High 6.07 8.13 11.34 5.32 5.34 9.18 8.54 8.39 6.53 5.73 9.22 7.00 7.70 <-Median-> 10 P/FFO High CDN$
Price/FFO Low 4.04 5.51 7.23 1.98 2.59 6.65 4.40 3.98 4.25 1.22 1.67 2.11 3.28 <-Median-> 10 P/FFO Low CDN$
Price/FFO Close 5.34 6.15 7.33 2.04 5.15 9.00 6.14 4.03 4.37 1.29 3.25 6.58 4.76 <-Median-> 10 P/FFO Close CDN$
Trailing P/E 7.65 5.56 6.98 2.46 2.79 6.62 7.62 3.21 3.39 1.20 0.62 6.58 3.30 <-Median-> 10 Trailing P/FFO Close CDN$
Median Values DPR 10 Yrs 47.01% 5 Yrs 41.22% P/CF 5 Yrs in order 5.39 7.00 2.11 4.03 -100.00% Diff M/C -100.00% Diff M/C 10 DPR 75% to 95% best
Funds Flow for Distributions to 2005, then company switched to Distributable Cash, then Fund Flows from 2011.
-$1.14 <-12 mths 17.99%
EPS Basic $3.38 $3.32 $0.73 $3.25 -$0.35 $0.51 $1.37 $0.37 -$1.67 -$3.51 -$5.27 -$1.39 -141.87% <-Total Growth 10 EPS Basic CDN$
EPS Diluted* $3.38 $3.27 $0.73 $3.22 -$0.35 $0.50 $1.36 $0.37 -$1.67 -$3.51 -$5.27 -$1.39 -$0.24 -$0.10 $0.03 -142.51% <-Total Growth 10 EPS Diluted CDN$
Increase 141.67% -3.35% -77.68% 341% -111% -243% 172% -73% -551% 110% 50% -74% -83% -58% -130% #NUM! <-IRR #YR-> 10 Earnings per Share -142.51% CDN$
Earnings Yield 9.9% 9.2% 1.8% 23.7% -1.9% 2.1% 6.7% 3.5% -18.8% -144.4% -450.4% -58.6% -16.0% -6.7% 1.4% #NUM! <-IRR #YR-> 5 Earnings per Share -202.21% CDN$
5 Year Running Ave $2.16 $2.24 $2.22 $2.40 $2.05 $1.47 $1.09 $1.02 $0.04 -$0.59 -$1.74 -$2.29 -$2.42 -$2.10 -$1.39 #NUM! <-IRR #YR-> 10 5 yr Running Average -202.38% CDN$
10 year Running Average $1.38 $1.58 $1.57 $2.52 $2.32 $1.82 $1.67 $1.62 $1.22 $0.73 -$0.14 -$0.60 -$0.70 -$1.03 -$0.99 #NUM! <-IRR #YR-> 5 5 yr Running Average -310.07% CDN$
* Diluted ESP per share E/P 10 Yrs -0.04% 5Yrs -58.65%
-$3.27 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 -$1.39
-$1.36 $0.00 $0.00 $0.00 $0.00 -$1.39
-$2.24 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 -$2.29
-$1.09 $0.00 $0.00 $0.00 $0.00 -$2.29
My Dividends
pre split 04
pre split 06 $1.95
Dividend* $3.25 $5.53 $4.08 $4.08 $2.04 $1.62 $0.90 $1.08 $0.95 $0.56 $0.17 -100.00% <-Total Growth 9 Dividends CDN$
Increase -27% 70% -26% 0% -50% -21% -44% 20% -12% -41% -70% #NUM! <-IRR #YR-> 9 Dividends CDN$
What is actually earned in dividends from Maximum Trust to Penn West #NUM! <-IRR #YR-> 4 Dividends CDN$
-$3.25 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.17
-$1.62 $0.00 $0.00 $0.00 $0.00 $0.17
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 CDN$
pre consold pre consold
pre split 06 $1.95 $1.08 pre split 06
Dividend* $3.25 $4.05 $4.08 $4.08 $2.04 $1.62 $0.90 $1.08 $0.95 $0.56 $0.17 $0.00 $0.00 $0.00 $0.00 -100.00% <-Total Growth 10 Dividends CDN$
Increase 1.56% 24.62% 0.74% 0.00% -50.00% -20.59% -44.44% 20.00% -12.04% -41.05% -69.64% -100.00% #DIV/0! #DIV/0! #DIV/0! -30.82% <-Median-> 10 Increase CDN$
Dividends 5 Yr Running $3.97 $3.37 $3.61 $3.73 $3.50 $3.17 $2.54 $1.94 $1.32 $1.02 $0.73 $0.55 $0.34 $0.15 $0.03 -83.60% <-Total Growth 10 Dividends 5 Yr Running CDN$
Yield H/L Price 10.05% 10.27% 7.97% 16.79% 14.30% 7.73% 4.23% 6.66% 8.69% 8.53% 8.67% 0.00% 0.00% 8.25% <-Median-> 10 Yield H/L Price CDN$
Yield on High Price 8.37% 8.61% 6.53% 11.52% 10.61% 6.66% 3.20% 4.91% 7.17% 5.17% 5.12% 0.00% 0.00% 5.85% <-Median-> 10 Yield on High Price CDN$
Yield on Low Price 12.58% 12.72% 10.24% 30.98% 21.91% 9.20% 6.21% 10.35% 11.02% 24.35% 28.33% 0.00% 0.00% 10.69% <-Median-> 10 Yield on Low Price CDN$
Yield on Close Price 9.52% 11.39% 10.11% 30.07% 11.00% 6.80% 4.46% 10.23% 10.71% 23.05% 14.53% 0.00% 0.00% 0.00% 0.00% 10.47% <-Median-> 10 Yield on Close Price CDN$
Payout Ratio EPS 96.1% 123.9% 558.9% 126.7% -583% 324% 66.18% 291.89% -56.89% -15.95% -3.23% 0.00% 0.00% 0.00% 0.00% 33.09% <-Median-> 10 DPR EPS CDN$
DPR EPS 5 Yr Running 184.08% 150.25% 162.49% 155.46% 170.68% 215.33% 232.97% 190.59% 3138.10% -173.22% -41.97% -24.06% -13.91% -6.95% -2.44% 166.58% <-Median-> 10 DPR EPS 5 Yr Running CDN$
Payout Ratio CFPS 57.54% 86.81% 79.73% 69.90% 61.39% 61.19% 30.15% 43.39% 48.00% 32.84% 48.78% 0.00% 0.00% 0.00% 0.00% 48.39% <-Median-> 10 DPR CF CDN$
DPR CF 5 Yr Running 85.17% 73.63% 70.93% 69.49% 71.17% 73.51% 63.89% 56.25% 49.09% 43.28% 38.50% 44.16% 40.87% 29.07% 13.54% 60.07% <-Median-> 10 DPR CF 5 Yr Running CDN$
Payout Ratio CFPS WC 57.54% 83.52% 77.35% 64.31% 60.23% 65.78% 29.14% 44.78% 50.56% 31.65% 59.28% 0.00% 0.00% 0.00% 0.00% 54.92% <-Median-> 10 DPR CF WC CDN$
DPR CF WC 5 Yr Running 85.17% 73.04% 69.99% 67.36% 68.62% 71.11% 61.88% 54.93% 49.81% 44.01% 38.79% 44.03% 39.95% 26.97% 12.25% 58.40% <-Median-> 10 DPR CF WC 5 Yr Running CDN$
Median Values Yield H/L 8.53% 10.71% Payout -3.23% 43.39% 44.78% #NUM! <-IRR #YR-> 10 Dividends -100.00% CDN$
* Dividends per share Curr diff -100.00% Last Div Inc ---> $0.14 $0.01 -92.9% #NUM! <-IRR #YR-> 5 Dividends -100.00% CDN$
-$4.05 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
-$0.90 $0.00 $0.00 $0.00 $0.00 $0.00
Historical Dividends Historical High Div 36.21% Low Div 3.72% Ave Div 19.97% Med Div 10.82% Close Div 11.34% Historical Dividends CDN$
High/Ave/Median Values Curr diff Exp. -100.00% Exp -100.00% Exp. -100.00% Exp. -100.00% Exp. -100.00% High/Ave/Median CDN$
Future Dividend Yield Div Yd 0.00% earning in 5.00 Years at IRR of 0.00% Div Inc. #DIV/0! Future Dividend Yield CDN$
Future Dividend Yield Div Yd 0.00% earning in 10.00 Years at IRR of 3.00% Div Inc. #DIV/0! Future Dividend Yield CDN$
Future Dividend Yield Div Yd 0.00% earning in 15.00 Years at IRR of 3.00% Div Inc. #DIV/0! Future Dividend Yield CDN$
Yield if held 5 yrs 13.53% 14.40% 20.40% 16.41% 7.25% 5.01% 2.28% 2.11% 3.91% 3.92% 0.81% 0.00% 0.00% 0.00% 0.00% 3.92% <-Median-> 10 Paid Median Price CDN$
Yield if held 10 yrs 11.30% 13.67% 16.91% 26.58% 12.81% 6.74% 3.20% 5.40% 3.82% 1.99% 0.53% 0.00% 0.00% 0.00% 0.00% 4.61% <-Median-> 10 Paid Median Price CDN$
Yield if held 15 yrs 5.63% 3.04% 4.48% 6.19% 3.52% 0.71% 0.00% 0.00% 0.00% 0.00% 3.52% <-Median-> 7 Paid Median Price CDN$
Yield if held 20 yrs 0.59% 0.00% 0.00% 0.00% 0.00% 0.30% <-Median-> 2 Paid Median Price CDN$
Cost covered if held 5 years 82.62% 59.85% 90.32% 75.04% 62.20% 49.07% 32.26% 19.00% 27.12% 35.81% 17.45% 12.96% 10.36% 6.68% 2.59% 34.03% <-Median-> 10 Paid Median Price CDN$
Cost covered if held 10 years 133.74% 134.85% 166.13% 272.05% 255.89% 148.68% 105.08% 138.92% 101.54% 80.37% 60.39% 39.25% 22.28% 30.13% 37.00% 122.00% <-Median-> 10 Paid Median Price CDN$
Cost covered if held 15 years 188.94% 177.79% 206.42% 314.98% 287.97% 163.91% 114.89% 147.32% 104.48% 80.97% 188.94% <-Median-> 7 Paid Median Price CDN$
Cost covered if held 20 years 201.67% 187.11% 213.39% 319.74% 289.04% 194.39% <-Median-> 2 Paid Median Price CDN$
Based on EPS 3 yrs trailing $28.14 $35.67 $33.83 $34.77 $32.06 $22.04 $22.18 $14.58 $16.10 $2.43 $2.43 $2.43 -93.19% <-Total Growth 10 Based on EPS 3 yrs trailing CDN$
Price/GP Ratio Med 1.15 1.11 1.51 0.70 0.45 0.95 0.96 1.11 0.68 2.70 0.81 0.68 0.88 <-Median-> 10 Price/GP Ratio CDN$
Price/GP Ratio High 1.38 1.32 1.85 1.02 0.60 1.10 1.27 1.51 0.82 4.46 1.37 1.04 1.19 <-Median-> 10 Price/GP Ratio CDN$
Price/GP Ratio Low 0.92 0.89 1.18 0.38 0.29 0.80 0.65 0.72 0.54 0.95 0.25 0.31 0.59 <-Median-> 10 Price/GP Ratio CDN$
Price/GP Ratio Close 1.21 1.00 1.19 0.39 0.58 1.08 0.91 0.72 0.55 1.00 0.48 0.98 0.82 <-Median-> 10 Price/GP Ratio CDN$
Prem/Disc Close 21.36% -0.28% 19.33% -60.97% -42.15% 8.19% -8.97% -27.55% -44.91% 0.10% -51.80% -2.37% -18.26% <-Median-> 10 Graham Price CDN$
Graham Price $42.03 $41.88 $17.59 $39.63 $14.53 $14.17 $24.26 $12.42 $11.31 $9.67 $6.98 $1.74 $1.75 $1.75 $1.75 -95.85% <-Total Growth 10 Graham Price CDN$
Price/GP Ratio Med 0.77 0.94 2.91 0.61 0.98 1.48 0.88 1.31 0.97 0.68 0.28 0.94 1.14 0.96 <-Median-> 10 Price/GP Ratio CDN$
Price/GP Ratio High 0.92 1.12 3.55 0.89 1.32 1.72 1.16 1.77 1.17 1.12 0.48 1.45 1.48 1.25 <-Median-> 10 Price/GP Ratio CDN$
Price/GP Ratio Low 0.61 0.76 2.27 0.33 0.64 1.24 0.60 0.84 0.76 0.24 0.09 0.44 0.80 0.62 <-Median-> 10 Price/GP Ratio CDN$
Price/GP Ratio Close 0.81 0.85 2.30 0.34 1.28 1.68 0.83 0.85 0.78 0.25 0.17 1.36 0.86 0.86 1.25 0.84 <-Median-> 10 Price/GP Ratio CDN$
Prem/Disc Close -18.74% -15.07% 129.55% -65.76% 27.62% 68.30% -16.78% -14.95% -21.56% -74.86% -83.23% 36.45% -14.17% -14.17% 25.31% -15.86% <-Median-> 10 Graham Price CDN$
Price Close CDN$ $34.15 $35.57 $40.37 $13.57 $18.55 $23.84 $20.19 $10.56 $8.87 $2.43 $1.17 $2.37 $1.50 $1.50 $2.19 -93.34% <-Total Growth 10 Stock Price CDN$
Increase 31.26% 4.16% 13.49% -66.39% 36.70% 28.52% -15.31% -47.70% -16.00% -72.60% -51.85% 102.56% -36.71% 0.00% 46.00% -23.73% <-IRR #YR-> 10 Stock Price -93.34% CDN$
P/E 10.09 10.88 55.30 4.21 -53.00 47.68 14.85 28.54 -5.31 -0.69 -0.22 -1.71 -6.25 -15.00 73.00 -34.85% <-IRR #YR-> 5 Stock Price -88.26% CDN$
Trailing P/E 24.39 10.51 12.35 18.59 5.76 -68.11 40.38 7.76 23.97 -1.46 -0.33 -0.45 -1.08 -6.25 -21.90 -13.40% <-IRR #YR-> 10 Price & Dividend CDN$
Median 10, 5 Yrs D. per yr 10.32% 4.63% % Tot Ret 0.00% 0.00% Price Inc -47.70% P/E: 2.00 -0.69 -30.22% <-IRR #YR-> 5 Price & Dividend CDN$
-$35.57 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.37
-$20.19 $0.00 $0.00 $0.00 $0.00 $2.37
-$35.57 $4.08 $4.08 $2.04 $1.62 $0.90 $1.08 $0.95 $0.56 $0.17 $2.37
-$20.19 $1.08 $0.95 $0.56 $0.17 $2.37
Price H/L Median $32.34 $39.44 $51.16 $24.30 $14.27 $20.97 $21.29 $16.21 $10.94 $6.57 $1.96 $1.64 $1.99 46.00% -95.84% <-Total Growth 10 Stock Price CDN$
Increase 14.96% 21.93% 29.73% -52.51% -41.26% 46.95% 1.53% -23.86% -32.54% -39.96% -70.14% -16.33% 21.04% -27.24% <-IRR #YR-> 10 Stock Price -95.84% CDN$
P/E 9.56 12.06 70.08 7.55 -40.77 41.94 15.65 43.81 -6.55 -1.87 -0.37 -1.18 -8.27 -40.11% <-IRR #YR-> 5 Stock Price -92.30% CDN$
Trailing P/E 23.10 11.66 15.65 33.28 4.43 -59.91 42.58 11.92 29.55 -3.93 -0.56 -0.31 -1.43 -16.47% <-IRR #YR-> 10 Price & Dividend CDN$
P/E on Run. 5 yr Ave 15.00 17.60 23.01 10.12 6.96 14.23 19.50 15.89 260.36 -11.13 -1.12 -0.71 -0.82 -35.19% <-IRR #YR-> 5 Price & Dividend CDN$
P/E on Run. 10 yr Ave 23.52 24.92 32.62 9.62 6.16 11.55 12.78 10.00 8.95 8.99 -14.52 -2.73 -2.84 9.71 P/E Ratio Historical Median 11.36 CDN$
Median 10, 5 Yrs D. per yr 10.77% 4.92% % Tot Ret 0.00% 0.00% Price Inc -32.54% P/E: 3.59 -1.18 Count 22 Years of data CDN$
-$39.44 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.64
-$21.29 $0.00 $0.00 $0.00 $0.00 $1.64
-$39.44 $4.08 $4.08 $2.04 $1.62 $0.90 $1.08 $0.95 $0.56 $0.17 $1.64
-$21.29 $1.08 $0.95 $0.56 $0.17 $1.64
High Months Sept Aug 06 Feb Jun Nov Dec Feb Feb Jul Jun Feb Oct Jan
pre consold
pre split 06 $23.31
Price High $38.85 $47.02 $62.46 $35.42 $19.23 $24.33 $28.09 $21.99 $13.25 $10.83 $3.32 $2.52 $2.58 -94.64% <-Total Growth 10 Stock Price CDN$
Increase 21.15% 21.03% 32.84% -43.29% -45.71% 26.52% 15.45% -21.72% -39.75% -18.26% -69.34% -24.10% 2.38% -25.37% <-IRR #YR-> 10 Stock Price -94.64% CDN$
P/E 11.48 14.38 85.56 11.00 -54.94 48.66 20.65 59.43 -7.93 -3.09 -0.63 -1.81 -10.75 -38.26% <-IRR #YR-> 5 Stock Price -91.03% CDN$
Trailing P/E 27.75 13.90 19.10 48.52 5.97 -69.51 56.18 16.17 35.81 -6.49 -0.95 -0.48 -1.86 13.33 P/E Ratio Historical Median 14.03
Median 10, 5 Yrs Price Inc -21.72% P/E: 12.69 -0.63 -1.81 29.86 P/E Ratio Historical High
-$47.02 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.52
-$28.09 $0.00 $0.00 $0.00 $0.00 $2.52
Low Months Jan Nov 06 Nov Dec Mar Jan Oct Nov Nov Dec Oct Jan Jul
Price Low $25.83 $31.85 $39.86 $13.17 $9.31 $17.61 $14.49 $10.43 $8.62 $2.30 $0.60 $0.76 $1.39 -97.61% <-Total Growth 10 Stock Price CDN$
Increase 6.75% 23.29% 25.15% -66.96% -29.31% 89.15% -17.72% -28.02% -17.35% -73.32% -73.91% 26.67% 82.89% -31.17% <-IRR #YR-> 10 Stock Price -97.61% CDN$
P/E 7.64 9.74 54.60 4.09 -26.60 35.22 10.65 28.19 -5.16 -0.66 -0.11 -0.55 -5.79 -44.54% <-IRR #YR-> 5 Stock Price -94.76% CDN$
Trailing P/E 18.45 9.41 12.19 18.04 2.89 -50.31 28.98 7.67 23.30 -1.38 -0.17 -0.14 -1.00 6.89 P/E Ratio Historical Median 8.69
Median 10, 5 Yrs Price Inc -28.02% P/E: 1.99 -0.55 -0.88 P/E Ratio Historical Low
-$31.85 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.76
Price Close CDN$ $34.15 $35.57 $40.37 $13.57 $18.55 $23.84 $20.19 $10.56 $8.87 $2.43 $1.17 $2.37 -93.34% <-Total Growth 10 Stock Price CDN$
Increase 31.26% 4.16% 13.49% -66.39% 36.70% 28.52% -15.31% -47.70% -16.00% -72.60% -51.85% 102.56% -23.73% <-IRR #YR-> 10 Stock prices -93.34% CDN$
P/E 10.09 10.88 55.30 4.21 -53.00 47.68 14.85 28.54 -5.31 -0.69 -0.22 -1.71 -34.85% <-IRR #YR-> 5 Stock Price -88.26% CDN$
Trailing P/E 24.39 10.51 12.35 18.59 5.76 -68.11 40.38 7.76 23.97 -1.46 -0.33 -0.45 -13.40% <-IRR #YR-> 10 Price & Dividend 10.49 CDN$
Median 10, 5 Yrs D. per yr 10.32% 4.63% % Tot Ret 0.00% 0.00% Price Inc -47.70% P/E: 2.00 -0.69 -30.22% <-IRR #YR-> 5 Price & Dividend CDN$
What my price changes have been from Maximum to Penn West. The Closing prices from above are Petrofund to Penn West.
-$35.57 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $2.37
-$20.19 $0.00 $0.00 $0.00 $0.00 $2.37
-$35.57 $4.08 $4.08 $2.04 $1.62 $0.90 $1.08 $0.95 $0.56 $0.17 $2.37
-$20.19 $1.08 $0.95 $0.56 $0.17 $2.37
pre split 06 $17.64
Price Close US$ $29.40 $30.56 $26.00 $11.12 $17.60 $23.92 $19.80 $10.59 $8.36 $2.08 $0.86 $1.77 $1.18 $1.18 $1.18 -94.21% <-Total Growth 10 Stock prices US$
Increase 35.28% 3.95% -14.92% -57.23% 58.27% 35.91% -17.22% -46.52% -21.06% -75.12% -58.65% 105.81% -33.33% 0.00% 0.00% -24.79% <-IRR #YR-> 10 Stock Price -94.21% US$
P/E 10.11 10.89 35.19 4.23 -52.81 47.70 14.87 28.48 -5.32 -0.69 -0.23 -1.71 -6.15 -14.76 49.21 -38.30% <-IRR #YR-> 5 Stock Price -91.06% US$
Trailing P/E 25.30 10.50 9.26 15.05 6.69 -71.77 39.48 7.95 22.48 -1.32 -0.28 -0.47 -1.14 -6.15 -14.76 -12.98% <-IRR #YR-> 10 Price & Dividend US$
Median 10, 5 Yrs D. per yr 11.81% 4.59% % Tot Ret 0.00% 0.00% Price Inc -46.52% P/E: 2.00 -0.69 -33.72% <-IRR #YR-> 5 Price & Dividend US$
Price H/L Median US$ $27.12 $35.36 $30.72 $22.75 $12.58 $20.28 $21.25 $16.27 $11.62 $6.06 $1.56 $1.23 $1.56 -96.54% <-Total Growth 10 Stock prices US$
Increase 25.59% 30.40% -13.12% -25.94% -44.70% 61.21% 4.78% -23.46% -28.59% -47.83% -74.26% -21.47% 27.35% -28.56% <-IRR #YR-> 10 Stock Price -96.54% US$
P/E 9.32 12.60 41.58 8.65 -37.74 40.44 15.96 43.74 -7.40 -2.00 -0.41 -1.18 -8.13 -43.49% <-IRR #YR-> 5 Stock Price -94.24% US$
Trailing P/E 23.34 12.15 10.95 30.79 4.78 -60.85 42.37 12.21 31.23 -3.86 -0.52 -0.32 -1.51 -16.64% <-IRR #YR-> 10 Price & Dividend US$
Median 10, 5 Yrs D. per yr 11.91% 4.80% % Tot Ret 0.00% 0.00% Price Inc -28.59% P/E: 4.12 -1.18 -38.69% <-IRR #YR-> 5 Price & Dividend US$
High Months Jun Feb Oct Jan
pre split 06 $19.88
Price High US$ $33.13 $42.97 $35.78 $34.54 $18.02 $24.14 $28.90 $22.10 $12.80 $10.14 $2.67 $1.91 $2.04 -95.56% <-Total Growth 10 Stock prices US$
Increase 32.89% 29.69% -16.73% -3.47% -47.83% 33.96% 19.72% -23.53% -42.08% -20.78% -73.67% -28.46% 6.81% -26.75% <-IRR #YR-> 10 Stock Price -95.56% US$
P/E 0.11 0.11 -0.23 -0.01 1.44 0.68 0.15 -0.63 0.27 0.07 0.19 0.27 -0.35 -41.92% <-IRR #YR-> 5 Stock Price -93.39% US$
Trailing P/E 28.51 14.77 12.75 46.75 6.85 -72.43 57.63 16.60 34.42 -6.46 -0.88 -0.50 -1.97 0.11 P/E Ratio Historical Median US$
Median 10, 5 Yrs Price Inc -28.46% P/E: 0.17 0.19 0.44 P/E Ratio Historical High US$
Low Months Dec Oct Jan Jul
pre split 06 $12.66
Price Low US$ $21.10 $27.75 $25.66 $10.96 $7.14 $16.42 $13.60 $10.43 $10.43 $1.98 $0.45 $0.54 $1.08 -98.05% <-Total Growth 10 Stock prices US$
Increase 15.62% 31.52% -7.53% -57.29% -34.85% 129.97% -17.17% -23.31% 0.00% -81.02% -77.27% 20.00% 100.00% -32.56% <-IRR #YR-> 10 Stock Price -98.05% US$
P/E 7.25 9.89 34.73 4.17 -21.42 32.74 10.21 28.05 -6.64 -0.65 -0.12 -0.52 -5.63 -47.55% <-IRR #YR-> 5 Stock Price -96.03% US$
Trailing P/E 18.16 9.54 9.14 14.84 2.71 -49.27 27.12 7.83 28.05 -1.26 -0.15 -0.14 -1.04 7.25 P/E Ratio Historical Median US$
Median 10, 5 Yrs Price Inc -23.31% P/E: 2.02 -0.52 -0.57 P/E Ratio Historical Low US$
Long Term Debt $2,149 $1,940 $469 $384 Debt CDN$
Change -9.73% -75.82% -18.12% -0.43 <-Median-> 2 Change CDN$
Ratio to Market Cap 1.78 3.30 0.39 0.51 1.78 <-Median-> 3 % of Market C. CDN$
Goodwill & Intangibles $2,020 $2,020 $1,912 $734 $0 $0 $0 <---Yes, 0 Intangibles Goodwill CDN$
Change 0.00% -5.35% -61.61% -100.00% #DIV/0! #DIV/0! #DIV/0! <-Median-> 4 Change CDN$
Ratio to Market Cap 0.21 0.40 0.44 0.61 0.00 0.00 0.00 0.31 <-Median-> 6 % of Market C. CDN$
Market Cap $M $2,039 $8,435 $9,796 $5,245 $7,821 $10,959 $9,517 $5,061 $4,338 $1,208 $588 $1,192 $754 $754 $1,101 -85.87% <-Total Growth 10 Market Cap CDN$
Diluted # of Sh in Million 475.808 485.814 493.669 502.0 502.3 5.57% <-Total Growth 4 Diluted
Change 2.10% 1.62% 1.68% 0.06% 0.02 <-Median-> 4 Change
Average # of Sh in Million 239.40 375.61 412.90 441.80 467.190 475.604 485.814 493.669 502.0 502.3 109.82% <-Total Growth 9 Average
Increase 56.90% 9.93% 7.00% 5.75% 1.80% 2.15% 1.62% 1.68% 0.06% 0.02 <-Median-> 9 Change
Difference 1.4% 2.9% 2.1% 4.0% 0.9% 0.8% 0.7% 0.7% 0.0% 0.1% 0.01 <-Median-> 10 Difference
$480 <-12 mths -4.57%
# of Share in Millions 59.71 237.1 242.7 386.5 421.6 459.7 471.4 479.3 489.1 497.3 502.2 502.8 502.8 502.8 502.8 7.80% <-IRR #YR-> 10 Shares 112.02% CDN$
Increase 36.90% 297.15% 2.34% 59.28% 9.09% 9.02% 2.54% 1.67% 2.05% 1.69% 0.97% 0.12% 0.00% 0.00% 0.00% 1.30% <-IRR #YR-> 5 Shares 6.66% CDN$
CF fr Op $M 337.2 1,106.3 1,241.8 2,256.0 1,401.0 1,217.0 1,407.0 1,193.0 968.0 848.0 175.0 -137.0 176.0 191.1 226.2 -112.38% <-Total Growth 10 Cash Flow CDN$
Increase 38.40% 228.06% 12.25% 81.67% -37.90% -13.13% 15.61% -15.21% -18.86% -12.40% -79.36% -178.29% -228.44% 8.57% 18.42% S. Issues, S.O. DRIP, Buy Backs CDN$
5 year Running Average $197.0 $392.6 $624.6 $1,037.0 $1,268.5 $1,444.4 $1,504.6 $1,494.8 $1,237.2 $1,126.6 $918.2 $609.4 $406.0 $250.6 $126.3 55.24% <-Total Growth 10 CF 5 Yr Running CDN$
CFPS $5.65 $4.67 $5.12 $5.84 $3.32 $2.65 $2.98 $2.49 $1.98 $1.71 $0.35 -$0.27 $0.35 $0.38 $0.45 -105.84% <-Total Growth 10 Cash Flow per Share CDN$
Increase 1.10% -17.40% 9.69% 14.06% -43.07% -20.32% 12.74% -16.60% -20.49% -13.85% -79.56% -178.19% -228.44% 8.57% 18.42% #NUM! <-IRR #YR-> 10 Cash Flow -112.38% CDN$
5 year Running Average $4.66 $4.57 $5.09 $5.37 $4.92 $4.32 $3.98 $3.46 $2.68 $2.36 $1.90 $1.25 $0.82 $0.50 $0.25 #NUM! <-IRR #YR-> 5 Cash Flow -109.74% CDN$
P/CF on Med Price 5.73 8.13 9.70 3.83 4.21 8.52 6.89 6.72 5.82 3.71 6.83 -20.61 5.67 #NUM! <-IRR #YR-> 10 Cash Flow per Share -105.84% CDN$
P/CF on Closing Price 6.05 7.62 7.89 2.32 5.58 9.00 6.76 4.24 4.48 1.43 3.36 -8.70 4.29 #NUM! <-IRR #YR-> 5 Cash Flow per Share -109.13% CDN$
-31.65% Diff M/C -12.16% <-IRR #YR-> 10 CFPS 5 yr Running -72.66% CDN$
Excl.Working Capital CF $0.0 $43.6 $38.2 $196.0 $27.0 -$85.0 $49.0 -$37.0 -$49.0 $32.0 -$31.0 $97.0 $0.0 $0.0 $0.0 -20.68% <-IRR #YR-> 5 CFPS 5 yr Running -68.61% CDN$
CF fr Op $M WC $337.2 $1,149.9 $1,280.0 $2,452.0 $1,428.0 $1,132.0 $1,456.0 $1,156.0 $919.0 $880.0 $144.0 -$40.0 $176.0 $191.1 $226.2 -103.48% <-Total Growth 10 Cash Flow less WC CDN$
Increase 38.40% 240.99% 11.31% 91.56% -41.76% -20.73% 28.62% -20.60% -20.50% -4.24% -83.64% -127.78% -539.92% 8.57% 18.42% #NUM! <-IRR #YR-> 10 Cash Flow less WC -103.48% CDN$
5 year Running Average $197.0 $401.3 $641.0 $1,092.6 $1,329.4 $1,488.4 $1,549.6 $1,524.8 $1,218.2 $1,108.6 $911.0 $611.8 $415.8 $270.2 $139.5 #NUM! <-IRR #YR-> 5 Cash Flow less WC -102.75% CDN$
CFPS Excl. WC $5.65 $4.85 $5.27 $6.34 $3.39 $2.46 $3.09 $2.41 $1.88 $1.77 $0.29 -$0.08 $0.35 $0.38 $0.45 4.31% <-IRR #YR-> 10 CF less WC 5 Yr Run 52.46% CDN$
Increase 1.10% -14.14% 8.77% 20.27% -46.61% -27.29% 25.43% -21.91% -22.10% -5.83% -83.79% -127.74% -539.92% 8.57% 18.42% -16.96% <-IRR #YR-> 5 CF less WC 5 Yr Run -60.52% CDN$
5 year Running Average $4.66 $4.61 $5.16 $5.54 $5.10 $4.46 $4.11 $3.54 $2.65 $2.32 $1.89 $1.25 $0.84 $0.54 $0.28 #NUM! <-IRR #YR-> 10 CFPS - Less WC -101.64% CDN$
P/CF on Med Price 5.73 8.13 9.70 3.83 4.21 8.52 6.89 6.72 5.82 3.71 6.83 -20.61 #NUM! <-IRR #YR-> 5 CFPS - Less WC -102.58% CDN$
P/CF on Closing Price 6.05 7.34 7.65 2.14 5.48 9.68 6.54 4.38 4.72 1.37 4.08 -29.79 4.29 3.95 4.87 -12.21% <-IRR #YR-> 10 CFPS 5 yr Running -72.80% CDN$
*Operational Cash Flow per share CF/-WC P/CF Med 10 yr 6.27 5 yr 5.82 P/CF Med 10 yr 6.27 5 yr 5.82 -31.65% Diff M/C -21.14% <-IRR #YR-> 5 CFPS 5 yr Running -69.51% CDN$
-$4.67 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 -$0.27 Cash Flow per Share
-$2.98 $0.00 $0.00 $0.00 $0.00 -$0.27 Cash Flow per Share
-$4.57 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.25 CFPS 5 yr Running
-$3.98 $0.00 $0.00 $0.00 $0.00 $1.25 CFPS 5 yr Running
-$1,149.9 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 -$40.0 Cash Flow less WC
-$1,456.0 $0.0 $0.0 $0.0 $0.0 -$40.0 Cash Flow less WC
-$401.3 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $611.8 CF less WC 5 Yr Run
-$1,549.6 $0.0 $0.0 $0.0 $0.0 $611.8 CF less WC 5 Yr Run
-$4.85 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 -$0.08 CFPS - Less WC
-$3.09 $0.00 $0.00 $0.00 $0.00 -$0.08 CFPS - Less WC
OPM 57.22% 62.49% 67.90% 51.12% 31.75% 39.85% 38.37% 36.88% 34.22% 34.85% 14.74% -22.53% -136.06% <-Total Growth 10 OPM CDN$
Increase -13.54% 9.20% 8.65% -24.70% -37.90% 25.52% -3.71% -3.89% -7.22% 1.86% -57.70% -252.84% Should increase or be stable. CDN$
Diff from Ave 59.5% 74.2% 89.3% 42.5% -11.5% 11.1% 7.0% 2.8% -4.6% -2.8% -58.9% -162.8% 0.00 <-Median-> 10 OPM CDN$
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 35.87% 5 Yrs 34.22% should be zero, it is a check on calculations CDN$
Current Assets $130.66 $378.70 $367.50 $940.00 $509.00 $490 $629 $706 $463 $410 $305 $341 $207 Liquidity ratio of 1.5 and up, best CDN$
Current Liabilities $112.65 $464.70 $589.40 $901.00 $726.00 $846 $1,349 $907 $754 $943 $626 $344 $195 0.62 <-Median-> 10 Ratio CDN$
Liquidity Ratio 1.16 0.81 0.62 1.04 0.70 0.58 0.47 0.78 0.61 0.43 0.49 0.99 1.06 0.61 <-Median-> 5 Ratio CDN$
Liq. with CF aft div 2.43 1.13 1.05 1.80 1.45 1.14 1.19 1.52 1.28 1.04 0.63 0.59 1.96 1.04 <-Median-> 5 Ratio
Liq. CF re Inv+Div 0.36 0.50 0.36 0.83 0.93 0.70 0.54 1.14 0.95 0.93 0.63 0.59 1.96 0.93 <-Median-> 5 Ratio
Curr Long Term Debt $64.0 $283.0 $222.0 $222.0 $222.0
Liquidity Less CLTD 0.67 0.62 0.75 2.80 -7.67
Liq. with CF aft div 1.40 1.48 0.98 1.67 -14.18
Assets $2,267.1 $8,070 $8,433 $15,412 $13,876 $13,368 $15,584 $14,491 $12,329 $9,852 $5,924 $3,339 $3,146 Debt Ratio of 1.5 and up, best CDN$
Liabilities $881.8 $2,417 $3,864 $7,032 $5,958 $5,169 $6,517 $5,617 $4,816 $4,270 $2,989 $1,092 $871 2.36 <-Median-> 10 Ratio CDN$
Debt Ratio 2.57 3.34 2.18 2.19 2.33 2.59 2.39 2.58 2.56 2.31 1.98 3.06 3.61 2.56 <-Median-> 5 Ratio CDN$
Book Value $1,385 $5,653 $4,570 $8,380 $7,918 $8,199 $9,067 $8,874 $7,513 $5,582 $2,935 $2,247 $2,275 $2,275 $2,275 -60.25% <-Total Growth 10 Book Value CDN$
Book Value per share $23.20 $23.84 $18.83 $21.68 $18.78 $17.84 $19.24 $18.52 $15.36 $11.22 $5.84 $4.47 $4.52 $4.52 $4.52 -81.25% <-Total Growth 10 Book Value per Share CDN$
Change -1.42% 2.75% -21.01% 15.14% -13.39% -5.02% 7.84% -3.74% -17.04% -26.93% -47.93% -23.53% 1.25% 0.00% 0.00% -73.00% P/B Ratio Current/Historical Median CDN$
P/B Ratio (Median) 1.39 1.65 2.72 1.12 0.76 1.18 1.11 0.88 0.71 0.58 0.34 0.37 0.44 1.23 P/B Ratio Historical Median
P/B Ratio (Close) 1.47 1.49 2.14 0.63 0.99 1.34 1.05 0.57 0.58 0.22 0.20 0.53 0.33 0.33 0.48 -15.41% <-IRR #YR-> 10 Book Value per Share -81.25% CDN$
Change 33.16% 1.37% 43.68% -70.81% 57.83% 35.31% -21.47% -45.67% 1.24% -62.51% -7.54% 164.90% -37.49% 0.00% 46.00% -25.32% <-IRR #YR-> 5 Book Value per Share -76.77% CDN$
Leverage (A/BK) 1.64 1.43 1.85 1.84 1.75 1.63 1.72 1.63 1.64 1.76 2.02 1.49 1.38 1.74 <-Median-> 10 A/BV CDN$
Debt/Equity Ratio 0.64 0.43 0.85 0.84 0.75 0.63 0.72 0.63 0.64 0.76 1.02 0.49 0.38 0.74 <-Median-> 10 Debt/Eq Ratio CDN$
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Med 0.82 5 yr Med 0.58 -59.46% Diff M/C 1.63 Historical 22 A/BV
-$23.84 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4.47
-$19.24 $0.00 $0.00 $0.00 $0.00 $4.47
-$596 <-12 mths 14.41%
Comprehensive Income -$144.00 $226.00 $638.00 $174.00 -$809.00 -$1,733 -$2,646 -$696 -383.33% <-Total Growth 7 Comprehensive Income CDN$
Increase 256.94% 182.30% -72.73% -564.94% -114.22% -52.68% 73.70% -72.73% <-Median-> 5 Comprehensive Income CDN$
5 Yr Running Average $17 -$301 -$875 -$1,142 25.24% <-IRR #YR-> 7 Comprehensive Income -383.33%
ROE -1.8% 2.8% 7.0% 2.0% -10.8% -31.0% -90.2% -31.0% #NUM! <-IRR #YR-> 5 Comprehensive Income -209.09% CDN$
5Yr Median 0.5% 2.8% 2.4% 2.0% 2.0% -10.8% -31.0% #NUM! <-IRR #YR-> 6 5 Yr Running Average #DIV/0! CDN$
% Difference from NI 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% #NUM! <-IRR #YR-> 5 5 Yr Running Average #DIV/0! CDN$
Median Values Diff 5, 10 yr 0.0% 0.0% -31.0% <-Median-> 5 Return on Equity
$144.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 -$696.0
-$226.0 -$638.0 $0.0 $0.0 $0.0 $0.0 -$696.0
$0.0 $0.0 $0.0 $0.0 $0.0 $0.0 -$1,142.0
$0.0 $0.0 $0.0 $0.0 $0.0 $0.0 -$1,142.0
Current Liability Coverage Ratio 2.99 2.47 2.17 2.72 1.97 1.34 1.08 1.27 1.22 0.93 0.23 -0.12 CFO / Current Liabilities
5 year Median 2.36 2.36 2.36 2.47 2.47 2.17 1.97 1.34 1.27 1.22 1.08 0.93 1.25 <-Median-> 10 Current Liability Cov Ratio
Asset Efficiency Ratio 14.87% 14.25% 15.18% 15.91% 10.29% 8.47% 9.34% 7.98% 7.45% 8.93% 2.43% -1.20% CFO / Total Assets
5 year Median 16.39% 14.87% 15.18% 15.18% 14.87% 14.25% 10.29% 9.34% 8.47% 8.47% 7.98% 7.45% 8.7% <-Median-> 10 Return on Assets
Return on Assets ROA 9.3% 8.2% 3.0% 8.8% -1.0% 1.7% 4.1% 1.2% -6.6% -17.6% -44.7% -20.8% Net Income/Assets Return on Assets CDN$
5Yr Median 7.7% 8.2% 8.2% 8.2% 8.2% 3.0% 3.0% 1.7% 1.2% 1.2% -6.6% -17.6% 0.1% <-Median-> 10 Asset Efficiency Ratio CDN$
Return on Equity ROE 15.2% 11.8% 5.5% 16.2% -1.8% 2.8% 7.0% 2.0% -10.8% -31.0% -90.2% -31.0% Net Inc/ Shareholders' equity Return on Equity CDN$
5Yr Median 13.2% 11.8% 11.8% 11.8% 11.8% 5.5% 5.5% 2.8% 2.0% 2.0% -10.8% -31.0% 0.1% <-Median-> 10 Return on Equity CDN$
-$596 <-12 mths 14.41%
Net Income $210.67 $665.60 $250.90 $1,356.0 -$144.0 $226 $638 $174 -$809 -$1,733 -$2,646 -$696 $14 -$10 $22 -204.57% <-Total Growth 10 Net Income CDN$
Increase 183.31% 215.95% -62.30% 440.45% -110.62% 256.94% 182.30% -72.73% -564.94% -114.22% -52.68% 73.70% 101.97% -175.18% 313.59% EPS/CF Ratio should not be higher than 1.00 CDN$
5 Yr Running Average $90 $212 $257 $512 $468 $471 $465 $450 $17 -$301 -$875 -$1,142 -$1,174 -$1,014 -$663 #NUM! <-IRR #YR-> 10 Net Income -204.57% CDN$
Operating Cash Flow $337.22 $1,106.3 $1,241.8 $2,256.0 $1,401.0 $1,217 $1,407 $1,193 $968 $848 $175 -$137 #NUM! <-IRR #YR-> 5 Net Income -209.09% CDN$
Investment Cash Flow -$657.26 -$591.2 -$1,125.3 -$1,049.0 -$398.0 -$521 -$1,633 -$305 -$264 -$113 $196 $1,310 #NUM! <-IRR #YR-> 10 5 Yr Running Ave. -65.87% CDN$
Total Accruals $530.7 $150.5 $134.4 $149.0 -$1,147.0 -$470 $864 -$714 -$1,513 -$2,468 -$3,017 -$1,869 #NUM! <-IRR #YR-> 5 5 Yr Running Ave. -345.39% CDN$
Total Assets $2,267.12 $8,069.7 $8,433.0 $15,412 $13,876 $13,368 $15,584 $14,491 $12,329 $9,852 $5,924 $3,339 Balance Sheet Assets CDN$
Accruals Ratio 23.41% 1.87% 1.59% 0.97% -8.27% -3.52% 5.54% -4.93% -12.27% -25.05% -50.93% -55.97% -25.05% <-Median-> 5 Ratio CDN$
EPS/CF Ratio 0.60 0.67 0.14 0.51 -0.10 0.20 0.44 0.15 -0.89 -1.98 -18.38 17.47 0.15 <-Median-> 10 EPS/CF Ratio
-$666 $0 $0 $0 $0 $0 $0 $0 $0 $0 -$696
-$638 $0 $0 $0 $0 -$696
-$212 $0 $0 $0 $0 $0 $0 $0 $0 $0 -$1,142
-$465 $0 $0 $0 $0 -$1,142
Change in Close 31.26% 4.16% 13.49% -66.39% 36.70% 28.52% -15.31% -47.70% -16.00% -72.60% -51.85% 102.56% -36.71% 0.00% 46.00% Count 22 Years of data CDN$
up/down up down down down up up up up Count 17 77.27% CDN$
Meet Prediction? Yes Yes % right Count 8 47.06% CDN$
Financial Cash Flow -$419.20 -$515.10 -$116.50 -$1,207.0 -$1,003.0 -$696 $266 -$888 -$704 -$668 -$436 -$1,164 C F Statement Financial Cash Flow CDN$
Total Accruals $949.9 $665.6 $250.9 $1,356.0 -$144.0 $226.0 $598.0 $174.0 -$809.0 -$1,800.0 -$2,581.0 -$705.0 Accruals CDN$
Accruals Ratio 41.90% 8.25% 2.98% 8.80% -1.04% 1.69% 3.84% 1.20% -6.56% -18.27% -43.57% -21.11% Ratio CDN$
Cash $0.00 $0.00 $0.00 $0.00 $67.00 $2.00 $11.00 $0.00 Cash CDN$
Cash per Share $0.00 $0.00 $0.00 $0.00 $0.13 $0.00 $0.02 $0.00 $0.00 <-Median-> 5 Cash per Share CDN$
Percentage of Stock Price 0.00% 0.00% 0.00% 0.00% 5.54% 0.34% 0.92% 0.00% 0.34% <-Median-> 5 % of Stock Price CDN$
Yes Yes Yes Yes
Taxes
Foreign $0.00 $0.00 $0.00 $0.00
Cap Gain $0.00 $0.00 $0.00 $0.00
Other Income $1.92 $4.05 $4.08 $4.08
Ret of Cap. $0.03 $0.00 $0.00 $0.00
Total $1.95 $4.05 $4.08 $4.08
Foreign 0.00% 0.00% 0.00% 0.00%
Cap Gain 0.00% 0.00% 0.00% 0.00%
Other Income 98.37% 100.00% 100.00% 100.00%
Ret of Cap. 1.63% 0.00% 0.00% 0.00%
Total 100.00% 100.00% 100.00% 100.00%
For Tax Cr
Notes:
July 22, 2017. Lasty estimates were for 2016, 2017 and 2018 of $674M, $765M and $509M for Revenue, $0.067 and $0.63 for 2016 and 2017 for FFO, -$0.55, -$0.24 and -$0.10 for EPS,
$0.27, $0.28 and $0.36 for CFPS and $-$285M, -$96M and -$11M for Net Income.
June 26, 2017. This company changed its name from Penn West Petroleum Ltd. (TSX-PWT, NYSE-PWE) to Obsidian Energy Ltd TSX-OBE, NYSE-OBE). Web site used to be www.pennwest.com.
July 17, 2016. Last estimates were for 2015, 2016 and 2017 of $1419M, $1595M and $1896M for Revenue, $-0.85, $-0.27 and $-0.10 for EPS, $0.77, $1.02 and $1.20 for CFPS and $-423M, $-105M and $-53M for net income.
July 26, 2015. Last estimates were for 2014, 2015 and 2016. Revenue was $2376M, $2282M and $2474M; EPS was -$0.01, $0.23 and $0.07; CFPS was 2.09, $1.94 and $2.10 and Net Income for 2014 and 2015 was $76M and $134M.
In 2015 I did update 2013 data because they put out new restated financial statements for 2013.
July 06, 2014. There were no estimates for 2012 to 2014.
December 30, 2012. The last time I got estimates they were for 2011 and 2012 of $6881M and $3945M for revenue $3.22 and 380 for Adj FFO, $1.22 and $.90 for EPS and $3.22 and $3.80 for CF
Oct 2, 2011. Last I looked I got estimates for 2010 and 2011 of $3.72 and $3.17 FFO, $.07 and $.47 Earnings and $3.30 abd $3.85 for CF
Distributable cash has turned into Cash Flow, so I do not need separate item for Distributable cash and can use CF.
2011. Company changed to Corporation of Penn West Petroleum from Penn West Energy Trust and symbols of PWT.UN to PWT
May 19, 2010. When I last looked at this stock I got estimates for earnings of $.16 and $.46 and Cash Flow of $3.57 and $3.80. 2010 estiamtes are down and 2011 up, a bit.
Apr 18, 2010. When I last looked at this stock, I got estimates for 2009 and 2010 of $3.14 and $4.00 for distri income, $-.037 and $.36 for earnings and $3.58 and $3.61 for Cash Flow.
They will convert to a corporation by mid-2011. Makes no reference to what distributions will be after conversion. Distributions will probably fluctuation to the price of oil and gas.
Sep 2009. When I last looked at this stock in May 2009, people thought that this stock would make modest earnings for 2009 at $.08. However, now most analyst feel this stock will lose money in 2009.
However, earnings for 2010 has gone up a bit. What is also interesting is that this stock has gone down in CDN$, but remained the same in US$.
May 9, 2009 AR 2008. No record of receiving notice of annual meeting for 2008.
The new tax rules on Unit Trust companies applies to this company. The distributions, will in probablity be reduced after2011. Company has not yet decided to convert to a corporation or not.
AP 2007. It is an oil play and as such as not done badly. Everyone seems to have a Hold recommendation (April 2008) on this stock. Do not know why, but EPS
has dropped 77% from $3.27 to $.73. Tax wise, all dividends are fully taxable, which is a negative. But I have little in this stock. $5,000 and have done ok, especially last 5 yrs.
AP 2005. Stock is oil so volatile. However I do not have much Oil stocks, and this is not a bad one to hold. Should even out # of shares held.
I reason I have this stock is to keep track of the Oil and Gas industry in Alberta.
2006. This spreadsheets follows the stock from Petrofund into Penn West. The exception is where it says it is following the stock from Maximum through to Penn West.
This has gone through several changed changes. Used to be NCE Petrofund. Petrofund Energy merged with Penn West in July 2006 and I got .6 of a share for each share I had.
Sector:
Energy, Resources
What should this stock accomplish?
Would I buy this company and Why.
I tend to like dividend paying companies and this company currently pays no dividends, although it might again in the future.
Why am I following this stock.
I bought this stock as Maximum Energy Trust (MXT.UN) in 1998. In November 2001, there was a stock exchange and stock became Ultimate Energy Fund.
In June 2004 fund changed from Ultimate Energy Income Trust to Petrofund Energy.
Petrofund Energy merged with Penn West in July 2006 and I got .6 of a share for each share I had.
Dividends
Dividends are paid quarterly in cycle 1 that is January, April, July and October. Dividends are declared in one month and paid in the following month.
For exaple, the dividend paid on January 15, 2014 was declared for shareholders of record of December 31, 2013.
Why I bought this stock.
I bought this stock as Maximum Energy Trust (MXT.UN) in 1998. I sold this stock of Penn West in 2010 as it was changing to a corporation, but they are also getting back into exploration, rather than just selling oil from their wells.
They also just reduced their dividends from $.15 per share per month to $.09 per share per month.
How they make their money
Obsidian Energy Ltd is a Canada-based conventional oil and natural gas producer and development and production company.
The Company operates a portfolio of opportunities with an oil position in the Cardium, Viking and Peace River areas of Alberta.
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.
Shares; '%, Value $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M Shares %, Val $M
Date Jan 09 2012 Jul 06 2014 Jul 26 2015 Jul 17 2016 Jul 22 2017
French, David L. 0.004 0.00%
CEO - Shares - Amount $0.007 bought in 2017
Options - percentage 0.220 0.04%
Options - amount $0.330
Roberts Jr, David Emmitt 0.060 0.01% 0.095 0.02% 0.210 0.04%
CEO - Shares - Amount $0.145 $0.112 $0.497
Options - percentage 1.400 0.28% 2.562 0.51% 4.162 0.83%
Options - amount $3.402 $2.998 $9.864
Nunns, Murray R. 0.153 0.03%
CEO - Shares - Amount $1.360
Options - percentage 1.550 0.32%
Options - amount $13.749
Hendry, David Warren 0.089 0.02% about half bought in 2017
CFO - Shares - Amount $0.134
Options - percentage 0.660 0.13%
Options - amount $0.989
Dyck, David Allan 0.033 0.01% 0.096 0.02% 0.164 0.03%
CFO - Shares - Amount $0.079 $0.112 $0.388
Options - percentage 0.050 0.01% 0.923 0.18% 2.068 0.41%
Options - amount $0.122 $1.080 $4.900
Takeyasu, Todd 0.057 0.01%
CFO - Shares - Amount $0.505
Options - percentage 1.125 0.23%
Options - amount $9.979
Hodgson, Mark Alan 0.000 0.00% last reported Mar 2017
Officer - Shares - Amount $0.000 yes, no shares, options.
Options - percentage 0.000 0.00%
Options - amount $0.000
Gegunde, Gregg 0.051 0.01% 0.102 0.02%
Officer - Shares - Amount $0.060 $0.242
Options - percentage 1.096 0.22% 1.767 0.35%
Options - amount $1.283 $4.188
Andrew, William E. 0.174 0.04% 0.150 0.03%
Officer - Shares - Amount $1.546 $0.365
Options - percentage 0.883 0.18% 0.654 0.13%
Options - amount $7.835 $1.588
Brookman, George Homer 0.020 0.00% 0.020 0.00% 0.020 0.00%
Director - Shares - Amount $0.023 $0.047 $0.030
Options - percentage 0.015 0.00% 0.030 0.01% 0.043 0.01%
Options - amount $0.017 $0.071 $0.065
Allard, James Edward 0.020 0.00% 0.030 0.01% 0.021 0.00% Not listed as director 2016
Director - Shares - Amount $0.175 $0.072 $0.025
Options - percentage 0.002 0.00% 0.009 0.00% 0.013 0.00%
Options - amount $0.017 $0.021 $0.016
George, Richard Lee 0.820 0.16% 0.873 0.17% 0.873 0.17% 0.873 0.17%
Chairman - Shares - Amt $1.993 $1.021 $2.068 $1.309
Options - percentage 0.019 0.00% 0.057 0.01% 0.205 0.04% 0.329 0.07%
Options - amount $0.047 $0.067 $0.487 $0.494
Increase in O/S Shares 0.230 0.05% 1.239 0.25% 1.067 0.21% 0.000 0.00% 0.601 0.12% Yes 0
due to SO 2013 $2.037 $10.992 $2.593 $0.000 $1.424
Book Value $3.000 $44.000 $12.000 $1.000 $3.000
Insider Buying -$2.277 -$0.740 -$2.567
Insider Selling $0.022 $0.286 $0.286
Net Insider Selling $3.818 -$2.255 -$0.453 -$2.280
% of Market Cap 0.32% -0.38% -0.04% -0.19%
Directors 8 8 9 8
Women 1 13% 1 13% 2 22% 1 13%
Minorities 0 0% 0 0% 0 0% 0 0%
Institutions/Holdings 356 46.93% 352 48.13% 268 41.52% 204 21.47% 166 21.16%
Total Shares Held 224.920 46.93% 237.990 47.85% 208.506 41.52% 107.831 21.45% 106.737 21.23%
Increase/Decrease -0.904 -0.40% 0.075 0.03% -0.898 -0.43% -3.168 -2.85% -0.246 -0.23%
Starting No. of Shares 225.824 237.915 209.403 110.999 106.983
Copyright 2008 Website of SPBrunner. All rights reserved.
My stock