Horizontal analysis of financial statements: Mathematical Solution

Horizontally analysis is usually a financial statement research technique that shows changes within the amounts of corresponding financial statement items over a period of time. It is a useful tool to measure the trend situations.

The statements for two or more periods are utilized in horizontal analysis. The primary period is usually used since the base period and the items on the statements for all later periods are compared with items on the statements from the base period. The changes are usually shown both inside dollars and portion.

Dollar and percentage changes are computed by using the following formulas:


Horizontal analysis may be conducted for balance sheet, income statement, schedules of current and fixed assets and statement of retained earnings.


An example of the horizontal analysis of balance sheet, schedule of current assets , income statement and statement of retained earnings is given below:

Comparative balance sheet with horizontal analysis:



550,000 – 533,000 = 17,000

(17,000/533,000) * 100 = 3.2%

Comparative schedule of current assets:


Comparative income statement with horizontal analysis:



Comparative retained earnings statement with horizontal analysis:


In above analysis, 2007 is the base year and 2008 is the comparison year. All items on the balance sheet and income statement for the year 2008 have been compared with the items of balance sheet and income statement for the year 2007.

The actual changes in items are compared with the expected changes. For example, if management expects a 30% increase in sales revenue but actual increase is only 10%, it needs to be investigated.