Finance homework help please

profileHannah777
copy_of_portfolio_3.xlsx
Home>Business & Finance homework help>Finance homework help please

Sheet1

Portfolio 3: Five Individual Stocks
Stock name: 1-NIKE inc (NKE)
Current price:99.55
10-Yrstotal returns
History (03/31/2015) 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014
NKE -3.13 15.6 31.7 -19.15 31.55 30.98 14.33 8.64 54.09 23.54
Footwear & Accessories -3.08 20.4 21.46 -30.05 38.88 42.22 10.16 9.7 50.53 18.53
S&P 500 TR USD 4.91 15.79 5.49 -37 26.46
10-yrs dividend history
Ex/Eff Date Type Cash Amount Declaration Date Record Date Payment Date
2/26/15 Cash 0.28 2/12/15 3/2/15 4/6/15
12/11/14 Cash 0.28 11/20/14 12/15/14 1/5/15
8/28/14 Cash 0.24 8/11/14 9/2/14 10/6/14
5/29/14 Cash 0.24 5/12/14 6/2/14 7/7/14
2/27/14 Cash 0.24 2/13/14 3/3/14 4/7/14
12/12/13 Cash 0.24 11/21/13 12/16/13 1/6/14
8/29/13 Cash 0.21 8/12/13 9/3/13 10/7/13
5/30/13 Cash 0.21 5/13/13 6/3/13 7/1/13
2/28/13 Cash 0.21 2/14/13 3/4/13 4/1/13
12/6/12 Cash 0.42 11/16/12 12/10/12 12/26/12
8/30/12 Cash 0.36 8/13/12 9/4/12 10/1/12
5/31/12 Cash 0.36 5/14/12 6/4/12 7/2/12
3/1/12 Cash 0.36 2/16/12 3/5/12 4/2/12
12/1/11 Cash 0.36 11/17/11 12/5/11 1/3/12
9/1/11 Cash 0.31 8/15/11 9/6/11 10/3/11
6/2/11 Cash 0.31 5/16/11 6/6/11 7/1/11
3/3/11 Cash 0.31 2/17/11 3/7/11 4/1/11
12/2/10 Cash 0.31 11/18/10 12/6/10 12/30/10
9/2/10 Cash 0.27 8/16/10 9/7/10 10/1/10
6/3/10 Cash 0.27 5/17/10 6/7/10 7/1/10
3/4/10 Cash 0.27 2/11/10 3/8/10 4/1/10
12/3/09 Cash 0.27 11/19/09 12/7/09 1/4/10
9/3/09 Cash 0.25 8/10/09 9/8/09 10/1/09
6/4/09 Cash 0.25 5/12/09 6/8/09 7/1/09
3/5/09 Cash 0.25 2/13/09 3/9/09 4/1/09
12/4/08 Cash 0.25 11/20/08 12/8/08 1/5/09
9/4/08 Cash 0.23 8/11/08 9/8/08 10/1/08
6/5/08 Cash 0.23 5/12/08 6/9/08 7/1/08
3/6/08 Cash 0.23 2/14/08 3/10/08 4/1/08
12/6/07 Cash 0.23 11/16/07 12/10/07 1/2/08
9/6/07 Cash 0.185 8/13/07 9/10/07 10/1/07
6/7/07 Cash 0.185 5/14/07 6/11/07 7/2/07
3/8/07 Cash 0.37 2/14/07 3/12/07 4/2/07
12/7/06 Cash 0.37 11/17/06 12/11/06 1/2/07
9/7/06 Cash 0.31 8/14/06 9/11/06 10/2/06
6/8/06 Cash 0.31 5/15/06 6/12/06 7/3/06
3/9/06 Cash 0.31 2/21/06 3/13/06 4/3/06
12/8/05 Cash 0.31 11/18/05 12/12/05 1/3/06
9/8/05 Cash 0.25 8/15/05 9/12/05 10/3/05
6/9/05 Cash 0.25 5/16/05 6/13/05 7/5/05
3/10/05 Cash 0.25
Read more: http://www.nasdaq.com/symbol/nke/dividend-history#ixzz3WIiJyi2f
Profitability
Profitability 2005-05 2006-05 2007-05 2008-05 2009-05 2010-05 2011-05 2012-05 2013-05 2014-05
Tax Rate % 34.85 35 32.2 24.75 24.01 24.24 25 25.48 24.69 24.01
Net Margin % 8.82 9.31 9.14 10.11 7.75 10.03 10.22 9.21 9.82 9.69
Asset Turnover (Average) 1.65 1.6 1.59 1.61 1.49 1.37 1.42 1.58 1.53 1.54
Return on Assets % 14.52 14.92 14.51 16.28 11.57 13.78 14.5 14.59 15.04 14.89
Financial Leverage (Average) 1.56 1.57 1.52 1.59 1.52 1.48 1.52 1.49 1.58 1.72
Return on Equity % 23.24 23.34 22.41 25.36 18 20.67 21.77 21.98 23.08 24.5
Return on Invested Capital % 20.2 20.77 20.49 24.22 16.56 19.21 20.49 20.9 21.32 21.77
Interest Coverage — — — —
Growth
2005-05 2006-05 2007-05 2008-05 2009-05 2010-05 2011-05 2012-05 2013-05 2014-05 Latest Qtr
Revenue %
Year over Year 12.13 8.84 9.17 14.09 2.95 -0.85 9.72 15.66 4.91 9.82 14.76
3-Year Average 11.57 11.82 10.04 10.68 8.64 5.21 3.85 7.96 10.01 10.04 —
5-Year Average 8.84 9.53 10.54 11.73 9.37 6.71 6.88 8.13 6.33 7.71 —
10-Year Average 11.18 8.74 5.92 6.91 8.13 7.77 8.2 9.33 9 8.54 —
Operating Income %
Year over Year 22.2 11.38 1.07 14.16 -23.63 33.12 13.78 7.99 7.04 13.09 20.46
3-Year Average 21.04 19.19 11.22 8.72 -4.13 5.09 4.97 17.82 9.57 9.34 —
5-Year Average 13.97 15.77 14.83 14.33 3.7 5.49 5.94 7.36 5.98 14.64 —
10-Year Average 10.69 8.02 4.45 10.91 8.05 9.65 10.75 11.03 10.08 9.03 —
Net Income %
Year over Year 28.13 14.89 7.15 26.28 -21.06 28.25 11.87 4.22 11.79 8.37 —
3-Year Average 22.24 43.2 16.41 15.84 2.22 8.53 4.24 14.35 9.23 8.08 —
5-Year Average 15.91 18.74 17.59 31.77 9.47 9.49 8.91 8.31 5.7 12.62 —
10-Year Average 11.73 9.67 6.48 16.77 12.66 12.66 13.72 12.86 18.02 11.03 —
EPS %
Year over Year 27.64 17.86 10.98 27.65 -18.98 27.39 13.73 7.74 14.59 9.59 25.42
3-Year Average 22.45 43.95 18.63 18.63 4.7 9.62 5.49 16 11.98 10.6 —
5-Year Average 16.7 19.57 19.15 33.41 11.54 11.5 10.71 10.05 7.7 14.41 —
10-Year Average 12.66 10.85 8.14 18.67
Cash flow
Cash Flow Ratios 2005-05 2006-05 2007-05 2008-05 2009-05 2010-05 2011-05 2012-05 2013-05 2014-05
Operating Cash Flow Growth % YOY 3.72 6.19 12.64 3.07 -10.34 82.26 -42.73 4.8 59.4 -0.79
Free Cash Flow Growth % YOY 1.01 1.57 17.31 -4.99 -13.9 120.95 -51.22 -5.65 83.64 -11.21
Cap Ex as a % of Sales 1.87 2.23 1.92 2.41 2.38 1.76 2.07 2.47 2.51 3.17
Free Cash Flow/Sales % 9.56 8.92 9.59 7.98 6.68 14.88 6.61 5.4 9.45 7.64
Free Cash Flow/Net Income 1.08 0.96 1.05 0.79
Financial health
Balance Sheet Items (in %) 2005-05 2006-05 2007-05 2008-05 2009-05 2010-05 2011-05 2012-05 2013-05 2014-05 Latest Qtr
Cash & Short-Term Investments 20.75 23.33 26.64 22.31 26.08 35.69 30.26 24.29 33.92 27.65 24.59
Accounts Receivable 25.72 24.28 23.34 22.47 21.77 18.38 20.92 21.21 17.73 18.47 18.04
Inventory 20.6 21.04 19.85 19.6 17.79 14.15 18.1 21.66 19.53 21.23 21.65
Other Current Assets 5.15 5.91 5.73 6.67 7.83 7.79 6.04 7.4 6.31 6.31 8.94
Total Current Assets 72.22 74.56 75.56 71.04 73.47 76 75.32 74.56 77.49 73.66 73.21
Net PP&E 18.26 16.8 15.7 15.2 14.78 13.4 14.1 14.74 13.94 15.24 15.27
Intangibles 6.16 5.43 5.06 9.58 4.99 4.54 4.61 4.76 2.92 2.22 2.15
Other Long-Term Assets 3.36 3.21 3.68 4.18 6.77 6.06 5.96 5.94 5.65 8.88 9.37
Total Assets 100 100 100 100 100 100 100 100 100 100 100
Accounts Payable 9.6 9.65 9.73 10.35 7.79 8.7 9.79 10.27 9.36 10.38 10.82
Short-Term Debt 0.86 3.03 1.23 1.48 2.83 1.01 2.58 1.02 1.01 0.94 1.06
Taxes Payable — — — — 0.65 0.41 0.78 1.59 1.65 3.42 1.48
Accrued Liabilities 11.19 13.04 12.19 14.16 13.46 12.3 13.24 10.7 8.94 10.72 10.85
Other Short-Term Liabilities 1.08 0.87 1.02 0.71 — 0.91 — 1.42 1.36 1.58 1.55
Total Current Liabilities 22.73 26.58 24.18 26.69 24.73 23.33 26.39 24.99 22.33 27.04 25.76
Long-Term Debt 7.82 4.16 3.84 3.55 3.3 3.09 1.84 1.47 6.88 6.45 5.66
Other Long-Term Liabilities 5.26 5.58 6.26 6.87 6.36 5.93 6.14 6.41 7.35 8.3 7.54
Total Liabilities 35.81 36.32 34.27 37.11 34.39 32.36 34.37 32.87 36.56 41.79 38.96
Total Stockholders' Equity 64.19 63.68 65.73 62.89 65.61 67.64 65.63 67.13 63.44 58.21 61.04
Total Liabilities & Equity 100 100 100 100 100 100 100 100 100 100 100
Liquidity/Financial Health 2005-05 2006-05 2007-05 2008-05 2009-05 2010-05 2011-05 2012-05 2013-05 2014-05 Latest Qtr
Current Ratio 3.18 2.81 3.13 2.66 2.97 3.26 2.85 2.98 3.47 2.72 2.84
Quick Ratio 2.04 1.79 2.07 1.68 1.93 2.32 1.94 1.82 2.31 1.71 1.65
Financial Leverage 1.56 1.57 1.52 1.59 1.52 1.48 1.52 1.49 1.58 1.72 1.64
Debt/Equity 0.12 0.07 0.06 0.06 0.05 0.05 0.03 0.02 0.11 0.11 0.09
Efficiency Ratios
Efficiency 2005-05 2006-05 2007-05 2008-05 2009-05 2010-05 2011-05 2012-05 2013-05 2014-05
Days Sales Outstanding 58.21 56.84 54.67 51.83 54.05 53.11 50.63 48.54 46.12 43.01
Days Inventory 82.45 84.79 83.6 81.28 82.78 78.58 76.44 81.05 86.71 87.74
Payables Period 38.48 39.17 39.67 41.49 40.04 40.85 43.78 40.85 41.33 42.51
Cash Conversion Cycle 102.18 102.46 98.6 91.62 96.79 90.84 83.3 88.74 91.49 88.24
Receivables Turnover 6.27 6.42 6.68 7.04 6.75 6.87 7.21 7.52 7.91 8.49
Inventory Turnover 4.43 4.3 4.37 4.49 4.41 4.64 4.77 4.5 4.21 4.16
Fixed Assets Turnover 8.61 9.16 9.79 10.44 9.96 9.78 10.31 10.98 10.7 10.52
Asset Turnover 1.65 1.6 1.59 1.61
Betas: 1.1
P/E ratios: 28.18
PEG. 1.7
S&P 500 index
History (03/31/2015) 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014
S&P 500 TR USD 4.91 15.79 5.49 -37 26.46 15.06 2.11 16 32.39 13.69
S&P 500 P/E. 18.6
risk Free Rate
share outstanding 863,938,522 
—
—
—
—

