Skip to content
Study Hall
Lesson 3 of 6Financial Analysis and Decision Making
Unit 4 · Lesson 3 of 6

Horizontal and Vertical Analysis

Horizontal analysis measures how each item changed from a base year in dollars and percent, vertical analysis expresses each item as a percent of a base figure in the same year, and together they reveal liquidity, solvency and profitability trends that raw numbers hide.

6 min read9 practice questionsAsk AI about this →

Key things to remember

  1. 1Dollar change current year base year.
  2. 2Percent change ; divide by the base (earlier) year.
  3. 3Trend percentage the base year is 100%.
  4. 4Common-size income statement: every item as a percent of net sales.
  5. 5Common-size balance sheet: every item as a percent of total assets (which equals total liabilities and equity).
  6. 6Horizontal analysis compares years; vertical analysis compares items within one year and lets you compare companies of different sizes.

Maple Outdoor's net income rose by $22,500 this year. Is that a lot? For a corner store it would be huge; for a national chain it would be a rounding error. Raw dollar amounts are hard to judge on their own. Analysts fix this by turning numbers into percentages. Horizontal analysis asks how much each line changed compared with a base year. Vertical analysis asks how big each line is compared with a base total in the same year. Both work on comparative statements, which show two or more years side by side, and both let you compare a company with itself over time and with competitors of very different sizes.

Item2024Vertical %2025Vertical %Horiz. %Sales40,000100.0%50,000100.0%+25.0%Cost of Goods Sold24,00060.0%30,00060.0%+25.0%Gross Profit16,00040.0%20,00040.0%+25.0%Operating Expenses10,00025.0%12,00024.0%+20.0%Net Income6,00015.0%8,00016.0%+33.3%
Fig 1Horizontal analysis reads across the years; vertical analysis reads down a single year as a percent of a base.

Horizontal analysis: dollar and percent change

The base year is the earlier year, and the dollar change is simply current minus base. Always divide by the base year, never the current year. If the base year amount is zero or negative, a percent change cannot be meaningfully calculated, so analysts write n/m (not meaningful). Here is Maple Outdoor Ltd.'s comparative income statement with 2025 as the base year. Percentages are rounded to one decimal place.

Maple Outdoor Ltd.20262025Dollar changePercent change
Net sales$800,000$700,000$100,00014.3%
Cost of goods sold$480,000$434,000$46,00010.6%
Gross profit$320,000$266,000$54,00020.3%
Operating expenses$200,000$180,000$20,00011.1%
Operating income$120,000$86,000$34,00039.5%
Interest expense$20,000$16,000$4,00025.0%
Income before income tax$100,000$70,000$30,00042.9%
Income tax expense$25,000$17,500$7,50042.9%
Net income$75,000$52,500$22,50042.9%
Comparative income statement, years ended December 31, with horizontal analysis (base year 2025).

The story is in the comparison between lines. Sales grew 14.3% but cost of goods sold grew only 10.6%, so gross profit grew faster (20.3%): Maple is paying relatively less for what it sells, perhaps through better buying or higher prices. Operating expenses grew 11.1%, also slower than sales, so management is controlling costs. This combination, revenue growing faster than costs, is called operating leverage, and it is why net income grew three times as fast as sales.

Maple Outdoor Ltd.20262025Dollar changePercent change
Cash$40,000$30,000$10,00033.3%
Accounts receivable$80,000$70,000$10,00014.3%
Inventory$120,000$100,000$20,00020.0%
Prepaid expenses$10,000$12,000($2,000)(16.7%)
Total current assets$250,000$212,000$38,00017.9%
Property, plant and equipment (net)$450,000$388,000$62,00016.0%
Total assets$700,000$600,000$100,00016.7%
Accounts payable$90,000$80,000$10,00012.5%
Accrued liabilities$20,000$25,000($5,000)(20.0%)
Total current liabilities$110,000$105,000$5,0004.8%
Long-term debt$200,000$175,000$25,00014.3%
Total liabilities$310,000$280,000$30,00010.7%
Common shares$200,000$180,000$20,00011.1%
Retained earnings$190,000$140,000$50,00035.7%
Total shareholders' equity$390,000$320,000$70,00021.9%
Total liabilities and equity$700,000$600,000$100,00016.7%
Comparative balance sheet, December 31, with horizontal analysis. Brackets show decreases.
Watch inventory and receivables against sales
Inventory grew 20.0% while sales grew 14.3%. That is worth a question: is Maple stocking up for its two new stores (a good reason), or is merchandise not selling (a bad one)? Receivables grew 14.3%, exactly in step with sales, which suggests collections are keeping pace. Horizontal analysis does not answer these questions; it tells you which ones to ask.
VideoCalculates the dollar and percent change for each line between two years, always dividing by the base year.Watch on YouTube

Trend percentages over several years

When you have five or more years, compare every year with one fixed base year instead of with the year before. Each year's trend percentage is that year's amount divided by the base-year amount, times 100. The base year is always 100%.

Maple Outdoor Ltd.20222023202420252026
Net sales$560,000$600,000$650,000$700,000$800,000
Sales trend (2022 = 100%)100.0%107.1%116.1%125.0%142.9%
Net income$35,000$40,000$46,000$52,500$75,000
Net income trend (2022 = 100%)100.0%114.3%131.4%150.0%214.3%
Trend percentages from the multi-year highlights. Net income has grown much faster than sales.

