Indicate what is meant by the following ratio calculations.
1. Liquidity Ratios
Current Ratio = Current Assets
Current Liabilities
= 515800
626900
= 0.82 : 1
Quick Ratio = Quick Assets
Current Liabilities
= 42700 + 205800
626900
= 0.40
Cash Ratio = Cash & Cash Equivalents
Current Liabilities
= 42700
626900
= 0.0681 : 1
2. Turnover / Activity Ratios
Inventory Turnover = COGS
Average Inventories
Average Inventories = (Beginning Inventory + Closing Inventory)/2
=(287,000+267,300)/2
= 277150
= 1229122
2,77,150
= 4.43
Accounts Receivable Turnover = Net Credit Sales
Average accounts receivables
= 37135000
205800
= 180.442
Accounts Payable Turnover = Total credit Purchases
Accounts Payable
= 466520
318300
= 1.465
3. Profitability Ratios
Gross Profit Margin = Revenue - Cost of goods sold
Revenue
Gross Profit = Revenue – Cost of Goods Sold
= 37135000 - 1229122
= 35905878
Gross Profit Margin = 35905878
37315000
= 0.97
Operating Margin = EBIT
Sales Revenue
= 292510
37135000
= 0.01
Return on Equity = Net Income
Average Shareholder Equity
= 615010
81820
= 0.01
4. Debt / Capital Structure Ratios
Debt to Equity Ratio = Total Liabilities
Total Stockholders' Equity
Debt / Equity Ratio = 3,08,600+$40,000
81820
= 4.26
Debt to Total Asset Ratio = Short term debt + Long term debt + Other fixed payments
Total assets
Debt to Total Asset Ratio = 3,08,600 + 40,000
748720
= 0.47
5. Capital Market Value Ratios
Book Value Per Share = Book Value
Number of Shares
= Total Asset – Intangible Asset – Liability
Number of Shares
= 748720 – 0 – 666900
50000
(Share value $1)
= 81820
50000
= 1.6364
Dividend Yield = Dividend
Price
= 55000 / 50000
1.6364
= 668.16
1] | LIQUIDITY RATIOS: |
Current ratio: | |
This ratio gives the number of times current assets | |
are over the current liabilities. It tells whether the | |
current assets are sufficient to meet the current | |
liabilities. | |
The ratio is very low at 0.82:1, indicating that the | |
current assets are not enough to meet the current | |
liabilities. It is a precarious situation indicating that | |
the company will have serious problems in meeting | |
its current liabilities. | |
Quick ratio: | |
This ratio tells how many times the quick assets | |
[current assets that can be converted quickly into | |
cash + cash and marketable securities] are in terms | |
of current liabilities. | |
The ratio is very low at 0.40 and indicates serious | |
liquidity problems. | |
Cash ratio: | |
It is the number of times cash and marketable | |
securities are in terms of current liabilities. It is | |
also very low indicating very serious liquidity | |
situation. | |
2] | TURNOVER/ACTIVITY RATIOS29-06-2019 |
Inventory turnover: | |
It gives the number of times the inventory is turned | |
over in the course of operations. The higher the | |
turnover higher the efficiency of operations. | |
Accounts receivable turnover: | |
The number of times the receivables are turned | |
over by credit sales. Higher the turnover better the | |
efficiency of operations. | |
Acccounts payable turnover: | |
The ratio indicates the outstanding payables for | |
purchases in terms of the total purchases. | |
Lower ratio indicates that the time taken to pay | |
is higher and vice versa. | |
3] | PROFITABILITY RATIOS; |
Gross profit: | |
Gross profit is the excess of sales over cost of | |
goods sold. | |
Gross profit: | |
Indicates the gross margin per dollar of sales in % | |
terms. | |
Operating margin: | |
States the operating profit as a % of sales. | |
Return on equity: | |
Measures the NI as a % of total shareholders' equity. | |
It indicates the rate of income earned on the funds | |
supplied by the shareholders. | |
4) | DEBT/CAPITAL STRUCTURE RATIOS: |
Debt to Equity: | |
This measures the number of times debt is over | |
equity and suggests the capital structure of the | |
firm. | |
Debt to total asset ratio: | |
The extent to which total assets are financed by | |
debt is indicated by the ratio. | |
5) | CAPITAL MARKET VALUE RATIOS: |
Book value per share: | |
The total equity is divided by the number of shares | |
outstanding to get the ratio. It indicates the net | |
asset value per share. | |
Dividend yield: | |
This gives the dividend as a % of share price and | |
indicates the current yield to stock holders. |
Indicate what is meant by the following ratio calculations. 1. Liquidity Ratios Current Ratio = Current...
1. Given the 2019 ratios of Verizon wireless what do EACH of these ratios indicate about the company specifically? (not just as a whole) 2. Lastly, at the end, in one paragraph what do these calculations (all together) mean for the companies financial health? Answers must be broken down into everyday language and not in "financial talk" Profit ratios: gross profit margin (gross profit / sales)*100 gross profit 77142000 sales 131868000 gross profit margin 58.50% operating profit margin (operating profit...
ey Ratio Calculations 5 1. Create a single sheet that calculates the ratios listed below based on the financial statement 2. Please see Demo 1E for suggestions on how to complete this exercise (the ratios demo may not be 6 exactly the same for this assignment. Please make sure to include the ratios listed HERE: a. Ratios: Current, Quick, Inventory Turnover, Average Collection Period, Fixed Assets Turnover Total Asset Turnover, Debt Ratio, Debt to Equity, Times Interest Earned, Gross Profit...
Questions: 1. Compute the following ratios for PAYPAL HOLDINGS INC: CURRENT RATIO QUICK RATIO CASH RATIO TOTAL DEBT RATIO DEBT EQUITY RATIO TIMES INTEREST EARNED RATIO CASH COVERAGE RATIO INVENTORY TURNOVER DAYS SALES IN INVENTORY RECEIVABLES TURNOVER DAYS SALES IN RECEIVABLES TOTAL ASSET TURNOVER CAPITAL INTENSITY PROFIT MARGIN RETURN ON ASSETS RETURN ON EQUITY PRICE EARNINGS RATIO MARKET TO BOOK RATIO 2. Decompose the ROE using the extended Du-Pont Analysis.
Liquidity Current ratio 2014 = current assets/current liabilities 204,000/89,000 = 2.292 for 2014 and 230,000/90,000 = 2.555 for 2015 Quick Ratio = current assets-inventory/current liabilities 204,000-66,000/89000= 1.550 for 2014 and 230,000-75000/90,000 = 1.722 for 2015 Accounts receivable turnover Credit sales/average debts Average debt 75000+82000/2 = 78500 Total sales = 3,199,900/78500 = 40.76 times (2015) Days sales outstanding = average accounts receivable/sales credit 78500/3199900 x 360 = 8.83 days (2015) Inventory turnover 66,000+75,000/2 = 70,500 Inventory turnover ratio = cost of...
Dana Dairy Products Key Ratios Industry Actual Actual Average 2009 2010 Current Ratio 1.3 1.0 Quick Ratio 0.8 0.75 Average collection Period 23 days 30 days Inventory Turnover 21.7 19 Debt Ratio 64.7° 50% Times Interest Earned 4.8 5.5 Gross Profit Margin 13.6 12.0% Net Profit Margin 1.0% 0.5 Return on total assets 2.9% 2.0% Return on Equity 8.2 4.0% Income Statement Dana Dairy Products For the Year Ended December 31, 2010 Sales Revenue $100,000 Less: Cost of Goods Sold...
Actual 2019 Dana Dairy Products Key Ratios Industry Actual Average 2018 Current ratio 1.3 1.0 Quick ratio 0.8 0.75 Average collection period 23 days 30 days Inventory turnover 21.7 Debt ratio 64.7% Times interest eamed 4.8 5.5 Gross profit margin 13.6% 12.0% Net profit margin 1.0% 0.5% Return on total assets 2.9% 20% Retum on equity 8.2% 4.0% 19 50% Income Statement Dana Dairy Products For the Year Ended December 31, 2019 Sales revenue $100,000 Less: Cost of goods sold...
Q-2 FINANCIAL RATIO FORMULAS Match each of the following financial ratios with its formula: Accounts Payable Tunover Ratio Fixed Asset Turnover Ratio Asset Turnover Ratio Cash Coverage Ratio Cash Ratio Current Ratio Average Age of Receivables Average Days Supply in Inventory Receivable Turnover Ratio Debt-to-Equity Ratio Earnings per Share (EPS) Financial Leverage Percentage Times Interest Earned Ratio Inventory Turnover Ratico Price/ Earnings (P/E) Ratio Profit Margin Quality of Income Quick Ratio Return on Equity (ROE) Return on Assets (ROA) A....
Ratios for Simmons IndustryBetter (B) or worse(W) Ratio Δverage Profit margin Return on assets Return on equity Receivables turnover Avg. collection period Inventory turnover Fixed asset turnover Total asset turnover Current ratio Quick ratio Debt to total assets Times interest earned Fixed charge coverage 17.5% 20.8% 35% 4.4x 68.0 days - 3.5x 2.4x -76x 1.28 .85 .45 12.0x 3.6x Given the balance sheet and income state for Simmons Maintenance ratios that are also shown for the industry average. For each...
Prepare ratio analyses (for the three year time period). You will compute the following ratios: Profitability ratios: Gross Profit margin Operating expense margin Profit margin Return on assets Return on equity Productivity ratios: Accounts Receivable Turnover Days Sales Outstanding Inventory Turnover Days inventory outstanding Accounts Payable turnover Days payable outstanding Cash Conversion Cycle PPE Turnover Coverage ratios: Total liabilities-to-equity Total debt to equity Cash from operations to total debt Times interest earned Liquidity ratios: Current Ratio Quick Ratio We were...
EXERCISE - CHAPTER 19. RATIOS: From the following Information, compute the ratios indicated and place the proper number in the blanks provided. ASSETS: Cash $10,000 Marketable Securities $15,000 Accounts Receivable, Net $20,000 Inventory $30,000 Prepaid Assets $ 5,000 Property, Plant & Equipment $100,000 Total Assets: $180,000 LIABILITIES & STOCKHOLDERS' EQUITY: Current Liabilities $20,000 Long-Term Liabilities $80,000 Stockholders' Equity $80,000 Total Liabilities & Stockholder's Equity: $180,000 Sales $200,000 Cost of Goods Sold $150.000 Gross Margin $ 50,000 Operating Expense $ 30,000...