## Vertical Analysis Formula & Purpose What is Vertical Analysis? Video & Lesson Transcript

By seeing the trend, which is a remarkable growth of over 100% from one year to the next, we can also see that the trend itself is not that remarkable of only 10% change from 2013 at 110% to 120% in 2014. Which could show, that perhaps growth is starting to stagnate or level-off. For example, although interest expense from one year to the next may have increased 100 percent, this might not need further investigation; because the dollar amount of increase is only \$1,000. The ability to spot this trend over time empowers you to intervene and be pro-active in solving the problem.

• Once you have that number, you can divide each line item by total revenue and multiply by 100 to get a percentage.
• Then, consider that in 2014, 50% of Cost of Goods Sold was 50% where it was 55% a year ago.
• Since these proportions are expressed as percentages, you can easily compare them to other time periods or other companies.
• Harold Averkamp (CPA, MBA) has worked as a university accounting instructor, accountant, and consultant for more than 25 years.
• Most often, vertical analysis is used by management to find changes or variations in financial statement items of importance like individual asset accounts or asset groups.

Tools like Google Sheets or Excel allow you to automate calculations, so you can focus on analysis. Using Layer, you can also automate data flows and user management, gathering and updating the data automatically, carrying out the analysis, and sending out customized reports. If a company has a gross sale amounting to \$5 million in which \$1 million represents the cost of goods sold, \$2 million used for general expenses and a tax rate of 25%. My Accounting Course  is a world-class educational resource developed by experts to simplify accounting, finance, & investment analysis topics, so students and professionals can learn and propel their careers.

## Vertical Analysis Example

The first line item might be sales revenue, which totaled \$100,000 last year. Vertical analysis makes it much easier to compare the financial statements of one company with another, and across industries. This is because one can see the relative proportions of account balances. Common methods of financial statement analysis include fundamental analysis, DuPont analysis, horizontal and vertical analysis and the use of financial ratios. Historical information combined with a series of assumptions and adjustments to the financial information may be used to project future performance. The Chartered Financial Analyst designation is available for professional financial analysts.

It would require the arrangement and calculation of interlinked numbers and dates. Particularly, interlinks among the numbers make financial analysis tiresome and complex for a typical businessperson. A solution is to create https://simple-accounting.org/ Comparative Financial Statements, which depicts the results of Horizontal Analysis and show the trends relative to only one base year. The baseline acts as a peg for the other figures while calculating percentages.

Business owners can use company financial analysis both internally and externally. They can use them internally to examine issues such as employee performance, the efficiency of operations and credit policies. They can use them externally to examine potential investments and the creditworthiness of borrowers, amongst other things. An example of vertical analysis would be if you took a company’s total revenue and divided it by the number of products they sell.

For example, on an income statement, the value of each revenue stream is a separate line item, which contributes to the total revenue. Depending on their expectations, Mistborn Trading could make decisions to alter operations to produce expected outcomes. For example, MT saw a 50% accounts receivable increase from the prior year to the current year. If they were only expecting a 20% increase, they may need to explore this line item further to determine what caused this difference and how to correct it going forward.

Common-size analysis is also an effective way of comparing two companies with different levels of revenues and assets. In general, managers prefer expenses as a percent of net sales to decrease over time, and profit figures as a percent of net sales to increase over time. Most changes were positive, with increasing revenues and decreasing expenses.

• Depending on their expectations, Mistborn Trading could make decisions to alter operations to produce expected outcomes.
• Horizontal analysis differs slightly from vertical analysis in that it presents each item in the financial statements as a percentage of itself at an earlier period in time.
• Vertical analysis is used in order to gain a picture of whether performance metrics are improving or deteriorating.
• Vertical analysis is a way to compare each line item on a financial statement to some percentage of the total for that category.
• For example, although interest expense from one year to the next may have increased 100 percent, this might not need further investigation; because the dollar amount of increase is only \$1,000.

Sometimes, financial statements are prepared in this way by the provider but often FP&A analysts will utilize their own basis depending on what information they are trying to understand. The issue with only performing horizontal analysis is that it presents one line item as it pertains https://simple-accounting.org/vertical-analysis-definition-and-overview/ to itself. Therefore, it is important to see the total picture by combining horizontal and vertical analysis. By doing this analysis get an idea of how line items compare to themselves over time and whether those changes make sense in the context of the current time period as well.

## What is a Vertical Analysis?

Let us assume that variable expenses on year 1, 2, and 3 were \$151, \$147, and \$142 respectively. DuPont analysis uses several financial ratios that multiplied together equal return on equity, a measure of how much income the firm earns divided by the amount of funds invested (equity). Likewise, a large change in dollar amount might result in only a small percentage change which will not cause concern for the business owner. With a Horizontal Analysis, also, known as a “trend analysis,” you can spot trends in your financial data over time.