This is “Ratio Analysis of Financial Information”, section 13.3 from the book Accounting for Managers (v. 1.0).
For more information on the source of this book, or why it is available for free, please see the project's home page. You can browse or download additional books there. You may also download a PDF copy of this book (83 MB) or just this chapter (10 MB), suitable for printing or most ereaders, or a .zip file containing this book's HTML files (for use in a web browser offline).
Question: Although reviewing trends and using commonsize analysis provides an excellent starting point for analyzing financial information, managers, investors, and other stakeholders also use various ratios to assess the financial performance and financial condition of organizations. What are the four categories of ratios used to evaluate the financial health of an organization?
Answer: The four categories of ratios presented in this chapter are as follows (in order of presentation):
For each ratio, we (1) explain the meaning, (2) provide the formula, (3) calculate the ratio for CocaCola for two years, and (4) compare the ratio for CocaCola to PepsiCo’s ratio and industry averages. (Note: All industry averages throughout this chapter were obtained from http://moneycentral.msn.com. Some averages are not available or not applicable and will be noted as such.)
Table 13.1 "Financial Ratio Formulas" summarizes the formulas for all the ratios presented in this section, and Table 13.2 "Summary of Financial Ratios for " shows the ratio results for CocaCola, PepsiCo, and the industry averages that will be covered throughout this section.
Table 13.1 Financial Ratio Formulas
Profitability Measures 

ShortTerm Liquidity Measures 

LongTerm Solvency Measures 

Market Valuation Measures 

Table 13.2 Summary of Financial Ratios for CocaCola, PepsiCo, and the Industry Average
CocaCola 2010  PepsiCo 2010  Industry Average 2010  

Profitability Measures  
1.  Gross margin ratio  63.9 percent  54.1 percent  56.1 percent 
2.  Profit margin ratio  33.6 percent  10.9 percent  19.2 percent 
3.  Return on assets  19.4 percent  11.7 percent  14.2 percent 
4.  Return on common shareholders’ equity  41.7 percent  32.3 percent  34.7 percent 
5.  Earnings per share  $5.12  $3.97  Not applicable 
ShortTerm Liquidity Measures  
6.  Current ratio  1.17 to 1  1.11 to 1  1.20 to 1 
7.  Quick ratio  0.85 to 1  0.80 to 1  1.10 to 1 
8.  Receivables turnover ratio  8.58 times  10.57 times  9.70 times 
9.  Average collection period  42.54 days  34.53 days  37.63 days 
10.  Inventory turnover ratio  5.07 times  8.87 times  7.50 times 
11.  Average sale period  71.99 days  41.15 days  48.67 days 
LongTerm Solvency Measures  
12.  Debt to assets  0.57 to 1  0.68 to 1  0.48 to 1 
13.  Debt to equity  1.33 to 1  2.17 to 1  0.94 to 1 
14.  Times interest earned  20.36 times  10.10 times  10.70 times 
Market Valuation Measures  
15.  Market capitalization  $146,500,000,000  $100,700,000,000  $87,500,000,000 
16.  Priceearnings ratio  12.48 times  16.04 times  14.60 times 
Before we discuss the various ratios, it is important to note that different terms are often used in financial statements to describe the same item. For example, some companies use the term net revenues instead of net sales, and the income statement is often called the statement of earnings, or consolidated statement of earnings. Also be sure to review the income statement and balance sheet information for CocaCola shown in Figure 13.5 "CommonSize Income Statement Analysis for " and Figure 13.6 "CommonSize Balance Sheet Analysis for ". We refer to these figures throughout this section. (All the dollar amounts given for CocaCola are in millions unless stated otherwise.)
Question: Analysts, shareholders, suppliers, and other stakeholders often want to evaluate profit trends within a company and compare a company’s profits with competitors’ profits. What are the five common ratios used to evaluate company profitability?
Answer: The five ratios used to evaluate profitability are as follows:
Question: How is the gross margin ratio calculated, and what does it tell us about CocaCola relative to PepsiCo and the industry average?
Answer: The gross margin ratioIndicates the gross margin generated for each dollar in net sales. Calculated as gross margin divided by net sales. indicates the gross margin generated for each dollar in net sales and is calculated as gross margin (which is net sales minus cost of goods sold) divided by net sales:
The gross margin ratio for CocaCola using 2010 information is calculated as follows, with PepsiCo and industry average information following it:
$$\text{Grossmargin}\text{ratio}=\frac{\text{\$22,426}}{\text{\$35,119}}=\text{63}.\text{9}\%$$CocaCola 2010  CocaCola 2009  PepsiCo 2010  Industry Average 2010  
Gross margin ratio  63.9 percent  64.2 percent  54.1 percent  56.1 percent 
The gross margin ratio indicates CocaCola generated 63.9 cents in gross margin for every dollar in net sales. This ratio decreased slightly from 2009 to 2010 and is substantially higher than PepsiCo’s 54.1 percent. CocaCola is also higher than the industry average of 56.1 percent. (Alternative terms: Gross margin is often called gross profit, net sales is often called net revenues, and cost of goods sold is often called cost of sales.)
Question: How is the profit margin ratio calculated, and what does it tell us about CocaCola relative to PepsiCo and the industry average?
Answer: The profit margin ratioIndicates the profit generated from each dollar in net sales. Calculated as net income divided by net sales. shows the profit generated for each dollar in net sales. It is calculated as net income divided by net sales:
The profit margin ratio for CocaCola using 2010 information is calculated as follows, with PepsiCo and industry average information following it:
$$\text{Profitmargin}\text{ratio}=\frac{\text{\$11,809}}{\text{\$35,119}}=\text{33}.\text{6}\%$$CocaCola 2010  CocaCola 2009  PepsiCo 2010  Industry Average 2010  
Profit margin ratio  33.6 percent  22.0 percent  10.9 percent  19.2 percent 
The profit margin ratio indicates CocaCola generated 33.6 cents in net income for every dollar in net sales. This ratio increased significantly from 2009 to 2010 and is substantially higher than PepsiCo’s 10.9 percent. CocaCola is also higher than the industry average of 19.2 percent. (Alternative term: Net income is often called net earnings.)
Question: The gross margin ratio and profit margin ratio focus solely on income statement information. Analysts also want to know what size asset base generated the net income. For example, a company with assets of $100,000 and net income of $15,000 is likely performing better than a company with assets of $300,000 and identical net income of $15,000. A measure that considers the assets required to generate net income is called return on assets. How is return on assets calculated, and what does it tell us about CocaCola relative to PepsiCo and the industry average?
Answer: The return on assetsIndicates the net income generated from each dollar in average assets. Calculated as net income divided by average total assets. ratio is used to evaluate how much net income was generated from each dollar in average assets invested. Return on assets is net income divided by average total assets:
The average total assets amount is found by adding together total assets at the end of the current year and previous year (2010 and 2009 for this example) and dividing by two. The return on assets ratio for CocaCola for 2010 is calculated as follows, with PepsiCo and industry average information following it:
$$\text{Returnon}\text{assets}=\frac{\text{\$11,809}}{(\text{\$72,921}+\text{\$48,671})\xf7\text{2}}=\frac{\text{\$11,809}}{\text{\$60,796}}=\text{19}.\text{4}\%$$CocaCola 2010  CocaCola 2009  PepsiCo 2010  Industry Average 2010  
Return on assets  19.4 percent  15.3 percent  11.7 percent  14.2 percent 
The return on assets ratio indicates CocaCola generated 19.4 cents in net income for every dollar in average assets. This ratio increased from 2009 to 2010 and is higher than PepsiCo’s 11.7 percent. CocaCola exceeded the industry average of 14.2 percent.
(Note: There are several variations on the return on assets calculation. Some prefer to use average operating assets in the denominator. Others adjust net income in the numerator by adding back interest expense net of the interest expense tax benefit. We leave these variations to advanced cost and intermediate accounting textbooks.)
Question: How is the return on common shareholders’ equity ratio calculated, and what does it tell us about CocaCola relative to PepsiCo and the industry average?
Answer: Common shareholders are interested in the return on common shareholders’ equityIndicates the net income generated from each dollar of common shareholders’ equity. Calculated as net income minus preferred dividends divided by average common shareholders’ equity. ratio because this ratio tells them how much net income was generated from each dollar of common shareholders’ equity. The return on common shareholders’ equity ratio is calculated as follows:
Note that preferred dividends are deducted from net income in the numerator. If the company does not have any outstanding preferred stock, as is the case with CocaCola, the preferred dividends amount is zero.
Average common shareholders’ equity in the denominator is found by adding together all items in the shareholders’ equity section of the balance sheet at the end of the current year and previous year (2010 and 2009 for this example), except preferred stock items, and dividing by two.
Because CocaCola does not have preferred stock, an average of all items in the shareholders’ equity section is in the denominator. The return on common shareholders’ equity ratio for CocaCola for 2010 is calculated as follows, with PepsiCo and industry average information following it:
$$\begin{array}{cc}\begin{array}{c}\text{Returnon}\text{common}\\ \text{shareholders}\u2019\text{equity}\end{array}& =\frac{\text{\$11}\text{,}\text{8}0\text{9}\mathrm{\$0}}{[(\text{\$1}0\text{,}\text{937}+\text{\$49}\text{,}\text{592}\text{\$1}\text{,}\text{45}0\text{\$27}\text{,}\text{762})+(\text{\$9}\text{,}\text{417}+\text{\$42}\text{,}0\text{84}\text{\$757}\text{\$25}\text{,}\text{398})]\xf7\text{2}}\hfill \\ & =\frac{\text{\$11}\text{,}\text{8}0\text{9}}{\text{\$28}\text{,}\text{332}}\hfill \\ & =\text{41}.\text{7}\%\hfill \end{array}$$CocaCola 2010  CocaCola 2009  PepsiCo 2010  Industry Average 2010  
Return on common shareholders’ equity  41.7 percent  29.5 percent  32.3 percent  34.7 percent 
The return on common shareholders’ equity ratio indicates CocaCola generated 41.7 cents in net income for every dollar in average common shareholders’ equity. This ratio increased significantly from 2009 to 2010 and is higher than PepsiCo’s 32.3 percent. CocaCola exceeded the industry average of 34.7 percent.
CocaCola’s return on common shareholders’ equity of 41.7 percent is higher than its return on assets of 19.4 percent, indicating that the company has positive financial leverage. Financial leverageIndicates the ability of a company to leverage common shareholders’ equity by taking on debt at an interest rate lower than the company’s return on assets. describes a company’s ability to leverage common shareholders’ equity by taking on debt at an interest rate lower than the company’s return on assets. For example, assume a company has equity of $10,000 earning 10 percent. The company can leverage this equity by borrowing $8,000 with a 6 percent interest rate. Assuming the company uses this $8,000 to purchase assets that earn 10 percent, the company has created positive financial leverage since the cost of borrowing is lower than the return on assets. This results in a return on equity that is higher than the return on assets. (Note: For a oneyear period, the return on assets is $1,800 [= $18,000 × 10 percent] less the cost of debt of $480 [= 6 percent × $8,000], or $1,320. This results in a return on assets of 7.3 percent [= $1,320 ÷ $18,000]. Positive financial leverage causes the return on equity to be much higher at 13.2 percent [= $1,320 ÷ $10,000 equity].)
Although some level of financial leverage is generally regarded as healthy, companies that are highly leveraged tend to be riskier than similar companies with less leverage. Analysts and shareholders should avoid drawing quick conclusions that increases in return on common shareholders’ equity are always better than decreases without thoroughly reviewing the rest of the data.
Figure 13.9 "Return on Assets and Return on Equity for " shows the return on assets and return on equity for CocaCola, PepsiCo, and the industry average.
Figure 13.9 Return on Assets and Return on Equity for CocaCola, PepsiCo, and the Industry Average
Question: How is earnings per share calculated, and what does it tell us about CocaCola relative to PepsiCo and the industry average?
Answer: Earnings per shareIndicates how much net income was earned for each share of common stock outstanding. Calculated as net income minus preferred dividends divided by weighted average common shares outstanding. indicates how much net income was earned for each share of common stock outstanding. The earnings per share ratio states net income on a per share basis and is calculated as the following:
Note that preferred dividends are deducted from net income in the numerator. If the company does not have any outstanding preferred stock, as is the case with CocaCola, the preferred dividends amount is zero. The weighted average common shares outstanding amount used in the denominator is typically provided in the financial statements, either on the income statement or in the notes to the financial statements. (More advanced intermediate accounting textbooks discuss this calculation in detail. Throughout this chapter, we provide the number of weighted average common shares outstanding.)
Earnings per share for CocaCola using 2010 information is calculated as follows, with PepsiCo and industry average information following it (dollar amount and shares are in millions, except per share amount):
$$\text{Earnings}\text{pershare}=\frac{\text{\$11,809}\mathrm{\$0}}{\text{2,308shares}}=\text{\$5}.\text{12pershare}$$CocaCola 2010  CocaCola 2009  PepsiCo 2010  Industry Average 2010  
Earnings per share  $5.12  $2.95  $3.97  Not applicable 
The earnings per share amount at CocaCola indicates the company earned $5.12 for each share of common stock outstanding. This ratio increased from 2009 to 2010. Although earnings per share is useful for looking at trends over time within a company, it cannot be compared in any meaningful way from one company to another because different companies have different numbers of shares outstanding.
For example, assume two identical companies earn $10,000 for the year. One company has one share of common stock outstanding, and the other has two shares outstanding. Thus one company has earnings per share of $10,000 (= $10,000 ÷ 1 share) and the other company has earnings per share of $5,000 (= $10,000 ÷ 2 shares). The second company is not performing any worse; it simply has more shares outstanding. This is why you should not compare earnings per share across companies. (Alternative terms: Earnings per share are often called EPS or income per share.)
Source: Photo courtesy of DangApricot, http://commons.wikimedia.org/wiki/File:AnnTaylorLoftSign.JPG.
The Importance of Earnings per Share
The business press often uses earnings per share to announce a company’s earnings. For example, the Associated Press addressed earnings at AnnTaylor Stores Corporation, a retailer of women’s clothing, as follows: “Quarterly income fell to $7,100,000, or 10 cents per share, from $30,100,000, or 41 cents, the year before. Setting aside relocation costs, adjusted earnings were 18 cents per share, a penny higher than the average estimate from analysts polled by Thomson Financial.”
This quote demonstrates not only that earnings per share data are important when announcing a company’s earnings but also that analysts use these data when making predictions about a company’s performance. A quick perusal of any business publication, such as The Wall Street Journal, or a review of online business press releases at sites like http://finance.yahoo.com will confirm that earnings per share data are commonly used to announce a company’s financial results.
Source: Associated Press, “AnnTaylor’s 2Q Profit Plummets on Charge,” August 19, 2005.
Refer to the information presented in Note 13.10 "Review Problem 13.1" for PepsiCo, and perform the following for 2010:
Solutions to Review Problem 13.3
$$\begin{array}{cc}\hfill \text{Grossmargin}\text{ratio}& =\frac{\text{Grossmargin}}{\text{Netsales}}\hfill \\ & =\frac{\text{\$31,263}}{\text{\$57,838}}\hfill \\ & =\text{54}.\text{1}\%\hfill \end{array}$$
For every dollar in net sales, PepsiCo generated 54.1 cents in gross margin.
$$\begin{array}{cc}\hfill \text{Profitmargin}\text{ratio}& =\frac{\text{Netincome}}{\text{Netsales}}\hfill \\ \hfill & =\frac{\text{\$6,32}0}{\text{\$57,838}}\hfill \\ \hfill & =\text{1}0.\text{9}\%\hfill \end{array}$$
For every dollar in net sales, PepsiCo generated 10.9 cents in net income.
$$\begin{array}{cc}\hfill \text{Returnon}\text{assets}& =\frac{\text{Netincome}}{\text{Averagetotalassets}}\hfill \\ \hfill & =\frac{\text{\$6,320}}{(\text{\$68}\text{,}\text{153}+\text{\$39,848})\xf7\text{2}}\hfill \\ \hfill & =\frac{\text{\$6,320}}{\text{\$54}\text{,}00\text{1}}\hfill \\ \hfill & =\text{11.7\%}\hfill \end{array}$$
For every dollar in average assets, PepsiCo generated 11.7 cents in net income.
$$\begin{array}{cc}\begin{array}{c}\hfill \text{Returnoncommon}\\ \text{shareholders\u2019equity}\end{array}& =\frac{\text{Netincome}\text{Preferreddividends}}{\text{Averagecommonshareholders}\u2019\text{equity}}\hfill \\ & =\frac{\mathrm{\$6,320}\mathrm{\$6}}{\left[(\text{\$4}\text{,}\text{558}+\text{\$37}\text{,}\text{4}0\text{2}\text{\$3}\text{,}\text{63}0\text{\$16}\text{,}\text{745})+(\text{\$28}0+\text{\$34}\text{,}\text{443}\text{\$3}\text{,}\text{794}\text{\$13}\text{,}\text{383})\right]\xf7\text{2}}\hfill \\ & =\frac{\text{\$6}\text{,}\text{314}}{\text{\$19}\text{,}\text{566}}\hfill \\ & =\text{32}.\text{3}\%\hfill \end{array}$$
For every dollar in average common shareholders’ equity, PepsiCo generated 32.3 cents in net income (after deducting preferred dividends).
$$\begin{array}{cc}\hfill \text{Earnings}\text{pershare}& =\frac{\text{Netincome}\text{Preferreddividends}}{\text{Weightedaveragecommonsharesoutstanding}}\hfill \\ \hfill & =\frac{\mathrm{\$6,320}\text{\$6}}{\text{1,590shares}}\hfill \\ \hfill & =\text{\$3}.\text{97pershare}\hfill \end{array}$$
For each common share outstanding, PepsiCo generated $3.97 in net income (after deducting preferred dividends).
Question: Suppliers and other shortterm lenders often want to evaluate whether companies can meet shortterm obligations. What are the four common ratios used to evaluate shortterm liquidity?
Answer: The four ratios used to evaluate shortterm liquidity are as follows:
Question: How is the current ratio calculated, and what does it tell us about CocaCola relative to PepsiCo and the industry average?
Answer: The current ratioIndicates whether a company has enough current assets to cover current liabilities. Calculated as current assets divided by current liabilities. indicates whether a company has sufficient current assets to cover current liabilities. It is found by dividing current assets by current liabilities:
The current ratio for CocaCola for 2010 is calculated as follows, with PepsiCo and industry average information following it:
$$\text{Currentratio}=\frac{\mathrm{\$11,199}+\mathrm{\$138}+\mathrm{\$4,430}+\mathrm{\$2,650}+\mathrm{\$3,162}}{\mathrm{\$8,859}+\mathrm{\$8,100}+\mathrm{\$1,549}}=\frac{\mathrm{\$21,579}}{\mathrm{\$18,508}}=\mathrm{1.17to1}$$CocaCola 2010  CocaCola 2009  PepsiCo 2010  Industry Average 2010  
Current ratio  1.17 to 1  1.28 to 1  1.11 to 1  1.20 to 1 
The current ratio indicates CocaCola had $1.17 in current assets for every dollar in current liabilities. This ratio decreased from 2009 to 2010 and is slightly higher than PepsiCo’s 1.11 to 1 ratio. CocaCola is close to the industry average of 1.20 to 1. In general, a current ratio above 1 to 1 is preferable, which indicates the company has sufficient current assets to cover current liabilities. However, finding the ideal minimum current ratio is dependent on many factors, such as the industry, the overall financial condition of the company, and the composition of the company’s current assets and current liabilities. Because of variations in these factors from one company to the next, a more stringent measure of shortterm liquidity is often used. We present this measure, called the quick ratio, next.
Question: How is the quick ratio calculated, and what does it tell us about CocaCola relative to PepsiCo and the industry average?
Answer: The quick ratioIndicates whether a company has enough quick assets to cover current liabilities. Calculated as quick assets divided by current liabilities; also called acidtest ratio. (also called acidtest ratio) indicates whether a company has sufficient quick, or highly liquid, assets to cover current liabilities. The quick ratio is quick assets divided by current liabilities:
Notice the numerator excludes current assets that are not easily and quickly converted to cash. Although inventory is typically excluded from the numerator, further analysis is needed to evaluate whether inventory should be included. For example, grocery stores turn inventory over very quickly, typically within a couple of weeks, and should consider including inventory in the quick ratio. Producers of wine, on the other hand, turn inventory over very slowly, and should consider excluding inventory in the numerator of the quick ratio. For the sake of consistency, you should exclude inventory from the numerator in this chapter, unless told otherwise. (Note: Many companies provide two quick ratio calculations, one that includes inventory in the numerator and one that excludes inventory in the numerator. If two ratios are presented, it is important to label each ratio to indicate whether inventory has been included or excluded.)
It is helpful when reviewing a company’s balance sheet to remember that current assets are presented in order of liquidity, with the most liquid current asset appearing first and the least liquid appearing last. This helps in determining whether a particular current asset should be included or excluded in the numerator of the quick ratio. The quick ratio for CocaCola for 2010 is calculated as follows, with PepsiCo and industry average information following it:
$$\text{Quickratio}=\frac{\mathrm{\$11,199}+\mathrm{\$138}+\mathrm{\$4,430}}{\mathrm{\$8,859}+\mathrm{\$8,100}+\mathrm{\$1,549}}=\frac{\mathrm{\$15,767}}{\mathrm{\$18,508}}=\mathrm{0.85to1}$$CocaCola 2010  CocaCola 2009  PepsiCo 2010  Industry Average 2010  
Quick ratio  0.85 to 1  0.95 to 1  0.80 to 1  1.10 to 1 
The quick ratio indicates CocaCola had $0.85 in quick assets for every dollar in current liabilities. This ratio decreased from 2009 to 2010 and is slightly higher than PepsiCo’s 0.80 to 1 ratio. CocaCola is below the industry average of 1.10 to 1.
Question: How is the receivables turnover ratio calculated, and what does it tell us about CocaCola relative to PepsiCo and the industry average?
Answer: The receivables turnover ratioIndicates how many times receivables are collected in a given period. Calculated as credit sales divided by average accounts receivable. indicates how many times receivables are collected in a given period and is found by dividing credit sales by average accounts receivable:
Assume all net sales presented on the income statement are on account, and therefore will be used in the numerator. The average accounts receivable amount in the denominator is found by adding together accounts receivable at the end of the current year and previous year (2010 and 2009 for this example) and dividing by two. The receivables turnover ratio for CocaCola for 2010 is calculated as follows, with PepsiCo and industry average information following it:
$$\text{Receivablesturnoverratio}=\frac{\text{\$35,119}}{(\text{\$4,430}+\text{\$3,758})\xf7\text{2}}=\frac{\text{\$35,119}}{\text{\$4}\text{,}0\text{94}}=\text{8}.\text{58times}$$CocaCola 2010  CocaCola 2009  PepsiCo 2010  Industry Average 2010  
Receivables turnover ratio  8.58 times  9.05 times  10.57 times  9.70 times 
The receivables turnover ratio indicates CocaCola collected receivables 8.58 times during 2010. This ratio decreased from 2009 to 2010 and is lower than PepsiCo’s 10.57 times. CocaCola is below the industry average of 9.70 times.
Question: How is the receivables turnover ratio converted to average collection period?
Answer: The receivables turnover ratio can be converted to the average collection periodIndicates how many days it takes on average to collect credit sales. Calculated as 365 days divided by receivables turnover ratio., which indicates how many days it takes on average to collect on credit sales, as follows:
This ratio is typically compared to the company’s credit terms to evaluate how effectively receivables are being collected. The average collection period for CocaCola for 2010 is calculated as follows, with PepsiCo and industry average information following it:
$$\text{Averagecollectionperiod}=\frac{\text{365days}}{\text{8}.\text{58times}}=\text{42}.\text{54days}$$CocaCola 2010  CocaCola 2009  PepsiCo 2010  Industry Average 2010  
Average collection period  42.54 days  40.33 days  34.53 days  37.63 days 
The average collection period indicates CocaCola collected credit sales in 42.54 days, on average. The number of days increased slightly from 2009 to 2010 and is higher than PepsiCo’s 34.53 days. CocaCola is also above the industry average of 37.63 days and therefore is slower at collecting accounts receivable than the industry as a whole.
Question: How is the inventory turnover ratio calculated, and what does it tell us about CocaCola relative to PepsiCo and the industry average?
Answer: The inventory turnover ratioIndicates how many times inventory is sold and restocked in a given period. Calculated as cost of goods sold divided by average inventory. indicates how many times inventory is sold and restocked in a given period. It is calculated as cost of goods sold divided by average inventory:
The average inventory amount in the denominator is found by adding together inventory at the end of the current year and previous year (2010 and 2009 for this example) and dividing by two. The inventory turnover ratio for CocaCola for 2010 is calculated as follows, with PepsiCo and industry average information following it:
$$\text{Inventory}\text{turnoverratio}=\frac{\text{\$12,693}}{(\text{\$2,650}+\text{\$2,354})\xf7\text{2}}=\frac{\text{\$12,693}}{\text{\$2,502}}=\text{5}.0\text{7times}$$CocaCola 2010  CocaCola 2009  PepsiCo 2010  Industry Average 2010  
Inventory turnover ratio  5.07 times  4.88 times  8.87 times  7.50 times 
The inventory turnover ratio indicates CocaCola sold and restocked inventory 5.07 times during 2010. This ratio increased slightly from 2009 to 2010 and is substantially lower than PepsiCo’s 8.87 times. CocaCola is well below the industry average of 7.50 times.
Question: How is the inventory turnover ratio converted to average sale period?
Answer: The inventory turnover ratio can be converted to the average sale periodIndicates how many days it takes on average to sell the company’s inventory. Calculated as 365 days divided by inventory turnover ratio., which indicates how many days it takes on average to sell the company’s inventory, as follows:
The average sale period for CocaCola for 2009 is calculated as follows, with PepsiCo and industry average information following it:
$$\text{Average}\text{saleperiod}=\frac{\text{365days}}{\text{5}.0\text{7times}}=\text{71}.\text{99days}$$CocaCola 2010  CocaCola 2009  PepsiCo 2010  Industry Average 2010  
Average sale period  71.99 days  74.80 days  41.15 days  48.67 days 
The average sale period indicates CocaCola sold its inventory in 71.99 days, on average. The number of days decreased from 2009 to 2010 and is substantially higher than PepsiCo’s 41.15 days. CocaCola is also above the industry average of 48.67 days and therefore is slower at selling inventory than the industry as a whole.
© Thinkstock
Industry Variations in Inventory and Receivable Turnover
Retail grocery stores turn inventory over every 22 days, meaning that shelves are emptied and restocked about every three weeks. In addition to extremely fast inventory turnover, retail grocery stores collect credit sales in seven days. Thus it takes 29 days, on average, to convert freshly stocked inventory to cash. Very few industries are able to convert inventory to cash as quickly. Examples of inventory and receivable turnover for several industries are shown in the following.
Receivables Turnover  Inventory Turnover  
Auto manufacturers  39 days  41 days 
Chemical manufacturing  51 days  61 days 
Forestry and wood products  46 days  53 days 
Computer systems  78 days  18 days 
Source: Industry averages found at MSN Money, Home Page,” http://moneycentral.msn.com.
Refer to the information presented in Note 13.10 "Review Problem 13.1" for PepsiCo, and perform the following requirements for 2010:
Solution to Review Problem 13.4
$$\begin{array}{cc}\text{Currentratio}\hfill & =\frac{\text{Currentassets}}{\text{Currentliabilities}}\hfill \\ & =\frac{\mathrm{\$5,943}+\mathrm{\$426}+\mathrm{\$6,323}+\mathrm{\$3,372}+\mathrm{1,505}}{\mathrm{\$4,898}+\mathrm{\$10,923}+\mathrm{\$71}}\hfill \\ & =\frac{\mathrm{\$17,569}}{\mathrm{\$15,892}}\hfill \\ & =\mathrm{1.11to1}\hfill \end{array}$$
For every dollar in current liabilities, PepsiCo had $1.11 in current assets.
$$\begin{array}{cc}\hfill \text{Quickratio}& =\frac{\text{Cash}+\text{Marketablesecurities}+\text{Shorttermreceivables}}{\text{Currentliabilities}}\hfill \\ & =\frac{\mathrm{\$5,943}+\mathrm{\$426}+\mathrm{\$6,323}}{\mathrm{\$4,898}+\mathrm{\$10,923}+\mathrm{\$71}}\hfill \\ \hfill & =\frac{\mathrm{\$12,692}}{\mathrm{\$15,892}}\hfill \\ & =0.\mathrm{80to1}\hfill \end{array}$$
For every dollar in current liabilities, PepsiCo had $0.80 in quick assets.
$$\begin{array}{cc}\hfill \text{Receivables}\text{turnoverratio}& =\frac{\text{Creditsales}}{\text{Averageaccountsreceivable}}\hfill \\ \hfill & =\frac{\text{\$57,838}}{(\text{\$6}\text{,}\text{323}+\text{\$4,624})\xf7\text{2}}\hfill \\ \hfill & =\frac{\text{\$57,838}}{\text{\$5,474}}\hfill \\ \hfill & =\text{1}0.\text{57times}\hfill \end{array}$$
PepsiCo collected receivables 10.57 times during 2010.
$$\begin{array}{cc}\hfill \text{Average}\text{collectionperiod}& =\frac{\text{365days}}{\text{Receivablesturnoverratio}}\hfill \\ \hfill & =\frac{\text{365days}}{\text{1}0.\text{57times}}\hfill \\ \hfill & =\text{34}.\text{53days}\hfill \end{array}$$PepsiCo collected credit sales in 34.53 days, on average.
$$\begin{array}{cc}\hfill \text{Inventory}\text{turnoverratio}& =\frac{\text{Costofgoodssold}}{\text{Averageinventory}}\hfill \\ \hfill & =\frac{\text{\$26,575}}{(\text{\$3}\text{,}\text{372}+\text{\$2,618})\xf7\text{2}}\hfill \\ \hfill & =\frac{\text{\$26,575}}{\text{\$2,995}}\hfill \\ \hfill & =\text{8}.\text{87times}\hfill \end{array}$$
PepsiCo sold and restocked inventory 8.87 times during 2010.
$$\begin{array}{cc}\hfill \text{Average}\text{saleperiod}& =\frac{\text{365days}}{\text{Inventoryturnoverratio}}\hfill \\ \hfill & =\frac{\text{365days}}{\text{8}.\text{87times}}\hfill \\ \hfill & =\text{41}.\text{15days}\hfill \end{array}$$PepsiCo sold its inventory in 41.15 days, on average.
Question: Banks, bondholders, and other longterm lenders often want to evaluate whether companies can meet longterm obligations. What are the three common ratios used to evaluate longterm solvency?
Answer: The three ratios used to evaluate longterm solvency are as follows:
Question: How is the debt to assets ratio calculated, and what does it tell us about CocaCola relative to PepsiCo and the industry average?
Answer: The debt to assetsIndicates the percentage of assets funded by creditors. Calculated as total liabilities divided by total assets. ratio indicates the percentage of assets funded by creditors and is used to evaluate the financial leverage of a company. Debt to assets is found by dividing total liabilities by total assets:
The higher the percentage, the higher the financial leverage. The debt to assets ratio for CocaCola for 2010 is calculated as follows, with PepsiCo and industry average information following it:
$$\text{Debttoassets}=\frac{\mathrm{\$8,859}+\mathrm{\$8,100}+\mathrm{\$1,549}+\mathrm{\$14,041}+\mathrm{\$9,055}}{\mathrm{\$72,921}}=\frac{\mathrm{\$41,604}}{\mathrm{\$72,921}}=\mathrm{0.57to1}$$CocaCola 2010  CocaCola 2009  PepsiCo 2010  Industry Average 2010  
Debt to assets  0.57 to 1  0.48 to 1  0.68 to 1  0.48 to 1 
The debt to assets ratio indicates that creditors funded 57 percent of CocaCola’s assets at the end of 2010. This ratio increased from 2009 to 2010 and is lower than PepsiCo’s 0.68 to 1. CocaCola is higher than the industry average of 0.48 to 1.
A review of the basic balance sheet equation shows that the complement of the debt to assets ratio provides the percentage of assets funded by shareholders. Thus for every dollar CocaCola has in assets, creditors fund $0.57 and shareholders fund $0.43 (= $1 – $0.57):
$$\begin{array}{cc}\hfill \text{Assets}& =\text{Liabilities}+\text{Shareholders\u2019equity}\hfill \\ \hfill \text{\$1}.00& =\mathrm{\$0.}\text{57}+\mathrm{\$0.}\text{43}\hfill \end{array}$$The debt to assets ratio reveals CocaCola (0.57 to 1) and PepsiCo (0.68 to 1) are more highly leveraged than the industry average of 0.48 to 1.
Question: How is the debt to assets ratio calculated, and what does it tell us about CocaCola relative to PepsiCo and the industry average?
Answer: A variation of the debt to assets ratio is the debt to equityIndicates the balance of liabilities and shareholders’ equity used to fund assets. Calculated as total liabilities divided by total shareholders’ equity. ratio, which measures the balance of liabilities and shareholders’ equity used to fund assets. The debt to equity ratio is total liabilities divided by total shareholders’ equity:
This ratio indicates the amount of debt incurred for each dollar that owners provide. The debt to equity ratio for CocaCola for 2010 is calculated as follows, with PepsiCo and industry average information following it:
$$\text{Debttoequity}=\frac{\mathrm{\$8,859}+\mathrm{\$8,100}+\mathrm{\$1,549}+\mathrm{\$14,041}+\mathrm{\$9,055}}{\mathrm{\$10,937}+\mathrm{\$49,592}\mathrm{\$1,450}\mathrm{\$27,762}}=\frac{\mathrm{\$41,604}}{\mathrm{\$31,317}}=\mathrm{1.33to1}$$CocaCola 2010  CocaCola 2009  PepsiCo 2010  Industry Average 2010  
Debt to equity  1.33 to 1  0.92 to 1  2.17 to 1  0.94 to 1 
The debt to equity ratio indicates that CocaCola had $1.33 in liabilities for each dollar in shareholders’ equity. This ratio increased from 2009 to 2010 and is substantially lower than PepsiCo’s 2.17 to 1. However, CocaCola is higher than the industry average of 0.94 to 1.
Source: Photo courtesy of spechtenhauser, http://www.flickr.com/photos/usinside/2931437356/.
Financial Leverage at General Motors and Toyota
Prior to the company’s bankruptcy filing in 2009, General Motors (GM) was the largest manufacturer of automobiles and trucks in the world (ranked by revenues). However, GM took on substantial amounts of debt over several years. With an average debt to equity ratio of 2.5 to 1, the automobile industry is relatively highly leveraged, but GM’s ratio was substantially higher at 11.3 to 1. This means that GM had $11.30 in debt for every $1 in shareholders’ equity.
Toyota Motor Corporation, on the other hand, was not highly leveraged; it had a debt to equity ratio of 1 to 1. Thus Toyota had $1 in debt for every $1 in shareholders’ equity. It is important to review other financial ratios before concluding that Toyota was in better financial shape than GM, but the fact that GM was much more highly leveraged than Toyota likely played a big role in GM’s downfall!
Source: Industry averages found at MSN Money, Home Page,” http://moneycentral.msn.com and Yahoo! Finance, “Home Page,” http://biz.yahoo.com.
Question: How is times interest earned calculated, and what does it tell us about CocaCola relative to PepsiCo and the industry average?
Answer: The times interest earnedIndicates the ability of a company to cover its interest expense with current period earnings. Calculated as income before income tax expense and interest expense divided by interest expense; also called interest coverage ratio. ratio (also called interest coverage ratio) measures the company’s ability to cover its interest expense related to longterm debt with current period earnings. The times interest earned ratio is net income before income tax expense and interest expense divided by interest expense:
Notice that income tax expense and interest expense are added back in the numerator to find net income available to cover interest expense. The times interest earned ratio for CocaCola for 2010 is calculated as follows, with PepsiCo and industry average information following it:
$$\text{Timesinterest}\text{earned}=\frac{\mathrm{\$11,809}+\mathrm{\$2,384}+\mathrm{\$733}}{\mathrm{\$733}}=\frac{\mathrm{\$14,926}}{\mathrm{\$733}}=\mathrm{20.36times}$$CocaCola 2010  CocaCola 2009  PepsiCo 2010  Industry Average 2010  
Times interest earned  20.36 times  25.97 times  10.10 times  10.70 times 
The times interest earned ratio indicates CocaCola had earnings to cover interest expense 20.36 times. This ratio decreased from 2009 to 2010 and is much higher than PepsiCo’s 10.10 times. CocaCola is also higher than the industry average of 10.70 times. It appears that CocaCola has plenty of earnings to cover interest expense.
Refer to the information presented in Note 13.10 "Review Problem 13.1" for PepsiCo, and perform the following requirements for 2010:
Solution to Review Problem 13.5
$$\begin{array}{cc}\hfill \text{Debttoassets}& =\frac{\text{Totalliabilities}}{\text{Totalassets}}\hfill \\ \hfill & =\frac{\mathrm{\$4,898}+\mathrm{\$10,923}+\mathrm{\$71}+\mathrm{\$19,999}+\mathrm{\$10,786}}{\mathrm{\$68,153}}\hfill \\ \hfill & =\frac{\mathrm{\$46,677}}{\mathrm{\$68,153}}\hfill \\ \hfill & =\mathrm{0.68to1}\hfill \end{array}$$
Creditors funded 68 percent of PepsiCo’s assets. Owners funded the remaining 32 percent.
$$\begin{array}{cc}\hfill \text{Debtto}\text{equity}& =\frac{\text{Totalliabilities}}{\text{Totalshareholders\u2019equity}}\hfill \\ \hfill & =\frac{\mathrm{\$4,898}+\mathrm{\$10,923}+\mathrm{\$71}+\mathrm{\$19,999}+\mathrm{\$10,786}}{\left(\mathrm{\$109}\right)+\mathrm{\$4,558}+\mathrm{\$37,402}\mathrm{\$3,630}\mathrm{\$16,745}}\hfill \\ \hfill & =\frac{\mathrm{\$46,677}}{\mathrm{\$21,476}}\hfill \\ \hfill & =\mathrm{2.17to1}\hfill \end{array}$$
For every dollar in shareholders’ equity, PepsiCo had $2.17 in liabilities.
$$\begin{array}{cc}\hfill \text{Timesinterest}\text{earned}& =\frac{\text{Netincome}+\text{Incometaxexpense}+\text{Interestexpense}}{\text{Interestexpense}}\hfill \\ \hfill & =\frac{\mathrm{\$6,320}+\mathrm{\$1,894}+\mathrm{\$903}}{\mathrm{\$903}}\hfill \\ \hfill & =\frac{\mathrm{\$9,117}}{\mathrm{\$903}}\hfill \\ \hfill & =10.10\text{times}\hfill \end{array}$$
PepsiCo had earnings to cover interest expense 10.10 times.
Question: Existing and potential shareholders are often interested in a company’s market value. What are the two common measures used to evaluate market value?
Answer: The two measures used to determine and evaluate the market value of a company are as follows:
Question: How is market capitalization calculated, and what does it tell us about CocaCola relative to PepsiCo and the industry average?
Answer: Market capitalizationIndicates the value of a company at a point in time. Calculated as market price per share times the number of shares outstanding; also called market cap. (also called market cap) measures the value of a company at a point in time. It is determined by multiplying market price per share times the number of shares outstanding:
CocaCola’s market capitalization for 2010 is calculated as follows, with PepsiCo information following it. The number of shares outstanding at CocaCola’s fiscal year ended December 31, 2010, totaled 2,292,000,000 (= 3,520,000,000 shares issued – 1,228,000,000 treasury shares). The market price per share at that time was $63.92.
Market capitalization = $63.92 per share × 2,292,000,000 shares = $146,500,000,000CocaCola 2010  CocaCola 2009  PepsiCo 2010  Industry Average 2010  
Market capitalization  $146,500,000,000  $123,200,000,000  $100,700,000,000  $87,500,000,000 
CocaCola’s market capitalization indicates that the company’s shares outstanding had a market value totaling $146,500,000,000 at the end of 2010. This amount increased significantly from 2009 to 2010 and is higher than PepsiCo’s $100,700,000,000. Both CocaCola and PepsiCo are above the industry average of $87,500,000.
(Note that the number of shares outstanding is typically found in the shareholders’ equity section of the balance sheet or in the notes to the financial statements. We provide the number of shares outstanding throughout this chapter, unless noted otherwise. This number is different than the weighted average shares outstanding used to calculate earnings per share earlier in the chapter. Also note that the price per share amount is from Yahoo’s finance Web site at http://finance.yahoo.com. We provide this information throughout the chapter, unless noted otherwise.)
Looking at a company’s market capitalization is a quick way of gauging its aggregate value. But what does a number like CocaCola’s $146,500,000,000 market capitalization really tell us about how a company compares to others? Note 13.54 "Business in Action 13.6" has the answer.
Three Categories of Market Capitalization
Most investors refer to market capitalization as market cap. Companies are typically classified into one of three market cap categories: smallcap, midcap, and largecap. In general, smallcap companies have a market value of less than $1,000,000,000, midcap companies have a market value between $1,000,000,000 and $12,000,000,000, and largecap companies have a market value greater than $12,000,000,000.
Thus smallcap mutual funds are stock funds that invest in companies with a market value of less than $1,000,000,000. Midcap mutual funds are stock funds that invest in companies with a market value between $1,000,000,000 and $12,000,000,000, and so on. These categories are important to investors because the stocks of smallcap companies tend to be more volatile than those of mid or largecap companies.
Source: Definitions are from the Web site of Vanguard, one of the world’s largest investment management firms (http://www.vanguard.com).
Question: How is the priceearnings ratio calculated, and what does it tell us about CocaCola relative to PepsiCo and the industry average?
Answer: The priceearnings ratioIndicates the premium investors are willing to pay for shares of stock relative to the company’s earnings. Calculated as market price per share divided by earnings per share; also called P/E ratio. (also called P/E ratio) measures the premium investors are willing to pay for shares of stock relative to the company’s earnings. The priceearnings ratio is found by dividing market price per share by earnings per share:
In general, a relatively high priceearnings ratio indicates investors expect favorable future earnings, whereas a relatively low priceearnings ratio indicates investors expect moderate future earnings. The priceearnings ratio for CocaCola for 2010 is calculated as follows, with PepsiCo and industry average information following it. The market price information was given in the market capitalization example, and we calculated earnings per share earlier in the chapter.
$$\text{Priceearnings}\text{ratio}=\frac{\text{\$63}.\text{92}}{\text{\$5}.\text{12}}=\text{12}.\text{48times}$$CocaCola 2010  CocaCola 2009  PepsiCo 2010  Industry Average 2010  
Priceearnings ratio  12.48 times  18.21 times  16.04 times  14.60 times 
The priceearnings ratio indicates investors were willing to pay 12.48 times the earnings for CocaCola’s stock. This ratio decreased from 2009 to 2010 and is lower than PepsiCo’s 16.04 times. CocaCola is also lower than the industry average of 14.60 times.
Perform the following requirements for PepsiCo for 2010:
Solution to Review Problem 13.6
$$\begin{array}{cc}\hfill \text{Marketcapitalization}& =\text{Marketpricepershare}\times \text{Numberofsharesoutstanding}\hfill \\ & =\mathrm{\$63.68}\times \mathrm{1,581,000,000}\hfill \\ & =\mathrm{\$100.7billion}\left(\text{rounded}\right)\hfill \end{array}$$
PepsiCo’s shares outstanding had a market value of $100,700,000,000 at the end of 2010.
$$\begin{array}{cc}\hfill \text{Priceearnings}\text{ratio}& =\frac{\text{Marketpricepershare}}{\text{Earningspershare}}\hfill \\ \hfill & =\frac{\mathrm{\$63.68}}{\mathrm{\$3.97}}\hfill \\ \hfill & =\mathrm{16.04times}\hfill \end{array}$$
Investors were willing to pay 16.04 times earnings for PepsiCo’s stock.