Horizontal analysis of financial statements: Mathematical Solution - QS Study
top logo

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:

a

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

Example

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:

com

 

550,000 – 533,000 = 17,000

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

Comparative schedule of current assets:

sch

Comparative income statement with horizontal analysis:

asd

 

Comparative retained earnings statement with horizontal analysis:

zxc

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.