Vertical Analysis Calculator

Vertical analysis allows the comparison of financial statements by representing each line item on the statement as a percentage of another (base) line item.

The vertical analysis calculator allows for details of an income statement and a balance sheet to be entered, and calculates each line item as a percentage of the relevant base line item. The use of vertical analysis as a comparison tool is discussed more fully in our vertical analysis tutorial.

Formula for Vertical Analysis Calculator

For the income statement the vertical analysis calculator works out the percentage each line item is of total revenue. The vertical analysis formula used for each income statement line item is given by:

Line item % = Line item value / Revenue

For example, if the income statement has total revenue of 40,000, and shows operating expenses of 16,000, then operating expenses are 16,000/40,000 = 40.0% of total revenue

For the balance sheet, the vertical analysis calculator works out the percentage each line item is of total assets. The vertical analysis formula used for each balance sheet line item is given by:

Line item % = Line item value / Total assets

For example, if the balance sheet has total assets of 31,000, and shows inventory of 4,000, then inventory is 4,000/31,000 = 12.9% of total assets.

vertical analysis calculator v 1.0
Vertical Analysis Calculator Preview

Instructions

The Excel vertical analysis calculator, available for download below, is used to produce the vertical analysis by entering details from the income statement and balance sheet of the business. The calculator is used as follows:

Step 1

Enter the relevant accounting period, for example, Year 1, 2016, Month 1 etc.

Step 2

Enter the income statement information for the business. The information will be for the relevant accounting period, such as the year ending 2015, and will come from management information, published financial statements, or from industry standards used for comparisons.

The vertical analysis calculator calculates the percentage each income statement line item has to the revenue line.

Step 3

Enter the balance sheet information for the business. The balance sheet information will be as at the end of the accounting period, and again will come from management information, published financial statements, or from industry standards.

The vertical analysis calculator calculates the percentage each balance sheet line item has to the total assets line.

Vertical Analysis Calculator Download

The vertical analysis calculator spreadsheet is available for download in Excel format by following the link below.

The vertical analysis calculator is one of many financial calculators used in bookkeeping and accounting, discover another at the links below.

Notes and major health warnings
Users use this vertical analysis calculator at their own risk. We make no warranty or representation as to its accuracy and we are covered by the terms of our legal disclaimer, which you are deemed to have read. This is an example of an accounting tool that you might use when considering how to calculate vertical analysis. It is purely illustrative. This is not intended to reflect general standards or targets for any particular business, company or sector. If you do spot a mistake in this vertical analysis excel calculator, please let us know and we will try to fix it.
Vertical Analysis Calculator November 6th, 2016Team

You May Also Like


Related pages


stockholders equity equationimportance of suspense accountasset turnover calculationcurrent asset turnover ratio formulaaccounting worksheet templatewhat is fob in accountingmarkup sheethow to calculate cash discounteffective monthly rate calculatorquick assets ratio formulaexample of process costingdebtors and creditors ledgerexcel calculate irrdeferred revenue purchase accountinghow to amortize intangible assetsballoon payment excelperpetual annuitypv pmt formulaexcel margin formulaaccounts receivable process flow diagramprofitabilty indexprepayment accounting entrydisposal of fixed assets double entryhow to calculate arraccounting debit credit cheat sheetjob costing spreadsheetnet profit sales ratiogross margin vs markup calculatorrecording adjusting entrieshow to calculate ear on financial calculatorstandard costing systempayroll general ledger entrieshow to calculate receivable turnoverhow to record dividends payableaccounting worksheets for highschool studentsvertical analysis calculatorreceivable turnover calculatoracquisition accounting journal entriesbookkeeping for dummies pdfaccounts receivable contra accountfinancial forecast templatehow to calculate trade discounthow to find variable cost formulanotes receivable assetpetty cash book template free downloadnpv formula exceldouble declining balance methodpmt on excelrevenue projection templatejournal entry of outstanding expenseswhat is factoring in accountingincome ledger templateabsorption rate calculatortrial balance excel templatewhat is accounting equationdeferred expenses definitionexample of operating leverageretained earnings statement formatbookkeeping formulasuspense in accountingaccounting debit and creditstrial balance vs general ledgerhow to do adjusting journal entriesperpetual inventory income statementhighly geared businessaccounts receivable ratio formulahow to calculate payback period on financial calculatorgross profit ratio equationgarnishee definitionhow to calculate work in process inventory endinginternal controls accounts receivableannualization calculatorfinance quizzes with answerscredit sales vs accounts receivableinventory turnover ratio formulaperpetuity growthaccrued revenue in balance sheethow to compute profitability index