Avadhut |

September 25, 2020

Financial health analysis (FHA), as the word says, is how to determine the financial health of a company.

The analysis is primarily performed by the management of companies to assess the business sustainability of its suppliers.

The overall health of a supplier sheds light on how well it will do in the short term and whether it will be able to honour the supply agreements.

For example, Apple has a business agreement with 320 suppliers.

At periodic intervals, the financial manager of product sourcing (procurement) team checks the financial health of its suppliers to assess whether a supplier would be able to honour the supply agreement of the products.

• Learn Wall Street Skills

• Ace the Interviews

• Get the Best Job

• Leading Training Provider

• 41053+ Customers

• Lifetime Expert Support

• 90-Day money-back guarantee

• $347-Value Bonus

The company also does FHA while entering into an agreement with a new supplier.

FHA is also now done by independent Supplier Assessment companies.

The Financial Analyst in these companies does FHA for the suppliers of a company (such as Apple) and provides the analysis to the financial manager, who can take the decision for existing or new supply agreement.

So, how does a financial manager or financial analyst does FHA?

Here's the process:

The FHA can be done by understanding financial performance with respect to industry performance.

However, looking at large sets of financial data for the company and its peers can be overwhelming.

Also, taking a strategic decision for a supply agreement just based on the looking at the financial performance could be difficult.

Hence, **we will prepare a simple model to deduce a score to depict the financial health of a company**.

The model will help you to understand the process carried out in calculating the score, which you can also compare historically to deduce the improvement or deterioration in the financial health of the company.

For example, if a supplier score has deteriorated over the period and has entered into a red zone (say less than 30%), the company can negotiate the terms with this supplier.

Similarly, you can look at the score of a supplier, with respect to the other suppliers, while entering into the new contract.

The assessment of FH can be done by analyzing the performance under four broad categories:

- Profitability
- Cash Flow
- Liquidity
- Leverage

We will calculate a score of these categories after analyzing the financial ratios under each of these categories.

In our article, we will take the case example of Cisco Systems. We will calculate the Peer benchmark score, which will help understand the financial health of Cisco relative to its peers. We have chosen the following peers of Cisco for our analysis: Motorola Solutions, Juniper Networks, Brocade Communications, and Finisar Corporation.

Read this first: Careers in Financial Modeling.

The below steps will help to calculate the aggregate score to assess financial health.

The financial data to analyze the financial ratios can be sourced from the filings of a company.

Please source the following financial items from the financial statements like income statement, balance sheet and cash flow statement of the financial statement. For the purpose of ratio calculation, source 2 years of historical data for each of the peers.

__Figure 1: Historical data for Health analysis__

The profitability of the company can be analyzed by calculating the following ratios for the company and its peers.

This ratio indicates how profitable a company is at the most fundamental level and is calculated as:

= Gross Profit / Revenues

This ratio indicates what proportion of a company's revenue is left over after paying for variable costs of production such as wages, raw materials, etc. and is calculated as:

= EBITDA / Revenues

This ratio indicates how much profit a company makes for every dollar it generates in revenue and is calculated as:

= Net Profit / Revenues

This ratio indicates how efficiently the management using its assets to generate earnings and is calculates as:

= EBIT x (1-Tax Rate) / Total Assets

Once the ratios are calculated for Cisco and its peers then set up the table as shown in Figure 2 to calculate the Profitability Score.

In order to calculate the Profitability Score, we will first assign the weight to each of the ratios and then calculate the score for each of the ratios.

We will then multiply the weight and score of each ratio and add them to calculate to the Profitability Score.

The weight of a ratio is assigned by understanding the relevance of that ratio relative to its peers.

The idea is that the ratio and the financial (used to calculate that ratio) should be comparable across the companies.

If the financial item is not comparable, you should try to adjust for unusual or extraordinary items to make it comparable and then calculate the ratio for comparison purpose.

If you are not able to make the desired adjustment (due to lack of disclosures) then either choose a different ratio or assign that ratio low or nil weight.

For example, if the net profit of the company (that you are analyzing) is negative and of all peers is positive, then you should find the reason for negative profit.

If the disclosures are available, then you should adjust the net profit to make it comparable.

If the disclosures are not available, then either choose a different ratio (such as EBIT Margin) or assign Net Profit Margin 0% weight and distribute the weights to other ratios.

Similarly, if the company that you are analyzing has less debt on its balance sheet as compared to its peers, then the leverage position or debt ratios will not be comparable.

Hence, assign less weight to the leverage category and debt ratios (for example, Total Debt to Equity) and coverage ratios (Interest coverage).

For our example of Cisco in Figure 2, we have assigned less weight to EBITDA margin and Return on Assets, because the ratios are very near to the boundaries (minimum and maximum) of peer average.

We will follow the same approach of assigning weights when we calculate the ratios in other categories.

We will now calculate the score for each ratio.

In order to calculate the score, we will first calculate the minimum and maximum of each ratio of all peers (including Cisco).

