# Vertical Analysis: Definition, How it Works, and Example.

What is Vertical Analysis?

Vertical analysis is a financial statement analysis technique that shows relationships between a company's various account balances and items over time. What is another term for vertical analysis? Vertical analysis is also known as common-size analysis.

#### How do you do vertical analysis on Excel?

Vertical analysis is a financial statement analysis technique that shows each line item as a percentage of a base figure. For example, a company's income statement may show sales, cost of goods sold, gross profit, and operating expenses as a percentage of sales. This type of analysis is also known as a common-size analysis.

To do vertical analysis on Excel, first create a column for the base figure. For example, if you are doing vertical analysis on a company's income statement, the base figure would be sales. Then, create a column for each line item, and enter the line item amounts in those columns. Finally, create a column for the percentages, and use the Excel function =line item amount/base figure to calculate the percentages. How do you analyze a vertical analysis? A vertical analysis is a financial statement analysis technique that shows each item in a company's financial statements as a percentage of a key figure. For instance, a vertical analysis of a company's income statement would show each line item as a percentage of total revenue.

There are a few different ways to approach a vertical analysis. One way is to calculate the percentage of each line item in relation to the total for that particular financial statement. For example, if a company has total revenue of \$100,000 and cost of goods sold of \$40,000, then the cost of goods sold would be 40% of total revenue.

Another way to approach a vertical analysis is to calculate the percentage of each line item in relation to a different line item. For example, if a company has total revenue of \$100,000 and cost of goods sold of \$40,000, then the cost of goods sold would be 40% of total revenue.

The most common way to present a vertical analysis is to use common-size financial statements. Common-size financial statements express each line item on a financial statement as a percentage of a common base figure. For example, a common-size income statement would express each line item as a percentage of total revenue.

There are a few advantages of using a vertical analysis. One advantage is that it makes it easy to compare line items to each other. For example, if you are looking at two companies' income statements and one company has a cost of goods sold that is 50% of total revenue while the other company has a cost of goods sold that is 60% of total revenue, then you can immediately see that the first company has a lower cost of goods sold as a percentage of total revenue.

Another advantage of using a vertical analysis is that it makes it easy to spot trends. For example, if you are looking at a company's income statements for multiple years and you see that the

### What is vertical analysis example?

Vertical analysis is a financial statement analysis technique that shows each line item as a percentage of a base figure within the statement. The base figure can be total revenue, total assets, or total liabilities, depending on which statement is being analyzed.

For example, vertical analysis of a balance sheet would show each line item as a percentage of total assets. This would give the analyst a better idea of the relative size of each line item and how it has changed over time. Vertical analysis of an income statement would show each line item as a percentage of total revenue. This would give the analyst a better idea of the relative profitability of each line item.

#### How do you perform a vertical analysis of financial statements?

A vertical analysis of financial statements is a type of financial analysis that shows the relative proportions of each item in a financial statement. For example, a vertical analysis of a company's balance sheet would show what percentage of the company's assets are made up of cash, what percentage are made up of accounts receivable, and so on.

A vertical analysis can be performed on any financial statement, but is most commonly used on the balance sheet and income statement. To perform a vertical analysis, all of the items on a financial statement are expressed as a percentage of the total. For example, if a company has \$100,000 in cash and \$200,000 in accounts receivable, the vertical analysis would show that cash makes up 50% of the company's assets and accounts receivable makes up 100% of the company's assets.

The vertical analysis is a useful tool for financial analysis because it allows for easy comparisons between companies of different sizes. For example, a vertical analysis of two companies' balance sheets would show whether one company is more leveraged than the other, even if the absolute values of the items on the balance sheet are different.