Vertical Analysis and Horizontal Analysis: the Difference, With Examples

Vertical analysis expresses every line on a financial statement as a percentage of one base number in the same period: revenue on the income statement, total assets on the balance sheet. Horizontal analysis takes a single line and compares it across periods, reporting the change in dollars and in percent. The difference in one sentence: vertical analysis tells you the shape of the business right now, and horizontal analysis tells you what is changing.

Both are elementary arithmetic, both take about twenty minutes in a spreadsheet, and most owners still never run them. Between them they catch nearly every problem a small company gets into: cost creep, overhead outrunning revenue, a receivables balance quietly doubling.

What is vertical analysis?

Vertical analysis restates each line item as a percentage of a base figure from the same statement and the same period. On the P&L, the base is total revenue, which is set to 100 percent. On the balance sheet, the base is total assets. The result is a picture of composition: how each dollar of revenue is spent, or how each dollar of assets is financed.

Vertical analysis formula: (line item / base figure) x 100.

• Income statement: (line item / total revenue) x 100. COGS of $192,000 on revenue of $480,000 is 40.0 percent.
• Balance sheet: (line item / total assets) x 100. Inventory of $90,000 against total assets of $600,000 is 15.0 percent.
• Cash flow statement: usually each line as a percent of total cash inflows, though it is the least common of the three.

The reason it is called vertical: you read down a single column, and nothing about time enters the calculation. A vertical analysis of one month is complete on its own, which is why it is the fastest sanity check on a set of books you have never seen.

How do you calculate vertical analysis? (worked example)

Take one month of a services business. Divide every line by revenue and multiply by 100. Here is the full common-size P&L (illustrative example figures):

Line item	Amount	Percent of revenue
Revenue	$480,000	100.0%
Cost of goods sold	$192,000	40.0%
Gross profit	$288,000	60.0%
Payroll (non-delivery)	$144,000	30.0%
Sales and marketing	$48,000	10.0%
Rent and facilities	$24,000	5.0%
Software and tools	$14,400	3.0%
Total operating expenses	$230,400	48.0%
Operating income	$57,600	12.0%
Interest expense	$4,800	1.0%
Net income	$52,800	11.0%

Read it as a sentence: of every revenue dollar, 40 cents goes to delivery, 30 cents to overhead payroll, 10 cents to acquiring the next customer, 8 cents to rent and software, 1 cent to the bank, and 11 cents stays. Now you can argue about whether 10 percent on sales and marketing is too little. That argument is impossible to have in raw dollars.

What is horizontal analysis?

Horizontal analysis compares the same line item across two or more periods and reports the movement in dollars and in percent. It is also called trend analysis, because when you extend it across five or ten periods, the column of percentages is the trend. You pick a base period, and every later period is measured against it.

Horizontal analysis formula: dollar change = current period amount minus base period amount. Percent change = (dollar change / base period amount) x 100.

Revenue of $4,600,000 this year against $4,000,000 last year is a dollar change of $600,000 and a percent change of ($600,000 / $4,000,000) x 100 = 15.0 percent. Two conventions trip people up. The denominator is always the base (earlier) period, not the current one. And if the base figure is negative or near zero, the percent change is meaningless: show the dollar change only.

Horizontal analysis example: what a 15 percent revenue year actually did

Same business, two full years side by side (illustrative example figures):

Line item	Prior year	Current year	Change ($)	Change (%)
Revenue	$4,000,000	$4,600,000	+$600,000	+15.0%
Cost of goods sold	$1,600,000	$1,920,000	+$320,000	+20.0%
Gross profit	$2,400,000	$2,680,000	+$280,000	+11.7%
Payroll (non-delivery)	$1,200,000	$1,410,000	+$210,000	+17.5%
Sales and marketing	$400,000	$520,000	+$120,000	+30.0%
Rent and facilities	$200,000	$200,000	$0	0.0%
Total operating expenses	$1,800,000	$2,130,000	+$330,000	+18.3%
Operating income	$600,000	$550,000	-$50,000	-8.3%

Revenue grew 15 percent and operating income fell 8.3 percent. The two lines that did it are visible immediately: COGS grew 20 percent, faster than the revenue it supported, so gross profit only grew 11.7 percent; and sales and marketing grew 30 percent, double the revenue growth rate. Rent held flat, the one line quietly working in your favor. The rule to carry around: any expense line growing faster than revenue is compressing your margin.

What is the difference between vertical and horizontal analysis?

