Question

In: Accounting

2017 2016 Current Ratio (Working Capital )              5.78           5.18 Quick Ratio      &nbs

2017 2016
Current Ratio (Working Capital )              5.78           5.18
Quick Ratio              4.90           4.60
A/R Turnover 5.91 5.53
Inventory Turnover 104.96 92.72
Gross margin 68% 66%
Return on Sales 53% 52%
Return on Equity 9% 6%
Return on Assets 1% 1%

Compare ratio analysis to trends in financial ratios over time for illustrating their impact, providing examples to support your claims.


Solutions

Expert Solution

.A. LIQUIDITY

1.Current Ratio:

Working Capital=Current asset-Current liabilities

Current Ratio=(Current assets)/(Current Liabilities)

In this case current ratio increased from 5.18 to 5.78.This indicates that the current asset has increased relative to current liabilities. Working capital reduced. Increase in current ratio indicates increase in liquidity . The company is in a better position to meet its short term liabilities.

2. Quick ratio=(Quick Assets)/(Current Liabilities)

Quick assets=Cash+ Marketable securities+ Accounts receivable

Quick Ratio increased from 4.60 to 4.90. Immediate available cash(Quick assets) increased relative to current liabilities. This indicates that the company is in a better position to meet its immediate liabilities.

The overall liquidity has improved and we expect the company to meet its current and immediate liabilities better

.B OPERATING EFFICIENCY

3. Accounts Receivable Turnover=( sales)/(Average accounts receivable)

Accounts Receivable Turnover increased from 5.53 to 5.91. This indicates that efficiency of collection process increased and the accounts receivable in terms of days of sales decreased

4.Inventory turnover=Cost of goods sold/Average inventory

Inventory turnover increased from 92.72 to 104.96. Hence Average inventory decreased relative to cost of goods sold.

This indicates that efficiency of inventory management   increased and the inventory in terms of days of consumption decreased

The overall operations efficiency has improved and we expect the company to manage with lower working capital resulting in higher profitability.

C PROFITABILITY

5.Gross margin= Gross Profit/Sales

Gross Profit=Sales – Cost of goods sold

Gross margin increased from 66% to68%.

This indicates increase in gross profit relative to sales. The profitability at gross level increased

6. Return on Sales= Net Income /Sales.

Return on sales increased from52% to 53%.This means Net income relative to sales has improved indicating higher profitability.

7.Return on Equity=Net Income/Stockholders equity

Return on Equity increased from 6% to 9%.This indicates increased profitability and higher return to stockholders

8. Return on Assets= Net income/Total Assets.

Return on Assets remained constant at 1%.

This indicates that though there is increase in net income ,there was proportionate increase in total assets ,keeping the ratio constant. Efficiency of utilization of assets remains constant


Related Solutions