Sheet2

Stock name. Microsoft corp MSFT
Current price 40.72
10yrs total return
History (03/31/2015) 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014
MSFT -0.94 15.6 20.6 -44.1 59.47 -6.63 -4.55 6.09 43.69 27.24
Software - Infrastructure -2.79 18.21 22.18 -40.18 53.83 12.09 -9.06 14.5 27.8 20.1
S&P 500 TR USD 4.91 15.79 5.49 -37 26.46 15.06 2.11 16 32.39 13.69
+/- Software - Infrastructure 1.86 -2.61 -1.58 -3.93
10-yrs dividend history
Ex/Eff Date Type Cash Amount Declaration Date Record Date Payment Date
5/19/15 Cash 0.31 3/10/15 5/21/15 6/11/15
2/17/15 Cash 0.31 12/3/14 2/19/15 3/12/15
11/18/14 Cash 0.31 9/16/14 11/20/14 12/11/14
8/19/14 Cash 0.28 6/10/14 8/21/14 9/11/14
5/13/14 Cash 0.28 3/11/14 5/15/14 6/12/14
2/18/14 Cash 0.28 11/19/13 2/20/14 3/13/14
11/19/13 Cash 0.28 9/16/13 11/21/13 12/12/13
8/13/13 Cash 0.23 6/12/13 8/15/13 9/12/13
5/14/13 Cash 0.23 3/11/13 5/16/13 6/13/13
2/19/13 Cash 0.23 11/28/12 2/21/13 3/14/13
11/13/12 Cash 0.23 9/18/12 11/15/12 12/13/12
8/14/12 Cash 0.2 6/13/12 8/16/12 9/13/12
5/15/12 Cash 0.2 3/13/12 5/17/12 6/14/12
2/14/12 Cash 0.2 12/14/11 2/16/12 3/8/12
11/15/11 Cash 0.2 9/20/11 11/17/11 12/8/11
8/16/11 Cash 0.16 6/15/11 8/18/11 9/8/11
5/17/11 Cash 0.16 3/14/11 5/19/11 6/9/11
2/15/11 Cash 0.16 12/15/10 2/17/11 3/10/11
11/16/10 Cash 0.16 9/21/10 11/18/10 12/9/10
8/17/10 Cash 0.13 6/16/10 8/19/10 9/9/10
5/18/10 Cash 0.13 3/8/10 5/20/10 6/10/10
2/16/10 Cash 0.13 12/9/09 2/18/10 3/11/10
11/17/09 Cash 0.13 9/18/09 11/19/09 12/10/09
8/18/09 Cash 0.13 6/10/09 8/20/09 9/10/09
5/19/09 Cash 0.13 3/9/09 5/21/09 6/18/09
2/17/09 Cash 0.13 12/10/08 2/19/09 3/12/09
11/18/08 Cash 0.13 9/19/08 11/20/08 12/11/08
8/19/08 Cash 0.11 6/11/08 8/21/08 9/11/08
5/13/08 Cash 0.11 3/17/08 5/15/08 6/12/08
2/19/08 Cash 0.11 12/19/07 2/21/08 3/13/08
11/13/07 Cash 0.11 -- 11/15/07 12/13/07
8/14/07 Cash 0.1 6/27/07 8/16/07 9/13/07
5/15/07 Cash 0.1 3/26/07 5/17/07 6/14/07
2/13/07 Cash 0.1 12/20/06 2/15/07 3/8/07
11/14/06 Cash 0.1 9/13/06 11/16/06 12/14/06
8/15/06 Cash 0.09 6/21/06 8/17/06 9/14/06
5/15/06 Cash 0.09 -- 5/17/06 6/8/06
2/15/06 Cash 0.09 12/14/05 2/17/06 3/9/06
11/15/05 Cash 0.08 9/22/05 11/17/05 12/8/05
8/15/05 Cash 0.08 -- 8/17/05 9/8/05
5/16/05 Cash 0.08 -- 5/18/05 6/9/05
2/15/05 Cash 0.08 -- 2/17/05 3/10/05
Read more: http://www.nasdaq.com/symbol/msft/dividend-history#ixzz3WM65D1Sr
Profitability
Profitability 2005-06 2006-06 2007-06 2008-06 2009-06 2010-06 2011-06 2012-06 2013-06 2014-06
Tax Rate % 26.31 31.01 30.03 25.75 26.5 25 17.53 23.75 19.18 20.65
Net Margin % 30.8 28.45 27.51 29.26 24.93 30.02 33.1 23.03 28.08 25.42
Asset Turnover (Average) 0.49 0.63 0.77 0.89 0.78 0.76 0.72 0.64 0.59 0.55
Return on Assets % 15.02 17.95 21.19 26.01 19.34 22.88 23.77 14.77 16.58 14.02
Financial Leverage (Average) 1.47 1.74 2.03 2.01 1.97 1.86 1.9 1.83 1.8 1.92
Return on Equity % 19.93 28.56 39.51 52.48 38.42 43.76 44.84 27.51 30.09 26.17
Return on Invested Capital % 19.93 28.56 39.51 52.48 33.36 38.75 38.63 23.44 25.7 21.79
Interest Coverage — — — —
Growth
2005-06 2006-06 2007-06 2008-06 2009-06 2010-06 2011-06 2012-06 2013-06 2014-06 Latest Qtr
Revenue %
Year over Year 8.02 11.29 15.45 18.19 -3.28 6.93 11.94 5.4 5.6 11.54 7.96
3-Year Average 11.94 11.22 11.54 14.94 9.69 6.92 5 8.05 7.6 7.48 —
5-Year Average 11.63 11.85 12.5 13.42 9.67 9.45 9.57 7.6 5.2 8.24 —
10-Year Average 20.95 17.71 16.23 15.35 11.46 10.53 10.71 10.02 9.23 8.95 —
Operating Income %
Year over Year 61.18 13.12 12.46 21.42 -9.47 18.34 12.71 -19.87 22.98 3.72 -2.42
3-Year Average 6.93 7.61 27.04 15.6 7.32 9.16 6.49 2.24 3.56 0.73 —
5-Year Average 5.71 7.04 9.24 11.22 17.65 10.6 10.52 3.28 3.54 6.39 —
10-Year Average 21.73 18.26 13.7 12.48 7.32 8.13 8.77 6.21 7.31 11.88 —
Net Income %
Year over Year 50.02 2.82 11.64 25.71 -17.6 28.77 23.4 -26.66 28.77 0.97 —
3-Year Average 16.11 8.03 19.86 13 4.96 10.08 9.4 5.23 5.23 -1.57 —
5-Year Average 5.4 11.39 12.43 12.09 12.27 8.89 12.94 3.84 4.34 8.67 —
10-Year Average 23.77 19.09 15.08 14.69 6.47 7.13 12.16 8.05 8.14 10.45 —
EPS %
Year over Year 49.33 7.14 18.33 31.69 -13.37 29.63 28.1 -25.65 29 1.94 -8.97
3-Year Average 16.68 9.26 23.71 18.63 10.52 13.93 12.89 7.28 7.1 -0.75 —
5-Year Average 5.67 12.7 15.03 15.24 16.65 13.4 17.52 7.09 6.65 10.18 —
10-Year Average 22.68 18.8 15.76 16.18
Cash flow
Cash Flow Ratios 2005-06 2006-06 2007-06 2008-06 2009-06 2010-06 2011-06 2012-06 2013-06 2014-06
Operating Cash Flow Growth % YOY 13.53 -13.26 23.55 21.44 -11.91 26.45 12.13 17.16 -8.83 11.79
Free Cash Flow Growth % YOY 16.84 -18.79 21.1 18.66 -13.63 38.81 11.51 19 -16.18 8.83
Cap Ex as a % of Sales 2.04 3.56 4.43 5.27 5.34 3.16 3.37 3.13 5.47 6.32
Free Cash Flow/Sales % 39.69 28.96 30.38 30.5 27.24 35.36 35.23 39.77 31.57 30.8
Free Cash Flow/Net Income 1.29 1.02 1.1 1.04
Financial health
Balance Sheet Items (in %) 2005-06 2006-06 2007-06 2008-06 2009-06 2010-06 2011-06 2012-06 2013-06 2014-06 Latest Qtr
Cash & Short-Term Investments 53.31 49.08 37.06 32.51 40.37 42.72 48.55 51.98 54.08 49.72 51.62
Accounts Receivable 10.14 13.39 17.95 18.67 14.37 15.11 13.79 13.01 12.28 11.34 9.26
Inventory 0.69 2.12 1.78 1.35 0.92 0.86 1.26 0.94 1.36 1.54 1.17
Other Current Assets 4.68 5.83 6.79 6.88 7.61 5.96 5.32 4.23 3.52 3.67 4.5
Total Current Assets 68.82 70.42 63.59 59.4 63.27 64.65 68.92 70.16 71.24 66.27 66.55
Net PP&E 3.31 4.37 6.89 8.58 9.67 8.86 7.51 6.82 7.01 7.55 7.78
Intangibles 5.38 6.33 8.92 19.34 18.31 15.74 12.26 13.71 12.45 15.73 16.67
Other Long-Term Assets 22.49 18.88 20.6 12.68 8.74 10.75 11.31 9.31 9.29 10.45 8.99
Total Assets 100 100 100 100 100 100 100 100 100 100 100
Accounts Payable 2.95 4.18 5.14 5.54 4.27 4.67 3.86 3.44 3.39 4.31 3.96
Short-Term Debt — — — — 2.57 1.16 — 1.02 2.11 1.16 5.75
Taxes Payable — — — — 0.93 1.25 0.53 0.65 0.42 0.45 0.41
Accrued Liabilities 2.35 2.78 3.68 4.03 4.05 3.81 3.29 3.2 2.89 2.78 1.99
Other Short-Term Liabilities 18.54 25.28 28.78 31.48 22.89 19.47 18.79 18.65 17.47 17.76 15.01
Total Current Liabilities 23.83 32.25 37.6 41.06 34.71 30.36 26.47 26.95 26.27 26.47 27.12
Long-Term Debt — — — — 4.81 5.74 10.97 8.83 8.85 11.98 10.44
Other Long-Term Liabilities 8.22 10.13 13.17 9.1 9.69 10.28 10.05 9.49 9.46 9.47 9.89
Total Liabilities 32.06 42.38 50.77 50.15 49.21 46.38 47.49 45.28 44.57 47.92 47.45
Total Stockholders' Equity 67.94 57.62 49.23 49.85 50.79 53.62 52.51 54.72 55.43 52.08 52.55
Total Liabilities & Equity 100 100 100 100 100 100 100 100 100 100 100
Liquidity/Financial Health 2005-06 2006-06 2007-06 2008-06 2009-06 2010-06 2011-06 2012-06 2013-06 2014-06 Latest Qtr
Current Ratio 2.89 2.18 1.69 1.45 1.82 2.13 2.6 2.6 2.71 2.5 2.45
Quick Ratio 2.66 1.94 1.46 1.25 1.58 1.9 2.35 2.41 2.53 2.31 2.24
Financial Leverage 1.47 1.74 2.03 2.01 1.97 1.86 1.9 1.83 1.8 1.92 1.9
Debt/Equity — — — — 0.09 0.11 0.21 0.16 0.16 0.23 0.2
Efficiency ratios
Efficiency 2005-06 2006-06 2007-06 2008-06 2009-06 2010-06 2011-06 2012-06 2013-06 2014-06
Days Sales Outstanding 59.95 67.99 73.73 75.29 77.39 70.7 73.06 76.16 77.98 77.83
Days Inventory 26.85 46.97 44.46 33.23 25.55 21.45 24.74 26.12 27.71 31.16
Payables Period 111.94 119.16 105.07 114.57 110.48 108.2 96.33 87.16 81.14 83.07
Cash Conversion Cycle -25.15 -4.2 13.13 -6.04 -7.53 -16.05 1.48 15.13 24.56 25.91
Receivables Turnover 6.09 5.37 4.95 4.85 4.72 5.16 5 4.79 4.68 4.69
Inventory Turnover 13.6 7.77 8.21 10.98 14.28 17.01 14.75 13.97 13.17 11.72
Fixed Assets Turnover 17.03 16.43 13.83 11.41 8.48 8.24 8.86 8.97 8.53 7.55
Asset Turnover 0.49 0.63 0.77 0.89
Betas. 1.37
P/E ratios. 16.42
PEG. 1.8
S&P 500 index return
History (03/31/2015) 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014
S&P 500 TR USD 4.91 15.79 5.49 -37 26.46 15.06 2.11 16 32.39 13.69
S&P 500 P/E ratios. 18.6
Risk free rates
share outstanding 8,203,785,341 

