Financial Ratio Calculator » The Spreadsheet Page

Publicado em: 27/04/20

Using Ratios In Financial Analysis

Expressed as a numerical value, the ratio indicates how many times current liabilities can be covered by current assets. Profit margin is one of the most popular financial ratios, as it is a straightforward way to gauge a company’s profitability. Expressed as a percentage, it measures a company’s earnings in relation to its revenue. In other what is double entry bookkeeping words, it indicates how much profit is earned on each dollar of sales. Profitability ratios measure a company’s ability to generate earnings in relation to their revenue, operating costs, shareholders’ equity, and balance sheet assets. In other words, these ratios reflect how well a company can convert its resources and assets into income.

financial ratios list

Latest Financial Ratio Articles

In this post, I’m going to explain the 19 most important financial ratios for investors. We will cover different types of ratios like valuation ratios, profitability ratios, liquidity ratios, efficiency ratios, and debt ratios. When used together, turnover ratios describe how well the business is being managed. They can indicate how fast the company’s products are selling, how long customers take to pay, or how long capital is tied up in inventory. Financial ratios are used by businesses and analysts to determine how a company is financed. Ratios are also used to determine profitability, liquidity, and solvency.


Financial ratios quantify many aspects of a business and are an integral part of the financial statement analysis. Financial ratios are categorized according to the financial aspect of the business which the ratio measures. Activity ratios measure how quickly a firm converts non-cash assets to cash assets. Profitability ratios measure the firm’s use of its assets and control of its expenses to generate an acceptable rate of return.

It shows the relationship between the cost of goods sold and the amount of average inventory. Stock turnover ratio is obtained by dividing the cost of sales by average stock.

It indicates the percentage of the company’s assets that are funded by debt and the degree to which its assets could be used to cover its debts. The current ratio is calculated by dividing current assets by current liabilities. Working capital ratio is the liquidity measurement ratio by using the relationship between current assets and current liability. Furthermore, financial ratios will be useful if they are benchmarked against something else, like past performance or another company. But, remember to make it apple to apple if you are benchmarking with other companies in term of company business and size. Financial ratios above might or might not suit with your company’s condition.

In order to pay the fixed costs like interest on debt, healthy operating margin is required for the company. Liquidity ratios is the type of financial ratios that contain set of ratios that describe the liquidity potential of the company. The receivables turnover ratio measures how many times a company collects its accounts receivable in a given period. It highlights the company’s efficiency in issuing credit and collecting money owed by its clients. The inventory turnover ratio is calculated by dividing cost of goods sold by average inventory. The inventory turnover ratio measures the number of times a company sells its inventory within a given period. It is used to determine how effectively a company’s inventory is managed and how quickly its products are sold.

Interest Coverage Ratio

A combined effect of increase to costs and decrease, in selling price. Decrease in cost of goods sold, with selling price remaining constant.

Basically, it is the opposite of liquidity ratio where it sees financial performance from liabilities/debt side. This financial ratio calculator in excel spreadsheet will help you calculate those important metrics. It should also help you to learn which accounts in balance sheet as well as profit and loss statement to generate those ratios. You can customize this spreadsheet easily by typing row numbers next to respective account names. Market ratios measure investor response to owning a company’s stock and also the cost of issuing stock. These are concerned with the return on investment for shareholders, and with the relationship between return and the value of an investment in company’s shares.

Companies in different industries have different sort of operations so it is better to compare those companies that lie in one industry. Liquidity ratios are the group of financial ratios that measure entity financial ability to pay its short term debit. There are many variety ratios including current basic bookkeeping ratio, quick ratio, defensive interval ratio, cash ratio, and working capital ratio. There are two main component that use for calculation these ratios are liquid assets and liquid liability. Working capitalrepresents a company’s ability to pay its current liabilities with its current assets.

In such a scenario, you will always find oil companies undervalued compared to FMCG companies. However, you can compare the PE of one FMCG company with another company in the same industry, to find out which one is cheaper. A company with a lower PE ratio is considered under-valued compared to another company in the same sector with a higher PE ratio.

A DSCR of less than 1.0 implies that the operating cash flows are not sufficient enough for Debt Servicing, implying negative cash flows. Debt Service Coverage Ratio tells us whether the Operating Income is sufficient to pay off all obligations that are related to debt in a year.

financial ratios list

Retained earnings are essential for growth and expansion of business. In fact retaining at least 20% of the net profit before declaring any dividend is a statutory requirement. This ratio indicates earnings per share reflected by the market price. Generally, investors are accustomed to judge companies in the context of the share market, with the help of ‘Earnings per share’. The gross profit ratio is expected to be adequate to cover operating expenses, fixed interest charges, dividends and transfer to reserves.