Vertical analysis works down a column within one period and shows composition (each line as a percent of a base). Horizontal analysis works across columns between periods and shows change (each line's dollar and percent movement). Vertical answers "what does this business look like." Horizontal answers "what is moving, and how fast." Neither substitutes for the other.

• Use vertical when you want to judge structure, compare yourself to a competitor or an industry benchmark, or hand a stranger (a lender, a buyer, a new CFO) a one-page read on how the company works.
• Use horizontal when you want to find what changed, build a forecast off real growth rates, or explain a result to a board.
• Use both when you are doing real financial statement analysis, which is to say always. Run vertical first to learn the shape, then horizontal to see which parts of that shape are moving.

What are common size financial statements?

A common-size financial statement is the output of vertical analysis: the whole statement restated in percentages, with revenue (or total assets) as 100 percent. The point is size neutrality. A $2M shop and a $200M company cannot be compared in dollars, but they can be compared line for line once both are in percent.

That is what makes benchmarking possible. If your gross margin is 60 percent and a comparable firm runs 68 percent, the eight-point gap is worth eight cents of every revenue dollar, and now you have something specific to go find: pricing, delivery labor, or discounting. The same trick works on the balance sheet, where inventory at 15 percent of total assets versus 6 percent for a peer says your cash is sitting in a warehouse. It is also how you compare your own company to itself after it doubles: in dollars, everything is bigger and nothing is comparable; in percent, the structure either held or it did not.

What does vertical analysis miss that horizontal catches?

Direction. Vertical analysis of a single period is blind to whether the business is growing or dying, and a stable percentage can hide a collapse. Consider two months (illustrative example): revenue $400,000 with COGS of $160,000, and six months later revenue $300,000 with COGS of $120,000. In both months COGS is exactly 40.0 percent of revenue and gross margin is exactly 60.0 percent. The vertical view is identical, and cost discipline looks perfect, because it is.

Horizontal analysis on the same two months: revenue down $100,000, a 25.0 percent decline. Gross profit down from $240,000 to $180,000, also 25.0 percent. Nothing is wrong with the cost structure. What is wrong is the top line, and if fixed overhead is $168,000 in both months, operating income has gone from $72,000 to $12,000 while every ratio on the cost side stayed obediently in range.

It runs the other way too. Horizontal analysis alone tells you payroll rose 17.5 percent without telling you payroll is 30 percent of revenue, which is the number that decides whether 17.5 percent is a problem. Percent change without composition is a rate with no context; composition without percent change is a snapshot with no direction. Ratios sit on top of both, and the ones that earn their keep are covered in the financial ratios small business owners should track.

How to run both on your own numbers

The mechanics are trivial once the data is clean, and "clean" is the whole job.

• Start from closed books. Both analyses inherit every error in the ledger. Unrecorded payables make your expense percentages look great and your current ratio look better.
• Get the raw data into rows and columns. If your starting point is a stack of PDF bank statements rather than a clean accounting export, get them into a spreadsheet first, because neither analysis works on a PDF.
• Build vertical first. One column of amounts, one column of percent-of-revenue (or percent-of-total-assets). Freeze the base cell so every row divides by the same denominator.
• Add horizontal columns. Prior period, dollar change, percent change. Compare month to same month last year rather than to last month if your business has any seasonality at all.
• Write one sentence per material move. Any line moving more than 10 percent, or any percent-of-revenue moving more than 2 points, gets an explanation in words. If you cannot write the sentence, you have found the thing to investigate.

Mistakes that make both analyses lie

• Comparing a partial period to a full one. A three-week month against a full one shows a "decline" that is a calendar artifact. Same for a 13-week quarter against a 14-week one.
• Ignoring seasonality. A landscaper comparing February to December will conclude the business is collapsing. Year over year, same month, is the honest comparison for seasonal businesses.
• Reading a percent change off a tiny base. A line that went from $200 to $800 is up 300 percent and means nothing. Sort your horizontal analysis by dollar change, not percent change, and set a materiality floor.
• Changing the chart of accounts mid-year. Move a cost from COGS to opex in July and your gross margin "improves" in a way no operational change caused. If you must reclassify, restate the prior periods too, or every comparison after that date is fiction.
• Picking a weird base year. If the base period was an outlier (a one-time contract, a shock quarter), every percent change measured against it is distorted. Say so, or pick a different base.

Is horizontal analysis the same as trend analysis?

Effectively yes, with a scope difference. Horizontal analysis usually means two periods compared line by line. Trend analysis means the same technique extended across many periods, often indexed to a base year set to 100, so you can see the slope rather than a single jump. Same formula, longer runway.

Getting both views without rebuilding the spreadsheet every month

The analysis is easy. Doing it every month, from freshly closed books, without the spreadsheet quietly breaking, is what people actually fail at. AIStatements is a financial statement generator: upload an accounting export or connect QuickBooks or Xero, and in about 60 seconds you get a formatted statement pack (P&L, balance sheet, cash flow) with comparative periods, computed ratios, and AI financial analysis in plain English, with red flags pinned to the exact statement lines they come from: margin slips, expense lines outgrowing revenue, DSO creep. The figures are deterministic, computed straight from the ledger; the AI writes only the narrative and cites the numbers. The vertical and horizontal views come off the income statement and balance sheet by default instead of being rebuilt by hand.

One honest boundary: this is software that formats and analyzes your data. It is not accounting, audit, tax or investment advice, and it does not certify GAAP or IFRS compliance, so have a professional review anything you file or send to a lender. What it does do is put the two most useful analyses in finance in front of you every month instead of on the someday list.