Calculation of financial ratios
Avatar Adrien
Company

Selecting and calculating financial ratios

Whether times are tough or business is booming, it is always wise to keep a close eye on your company’s financial situation. With this in mind, analysing and interpreting financial ratios will give you a clearer picture of your company’s financial health and enable you to make the right decisions at the right time.

What is a financial ratio? How do you calculate a financial ratio? How do you choose the most appropriate financial ratio for your situation? Find all the answers in this article.

Understanding financial ratios

A financial ratio provides clear and precise information on a company’s financial health. There are many financial ratios that provide a variety of data, which is often complementary.

These are expressed as ratios or percentages and may be presented in a financial analysis from the following perspective:

  • to assist CFOs and business leaders in their decision-making, whether to secure capital or to increase investment;
  • to persuade lenders (banks and other institutions) during the process of negotiating a loan to help grow the business;
  • to reassure shareholders regarding the company’s performance in the short term (dividend payments) and in the medium term;
  • to communicate with employees and staff in order to reassure them and involve them in the creation of value for the company.

It is particularly in the context of a company takeover or when comparing performance against the sector in which the company operates that financial ratios come into their own. Financial ratios therefore have practical significance; as a result, they generally focus on current rather than historical data.

Choosing the right financial ratios

Depending on the situation and the industry in question, the ratios to be used will vary; it is therefore essential to understand them fully in order to select the most appropriate ones.

To select the most relevant financial ratios, it is advisable to base your decision on:

  • analysis of key performance indicators (KPIs);
  • an analysis of the business environment (sector, competition and market);
  • analysis of the content of the financial statements (balance sheet, profit and loss account, cash flow statement, etc.)

The purpose for which you are using financial ratios and the timeframe within which you wish to act are two further factors to consider when making your decision.

Ultimately, it all depends on the specific challenges your company faces. Liquidity, solvency, profitability, financial risk coverage… There are several ratios for each of these areas.

Calculate a financial ratio

Profitability ratios

Profitability ratios are designed to assess a company’s current performance.
For this reason, they draw on data from the income statement to provide relevant information on the relationship between revenue and expenses.

They also make it possible to compare the company’s results with those of its competitors and to analyse the productivity of the resources used.

Financial ratioCalculation formulaObjective
Overall profitabilityRevenue / TurnoverMeasures the impact of costs on the company’s ability to generate sales.
Margin rateEBE / VAMeasures the company’s ability to generate sales (of goods or services).
Operating gross marginEBITDA / Turnover (excl. VAT)Measures the company’s actual profitability and its ability to cover depreciation and amortisation.
Return on equity (ROE)Nursery / ReceptionMeasures the return on capital invested in the company.
Production margin rate (mark-up rate)(Turnover excl. VAT – Purchases excl. VAT) / Turnover excl. VATMeasures the percentage of turnover remaining after deducting the costs incurred in generating it.
Sales margin(Turnover excl. VAT – purchases excl. VAT) / purchasesMeasures the percentage of turnover remaining after paying for the services required to generate it.
Labour productivity ratio (staff efficiency rate)Turnover / number of employeesMeasures human resource productivity. This ratio is only meaningful when compared with competitors.
Value-added rateVA / CAMeasures the value actually generated by the company internally.

Where:

  • CA stands for turnover.
  • EQUITY stands for equity.
  • HT stands for 'excluding tax'.
  • VA stands for value added. VA = gross margin + production – purchases from third parties.
  • NP stands for net profit. NP = operating profit + financial profit + extraordinary profit.
  • EBE stands for gross operating profit. EBE = turnover + operating subsidies – purchases from third parties – staff costs – taxes and duties.

To track changes in a company’s profitability over time, we use the rates of change between year N and year N-1.

Financial ratioCalculation formulaObjective
Activity ratio(CAN – CAN-1) / CAN-1Measures changes in turnover from one period to the next
Value-added ratio(VAN – VAN-1) / VAN-1Measures the change in value added from one period to the next

This formula can, of course, be applied to any of the company’s financial indicators to determine its year-on-year growth rate.

Coverage ratios

Coverage ratios help to determine the extent to which a company is able to maintain its financial independence at a given point in time in the face of various liabilities. These ratios therefore provide a clear picture of the level of risk assumed by the company.

Financial ratioCalculation formulaObjective
Financial expense coverage rationet financial expenses / VAMeasures the company’s financial independence.
Coverage ratio for long-term loansannual refunds / CAF*Measures the company’s financial independence in relation to its long-term borrowings.
Debt coverage ratioEBITDA / loan and lease paymentsMeasures the company’s financial independence in relation to its debts.
*Where CAF stands for cash flow.

