Calculate Vertical Analysis Percentages

Learning how to calculate vertical analysis can be overwhelming without the right tools. In this guide, we’ll explore how Sourcetable lets you calculate vertical analysis and more using its advanced features, which you can try at app.sourcetable.com/signup. And then working out each transaction that is recorded in your financial books as a bookkeeping and payroll services percentage of that figure. Read on to learn more about vertical analysis of a balance sheet, how to perform one, and some limitations and drawbacks of this analytical tool.

Advantages

Vertical Analysis, also known as common size analysis, has been a staple in financial reporting and analysis. It simplifies the comparison of financial statements of companies of different sizes by converting figures to percentages of a total. Businesses can improve their performance by taking the vertical analysis percentage formula necessary steps to address any issues. Ernst & Young found that 70% of businesses using vertical analysis were able to identify key areas for operational improvement. Vertical Analysis using Income Statements helps in understanding the proportion of each expense and revenue item. For instance, suppose the total revenue is Rs.10 crore and the cost of goods sold (COGS) is Rs.4 crore, then the COGS would be 40% of total revenue.

Accounting Ratios

• Vertical analysis makes it much easier to compare and contrast the financial statements of different companies.
• On the balance sheet, with Rs. 500 crores of total assets, if current assets were Rs. 150 crores and fixed assets were Rs. 300 crores,.
• A 2019 McKinsey study found that top performing companies carefully manage the composition of expenses, keeping non-core costs below 15% of revenue.
• A research conducted by the Indian Institute of Management (IIM) found that Indian companies using vertical analysis were better able to manage their operational costs.
• Do you want to take your financial analysis skills to the next level and get more detailed insight into your financial statements?

The sum of the current assets equals 50%, confirming our calculations thus far are correct. Once we divide each balance sheet item by the “Total Assets” of $500 million, we are left with the following table. For example, some minor adjustments could be to remove the “Revenue (% Revenue)” line item since it is not necessary and offers no practical insights. The placement is not much of a concern in our simple exercise, however, the analysis can become rather “crowded” given numerous periods. In contrast, the process is practically the same for the balance sheet, but there is the added option of using “Total Liabilities” instead of “Total Assets”.

Example 3: Equity Proportion Analysis

This shows each cash outflow or inflow as a percentage of the total cash inflows of the business. Based on the information above, Jackson Widget Company’s total assets are $190,000. That’s $100,000 in cash plus $40,000 in accounts receivable plus $50,000 of fixed assets.

Vertical Analysis Formula Explained in Video

By comparing a large number of firms at once, analysts can ensure that indicators like net income and total income are comparable among businesses of varied sizes. This approach is helpful since it quickly and clearly breaks down the financial statements’ graphs and charts of various account balances as a proportion of the whole. A basic vertical analysis needs an individual statement for a reporting period but comparative statements may be prepared to enhance the usefulness of analysis. Sign up for a free trial today at app.sourcetable.com/signup and streamline your calculation processes. Sourcetable, an AI-powered spreadsheet, revolutionizes how these calculations are performed, allowing users to run vertical analysis effortlessly. Its intuitive interface and advanced features empower you to apply complex calculations and analyze AI-generated data seamlessly.

Vertical Analysis Formula

Though this is dependent on what you are attempting to measure as different financial documents will have different base figures. This type of analysis enables businesses to view the relative proportions of account balances, compare internal changes over time, and identify trends. The vertical analysis formula, also known as the common-size ratio, is a way to express each line item on a financial statement as a percentage of a base amount. Each line item’s common-size ratio can then be used to conduct comparative analysis across different fiscal periods or companies, allowing for a standardized approach to analyzing financial statements. The main benefit of vertical analysis is that it helps businesses determine whether certain items consistently increase or decrease over time.

• COGS was 60% of revenue in 2020, 55% in 2023, and 59% in 2022, You can see it dropped but then started rising again as a percent of revenue.
• This technique fosters informed decision-making and strategic planning, vital for sustained success in today’s competitive financial landscape.
• Conceptually, vertical analysis can be thought of as reading a single column of financial data and determining the relationships among each item to reflect the relative size of the various cost and profit metrics.
• Understanding how to effectively apply vertical analysis can lead to improved insights into financial operations and performance across various organizations.
• The following examples demonstrate how to do a vertical analysis using these free balance sheet template and income statement template.

Analyze & Compare Results

Vertical analysis is a handy tool and a popular method for comparing financial statements. When using this alongside horizontal analysis, you can get a full picture of a company’s financial position. Standardizing financial statements as percentages through vertical analysis helps make comparisons regardless of absolute size differences. Trends in the percentages highlight comparative strengths and weaknesses between companies. Vertical analysis of financial statements is also very useful in analyzing key trends over time.

Step 1: Gather your balance sheet figures

Vertical analysis enables the analyst to delve deeper into a financial statement and better comprehend its composition. To perform such analysis, one needs to create a common size financial statement (for example, a common size income statement). Vertical analysis states financial statements in a comparable common-size format (i.e., percentage form). One of the advantages of common-size analysis is that it can be used for inter-company comparison of enterprises with different sizes because all items are expressed as a percentage of some common number. Vertical analysis (also known as common-size analysis) is a popular method of financial statement analysis that shows each item on a statement as a percentage of a base figure within the statement. Through vertical analysis, companies can engage in ratio trend analysis and regression analysis, gaining a clearer understanding of how individual items correlate to overall financial health.

• Results and methodologies are displayed directly in a user-friendly spreadsheet format, accompanied by concurrent explanations via a chat interface.
• We can gather from the data below that the sales of the company increased consistently from year 1 to year 3.
• For instance, a vertical analysis of an income statement might reveal that a company is spending a higher percentage of its revenue on marketing expenses compared to its competitors.
• In the example below total assets has been chosen as the base line item and the right hand column shows each line item as a percentage of total assets.
• The net profit margin ratio reveals how much net income is generated for each rupee of sales.
• Here, we have divided each item by the company’s total sales and shown each category as a percentage of total sales for year 1-3 respectively.

It is beneficial for financial benchmarking and assessing company performance over time. Vertical analysis is less effective for companies in different stages of growth. Startups and mature companies can exhibit vastly different financial characteristics. A startup might have high operating expenses as a percentage of revenue due to bookkeeping initial investment in growth, while a mature company might have lower percentages due to established operations. Comparing these companies using vertical analysis alone may not provide an accurate assessment.