Download the practice file by clicking on the link below if you would like to practice along with me.
Note: If you would like to learn in detail, how to calculate sales variances and the impact they have on sales $, profit $ and profit margin %, and how to explain performance vs budget and prior periods, click here for a detailed video course (at a special price for readers of this post) showing exactly how this is done. You will also learn how to analyse and present the results of the variances to management and will be able to download solved variance calculation Excel templates.
In this video, I explain vertical analysis of income statement (in Excel) by comparing the real income statements of Coca Cola and Pepsi.
What is vertical income statement analysis?
Vertical analysis is a top to bottom analysis of income statement where amounts for all line items in the income statement are converted to a percentage of a base amount (usually total revenue or Net Sales). This analysis is done to see the relative size of each type of income or expense with respect to the revenue (base).
When is Vertical Analysis used?
Vertical analysis of income statement can be used when trying to understand the size and significance of the components of income statement (hence reflected in percentage), and also to compare financial statements of difference companies either in the same or different industries, which may or may not be of similar size or revenue base. Converting amounts into percentage gives a particularly good idea for comparison, as you will see in the video above. Although Pepsi’s total revenue is more than double Coca Cola’s revenue, you can still compare the two income statements and analyze them to make informed decisions.
Vertical Analysis vs Horizontal Analysis
While vertical analysis looks at the components of income statements and their relative size, horizontal analysis looks at changes in the financial statements over a period of time. It is usually reflected in terms of year over year growth or decline.
Course: If you would like to learn in detail, how to calculate sales variances and the impact they have on sales $, profit $ and profit margin %, and how to explain performance vs budget and prior periods, click on the link for a detailed video course (at a special price). You will also learn how to analyse and present the results of the variances to management and will be able to download solved variance calculation Excel templates. https://www.udemy.com/course/learn-financial-analysis-of-variances-in-profit-and-sales/?couponCode=YOUTUBE10
Hope you find the information in the video helpful. If you like to watch more videos in accounting, financial analysis and controller ship, videos that help you directly in doing your job, subscribe to my channel. If you liked the video, I would love if you could LIKE it and leave a comment. If you have any questions or feedback, again leave a comment. Lets stay connected at #learnaccountingfinance.