Then we will calculate the score of Cisco on a scale of 0 to 10 (0 being the lowest and 10 being the highest). **This process is called normalization.**

To understand normalization, consider that you need to find the position of a number between lower boundary and an upper boundary.

For example, 8 is at the 8^{th} position between 0 and 10 (with 0 being the minimum and 10 being the highest).

This can be calculated as (8 – 0)/(10 – 0).

We will use this concept to calculate the score of each ratio.

For example, Gross Margin of Cisco is 60.3% and a minimum of peers is 34.8% and a maximum of peers is 66.3%.

The normalized score of Gross Margin (on a scale of 0 to 10) can be calculated as [(60.3% – 34.8%) / (66.3% – 34.8%)] * 10. Please note that 0 is the lowest score and 10 is the highest score.

Once, you have set up the weights and calculated score for each ratio, you can calculate the profitability score by summing up the multiplication of weight and score of each ratio.

This is done using the** Sumproduct** function of Excel.

In practice, you should assign the weight for a financial ratio based on an understanding of the company.

This is the approach followed by a financial manager or financial analysts.

Also, you should exclude the outliers (companies having very high or low ratios) from the peer set or calculation of minimum and maximum.

In practice, the minimum and maximum are also calculated by taking the full data set of companies in a broad index, like the S&P 500.

** **__Figure 2: Calculation of Profitability Score__

The liquidity of the company can be analyzed by calculating the following ratios for the company and industry peers.

This ratio indicates the firm’s ability to meet short-term obligations from short-term assets employed in the firm and is calculated as:

= Current Assets / Current Liabilities

This ratio indicates the firm’s ability to meet short-term obligation from short-term liquid obligations employed in the firm and is calculated as:

= (Cash and Short term investment) / Current Liabilities

This ratio indicates the firm’s ability to meet the interest expense from earnings generated by the business and is calculated as:

= EBITDA / Interest Expense

Where EBITDA is calculated as EBIT + Depreciation + Amortization

This ratio indicates the firm’s ability to meet the current debt obligation from cash generated by the business and is calculated as:

= Cash Flow from Operation / Short Term Borrowings

We will apply a similar approach to calculate the liquidity score as we used to calculate profitability score.

__Figure 3: Calculation of Liquidity Score__

The full calculation of Liquidity score for CISCO Corp can be seen in the spreadsheet here.

The cash flow of the company can be analyzed by calculating the following ratios for the company and industry peers.

The ratio indicates the effectiveness of the company’s credit control department in collecting the outstanding money and is calculated as:

= Total Revenue / Average Receivables

This ratio indicates the firm’s ability to meet short-term obligations from the cash flows (from operations) generated by the business and is calculated as:

= Cash Flow from Operations / Current Liabilities

This ratio indicates the cash generated by the business after laying out the money required to maintain or expand its asset base and is calculated as:

= EBIT x (1-Tax Rate) + Depreciation & Amortization - Change in Net Working Capital - Capital Expenditure

We will apply a similar approach to calculate the Cash Flow score as we used to calculate profitability score.

__Figure 4: Calculation of Cash Flow Score__

The leverage/capital structure of the company can be analyzed by calculating the following ratios for the company and industry peers.

This ratio indicates the proportion of debt capital with respect to equity capital employed in the business and can be calculated as:

= Total Debt / Total Equity

where Total Debt = Short Term Borrowing + Total Long Term Borrowing + Capital Leases and

Total Equity = Total Preferred Equity + Total Shareholder’s Equity

This ratio indicates the proportion of debt capital with respect to total capital employed in the business and can be calculated as:

= Total Debt / (Total Debt + Total Equity)

This ratio indicates the proportion of total liabilities with respect to total assets in the business and can be calculated as:

= Total Liabilities / Total Assets

This ratio indicates the repaying capacity of the borrowers with the cash income generated by the business and is calculated as:

= Total Debt / Total EBITDA

We will apply a similar approach to calculate the leverage score as we used to calculate profitability score.

__Figure 5: Calculation of Leverage Score__

We will now assign the weight to each of the broad ratio category scores to calculate the aggregate score for peer benchmark and historical benchmark.

The consolidated company score can be calculated by the Sumproduct of weight and score.

__Figure 6: Calculation of Aggregate Score__

Based on the above calculations, we can observe that Cisco has a strong profitability position, supported by a large revenue base and healthy margins.

The liquidity position is strong, marked by a substantial cash reserve and a high current ratio.

The company generated enough earnings and cash flows to cover up the interest and debt obligations.

The leverage position is strong, supported by a low net debt level and healthy coverage of liabilities.

The aggregate score was above 70%, which places Cisco in strong position amongst its peers for supply assessment.

The financial manager can compare the score historically to see the improvement/deterioration in financial health.

You’ve just seen 6 of my favourite Financial Health Analysis secrets…

Now it’s time to put these techniques into practice.

The first step?

Enter your email to get access to my FREE Financial Modeling Videos and eBooks.

The next step?

Write your comments and queries below.

Subscribe

15 Comments