Sheet3

Stock name. CVS
Current price. 102.26
10yrs total returns
History (03/31/2015) 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014
CVS 17.88 17.58 29.34 -27.05 13.14 9.03 18.72 20.16 49.89 36.1
Health Care Plans 44.6 -5.81 18.43 -51.57 32.91 12.29 24.84 7.63 40.27 31.7
S&P 500 TR USD 4.91 15.79 5.49 -37 26.46
10yrs dividend history
Ex/Eff Date Type Cash Amount Declaration Date Record Date Payment Date
4/22/15 Cash 0.35 3/4/15 4/24/15 5/4/15
1/20/15 Cash 0.35 12/15/14 1/22/15 2/2/15
10/21/14 Cash 0.275 9/24/14 10/23/14 11/3/14
7/17/14 Cash 0.275 7/10/14 7/21/14 8/1/14
4/17/14 Cash 0.275 3/6/14 4/22/14 5/2/14
1/21/14 Cash 0.275 12/18/13 1/23/14 2/3/14
10/17/13 Cash 0.225 9/25/13 10/21/13 11/1/13
7/18/13 Cash 0.225 7/10/13 7/22/13 8/2/13
4/19/13 Cash 0.225 3/6/13 4/23/13 5/3/13
1/22/13 Cash 0.225 12/13/12 1/24/13 2/4/13
10/18/12 Cash 0.1625 9/19/12 10/22/12 11/2/12
7/19/12 Cash 0.1625 7/5/12 7/23/12 8/3/12
4/19/12 Cash 0.1625 3/7/12 4/23/12 5/3/12
1/19/12 Cash 0.1625 12/20/11 1/23/12 2/2/12
10/19/11 Cash 0.125 9/21/11 10/21/11 11/1/11
7/20/11 Cash 0.125 7/6/11 7/22/11 8/2/11
4/19/11 Cash 0.125 3/9/11 4/22/11 5/3/11
1/19/11 Cash 0.125 1/11/11 1/21/11 2/2/11
10/20/10 Cash 0.0875 9/22/10 10/22/10 11/2/10
7/20/10 Cash 0.0875 7/7/10 7/22/10 8/2/10
4/21/10 Cash 0.0875 3/10/10 4/23/10 5/4/10
1/20/10 Cash 0.0875 1/11/10 1/22/10 2/2/10
10/20/09 Cash 0.07625 9/18/09 10/22/09 11/3/09
7/21/09 Cash 0.07625 7/8/09 7/23/09 8/3/09
4/20/09 Cash 0.07625 3/4/09 4/22/09 5/4/09
1/21/09 Cash 0.07625 1/13/09 1/23/09 2/3/09
10/17/08 Cash 0.069 9/24/08 10/21/08 11/3/08
7/17/08 Cash 0.069 7/9/08 7/21/08 8/1/08
4/17/08 Cash 0.06 3/5/08 4/21/08 5/2/08
1/17/08 Cash 0.06 1/9/08 1/22/08 2/1/08
10/18/07 Cash 0.06 9/26/07 10/22/07 11/2/07
7/19/07 Cash 0.06 7/11/07 7/23/07 8/3/07
4/20/07 Cash 0.06 3/29/07 4/24/07 5/4/07
1/18/07 Cash 0.04875 1/10/07 1/22/07 2/2/07
10/18/06 Cash 0.03875 9/20/06 10/21/06 11/1/06
7/19/06 Cash 0.03875 7/6/06 7/21/06 8/1/06
4/20/06 Cash 0.03875 3/1/06 4/24/06 5/3/06
1/19/06 Cash 0.03875 1/12/06 1/23/06 2/3/06
10/19/05 Cash 0.03625 9/14/05 10/21/05 11/1/05
7/19/05 Cash 0.03625 7/6/05 7/21/05 8/1/05
4/20/05 Cash 0.0725 3/2/05 4/22/05 5/2/05
1/20/05 Cash 0.0725 1/5/05
Read more: http://www.nasdaq.com/symbol/cvs/dividend-history#ixzz3WMBUn6W3
Profitability
Profitability 2005-12 2006-12 2007-12 2008-12 2009-12 2010-12 2011-12 2012-12 2013-12 2014-12
Tax Rate % 35.85 38.5 39.5 39.6 37.29 38.91 39.3 38.61 38.89 39.5
Net Margin % 3.27 3.09 3.44 3.66 3.74 3.55 3.23 3.15 3.62 3.33
Asset Turnover (Average) 2.48 2.44 2.03 1.51 1.61 1.56 1.69 1.89 1.84 1.91
Return on Assets % 8.12 7.56 6.97 5.53 6.03 5.54 5.46 5.94 6.68 6.37
Financial Leverage (Average) 1.88 2.12 1.76 1.77 1.72 1.65 1.7 1.75 1.89 1.96
Return on Equity % 16.29 15.21 12.85 9.76 10.54 9.33 9.14 10.24 12.14 12.24
Return on Invested Capital % 12.92 11.95 10.31 7.99 8.66 7.93 7.97 8.83 9.93 9.81
Interest Coverage — — — —
Growth
2005-12 2006-12 2007-12 2008-12 2009-12 2010-12 2011-12 2012-12 2013-12 2014-12 Latest Qtr
Revenue %
Year over Year 20.96 18.4 74.21 14.6 12.87 -2.35 11.08 14.97 2.95 9.94 13.03
3-Year Average 15.24 18.12 35.63 33.21 31.1 8.1 6.98 7.64 9.55 9.18 —
5-Year Average 13 14.52 25.85 26.89 26.4 21.11 19.57 10.04 7.7 7.14 —
10-Year Average 14.34 23 19.61 19.07 18.49 16.98 17.02 17.68 16.9 16.37 —
Operating Income %
Year over Year 38.83 20.9 96.32 26.14 6.48 -4.24 2.68 14.19 11.19 9.48 5.07
3-Year Average 18.74 92.61 48.81 44.13 38.15 8.75 1.54 3.93 9.24 11.6 —
5-Year Average 8.83 25.94 31.78 77.65 34.65 25.01 20.99 8.56 5.86 6.45 —
10-Year Average 26.4 23.34 22.26 20.58 18.95 16.64 23.44 19.61 37.13 19.72 —
Net Income %
Year over Year 33.29 11.77 92.64 21.81 15.06 -7.28 0.99 12.02 18.44 1.13 —
3-Year Average 19.56 17.34 42.11 37.91 39.25 9.13 2.52 1.61 10.25 10.3 —
5-Year Average 10.42 27.07 29.77 30.54 32.1 22.85 20.38 8.01 7.41 4.67 —
10-Year Average — 33.63 52.92 23.27 19.26 16.47 23.68 18.39 18.41 17.59 —
EPS %
Year over Year 31.82 10.34 20 13.54 16.97 -2.35 3.21 17.9 23.43 5.88 10.48
3-Year Average 18.34 15.81 20.4 14.56 16.81 9.05 5.64 5.92 14.52 15.5 —
5-Year Average 9.65 26.19 17.02 16.18 18.31 11.42 9.94 9.55 11.4 9.2 —
10-Year Average — 27.36 49.25 16.1
Cash flow
Cash Flow Ratios 2005-12 2006-12 2007-12 2008-12 2009-12 2010-12 2011-12 2012-12 2013-12 2014-12
Operating Cash Flow Growth % YOY — 808 — — 223 — — — — —
Free Cash Flow Growth % YOY — — — — — — — — — —
Cap Ex as a % of Sales 4.04 4.04 2.37 2.49 2.58 2.08 1.75 1.65 1.57 1.53
Free Cash Flow/Sales % 0.32 -0.06 1.87 2.02 1.51 2.88 3.72 3.77 3 4.31
Free Cash Flow/Net Income 0.1 -0.02 0.54 0.55
Financial health
Balance Sheet Items (in %) 2005-12 2006-12 2007-12 2008-12 2009-12 2010-12 2011-12 2012-12 2013-12 2014-12 Latest Qtr
Cash & Short-Term Investments 3.36 2.58 1.98 2.22 1.77 2.3 2.2 2.09 5.84 3.39 3.39
Accounts Receivable 12.04 11.56 8.37 8.83 8.85 7.92 9.37 9.82 12.2 13.05 13.05
Inventory 37.42 34.56 14.63 15.01 16.78 17.2 15.56 16.32 15.44 16.07 16.07
Other Current Assets 2.09 1.82 0.87 1.04 1.05 1.05 1.68 1.88 1.92 2.49 2.49
Total Current Assets 54.91 50.52 25.86 27.11 28.45 28.48 28.81 30.12 35.41 34.99 34.99
Net PP&E 25.86 25.93 10.7 13.33 12.85 13.39 13.12 13.1 12.04 11.91 11.91
Intangibles 17 22 63 59 58 57 56 55 50 51 51
Other Long-Term Assets 2.26 1.61 0.67 0.6 0.61 1.11 1.79 1.94 2.12 2.03 2.03
Total Assets 100 100 100 100 100 100 100 100 100 100 100
Accounts Payable 16.14 13.92 6.57 6.23 10.76 10.61 12.17 13.72 14.12 16.1 16.1
Short-Term Debt 4 11 4 6 4 2 1 1 1 2 2
Taxes Payable — — — — — — — — — — —
Accrued Liabilities 9.95 9.48 4.67 5.21 5.27 4.94 5.1 6.15 6.67 7.83 7.83
Other Short-Term Liabilities — — 4.54 4.62 — — — — — — —
Total Current Liabilities 29.99 34.03 20 22 20 18 19 21 22 26 26
Long-Term Debt 10.43 13.95 15.26 13.22 14.2 13.92 14.27 13.86 17.95 15.75 15.75
Other Long-Term Liabilities 5 4 8 8 8 8 8 8 7 8 8
Total Liabilities 45 52 43 43 42 39 41 43 47 49 49
Total Stockholders' Equity 54.51 48.21 57 57 58 61 59 57 53 51 51
Total Liabilities & Equity 100 100 100 100 100 100 100 100 100 100 100
Liquidity/Financial Health 2005-12 2006-12 2007-12 2008-12 2009-12 2010-12 2011-12 2012-12 2013-12 2014-12 Latest Qtr
Current Ratio 1.83 1.48 1.31 1.23 1.43 1.6 1.56 1.44 1.64 1.37 1.37
Quick Ratio 0.51 0.42 0.53 0.5 0.53 0.57 0.62 0.57 0.84 0.64 0.64
Financial Leverage 1.88 2.12 1.76 1.77 1.72 1.65 1.7 1.75 1.89 1.96 1.96
Debt/Equity 0.2 0.3 0.27 0.23
Efficiency ratios
Efficiency 2005-12 2006-12 2007-12 2008-12 2009-12 2010-12 2011-12 2012-12 2013-12 2014-12
Days Sales Outstanding 17.77 17.57 16.63 20.79 20.04 19.65 18.7 18.56 21.89 24.12
Days Inventory 75.23 73.45 45.81 45.27 45.41 50.42 43.74 37.73 38.64 36.78
Payables Period 31.94 30.52 19.57 19.5 17.15 18.18 17.71 17.12 18.82 19.36
Cash Conversion Cycle 61.07 60.49 42.88 46.55 48.31 51.89 44.73 39.17 41.71 41.53
Receivables Turnover 20.54 20.78 21.94 17.56 18.21 18.57 19.52 19.67 16.68 15.14
Inventory Turnover 4.85 4.97 7.97 8.06 8.04 7.24 8.34 9.67 9.45 9.92
Fixed Assets Turnover 9.92 9.44 13.65 12.52 12.3 11.87 12.76 14.4 14.7 15.97
Asset Turnover 2.48 2.44 2.03 1.51
Betas. 0.78
P/E ratios. 25.82
PEG ratios. 1.2
S&P500 index returns
History (03/31/2015) 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014
S&P 500 TR USD 4.91 15.79 5.49 -37 26.46 15.06 2.11 16 32.39 13.69
S&P 500 P/E. 18.6
Risk free rates
share outstanding 1,125,252,739 

