Premium Essay

Formulas for Common Ratios

In:

Submitted By rachel16
Words 482
Pages 2
Formulas For Common Ratios
Growth Rates
One-year Growth Rate Xt −Xt−1 Xt−1 Xt Xt−n
1 n

Compound Average Growth Rate (CAGR)1

−1

Profitability Ratios
Gross Margin Operating Margin Net Margin Return on Assets (ROA)2 Return on Beginning Equity (ROBE)3 Return on Invested Capital (ROIC)4 Pretax Return on Invested Capital Gross Profit Sales EBIT Sales Net Income Sales EBIT(1-Tax Rate) Average Total Assets Net Income Beginning Equity EBIT(1-Tax Rate) Interest-bearing Debt + Equity EBIT Interest-bearing Debt + Equity

1

n denotes the number of periods between observations Xt and Xt−n . Ratios that compare balance sheet and income accounts are often computed using the average of the balance sheet item. The average is computed by averaging beginning and year-end account balances. 3 Some analysts use year-end or average equity when computing ROE. 4 Interest-bearing debt is commonly defined as the sum of long-term debt, current portion long-term debt, and shortterm debt. Analysts may use year-end or average invested capital.
2

HBS Finance Tutorial

1

Ratio Formulas

Efficiency Ratios
Asset Turnover Net Working Capital Turnover Fixed Assets Turnover Days in Inventory (Days) Inventory Turnover Collection Period (Days) Receivables Turnover Days’ Sales in Cash (Days) Payables Period (Days)5 Sales Average Total Assets Sales Average Net Working Capital Sales Net PP&E Average Inventory COGS/365 COGS Average Inventory Average Receivables Sales/365 Sales Average Receivables Cash + Securities Sales/365 Accounts Payable Credit Purchases/365

Liquidity Ratios
Current Ratio Quick Ratio6 Cash Ratio Interval Measure7 Current Assets Current Liabilities Cash + Marketable Securities + Receivables Current Liabilities Cash + Marketable Securities Current Liabilities Cash + Marketable Securities + Receivables Operating Costs/365

5 6

COGS is often used when credit

Similar Documents

Premium Essay

Ratios

...|FINAL PROJECT RATIOS | LIQUIDITY AND ACTIVIY Current Ratio measures the ability of a firm to pay its short-term debts. The formula is: |Current Ratio |= |Current Assets | | | |Current Liabilities | Quick (Acid-Test) Ratio measures the immediate ability of a firm to pay its short-term debts. The formula is: |Current Ratio |= |Cash + Marketable Securities + Current Receivables | | | |Current Liabilities | Accruals ratio measures the amount of accounts receivables to cover the accounts payable. The formula is: |Accruals Ratio |= |Accounts Receivables | | | |Accounts Payables | Cash Flow Yield measures ability to generate operating cash flows in relation to NI (the most important liquidity ratio). The formula is: |Cash Flow Yield |= |Net cash provided by | | ...

Words: 1226 - Pages: 5

Premium Essay

Disney Finance Report

...Performance Current Ratio The current ration concludes the liquidity of the company. A company’s current assets mainly consist of cash, accounts receivable, and etc. Current liabilities are primarily account payable, accumulated income taxes, existing maturities of long-term debt, and other accumulated expenses payable within one year. When the current ratio is greater than the industry normal, this concludes the presence of redundant assets. Whereas, on the other hand, lower than the industry concludes that there is a lack of liquidity ("Ratios And Formulas In Customer Financial Analysis", 1999). The current ratio formula consists of: Current Assets/ Current Liabilities = Current Ratio (In millions) 2011 | 2012 | 13,757/ 12,088 = 1.1x | 13,709/ 12,813 = 1.0x | Based on the current ratio for the past two years, Disney current ratio has been lower than the industry normal. This can conclude their assets lack liquidity and may have some issues meeting their short-term financial obligations. Debt Ratio The debt ration formula assists with the comparison of a company’s total debt from its total assets. This formula is primarily used to develop a general idea on the leverage of the company. Typically, a greater percentage is stating that the company is more dependent on their creditor, while a lower percentage states the opposite; the company relies less on their creditors and has a strong equity position ("Debt Ratio Formula", n.d.). The debt ratio formula consists of: Total...

