How Do You Do A Vertical Analysis? | Step-by-Step Guide

Understanding financial statements often requires more than just looking at raw dollar amounts. You need context to see the full picture. Learning how do you do a vertical analysis allows you to convert confusing numbers into clear percentages. This makes it easier to spot trends, control costs, and compare businesses of different sizes side-by-side.

This method transforms a standard balance sheet or income statement into a “common-size” statement. Investors, accountants, and students use this technique to gauge performance without getting distracted by the sheer scale of the numbers. It simplifies the relationship between different accounts for better decision-making.

What Is Vertical Analysis In Accounting?

Vertical analysis is a proportional analysis of a financial statement. Each line item is listed as a percentage of a specific base figure within that same statement. This creates a vertical column of percentages next to your standard currency amounts.

The term “vertical” comes from the way you read the numbers. You look up and down the column to see how individual components relate to the whole for a single reporting period. This differs from horizontal analysis, which looks across multiple periods to track growth.

Primary goal: The main objective is to establish the relative weight of each account. For instance, knowing you spent $50,000 on marketing means little on its own. Knowing that marketing consumes 15% of your total revenue provides actionable insight. It helps you determine if your spending aligns with your budget or industry standards.

The Importance Of Doing Vertical Analysis

Students and professionals use this method to normalize data. When you remove currency symbols and scale, you can compare a small local business with a massive multinational corporation. This is impossible with raw numbers alone.

Spotting internal trends: You might notice that while your total profit increased, your cost of goods sold (COGS) rose from 30% to 40% of revenue. This signals an efficiency problem that higher sales figures might hide. The percentage exposes the leak in your profit margin immediately.

Benchmarking competitors: Comparing your business to industry averages works best with percentages. If the industry average for rent is 5% of revenue and you pay 10%, you instantly know where to focus your cost-cutting efforts. This level of clarity helps in academic studies and real-world financial planning.

How To Perform A Vertical Analysis Calculation

The math behind this analysis is straightforward. You do not need advanced calculus, just simple division and multiplication. The formula remains consistent regardless of the statement you analyze, but the “base figure” changes depending on the document.

The Core Formula

Vertical Analysis % = (Specific Line Item / Base Figure) x 100

You apply this formula to every single item on the list. The base figure will always equal 100%. Every other item will be a percentage smaller than 100%.

Choosing The Correct Base Number

Selecting the right denominator is vital for accuracy. If you pick the wrong base, your ratios will not make sense to anyone reviewing the work.

• Income Statement: Use Net Sales or Total Revenue as the base. All expenses and profit margins are calculated as a percentage of revenue.
• Balance Sheet: Use Total Assets as the base for asset accounts. Use Total Liabilities and Equity (which equals Total Assets) as the base for liability and equity accounts.
• Cash Flow Statement: Use Total Cash Inflows or Net Sales as the base, though this is less common than the other two statements.

Step-by-Step Guide To Conducting A Vertical Analysis

Follow this logical process to convert any standard financial report into a common-size statement. This workflow applies whether you use Excel, Google Sheets, or a calculator.

1. Gather the financial statements — Collect the Income Statement or Balance Sheet for the period you want to analyze. Ensure the data is accurate and audited if possible.

2. Set up your columns — Create a new column to the right of the dollar amounts. Label this column “Percent of Base” or “Common-Size %”.

3. Identify the base figure — Locate Total Revenue (for income statements) or Total Assets (for balance sheets). This number represents 100% of the value.

4. Calculate the ratios — Divide the first line item by the base figure. Multiply by 100 to get the percentage. Repeat this for every single line item in the column.

5. Verify the total — Add up your component percentages. Due to rounding, they might sum to 99.9% or 100.1%, but they should virtually equal 100%. If they do not, check your math.

Example Of Vertical Analysis On An Income Statement

Let’s look at a practical example. Suppose a company named “EduHelp Corp” has the following figures for the year 2025. We will determine how do you do a vertical analysis on their simplified income statement.

Raw Data

• Total Revenue: $200,000
• Cost of Goods Sold (COGS): $80,000
• Gross Profit: $120,000
• Operating Expenses: $50,000
• Net Income: $70,000

The Calculation

Here, Total Revenue ($200,000) is the base. It represents 100%.

• COGS %: ($80,000 / $200,000) x 100 = 40%
• Gross Profit %: ($120,000 / $200,000) x 100 = 60%
• Operating Expenses %: ($50,000 / $200,000) x 100 = 25%
• Net Income %: ($70,000 / $200,000) x 100 = 35%

The Analysis

This tells us that for every dollar EduHelp Corp earns, 40 cents goes to producing the product, 25 cents covers operations, and 35 cents remains as profit. If next year the COGS rises to 45%, management knows immediately that production costs are eating into margins, even if total revenue grows.

Performing Vertical Analysis On A Balance Sheet

The balance sheet requires a slightly different approach because you deal with assets, liabilities, and equity. The logic remains the same: knowing the composition of your assets helps manage risk.

