How to present Financial Ratio Analysis in your equity research report?
In this chapter, I will explain the importance of presenting financial ratio analysis data of the company in detail.
I will also explain the importance of financial and ratio analysis in an equity research report. We'll look at the different financial statements where you will get the data for calculating the ratios.
In the earlier chapter we learnt how to write industry analysis in equity research reports, Porter's 5 forces model and PESTLE analysis.
Now that you have understood how to complete the industry segment, let’s move on to the next chapter which is financial and ratio analysis.
This is one of the most challenging segments of an equity research report as many times it’s difficult to decide what to put in this segment and what to avoid.
If you look at any annual report you find a lot of financial information being provided there. You have the four key financial statements:
- Balance sheet
- Income statement (profit and loss statement)
- Cash flows
- Statements of shareholders’ equity
Balance sheets show what an organization owns and what it owes at a fixed point in time.
Income statements show how much money an organization made and spent over a period of time.
Cash flow statements show the exchange of money between an organization and the outside world over a time period.
The fourth financial statement, called a “statement of shareholders’ equity,” shows changes in the holdings of the organization’s shareholders over a period of time.
Let’s look at each of the first three statements more carefully:
a. Balance Sheet
A balance sheet provides detailed information about a company’s assets, liabilities and shareholders’ equity. The following formula explains what a balance sheet shows:
Assets = Liabilities + Shareholders' Equity
A company's assets have to equal, or balance, the total of its liabilities and shareholders' equity.
Assets are generally listed based on how quickly they will be converted into cash while Liabilities are generally listed based on their due dates. Liabilities are said to be either current or long-term.
A balance sheet shows a snapshot of a company’s assets, liabilities and shareholders’ equity at the end of the reporting period. It does not show the flows into and out of the accounts during the period.
b. Income Statements
An income statement is a report that shows how much revenue a company earned over a specific time period (usually for a year or some portion of a year). It also shows the costs and expenses associated with earning that revenue.
Income statements also report earnings per share (or “EPS”). This calculation tells you how much money shareholders would receive if the company decided to distribute all of the net earnings for the period.
c. Cash Flow Statements
Cash flow statements report a company’s inflows and outflows of cash. This is important because a company needs to have enough cash on hand to pay its expenses and purchase assets. While an income statement can tell you whether a company made a profit, a cash flow statement can tell you whether the company generated cash.
You can find more information about this at Beginners' Guide to Financial Statements.
Please understand one thing that no single financial statement will tell you the complete story of any organization. But if you combine them, they provide very powerful information for investors.
Remember that good and correct information is the investor’s best device when it comes to investing wisely.
So now that we have seen the most important financial statements, let’s understand what we should include from them in our equity research report.
Always remember the principal “less is more”. This does not mean that you just give a brief snapshot of the financials of the company which might not be enough for the reader to make up his mind about the financial strength of the organization. It means give precise and relevant information which will help the reader quickly understand the organization’s financial health and take calculated decisions.
So now what do we put in our equity research report?
First thing to add is a brief financial snapshot or a summary. Refer the example given below.
You can see that here the analyst has given us the key financial information points for the quarter such as total income, total expenses, EBITDA and other profit figures.
Note that he has given the financial numbers for not just the current quarter, but has also for the last quarter as well as the same quarter last year. He has also provided the ‘year on year’ (YOY) change as compared to the last year as well as a ‘quarter on quarter’ (QOQ) change against last year’s quarter. This gives the reader a clear idea as to whether the company is doing better or worse as compared to these two time periods. So here, instead of giving the entire income statement, the analyst has given us only key information which will help the reader understand the financial strength of the organization.
You can also provide a snapshot of the annual financial figures in addition to the quarterly figures. By providing annual figures you give the readers a more detailed view of the organization and they can look at a whole year’s performance instead of looking at only a quarter’s performance.
In this example if you see, the analyst has given a snapshot of all the three key financial statements. You don’t need to print the entire statements here but only the key numbers which are really helpful in understanding the financial strength or performance of the organization.
You can also give historical figures for the last two or three years, with growth rates, which will give a much clearer picture to the reader about the growth or decline of the organization.
All this information is easily available in the organization’s financial reports.
Further, you can also give more details such as breakup of the revenue or earning figures or trends in various different margins over a period of time as shown in the examples below:
Thus first thing you have to do is to figure out which are the key financials that you want to show in your report. And then decide with how many different time periods you want to compare the current financials with. Again don’t forget the rule of ‘less is more’ while doing this.
Now that you have given a snap shot of the financials of the company the next thing is the look at key ratios.
d. Financial Ratio Analysis
Ratio Analysis is a type of financial analysis that is used to get a quick indication of an organization’s financial performance in several key areas. The ratios can be categorized as Short-term Solvency Ratios, Debt Management Ratios, Asset Management Ratios, Profitability Ratios, and Market Value Ratios.
The calculation of ratios helps in the comparison of companies which vary in size. Ratios can be used to evaluate a company’s financial performance with the industry averages. In addition, ratios can be used as trend analysis to spot areas where performance has improved or deteriorated over a period of time.
Ratio Analysis should only be used as an initial step in financial analysis, to get a quick idea of a company’s performance and to understand areas which should be investigated further.
Some key financial ratios are:
- Short-term Solvency Ratios
- Debt Management Ratios
- Asset Management Ratios
- Profitability Ratios
- Market Value Ratios
- Equations (per share ratios)
You can get more information on ratio analysis on the below links:
Now that we know that there are so many financial ratios that you can calculate and present, which of them should you really put in your equity research report? Again use the rule of ‘less is more’. No need to give all the ratios that you can calculate. There are no marks for filling up pages. Only give those ratios which will help the reader make comparisons or take calculated decisions.
Some of the important ratios you should always provide are:
- PE ratio (Price earnings ratio)
- ROE (Return on equity)
- ROCE (Return on capital employed)
- CR (Current Ratio)
- Margins such as Net Profit Margin, EBIT Margin, EBITDA margin, etc
If you see this example, the analyst here has provided the key ratios such as PE, ROCE, ROE, margins, as well as asset turnover and net debt to equity ratio.
Note that most ratios will be in percentage (%) but some like working capital cycle will be in days while some will be in multiples. Please make sure you give these notations clearly to avoid any confusion to the reader.
You can also compare these ratios to earlier years or even with competing companies to give an even better comparable analysis to the reader.
Also it’s a very good idea to give interesting and informative graphs and charts about various financial intelligence data points in the report to make it interesting and at the same time informative.
If you see the above examples, the analyst here has given two interesting charts. One shows the growth in the company’s domestic sales, and other shows growth in the exports of the company. These charts supplement the financial information the analyst has given above in the tables.
All the financial information you might need for this section of the report is most of the times easily available in the financial reports of the companies. There are also various databases such as Bloomberg which provide this kind of information. For the ratios, either you can calculate the ratios, or even get then from financial portals such as Yahoo finance or Google Finance.
Hopefully, now you understand what financial intelligence and financial ratios to use in your equity research report and how to present them.
Suggested: Read more about Equity Research Report
I would again like to reiterate that do not overload your report with loads and loads of financial information, which could put off the reader. Be as precise as possible, only give the information which is relevant and will help the reader take calculated decisions about the company. Always remember the golden rule – ‘less is more’!
Now You Try It
I hope you understood how to present financial ratio analysis in your equity research report.
Yes, it takes hard work to create something great.
But with this skill you already know ahead of time that your hard work is going to pay off.
I want you to read various equity research reports to understand various styles and methods of presenting financial ratio analysis
At the same time, start working on writing reports.
If you have a question or thought, leave a comment below and I’ll get right to it.