{"id":597,"date":"2021-04-27T06:47:46","date_gmt":"2021-04-27T06:47:46","guid":{"rendered":"https:\/\/enorcerna.com\/wiki\/definition\/horizontal-analysis\/"},"modified":"2021-04-27T06:47:46","modified_gmt":"2021-04-27T06:47:46","slug":"horizontal-analysis","status":"publish","type":"post","link":"https:\/\/enorcerna.com\/wiki\/definition\/horizontal-analysis\/","title":{"rendered":"Horizontal analysis"},"content":{"rendered":"<div>\n<p>\n<span itemprop=\"description\"><strong>The horizontal analysis calculates the absolute and relative variation suffered by each of the items on the balance sheet or the income statement in two consecutive periods of time.<\/strong><\/span><\/p>\n<p><span id=\"more-75676\"\/><\/p>\n<p>Therefore, the horizontal or dynamic analysis focuses on finding out what has happened to an accounting item in a given period.  It is normally calculated between two financial years and in the calendar year.  It must be taken into account that absolute and relative values \u200b\u200bare used, the latter being the most useful to show the variations.<\/p>\n<h3><span itemprop=\"additionalType\">How to do a horizontal analysis<\/span><\/h3>\n<p>The way of calculation is very simple.  We need the balance sheet or income statement for two years.  In this way, in a spreadsheet or using specific software, two more columns are added.  The first is the difference between the last year and the previous one.  The second is a rate of change whose formula is the following:<\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img decoding=\"async\" loading=\"lazy\" itemprop=\"image\" loading=\"lazy\" src=\"https:\/\/enorcerna.com\/wiki\/wp-content\/uploads\/2021\/04\/Horizontal-analysis.png\" alt=\"Horizontal Analysis 1\" class=\"wp-image-75678\" width=\"395\" height=\"112\"  \/><\/figure>\n<\/div>\n<p>What the rate of change (relative value) does is calculate how much a variable increases or decreases in two periods of time.  The value obtained indicates in percentage what this variation has been.  The sign tells us if it has increased (positive) or decreased (negative).  This value is the most relevant in the analysis.<\/p>\n<h3><span itemprop=\"additionalType\">Some considerations<\/span><\/h3>\n<p>When carrying out the calculations, we must take into account which games we are comparing.  It is not the same to compare debts and fixed assets.  In the first case, the ideal state is that these decrease.  In the second, depending on other factors, it could be that it increases.  In relation to expenses and income, a similar reasoning could be made.<\/p>\n<p>On the other hand, comparison with the sector average is also necessary.  There are items that grow little in percentage terms, but it is a characteristic of a specific activity.  For example, in the case of banks, interest rates vary little from year to year.  Therefore, it is convenient to know how others behave.<\/p>\n<h3><span itemprop=\"additionalType\">A practical example<\/span><\/h3>\n<p>Let's imagine a company that has an income statement like the one shown.  We will dispense with the balance.  We have two columns with the values \u200b\u200bof the last two years.  A third column indicates the absolute variation and the fourth the relative one.  We have seen the formula for the latter in a previous section.<\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img decoding=\"async\" loading=\"lazy\" itemprop=\"image\" loading=\"lazy\" width=\"526\" height=\"194\" src=\"https:\/\/enorcerna.com\/wiki\/wp-content\/uploads\/2021\/04\/1619506065_804_Horizontal-analysis.png\" alt=\"Horizontal Analysis 2\" class=\"wp-image-75684\"  \/><\/figure>\n<\/div>\n<p>We can see that revenues have increased by 20,000, which is 20% over the previous year.  Supplies also had an increase, while the rest of expenses decreased.  The financial result improved by increasing income and reducing spending.  We see that, in this case, the variation is negative, because we started from a negative value.  Therefore it is interpreted as a decrease.  The overall result increased by almost 50%.<\/p>\n<p>The usefulness of horizontal analysis has become clear, but yes, it cannot be done alone.  It must be completed with others such as the vertical or the ratios.  Ultimately, a company is a complex whole and for that reason it must be analyzed from various points of view.<\/p>\n<\/div>\n\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-center kksr-valign-bottom\"\n    data-payload='{&quot;align&quot;:&quot;center&quot;,&quot;id&quot;:&quot;597&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;bottom&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;0&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;0&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;4&quot;,&quot;greet&quot;:&quot;Rate this post&quot;,&quot;legend&quot;:&quot;0\\\/5 - (0 votes)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;Horizontal analysis&quot;,&quot;width&quot;:&quot;0&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 0px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            <span class=\"kksr-muted\">Rate this post<\/span>\n    <\/div>\n    <\/div>\n","protected":false},"excerpt":{"rendered":"<p>The horizontal analysis calculates the absolute and relative variation suffered by each&hellip;<\/p>\n","protected":false},"author":1,"featured_media":598,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-597","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-definition"],"_links":{"self":[{"href":"https:\/\/enorcerna.com\/wiki\/wp-json\/wp\/v2\/posts\/597","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/enorcerna.com\/wiki\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/enorcerna.com\/wiki\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/enorcerna.com\/wiki\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/enorcerna.com\/wiki\/wp-json\/wp\/v2\/comments?post=597"}],"version-history":[{"count":0,"href":"https:\/\/enorcerna.com\/wiki\/wp-json\/wp\/v2\/posts\/597\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/enorcerna.com\/wiki\/wp-json\/wp\/v2\/media\/598"}],"wp:attachment":[{"href":"https:\/\/enorcerna.com\/wiki\/wp-json\/wp\/v2\/media?parent=597"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/enorcerna.com\/wiki\/wp-json\/wp\/v2\/categories?post=597"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/enorcerna.com\/wiki\/wp-json\/wp\/v2\/tags?post=597"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}