Asset Side: Total Assets is the base (100%).
If “Cash” is $20,000 and “Total Assets” is $100,000, then Cash is 20%. A high percentage here suggests strong liquidity but perhaps poor investment of idle funds. A low percentage might signal liquidity risk.

Liability Side: Total Liabilities and Shareholders’ Equity is the base (100%).
If “Long-Term Debt” is $50,000 and the base is $100,000, then debt finances 50% of the company. This ratio (Debt-to-Asset ratio) is critical for creditors. A vertical analysis makes these structural risks visible at a glance.

Interpreting The Results Of Your Vertical Analysis

Calculating the numbers is only the first step. The real value comes from reading the story those percentages tell. You must look for anomalies and patterns that raw numbers obscure.

Compare Against History

Run a vertical analysis for the last three years side-by-side. If “Salaries” were 15% of revenue in Year 1, 18% in Year 2, and 22% in Year 3, you have a trend. The salary cost is growing faster than revenue. This is an unsustainable path that management must address. Horizontal analysis shows the dollar change, but vertical analysis shows the burden on revenue.

Compare Against Competitors

Imagine Compary A has $1 million in revenue and Company B has $100 million. You cannot compare their marketing budgets in dollars. However, if Company A spends 10% on marketing and Company B spends 20%, you can ask why. Is Company B more aggressive? Does Company A rely on organic growth? These percentages level the playing field for analysis.

Common Mistakes When You Do A Vertical Analysis

Even though the math is simple, students and beginners often trip up on specific details. Avoid these errors to ensure your report is credible.

Using the wrong base: This is the most frequent error. On an income statement, never use “Net Income” as the base. Always use “Total Revenue” or “Net Sales.” Using Net Income makes the math messy and the ratios meaningless for standard comparison.

Ignoring negative numbers: Sometimes, a Net Income line might be negative (a loss). The vertical analysis still applies. If you lost $10,000 on $100,000 revenue, your Net Income is -10%. Do not ignore the sign; it accurately reflects the loss margin.

Overlooking categorization: Grouping expenses incorrectly skews the percentages. If you bury “Rent” inside “Miscellaneous Expenses,” you lose visibility. Ensure your line items are granular enough to provide insight but grouped enough to remain readable.

Tools To Automate Vertical Analysis

While you can calculate this manually, modern tools speed up the process. Most accounting software includes common-size reports as a standard feature.

Spreadsheets (Excel/Google Sheets): These are the best tools for students and analysts. You can set up a formula once and drag it down the entire column. This creates a dynamic template where you can paste new data and get instant analysis.

Accounting Software (QuickBooks/Xero): Look for “Common-Size Balance Sheet” in the reports section. These platforms automate the categorization and calculation, saving time during tax season or quarterly reviews.

Key Takeaways: How Do You Do A Vertical Analysis?

➤ Vertical analysis divides each line item by a base figure like Revenue or Assets.

➤ It converts raw dollars into percentages for easier comparison.

➤ This method is ideal for comparing companies of vastly different sizes.

➤ Use Total Revenue as the base for Income Statements (100%).

➤ Use Total Assets as the base for Balance Sheets (100%).

Frequently Asked Questions

What is the difference between vertical and horizontal analysis?

Vertical analysis looks at one specific period and measures items as a percentage of a base figure (top-to-bottom). Horizontal analysis compares financial data across multiple time periods (left-to-right) to identify growth trends, percentage increases, or decreases over years or quarters.

Can I do vertical analysis on a cash flow statement?

Yes, you can. Typically, analysts use Total Cash Inflows or Net Sales as the base figure. However, this is less standard than income sheet analysis because cash flow categories vary more widely between companies, making industry benchmarking harder.

Why is it called a “common-size” statement?

It is called common-size because it reduces all financial figures to a “common” denominator (percentages). This puts all companies on the same scale, regardless of their actual size, allowing a small startup to be directly compared to a giant corporation.

Does vertical analysis work for personal finance?

Absolutely. You can use your monthly income as the base (100%). Then, calculate what percentage of your income goes to rent, food, and savings. This reveals if you are overspending in one category relative to your total earnings.

Is vertical analysis useful for internal management?

Yes, managers use it to control budgets. If the vertical analysis shows that “Travel Expenses” jumped from 2% to 5% of revenue without a strategic reason, management can implement stricter travel policies to protect the profit margin.

Wrapping It Up – How Do You Do A Vertical Analysis?

Mastering how do you do a vertical analysis provides a powerful lens for viewing financial health. It strips away the confusion of large numbers and reveals the structural relationship between revenue, expenses, assets, and liabilities. Whether you are a student preparing for an exam or a business owner trying to widen profit margins, this tool offers the clarity needed to make informed choices.

By consistently applying this method, you move beyond simple bookkeeping. You start to see the operational efficiency of a business and can spot risks before they become critical issues. Start with a simple income statement, identify your revenue base, and calculate the percentages to unlock a deeper understanding of the numbers.