Sheet4

Stock name. Coca Cola Coca Cola co. KO
Current price. 40.68
10yrs total returns
History (03/31/2015) 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014
CVS 17.88 17.58 29.34 -27.05 13.14 9.03 18.72 20.16 49.89 36.1
Health Care Plans 44.6 -5.81 18.43 -51.57 32.91 12.29 24.84 7.63 40.27 31.7
S&P 500 TR USD 4.91 15.79 5.49 -37 26.46
10yrs dividend history
Ex/Eff Date Type Cash Amount Declaration Date Record Date Payment Date
3/12/15 Cash 0.33 2/19/15 3/16/15 4/1/15
11/26/14 Cash 0.305 10/16/14 12/1/14 12/15/14
9/11/14 Cash 0.305 7/15/14 9/15/14 10/1/14
6/12/14 Cash 0.305 4/24/14 6/16/14 7/1/14
3/12/14 Cash 0.305 2/20/14 3/14/14 4/1/14
11/27/13 Cash 0.28 10/17/13 12/2/13 12/16/13
9/12/13 Cash 0.28 7/18/13 9/16/13 10/1/13
6/12/13 Cash 0.28 4/25/13 6/14/13 7/1/13
3/13/13 Cash 0.28 2/21/13 3/15/13 4/1/13
11/28/12 Cash 0.255 10/18/12 11/30/12 12/17/12
9/12/12 Cash 0.255 7/30/12 9/14/12 10/1/12
6/13/12 Cash 0.51 4/26/12 6/15/12 7/1/12
3/13/12 Cash 0.51 2/16/12 3/15/12 4/1/12
11/29/11 Cash 0.47 10/20/11 12/1/11 12/15/11
9/13/11 Cash 0.47 7/21/11 9/15/11 10/1/11
6/13/11 Cash 0.47 4/28/11 6/15/11 7/1/11
3/11/11 Cash 0.47 2/17/11 3/15/11 4/1/11
11/29/10 Cash 0.44 10/21/10 12/1/10 12/15/10
9/13/10 Cash 0.44 7/22/10 9/15/10 10/1/10
6/11/10 Cash 0.44 4/22/10 6/15/10 7/1/10
3/11/10 Cash 0.44 2/18/10 3/15/10 4/1/10
11/27/09 Cash 0.41 10/22/09 12/1/09 12/15/09
9/11/09 Cash 0.41 7/23/09 9/15/09 10/1/09
6/11/09 Cash 0.41 4/23/09 6/15/09 7/1/09
3/11/09 Cash 0.41 2/19/09 3/15/09 4/1/09
11/26/08 Cash 0.38 10/16/08 12/1/08 12/15/08
9/11/08 Cash 0.38 7/17/08 9/15/08 10/1/08
6/11/08 Cash 0.38 4/17/08 6/15/08 7/1/08
3/12/08 Cash 0.38 2/21/08 3/15/08 4/1/08
11/28/07 Cash 0.34 10/18/07 12/1/07 12/15/07
9/12/07 Cash 0.34 7/19/07 9/15/07 10/1/07
6/13/07 Cash 0.34 4/19/07 6/15/07 7/1/07
3/13/07 Cash 0.34 2/15/07 3/15/07 4/1/07
11/29/06 Cash 0.31 10/19/06 12/1/06 12/15/06
9/13/06 Cash 0.31 7/20/06 9/15/06 10/1/06
6/13/06 Cash 0.31 4/20/06 6/15/06 7/1/06
3/13/06 Cash 0.31 2/16/06 3/15/06 4/1/06
11/29/05 Cash 0.28 10/20/05 12/1/05 12/15/05
9/13/05 Cash 0.28 7/21/05 9/15/05 10/1/05
6/13/05 Cash 0.28 4/20/05 6/15/05 7/1/05
3/11/05 Cash 0.28 2/17/05
Read more: http://www.nasdaq.com/symbol/ko/dividend-history#ixzz3WMHje6cj
Profitability
Profitability 2005-12 2006-12 2007-12 2008-12 2009-12 2010-12 2011-12 2012-12 2013-12 2014-12
Tax Rate % 35.85 38.5 39.5 39.6 37.29 38.91 39.3 38.61 38.89 39.5
Net Margin % 3.27 3.09 3.44 3.66 3.74 3.55 3.23 3.15 3.62 3.33
Asset Turnover (Average) 2.48 2.44 2.03 1.51 1.61 1.56 1.69 1.89 1.84 1.91
Return on Assets % 8.12 7.56 6.97 5.53 6.03 5.54 5.46 5.94 6.68 6.37
Financial Leverage (Average) 1.88 2.12 1.76 1.77 1.72 1.65 1.7 1.75 1.89 1.96
Return on Equity % 16.29 15.21 12.85 9.76 10.54 9.33 9.14 10.24 12.14 12.24
Return on Invested Capital % 12.92 11.95 10.31 7.99 8.66 7.93 7.97 8.83 9.93 9.81
Interest Coverage — — — —
Growth
2005-12 2006-12 2007-12 2008-12 2009-12 2010-12 2011-12 2012-12 2013-12 2014-12 Latest Qtr
Revenue %
Year over Year 20.96 18.4 74.21 14.6 12.87 -2.35 11.08 14.97 2.95 9.94 13.03
3-Year Average 15.24 18.12 35.63 33.21 31.1 8.1 6.98 7.64 9.55 9.18 —
5-Year Average 13 14.52 25.85 26.89 26.4 21.11 19.57 10.04 7.7 7.14 —
10-Year Average 14.34 23 19.61 19.07 18.49 16.98 17.02 17.68 16.9 16.37 —
Operating Income %
Year over Year 38.83 20.9 96.32 26.14 6.48 -4.24 2.68 14.19 11.19 9.48 5.07
3-Year Average 18.74 92.61 48.81 44.13 38.15 8.75 1.54 3.93 9.24 11.6 —
5-Year Average 8.83 25.94 31.78 77.65 34.65 25.01 20.99 8.56 5.86 6.45 —
10-Year Average 26.4 23.34 22.26 20.58 18.95 16.64 23.44 19.61 37.13 19.72 —
Net Income %
Year over Year 33.29 11.77 92.64 21.81 15.06 -7.28 0.99 12.02 18.44 1.13 —
3-Year Average 19.56 17.34 42.11 37.91 39.25 9.13 2.52 1.61 10.25 10.3 —
5-Year Average 10.42 27.07 29.77 30.54 32.1 22.85 20.38 8.01 7.41 4.67 —
10-Year Average — 33.63 52.92 23.27 19.26 16.47 23.68 18.39 18.41 17.59 —
EPS %
Year over Year 31.82 10.34 20 13.54 16.97 -2.35 3.21 17.9 23.43 5.88 10.48
3-Year Average 18.34 15.81 20.4 14.56 16.81 9.05 5.64 5.92 14.52 15.5 —
5-Year Average 9.65 26.19 17.02 16.18 18.31 11.42 9.94 9.55 11.4 9.2 —
10-Year Average — 27.36 49.25 16.1
Cash flow
Cash Flow Ratios 2005-12 2006-12 2007-12 2008-12 2009-12 2010-12 2011-12 2012-12 2013-12 2014-12
Operating Cash Flow Growth % YOY — 808 — — 223 — — — — —
Free Cash Flow Growth % YOY — — — — — — — — — —
Cap Ex as a % of Sales 4.04 4.04 2.37 2.49 2.58 2.08 1.75 1.65 1.57 1.53
Free Cash Flow/Sales % 0.32 -0.06 1.87 2.02 1.51 2.88 3.72 3.77 3 4.31
Free Cash Flow/Net Income 0.1 -0.02 0.54 0.55
Financial health
Balance Sheet Items (in %) 2005-12 2006-12 2007-12 2008-12 2009-12 2010-12 2011-12 2012-12 2013-12 2014-12 Latest Qtr
Cash & Short-Term Investments 3.36 2.58 1.98 2.22 1.77 2.3 2.2 2.09 5.84 3.39 3.39
Accounts Receivable 12.04 11.56 8.37 8.83 8.85 7.92 9.37 9.82 12.2 13.05 13.05
Inventory 37.42 34.56 14.63 15.01 16.78 17.2 15.56 16.32 15.44 16.07 16.07
Other Current Assets 2.09 1.82 0.87 1.04 1.05 1.05 1.68 1.88 1.92 2.49 2.49
Total Current Assets 54.91 50.52 25.86 27.11 28.45 28.48 28.81 30.12 35.41 34.99 34.99
Net PP&E 25.86 25.93 10.7 13.33 12.85 13.39 13.12 13.1 12.04 11.91 11.91
Intangibles 16.96 21.94 62.78 58.96 58.09 57.03 56.28 54.84 50.43 51.06 51.06
Other Long-Term Assets 2.26 1.61 0.67 0.6 0.61 1.11 1.79 1.94 2.12 2.03 2.03
Total Assets 100 100 100 100 100 100 100 100 100 100 100
Accounts Payable 16.14 13.92 6.57 6.23 10.76 10.61 12.17 13.72 14.12 16.1 16.1
Short-Term Debt 3.89 10.63 3.9 6.07 3.92 2.26 1.25 1.05 0.78 1.7 1.7
Taxes Payable — — — — — — — — — — —
Accrued Liabilities 9.95 9.48 4.67 5.21 5.27 4.94 5.1 6.15 6.67 7.83 7.83
Other Short-Term Liabilities — — 4.54 4.62 — — — — — — —
Total Current Liabilities 29.99 34.03 19.67 22.13 19.95 17.81 18.52 20.92 21.57 25.62 25.62
Long-Term Debt 10.43 13.95 15.26 13.22 14.2 13.92 14.27 13.86 17.95 15.75 15.75
Other Long-Term Liabilities 5.07 3.8 7.83 7.94 7.81 7.64 8.25 8.02 7.44 7.5 7.5
Total Liabilities 45.49 51.79 42.76 43.28 41.97 39.36 41.05 42.8 46.96 48.88 48.88
Total Stockholders' Equity 54.51 48.21 57.24 56.72 58.03 60.64 58.95 57.2 53.04 51.12 51.12
Total Liabilities & Equity 100 100 100 100 100 100 100 100 100 100 100
Liquidity/Financial Health 2005-12 2006-12 2007-12 2008-12 2009-12 2010-12 2011-12 2012-12 2013-12 2014-12 Latest Qtr
Current Ratio 1.83 1.48 1.31 1.23 1.43 1.6 1.56 1.44 1.64 1.37 1.37
Quick Ratio 0.51 0.42 0.53 0.5 0.53 0.57 0.62 0.57 0.84 0.64 0.64
Financial Leverage 1.88 2.12 1.76 1.77 1.72 1.65 1.7 1.75 1.89 1.96 1.96
Debt/Equity 0.2 0.3 0.27 0.23
Efficiency ratios
Efficiency 2005-12 2006-12 2007-12 2008-12 2009-12 2010-12 2011-12 2012-12 2013-12 2014-12
Days Sales Outstanding 17.77 17.57 16.63 20.79 20.04 19.65 18.7 18.56 21.89 24.12
Days Inventory 75.23 73.45 45.81 45.27 45.41 50.42 43.74 37.73 38.64 36.78
Payables Period 31.94 30.52 19.57 19.5 17.15 18.18 17.71 17.12 18.82 19.36
Cash Conversion Cycle 61.07 60.49 42.88 46.55 48.31 51.89 44.73 39.17 41.71 41.53
Receivables Turnover 20.54 20.78 21.94 17.56 18.21 18.57 19.52 19.67 16.68 15.14
Inventory Turnover 4.85 4.97 7.97 8.06 8.04 7.24 8.34 9.67 9.45 9.92
Fixed Assets Turnover 9.92 9.44 13.65 12.52 12.3 11.87 12.76 14.4 14.7 15.97
Asset Turnover 2.48 2.44 2.03 1.51
Betas. 0.68
P/E ratios. 25.58
PEG ratios. 3.2
S&P500 index returns
History (03/31/2015) 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014
S&P 500 TR USD 4.91 15.79 5.49 -37 26.46 15.06 2.11 16 32.39 13.69
S&P500 P/E. 18.6
Risk free rates