Vertical analysis: common-size statements

Vertical analysis converts one year's statement into a common-size statement, where every line is a percent of a single base. On the income statement the base is net sales (100%); on the balance sheet the base is total assets (100%), which also equals total liabilities and equity. Because everything becomes a percent, a company with $800,000 of sales can be compared directly with one that has $80 million.

Maple Outdoor Ltd.2026% of net sales2025% of net sales
Net sales$800,000100.0%$700,000100.0%
Cost of goods sold$480,00060.0%$434,00062.0%
Gross profit$320,00040.0%$266,00038.0%
Operating expenses$200,00025.0%$180,00025.7%
Operating income$120,00015.0%$86,00012.3%
Interest expense$20,0002.5%$16,0002.3%
Income before income tax$100,00012.5%$70,00010.0%
Income tax expense$25,0003.1%$17,5002.5%
Net income$75,0009.4%$52,5007.5%
Common-size income statement. Each line is a percent of that year's net sales.
Maple Outdoor Ltd.2026% of total assets2025% of total assets
Cash$40,0005.7%$30,0005.0%
Accounts receivable$80,00011.4%$70,00011.7%
Inventory$120,00017.1%$100,00016.7%
Prepaid expenses$10,0001.4%$12,0002.0%
Total current assets$250,00035.7%$212,00035.3%
Property, plant and equipment (net)$450,00064.3%$388,00064.7%
Total assets$700,000100.0%$600,000100.0%
Total current liabilities$110,00015.7%$105,00017.5%
Long-term debt$200,00028.6%$175,00029.2%
Total liabilities$310,00044.3%$280,00046.7%
Common shares$200,00028.6%$180,00030.0%
Retained earnings$190,00027.1%$140,00023.3%
Total shareholders' equity$390,00055.7%$320,00053.3%
Total liabilities and equity$700,000100.0%$600,000100.0%
Common-size balance sheet. Each line is a percent of that year's total assets. Rounded lines may not add to exactly 100.0%.
VideoBuilds common-size statements, with each income statement line as a percentage of sales and each balance sheet line as a percentage of total assets.Watch on YouTube

Reading liquidity, solvency and profitability signals

  • Profitability: cost of goods sold fell from 62.0% to 60.0% of sales, so gross margin rose from 38.0% to 40.0%. Operating expenses fell from 25.7% to 25.0%. Net income rose from 7.5 cents to 9.4 cents per dollar of sales.
  • Liquidity: current liabilities shrank from 17.5% to 15.7% of total assets while current assets held steady at about 35%, so the company's short-term cushion improved.
  • Solvency: total liabilities fell from 46.7% to 44.3% of total assets, and equity rose from 53.3% to 55.7%. Even though Maple borrowed $25,000 more, it financed more of its growth from retained profits, so it is less dependent on creditors.
  • Interest grew 25.0% in dollars but barely moved as a percent of sales (2.3% to 2.5%), so the new borrowing is affordable.

Worked examples

Reveal one step at a time and try to beat it to the next line.

Example 1
Cedar Gear Inc.'s operating expenses were $200,000 in 2025 and $212,000 in 2026. Find the dollar change and the percent change to one decimal place, using 2025 as the base year.
Example 2
Cedar Gear Inc. reports 2026 net sales of $820,000, cost of goods sold of $533,000, operating expenses of $212,000, interest expense of $36,000 and net income of $29,250. Prepare the common-size percentages to one decimal place and compare Cedar Gear's cost structure with Maple's.
Example 3
Using Maple Outdoor's 2026 balance sheet, find the common-size percentage for inventory and for total liabilities to one decimal place, and explain what each tells you.

Where marks get lost

  • Dividing the change by the current year instead of the base year. A rise from $700,000 to $800,000 is 14.3%, not 12.5%.
  • Using total assets as the base for an income statement, or net sales for a balance sheet.
  • Calculating a percent change from a base of zero or a negative number. Write n/m (not meaningful) instead.
  • Assuming a large percent change is important. A 50% rise on a $2,000 item matters less than a 5% rise on a $500,000 item; look at the dollar change too.
  • Forcing rounded common-size percentages to total exactly 100.0%. Small rounding differences are normal and acceptable.

Flashcards 8

Horizontal analysis
Vertical analysis
Base for a common-size income statement
Base for a common-size balance sheet
+ 4 more

Practice

1
Accounts receivable rose from $64,000 to $72,000. What is the percent change? Answer to one decimal place.
%
2
A company's net sales are $450,000 and its gross profit is $171,000. On a common-size income statement, what percent is gross profit? Answer to one decimal place.
%
3
Inventory is $84,000 and total assets are $560,000. What percent of total assets is inventory? Answer to one decimal place.
%
4
Sales were $400,000 in the base year and $482,000 four years later. What is the trend percentage for the later year? Answer to one decimal place.
%
5
Which base is used for a common-size income statement?
6
Sales increased 8% while cost of goods sold increased 12%. What happened to the gross profit margin?
7
Total liabilities fell from 52.0% to 45.0% of total assets over two years. What does this suggest?
8
Match each analysis to what it compares.
Horizontal analysis
Vertical analysis
Trend percentages
Industry comparison
9
Prepaid expenses fell from $12,000 to $10,000. What is the percent change? Enter a decrease as a negative number, to one decimal place.
%

Spot a mistake on this page? Let us know