Words: 609 - Pages: 3

Premium Essay

Financial Analysis

... Current Ratio The current ratio is an indication of a company’s ability to pay current liabilities with current assets. The formula for calculating the current ratio is current assets divided by current liabilities. DHG has a current ratio of 1.69 for year 11. When compared to the current ratio of 1.83 in year 10 and industry data quartiles of 3.1, 2.1, and 1.4 this ratio appears to be decreasing and indicates a weakness. Management should investigate ways to increase assets and reduce liabilities to improve the company’s ratio and ability to pay its liabilities. Acid-Test Ratio The acid-test ratio is an indication of a company’s ability to pay all of its current liabilities if they came due immediately. The formula for calculating this starts by adding cash, short term investments, and net current receivables together and driving them by current liabilities. DHG has an acid-test ratio of .39 for year 11. This compared to the acid test ratio of .61 for year 10 and the industry quartiles of 1.6, .9, and .6. This ratio is decreasing and indicates a weakness for DHG. Management again needs to investigate ways to increase assets and reduce liabilities to improve this ratio and the company’s ability to pay its liabilities. Inventory Turnover The inventory turnover ratio is an indication of a company’s ability to sell its inventory/goods. The formula for calculating this is the cost of goods divided by average inventory. DHG has an inventory turnover ratio of 5.15 for...

Words: 1561 - Pages: 7

Premium Essay

American Corporation Analysis

...American Corporation Analysis PROFITABILITY RATIOS Note: All numbers are shown in millions except for ratios. 1. Earnings Per Share Ratio | Formula | Purpose | 2013 | 2012 | Earnings Per Share (EPS) | Net Income − Preferred Stock DividendsAverage Common Shares Outstanding | Measures the net income earned on each share of Deere’s common stock. | $9.093,537.3 – 0389.2 | $7.633,064.7 – 0401.5 | Earnings Per Share (EPS) is the gauge of John Deere’s profitability. It is the portion of Deere’s profit allocated to each outstanding share of common stock. In 2013, EPS increase by $1.46 per share. This was two (2) years in a row that Deere’s EPS has increased substantially. 2. Price-Earnings Ratio Ratio | Formula | Purpose | 2013 | 2012 | Price-Earnings Ratio | Stock Price Per ShareEarnings Per Share | Reflects investors’ assessments of Deere’s future earnings. | 9.0081.849.09 | 11.1985.447.63 | This oft-quoted statistic measures the ratio of the market price of each common stock to EPS. Price-earnings ratio (P/E) is how John Deere’s stock is measured amongst investors. Deere’s P/E tells investors what the market is willing to pay for Deere’s earnings. 3. Gross Profit Ratio Ratio | Formula | Purpose | 2013 | 2012 | Gross Profit Ratio | Gross ProfitNet Sales | Determines ability to maintain adequate selling price above its cost of goods sold. | .279,33134,997.9 | .258,49333,500.9 | John Deere’s 2013 gross profit ratio increased to .27 from .25 in 2012. The increase...

Words: 1608 - Pages: 7

Premium Essay

Charcoal

...to the exact scope and definition of mathematics.[7][8]  If a sequence of values follows a pattern of adding a fixed amount from one term to the next, it is referred to as an  arithmetic sequence.   The number added to each term is constant (always the same). The fixed amount is called the common difference, d,referring to the fact that the difference between two successive terms yields the constant value that was added.   To find the common difference, subtract the first term from the second term. 1.  Find the common difference for this arithmetic sequence                           5, 9, 13, 17 ... | 1.  The common difference, d, can be found by subtracting the first term from the second term, which in this problem yields 4.  Checking shows that 4 is the difference between all of the entries. | 2.  Find the common difference for the arithmetic sequence whose formula is                           an = 6n + 3 | 2. The formula indicates that 6 is the value being added (with increasing multiples) as the terms increase.  A listing of the terms will also show what is happening in the sequence (start with n = 1).                            9, 15, 21, 27, 33, ... The list shows the common difference to be 6. | 3.  Find the 10th term of the sequence                           3, 5, 7, 9, ... | 3. n = 10;  a1 = 3, d = 2  The tenth term is 21. | 4.  Find a7 for an arithmetic sequence where                   a1 = 3x and d = -x. | 4.  n = 7;  a1 = 3x, d = -x | 5.  Find  t15 for...