Liquidity is the firm’s ability to pay off short term debts, and solvency is the ability to pay off long term debts. Monitoring a company’s performance using ratio analysis and comparing those measures to industry benchmarks often leads to improvements in company performance. The following article provides an overview of the 5 categories of financial ratios and links to their description and calculation. Since valuation ratios rely on a company’s current share price, they provide a picture of whether or not the stock makes a compelling investment at current levels. How much cash, working capital, cash flow, or earnings do you get for each dollar invested? These ratios may also be called market ratios, as they evaluate a company’s attractiveness on the market. Financial ratios help you interpret the raw data of a company’s finances to get a better picture of its performance.

Based on this calculation, we can conclude that Company J has a debt service coverage ratio of 0.83, meaning that its operating income only covers 83% of its current debt obligations. This indicates that the company may have trouble repaying what are retained earnings its debts without raising external capital, and therefore could be considered high risk to lenders. The debt service coverage ratio is a measure of a company’s ability to cover its outstanding debt obligations using its operating income.

The ratio establishes relationship between cost of sales and working capital. Working capital turnover ratio is calculated with the help of the following formula. It is calculated to ascertain the efficiency of inventory management in terms of capital investment.

The Operating Cash Flow Ratio, a liquidity ratio, is a measure of how well a company can pay off its current liabilities with the cash flow generated from its core business operations. This financial metric shows how much a company earns from its operating activities, per dollar of current liabilities. Common liquidity ratios are the current ratio, the quick ratio, and the cash ratio.

The current ratio below 1 indicates that the company is not able to pay back its due obligations. Current ratio below 1 shows the poor financial health of the company, but it is not surety for the bankruptcy of the company. Activity ratios contra asset account measure how a company uses its resources to generate sales. They are often used by investors to gauge the efficiency of an operation, the speed at which cash is collected, the rate at which inventory is turned over, and so on.

What Are Activity Ratios?

And, this high ratio might indicate that entity could face difficulty to pay its debt by using all of its assets. Debt to equity or sometime it is called liability to equity ratio. This ratio compare entity current liability or debt to its current equity. It assesses the entity financial leverages by using the direct relationship between current entity liability and entity’s equity.

It is used to check how much capital amount is borrowed vs that of contributed by the shareholders in a company. The average collection period should be lower as a higher ratio means that the company is taking too long to collect the receivables and hence is unfavorable for the operations of the company. As a rule of thumb, companies with increasing earnings per share for the last couple of years can be considered as a healthy sign. For example, the industry PE of Oil and refineries is around 10-12. On the other hand, the PE ratio of FMCG & personal cared is around 55-50. Therefore, you cannot compare the PE of a company from the Oil sector with another company from the FMCG sector.

  • These comprise the firm’s “accounting statements” or financial statements.
  • This ratio also indicates the efficiency of credit collection and efficiency of credit policy.
  • The ratio is helpful in determining the operational efficiency of a business concern and the effectiveness of its credit policy.
  • Debtors turnover ratio measures the number of times the receivables are rotated in a year in terms of sales.
  • Values used in calculating financial ratios are taken from the balance sheet, income statement, statement of cash flows or the statement of changes in equity.
  • The statements’ data is based on the accounting method and accounting standards used by the organisation.

Liquidity ratios are used to measure the ability of a company to pay its short-term debts using liquid assets. More specifically, the profitability ratio can help you to measure business income against various groupings of business expenses, in order to better evaluate the level of a company’s earnings. adjusting entries You can use an efficiency ratio to measure how well a business is using its assets and liabilities to generate sales and income. Return on Equity is a measure of a company’s profitability that takes a company’s annual return divided by the value of its total shareholders’ equity (i.e. 12%).

financial ratios list

Remember that a company cannot be properly evaluated or analyzed using just one ratio in isolation – always combine ratios and metrics to get a complete picture of a company’s prospects. Financial ratios are used to perform analysis on numbers found in company financial statements to assess the leverage, liquidity, valuation, growth, and profitability of a business. Also known as leverage ratios, solvency ratios directly measure a company’s total debt against its assets, equity, and earnings.

They use the firm’s long-term liabilities on the balance sheet such as payable bonds, long-term loans, or pension funds. The solvency ratio represents the ability of a company to pay it’s long term obligations. This ratio compares your company’s non-cash expenses and net income after taxes to your total liabilities . The operating ratio expresses the relationship between operating costs and net sales.

In other words, it is the amount an investor must pay for each dollar of earnings. It indicates whether the market price of a stock reflects the company’s earnings potential or true value, and helps investors determine if it is under or overvalued. As a measure of a company’s ability to pay the interest on its debt, it is used by investors, lenders, and creditors to gauge the level of risk involved in lending. The debt-to-equity ratio is a measure of a company’s debt in relation to its equity. It indicates the degree to which its operations are funded by debt and whether shareholders’ equity can cover total liabilities. The debt ratio is a measure of a company’s debt in relation to its assets.