CFI Jeff Schmidt - Analysis of Financial Statements
CFI Jeff Schmidt - Analysis of Financial Statements
CFI Jeff Schmidt - Analysis of Financial Statements
This guide is designed to be useful for both beginners and advanced finance professionals, with the
main topics covering: (1) the income statement, (2) the balance sheet, (3) the cash flow statement,
and (4) rates of return.
In order to answer these questions, and much more, we will dive into the income statement to get
started.
There are two main types of analysis we will perform: vertical analysis and horizontal analysis.
Vertical Analysis
With this method of analysis, we will look up and down the income statement (hence, “vertical”
analysis) to see how every line item compares to revenue, as a percentage.
For example, in the income statement shown below, we have the total dollar amounts and the
percentages, which make up the vertical analysis.
As you see in the above example, we do a thorough analysis of the income statement by seeing each
line item as a proportion of revenue.
To learn how to perform this analysis step-by-step, please check out our Financial Analysis
Fundamentals Course.
Key Highlights
One of the main tasks of a financial analyst is to perform an extensive analysis of a
company’s financial statements. This usually begins with the income statement but also
includes the balance sheet and cash flow statement.
This analysis can then be used to forecast a company’s financial statements into the
future.
Horizontal Analysis
Now it’s time to look at a different way to evaluate the income statement. With horizontal
analysis, we look at the year-over-year (YoY) change in each line item.
In order to perform this exercise, you need to take the value in Period N and divide it by the
value in Period N-1 and then subtract 1 from that number to get the percent change.
For the below example, revenue in Year 3 was $55,749, and in Year 2, it was $53,494. The
YoY change in revenue is equal to $55,749 / $53,494 minus one, which equals 4.2%.
To see exactly how to perform this horizontal analysis of financial statements, please enroll in
our Financial Analysis Fundamentals Course now!
Quick ratio
Current ratio
Debt to equity
Debt to capital
Debt to EBITDA
Interest coverage
Inventory turnover
Using the above financial ratios, we can determine how efficiently a company is generating revenue
and how quickly it’s selling inventory.
Using the financial ratios derived from the balance sheet and comparing them historically versus
industry averages or competitors will help you assess the solvency and leverage of a business.
In our course on Analysis of Financial Statements, we explore all the above metrics and ratios in
great detail.
The cash flow statement, or statement of cash flow, consists of three components:
Each of these three sections tells us a unique and important part of the company’s sources and uses
of cash over a specific time period.
Many investors consider the cash flow statement the most important indicator of a company’s
performance.
Today, investors quickly flip to this section to see if the company is actually making money or not
and what its funding requirements are.
It’s important to understand how different ratios can be used to properly assess the operation of an
organization from a cash management standpoint.
Below is an example of the cash flow statement and its three main components. Linking the 3
statements together in Excel is the building block of financial modeling. To learn more, please see
our online courses to learn the process step by step.
4. Rates of Return and Profitability Analysis
In this part of our analysis of financial statements, we unlock the drivers of financial performance. By
using a “pyramid” of ratios, we are able to demonstrate how you can determine the profitability,
efficiency, and leverage drivers for any business.
This is the most advanced section of our financial analysis course, and we recommend that you
watch a demonstration of how professionals perform this analysis.
The course includes a hands-on case study and Excel templates that can be used to calculate
individual ratios and a pyramid of ratios from any set of financial statements.
Dupont analysis
By constructing the pyramid of ratios, you will gain an extremely solid understanding of the business
and its financial statements.