Common-Size Statements

A common-size income statement is created by restating each line as a percentage of net sales. Expressing each item on the income statement as a percentage rather than in absolute dollars makes it much easier to make comparisons, particularly to other divisions or competitors of varying sizes. The formula to calculate each item on the income statement is:

Common-Size Item = Income Statement Line Item / Net Sales

Using Clear Lake Sporting Goods’ current year income statement, we can see how each line item in it is divided by net sales in order to assemble a common-size income statement (see Figure 5.20).

Figure 5.20 Common-Size Income Statement

It may seem cumbersome to create a common-size statement. However, a simple tool like Microsoft Excel can be quite handy in making the process easier and faster. The same formula can be copied and replicated in each income statement line, making the calculations much faster. In Figure 5.21, you can see the formulas used to create Clear Lake Sporting Goods’ common-size income statement in Excel. Notice that the $ can be inserted to anchor a cell reference, making it easier to copy and paste the same formula onto many lines or columns.

Figure 5.21 Clear Lake Sporting Goods Common-Size Income Statements with Excel Formulas

The common-size balance sheet functions much like the common-size income statement. Each line item on the balance sheet is restated as a percentage of total assets.

Common-Size Item = Balance Sheet Line Item / Total Assets

Using Clear Lake Sporting Goods’ current balance sheet, we can see how each line item in its statement is divided by total assets in order to assemble a common-size balance sheet (see Figure 5.22).

Figure 5.22 Common-Size Balance Sheet

Excel can also be used to create a common-size balance sheet. Once the formula is created, it can be copied into each line, making the process to create a common-size statement much easier (see Figure 5.23):

Figure 5.23 Common-Size Balance Sheet with Excel Formulas

It is important to note that while we have provided two years of data here to explore the process, when performing analysis for a firm or investment, several years of data are commonly used to provide a better view of historical performance.

Common-size financial statements facilitate the analysis of financial performance by converting each element of the statements to a percentage. This makes it easier to compare figures from one period to the next, compare departments within an organization, and compare the firm to other companies of any size as well as industry averages. On the income statement, analysts can see how much of sales revenue is spent on each type of expense. They can see this breakdown for each firm and compare how different firms function in terms of expenses, proportionally. They can also look at the percentage for each expense over time to see if they are spending more or less on certain areas of the business, such as research and development. On the balance sheet, analysts commonly look to see the percentage of debt and equity to determine capital structure. They can also quickly see the percentage of current versus noncurrent assets and liabilities.

In Clear Lake Sporting Goods’ common-size income statement for the current and prior years, we can see that cost of goods as a percentage of sales remained the same (see Figure 5.24). This means that while sales increased, so did cost of goods sold, but it increased at the same proportion as sales. No improvement or decline occurred in the company’s cost of goods sold. The same is true for rent, depreciation, and utilities expenses. One key item did change slightly as a percentage: salaries expense. The 2 percent decrease in operating income from the prior year’s 38 percent to the current year’s 36 percent was caused by the increase in salaries expense as a percentage of sales.

Net income, however, only declined by 1 percent from 30 percent in the prior year to 29 percent in the current year because interest expense dropped by 1 percent, offsetting the 2 percent increase in salaries expense.

Figure 5.24 Common-Size Income Statement

On the Clear Lake Sporting Goods’ common-size balance sheet, we see that current assets remained at 80 percent of total assets from the prior to current year (see Figure 5.25). The mix of current assets that comprise that 80 percent changed only slightly with a 1 percent decrease in cash, 2 percent increase in accounts receivable, 2 percent decrease in inventory, and no change in short-term investments. Noncurrent assets includes only equipment. While the balance in the equipment account did change as a percentage of total assets, equipment remained the same at 20 percent.

On the debt and equity side of the balance sheet, however, there were a few percentage changes worth noting. In the prior year, the balance sheet reflected 55 percent debt and 45 percent equity. In the current year, that balance shifted to 60 percent debt and 40 percent equity. The firm did issue additional stock and showed an increase in retained earnings, both totaling a $10,000 increase in equity. However, the equity increase was much smaller than the total increase in liabilities of $40,000. Long-term debt increased by only $10,000 by issuing additional notes payable. The remainder of that increase is seen in the 5 percent increase in current liabilities. In that increase, most of it was in unearned revenue.

Figure 5.25 Common-Size Balance Sheet

Now that you have covered the basic financial statements and a little bit about how they are used, where do we find them? How often are they prepared? Who gets them? In this next section we will explore the requirements for what needs to be reported, when, and to whom.

Common-Size Income Statement

Visit the Apple, Inc. Common-Size Income Statement provided by the Stock Analysis on Net website. Review the company’s cost of sales, gross profit, operating income, other income, and net income percentages for the current and prior year. What can you learn about the company’s recent performance in these areas? Has it improved or declined, or has it simply changed incrementally with gross sales?

Common-Size Assets and Common-Size Liabilities and Equity

Visit the Apple, Inc. Common-Size Assets Balance Sheet and Common-Size Liabilities and Equity Balance Sheet provided by the Stock Analysis on Net website. Review the composition of the company’s assets, liabilities, and equity. How have assets changed? Has capital structure changed? If so, what elements impacted the change?