How to Analyze Financial Statements: Horizontal Method

Analyzing Financial Statements: The Horizontal Method

The second method to analyze financial statements is the horizontal method. The horizontal method is used to analyze financial information in two fiscal years.

This method consists of comparing various financial statements, and it has a comparative evaluation between two years as less to identify the evolution of different accounts.

The method involves increasing and decreasing, a technique used to compare similar concepts on different dates. The object is to locate differences or inconsistent and analyze the accounts’ behavior year by year.

We determine if the variation is positive (increase) or negative (decrease). 

To ensure a good analyze we recommend following the following steps:

Step #1

Having the financial statements in an Excel format will make it easier for the necessary calculations. Make sure you include the complete accounts next to their amounts and the two years correspondence. In the following example, we can see how it must look.

   

Step #2

Include two columns next to the amounts inserted; the first one will be used to present the increases and decreases, and the second one will show the percentages.

The horizontal method takes each account’s value from the last year minus each account’s worth from the previous year.

For example, cash and cash equivalents from 2019 minus cash and its equivalents from 2018, as we can see as follow:

   

Then, the result is divided by the total of the account from the last year. In this case, the result was divided by the total cash and cash equivalent from 2019 (the most recent year), obtaining 1.55%.

   

Step #3

Once the percentages have been obtained, the user of the financial statements can select the account with more variation (a positive percentage if the account had an increase or a negative percentage if the account had a decrease) in the assets, liabilities, or income loss statement.

In the following example, we have the current portion of sublease receivable with 100% positive variation and cash and cash equivalents with 1.55% negative variation. The first have our special attention because it has more than 50%.

   

Step #4

The analyst can start making questions about the variations; the first one could be which sublease did the company celebrate? In which operations or inversions the company expended cash?

You could have that information having an interview with the accounting department, the administrator, or even directly with the company’s owner, also. If the financial statement has been audited, you could read its notes.

With this method and the vertical method, it is essential to be sure about the accounts you are reviewing and investigate a lot about them. Make questions, look for supporting documents and call an expert if necessary.

Written by: Andrea Diaz

Related Articles:

Newsletters

Events & Sponsorship

Talent Kids Event 2017

August 19, 2017 RGB Accounting has proudly sponsored the 2017 Talent Kids event organized by Pecora Events on August 19th. RGB Accounting wants to thank organizers, presenters, judges, and all participants for making this a great event. Here we share some of the...

Los Nocheros USA/Canada Tour 2017

June 02, 2017 Argentina's biggest folkloric phenomenon arrived in Toronto, Canada to celebrate its 30 years trajectory. RGB Accounting was one of the sponsors of the event. More from our blog   Newsletters Events & Sponsorship Articles &...

2nd Latin American Entrepreneur Conference

May 29, 2017 The Entrepreneur Conference was organized by the City of Toronto's Economic Development & Culture department in partnership with the Latin American Bi-Lateral Trade Initiative (LABTI) which consists of the Consulate Generals of Argentina, Brazil,...

Tax Season 2017 at La Liga Indoor Soccer

April 29, 2017 RGB Accounting has been sponsoring social events to promote cultural values in the hispanic community of Toronto and the GTA. The During the last tax season, RGB Accounting helped many individuals and small business owners to prepare their taxes,...

Articles & Publications

Home office expenses for employees

Home office expenses for employees Calculate your expenses To understand the math behind the home office expenses calculation, refer to how the claim is calculated. To use the calculator, select from the options below. A temporary flat rate of $2 for each day you...

Tax impacts of leaving Canada to live elsewhere

Tax impacts of leaving Canada to live elsewhere. You must carefully consider numerous tax impacts before deciding to leave Canada to live elsewhere. Analyzing the termination of your tax residence is a question of fact. Generally, the Canada Revenue Agency will...

Selling your business shares to a family member?

Selling your business shares to a family member?   A new law means significant tax relief when you pass your business on to your kids.   A recent change to Canada’s Income Tax Act (ITA) could reduce the tax sting associated with selling your business shares...

Tax changes in the latest fiscal update.

Tax changes in the latest fiscal update. If you're working from home, you can claim up to $500 for office expenses with the temporary flat rate method There were very few broad-based tax changes in the recently released federal government's fall economic statement....

COVID-19 Update January 2022

COVID-19 Update   Federal   Expanding Access to the Local Lockdown Program (December 22, 2021) The Department of Finance announced that the government intends to expand the Local Lockdown Program eligibility to access the wage and rent subsidies to more...