Horizontal Analysis refers to the process of comparing the line of items over the period, in the comparative financial statement, to track the overall trend and performance. On the other hand, vertical analysis refers to the tool used to study financial statement by making a comparison of each line of the item as a proportion of the base figure within the statement, i.e. assets, liabilities, sales or equity. A closer look into vertical analysis in fig shows the distribution pattern of liabilities among current liabilities, long – terms liabilities and equity capital. Similarly, it shows the distribution pattern of total asserts among current asserts, fixed assets and other asserts. In this article, you will learn about the horizontal analysis of financial statements and how to incorporate it into your company’s accounting practices. You will also learn how to do horizontal analysis using an income statement and a balance sheet. You can carry out the analysis of financial statements using many methods.

This type of analysis enables analysts to assess relative changes in different line items over time and project them into the future. Horizontal analysis is used by companies to see what has been the factors to drive the company’s financial performance over a number of years (Aizenman & Marion, 2004). (Miller & Goidel, 2009) Like in Nepal as well, the demand/sell of clothes and other appliances is higher during special festivals or occasions compared to other normal days.

Horizontal Analysis: Should You Be Using It in Your Business?

Google is in a good phase of business at the moment, and will likely continue to expand and announce new products and tech as they normally do. I’ve added a line for research & development costs as well. We have no way of knowing, because we don’t know the cash positions of Companies A and B, how profitable Companies A and B are, etc. Harold Averkamp has worked as a university accounting instructor, accountant, and consultant for more than 25 years. He is the sole author of all the materials on AccountingCoach.com. Insert a column to the right of ‘2022’ and click on the cell corresponding to the first revenue line item.

Analysis are done to understand what is going on in a company. It helps investors analyze and ascertain whether the company has had consistent growth over the years and if they are utilizing fund available in a balanced way. The horizontal analysis as the name suggest is the analysis done on horizontal basis for the same item of a company’s financial statements generally for two or more years. It analyses the trend of the company by calculating the change percentage between the same line item for various years. On the other hand the vertical analysis is done by comparing the line items vertically in a financial statement with the total of either sales or assets . This is done for single year, analyses the changes over time and the effect of one line item to another as well as to the base amount .

Vertical And Horizontal Analysis Of Starbucks

In the next section, you have step-by-step instructions on how to do horizontal analysis with examples using a balance sheet and an income statement. The following examples demonstrate how to do a vertical analysis using these free balance sheet template and income statement template. The calculations are performed in Google Sheets, but you can easily do the same in Excel. In addition to the data for your company, collect the same data for similar companies in your industry.

In vertical analysis, the line of items on a balance sheet can be expressed as a proportion or percentage of total assets, liabilities or equity. However, in the case of the income statement, the same may be indicated as a percentage of gross sales, while in cash flow statement, the cash inflows and outflows are denoted as a proportion of total cash inflow. It is a useful tool for gauging the trend and direction over the period. In this analysis, the line of items is compared in comparative financial statements or ratios over the reporting periods, so as to record the overall rise or fall in the company’s performance and profitability. In this way horizontal and vertical analysis helps to analyze the trend of a company and the income statement based on the total revenue. Based on the above analysis we see that the sales has increased resulting in increase in retained earning and dividend payout. The liquidity has also increased along with decrease in cost of capital.

Horizontal analysis helps you spot trends

Vertical analysis is a type of ratio analysis that presents each line on the financial statements as a percentage of another item. This uses a fixed point of reference that Horizontal And Vertical Analysis is used for comparison purposes. For example, on the income statement, if the base chosen is revenue, then each line item would be expressed as a percentage of revenue.

The Vertical Analysis income statement Fig reveals what portion of sales has been absorbed by various costs, and expenses incurred and the percentage of the total sales that remains as net income. For example, the table shows that 60 percent of total sales are incurred as cost of goods sold and only 13.54 percentage of total sales are in the form of net income to the firm. The first step to performing horizontal analysis is to calculate the net difference — in dollar terms ($) — between the comparable periods. Suppose we’re tasked with performing horizontal analysis on a company’s financial performance from fiscal years ending 2020 to 2021. Starbuck’s consolidated net revenue grew 17% to $19.2 billion, from 2014. Their non-GAAP (adjusted-generally accepted accounting principles) operating income was up 19% to $3.7 billion, over their 2014 total.

It’s yours, free.

Seeing the horizontal analysis of every item allows you to more easily see the trends. It will be easy to detect that over the years the cost of goods sold has been increasing at a faster pace than the company’s net sales. From the balance sheet’s horizontal analysis you may see that inventory and accounts payable have been growing as a percentage of total assets. Horizontal analysis allows investors and analysts to see what has been driving a company’s financial performance over several years and to spot trends and growth patterns.

• Notice that the column presenting the ratio of each line item to gross sales is to the right of the actual values.
• Although there is increase in liabilities and provision, investments in made in fixed assets and other assets have increased showing a good balance in the company statement.
• Their non-GAAP operating margin was at 19%, which increased 50 basis points from 2014.
• It could possibly be that they are extending credit to customers more readily than anticipated or not collecting as rapidly on outstanding accounts receivable.
• You can analyze multiple periods separately, then do a horizontal analysis to look for trends.

With the help of this analysis, the percentages so computed can be directly compared with the result of the equivalent percentages of the past years or other companies operating in the same industry, irrespective of their size. So, common size https://business-accounting.net/ financial statement not only helps in intra-firm comparison but also in inter-firm comparison. Comparative financial statements reflect the profitability and financial status of the concern for various accounting years in a comparative manner.

Calculate Line Items as % of Total

For this example, I will carry out the analysis of the data reported for 2021 and 2022. However, you can do this quickly for multiple years, particularly if you’re interested in long-term trends. Fortunately, tools like Google Sheets or Excel allow you to set up templates, so you can forget about the calculations and focus on analysis. Using Layer, you can also automate data flows and user management, so you can gather the data automatically, carry out the analysis, and automatically share results and reports with the right users. 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.

• When using vertical analysis, a line item on a financial statement is listed as a percentage of another item .
• It is a useful tool for gauging the trend and direction over the period.
• Vertical Analysis → In vertical analysis, each line item on the income statement is expressed as a percentage of a base figure, which is usually revenue .
• Vertical analysis, horizontal analysis and financial ratios are part of financial statement analysis.
• In fact, there must be a bare minimum of at least data from two accounting periods for horizontal analysis to even be plausible.
• The latter two tend to go hand-in-hand because the most useful benchmark against which to compare recent performance is most often the preceding period.