Do you ever wonder how your company’s financial health stacks up to that of competitors? Or how your revenue and expenses have changed over time? If so, you can use horizontal and vertical variance analysis to transform your financial information into a percentage format. This way, you can easily spot trends in year-over-year results and compare your company to industry averages.

Variance analysis may sound complicated but it’s actually fairly straightforward to set up. If you have access to your accounting software, start by downloading two years’ worth of financial statements and copying the information into a spreadsheet.

Horizontal Variance Analysis

Horizontal variance analysis, also known as trend analysis, compares financial statement information over time. Most trend analysis spreadsheets show both the change in the dollar figure and the year-over-year percent change.

To analyze your financials using the horizontal method, place the two years’ worth of data side by side. Subtract this year’s numbers from last year’s numbers to find the dollar amount difference between the two. Divide the dollar amount difference by last year’s numbers to find the percent change. The comparison for the balance sheet should look something like this. The income statement comparison should look like this. You can also do a month-over-month comparison, but seasonal revenue fluctuations can skew the figures.

Look For Unexpected Trends

Once you set up the comparison, note the changes and evaluate how they stack up with your expectations. Keep an eye out for large variations in dollar amounts and  percentages, both positive and negative. Pay attention to any changes that are greater than 10 percent. If certain expenses are increasing or revenues are decreasing and you don’t know why, that’s a sign there may be a problem you need to investigate.

Vertical Variance Analysis

Vertical variance analysis of the income statement is the practice of expressing every expense as a percentage of net sales. Vertical analysis of the balance sheet uses the same concept, but every line item is expressed as a percentage of total assets. Expressing the income statement and balance sheet in this way is referred to as generating common-size financial statements. This NetMBA article provides a good example of what a common-size income statement and balance sheet look like.

Read the rest of the article here:

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s