Financial Terms “V”

Financial Terms Dictionary


Vertical analysis

Vertical analysis is a technique that examines the components of a number. It is shown as a percentage. For example, on the income statement, sales is 100% and everything is deducted from sales.

On the balance sheet, total assets are 100% and all the assets are components of that number. Vertical analysis is also called common-size analysis.


VLOOKUP is an Excel function that retrieves data from a specific column in a table in Excel. VLOOKUP supports approximate and exact matching, and wildcards (* ?) for partial matches.

The “V” stands for “vertical”. Lookup values must appear in the first column of the table, with lookup columns to the right.

Jeff Mankin

Jeff Mankin teaches financial literacy. His website is

Recent Posts