Effect of Transactions on Working Capital, Current Ratio, and Quick Ratio The following account balances are...
Effect of Transactions on Working Capital, Current Ratio, and Quick Ratio The following account balances are taken from the records of Liquiform Inc.: Cash $ 70,000 Short-term investments 60,000 Accounts receivable 80,000 Inventory 100,000 Prepaid insurance 10,000 Accounts payable 75,000 Taxes payable 25,000 Salaries and wages payable 40,000 Short-term loans payable 60,000 Required: 1. Use the information provided to compute the amount of working capital and Liquiform's current and quick ratios (round to two decimal points). Working capital $ Current...
Ratio 2017 2016 Industry Average Current Ratio 1.8 1.9 2.2 Quick Ratio 0.5 0.4 0.3 Inventory...
Ratio 2017 2016 Industry Average Current Ratio 1.8 1.9 2.2 Quick Ratio 0.5 0.4 0.3 Inventory Turnover 4.9 4.8 4.3 times Days Sales Outstanding 7.4 6.3 5.1 days Fixed Asset Turnover 83.4 86.5 51.6 Total Asset Turnover 1.4 1.4 3.8 Debt Ratio (Debt/Assets) 83.77% 79.59% 29.45% Times Interest Earned 2.8 3.2 15 Net Profit Margin 2.98% 3.50% 1.52% Return on Assets 4.10% 4.95% 4.00% Equity Multiplier 2.6 2.5 0.9 DuPont Equation (ROE) 139 168.25 5.20% Complete both a trend and...
For company Exxon Mobil stock symbol XOM Liquidity (current ratio, quick ratio, and net working capital-to-sales...
For company Exxon Mobil stock symbol XOM Liquidity (current ratio, quick ratio, and net working capital-to-sales ratio) Operating performance ratio (Days of Sales in Inventory, Days of Sales in Receivables), turnovers Profitability ratios (Gross Profit Margin, Operating Profit Margin, Net Profit Margin) Return on Investment ratios: (Basic Earning Power ratio, ROA, ROE) You can find financial ratios for the company for the last 3-5 years in the Internet (www.morningstar.com) a) Present the ratios as the table(s) in your project. Create...
Ratios: Current Ratio: 3.6093 Quick Ratio:                           2.1799 Times Interest Earned: 9.9143 ROE &nbs
Ratios: Current Ratio: 3.6093 Quick Ratio:                           2.1799 Times Interest Earned: 9.9143 ROE                                        16.48% ROA                                        12.01% Equity Multiplier                    1.3714 Inventory Turnover 1.3489 The DuPont Identity helps us to better understand why a firm might have a poor ROE (Return on Equity).  We can write the DuPont Identity as follows: ROE = (Net Income / Sales)(Sales / Assets)(Assets / Owner's Equity) Based on this, which of the following statements are true? Select one: a. If Sales remained constant but Net Income fell, the ROE would rise, ceteris...
1.      Holmes Inc. has a quick ratio of 0.70, current liabilities of $21,500, net working capital...
1.      Holmes Inc. has a quick ratio of 0.70, current liabilities of $21,500, net working capital of $1200, and sales of $14,500. How much does it have in inventory? 2.      Watson Co. has net income of $235,000, a return on assets of 12.5%, and a debt-equity ratio of 0.52. What is its return on equity? 3.      Lestrade Plc. has net income of $16,000 and a profit margin of 8%. It also had costs (including depreciation) of $154,000 and a tax...
SDJ, Inc., has net working capital of $1,965, current liabilities of $5,460, and inventory of $2,170. What is the current ratio? What is the quick ratio?
Calculating Liquidity Ratios SDJ, Inc., has net working capital of $1,965, current liabilities of $5,460, and inventory of $2,170. What is the current ratio? What is the quick ratio?Net Working Capital$      1,965.00Current Liabilities$      5,460.00Inventory$      2,170.00Current RatioQuick Ratio03.04 Calculating Inventory Turnover Bobaflex Corporation has ending inventory of $527,156 and cost of goods sold for the year just ended was $8,543,132. What is the inventory turnover? The days’ sales in inventory? How long on average did a unit of inventory sit on...
1) Company's Current ratio 2017 Current ratio = 2.055 2016 Current ratio = 2.077 Explain what...
1) Company's Current ratio 2017 Current ratio = 2.055 2016 Current ratio = 2.077 Explain what information this ratio provides (define), and what the results mean specifically to your company. Use complete sentences in your own words. Has the current ratio improved?_________________________ 2) Company's Debt ratio 2017 Debt Ratio =0.417987 = 41.799% 2016 Debit Ratio = 0.415240 = 41.524% Explain what information this ratio provides (define), and what the results mean specifically to your company Use complete sentences Has the...
1) Company's Current ratio 2017 Current ratio = 2.055 2016 Current ratio = 2.077 Explain what...
1) Company's Current ratio 2017 Current ratio = 2.055 2016 Current ratio = 2.077 Explain what information this ratio provides (define), and what the results mean specifically to your company. Use complete sentences in your own words. Has the current ratio improved?_________________________ 2) Company's Debt ratio 2017 Debt Ratio =0.417987 = 41.799% 2016 Debit Ratio = 0.415240 = 41.524% Explain what information this ratio provides (define), and what the results mean specifically to your company Use complete sentences Has the...
1) Company's Current ratio 2017 Current ratio = 2.055 2016 Current ratio = 2.077 Explain what...
1) Company's Current ratio 2017 Current ratio = 2.055 2016 Current ratio = 2.077 Explain what information this ratio provides (define), and what the results mean specifically to your company. Use complete sentences in your own words. Has the current ratio improved?_________________________ 2) Company's Debt ratio 2017 Debt Ratio =0.417987 = 41.799% 2016 Debit Ratio = 0.415240 = 41.524% Explain what information this ratio provides (define), and what the results mean specifically to your company Use complete sentences Has the...
Working capital: Mukhopadhya Network Associates has a current ratio of 1.60, where the current ratio is...
Working capital: Mukhopadhya Network Associates has a current ratio of 1.60, where the current ratio is defined as follows: Current ratio = Current assets/Current liabilities. The firm's current assets are equal to $1,233,265, its accounts payables are $419,357, and its notes payables are $351,663. Its inventory is currently at $721,599. The company plans to raise funds in the short-term debt market and invest the entire amount in additional inventory. How much can note payable increase without the current ratio falling...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT