May 03, 2022/ Steven Bragg
Vertical analysis is the proportional analysis of a financial statement, where each line item on a financial statement is listed as a percentage of another item. This means that every line item on an income statement is stated as a percentage of gross sales, while every line
item on a balance sheet is stated as a percentage of total assets. The most common use of vertical analysis is within a financial statement for a single reporting period, so that one can see the relative proportions of account balances. Vertical analysis is also useful for trend analysis, to see relative changes in accounts over time, such as on a comparative basis over a five-year period. For example, if the cost of goods sold has a history of being 40% of sales in each of the past four
years, then a new percentage of 48% would be a cause for alarm. The most common use of vertical analysis in an income statement is to show the various expense line items as a percentage of sales, though it can also be used to show the percentage of different revenue line items that make up total sales. An example of vertical analysis for an income statement is
shown in the far right column of the following condensed income statement:
What is Vertical Analysis?
Vertical Analysis of the Income Statement
$ Totals
Percent
Sales
$1,000,000
100%
Cost of goods sold
400,000
40%
Gross margin
600,000
60%
Salaries and wages
250,000
25%
Office rent
50,000
5%
Supplies
10,000
1%
Utilities
20,000
2%
Other expenses
90,000
9%
Total expenses
420,000
42%
Net profit
180,000
18%
The information provided by this income statement format is useful not only for spotting spikes in expenses, but also for determining which expenses are so small that they may not be worthy of much management attention.
Vertical Analysis of the Balance Sheet
The central issue when creating a vertical analysis of a balance sheet is what to use as the denominator in the percentage calculation. The usual denominator is the asset total, but one can also use the total of all liabilities when calculating all liability line item percentages, and the total of all equity accounts when calculating all equity line item percentages. An example of vertical analysis for a balance sheet is shown in the far right column of the following condensed balance sheet:
$ Totals | Percent | |
Cash | $100,000 | 10% |
Accounts receivable | 350,000 | 35% |
Inventory | 150,000 | 15% |
Total current assets | 600,000 | 60% |
Fixed assets | 400,000 | 40% |
Total assets | $1,000,000 | 100% |
Accounts payable | $180,000 | 18% |
Accrued liabilities | 70,000 | 7% |
Total current liabilities | 250,000 | 25% |
Notes payable | 300,000 | 30% |
Total liabilities | 550,000 | 55% |
Capital stock | 200,000 | 20% |
Retained earnings | 250,000 | 25% |
Total equity | 450,000 | 45% |
Total liabilities and equity | $1,000,000 | 100% |
The information provided by this balance sheet format is useful for noting changes in a company's investment in working capital and fixed assets over time, which may indicate an altered business model that requires a different amount of ongoing funding. This information can be used to revised budgeted funding levels in future periods.