Horizontal Analysis (%) = [(Amount in Comparison Year – Amount in Base Year) / Amount in Base Year] * 100

1. The overall growth has been relatively higher in the year 2018 compared to that of the year 2017.
2. Further, it is also noticed that the operating income moves in tandem with the revenue growth, which is a good sign.

What does horizontal and vertical analysis show?

The primary aim of horizontal analysis is to keep a track on the behaviour of the individual items of the financial statement over the years. Conversely, the vertical analysis aims at showing an insight into the relative importance or proportion of various items on a particular year’s financial statement.

What does a vertical analysis tell you?

Vertical analysis makes it easier to understand the correlation between single items on a balance sheet and the bottom line, expressed in a percentage. Vertical analysis can become a more potent tool when used in conjunction with horizontal analysis, which considers the finances of a certain period of time.

What’s the difference between vertical analysis and Horizontal analysis?

What is the difference between vertical analysis and horizontal analysis? Vertical analysis expresses each amount on a financial statement as a percentage of another amount. The vertical analysis of a balance sheet results in every balance sheet amount being restated as a percent of total assets.

How to calculate the formula for Horizontal analysis?

Explanation 1 Firstly, note the line item’s amount in the base year from the financial statement. 2 Next, note the amount of the line item in the comparison year. 3 Now, the formula for in absolute terms can be derived by deducting the amount in the base year (step 1) from the amount in comparison year (step 2),

How to do Horizontal analysis with base year?

Horizontal Analysis (%) = [ (Amount in Comparison Year – Amount in Base Year) / Amount in Base Year] * 100 In the above table, it can be seen that: The percentage change in gross profit has been relatively higher than that of net sales due to a lower increase in the cost of goods sold.

How is the percentage of sales calculated in a vertical analysis?

In the vertical analysis of financial statements, the percentage is calculated by using the below formula: Vertical analysis formula for the Income Statement and Balance Sheet are given below – Vertical Analysis Formula (Income Statement) = Income Statement Item / Total Sales * 100