Horizontal and Vertical Analysis

Starting from the revenue line item, each line item on the income statement – if deemed appropriate – is divided by revenue (or the applicable core metric). This online calculator can be used to know the percentage change year over year (Y-o-Y) in net sales of your business. For the horizontal analysis, let us look at the example using real numbers to understand our topic completely. This is the part that helps you apply everything that you learnt beforehand. Students should develop an understanding of how to read these statements, particularly in India. Chartered accountant Michael Brown is the founder and CEO of Double Entry Bookkeeping.

Step 2: determine comparison methods

• Looking ahead, the role of analysis will only grow in importance as companies face an increasingly dynamic and competitive financial landscape.
• When conducting horizontal analysis, be aware of any changes in accounting policies that might affect comparability between periods.
• Horizontal analysis is a financial analysis technique that compares financial information over multiple periods to identify trends and changes.
• One of the primary advantages is its ability to detect trends and pinpoint discrepancies that may require further investigation.
• With effective horizontal analysis, the growth and profitability of a company can also be evaluated.

He has worked as an accountant and consultant for more than 25 years and has built financial models for all types of industries. He has been the CFO or controller of both small and medium sized companies and has run small businesses of his own. He has been a manager and an auditor with Deloitte, a big 4 accountancy firm, and holds a degree from Loughborough University.

• By analyzing financial statements, your company accurately spots trends over time and identifies the mix of assets and liabilities it has to deal with within a certain period.
• Armed with these insights, management can target specific areas for operational improvements, cost reductions, or process optimizations.
• Whether you’re assessing growth or pinpointing areas of concern, this analysis can offer valuable insights.
• At PivotXL, we are dedicated to supporting finance teams in making their horizontal analysis as efficient and insightful as possible.

Horizontal Analysis of Financial Statements

This method offers a more nuanced view of financial performance than looking at a single period’s data in isolation. Horizontal analysis involves the calculation of percentage changes from one or more years horizontal analysis over the base year dollar amount. The following two examples of horizontal analysis use an abbreviated income statement and balance sheet information where 2019 represents the base year.

• Horizontal analysis is a method used to evaluate financial data over multiple periods, allowing businesses to spot trends and patterns.
• The consolidated financial statement of Wipro Limited and its subsidiaries for the year ended March 31, 2024 is uploaded below.
• Variations in accounting methods or data aggregation can lead to inaccurate conclusions in your horizontal analysis.
• A horizontal balance sheet can also used to compare the growth rate, profitability, losses and overall business performance of various companies and in the same company for various accounting periods.
• A group of products within the product family recognised as having a certain functional coherence.
• He has a vast knowledge in technical analysis, financial market education, product management, risk assessment, derivatives trading & market Research.

Percentage Changes and Trends

• Changes in equity also reveal whether the company’s net worth is increasing or whether it needs to raise capital.
• A senior executive at a company can’t make any decisions based on a top-line revenue figure alone.
• The percentage change is calculated by dividing the dollar change between the base year and the year in question by considering the line item.
• Financial statement analysis can be used to evaluate a company’s liquidity, solvency, profitability, and overall financial position.
• The percentage change is determined by dividing the dollar difference between the comparison year and the base year by the line item value in the base year, then multiplying the result by 100.

At Bricks, we built our AI data analyst to do this heavy lifting for you. Numbers and percentages are great, but visuals make trends instantly obvious. Excel has several tools perfect for bringing your horizontal analysis to life. The revenue decreased Record Keeping for Small Business by 0.8% from Rs 604,234 million in 2023 to Rs 599,327 million in 2024.

Horizontal analysis can also be applied to the balance sheet to evaluate changes in assets, liabilities, and shareholders’ equity over multiple periods. You can assess the company’s financial position and overall health by comparing these items. For instance, an increase in total assets suggests that the company is investing or expanding, while a decrease might signal asset disposals or financial difficulties. Another issue with horizontal analysis of financial statements is that the aggregation of financial information in those statements may have changed https://www.bookstime.com/ over time. It means that the expenses, revenues, assets and liabilities may have changed in different accounting periods. Hence, these changes can cause variations when comparing the account balances of one accounting year to another.