Chapter4: Analyzing Financial Statements
Instruction: After reading the chapter below, write a brief summary of the chapter and how the information in the chapter could be applied to meeting your life or career goals. If you cannot relate the chapter to your personal goals, write about the most important thing you learned from the chapter and how it could impact your life.
Chapter4: Analyzing Financial Statements
4.1 BACKGROUND FOR FINANCIAL STATEMENT ANALYSIS
This chapter will guide you through a typical financial statement analysis, which involves the use of financial statements to analyze a company’s performance and assess its strengths and weaknesses. First, we look at the different perspectives we can take when analyzing financial statements; then we present some helpful guidelines for financial statement analysis.
Perspectives on Financial Statement Analysis
Stockholders and stakeholders may differ in the information they want to gain when analyzing financial statements. In this section, we discuss three perspectives from which we can view financial statement analysis: those of (1) stockholders, (2) managers, and (3) creditors.
Stockholders are primarily concerned with the value of their stock and with how much cash they can expect to receive from dividends and capital appreciation over time. Therefore, stockholders want financial statements to tell them how profitable the firm is, what the return on their investment is, and how much cash is available for stockholders, both in total and on a per-share basis. Ultimately, stockholders are interested in how much a share of stock is worth. We address pricing issues in detail in Chapter 9, but financial analysis is a key step in valuing a company’s stock.
Broadly speaking, management’s perspective of financial statement analysis is similar to that of stockholders. The reason is that stockholders own the firm and managers have a fiduciary responsibility to make decisions that are in the owners’ best interests. Thus, managers are interested in the same performance measures as stockholders: profitability, how much cash is available for stockholders, capital appreciation, return on investment, and the like.
Managers, however, are also responsible for running the business on a daily basis and must make decisions that will maximize the value of the stockholders’ shares in the long run. Maximizing the value of the stockholders’ shares does not involve a single big decision, but rather a series of smaller day-to-day decisions. Thus, managers need feedback on the short-term impact these day-to-day decisions have on the firm’s financial statements and its current stock price. For example, managers can track trends in sales and can determine how well they are controlling expenses and how much of each sales dollar goes to the bottom line. In addition, managers can see the impact of their capital budgeting, financing, and working capital decisions reflected in the financial statements. Keep in mind that managers, as insiders, have access to much more detailed financial information than those outside the firm. Generally, outsiders only have access to published financial statements for publicly traded firms.
The primary concern of creditors is whether and when they will receive the interest payments they are entitled to and when they will be repaid the money they loaned to the firm. Thus, a firm’s creditors, including long-term bondholders, closely monitor how much debt the firm is currently using, whether the firm is generating enough cash to pay its day-to-day bills, and whether the firm will have sufficient cash in the future to make interest and principal payments on long-term debt after satisfying obligations that have a higher legal priority, such as paying employees’ wages. Of course, the firm’s ability to pay interest and principal ultimately depends on cash flows and profitability; hence, creditors—like stockholders and managers—are interested in those aspects of the firm’s financial performance.
Guidelines for Financial Statement Analysis
We turn now to some general guidelines that will help you when analyzing a firm’s financial statements. First, make sure you understand which perspective you are adopting to conduct your analysis: stockholder, manager, or creditor. The perspective will dictate the type of information you need for the analysis and may affect the actions you take based on the results.
Second, always use audited financial statements if they are available. As we discussed in Chapter 1, an audit means that an independent accountant has attested that the financial statements present fairly, in all material respects, the firm’s financial condition at a point in time. If the statements are unaudited, your analysis will require extra effort. For example, if you are a creditor considering making a loan, you will need to undertake an especially diligent examination of the company’s books before closing the deal. It would also be a good idea to make sure you know the company’s management team and accountant very well. This will provide additional insight into the creditworthiness of the firm.
Third, use financial statements that cover three to five years, or more, to conduct your analysis. This enables you to perform a trend analysis, which involves looking at historical financial statements to see how various ratios are increasing, decreasing, or staying constant over time.
Fourth, when possible, it is always best to compare a firm’s financial statements with those of competitors that are roughly the same size and that offer similar products and services. If you compare firms of disparate size, the results may be meaningless because the two firms may have very different infrastructures, sources of financing, production capabilities, product mixes, and distribution channels. For example, comparing The Boeing Company’s financial statements with those of Piper Aircraft, a firm that manufactures small aircraft, makes no sense whatsoever, although both firms manufacture aircraft. You will have to use your judgment as to whether relevant comparisons can be made between firms with large size differences.
In business it is common to benchmark a firm’s performance, as discussed in the previous paragraph. The most common type of benchmarking involves comparing a firm’s performance with the performance of similar firms that are relevant competitors. For example, Ford Motor Company management may want to benchmark the firm against General Motors and Toyota, Ford’s major competitors in the world market. Firms can also be benchmarked against themselves. For example, they can compare this year’s performance with last year’s performance or with a specific goal, such as a 10 percent growth in sales. We discuss benchmarking in more detail later in this chapter.
4.2 COMMON-SIZE FINANCIAL STATEMENTS
A common-size financial statement is one in which each number is expressed as a percentage of some base number, such as total assets or net revenues (net sales). For example, each number on a balance sheet may be divided by total assets. Dividing numbers by a common base to form a ratio is called scaling. Scaling is an important concept, and you will read more about it later in this chapter, in the discussion of financial ratios. Financial statements scaled in this manner are also called standardized financial statements.
Common-size financial statements make it easier to evaluate changes in a firm’s performance and financial condition over time. They also allow you to make more meaningful comparisons between the financial statements of two firms that are different in size. For example, in the oil and gas field equipment market, Schlumberger Limited is the major competitor of Diaz Manufacturing, the illustrative firm introduced in Chapter 3. However, Schlumberger has over $55 billion in total assets while Diaz Manufacturing’s assets total only $1.9 billion. Without common-size financial statements, comparisons of these two firms would be difficult to interpret. Common-size financial statements are also useful for analyzing trends within a single firm over time, as you will see.
Common-Size Balance Sheets
To create a common-size balance sheet, we divide each of the asset accounts by total assets. We also divide each of the liability and equity accounts by total assets since .
You can see the common-size balance sheet for Diaz Manufacturing in Exhibit 4.1. Assets are shown in the top portion of the exhibit, and liabilities and equity in the lower portion. The calculations are simple. For example, on the asset side in 2014, cash and marketable securities were 15.3 percent of total assets ( , or 15.3 percent) and inventory was 22.4 percent of total assets ( , or 22.4 percent). Notice that the percentages of total assets add up to 100 percent. On the liability side, accounts payable are 18.5 percent of total assets ( , or 18.5 percent), and long-term debt is 30.4 percent ( , or 30.4 percent). To test yourself, see if you can re-create the percentages in Exhibit 4.1 using your calculator. Make sure the percentages add up to 100, but realize that you may obtain slight variations from 100 because of rounding.
2014 2013 2012
% of Assets % of Assets % of Assets
Cash and marketable securities $ 288.5 15.3 $ 16.6 1.1 $ 8.2 0.6
Accounts receivable 306.2 16.2 268.8 18.0 271.5 19.4
Inventories 423.8 22.4 372.7 24.9 400.0 28.6
Other current assets 21.3 1.1 29.9 2.0 24.8 1.8
Total current assets $1,039.8 55.0 $ 688.0 46.1 $ 704.5 50.4
Plant and equipment (net) 399.4 21.1 394.2 26.4 419.6 30.0
Goodwill and other assets 450.0 23.8 411.6 27.6 273.9 19.6
Total assets $1,889.2 100.0 $1,493.8 100.0 $1,398.0 100.0
Liabilities and Stockholders’ Equity:
Accounts payable and accruals $ 349.3 18.5 $ 325.0 21.8 $ 395.0 28.3
Notes payable 10.5 0.6 4.2 0.3 14.5 1.0
Accrued income taxes 18.0 1.0 16.8 1.1 12.4 0.9
Total current liabilities $ 377.8 20.0 $ 346.0 23.2 $ 421.9 30.2
Long-term debt 574.0 30.4 305.6 20.5 295.6 21.1
Total liabilities $ 951.8 50.4 $ 651.6 43.6 $ 717.5 51.3
Common stock (54,566,054 shares) 0.5 0.0 0.5 0.0 0.5 0.0
Additional paid in capital 892.4 47.2 892.4 59.7 892.4 63.8
Retained earnings 67.8 3.6 (50.7) (3.4) (155.8) (11.1)
Less: Treasury stock (23.3) (1.2) — — (56.6) (4.0)
Total stockholders’ equity $ 937.4 49.6 $ 842.2 56.4 $ 680.5 48.7
Total liabilities and equity $1,889.2 100.0 $1,493.8 100.0 $1,398.0 100.0
EXHIBIT 4.1 Common-Size Balance Sheets for Diaz Manufacturing on December 31 ($ millions)In common-size balance sheets, such as those in this exhibit, each asset account and each liability and equity account is expressed as a percentage of total assets. Common-size statements allow financial analysts to compare firms that are different in size and to identify trends within a single firm over time.
What kind of information can Exhibit 4.1 tell us about Diaz Manufacturing’s operations? Here are some examples. Notice that in 2014, inventories accounted for 22.4 percent of total assets, down from 24.9 percent in 2013 and 28.6 percent in 2012. In other words, Diaz Manufacturing has been steadily reducing the proportion of its money tied up in inventory. This is probably good news because it is usually a sign of more efficient inventory management.
Now look at liabilities and equity, and notice that in 2014 total liabilities represent 50.4 percent of Diaz Manufacturing’s total liabilities and equity. This means that common stockholders have provided 49.6 percent of the firm’s total financing and that creditors have provided 50.4 percent of the financing. In addition, you can see that from 2012 to 2014, Diaz Manufacturing substantially increased the proportion of financing from long-term debt holders. Long-term debt provided 21.1 percent ( , or 21.1 percent) of the financing in 2012 and 30.4 percent ( , or 30.4 percent) in 2014.
Overall, we can identify the following trends in Diaz Manufacturing’s common-size balance sheet. First, Diaz Manufacturing is a growing company. Its assets increased from $1,398.0 million in 2012 to $1,889.2 million in 2014. Second, the percentage of total assets held in current assets grew from 2012 to 2014, a sign of increasing liquidity. Recall from Chapter 2 that assets are liquid if they can be sold easily and quickly for cash without a loss of value. Third, the percentage of total assets in plant and equipment declined from 2012 to 2014, a sign that Diaz Manufacturing is becoming more efficient because it is using fewer long-term assets in producing sales (below you will see that net sales have increased over the same period). Finally, as mentioned, Diaz Manufacturing has significantly increased the percentage of its financing from long-term debt. Generally, these are considered signs of a solidly performing company, but we have a long way to go before we can confidently reach that conclusion. We will now turn to Diaz Manufacturing’s common-size income statement.
Common-Size Income Statements
The most useful way to prepare a common-size income statement is to express each account as a percentage of net sales, as shown for Diaz Manufacturing in Exhibit 4.2. Net sales are defined as total sales less all sales discounts and sales returns and allowances. You should note that when looking at accounting information and sales numbers as reported, they almost always mean net sales, unless otherwise stated. We will follow this convention in the book. Again, the percent calculations are simple. For example, in 2014 selling and administrative expenses are , and net income is . Before proceeding, make sure that you can verify each percentage in Exhibit 4.2 with your calculator.
2014 2013 2012
% of Net Sales % of Net Sales % of Net Sales
Net sales $1,563.7 100.0 $1,386.7 100.0 $1,475.1 100.0
Cost of goods sold 1,081.1 69.1 974.8 70.3 1,076.3 73.0
Selling and administrative expenses 231.1 14.8 197.4 14.2 205.7 13.9
Earnings before interest, taxes, depreciation, and amortization (EBITDA) $ 251.5 16.1 $ 214.5 15.5 $ 193.1 13.1
Depreciation 83.1 5.3 75.3 5.4 71.2 4.8
Earnings before interest and taxes (EBIT) $ 168.4 10.8 $ 139.2 10.0 $ 121.9 8.3
Interest expense 5.6 0.4 18.0 1.3 27.8 1.9
Earnings before taxes (EBT) $ 162.8 10.4 $ 121.2 8.7 $ 94.1 6.4
Taxes 44.3 2.8 16.1 1.2 27.9 1.9
Net income $ 118.5 7.6 $ 105.1 7.6 $ 66.2 4.5
Dividends — — —
Addition to retained earnings $ 118.5 $ 105.1 $ 66.2
EXHIBIT 4.2 Common-Size Income Statements for Diaz Manufacturing for Fiscal Years Ending December 31 ($ millions)Common-size income statements express each account as a percentage of net sales. These statements allow financial analysts to better compare firms of different sizes and to analyze trends in a single firm’s income statement accounts over time.
Interpreting the common-size income statement is also straightforward. As you move down the income statement, you will find out exactly what happens to each dollar of sales that the firm generates. For example, in 2014 it cost Diaz Manufacturing 69.1 cents in cost of goods sold to generate one dollar of sales. Similarly, it cost 14.8 cents in selling and administrative expenses to generate a dollar of sales. The government takes 2.8 percent of sales in the form of taxes.
The common-size income statement can tell us a lot about a firm’s efficiency and profitability. For example, in 2012, Diaz Manufacturing’s cost of goods sold and selling and administrative expenses totaled . By 2014, these expenses declined to . This might mean that Diaz Manufacturing is negotiating lower prices from its suppliers or is more efficient in its use of materials and labor. It could also mean that the company is getting higher prices for its products, perhaps by offering fewer discounts or rebates. The important point, however, is that more of each dollar of sales is contributing to net income.
The trends in the income statement and balance sheet suggest that Diaz Manufacturing is improving along a number of dimensions. The real question, however, is whether Diaz Manufacturing is performing as well as other firms in the same industry. For example, the fact that 7.6 cents of every dollar of sales reaches the bottom line may not be a good sign if we find out that Diaz Manufacturing’s competitors average 10 cents of net income for every dollar of sales.
4.3 FINANCIAL RATIOS AND FIRM PERFORMANCE
In addition to the common-size ratios we have just discussed, other specialized financial ratios help analysts interpret the myriad of numbers in financial statements. In this section we examine financial ratios that measure a firm’s liquidity, efficiency, leverage, profitability, and market value, using Diaz Manufacturing as an example. Keep in mind that for ratio analysis to be most useful, it should also include trend and benchmark analyses, which we discuss in more detail later in this chapter.
Why Ratios Are Better Measures
A financial ratio is simply one number from a financial statement that has been divided by another financial number. Like the percentages in common-size financial statements, ratios eliminate problems arising from differences in size because the denominator of the ratio adjusts, or scales, the numerator to a common base.
Here’s an example. Suppose you want to assess the profitability of two firms. Firm A’s net income is $5, and firm B’s is $50. Which firm had the best performance? You really cannot tell because you have no idea what asset base was used to generate the income. In this case, a relevant measure of financial performance for a stockholder might be net income scaled by the firm’s stockholders’ equity—that is, the return on equity (ROE):
If firm A’s total stockholders’ equity is $25 and firm B’s stockholders’ equity is $5,000, the ROE for each firm is as follows:
Firm ROE Calculation ROE
A $5/$25 0.20, or 20%
B $50/$5,000 0.01, or 1%
As you can see, the ROE for firm A is 20 percent—much larger than the ROE for firm B at 1 percent. Even though firm B had the higher net income in absolute terms ($50 versus $5), its stockholders had invested more money in the firm ($5,000 versus $25), and it generated less income per dollar of invested equity than firm A. Clearly, firm A’s performance is better than firm B’s, given its smaller equity investment. The bottom line is that accounting numbers are more easily compared and interpreted when they are scaled.
Choice of Scale Is Important
An important decision is your choice of the “size factor” for scaling. The size factor you select must be relevant and make economic sense. For example, suppose you want a measure that will enable you to compare the productivity of employees at a particular plant with the productivity of employees at other plants that make similar products. Your assistant makes a suggestion: divide net income by the number of parking spaces available at the plant. Will this ratio tell you how productive labor is at a plant? Clearly, the answer is no.
Your assistant comes up with another idea: divide net income by the number of employees. This ratio makes sense as a measure of employee productivity. A higher ratio indicates that employees are more productive because, on average, each employee is generating more income. In business, the type of variable most commonly used for scaling is a measure of size, such as total assets or total net sales. Other scaling variables are used in specific industries where they are especially informative. For example, in the airline industry, a key measure of performance is revenue per available seat mile; in the steel industry, it is sales or cost per ton; and in the automobile industry, it is cost per car.
Other Comments on Ratios
The ratios we present in this chapter are widely accepted and are almost always included in any financial workup. However, you will find that different analysts will compute many of these standard ratios slightly differently. Modest variation in how ratios are computed are not a problem as long as the analyst carefully documents the work done and discloses the ratio formula. These differences are particularly important when you are comparing data from different sources.
Short-Term Liquidity Ratios
Liquid assets have active secondary markets and can be sold quickly for cash without a loss of value. Some assets are more liquid than others. For example, short-term marketable securities are very liquid because they can be easily sold in the secondary market at or near the original purchase price. In contrast, plant and equipment can take months or years to sell and often must be sold substantially below the cost of building or acquiring them.
When we examine a company’s liquidity position, we want to know whether the firm can pay its bills when cash flow from operations is insufficient to pay short-term obligations, such as payroll, invoices from vendors, and maturing bank loans. As the name implies, short-term liquidity ratios focus on whether the firm has the ability to convert current assets into cash quickly without loss of value. As we have noted before, even a profitable business can fail if it cannot pay its current bills on time. The inability to pay debts when they are due is known as insolvency. Thus, liquidity ratios are also known as short-term solvency ratios. The two most important liquidity ratios are the current ratio and the quick ratio.
The Current Ratio
To calculate the current ratio, we divide current assets by current liabilities.The formula is presented below, along with a calculation of the current ratio for Diaz Manufacturing for 2014 based on balance sheet account data from Exhibit 4.1:
Diaz Manufacturing’s current ratio is 2.75, which should be read as “2.75 times.” What does this number mean? If Diaz Manufacturing were to take its current supply of cash and add to it the proceeds of liquidating its other current assets—such as marketable securities, accounts receivable, and inventory—it would have $1,039.8 million. This $1,039.8 million would cover the firm’s short-term obligations of $377.8 million approximately 2.75 times, leaving a cushion of .
Now turn to Exhibit 4.3, which shows the ratios discussed in this chapter for Diaz Manufacturing for the three-year period 2012-2014. The exhibit will allow us to identify important trends in the company’s financial statements. Note that Diaz Manufacturing’s current ratio has been steadily increasing over time. What does this trend mean? From the perspective of a potential creditor, it is a positive sign. To a potential creditor, more liquidity is better because it means that the firm has a greater ability, at least in the short term, to make payments. From a stockholder’s perspective, however, too much liquidity is not necessarily a good thing. If we were to discover that Diaz Manufacturing has a much higher current ratio than its competitors, it could mean that management is being too conservative by keeping too much money tied up in current assets, leaving less cash flow for investors. Generally, more liquidity is better and is a sign of a healthy firm. Only a benchmark analysis can tell us the complete story, however.
Financial Ratio 2014 2013 2012
Current ratio 2.75 1.99 1.67
Quick ratio 1.63 0.91 0.72
Inventory turnover 2.55 2.62 2.69
Day’s sales in inventory 143.14 139.31 135.69
Accounts receivable turnover 5.11 5.16 5.43
Day’s sales outstanding 71.43 70.74 67.22
Total asset turnover 0.83 0.93 1.06
Fixed asset turnover 3.92 3.52 3.52
Total debt ratio 0.50 0.44 0.51
Debt-to-equity ratio 1.02 0.77 1.05
Equity multiplier 2.02 1.77 2.05
Times interest earned 30.07 7.73 4.38
Cash coverage 44.91 11.92 6.95
Gross profit margin 30.86% 29.70% 27.04%
Operating profit margin 10.77% 10.04% 8.26%
Net profit margin 7.58% 7.58% 4.49%
EBIT return on assets 8.91% 9.32% 8.72%
Return on assets 6.27% 7.04% 4.74%
Return on equity 12.64% 12.48% 9.73%
Price-earnings ratio 22.40 18.43 14.29
Earnings per share $ 2.17 $ 1.93 $ 1.21
Market-to-book ratio 2.83 1.63 1.39
Note: Numbers may not add up because of rounding.
EXHIBIT 4.3 Ratios for Time-Trend Analysis for Diaz Manufacturing for Fiscal Years Ending December 31Comparing how financial ratios, such as these ratios for Diaz Manufacturing, change over time enables financial analysts to identify trends in company performance.
The Quick Ratio
The quick ratio is similar to the current ratio except that inventory is subtracted from current assets in the numerator. The quick ratio accounts for the fact that inventory is often much less liquid than other current assets. Inventory is the most difficult current asset to convert to cash without loss of value. Of course, the liquidity of inventory varies with the industry. For example, inventory of a raw material commodity, such as gold or crude oil, is more likely to be sold with little loss in value than inventory consisting of perishables, such as fruit, or fashion items, such as basketball shoes. Another reason for excluding inventory in the quick ratio calculation is that the book value of inventory may be significantly more than its market value because it may be obsolete, partially completed, spoiled, out of fashion, or out of season.
To calculate the quick ratio—or acid-test ratio, as it is sometimes called—we divide current assets, less inventory, by current liabilities. The calculation for Diaz Manufacturing for 2014 is as follows, based on balance sheet data from Exhibit 4.1:
The quick ratio of 1.63 times means that if we exclude inventory, Diaz Manufacturing had $1.63 of current assets for each dollar of current liabilities. You can see from Exhibit 4.3 that Diaz Manufacturing’s liquidity position, as measured by its quick ratio, has been increasing over time.
Note that the quick ratio is usually less than the current ratio, as it was for Diaz Manufacturing in 2014.The quick ratio is a very conservative measure of liquidity because the calculation assumes that the inventory is valued at zero, which in most cases is not a realistic assumption. Even in a bankruptcy “fire sale,” the inventory can be sold for some small percentage of its book value, generating at least some cash.
We now turn to a group of ratios called efficiency ratios or asset turnover ratios, which measure how efficiently a firm uses it assets. These ratios are quite useful for managers and financial analysts in identifying the inefficient use of current and long-term assets. They are also valuable for a firm’s investors who use the ratios to find out how quickly a firm is selling its inventory and converting receivables into cash flow for investors.
Inventory Turnover and Days’ Sales in Inventory
We measure inventory turnover by dividing the cost of goods sold from the income statement by inventory from the balance sheet (see Exhibits 4.1 and 4.2). The cost of goods sold is used because it reflects the book value of the inventory that is sold by a firm. The formula for inventory turnover and its value for Diaz Manufacturing in 2014 are:
The firm “turned over” its inventory 2.55 times during the year. Looking back at Exhibit 4.3, you can see that this ratio remained about the same over the period covered.
What exactly does “turning over” inventory mean? Consider a simple example. Assume that a firm starts the year with inventory worth $100 and replaces the inventory when it is all sold; that is, the inventory goes to zero. If, over the course of the year, the firm sells the inventory and replaces it three times, the firm is said to have an inventory turnover of three times.
As a general rule, turning over inventory faster is a good thing because it means that the firm is doing a good job of minimizing its investment in inventory. Nevertheless, like all ratios, inventory turnover can be either too high or too low. Too high of an inventory turnover ratio may signal that the firm has too little inventory for its customers and could be losing sales as a result. If the firm’s inventory turnover level is too low, it could mean that management is not managing the firm’s inventory efficiently or that an unusually large portion of the inventory is obsolete or out of date. In sum, inventory turnover that is significantly lower or significantly higher than that of competitors calls for further investigation.
Based on the inventory turnover figure, and using a 365-day year, we can also calculate the days’ sales in inventory, which tells us how long it takes a firm to turn over its inventory on average. The formula for days’ sales in inventory, along with the 2014 calculation for Diaz Manufacturing, is as follows:
Note that inventory turnover in the formula is computed using Equation 4.3. On average, Diaz Manufacturing takes about 140 days to turn over its inventory. Generally speaking, the smaller the number, the more efficient the firm is at moving its inventory.
Alternative Calculation for Inventory Turnover
Normally, we determine inventory turnover by dividing cost of goods sold by the inventory level at the end of the period. However, if a firm’s inventory fluctuates widely or is growing (or decreasing) over time, some analysts prefer to compute inventory turnover using the average inventory value for the time period. In this case, the inventory turnover is calculated in two steps:
• 1.We first calculate average inventory by adding beginning and ending inventory and dividing by 2:
• 2.We then divide the cost of goods sold by average inventory to find inventory turnover:
Note that all six efficiency ratios presented in the chapter (Equations 4.3 through 4.8) can be computed using an average asset value. For simplicity, we will generally use the end of the period asset value in our calculations.
Accounts Receivable Turnover and Days’ Sales Outstanding
Many firms make sales to their customers on credit, which creates an account receivable on the balance sheet. It does not do the firm much good to ship products or provide the services on credit if it cannot ultimately collect the cash from its customers. A firm that collects its receivables faster is generating cash faster. We can measure the speed at which a firm converts its receivables into cash with a ratio called accounts receivable turnover; the formula and calculated values for Diaz Manufacturing in 2014 are as follows:
The data to compute this ratio is from Diaz’s balance sheet and income statement (Exhibits 4.1 and 4.2). Roughly, this ratio means that Diaz Manufacturing loans out and collects an amount equal to its outstanding accounts receivable 5.11 times over the course of a year.
In most circumstances, higher accounts receivable turnover is a good thing—it means that the firm is making fewer sales on credit and collecting cash payments from its credit customers faster. Such credit is a customer incentive that is used to promote sales, but it can be expensive. As shown in Exhibit 4.3, Diaz’s collection speed slowed down slightly from 2012 to 2014. This may be a cause for management concern for at least three reasons. First, Diaz’s system for collecting accounts receivable may be inefficient. Second, the firm’s customers may not be paying on time because their businesses are slowing down due to industry or general economic conditions. Finally, Diaz may be extending credit to customers that are poor credit risks. Making a determination of the cause would require us to compare Diaz’s accounts receivable turnover with corresponding figures from its competitors.
You may find it easier to evaluate a firm’s credit and collection policies by using days’ sales outstanding, often referred to as DSO, which is calculated as follows:
Note that accounts receivable turnover is computed using Equation 4.5. The DSO for Diaz Manufacturing means that, on average, the company converts its credit sales into cash in 71.43 days. DSO is commonly called the average collection period.
Generally, faster collection is better. Whether 71.43 days is fast enough really depends on industry norms and on the credit terms Diaz Manufacturing extends to its customers. For example, if the industry average DSO is 77 days and Diaz Manufacturing gives customers 90 days to pay, then a DSO of 71.43 days is an indication of good management. If, in contrast, Diaz gives customers 60 days to pay, the company has a problem, and management needs to determine why customers are not paying on time.
Asset Turnover Ratios
We turn next to a discussion of some broader efficiency ratios. In this section we discuss two ratios that measure how efficiently management is using the firm’s assets to generate sales.
Total asset turnover measures the dollar amount of sales generated with each dollar of total assets. Generally, the higher the total asset turnover, the more efficiently management is using total assets. Thus, if a firm increases its asset turnover, management is squeezing more sales out of a constant asset base. When a firm’s asset turnover ratio is high for its industry, the firm may be approaching full capacity. In such a situation, if management wants to increase sales, it will need to make an investment in additional fixed assets. Total asset turnover should be interpreted with care when examining trends for a given firm or when benchmarking against competitors. Younger firms and firms with more recent purchases of fixed assets will have a higher book value of assets and therefore lower total asset turnover for a given level of net sales.
The formula for total asset turnover and the calculation for Diaz Manufacturing’s turnover value in 2014 (based on data from Exhibits 4.1 and 4.2) are as follows:
Total asset turnover for Diaz Manufacturing is 0.83 times. In other words, in 2014, Diaz Manufacturing generated $0.83 in sales for every dollar in assets. In Exhibit 4.3 you can see that Diaz Manufacturing’s total asset turnover has declined since 2012. This does not necessarily mean that the company’s management team is performing poorly. The decline could be part of a typical industry sales cycle, or it could be due to a slowdown in the business of Diaz Manufacturing’s customers. As always, getting a better fix on potential problems requires comparing Diaz Manufacturing’s total asset turnover with comparable figures for its close competitors.
The turnover of total assets is a “big picture” measure. In addition, management may want to see how particular types of assets are being put to use. A common asset turnover ratio measures sales per dollar invested in fixed assets (plant and equipment). The fixed asset turnover formula and the 2014 calculation for Diaz are:
Diaz Manufacturing generated $3.92 of sales for each dollar of net fixed assets in 2014, which is an increase over the 2013 value of $3.52. This means that the firm is generating more sales for every dollar in fixed assets. In a manufacturing firm that relies heavily on plant and equipment to generate output, the fixed asset turnover number is an important ratio. In contrast, in a service-industry firm with little plant and equipment, total asset turnover is more relevant.
Leverage ratios measure the extent to which a firm uses debt rather than equity financing and indicate the firm’s ability to meet its long-term financial obligations, such as interest payments on debt and lease payments. The ratios are also called long-term solvency ratios. They are of interest to the firm’s creditors, stockholders, and managers. Many different leverage ratios are used in industry; in this chapter we present some of the most widely used.
The term financial leverage refers to the use of debt in a firm’s capital structure. When a firm uses debt financing, rather than only equity financing, the returns to stockholders may be magnified. This so-called leveraging effect occurs because the interest payments associated with much long-term debt and some short-term debt are fixed, regardless of the level of the firm’s operating profits. On the one hand, if the firm’s operating profits increase from one year to the next, fixed debt holders continue to receive only their fixed-interest payments, and all of the increase goes to the stockholders. On the other hand, if the firm falls on hard times and suffers an operating loss, these debt holders receive the same fixed-interest payment (assuming that the firm does not become insolvent and default on its obligations to debt holders), and the loss is charged against the stockholders’ equity. Thus, debt increases the returns to stockholders during good times and reduces the returns during bad times. In Chapter 16 we discuss financial leverage in greater depth and present a detailed example of how debt financing creates the leveraging effect.
The use of debt in a company’s capital structure increases the firm’s default (insolvency) risk —the risk that it will not be able to pay its debt as it comes due. The explanation is, of course, that debt payments are a fixed obligation and debt holders must be paid the interest and principal payments they are owed, regardless of whether the company earns a profit or suffers a loss. If a company fails to make an interest payment on the prescribed date, the company defaults on its debt and could be forced into bankruptcy by creditors.
We next look at three leverage ratios that focus on how much debt, rather than equity, the firm employs in its capital structure. The more debt a firm uses, the higher its financial leverage, the more volatile its earnings, and the greater its risk of default.
Total Debt Ratio.
The total debt ratio measures the extent to which the firm finances its assets from sources other than the stockholders. The higher the total debt ratio, the more debt the firm has in its capital structure. The total debt ratio and a calculation for Diaz Manufacturing for 2014 based on data from Exhibit 4.1 appear as follows:
How do we determine the figure to use for total debt? Many variations are used, but perhaps the easiest is to subtract total equity from total assets. In other words, total debt is equal to total liabilities. A common alternative measure of debt is the sum of all the firm’s interest-bearing liabilities, such as notes payable and long-term debt. Using data from Exhibit 4.1, we can calculate total debt for Diaz Manufacturing in 2014 as follows:
As you can see from Equation 4.9, the total debt ratio for Diaz Manufacturing is 0.50, which means that 50 percent of the company’s assets are financed with debt. Looking back at Exhibit 4.3, we find that Diaz Manufacturing increased its use of debt from 2013 to 2014. The 2014 total debt ratio of 50 percent appears high, raising questions about the company’s financing strategy. Whether a high or low value for the total debt ratio is good or bad, however, depends on how the firm’s capital structure affects the value of the firm. We explore this topic in greater detail in Chapter 16.
We turn next to two common variations of the total debt ratio: the debt-to-equity ratio and the equity multiplier.
The total debt ratio tells us the amount of debt for each dollar of total assets. The debt-to-equity ratio tells us the amount of debt for each dollar of equity. Based on data from Exhibit 4.1, Diaz Manufacturing’s debt-to-equity ratio for 2014 is 1.02:
The total debt ratio and the debt-to-equity ratio are directly related by the following formula, shown with a calculation for Diaz Manufacturing:
As you can see, once you know one of these ratios, you can compute the other. Which of the two ratios you use is really a matter of personal preference.
The equity multiplier tells us the amount of assets that the firm has for every dollar of equity. Diaz Manufacturing’s equity multiplier ratio in 2014 was 2.02, as shown here:
Notice that the equity multiplier is directly related to the debt-to-equity ratio:
This is no accident. Recall the balance sheet identity: . This identity can be substituted into the numerator of the equity multiplier formula (Equation 4.11):
Therefore, all three of these leverage ratios (Equations 4.9-4.11) are related by the balance sheet identity, and once you know one of the three ratios, you can compute the other two ratios.
A second type of leverage ratio measures the firm’s ability to service its debt, or how easily the firm can “cover” its debt payments out of earnings or cash flow. We assess this using coverage ratios. For example, if your monthly take-home pay from your part-time job is $400 and the rent on your apartment is $450, your monthly coverage ratio with respect to rent is . Because this ratio is less than 1 you will be in some financial distress. Your income does not cover your $450 fixed obligation to pay the rent. If, on the other hand, your takehome pay is $900, your monthly coverage ratio with respect to rent is . This means that for every dollar of rent you must pay, you earn two dollars of revenue. The higher your coverage ratio, the less likely you are to default on your rent payments.
Times Interest Earned.
Our first coverage ratio is times interest earned, which measures the extent to which operating profits (earnings before interest and taxes, or EBIT) cover the firm’s interest expenses. Creditors prefer to lend to firms whose EBIT is far in excess of their interest payments. The equation for the times-interest-earned ratio and a calculation for Diaz Manufacturing from its income statement (Exhibit4.2) for 2014 are:
Diaz Manufacturing can cover its interest charges about 30 times with its operating income. This figure appears to point to a good margin of safety for creditors. In general, the larger the times interest earned, the more likely the firm is to make its interest payments.
As we have discussed before, depreciation is a noncash expense, and as a result, no cash goes out the door when depreciation is deducted on the income statement. Thus, rather than asking whether operating profits (EBIT) are sufficient to cover interest payments, we might ask how much cash is available to cover interest payments. The cash a firm has available from operations to meet interest payments is better measured by EBIT plus depreciation and amortization (EBITDA).Thus, the cash coverage ratio for Diaz Manufacturing in 2014 is:
For a firm with depreciation or amortization expenses, which includes virtually all firms, EBITDA coverage will be larger than times interest earned coverage.
Profitability ratios measure management’s ability to efficiently use the firm’s assets to generate sales and manage the firm’s operations. These measurements are of interest to stockholders, creditors, and managers because they focus on the firm’s earnings. The profitability ratios presented in this chapter are among a handful of such ratios commonly used by stockholders, managers, and creditors when analyzing a firm’s performance. In general, the higher the profitability ratios, the better the firm is performing.
Gross Profit Margin
The gross profit margin measures the percentage of net sales remaining after the cost of goods sold is paid. It captures the firm’s ability to manage the expenses directly associated with producing the firm’s products or services. Using data from Exhibit 4.2, the gross profit margin formula, along with a calculation for Diaz Manufacturing in 2014, is:
Thus, after paying the cost of goods sold, Diaz Manufacturing has 30.86 percent of the sales amount remaining to pay other expenses. From Exhibit 4.3, you can see that Diaz Manufacturing’s gross profit margin has been increasing over the past several years, which is good news.
Operating Profit Margin and EBITDA Margin
Moving farther down the income statement, you can measure the percentage of sales that remains after payment of cost of goods sold and all other expenses, except for interest and taxes. Operating profit is typically measured as EBIT. The operating profit margin, therefore, gives an indication of the profitability of the firm’s operations, independent of its financing policies or tax management strategies. The operating profit margin formula, along with Diaz Manufacturing’s 2014 operating profit margin calculated using data from Exhibit 4.2, is as follows:
Many analysts and investors are concerned with cash flows generated by operations rather than operating earnings and will use EBITDA in the numerator instead of EBIT. Calculated in this way, the operating profit margin is known as the EBITDA margin.
Net Profit Margin
The net profit margin is the percentage of sales remaining after all of the firm’s expenses, including interest and taxes, have been paid. The net profit margin formula is shown here, along with the calculated value for Diaz Manufacturing in 2014, using data from the firm’s income statement (Exhibit 4.2):
As you can see from Exhibit 4.3, Diaz Manufacturing’s net profit margin improved dramatically from 2012 to 2014. This is good news. The question remains, however, whether 7.58 percent is a good profit margin in an absolute sense. Answering this question requires that we compare Diaz Manufacturing’s performance to the performance of its competitors, which we will do later in this chapter. What qualifies as a good profit margin varies significantly across industries. Generally speaking, the higher a company’s profit margin, the better the company’s performance.
Return on Assets
So far, we have examined profitability as a percentage of sales. It is also important that we analyze profitability as a percentage of investment, either in assets or in equity. First, let’s look at return on assets. In practice, return on assets is calculated in two different ways.
One approach provides a measure of operating profit (EBIT) per dollar of assets. This is a powerful measure of return because it tells us how efficiently management utilized the assets under their command, independent of financing decisions and taxes. It can be thought of as a measure of the pre-tax return on the total net investment in the firm from operations. The formula for this version of return on assets, which we call EBIT return on assets (EROA), is shown next, together with the calculated value for Diaz Manufacturing in 2014, using data from Exhibits 4.1 and 4.2:
Exhibit 4.3 shows us that, unlike the other profitability ratios, Diaz Manufacturing’s EROA did not really improve from 2012 to 2014. The very similar EROA values for 2012 and 2014 indicate that assets increased at approximately the same rate as operating profits.
Some analysts calculate return on assets (ROA) as:
Although it is a common calculation, we advise against using the calculation in Equation 4.18 unless you are using the DuPont system, which we discuss shortly. The ROA calculation divides a measure of earnings available to stockholders (net income) by total assets (debt plus equity), which is a measure of the investment in the firm by both stockholders and creditors. Constructing a ratio of those two numbers is like mixing apples and oranges. The information that this ratio provides about the efficiency of asset utilization is obscured by the financing decisions the firm has made and the taxes it pays. You can see this in Exhibit 4.3, which shows that, in contrast to the very small change in EROA, ROA increases substantially from 2012 to 2014. This increase in ROA is not due to improved efficiency, but rather to a large decrease in interest expense (see Exhibit 4.2).
The key point is that EROA surpasses ROA as a measure of how efficiently assets are utilized in operations. Dividing a measure of earnings to both debt holders and stockholders by a measure of how much both debt holders and stockholders have invested gives us a clearer view of what we are trying to measure.
In general, when you calculate a financial ratio, if you have a measure of income to stockholders in the numerator, you want to make sure that you have only investments by stockholders in the denominator. Similarly, if you have a measure of total profits from operations in the numerator, you want to divide it by a measure of total investments by both debt holders and stockholders.
Return on Equity
Return on equity (ROE) measures net income as a percentage of the stockholders’ investment in the firm. The return on equity formula and the calculation for Diaz Manufacturing in 2014 based on data from Exhibits 4.1 and 4.2 are as follows:
Alternative Calculation of ROA and ROE
As with efficiency ratios, the calculation of ROA and ROE involves dividing an income statement value, which relates to a period of time, by a balance sheet value from the end of the time period. Some analysts prefer to calculate ROA and ROE using the average asset value or equity value, where the average value is determined as follows:
Using the average asset or equity value makes sense because the earnings over a period are generated with the average value of assets or equity.
The ratios we have discussed so far rely solely on the firm’s financial statements, and we know that much of the data in those statements are historical and do not represent current market values. Also, as we discussed in Chapter 1, the appropriate objective for the firm’s management is to maximize stockholder value, and the market value of the stockholders’ claims is the value of the cash flows that they are entitled to receive, which is not necessarily the same as accounting income. To find out how the stock market evaluates a firm’s liquidity, efficiency, leverage, and profitability, we need ratios based on market values.
Over the years, financial analysts have developed a number of ratios, called market-value ratios, which combine market-value data with data from a firm’s financial statements. Here we examine the most commonly used market-value ratios: earnings per share, the price-earnings ratio, and the market-to-book ratio.
Earnings per Share
Dividing a firm’s net income by the number of shares outstanding yields earnings per share (EPS). At the end of 2014, Diaz Manufacturing had 54,566,054 shares outstanding (see Exhibit 3.1 in Chapter 3) and net income of $118.5 million (Exhibit 4.2). Its EPS at that point is calculated as follows:
The price-earnings (P/E) ratio relates earnings per share to price per share. The formula, with a calculation for Diaz Manufacturing for the end of 2014, is as follows:
Price per share on a given date can be obtained from listings in the Wall Street Journal or from an online source, such as Yahoo! Finance.
What does it mean for a firm to have a price-earnings ratio of 22.4? It means that the stock market places a value of $22.40 on every $1 of net income. Why are investors willing to pay $22.40 for a claim on $1 of earnings? The answer is that the stock price does not only reflect the earnings this year. It reflects all future cash flows from earnings. An especially high P/E ratio can indicate that investors expect the firm’s earnings to grow rapidly in the future. Alternatively, a high P/E ratio might be due to unusually low earnings in a particular year and investors might expect earnings to recover to a normal level soon. We will discuss how expected growth affects P/E ratios in detail in later chapters. As with other measures, to understand whether the P/E ratio is too high or too low, we must compare the firm’s P/E ratio with those of competitors and also look at movements in the firm’s P/E ratio relative to market trends.
The Market-to-Book ratio compares the market value of the firm’s investments to its book value. The formula, with a calculation for Diaz at the end of 2014, is:
Book value per share is an accounting number that reflects the cumulative historical investment into the firm’s equity account on a per share basis. Market value of equity per share is simply the price per share. A higher market-to-book ratio suggests that the firm has been more effective at investing in projects that add value for its stockholders. A value of less than one could mean that the firm has not created any value for its stockholders.
Concluding Comments on Ratios
We could have covered many more ratios. However, the group of ratios presented in this chapter is a fair representation of the ratios needed to analyze the performance of a business. When using ratios, it is important that you ask yourself, “What does this ratio mean, and what is it measuring?” rather than trying to memorize a definition. Good ratios should make good economic sense when you look at them.
4.4 THE DUPONT SYSTEM: A DIAGNOSTIC TOOL
By now, your mind may be swimming with ratios. Fortunately, some enterprising financial managers at the DuPont Company developed a system in the 1960s that ties together some of the most important financial ratios and provides a systematic approach to financial ratio analysis.
An Overview of the DuPont System
The DuPont system of analysis is a diagnostic tool that uses financial ratios to evaluate a company’s financial health. The process has three steps. First, management assesses the company’s financial health using the DuPont ratios. Second, if any problems are identified, management corrects them. Finally, management monitors the firm’s financial performance over time, looking for differences from ratios established as benchmarks by management.
Under the DuPont system, management is charged with making decisions that maximize the firm’s return on equity as opposed to maximizing the value of the stockholders’ shares. The system is primarily designed to be used by management as a diagnostic and corrective tool, though investors and other stakeholders have found its diagnostic powers of interest.
The DuPont system is derived from two equations that link the firm’s return on assets (ROA) and return on equity (ROE). The system identifies three areas where management should focus its efforts in order to maximize the firm’s ROE: (1) how much profit management can earn on sales, (2) how efficient management is in using the firm’s assets, and (3) how much financial leverage management is using. Each of these areas is monitored by a single ratio, and together the ratios comprise the DuPont equation.
The ROA Equation
The ROA equation links the firm’s return on assets with its total asset turnover and net profit margin. We derive this relation from the ROA equation as follows:
As you can see, we start with the ROA formula presented earlier as Equation 4.18. Then we multiply ROA by net sales divided by net sales. In the third line, we rearrange the terms, coming up with the expression . You may recognize the first ratio in the third line as the firm’s net profit margin (Equation 4.16) and the second ratio as the firm’s total asset turnover (Equation 4.7). Thus, we end up with the final equation for ROA, which is restated as Equation 4.23:
Equation 4.23 says that a firm’s ROA is determined by two factors: (1) the firm’s net profit margin and (2) the firm’s total asset turnover. Let’s look at the managerial implications of each of these terms.
Net Profit Margin.
The net profit margin ratio can be written as follows:
As you can see, the net profit margin can be viewed as the product of three ratios: (1) the operating profit margin (EBIT/Net sales), which is Equation 4.15, (2) a ratio that measures the impact of interest expenses on profits (EBT/EBIT), and (3) a ratio that measures the impact of taxes on profits (Net income/EBT). Thus, the net profit margin focuses on management’s ability to generate profits from sales by efficiently managing the firm’s (1) operating expenses, (2) interest expenses, and (3) tax expenses.
Total Asset Turnover.
Total asset turnover, which is defined as Net sales/Total assets, measures how efficiently management uses the assets under its command—that is, how much output management can generate with a given asset base.
Net Profit Margin versus Total Asset Turnover
The ROA equation provides some very interesting managerial insights. It says that if management wants to increase the firm’s ROA, it can increase the net profit margin, total asset turnover, or both. Of course, every firm would like to make both terms as large as possible so as to earn the highest possible ROA. Though every industry is different, competition, marketing considerations, technology, and manufacturing capabilities, to name a few, place upper limits on asset turnover and net profit margins and, thus, ROA. Equation 4.23 suggests that management can follow two distinct strategies to maximize ROA. Deciding between the strategies involves a trade-off between total asset turnover and net profit margin.
The first management strategy emphasizes high profit margin and low asset turnover. Examples of companies that use this strategy are luxury stores, such as jewelry stores, high-end department stores, and upscale specialty boutiques. Such stores carry expensive merchandise that has a high profit margin but tends to sell slowly. The second management strategy depends on low profit margins and high turnover. Examples of firms that use this strategy are discount stores and grocery stores, which have very low profit margins but make up for it by turning over their inventory very quickly. A typical chain grocery store, for example, turns over its inventory more than 12 times per year.
Exhibit 4.4 illustrates both strategies. The exhibit shows asset turnover, profit margin, and ROA for four retailing firms for the fiscal year ending closest to December 2012. Tiffany & Co. is a nationwide retailer of high-end jewelry, and Ralph Lauren stores are upscale boutiques that carry expensive casual wear for men and women. At the other end of the spectrum are Wal-Mart, which is famous for its low-price, high-volume strategy, and Whole Foods Markets, a grocery chain based in Austin, Texas.
Company Asset Turnover × Profit Margin (%) = ROA (%)
High Profit Margin:
Tiffany & Co. 0.82 10.97 9.00
Ralph Lauren 1.28 10.80 13.82
Whole Foods Market 2.21 3.98 8.80
Wal-Mart Stores 2.31 3.62 8.36
aRatios are calculated using financial results for the fiscal year ending closest to December 2012.
EXHIBIT 4.4 Two Basic Strategies to Earn a Higher ROATo maximize a firm’s ROA, management can focus more on achieving high profit margins or on achieving high asset turnover. High-end retailers like Tiffany & Co. and Ralph Lauren focus more on achieving high profit margins. In contrast, grocery and discount stores like Whole Foods Market and Wal-Mart tend to focus more on achieving high asset turnover because competition limits their ability to achieve very high profit margins.
Notice that the two luxury-item stores (Tiffany & Co. and Ralph Lauren) have lower asset turnover and higher profit margins, while the discount and grocery stores have lower profit margins and much higher asset turnover. Whole Foods and Wal-Mart are strong financial performers in their industry sectors. Their relatively low ROAs of 8.80 and 8.36 percent, respectively, reflect the high degree of competition in the grocery and discount store businesses.
The ROE Equation
To derive the ROE equation, we start with the formula from Equation 4.19:
Next, we multiply by total assets divided by total assets, and then we rearrange the terms so that , as shown in the third line. By this definition, ROE is the product of two ratios already familiar to us: ROA (Equation 4.18) and the equity multiplier (Equation 4.11). The equation for ROE is shown as Equation 4.24:
Interesting here is the fact that ROE is determined by the firm’s ROA and its use of leverage. The greater the use of debt in the firm’s capital structure, the greater the ROE. Thus, increasing the use of leverage is one way management can increase the firm’s ROE—but at a price. That is, the greater the use of financial leverage, the more risky the firm. How aggressively a company uses this strategy depends on management’s preference for risk and the willingness of creditors to lend money and bear the risk.
The DuPont Equation
Now we can combine our two equations into a single equation. From Equation 4.24, we know that ; and from Equation 4.23, we know that turnover. Substituting Equation 4.23 into Equation 4.24 yields an expression formally called the DuPont equation, as follows:
We can also express the DuPont equation in ratio form:
To check the DuPont relation, we will use some values from Exhibit 4.3, which lists financial ratios for Diaz Manufacturing. For 2014, Diaz’s net profit margin is 7.58 percent, total asset turnover is 0.83, and the equity multiplier is 2.02. Substituting these values into Equation 4.25 yields:
With rounding error, this agrees with the value computed for ROE using Equation 4.19.
Applying the DuPont System
In summary, the DuPont equation tells us that a firm’s ROE is determined by three factors: (1) net profit margin, which measures the firm’s operating efficiency and how it manages its interest expense and taxes; (2) total asset turnover, which measures the efficiency with which the firm’s assets are utilized; and (3) the equity multiplier, which measures the firm’s use of financial leverage. The schematic diagram in Exhibit 4.5 shows how the three key DuPont ratios are linked together and how they relate to the balance sheet and income statement for Diaz Manufacturing.
EXHIBIT 4.5 Relations in the DuPont System of Analysis for Diaz Manufacturing in 2014 ($ millions) The diagram shows how the three key DuPont ratios are linked together and to the firm’s balance sheet and income statement. Numbers in the exhibit are in millions of dollars and represent 2014 data from Diaz Manufacturing. The ROE of 12.67 percent differs from the 12.64 percent in Exhibit 4.3 due to rounding.
The DuPont system of analysis is a useful tool to help identify problem areas within a firm. For example, suppose that North Sails Group, a sailboat manufacturer located in San Diego, California, is having financial difficulty. Management hires you to find out why the ship is financially sinking. You calculate the DuPont ratio values for the firm and obtain some industry averages to use as benchmarks, as shown.
DuPont Ratios Firm Industry
ROE 8% 16%
ROA 4% 8%
Equity multiplier 2 2
Net profit margin 8% 16%
Asset turnover 0.5 0.5
Clearly, the firm’s ROE is quite low compared to its industry (8 percent versus 16 percent), so without question the firm has problems. Next, you examine the values for the firm’s ROA and equity multiplier. The firm’s use of financial leverage is equal to the industry standard of 2 times, but its ROA is half that of the industry (4 percent versus 8 percent). Because ROA is the product of net profit margin and total asset turnover, you next examine these two ratios. Asset turnover does not appear to be a problem because the firm’s ratio is equal to the industry standard of 0.5 times. However, the firm’s net profit margin is substantially below the benchmark standard (8 percent versus 16 percent). Thus, the firm’s performance problem stems from a low profit margin.
Identifying the low profit margin as an area of concern is only a first step. Further investigation is necessary to determine the underlying problem and its causes. The point to remember is that financial analysis identifies areas of concern within the firm, but rarely does it tell us all we need to know.
Is Maximizing ROE an Appropriate Goal?
Throughout this book we have stressed the notion that management should make decisions that maximize the current value of the company stock. An important question is whether maximizing the value of ROE, as suggested by the DuPont system, is equivalent to maximization share price. The short answer is that the two goals are not equivalent, but some discussion is warranted.
A major shortcoming of ROE is that it does not directly consider cash flow. ROE considers earnings, but earnings are not the same as future cash flows. Second, ROE does not consider risk. As discussed in Chapter 1, management and stockholders are very concerned about the degree of risk they face. Third, ROE does not consider the size of the initial investment or the size of future cash payments. As we stressed in Chapter 1, the essence of any business or investment decision is this: What is the size of the cash flows to be received, when do you expect to receive the cash flows, and how likely are you to receive them?
In spite of these shortcomings, ROE analysis is widely used in business as a measure of operating performance. Proponents of ROE analysis argue that it provides a systematic way for management to work through the income statement and balance sheet and to identify problem areas within the firm. Furthermore, they note that ROE and stockholder value are often highly correlated.
4.5 SELECTING A BENCHMARK
How do you judge whether a ratio value is too high or too low? Is the value good or bad? We touched on these questions several times earlier in this chapter. As we suggested, the starting point for making these judgments is selecting an appropriate benchmark—a standard that will be the basis for meaningful comparisons. Financial managers can gather appropriate benchmark data in three ways: through trend, industry, and peer group analysis.
Trend analysis uses history as its standard by evaluating a single firm’s performance over time. This sort of analysis allows management to determine whether a given ratio value has increased or decreased over time and whether there has been an abrupt shift in a ratio value. An increase or decrease in a ratio value is in itself neither good nor bad. However, a ratio value that is changing typically prompts the financial manager to sort out the issues surrounding the change and to take any action that is warranted. Exhibit 4.3 shows the trends in Diaz Manufacturing’s ratios. For example, the increase in Diaz’s current ratio indicates that the company’s liquidity has improved.
A second way to establish a benchmark is to conduct an industry group analysis. To do that, we identify a group of firms that have the same product line, compete in the same market, and are about the same size. The average ratio values for these firms will be our benchmarks. Since no two firms are identical, deciding which firms to include in the analysis is always a judgment call. If we can construct a sample of reasonable size, however, the average values provide defensible benchmarks.
Financial ratios and other financial data for industry groups are published by a number of sources—the U.S. Department of Commerce, Dun & Bradstreet, the Risk Management Association, and Standard & Poor’s (S&P), to name a few. One widely used system for identifying industry groups is the Standard Industrial Classification (SIC) System . The SIC codes are four-digit numbers established by the federal government for statistical reporting purposes. The first two digits describe the type of business in a broad sense (for example, firms engaged in building construction, mining of metals, manufacturing of machinery, food stores, or banking). Diaz’s two-digit code is 35: “Industrial and commercial machinery and computer equipment manufacturing.”
More than 400 companies fall into the “Industrial and commercial machinery and computer equipment manufacturing” code category. To narrow the group, we use more digits. Diaz Manufacturing’s four-digit code is 3533 (“oil and gas field machinery and equipment manufacturing”), and there are only 35 firms in this category. Among firm’s within an SIC code, financial ratio data can be further categorized by asset size or by sales, which allows for more meaningful comparisons.
In 1977, the North American Industry Classification System (NAICS) was introduced as a new classification system. It was intended to refine and replace the older SIC codes, but it has been slow to catch on. Industry databases still allow you to sort data by either SIC or NAICS classifications.
Although industry databases are readily available and easy to use, they are far from perfect. When trying to find a sample of firms that are similar to your company, you may find the classifications too broad. For example, Wal-Mart and Nordstrom have the same four-digit SIC code (5311), but they are very different retailing firms. Another problem is that different databases may compute ratios differently. Thus, when making benchmark comparisons, you must be careful that your calculations match those in the database, or there could be some distortions in your findings.
Peer Group Analysis
The third way to establish benchmark information is to identify a group of firms that compete with the company we are analyzing. Ideally, the firms are in similar lines of business, are about the same size, and are direct competitors of the target firm. These firms form a peer group. Once a peer group has been identified, management can obtain the associated financial information and compute average ratio values against which the firm can compare its performance.
How do we determine which firms should be in the peer group? The senior management team within a company will know its competitors. If you’re working outside the firm, you can look at the firm’s annual report and at financial analysts’ reports. Both of these sources usually identify key competitors. Exhibit 4.6 shows ratios for a five-firm peer group constructed for Diaz Manufacturing for 2012 through 2014.
2014 2013 2012
Current ratio 2.10 2.20 2.10
Quick ratio 1.50 1.60 1.50
Inventory turnover 5.40 5.30 5.20
Day’s sales in inventory 67.59 68.87 70.19
Accounts receivable turnover 4.90 4.20 4.10
Days’ sales outstanding 76.70 89.80 90.00
Total asset turnover 0.87 0.90 0.80
Fixed asset turnover 3.50 3.30 2.40
Total debt ratio 0.18 0.11 0.21
Debt-to-equity ratio 0.40 0.20 0.50
Equity multiplier 2.02 1.77 2.05
Times interest earned 7.00 5.60 1.60
Cash coverage 7.50 8.20 1.30
Gross profit margin 26.80% 24.10% 19.20%
Operating profit margin 12.00% 6.90% 2.70%
Net profit margin 10.74% 3.30% 0.10%
Return on assets 9.34% 3.30% 0.80%
Return on equity 13.07% 7.00% 1.00%
Price-to-earnings ratio 18.10 38.40 44.60
Earnings per share $1.65 $3.85 $3.78
Market-to-book ratio 2.84 1.82 1.64
EXHIBIT 4.6 Peer Group Ratios for Diaz Manufacturing Peer group analysis is one way to establish benchmarks for a firm. Ideally, a firm’s peer group is made up of firms that are its direct competitors and are of about the same size. The exhibit shows the average financial ratios for public companies that make up the peer group for Diaz Manufacturing for 2012, 2013, and 2014.
We consider the peer group methodology the best way to establish a benchmark if financial data for peer firms are publicly available. We should note, however, that comparison against a single firm is acceptable when there is a clear market leader and we want to compare a firm’s performance and other characteristics against those of a firm considered the best. For example, Ford Motor Company may want to compare itself directly against the automobile manufacturer that is the most productive. It is worthwhile to compare a firm with the market leader to identify areas of relative strength and weakness.
4.6 USING FINANCIAL RATIOS
So far, our focus has been on the calculation of financial ratios. As you may already have concluded, however, the most important tasks are to correctly interpret the ratio values and to make appropriate decisions based on this interpretation. In this section we discuss using financial ratios in performance analysis.
Performance Analysis of Diaz Manufacturing
Let’s examine Diaz Manufacturing’s performance during 2014 using the DuPont system of analysis as our diagnostic tool and the peer group sample in Exhibit 4.6 as our benchmark. For ease of discussion, Diaz’s financial ratios and the peer group data are assembled in Exhibit 4.7.
(1) (2) (3)
Diaz Ratio Peer Group Ratio Difference (Column 1 – Column 2)
Return on equity (%) 12.64 13.07 (0.43)
Return on assets (%) 6.27 9.34 (3.07)
Equity multiplier (%) 2.02 1.40 0.62
Net profit margin (%) 7.58 10.74 (3.16)
Total asset turnover 0.83 0.87 (0.04)
Current ratio 2.75 2.10 0.65
Fixed asset turnover 3.92 3.50 0.42
Inventory turnover 2.55 5.40 (2.85)
Accounts receivable turnover 5.11 4.90 0.21
Gross profit margin (%) 30.86 26.80 4.06
Operating margin (%) 10.77 12.00 (1.23)
Net profit margin (%) 7.58 10.74 (3.16)
EXHIBIT 4.7 Peer Group Analysis for Diaz Manufacturing in 2014 Examining the differences between the ratios of a firm and its peer group is a good way to spot areas that require further analysis.
We start our analysis by looking at the big picture—the three key DuPont ratios for the firm and a peer group of firms (see Exhibit 4.7). We see that Diaz Manufacturing’s ROE of 12.64 percent is below the benchmark value of 13.07 percent, a difference of 0.43 percent, which is not good news. More dramatically, Diaz’s ROA is 3.07 percent below the peer group benchmark, which is a serious difference. Clearly, Diaz Manufacturing has some performance problems that need to be investigated.
To determine the problems, we examine the firm’s equity multiplier and ROA results in more detail. The equity multiplier value of 2.02, versus the benchmark value of 1.40, suggests that Diaz Manufacturing is using more leverage than the average firm in the benchmark sample. Management is comfortable with the higher-than-average leverage. Conversations with the firm’s investment banker, however, indicate that the company’s debt could become a problem if the economy deteriorated and went into a recession.
Without the higher equity multiplier and management’s willingness to bear additional risk, Diaz Manufacturing’s ROE would be much lower. To illustrate this point, suppose management reduced the company’s leverage to the peer group average equity multiplier of 1.40 (see Exhibit 4.7). With an equity multiplier of 1.40, the firm’s ROE would be only ; this is 3.86 percent below the firm’s current ROE of 12.64 percent and 4.29 percent below the peer group benchmark. Thus, the use of higher leverage has, to some extent, masked the severity of the firm’s problem with ROA.
Recall that ROA equals the product of the net profit margin and total asset turnover. Diaz’s net profit margin is 3.16 percent lower than the benchmark value , and its total asset turnover ratio is slightly below the benchmark value (0.83 versus 0.87). Thus, both ratios that comprise ROA are below the peer group benchmark standard, but the net profit margin appears to be the larger problem.
Turning to the asset turnover ratios shown in Exhibit 4.7, we find that the ratios for Diaz are generally similar to the corresponding peer group ratios. An exception is the inventory turnover ratio, which is substantially below the benchmark: 2.55 for Diaz versus 5.40 for the benchmark. Diaz’s management needs to investigate why the inventory turnover ratio is off the mark.
Because Diaz Manufacturing’s net profit margin is low, we next look at the various profit margins shown in Exhibit 4.7 to gain insight into this situation. Diaz Manufacturing’s gross profit margin is 4.06 percentage points above the benchmark value , which is good news. Since gross profit margin is a factor of sales and the cost of goods sold, we can conclude that there is no problem with the price the firm is charging for its products or with its cost of goods sold.
Diaz’s problems begin with its operating margin of 10.77 percent, which is 1.23 percentage points below the peer group benchmark of . The major controllable expense here is selling and administrative costs, and management needs to investigate why these expenses appear to be out of line.
In sum, the DuPont analysis of Diaz Manufacturing has identified two areas that warrant detailed investigation by management: (1) the larger-than-average inventory (slow inventory turnover) and (2) the above-average selling and administrative expenses. Management must now investigate each of these areas and come up with a course of action. Management may also want to give careful consideration to the firm’s high degree of financial leverage and whether it represents a prudent degree of risk.
Financial ratio analysis is an excellent diagnostic tool. It helps management identify the problem areas in the firm—the symptoms. However, it does not tell management what the causes of the problems are or what course of action should be taken. Management must drill down into the accounting data, talk with managers in the field, and if appropriate, talk with people outside the firm, such as suppliers, to understand what is causing the problems and how best to fix them.
Limitations of Financial Statement Analysis
Financial statement and ratio analysis as discussed in this chapter presents two major problems. First, it depends on accounting data based on historical costs. As we discussed in Chapter 3, knowledgeable financial managers would prefer to use financial statements in which all of the firm’s assets and liabilities are valued at market. Financial statements based on current market values more closely reflect a firm’s true economic condition than do statements based on historical cost.
Second, there is little theory to guide us in making judgments based on financial statement and ratio analysis. That is why it is difficult to say a current ratio of 2.0 is good or bad or to say whether ROE or ROA is a more important ratio. The lack of theory explains, in part, why rules of thumb are often used as decision rules in financial statement analysis. The problem with decision rules based on experience rather than theory is that they may work fine in a stable economic environment, but may fail when a significant shift takes place. For example, if you were in an economic environment with low inflation, you could develop a set of decision rules to help manage your business. However, if the economy became inflationary, more than likely many of your decision rules would fail.
Despite the limitations, we know that financial managers and analysts routinely use financial statements and ratio analysis to evaluate a firm’s performance and to make a variety of decisions about the firm. These financial statements and the resulting analysis are the primary means by which financial information is communicated both inside and outside of firms. The availability of market value data is limited for public corporations and are not available for privately held firms and other entities such as government units.
Thus, practically speaking, historical accounting information often represents the best available information. However, times are changing. As the accounting profession becomes more comfortable with the use of market data and as technology increases its availability and reliability and lowers its cost, we expect to see an increase in the use of market-based financial statements.
Chapter4: Analyzing Financial Statements