Cash flow ratios

Cash flow ratios highlight a company’s ability to manage its cash flow and inventory levels, both in terms of payments to suppliers and invoicing of customers.

It is similar to financial balance ratios, which compare a company’s requirements with the resources actually available.

This brings two key concepts into play:

  • Working capital requirement (WCR), which is equal to inventories, trade receivables and other receivables minus trade payables, tax liabilities and social security liabilities. A distinction is made between operating working capital requirement (OWCR) and non-operating working capital requirement (NOWCR).
  • Total net working capital (TNWC), which is equivalent to permanent capital minus fixed assets. When TNWC is positive, it indicates that the company is solvent.

Good to know: Working capital (BFRE) = current operating assets – current operating liabilities. Non-operating working capital (BFRHE) = current non-operating assets – current non-operating liabilities.

Financial ratioCalculation formulaObjective
Average payment period for suppliers (in days)(trade payables incl. VAT / total purchases incl. VAT) × 360Measures the average length of credit terms granted by suppliers in days.
Average customer payment period (in days)(trade receivables incl. VAT / turnover incl. VAT) × 360Measures the average number of days taken to receive payment from customers.
Inventory turnover ratio(value of stock / total purchases including VAT) × 360Measures the difficulty in moving stock.
Net cashcash on the assets side – cash on the liabilities side, or
working capital – WCC
Measures the net cash actually available to the company.

Liquidity ratios

Liquidity ratios indicate a company’s ability to meet its short-term financial obligations. Each ratio is calculated based on the assets required to make the various payments.

Financial ratioCalculation formulaObjective
Liquidity ratio (or general liquidity)current assets / current liabilitiesMeasures the company’s ability to repay its short-term debts.
Restricted liquidity ratio(receivables + cash and cash equivalents) / current liabilitiesMeasures the company’s limited ability to repay its debts.
Quick ratiocash and cash equivalents / current liabilitiesMeasures the company’s ability to repay its debts immediately.
Net gearing ratiodebts / CPMeasures the company’s level of financial independence.

Structural ratios

Structural ratios are based on the balance sheet to provide a more in-depth analysis of the company’s financial position. Assets, liabilities, financing… The data obtained is meaningful both internally and when viewed within the sectoral context.

Financial ratioCalculation formulaObjective
Asset liquidity ratiocurrent assets / total assetsMeasures the proportion of stock and trade receivables relative to the total balance sheet.
Asset immobilisation rationet fixed assets / total assetsMeasures the proportion of tangible fixed assets relative to the total balance sheet.
Ageing rationet fixed assets / gross fixed assetsMeasures the level of wear and tear on fixed assets, i.e. the condition of the production equipment.

Solvency ratios

In addition to coverage and cash flow ratios, solvency ratios assess a company’s ability to generate and retain value (equity and cash flow) in relation to its other resources.

Financial ratioCalculation formulaObjective
Financial independence ratioEquity / permanent capitalMeasures the company’s ability to finance itself, i.e. its level of financial independence.
Financial independence ratioBalance sheet / total assetsMeasures the proportion of equity capital relative to total capital.
Repayment capacity ratioAnnual capital and interest payments / total repayment instalments on medium-term loansMeasures the company’s ability to repay its debts sooner or later than originally scheduled.

Stock market ratios

In the case of a publicly listed company, other indicators can be used to gauge the value of its shares.

Financial ratioCalculation formulaObjective
Earnings per share (EPS)net profit / total number of shares, orMeasures earnings per share.
Price-to-book ratio (PBR)market capitalisation / equityMeasures the company’s market valuation relative to its equity.
Price-to-earnings ratio (P/E ratio)market capitalisation / net profitMeasures the share price and helps to identify potential overvaluation or undervaluation.
Dividend per sharetotal dividend / number of sharesCalculates the dividend per share.
Share yielddividend / market capitalisation of a shareMeasures the return per share.

Financial ratios by business segment

Depending on the sector in which the company operates, other ratios may serve as key performance indicators. In the context of an e-commerce business, for example, ratios such as average basket value, conversion rate and cost per click (CPC) can provide valuable insights at every stage of the user journey.

Of course, there are countless such ratios, and they vary significantly depending on whether the company specialises in providing services or selling goods, and on its core business.

Far more than just a simple percentage, financial ratios are a tool which, when used wisely, provide vital insights into a company’s financial health and performance. What’s more, these ratios are essential for informed decision-making, as well as for successful negotiations!

React to this article!

Your comment will be reviewed before it is published.