Horizontal analysis is comparing financial information from one reporting period (your base period) to similar financial information from other reporting periods to analyze historical trends.
When you compare information in one financial statement against similar information from other reporting periods, you can better understand your financial position and performance.
By recognizing values that are trending upward or downward, you can learn what’s driving performance, efficiency and profitability.
GAAP requires your financial statements to be consistent and comparable to one another—and that they’re able to be analyzed against similar companies. This requires you to follow the same accounting methods and principles for every reporting period.
You can express your horizontal analysis as change percentages or absolute values. If you’re using change percentages, your base period is 100%.
This is the formula for a horizontal analysis:
Horizontal Analysis (Value) = (Amount in Comparison Period - Amount in Base Period) / Amount in Base Period.
OR
Horizontal Analysis (%) = (Amount in Comparison Period - Amount in Base Period) / Amount in Base Period X 100.
Save hours on designing and formatting your financial reports with these free Reporting Templates for Excel.
What’s keeping you from reporting and uncovering trends faster?
Create accurate reports in less time with Vena’s Financial Reporting Software. Automate your workflows, conduct your variance analysis and discover what’s behind your business’s financial position.