Words: 1465 - Pages: 6

Premium Essay

Ratio Anlysis on Beximco

...Ratio Analysis & Time Series Analysis Of 2.1 Ratio and time series analysis of Beximco Pharmaceutical 1. Inventory turnover: A ratio showing how many times a company's inventory is sold and replaced over a period. Formula: Inventory Turnover =Cost of goods sold/Average Inventory. The ratio and time series analysis of Inventory Turnover of Beximco Pharmaceutical from 2008-2012 is given below- | Inventory Turnover | 2008 | 1.346 | 2009 | 3.01 | 2010 | 3.50 | 2011 | 1.92 | 2012 | 2.07 | Interpretation: The companies ratio increases from 2008 to 2010, then decreases in 2011 and then again increases from 2012. 2. TIE ratio: Time interest earned ratio (TIE) also known as Interest coverage ratio, indicates how well a company can cover its interest payment on a pretext basis. The larger the time interest earned, the more capable the company is paying the interest on its debt. Formula: Earnings before interest and tax / Total interest ] The ratio and time series analysis of TIE Ratio from 2008-2012 given below- | Time Interest Earned | 2008 | 4.90 | 2009 | 4.03 | 2010 | 3.21 | 2011 | 3.50 | 2012 | 3.42 | Interpretation: The Ratio Increases from 2008 to 2012 to its highest level of 4.90 and then decreases in 2009 & 2010.Again ratio increase 2011. The ratio fluctuation is very high. 3. Gross Profit Margin: A financial metric used to assess a firm's financial health by revealing the proportion of...

Words: 1867 - Pages: 8

Premium Essay

Financial Statement Analysis

...Insurance Company. 1.2 Report Preview The report mainly consists of a few important parts. The Organization part gives the idea about NItol Insurance Company’s historical background and few relevant information regarding its mission, vision and services. Then, there is a work report that mainly focuses on the main part of the report. This part includes the calculation of financial ratios, then common size analysis of balance sheets and income statement and the overall trend analysis of the company’s financial ratios. Throughout this work report part, we have done some important interpretation regarding the ratios and find some relevant patterns that are described in the part elaborately to give some sort of knowledge about the performance of this insurance company. 1.3 Acronyms Acronyms used throughout the report are as follows: ▪ ROA Return On Asset ▪ ROE Return On Equity ▪ SSC Sales and Service Center ▪ HRM Human Resource Management ▪ CS Common Stock Part 2 Industrial Background Organizational Background 2.1 Industrial Background Insurance is not a new idea or proposition to the people of Bangladesh. About half a century back, during the British regime in the then India, some insurance companies started...

Words: 4549 - Pages: 19

Premium Essay

The Morgan Bistro

...The Morgan Bistro - Ratio Analysis Memo Jennifer Allara, Vanessa Ford, Karla Morales, & Kimberly Richardson ACC/291 October 15, 2012 Emily Baculik | |XYZ Accounting, LLC | Memo To: CEO, Baderman Resort From: Allara, Ford, Morales, & Richardson CC: Boardman Management Group Date: 10/13/2012 Re: The Morgan Bistro – Financial Ratio Analysis 1. What do the liquidity, profitability, and solvency ratios reveal about the company’s financial position? 2. Which users may be interested in each type of ratio? Short terms creditors and such as bankers and suppliers would be interested in evaluating the company’s liquidity ratios. Investors would be very pleased with the current ration of this company for example since for both years 2005 and 2006 the current ratio gave a clean bill of health. In 2005 for every dollar in current liabilities, there was $1.12 in current assets. And in 2006 there was $1.12 in current assets. Bankers and stockholders would be interested in knowing the solvency of the company. They would be interested in solvency rations such as debt ratio, debt equity ratio and interest coverage ratio. Investors will be interested in knowing the returns that they can earn on their investments. For both 2005 and 2006 the debt to total assets ration indicated that the company should be able...

Words: 744 - Pages: 3

Premium Essay

Ratios

