Vertical Analysis

Vertical Analysis Overview

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. Typically, 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 time period, so that one can see the relative proportions of account balances. Vertical analysis is also useful for timeline 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.

Vertical Analysis of the Income Statement

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:

	Rs. Totals	Percent
Sales	Rs.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:

	Rs. Totals	Percent
Cash	Rs.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	Rs.1,000,000	100%
Accounts payable	Rs.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	Rs.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.