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.
See my website on stocks or see my blog at the following sites.  www.spbrunner.com/stocks.html www.spbrunner.blogspot.com/
Inter Pipeline Fund www.interpipelinefund.com TSX: IPL.UN Fiscal Yr: Dec 31
Year 12/31/98 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 12/31/10 12/31/11 #Y
Accting Rules C GAAP IFRS
Revenue* $82.0 $77.0 $83.1 $92.1 $104.3 $177.9 $482.4 $927.0 $1,011.0 $1,145.0 $1,224.6 $924.6 $997.1 1099% <-Total Growth 10 Revenue
Increase 871.53% -6.11% 8.02% 10.73% 13.27% 70.66% 171.08% 92.18% 9.07% 13.25% 6.95% -24.50% 7.84% 28.20% <-IRR #YR-> 10 Revenue
Rev per Share $1.12 $1.05 $1.14 $1.26 $1.41 $1.38 $2.68 $5.02 $5.01 $5.18 $5.49 $3.63 $3.86 1.47% <-IRR #YR-> 5 Revenue
P/S (Price/Sales) 5.09 4.66 5.02 5.41 4.39 5.62 3.42 2.00 1.80 1.83 1.28 2.98 3.86 13.03% <-IRR #YR-> 10 Rev per share
*Revenue in M CDN $  P/S 10 yr  3.20 5 yr  1.83 -5.11% <-IRR #YR-> 5 Rev per share
-$83.1 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $0.0 $997.1
-$927.0 $0.0 $0.0 $0.0 $0.0 $997.1
-$1.14 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $3.86
-$5.02 $0.00 $0.00 $0.00 $0.00 $3.86
EPS* $0.09 -$0.01 $0.12 $0.11 $0.28 $0.13 $0.52 $0.48 $0.65 -$0.39 $1.12 $0.66 $0.91 $0.99 $0.97 658% <-Total Growth 10 Dividends
Increase 350.00% -111.11% -1300% -8.33% 154.55% -53.57% 300.00% -7.69% 35.42% -160% 72% -41.07% 37.88% 8.79% -2.02% 26.46% <-IRR #YR-> 9 Dividends
Earnings Yield 1.6% -0.2% 2.1% 1.6% 4.5% 1.7% 5.7% 4.8% 7.2% -4.1% 15.9% 6.1% 6.1% 5.3% 5.2% 13.65% <-IRR #YR-> 5 Dividends
* ESP per share (Cdn GAAP) E/P 10 Yrs 5.23% 5Yrs 6.11%
-$0.11 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.91
-$0.48 $0.00 $0.00 $0.00 $0.00 $0.91
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 Dividends
Div* $0.77 $0.64 $0.66 $0.68 $0.68 $0.72 $0.73 $0.75 $0.80 $0.84 $0.84 $0.84 $0.90 $0.96 $1.05 36.36% 41.18% <-Total Growth 10 Dividends
Increase 175.00% -16.88% 3.13% 3.03% 0.00% 5.88% 1.39% 2.74% 6.67% 5.00% 0.00% 0.00% 7.14% 6.67% 9.37% 2.89% 3.87% <-Median-> 10 Dividends
Yield H/L Pr 12.13% 10.88% 11.23% 10.60% 10.32% 10.40% 8.77% 7.79% 8.63% 9.02% 10.33% 9.52% 6.92% 5.75% 9.27% 8.89% <-Median-> 10 Dividends
Yield on High Pr 10.78% 9.21% 8.35% 9.81% 8.97% 9.28% 7.77% 6.98% 7.55% 8.53% 8.18% 7.60% 5.89% 5.07% 7.97% 7.68% <-Median-> 10 Dividends
Yield on Low Pr 13.87% 13.28% 17.14% 11.53% 12.14% 11.84% 10.07% 8.81% 10.06% 9.57% 14.00% 12.75% 8.36% 6.64% 10.80% 10.07% <-Median-> 10 Dividends
Yield on Cl Pr 13.51% 13.06% 11.58% 10.00% 10.97% 9.28% 7.97% 7.46% 8.85% 8.85% 11.91% 7.77% 6.03% 5.15% 5.68% 8.85% 8.41% <-Median-> 10 Dividends
Payout Ratio 855.6% -6400.0% 550.0% 618.2% 242.9% 553.8% 140.4% 156.3% 123.1% -215.4% 75.0% 127.3% 98.9% 97.0% 108.2% 133.83% 125.17% <-Median-> 10 Dividends
Payout Ratio CF 100.7% 90.9% 92.3% 94.1% 95.1% 153.0% 98.3% 80.6% 80.0% 79.3% 58.4% 75.9% 66.4% 63.2% 70.0% 80.30% 79.65% <-Median-> 10 Dividends
Payout Ratio CF NC 102.6% 94.0% 92.4% 95.8% 93.8% 104.5% 87.6% 90.5% 78.6% 75.1% 66.8% 72.7% 69.6% 63.2% 83.10% 76.85% <-Median-> 10 Dividends
Median 5 Yrs Div Yd 6.58% 5 7.63% 10 Yield  9.02% 7.77% Payout 96.97% 66.44% 3.15% 3.51% <-IRR #YR-> 10 Dividends
* Dividends per share  3.0% Years 3.0% Years Curr diff -100.00% Last Div Inc ---> $0.08 $0.09 9.4% 3.71% 3.71% <-IRR #YR-> 5 Dividends
-$0.68 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.96
-$0.80 $0.00 $0.00 $0.00 $0.00 $0.96
H/L Yield held 5 yrs 11.34% 12.40% 12.77% 12.47% 12.75% 12.14% 10.09% 9.35% 10.35% 11.27% 12.27% <-Median-> 8 Dividends
H/L Yield held 10 yrs 13.23% 14.27% 15.32% 14.96% 15.93% 14.27% <-Median-> 3 Dividends
H/LYield held 15 yrs #DIV/0! #NUM! <-Median-> 0 Dividends
Graham No. $4.20 $4.04 $4.50 $4.15 $6.46 $4.15 $8.32 $7.77 $9.32 $8.39 $11.30 $8.77 $10.28 $11.01 $10.90 128.39% 165.38% <-Total Growth 10 Graham Price
Prem /Disc.Med H/L 51.22% 45.76% 30.47% 54.62% 2.09% 66.78% 0.10% 23.80% -0.49% 10.97% -28.00% 0.52% 26.55% 51.54% 6.53% 6.53% <-Median 10 Graham Price
Prem /Disc. High 70.22% 72.14% 75.44% 67.03% 17.42% 87.02% 13.02% 38.14% 13.72% 17.34% -9.10% 25.94% 48.48% 71.83% 21.68% 21.68% <-Median 10 Graham Price
Prem /Disc. Low 32.22% 19.38% -14.50% 42.21% -13.25% 46.53% -12.83% 9.46% -14.71% 4.60% -46.90% -24.89% 4.63% 31.24% -4.12% -4.12% <-Median 10 Graham Price
Prem /Disc. Cl 35.79% 21.36% 26.58% 63.90% -3.96% 87.02% 10.14% 29.27% -3.01% 13.05% -37.60% 23.21% 45.08% 69.20% 69.65% 18.13% 18.13% <-Median 10 Graham Price
Price Cl $5.70 $4.90 $5.70 $6.80 $6.20 $7.76 $9.16 $10.05 $9.04 $9.49 $7.05 $10.81 $14.92 $18.63 $18.49 161.75% 173.97% <-Total Growth 10 Stock Price
Increase -43.00% -14.04% 16.33% 19.30% -8.82% 25.16% 18.04% 9.72% -10.05% 4.98% -25.71% 53.33% 38.02% 24.87% -0.75% 10.10% 10.60% <-IRR #YR-> 10 Stock Price
P/E 63.33 -490.00 47.50 61.82 22.14 59.69 17.62 20.94 13.91 -24.33 6.29 16.38 16.40 18.82 19.06 8.22% 15.56% <-IRR #YR-> 5 Stock Price
Trailing P/E 285.00 54.44 -570.00 56.67 56.36 27.71 70.46 19.33 18.83 14.60 -18.08 9.65 22.61 20.47 18.68 19.45% 18.52% <-IRR #YR-> 10 Price & Div
Median 10, 5 Yrs D.  per yr 7.91% 7.44% % Tot Ret 42.73% 32.36% Price Inc 24.87% P/E:  17.01 16.38 15.46% 23.00% <-IRR #YR-> 5 Price & Div
-$6.80 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $18.63
-$9.04 $0.00 $0.00 $0.00 $0.00 $18.63
-$6.80 $0.68 $0.72 $0.73 $0.75 $0.80 $0.84 $0.84 $0.84 $0.90 $19.59
-$9.04 $0.84 $0.84 $0.84 $0.90 $19.59
Price Median H/L $6.35 $5.89 $5.88 $6.42 $6.59 $6.92 $8.33 $9.63 $9.28 $9.32 $8.14 $8.82 $13.02 $16.69 121.53% 160.09% <-Total Growth 10 Stock Price
Increase -7.29% -0.17% 9.19% 2.73% 5.01% 20.30% 15.62% -3.64% 0.43% -12.67% 8.42% 47.56% 28.20% 8.28% 10.03% <-IRR #YR-> 10 Stock Price
P/E 70.53 -588.50 48.96 58.32 23.54 53.23 16.01 20.05 14.27 -23.88 7.26 13.36 14.30 16.85 6.22% 12.46% <-IRR #YR-> 5 Stock Price
Trailing P/E 317.38 65.39 -587.50 53.46 59.91 24.71 64.04 18.51 19.32 14.33 -20.86 7.88 19.72 18.34 17.89% 18.59% <-IRR #YR-> 10 Price & Div
Median 10, 5 Yrs D.  per yr 8.56% 7.60% % Tot Ret 46.05% 37.87% Price Inc 8.42% P/E:  15.16 13.36 14.04% 20.06% <-IRR #YR-> 5 Price & Div
-$6.42 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $16.69
-$9.28 $0.00 $0.00 $0.00 $0.00 $16.69
-$6.42 $0.68 $0.72 $0.73 $0.75 $0.80 $0.84 $0.84 $0.84 $0.90 $17.65
-$9.28 $0.84 $0.84 $0.84 $0.90 $17.65
Hi Mths Jun99 Sep 00 Nov 01 Mar 02 Dec 03 Feb 04 Jul 05 Feb 06 Nov 07 Jun Dec Dec Dec
Price Hi $7.15 $6.95 $7.90 $6.93 $7.58 $7.76 $9.40 $10.74 $10.60 $9.85 $10.27 $11.05 $15.27 $18.92 93.29% 173.02% <-Total Growth 10 Stock Price
Increase -2.73% 13.67% -12.28% 9.38% 2.37% 21.13% 14.26% -1.30% -7.08% 4.26% 7.59% 38.19% 23.90% 6.81% 10.57% <-IRR #YR-> 10 Stock Price
P/E -695.00 65.83 63.00 27.07 59.69 18.08 22.38 16.31 -25.26 9.17 16.74 16.78 19.11 7.29% 12.29% <-IRR #YR-> 5 Stock Price
Trailing P/E 77.22 -790.00 57.75 68.91 27.71 72.31 20.65 22.08 15.15 -26.33 9.87 23.14 20.79
Median 10, 5 Yrs Price Inc 7.59% P/E:  17.43 16.74
-$6.93 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $18.92
-$10.60 $0.00 $0.00 $0.00 $0.00 $18.92
Low Mths Dec 99 Feb 00 Feb 01 Nov 02 Feb 03 May 04 Mar 05 Nov 06 Jan 07 Dec Mar May Aug
Price Low $5.55 $4.82 $3.85 $5.90 $5.60 $6.08 $7.25 $8.51 $7.95 $8.78 $6.00 $6.59 $10.76 $14.45 179.48% 144.92% <-Total Growth 10 Stock Price
Increase -20.12% 53.25% -5.08% 8.57% 19.24% 17.38% -6.58% 10.44% -31.66% 9.83% 63.28% 34.29% 10.82% 9.37% <-IRR #YR-> 10 Stock Price
P/E -482.00 32.08 53.64 20.00 46.77 13.94 17.73 12.23 -22.51 5.36 9.98 11.82 14.60 4.80% 12.69% <-IRR #YR-> 5 Stock Price
Trailing P/E 53.56 -385.00 49.17 50.91 21.71 55.77 16.37 16.56 13.51 -15.38 5.88 16.30 15.88
Median 10, 5 Yrs Price Inc 10.44% P/E:  13.09 9.98
-$5.90 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $14.45
Market Cap $417 $359 $417 $498 $458 $999 $1,650 $1,855 $1,824 $2,096 $1,573 $2,753 $3,850 $4,807 $4,771
Equity Iss Equity Issu
# of Sh in M 73.20 73.20 73.20 73.20 73.88 128.78 180.09 184.59 201.73 220.88 223.10 254.65 258.04 258.04 258.04 252.52% <-Total Growth 10 Shares
Increase 0.00% 0.00% 0.00% 0.00% 0.92% 74.32% 39.85% 2.50% 9.28% 9.49% 1.01% 14.14% 1.33% 0.00% 0.00% 5.89% <-Median-> 10 Shares
CF fr Op $M $56.0 $51.5 $52.3 $52.9 $52.8 $60.6 $133.8 $171.8 $201.6 $234.1 $321.1 $281.8 $349.6 $392.2 $387.1 561.45% <-Total Growth 8 Cash Flow
OPS $0.76 $0.70 $0.71 $0.72 $0.72 $0.47 $0.74 $0.93 $1.00 $1.06 $1.44 $1.11 $1.35 $1.52 $1.50 89.52% <-Total Growth 10 Cash Flow
Increase 797.47% -7.96% 1.54% 1.08% -0.99% -34.23% 57.89% 25.30% 7.38% 6.02% 35.83% -23.13% 22.42% 12.20% -1.32% 6.60% <-IRR #YR-> 10 Cash Flow
non-cash $M -$1.04 -$1.69 -$0.04 -$0.95 $0.73 $28.17 $16.24 -$18.88 $3.77 $12.83 -$40.67 12.374 -15.901 0.000 0.000 7.79% <-IRR #YR-> 5 Cash Flow
OPS Less Non-Cash $0.75 $0.68 $0.71 $0.71 $0.73 $0.69 $0.83 $0.83 $1.02 $1.12 $1.26 $1.16 $1.29 $1.52 $1.50 6.11% <-IRR #YR-> 10 CF - non cash
Increase -9.29% 4.90% -0.66% 2.22% -4.96% 20.87% -0.54% 22.89% 9.78% 12.46% -8.11% 11.94% 17.55% -1.32% 9.31% <-IRR #YR-> 5 CF - non cash
P/O on Cl 7.59 7.20 7.98 9.58 8.55 11.26 11.00 12.13 8.88 8.49 5.61 9.36 11.54 12.26 12.33
*Operational Cash Flow per share P/CF 10 Yrs  9.64 5 Yrs   8.77
-$0.71 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1.35
-$0.93 $0.00 $0.00 $0.00 $0.00 $1.35
OPM 68.30% 66.96% 62.94% 57.45% 50.69% 34.05% 27.74% 18.54% 19.94% 20.44% 26.22% 30.48% 35.06% should be zero, it is a check on calculations
Diff from Ave 134.6% 130.0% 116.2% 97.4% 74.1% 17.0% -4.7% -36.3% -31.5% -29.8% -9.9% 4.7% 20.4% 0.00 <-Median-> 10 OPM
*Operational Profit Margin (CF/Revenue) Ratio OPM 10 Yrs 29.11% 5 Yrs 26.22%
Q3 2011
Curr Assets $20.30 $26.87 $24.07 $30.20 $167.37 $44.86 $127.82 $198.44 $160.85 $191.95 $231.27 $162.00 $184.03 $174.64 Liq ratio of 1.5 and up, best Assets
Curr Liab. $21.13 $25.45 $34.90 $22.92 $26.98 $24.63 $101.59 $147.78 $159.52 $240.87 $269.45 $308.61 $596.57 $1,758.52 1.13 <-Median-> 10 Liabilities
Liquidity 0.96 1.06 0.69 1.32 6.20 1.82 1.26 1.34 1.01 0.80 0.86 0.52 0.31 0.10 0.80 <-Median-> 5 Ratio
Less Long Term Debt $386.58 $1,512.09
Liquidity 0.88 0.71
Liq. with CF aft div 1.44 1.30
Liq. CF re  Inv+Div  0.56 1.30
Assets $659 $624 $585 $617 $751 $985 $1,743 $2,082 $2,157 $3,550 $4,126 $4,473 $4,712 $4,779 A/L ratio of 1.5 and up, best Assets
Liab. $22 $34 $34.90 $108 $262 $227 $678 $1,049 $959 $2,486 $2,996 $3,153 $3,379 $3,375 2.12 <-Median-> 10 Liabilities
Liquidity 29.79 18.18 16.75 5.71 2.86 4.33 2.57 1.98 2.25 1.43 1.38 1.42 1.39 1.42 1.42 <-Median-> 5 Ratio
Book Value $637 $589 $550 $509 $489 $758 $1,065 $1,033 $1,198 $1,064 $1,130 $1,320 $1,333 $1,404 $1,404 142.48% <-Total Growth 10 Book Value
BV per share $8.70 $8.05 $7.51 $6.95 $6.61 $5.89 $5.91 $5.60 $5.94 $4.82 $5.07 $5.18 $5.17 $5.44 $5.44 -31.22% <-Total Growth 10 Book Value
Change -7.20% -7.48% -6.71% -7.39% -4.90% -11.01% 0.44% -5.34% 6.15% -18.90% 5.14% 2.34% -0.35% 5.36% 2.2124 Current/Historical Book Value
P/BV (CL) 0.66 0.61 0.76 0.98 0.94 1.32 1.55 1.80 1.52 1.97 1.39 2.09 2.89 3.42 3.40 -3.67% <-IRR #YR-> 10 Book Value
Change -38.58% -7.08% 24.69% 28.82% -4.13% 40.65% 17.52% 15.90% -15.26% 29.44% -29.34% 49.83% 38.51% 18.51% -1.59% <-IRR #YR-> 5 Book Value
Leverage (A/BK) 1.03 1.06 1.06 1.21 1.54 1.30 1.64 2.02 1.80 3.34 3.65 3.39 3.54 3.40 1.91 <-Median-> 10 A/BV
Debt/Equity Ratio 0.03 0.06 0.06 0.21 0.54 0.30 0.64 1.02 0.80 2.34 2.65 2.39 2.54 2.40 0.91 <-Median-> 10 Debt/Eq Ratio
Sharerholders Equity (Assets less liabilities) P/BV 10 yr Med 1.54 5 yr Med 1.97
-$7.51 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5.17
-$5.60 $0.00 $0.00 $0.00 $0.00 $5.17
ROE -11.4% 20.9% 10.2% 15.5% 18.6% <-12 mths 12.89% <-Median-> 4 Compreh. Inc
Comprehensive Inc -$121.12 $236.64 $135.22 $207.20 $261.66 <-12 mths Compreh. Inc
ROE 1.1% -0.1% 1.6% 1.6% 4.2% 1.8% 7.6% 8.6% 10.9% -7.5% 22.1% 11.9% 17.6% 18.6% <-12 mths Net Income/Shareholders' equity
5Yr Median 1.1% 1.6% 1.6% 1.8% 4.2% 7.6% 7.6% 8.6% 10.9% 11.9% 17.6% <-12 mths
Net Income $6.95 -$0.80 $8.78 $8.15 $20.58 $13.59 $81.09 $89.26 $130.61 -$80.02 $249.70 $157.68 $234.77 $260.95 <-12 mths 2575.43% <-Total Growth 10 Net Income
Oper C. F. $55.98 $51.53 $52.32 $52.89 $52.85 $60.59 $133.79 $171.83 $201.64 $234.08 $321.14 $281.79 $349.57 C F Statement  Oper C. F.
Invest. C. F -$1.13 -$6.72 -$7.38 -$70.88 -$17.37 -$415.75 -$727.50 -$305.43 -$65.84 -$652.61 -$613.94 -$604.13 -$331.51 C F Statement  Invest. C. F
Total Accruals -$47.91 -$45.61 -$36.17 $26.14 -$14.90 $368.75 $674.80 $222.86 -$5.20 $338.51 $542.49 $480.03 $216.71 Accruals
Total Assets $659 $624 $585 $617 $751 $985 $1,743 $2,082 $2,157 $3,550 $4,126 $4,473 $4,712 Balance Sheet Assets
Accruals Ratio -7.27% -7.31% -6.19% 4.24% -1.98% 37.42% 38.72% 10.70% -0.24% 9.54% 13.15% 10.73% 4.60% Ratio
up/down/neutral Need free cash flow (cash from operations, with depreciation and amortization added back and capital spending subtracted) to amply cover the payouts.
Chge in Close -43.00% -14.04% 16.33% 19.30% -8.82% 25.16% 18.04% 9.72% -10.05% 4.98% -25.71% 53.33% 38.02%
Any Predictions?
Fin. C. F -$47.31 -$40.46 $56.43 $36.40 $98.14 $207.33 $591.29 $147.44 -$139.07 $416.90 $293.70 $328.33 -$12.95 C F Statement  Fin. C. F
Total Accruals -$0.60 -$5.15 -$92.60 -$10.26 -$113.05 $161.42 $83.51 $75.42 $133.88 -$78.39 $248.80 $151.70 $229.66 Accruals
Accruals Ratio -0.09% -0.83% -15.84% -1.66% -15.06% 16.38% 4.79% 3.62% 6.21% -2.21% 6.03% 3.39% 4.87% Ratio
Jan 7, 2012.  Last I looked I got estimates for 2010 and 2011 of $.91 and $.81 for EPS and $1.28 and $1.38 for CF.
Dec 18, 2010.  The last time I looked, I got 2009 estimates for earnings of $.65 and Cash Flow of $1.09
Old name: KOCH PIPELINES, started 1997
Jan 7, 2012. They have credit facilities set up to handle their debt, including the current portion of the long term debt.
How they make their money.
Inter Pipeline is a major petroleum transportation, natural gas liquids extraction, and bulk liquid storage business based in Calgary, Alberta, Canada. Structured as a publicly traded limited partnership, Inter 
Pipeline owns and operates energy infrastructure assets in western Canada, the United Kingdom, Germany and Ireland.  The company is a limited partnership, not an income trust.
Pipeline Management Inc., the general partner of Inter Pipeline, holds a 0.1% partnership interest represented by Class B units and public unitholders hold the remaining 
99.9% partnership interest, as limited partners, which are represented by Class A units. Inter Pipeline's Class A units are widely held.
Inter Pipeline currently makes monthly cash distributions to holders of the Class A limited liability partnership units (Class A units) and Class B unlimited liability partnership units (Class B units)
(collectively Partnership units).  Class A is what is sold on TSX.
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.
31.941
Institutions 1.181 3.57%
33.122