...Ratios and Formulas in Customer Financial Analysis Financial statement analysis is a judgmental process. One of the primary objectives is identification of major changes in trends, and relationships and the investigation of the reasons underlying those changes. The judgment process can be improved by experience and the use of analytical tools. Probably the most widely used financial analysis technique is ratio analysis, the analysis of relationships between two or more line items on the financial statement. Financial ratios are usually expressed in percentage or times. Generally, financial ratios are calculated for the purpose of evaluating aspects of a company's operations and fall into the following categories: * liquidity ratios measure a firm's ability to meet its current obligations. * profitability ratios measure management's ability to control expenses and to earn a return on the resources committed to the business. * leverage ratios measure the degree of protection of suppliers of long-term funds and can also aid in judging a firm's ability to raise additional debt and its capacity to pay its liabilities on time. * efficiency, activity or turnover ratios provide information about management's ability to control expenses and to earn a return on the resources committed to the business. A ratio can be computed from any pair of numbers. Given the large quantity of variables included in financial statements, a very long list of meaningful ratios can be derived...

Words: 2431 - Pages: 10

Premium Essay

Ratio's Cheat Sheet

...Ratio Formula Cheat Sheet Prerequisite Formulas Used in the various ratio formulas below Measures the dollar amount of profit remaining after cost of goods sold and is used as the denominator in the Gross Margin calculation Used as the denominator in the Return on Assets calculation Used as the denominator in the Return on Equity calculation Used as the denominator in the Receivables Turnover calculation Used as the denominator in the Inventory Turnover calculation Profitability Ratio Formulas Used to measure how effective an organization is at generating profits Measures the percentage of each sales dollar remaining after cost of sales that contributes to funding the organization’s SG&A and other costs Measures the percentage of each sales dollar that remains after cost of goods sold and SG&A expenses Measures the percentage of each sales dollar that remains after all expenses Measures how effectively an organization uses its assets to generate profits Measures how effectively an organization uses the capital contributed by equity investors (excludes preferred stock) Measures the percentage of net income paid out as dividends Asset Utilization Ratio Formulas Used to measure the amount of time it takes or how efficiently assets are turned into cash Measures the number of times per year the balance of receivables is collected and shows how efficient an organization is in collections Measures the average number of days it takes from the time a sale is made until cash is collected...

Words: 555 - Pages: 3

Premium Essay

Cashflow Analysis

...flow statements             Dear Sir,    Enclosed  is  the  report  you  requested  to  prepare  on  cash  flow  statements  on  the financial report of BEXIMCO SYNTHETICS LIMITED. This report contains the  following particulars   • it contains the analysis of financial statements.   • ratios of different point of view are shown here  • It also shows the comparative analysis of the income statements   • It shows the application of different theories(du point analysis, z‐score)    I  have  collected  the  information  from  the  annual  report  published  that  is  published yearly.    Thank you for giving us the opportunity to prepare this report. I appreciate the  chance to apply my knowledge for conducting the research and preparing this  report. This whole task broadens our outlook and refines our knowledge of this  working capital management course.      Sincerely yours,    Rashmin Ridita  ID‐16076              TABLE OF CONTENT  Introduction   Objective   Methodology   Cash Flow  Financial analysis  1. Activity Measures  2. Liquidity Measures  3. Solvency Measures  4. Profitability Measures   Common size analysis of balance sheet  Common size analysis of income statement Common size analysis of cash flow statements  Trend analysis  Du point analysis  Z score analysis  04  05  05  6‐8    9‐11  12‐13...

Words: 4789 - Pages: 20

Premium Essay

Fnt1

...Current Ratio: Current ratio is a financial ratio that measures whether or not a firm has enough resources to pay its debts over the next 12 months. Formula to calculate current ratio is as follows; Current ratio = Current Assets / Current Liabilities From the results of Company G, we can find out that company G has week liquidity position. It is due to increase in current liabilities more than current assets. Current ratio is not only declining as compared to previous year but also below industrial quartile. Current ratio of company G for year 12 is 1.77 which is lower than that of year 11 that is 1.86. When compared to industry quartile, it’s below first quartile which is 3.1 and also below second quartile i.e. 2.1, although it’s slightly above third quartile but it does not indicate stronger liquidity. Hence it indicates the weakness or threat to the company G. Acid –Test Ratio: Acid-test ratio also known as quick ratio measures the company’s ability to use its quick assets for extinguishing or retiring its current liabilities. Quick assets include cash and cash equivalents, marketable securities and account receivables. Formulas as under; Acid-Test Ratio = Current Assets – Inventory / Current Liabilities Company G has revealed weaker liquidity position in this ratio as well. As compared to previous year, acid-test ratio has been declined from 0.64 to 0.43. As compared to industry quartile, it is also below first quartile (1.6), second quartile (0.9) and third quartile...

