• Accounting: ratio analysis in depth

What is horizontal and vertical analysis?

Written with AI (How we create content)Target level: Grade 12Last updated: Report an error
Quick answer

Horizontal and vertical analysis are two ways to read financial statements. Horizontal analysis compares each line with the same line in an earlier year, as a change in shekels and in percent. Vertical analysis shows each line as a percentage of a total in the same year: of sales in the income statement, of total assets in the balance sheet.

The topic explained

Two directions of reading

A set of statements is a table of numbers, and a table can be read in two directions. Horizontal and vertical analysis name them. Reading across, from one year to the next, shows what grew and what shrank. Reading down a single year, with every line as a share of one total, shows the shape of the business: how much of each shekel of sales is eaten by each cost.

A made-up furniture store sold ₪400,000 in year 1 and ₪500,000 in year 2. Its cost of sales rose from ₪240,000 to ₪320,000, its other expenses from ₪100,000 to ₪110,000 and its interest from ₪2,000 to ₪5,000, so net profit went from ₪58,000 to ₪65,000. Both kinds of analysis start from these six lines.

Table of the furniture store's income statement for two years with the change in shekels and in percent: sales up 25%, cost of sales up 33.3%, gross profit up 12.5%, expenses up 10%, interest up 150%, net profit up 12.1%.LineYear 1Year 2Change%Sales400,000500,000+100,000+25%Cost of sales240,000320,000+80,000+33.3%Gross profit160,000180,000+20,000+12.5%Expenses100,000110,000+10,000+10%Interest2,0005,000+3,000+150%Net profit58,00065,000+7,000+12.1%
Horizontal analysis: each line against the same line a year earlier.

Horizontal analysis: change from a base year

Horizontal analysis takes an earlier year as the base year and measures each line against it: the change in shekels, and the change divided by the base-year amount. Sales grew by ₪100,000, which is 100,000 ÷ 400,000 = 25%. Cost of sales grew by ₪80,000, or 33.3%, faster than sales; so gross profit grew by only 12.5%, and net profit by 12.1%.

The trap is the small line. Interest grew by 150%, the largest change in the table, yet it is ₪3,000 in a business that sold half a million. A percentage says how fast a line moved, not how much it matters, and from a base of zero it cannot be calculated at all. Read the shekel column beside the percent column before deciding what deserves attention.

Bar chart of the percentage change in four lines: sales 25%, gross profit 12.5%, expenses 10% and interest 150%, drawn to scale.+25%Sales+12.5%Gross profit+10%Expenses+150%Interest
The tallest bar belongs to the smallest line: interest grew by ₪3,000.

Vertical analysis: every line as a share

Vertical analysis sets one total at 100% and divides every line by it. In the income statement the base is sales; in the balance sheet it is total assets. Statements in this form are called common-size statements, because they let a small shop and a large chain be compared on the same scale.

For the furniture store, cost of sales was 60% of sales in year 1 and 64% in year 2, so gross profit fell from 40% of sales to 36%. Expenses fell from 25% to 22%, which saved part of the loss, and net profit ended at 13% of sales instead of 14.5%. Had cost of sales stayed at 60%, gross profit would have been ₪20,000 higher. The store sold more, but it kept less from each shekel: perhaps it cut prices, or its suppliers raised theirs.

Table of the same income statement as percentages of sales: cost of sales 60% then 64%, gross profit 40% then 36%, expenses 25% then 22%, interest 0.5% then 1%, net profit 14.5% then 13%.LineYear 1, %Year 2, %Sales100%100%Cost of sales60%64%Gross profit40%36%Expenses25%22%Interest0.5%1%Net profit14.5%13%
Vertical analysis: every line as a share of the year's sales.

Reading the two together

Each method answers a question the other cannot. Horizontal analysis alone says that profit grew by 12%, which sounds good; vertical analysis adds that the margin shrank. Vertical analysis alone says that interest is only 1% of sales; horizontal analysis adds that it more than doubled, which may point to new borrowing worth a closer look.

Two habits keep the analysis honest. Compare like with like: the same base for every year and, between companies, the same kind of business. And treat the numbers as questions, not verdicts. A change tells you where to look; the reason is in the notes, the market and the decisions behind the figures.

Free printable worksheet

Practice: horizontal and vertical analysis

For 12th grade accounting students. A made-up bookstore sold ₪200,000 in year 1 and ₪240,000 in year 2; cost of sales was ₪120,000 and ₪150,000; other expenses were ₪50,000 and ₪54,000. Round percentages to one decimal place. Check the answers at the end.

Free, no sign-up. The answer key prints on the second page. Regenerating a new worksheet on the same topic needs a free account.

Free printable worksheetlessoons.com
Practice: horizontal and vertical analysisName:
  1. In one sentence each, what do horizontal analysis and vertical analysis compare?

  2. Complete the horizontal analysis.

    Table of the bookstore's sales, cost of sales and gross profit for two years, with the change in shekels and in percent marked with question marks.LineYear 1Year 2Change%Sales200,000240,000??Cost of sales120,000150,000??Gross profit80,00090,000??
  3. Calculate the operating profit of each year and its change in percent.

  4. Complete the vertical analysis.

    Table of the bookstore's lines as a percentage of sales: sales 100% in both years, cost of sales and gross profit marked with question marks.LineYear 1, %Year 2, %Sales100%100%Cost of sales??Gross profit??
  5. Sales grew by 20% but gross profit by only 12.5%. Use your vertical analysis to explain why.

  6. Total assets at the end of year 2 are ₪500,000. Find each asset's share of the total.

    Bar chart of the bookstore's assets drawn to scale: inventory ₪100,000, customers ₪75,000 and fixed assets ₪325,000, out of total assets of ₪500,000.100,000Inventory75,000Customers325,000Fixed assets
  7. Other income rose from ₪1,000 to ₪4,000, a rise of 300%. A classmate calls it the most important change in the year. Is she right?

  8. A second bookstore sold ₪1,000,000 and made an operating profit of ₪120,000. Which store keeps more operating profit per shekel of sales in year 1?

More topics and worksheets at lessoons.com© 2026 Lessons

Common questions

What is the difference between horizontal and vertical analysis?

Horizontal analysis follows a line across several years and measures its change from a base year. Vertical analysis looks at one year and shows each line as a percentage of a total, such as sales or total assets.

What is a common-size income statement?

It is an income statement in which sales are set at 100% and every other line is shown as a percentage of sales, so statements of businesses of different sizes can be compared.

What base is used for a vertical analysis of the balance sheet?

Total assets, set at 100%. Each asset is shown as a share of total assets, and each liability and equity line as a share of the same total, since the two sides are equal.

How do you calculate a percentage change in horizontal analysis?

Subtract the base-year amount from the current amount and divide the difference by the base-year amount. A rise from ₪400,000 to ₪500,000 is 100,000 ÷ 400,000 = 25%.

Why can a large percentage change be misleading?

A line that starts small can double with a change of a few thousand shekels, while a large line that grows 5% may change by far more money. Always read the shekel change beside the percentage.

Still have a question? Ask Lessi

Any question about this subject. Lessi answers right here, step by step.

Try asking

Asking needs a free account; your question is kept while you sign up. Answers are written by AI and can contain mistakes. Lessi doesn’t give medical or legal advice.

Learn it with a teacher

Learn this topic live with Lessi

Lessi, the AI teacher, explains it out loud on a board, with short quizzes, at your pace. The first 60 minutes are free.