# Duke Energy: Inside The Numbers

Determining a company's financial health is a very important step in making a decision whether or not to invest or to stay invested. There are many different ways to compute a company's financial health. In this test, I will be considering Duke Energy Corporation's (NYSE:DUK) profitability, debt and capital, and operating efficiency. Based on this criteria, we get to see sales, returns, margins, liabilities, assets, returns and turnovers.

Profitability

Profitability is a class of financial metrics that are used to assess a business' ability to generate earnings, compared with expenses and other relevant costs incurred during a specific period of time.

In this section, we will look at four tests of profitability. They are: Net Income, Operating Cash Flow, Return on Assets and Quality of Earnings. From these four metrics, we will establish if the company is making money, and gauge the quality of the reported profits.

1. Net Income 2011 = \$1.706 billion

To pass, the company needs to have a positive net income. Duke Energy passes.

1. Operating Cash Flow 2011 = \$2.769 billion

Operating Cash Flow is the cash generated from the operations of a company, generally defined as revenue less all operating expenses, but calculated through a series of adjustments to net income.

To pass, the company needs to have a positive operating cash flow. Duke Energy passes.

1. ROA - Return On Assets

ROA is an indicator of how profitable a company is relative to its total assets. ROA gives an idea as to how efficient management is at using its assets to generate earnings. Calculated by dividing a company's net income by its total assets, ROA is displayed as a percentage. Sometimes this is referred to as "return on investment."

• ROA in 2010 = 2.23%

• ROA in 2011 = 2.73%

• Net income growth, 2010 = \$1.320 billion to 2011 = \$1.706 billion, a increase of 29.24%

• Total Asset growth, 2010 = \$59.090 billion to 2011 = \$62.526 billion, an increase of 5.81%

In 2010-2011, Duke Energy's ROA rose from 2.23% to 2.73%. Duke Energy passes.

1. Quality of Earnings

Quality of Earnings is the amount of earnings attributable to higher sales or lower costs rather than artificial profits created by accounting anomalies such as inflation of inventory.

• Operating Cash Flow 2011 = \$2.769 billion

• Net Income 2011 = \$1.706 billion

To pass, the operating cash flow must exceed the net income. Duke Energy passes, Operating Cash Flow exceeds net income.

Debt and Capital

The Debt and Capital section establishes if the company is sinking into debt or digging its way out. It will also determine if the company is growing organically or raising cash by selling off stock.

1. Total Liabilities to Total Assets or TL/A ratio.

TL/A ratio is a metric used to measure a company's financial risk by determining how much of the company's assets have been financed by debt.

• Total Assets - 2010 = \$59.090 billion

• Total Assets - 2011 = \$62.526 billion

• Equals an increase of 5.8%

• Total Liabilities 2010 = \$36.568 billion

• Total liabilities 2011 = \$39.754 billion

• Equals an increase of 8.71%

Duke Energy's increase in total assets was less than the percentage increase of total liabilities. Total assets increased by 5.81%, while the total liabilities increased by 8.71%. As the total assets did not exceed the total liabilities, Duke Energy does not pass.

1. Working Capital

Working Capital is a general and quick measure of liquidity of a firm. It represents the margin of safety or cushion available to the creditors. It is an index of the firm's financial stability. It is also an index of technical solvency and an index of the strength of working capital.

• Current Assets / Current liabilities

• Current Ratio 2010 = 1.60

• Current Ratio 2011 = 1.24

Duke Energy's current ratio went from 1.60 in 2010 to 1.24 in 2011. As Duke Energy's current ratio decreased, Duke Energy does not pass.

1. Shares Outstanding
• 2010 Shares Outstanding = 443.0 million

• 2011 Shares Outstanding = 445.33 million

To pass, the company's shares must increase less than by 2%. Duke Energy's shares increased by 0.53%. Duke Energy passes.

Operating Efficiency

Operating Efficiency is a market condition that exists when participants can execute transactions and receive services at a price that equates fairly to the actual costs required to provide them. An operationally efficient market allows investors to make transactions that move the market further toward the overall goal of prudent capital allocation without being chiseled down by excessive frictional costs, which would reduce the risk/reward profile of the transaction.

1. Gross Margin: Gross Income / Sales

The gross profit margin is a measurement of a company's manufacturing and distribution efficiency during the production process. The gross profit tells an investor the percentage of revenue / sales left after subtracting the cost of goods sold. A company that boasts a higher gross profit margin than its competitors and industry is more efficient. Investors tend to pay more for businesses that have higher efficiency ratings than their competitors, as these businesses should be able to make a decent profit as long as overhead costs are controlled (overhead refers to rent, utilities, etc.)

• Gross Margin 2010 = \$9.347 billion/ \$14.272 billion = 65.49%
• Gross Margin 2011 = \$9.384 billion/ \$14.529 billion = 64.59%

The gross margin increased from 65.49% in 2010 to 64.59% in 2011. As the gross margin decreased, Duke Energy does not pass.

1. Asset Turnover:

The formula for the asset turnover ratio evaluates how well a company is utilizing its assets to produce revenue.

The numerator of the asset turnover ratio formula shows revenues found on a company's income statement and the denominator shows total assets, which is found on a company's balance sheet. Total assets should be averaged over the period of time that is being evaluated.

• Sales growth - 2010 sales = \$14.272 billion

• Sales growth - 2011 sales = \$14.529 billion

• 1.80% sales increase

• Asset growth - Assets in 2010 = \$59.090 billion

• Asset growth - Assets in 2011 = \$62.526 billion

• Asset increase of 5.81%

As the sales growth did not exceed the asset growth, this implies that the sales did not keep up with the asset growth. Duke Energy does not pass.

Based on the nine tests that Duke Energy Corp. received on profitability, debt and capital, and operating efficiency, the company achieved six passes out of nineâ€”this is a strong grade for financial health. Duke Energy declined in the working capital, the asset turnover and the TL/A aspects of the test. The working capital implies the company does not have as much liquidity as the year before while the asset turnover aspect of the test implies that the sales did not keep up with the asset growth in 2011. None of these declines raise any red flags, as the degradations were very minor. Based on the nine tests, overall, the company is showing strong results with six passes out of nine.

This shows that Duke Energy is very profitable, and very efficient. Based on the nine tests, overall, the company is showing strong results.

Disclosure: I have no positions in any stocks mentioned, and no plans to initiate any positions within the next 72 hours.