Words: 975 - Pages: 4

Premium Essay

Week 4 Problem Set

... Receivables (net) 70,000 62,000 Other current assets 90,000 73,000 Long-term investments 62,000 60,000 Plant and equipment (net) 510,000 470,000 Total assets $760,000 $685,000 Liabilities and Stockholders’ Equity Current liabilities 75,000 70,000 Long-term debt 80,000 90,000 Common stock 330000 300000 Retained earnings 275000 225000 Total liabilities and stockholders’ equity 760,000 685,000 "SIEVERT CORPORATION Income Statement For the Years Ended December 31" 2012 2011 Sales $750,000 $680,000 Cost of goods sold 440,000 400,000 Operating expenses (including income taxes) 240,000 220,000 Net income $70,000 $60,000 Additional information: Cash from operating activities $82,000 $56,000 Cash used for capital expenditures $45,000 $38,000 Dividends paid $20,000 $15,000 Average number of shares outstanding 33,000.00 30,000.00 Instructions Compute these values and ratios for 2011 and 2012. Answers must also include formulas and calculations. Answers (a) Earnings per share. 2011 2012 Net Income - Dividends on Preferred Stock / Average Outstanding Shares ($60,000 - $15,000) / 30,000 = $1.5 $770,000 - $20,000 / 33,000 = $1.51515152 (b) Working capital. 2011 2012 Current Assets - Current...

Words: 680 - Pages: 3

Premium Essay

How to Analyze Profitability

...profit is the most likely reason you started your business. This guide introduces you to several methods for analyzing your company’s operations and calculating the profitability of your business. What You Should Know Before Getting Started Profitability Ratios • Gross Profit Margin • Operating Profit Margin Ratio • Net Profit Margin Ratio • Other Common Size Ratios 3 4 6 7 7 7 Break-Even Analysis • What is Break-Even Analysis? • Break-Even Analysis for Sales • Using Break-Even Analysis for Profit Planning • Break-Even Analysis for Units Sold 9 9 9 11 12 Calculating Return on Assets and Return on Investment • Return on Assets • Return on Investment 13 13 14 Checklist Resources 15 16 how to analyze profitability 3 what to expect Many entrepreneurs start their business, at least in part, because of pride of ownership and the satisfaction that comes from being their own boss. In addition, of course, you almost certainly started your business to generate profits. This Business Builder will introduce you to several methods that will help you analyze your company’s operations and compute the profitability of your business. Among the tools to which you will be introduced are profitability ratios, break-even analysis, return on assets and return on investment. Some of these concepts, and some of the vocabulary we will use to describe them, may be new to you. We’ve tried to explain the terminology and concepts as they are introduced, and where appropriate...

Words: 4894 - Pages: 20

Premium Essay

Finance

...Question 2 (I) Profitability Ratios The profitability ratios are financial ratios that are used to assess a corporation’s performance and its ability to generate income from its operations as compared to its expenses and other costs during a specific period of time. In other words, these ratios basically shows how well a corporation is doing and how well can it achieve profits from all of its operations. Most commonly used by investors and creditors, the profitability ratios can be used to judge a corporation’s performance against its previous business period or over another corporation which is a competitor. For most of these ratios, having a higher ratio value will indicate that the business is doing well. Amongst the profitability ratios are ratios such as a) Profit Margin b) Gross Margin Ratio c) Return on Assets d) Return on Equity e) Return on Capital Employed. a) The most commonly used profitability ratio is the Profit Margin ratio, which is also known as the Return on Sales ratio or Gross Profit ratio. It is used to determine the amount of net income gained with each ringgit of sales generated by comparing the net income over the net sales of a business. In other words, the Profit Margin ratio shows how many percentages of sales are left after the expenses and other costs are paid by a business. Investors will use this ratio to find out if profits are high enough to distribute dividends while creditors will use this to observe whether a business has enough...

Words: 2983 - Pages: 12