Accounting › Section O · Cash flows and statement analysis › Topic O.5

Horizontal and vertical analysis

A set of financial statements is a wall of numbers until you compare them with something. Horizontal analysis compares each line with earlier years; vertical analysis compares each line with a total in the same year. Together they are the first tools an analyst reaches for.

Why analyse financial statements

Investors, lenders, suppliers, managers and regulators all read financial statements to answer four questions. Is the company profitable? Is it liquid, able to pay bills due soon? Is it solvent, able to meet its long-term debts? Is it efficient in using its assets? Raw dollar amounts rarely answer these on their own: a $40,000 rise in expenses is alarming for a corner shop and trivial for a national chain. Analysis turns amounts into comparisons, against the company's own past, against competitors and against industry averages, so that changes and outliers stand out.

Three tools

Three tools do most of the work. Horizontal analysis compares the same line item across periods to reveal growth and trends. Vertical analysis expresses each line item as a percentage of a total in the same statement to reveal structure. Ratio analysis relates one item to another, such as current assets to current liabilities, and is the subject of An overview of financial ratios. The tools work best together, and each depends on reliable statements prepared on the same basis from year to year.

Horizontal analysis

Horizontal analysis, also called trend analysis, sets an earlier period as the base and measures the change to the period being analysed. The dollar change is the current amount minus the base amount, and

\text{\% change} = \frac{\text{Current} - \text{Base}}{\text{Base}} \times 100

If net sales rose from $800,000 to $920,000, the dollar change is $120,000 and the percentage change is 15%. Always divide by the base-year amount, never the current one. When the base amount is zero or negative, a percentage change has no sensible meaning, so report the dollar change instead.

Comparing rates of change

The power of horizontal analysis lies in comparing growth rates between related lines. If sales grow 15% but cost of goods sold grows 23%, each sales dollar now costs more to deliver, and gross margin is being squeezed. If receivables grow far faster than sales, customers may be paying more slowly. If operating expenses grow more slowly than sales, the business is gaining scale. A single percentage change says little; two that should move together but do not are a prompt to investigate.

Trend percentages

Over three or more years, analysts often use trend percentages. Choose a base year, set each line to 100% in that year, and express every later year as a percentage of the base:

\text{Trend \%} = \frac{\text{Year amount}}{\text{Base amount}} \times 100

A trend of 100%, 110%, 125%, 144% shows growth that is speeding up, not just continuing. Trend percentages help separate lasting patterns from one-off jumps, but they are only as good as the base year: an unusually weak base makes every later year look impressive.

Vertical analysis

Vertical analysis, also called common-size analysis, expresses every line as a percentage of a base figure in the same statement. On the income statement the base is net sales, set to 100%. On the balance sheet the base is total assets for the asset side and total liabilities and equity, the same amount, for the other side. If cost of goods sold is 60% of net sales, then 40 cents of every sales dollar remains as gross profit to cover operating expenses and leave a profit.

Common-size comparisons and benchmarks

Because common-size figures remove the effect of size, they let you compare a small firm with a giant one, or a company with an industry average. Does each spend a similar share of sales on marketing? Does each hold a similar share of assets as inventory? Benchmarks must be sensible ones, though. Grocery chains typically earn net margins of a few cents per sales dollar, while many software companies earn far more, so a 3% margin can be healthy in one industry and dismal in another. Compare like with like.

Worked example: Larkspur Outfitters' income statement

Larkspur's net sales rose from $800,000 to $920,000. Cost of goods sold went from $480,000 to $588,800 and operating expenses from $224,000 to $239,200. 1. Gross profit: $320,000, then $331,200; operating income: $96,000, then $92,000. 2. Horizontal: sales +15.0%, cost of goods sold +22.7%, gross profit +3.5%, operating expenses +6.8%, operating income −4.2%. 3. Vertical:

\begin{array}{lrr} & \text{Yr 1} & \text{Yr 2} \\ \hline \text{Net sales} & 100\% & 100\% \\ \text{COGS} & 60\% & 64\% \\ \text{Gross profit} & 40\% & 36\% \\ \text{Op. expenses} & 28\% & 26\% \\ \text{Op. income} & 12\% & 10\% \end{array}

4. Interpret: sales grew strongly, but a 4-point rise in cost of goods sold, perhaps from higher supplier prices or discounting, outweighed tighter expense control.

Worked example: trends and a common-size balance sheet

Larkspur's net sales over four years were $640,000, $704,000, $800,000 and $920,000. 1. Base year 1 = 100%. 2. Year 2: \(704{,}000 \div 640{,}000 = 110\%\). 3. Year 3: 125%. 4. Year 4: \(920{,}000 \div 640{,}000 = 143.75\%\), about 144%. Growth is accelerating: +10, +15 and then +19 percentage points. Its year-end assets were cash $45,000, receivables $90,000, inventory $150,000 and equipment $315,000, totalling $600,000. 5. Common-size: cash 7.5%, receivables 15%, inventory 25%, equipment 52.5%, summing to 100%. A quarter of assets sits in inventory, worth comparing with competitors.

Common mistakes to avoid

First, dividing a change by the current year instead of the base year. Second, quoting a percentage change from a zero or negative base. Third, using the wrong base in vertical analysis: net sales for the income statement, total assets for the balance sheet. Fourth, confusing a change in percentage points with a percentage change: cost of goods sold rising from 60% to 64% of sales is a 4-point rise. Fifth, judging a figure without a benchmark. The topic Strengths and limits of statement analysis explains why even good comparisons need care.

Key takeaways

Statement analysis judges profitability, liquidity, solvency and efficiency by comparison. Horizontal analysis computes dollar and percentage changes from a base period, and trend percentages index several years to a base year of 100%. Vertical analysis expresses each item as a percentage of net sales on the income statement or of total assets on the balance sheet. Common-size statements make companies of different sizes comparable. Benchmarks are the company's past, its competitors and its industry, and norms differ widely between industries.

Flashcards

Flashcard

Four questions

Profitability, liquidity, solvency, efficiency

What statement analysis judges.

Test your understanding

Question 1 of 5

Revenue grew from $480,000 last year to $552,000 this year. What is the percentage increase?

Question 2 of 5

Net sales are $600,000 and cost of goods sold is $330,000. In a common-size income statement, what percentage is cost of goods sold?

Question 3 of 5

Sales were $250,000 in the base year and $340,000 four years later. What is the trend percentage for the later year?

Question 4 of 5

In vertical analysis of a balance sheet, which figure is normally set at 100%?

Question 5 of 5

Net sales rose 10% while cost of goods sold rose 16%. What happened to gross profit as a percentage of sales?

← Previous topicNext topic →