Question

In: Accounting

Calculate the following ratios (Please show the formula & your calculations). Current ratio Quick ratio Receivable...

Calculate the following ratios (Please show the formula & your calculations).

Current ratio

Quick ratio

Receivable turnover

Days' sales uncollected

Interest coverage ratio

Profit margin

Price/earnings (P/E) ratio

Balance Sheet

December 31, 20X7 & 20X6

Assets 20X7 20X6

Cash $ 15,000   17,000

Marketable securities 10,000 10,000

Accounts receivable (net) 20,000 22,000

Inventory 30,000 27,000

Prepaid expenses 8,000 9,000

Property, plant, and equipment 117,000 117,000

Total assets $200,000 202,000

Liabilities and Stockholders' Equity

Current liabilities $ 30,000 27,000

Long-term liabilities 61,000 56,000

Stockholders' equity 109,000 119,000

Total liabilities and stockholders' equity $200,000 202,000

Income Statement

For the Year Ended December 31, 20X7 & 20X6

Net sales $160,000 150,000

Cost of goods sold 120,000 118,000

Gross margin $ 40,000 32,000

Operating expenses

Selling and administrative expenses $ 16,000 23,000

Interest expense 8,000 7,750

Income taxes expense 4,000 28,000 250

Net income $ 12,000 1,000

Solutions

Expert Solution


Related Solutions

Find the following financial ratios for Smolira Golf Corp. Short-term solvency ratios Current ratio Quick ratio...
Find the following financial ratios for Smolira Golf Corp. Short-term solvency ratios Current ratio Quick ratio Cash ratio Asset turnover ratios Total asset turnover Inventory turnover Receivables turnover Long-term solvency ratios Total debt ratio Equity multiplier Times interest earned ratio Cash coverage ratio Profitability ratios Profit margin Return on assets Return on equity Smolira Golf Corp Balance Sheets as of December 31,2001 and 2002 2001 2002 2001 2002 Assets Liabilities & Equity Current assets Current liabilities Cash $650 $710 Accounts...
Calculate the value of inventory given the following information: current ratio = 2.20; quick ratio =...
Calculate the value of inventory given the following information: current ratio = 2.20; quick ratio = 1.80; current assets = $275. a. 50 b. 60 c. 80 d. 70 e. 40
The financial statements for Tyler​ Toys, Inc.  Calculate the current​ ratio, quick​ ratio, and cash ratio...
The financial statements for Tyler​ Toys, Inc.  Calculate the current​ ratio, quick​ ratio, and cash ratio for Tyler Toys for 2013 and 2014. Should any of these ratios or the change in a ratio warrant concern for the managers of Tyler Toys or the​ shareholders? Tyler Toys, Inc. Income Statement for Years Ending December 31, 2013 and 2014 2014 2013 Revenue $14,147,946 $13,566,699 Cost of goods sold $-8,447,605 $-8,132,285 Selling, general, and administrative expenses $-997,233 $-980,532 Depreciation $-1,497,455 $-1,472,391 EBIT...
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...
Comprehensive analysis of Wal-Mart and Target, compute the four ratios; current ratio, quick ratio, liabilities to...
Comprehensive analysis of Wal-Mart and Target, compute the four ratios; current ratio, quick ratio, liabilities to equity, times earned. Current Ratio                                 2018        2017 Walmart                                        0.75:1     0.86:1 Target                                           0.95:1     0.94:1 Quick Ratio                                  2018        2017 Walmart                                       0.20:1     0.21:1 Target                                          0.29:1     0.28:1 Total liabilities to equity            2018          2017 Walmart    1.62times 1.55times Target 2.33times 2.41times    Times interest earned                      2018              2017 Walmart                                     7.490.5times   9.659.5times Target                                         6.475.5times 4.949.5times -          Which company is more liquid? More solvent? -          Compare the liabilities to equity ratio, do...
CURRENT RATIO What is the formula? Current assets/current liabilities pg 51 Calculate the ratio current year....
CURRENT RATIO What is the formula? Current assets/current liabilities pg 51 Calculate the ratio current year. Page________ 7266/10132=.72 Calculate the ratio for the prior year. Page_______ 8753/9501=.92 Analyze the ratio trend. 2. RETURN ON ASSETS What is the formula? net income/avg total assets Calculate the ratio current year. 10990/((120,232)=9.15% Page_______19_ Calculate the ratio for the prior year. Page_______ 3642/(120,480)=3.02% Analyze the ratio trend. 3. RECEIVABLE TURNOVER RATIO What is the formula?Net credit Sales/Average Account Receivable Calculate the ratio current year....
tow overall conclusions draw from the numbers ( Walmart) Liquidity ratios Current ratio= 79.98% Quick ratio=...
tow overall conclusions draw from the numbers ( Walmart) Liquidity ratios Current ratio= 79.98% Quick ratio= 20.22% Leverage ratio Debt to equity ratio= 1.59% Debt to total asset ratio= 60.48% Activity ratio Inventory turnover= 11.43% Total asset turnover= 2.45% Profitability Net profit margin = 1.97% ROA= 4.82% Growth ratio Sales= 2.86% Net income= Walmart annual net income for 2018 was $9.862B, a 27.71% decline from 2017 i apologize if I do not explain it clearly can you help me to...
Tours Company Ratios: Current Ratio = 1.30 Quick Ratio =  0.84 Average Collection Period =  72 Days Fixed...
Tours Company Ratios: Current Ratio = 1.30 Quick Ratio =  0.84 Average Collection Period =  72 Days Fixed Assets Turnover =  1.15 times Return On Equity = 0.142 The sector in which Tour operates has the following ratios: Current ratio                           1.26 Quick ratio                              0.8 Average collection period      72 Fixed assets turnover ratio      1.10 Return on Equity                    0.45 Comment on the financial performance of Tours?
4.  Problem 3-12 (Comprehensive Ratio Calculations) Comprehensive Ratio Calculations The Kretovich Company had a quick ratio of...
4.  Problem 3-12 (Comprehensive Ratio Calculations) Comprehensive Ratio Calculations The Kretovich Company had a quick ratio of 1.3, a current ratio of 4.0, a days sales outstanding of 36.5 days (based on a 365-day year), total current assets of $900,000, and cash and marketable securities of $110,000. What were Kretovich's annual sales? Do not round intermediate calculations. Round your answer to the nearest dollar. $ ______________
Task To calculate and analyze the current and quick (acid-test) ratios of different businesses. Potz and...
Task To calculate and analyze the current and quick (acid-test) ratios of different businesses. Potz and Pans, a small gift shop, has current assets of $45,000 (including inventory valued at $30,000) and $9,000 in current liabilities. WannaBees, a specialty clothing store, has current assets of $150,000 (including inventory valued at $125,000) and $85,000 in current liabilities. Both businesses have applied for loans. Click the “See all calculators” link at bankrate.com and then click on “Small Business” to answer the following...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT