I'm looking for something similar to this, but for Xcel Energy.
The analysis of the Statement of Cash Flow for Starbucks Corporation:
Operating cash flows/current liabilities
2012: 1,750/2,210 = .79
2011: 1,612/2,076 = .78
2010: 1,705/1,779 = .96
The operating cash flows/current liabilities for Starbucks dropped in 2011, but increased slightly in 2012. The liquidity is worse than it was in 2010, but is showing improvement from 2011 to 2012. The ability to meet current maturities of debt is lower than it was in 2010, meaning that it would be more difficult to cover current liabilities with current cash flows today, than it would have been in 2010. The fact that it did increase from 2011 to 2012 shows that they are working to improve this position.
Operating cash flow/total debt
2012: 1,750/3,110 = .56
2011: 1,612/2,976 = .54
2010: 1,705/2,711 = .63
The operating cash flow/total debt showed a decrease from 2012 to 2011, but increased in 2012. This increase shows that Starbucks is in a better position to carry total debt than they were in 2011.
Operating cash flow per share
2012: 1,750,300,000/751,400,000 = $2.33
This number shows that the company is making good capital expenditure decisions and is able to pay out dividends.
Operating cash flow/cash dividends
2012: 1,750/513 = 3.41
2011: 1,612/390 = 4.13
2010: 1,705/171 = 9.97
The operating cash flow/cash dividends ratio has decreased over the last three years. Starbucks is paying out an increasing number of dividends, but is not increasing cash flow from operating activities at a similar pace. The biggest change in the operating activities occurred in the Changes in Inventory section. Starbucks has purchased an increasingly larger amount of inventory, which is directly affecting the Total Cash Flows from Operating Activities, which in turn is affecting this ratio negatively.
Starbucks Corporation. Balance statement for September 30, 2012, October 2, 2011 and October 3, 2010. Retrieved from http://finance.yahoo.com/q/bs?s=SBUX+Balance+Sheet&annual