Horizontal Analysis of Balance Sheets and Financial Statements

In general, an analysis of Financial Statements is vital for a person running a business. Because this analysis tells these business owners where they stand in their financial environment. Explain the percentage of receivables basis to estimating the amount of uncollectible accounts. That means that from 2017 to 2018, your revenue increased by 24%. The articles and research support materials available on this site are educational and are not intended to be investment or tax advice.

It would make more sense to compare the values for a specific quarter to the same quarter from past years. If you happen to choose a particularly bad time period for your base values, the values for your comparison period may look much better than they are. Now that you know how to calculate percentage change, you can read about all the steps involved in horizontal analysis in the next section. Now we can assume a sales growth percentage based on the historical trends and project the revenues under each segment. Therefore, total net sales are in the Oral, Personal & Home Care, andPet Nutrition Segments. Let us assume that we are provided with the income statement data of ABC Co.

Horizontal Analysis of Balance Sheets

Whereas a low percentage rate compared to the average for the industry usually indicates an efficient use of Assets. Likewise, a high percentage rate indicates the need to improve the use of Assets. Describe how the various users may use the financial statement information. The example from Safeway Stores shows a comparative which of the following is an example of horizontal analysis? balance sheet for 2018 and 2019 following a similar format to the income statement above. Horizontal, or trend, analysis is used to spot and evaluate trends over a specific period of time. For example, if a company starts generating low profits in a particular year, expenses can be analyzed for that year.

At the bottom of the analysis, note that net income, as a percentage of sales, declined by 2.62 percentage points (6.67 percent to 4.05 percent). As a dollar amount, net income declined by $14,096 ($33,333 to $19,237). Management should consider both the percentage change and the dollar amount change. \n\nAt the bottom of the analysis, note that net income, as a percentage of sales, declined by 2.62 percentage points (6.67 percent to 4.05 percent). In the final section, we’ll perform horizontal analysis on our company’s historical balance sheet. Financial Statements often contain current data and the data of a previous period.

Everything You Need To Master Financial Statement Modeling

Business owners can use company financial analysis both internally and externally. They can use them internally to examine issues such as employee performance, the efficiency of operations and credit policies. They can use them externally to examine potential investments and the creditworthiness of borrowers, amongst other things. Which of the following is an example of what vertical analysis can tell a financial statement… By looking at the numbers provided by a company, you should see whether there are any large differences between one year and the next. It is also possible to perform this analysis with time series data to make direct comparisons with other companies. Horizontal analysis of income statements also produces worthwhile information.

This figure compares the difference in accounts from 2014 to 2015, showing each account as a percentage of sales for each year listed. You can do the same types of analyses for balance sheet accounts. For a horizontal analysis, you compare like accounts to each other over periods of time — for example, accounts receivable (A/R) in 2014 to A/R in 2015.

Business is Our Business

This method of analysis makes it easy for the financial statement user to spot patterns and trends over the years. The percentage change in gross profit has been relatively higher than that of net sales due to a lower increase in the cost of goods sold. Now that you have the percentage change values for your chosen variables – both for your company and others in the same industry – it’s time to analyze your company’s values and those of your competitors. This will allow you to interpret these results within as comprehensive a context as possible. First, decide which periods you will be comparing, carefully choosing comparable periods. For example, if your industry is seasonal, comparing consecutive quarters would provide misleading results.

The business will need to determine which line item they are comparing all items to within that statement and then calculate the percentage makeup. These percentages are considered common-size because they make businesses within industry comparable by taking out fluctuations for size. It is typical for an income statement to use revenue as the comparison line item.