- Accounting: ratio analysis in depth
What is horizontal and vertical analysis?
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.
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.
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.
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.
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.
In one sentence each, what do horizontal analysis and vertical analysis compare?
Complete the horizontal analysis.
Calculate the operating profit of each year and its change in percent.
Complete the vertical analysis.
Sales grew by 20% but gross profit by only 12.5%. Use your vertical analysis to explain why.
Total assets at the end of year 2 are ₪500,000. Find each asset's share of the total.
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?
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?
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.