Blog

The importance of common size analysis lies in the power of percentages to help you gain a deeper understanding of your business, find out whether it’s growing profitably and compare it to the competition. You can use it to see how your business stacks up percentage-wise with another bookkeeping for startups business, even if that business is substantially larger. 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.

Because vertical analysis deals with percentages rather than totals, using vertical analysis makes it easy to compare company performance with other companies, even those of different sizes. Here, we’ve chosen “Revenue” as the base figure for the common size income statement, followed by “Total Assets” for the common size balance sheet. In vertical analysis each line item in the income statement is converted to a percent of total assets.

Definition of Vertical Analysis of Income Statement

Once converted to common-size percentages, however, we see that Coca-Cola outperforms PepsiCo in virtually every income statement category. Coca-Cola’s cost of goods sold is 36.1 percent of net sales compared to 45.9 percent at PepsiCo. Coca-Cola’s gross margin is 63.9 percent of net sales compared to 54.1 percent at PepsiCo. Coca-Cola’s operating income is 24.1 percent of sales compared to 14.4 percent at PepsiCo.

• 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.
• This helps you get a better idea of general trends in your accounts and any growth or decline that may have occurred over set periods of time.
• Vertical analysis compares line items within a statement in the current year.
• So if we had multiple years of historical data, it is recommended to organize the percentage calculations into a single section on the far right or below the financials with the timing of the periods aligned.

The balance sheet is the financial statement that provides a snapshot in time of the company’s financial position. It is composed of assets, liabilities, and stockholders’ equity and demonstrates the accounting equation is in balance. Liabilities are amounts a company owes like accounts payable and long-term debt.

Business Case Studies

For this example, the analysis will be carried out on the data reported for 2021. However, you can do this quickly for multiple years, particularly if you use a balance sheet template. Since the total will be the same for all line items in this section, use absolute referencing ($) for the total. Drag down the cell with the formula to copy it to the other revenue line items. Note that rounding issues sometimes cause subtotals in the percent column to be off by a small amount.

All these companies, who cheat it financial position through vertical analysis always designed their financial statement in column form and also post the data in columns in figure and percentage. The lined-up items in the financial statement help the user to easily analyze the statement and give the report related to the financial position. These types of a financial statement included the vertical analysis in which all item are lined up in a vertical column that called column size financial statement. This percentage can be used to compare both balance sheet and income statementperformance within the company. Much like ratio analysis, vertical analysis allows financial information of a small company to be compared with that of a large company.

Overview of Vertical Analysis

The second column is the common-size version with a vertical analysis based on total assets. Each common-size line item is the percent of total assets that the line item’s dollar value represents. Generally speaking, a common-size financial statement is a type of analysis of an income statement that expresses each line of the statement as a percentage of sales. The common size income statement shows that the percentage of COGS has also gone up. This suggests that the firm should try to find quality material at a lower cost and lower its direct expenses if possible. The main purpose of the vertical analysis to find the interrelationship between the item of the statement and also check the volume of sales, Profit and total assets of the business.

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. In fact, some sources of industry data present the information exclusively in a common-size format, and most of the accounting software available today has been engineered to facilitate this type of analysis. The income from selling the products or services will show up in operating profit.

Automate financial reporting with LiveFlow

In the current year, company XYZ reported a net income of $20 million and retained earnings of $52 million. Consequently, it has an increase of $10 million in its net income and $2 million in its retained earnings year over year. With the financial information in hand, it’s time to decide how to analyze the information. Get instant access to video lessons taught by experienced investment bankers. Learn financial statement modeling, DCF, M&A, LBO, Comps and Excel shortcuts.

While vertical analysis cannot answer why changes have taken place, it’s a useful tool for trend analysis along with pinpointing areas that need further investigation. Balance sheet vertical analysis uses total assets as a base and assigns a percentage to all line items. Horizontal analysis is a financial analysis technique used to evaluate a company’s performance over time. By comparing prior-period financial results with more current financial results, a company is better able to spot the direction of change in account balances and the magnitude in which that change has occurred. On the other hand, horizontal analysis looks at amounts from the financial statements over a horizon of many years. Coverage ratios, like the cash flow-to-debt ratio and the interest coverage ratio, can reveal how well a company can service its debt through sufficient liquidity and whether that ability is increasing or decreasing.

A common-size income statement allows you to compare your company’s income statement to another company’s or to the industry average. Vertical analysis is said to get its name from the up and down motion of your eyes as you scan the common-size financial statements during the analysis process. 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.