Sheet5

Stock name. CVS Helmerich & Payne Inc HP
Current price. 102.26 68.21
10yrs total return
History (03/31/2015) 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014
HP 82.84 -20.39 64.49 -42.75 76.18 22.12 20.92 -3.55 52.44 -16.69
Oil & Gas Drilling 53.85 2.29 45.19 -60.77 82.47 4.16 -14.06 11.88 13.82 -46.93
S&P 500 TR USD 4.91 15.79 5.49 -37 26.46
10yrs dividend history
Ex/Eff Date Type Cash Amount Declaration Date Record Date Payment Date
5/13/15 Cash 0.6875 3/4/15 5/15/15 6/1/15
2/11/15 Cash 0.6875 12/2/14 2/13/15 3/2/15
11/12/14 Cash 0.6875 9/3/14 11/14/14 12/1/14
8/13/14 Cash 0.6875 6/4/14 8/15/14 9/2/14
5/13/14 Cash 0.625 3/5/14 5/15/14 6/2/14
2/12/14 Cash 0.625 12/3/13 2/14/14 3/3/14
11/13/13 Cash 0.5 9/4/13 11/15/13 12/2/13
8/13/13 Cash 0.5 6/5/13 8/15/13 8/30/13
5/13/13 Cash 0.15 3/6/13 5/15/13 5/31/13
2/13/13 Cash 0.15 12/4/12 2/15/13 3/1/13
11/13/12 Cash 0.07 9/5/12 11/15/12 11/30/12
8/13/12 Cash 0.07 6/6/12 8/15/12 8/31/12
5/11/12 Cash 0.07 3/7/12 5/15/12 6/1/12
2/13/12 Cash 0.07 12/6/11 2/15/12 3/1/12
11/10/11 Cash 0.07 9/7/11 11/15/11 12/1/11
8/11/11 Cash 0.07 6/1/11 8/15/11 9/1/11
5/11/11 Cash 0.06 3/2/11 5/13/11 6/1/11
2/11/11 Cash 0.06 12/7/10 2/15/11 3/1/11
11/10/10 Cash 0.06 9/1/10 11/15/10 12/1/10
8/11/10 Cash 0.06 6/2/10 8/13/10 9/1/10
5/12/10 Cash 0.05 3/3/10 5/14/10 6/1/10
2/10/10 Cash 0.05 12/1/09 2/15/10 3/1/10
11/10/09 Cash 0.05 9/2/09 11/13/09 12/1/09
8/12/09 Cash 0.05 6/3/09 8/14/09 9/1/09
5/13/09 Cash 0.05 3/4/09 5/15/09 6/1/09
2/11/09 Cash 0.05 12/2/08 2/13/09 3/2/09
11/12/08 Cash 0.05 9/3/08 11/14/08 12/1/08
8/13/08 Cash 0.05 6/4/08 8/15/08 9/2/08
5/13/08 Cash 0.045 3/5/08 5/15/08 6/2/08
2/13/08 Cash 0.045 12/4/07 2/15/08 3/3/08
11/13/07 Cash 0.045 9/5/07 11/15/07 12/3/07
8/13/07 Cash 0.045 6/6/07 8/15/07 9/4/07
5/11/07 Cash 0.045 3/7/07 5/15/07 6/1/07
2/13/07 Cash 0.045 12/5/06 2/15/07 3/1/07
11/13/06 Cash 0.045 9/6/06 11/15/06 12/1/06
8/11/06 Cash 0.045 6/7/06 8/15/06 9/1/06
5/11/06 Cash 0.0825 3/1/06 5/15/06 6/1/06
2/13/06 Cash 0.0825 12/6/05 2/15/06 3/1/06
11/10/05 Cash 0.0825 9/7/05 11/15/05 12/1/05
8/11/05 Cash 0.0825 6/1/05 8/15/05 9/1/05
5/11/05 Cash 0.0825
Read more: http://www.nasdaq.com/symbol/hp/dividend-history#ixzz3WMKNSPsF
Profitability
Profitability 2005-09 2006-09 2007-09 2008-09 2009-09 2010-09 2011-09 2012-09 2013-09 2014-09
Tax Rate % 41.13 35.01 36.36 36.51 40.36 34.72 36.74 36.45 35.25 35.35
Net Margin % 15.94 23.99 27.57 22.67 18.67 8.34 17.07 18.44 21.75 19.05
Asset Turnover (Average) 0.52 0.65 0.65 0.63 0.49 0.45 0.55 0.59 0.57 0.57
Return on Assets % 8.31 15.47 17.9 14.27 9.12 3.71 9.37 10.84 12.29 10.91
Financial Leverage (Average) 1.54 1.54 1.59 1.58 1.55 1.52 1.53 1.49 1.41 1.37
Return on Equity % 12.8 23.88 28.1 22.63 14.29 5.69 14.29 16.36 17.8 15.18
Return on Invested Capital % 11.72 20.61 23.88 18.74 12.13 5.34 12.9 15.25 17.01 14.81
Interest Coverage — — — —
Growth
2005-09 2006-09 2007-09 2008-09 2009-09 2010-09 2011-09 2012-09 2013-09 2014-09 Latest Qtr
Revenue %
Year over Year 28.96 52.96 33.05 24.97 -7 -1 35.66 23.9 7.48 9.8 18.83
3-Year Average 16.16 33.46 37.94 36.5 15.64 4.79 7.7 18.5 21.79 13.5 —
5-Year Average 4.88 8.18 26.11 31.63 24.99 18.55 15.74 14.1 10.71 14.45 —
10-Year Average 9.41 12.2 12.15 12.33 12.87 11.51 11.89 19.96 20.72 19.6 —
Operating Income %
Year over Year 148.17 132.85 51.53 9.57 -15.77 -22.58 55.49 29.48 5.17 10.26 25.67
3-Year Average 24.8 108.21 106.12 56.95 11.83 -10.6 0.46 15.95 28.41 14.51 —
5-Year Average 5.09 12.16 46.97 71.85 51.88 20.31 10.98 7.54 6.67 12.57 —
10-Year Average 28.86 20.53 16.99 16.3 23.38 12.44 11.57 25.72 35.39 30.75 —
Net Income %
Year over Year 2827.41 130.29 52.88 2.78 -23.43 -55.79 177.77 33.82 26.78 -3.79 —
3-Year Average 26.18 154.28 368.85 53.52 6.36 -29.67 -2.03 18.01 67.66 17.74 —
5-Year Average 9.17 15.29 47.88 91.62 140.89 4.14 8.12 5.28 9.79 14.92 —
10-Year Average 29.26 15.02 18.23 16.39 23.51 6.63 11.65 24.78 45.05 66.38 —
EPS %
Year over Year — 126.12 54.15 1.64 -23.5 -56.33 175.17 33.83 27.15 -4.86 16.35
3-Year Average 24.81 151.08 356.11 52.45 6.22 -30.23 -2.76 17.17 67.3 17.42 —
5-Year Average 8.36 14.3 46.63 90.06 136.37 3.43 7.57 4.57 9.36 14.24 —
10-Year Average 28.47 14.19 17.59 15.81
Cash flow
Cash Flow Ratios 2005-09 2006-09 2007-09 2008-09 2009-09 2010-09 2011-09 2012-09 2013-09 2014-09
Operating Cash Flow Growth % YOY — — — 887 — — — 233 -31 —
Free Cash Flow Growth % YOY — — — — — — — — — —
Cap Ex as a % of Sales 10.84 43.18 54.87 34.65 46.5 17.58 27.29 34.83 23.88 25.62
Free Cash Flow/Sales % 15.66 -18.98 -20.44 -4.66 0.87 7.08 11.14 -3.09 5.55 4.45
Free Cash Flow/Net Income 0.98 -0.79 -0.74 -0.21
Financial health
Balance Sheet Items (in %) 2005-09 2006-09 2007-09 2008-09 2009-09 2010-09 2011-09 2012-09 2013-09 2014-09 Latest Qtr
Cash & Short-Term Investments 17.36 3.87 3.1 3.39 3.7 1.48 7.28 1.68 7.15 5.37 3.7
Accounts Receivable 9.78 13.56 11.78 12.9 5.93 10.73 9.2 10.85 10 10.49 10.8
Inventory 1.28 1.23 1.01 0.92 1.07 1.02 1.09 1.38 1.42 1.58 1.63
Other Current Assets 1.63 1.43 1.4 2.04 1.86 2.08 1.54 1.75 1.52 1.56 1.67
Total Current Assets 30.05 20.08 17.29 19.25 12.57 15.3 19.11 15.65 20.08 19 17.79
Net PP&E 59.04 69.48 74.6 74.76 78.49 76.78 73.48 76.06 74.64 77.19 79.39
Intangibles — — — — — — — — — — —
Other Long-Term Assets 10.92 10.44 8.1 6 8.94 7.91 7.4 8.29 5.28 3.81 2.82
Total Assets 100 100 100 100 100 100 100 100 100 100 100
Accounts Payable 2.7 6.5 4.32 4.29 1.69 1.89 2.08 2.79 2.3 2.71 2.48
Short-Term Debt — 1.35 — 0.75 2.52 — 2.3 0.7 1.84 0.6 0.6
Taxes Payable — — — — — 1.05 — 0.65 0.61 0.79 —
Accrued Liabilities 2.68 4.55 3.54 3.58 3.04 1.86 3.85 2.01 1.92 3.09 3.45
Other Short-Term Liabilities — — — — — 0.66 0.1 0.52 0.54 0.36 0.05
Total Current Liabilities 5.38 12.39 7.85 8.61 7.26 5.45 8.33 6.66 7.22 7.55 6.58
Long-Term Debt 12.02 8.2 15.42 13.24 10.09 8.44 4.7 3.41 1.28 0.6 0.59
Other Long-Term Liabilities 17.71 14.68 13.8 15.01 18.17 20.29 21.63 22.9 20.57 19.09 20.48
Total Liabilities 35.12 35.27 37.08 36.86 35.52 34.18 34.65 32.97 29.07 27.24 27.65
Total Stockholders' Equity 64.88 64.73 62.92 63.14 64.48 65.82 65.35 67.03 70.93 72.76 72.35
Total Liabilities & Equity 100 100 100 100 100 100 100 100 100 100 100
Liquidity/Financial Health 2005-09 2006-09 2007-09 2008-09 2009-09 2010-09 2011-09 2012-09 2013-09 2014-09 Latest Qtr
Current Ratio 5.59 1.62 2.2 2.24 1.73 2.81 2.29 2.35 2.78 2.52 2.7
Quick Ratio 5.04 1.41 1.89 1.89 1.33 2.24 1.98 1.88 2.38 2.1 2.2
Financial Leverage 1.54 1.54 1.59 1.58 1.55 1.52 1.53 1.49 1.41 1.37 1.38
Debt/Equity 0.19 0.13 0.25 0.21 0.16 0.13 0.07 0.05 0.02 0.01 0.01
Efficiency ratios
Efficiency 2005-09 2006-09 2007-09 2008-09 2009-09 2010-09 2011-09 2012-09 2013-09 2014-09
Days Sales Outstanding 67.44 67.37 70.25 71.75 68.38 63.91 62.45 62.6 66.91 65.09
Days Inventory 15.88 13.1 11.71 10.45 14.04 15 12.46 13.89 16.51 17.72
Payables Period 27.46 50.65 55.73 46.76 40.43 25.67 23.49 27.45 29.92 29.64
Cash Conversion Cycle 55.86 29.82 26.23 35.45 41.99 53.25 51.42 49.03 53.49 53.17
Receivables Turnover 5.41 5.42 5.2 5.09 5.34 5.71 5.84 5.83 5.46 5.61
Inventory Turnover 22.98 27.87 31.18 34.92 26 24.33 29.29 26.29 22.1 20.6
Fixed Assets Turnover 0.81 0.99 0.9 0.84 0.64 0.57 0.73 0.79 0.75 0.75
Asset Turnover 0.52 0.65 0.65 0.63
Betas. 1.08
P/E ratios. 10.15
PEG ratios. 49.9
S&P 500 index returns
History (03/31/2015) 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014
S&P 500 TR USD 4.91 15.79 5.49 -37 26.46 15.06 2.11 16 32.39 13.69
S&P 500 P/E. 18.6
Risk free rates 1.89%
SHARE 107.64