Current Ratio: 5
Quick Ratio: 1.8
Inventory Turnover: 7
Total Current Assets: $340,000
Cash: $43,000
COGS = 80% of Sales
Required:
Required 1 : |
Total Sales for the Year = $ 1,904,000 |
Explanation : |
Current ratio = Total Current Assets / Total Current Liabilities |
Here, Total Current Assets = $ 340,000 (Given ) |
Current ratio = Total Current Assets / Total Current Liabilities |
5 Times = $ 340,000 / Total Current Liabilities |
Total Current Liabilities = $ 340,000 / 5 Times |
Total Current Liabilities = $ 68,000 |
Quick Ratio = Quick Assets / Total Current Liabilities |
1.8 Times = Quick Assets / $ 68,000 |
Quick Assets = $ 68,000 *1.8 Times |
Quick Assets = $ 122,400 |
Here, Quick Assets = Cash + Accounts Receivable |
Cash = $ 43,000 (Given ) |
Quick Assets = Cash + Accounts Receivable |
$ 122,400 = $ 43,000 + Accounts Receivable |
Accounts Receivable = $122,400 - $43,000 |
Accounts Receivable = $79,400 |
Here, Inventory = Total Current assets - Quick Assets |
Inventory = $ 340,000 - $122,400 |
Inventory = $ 217,600 |
Inventory Turnover = Cost of goods sold / Average Inventory |
Here, Inventory is treated as Average Inventory |
Inventory Turnover = Cost of goods sold / Average Inventory |
7 Times = Cost of goods sold / $ 217,600 |
Cost of goods sold (COGS)= $217,600* 7 Times |
Cost of goods sold (COGS)= $1,523,200 |
Here Cost of goods sold = 80% of Sales , |
So, Total Sales = $ 1,523,200*100/80 |
Total Sales = $ 1,904,000 |
Required 2 : |
Days Sales Outstanding = 15.22 Days (Rounded to 2 decimals ) |
Explanation : |
Days Sales Outstanding = (Account Receivable / Total Sales )*Number of days in a year |
Here, It is assumed that Number of days in a Year = 365 Days |
Here, It is assumed That Total Sales is treated as Credit Sales |
Days Sales Outstanding = (Account Receivable / Total Sales )*Number of days in a year |
Days Sales Outstanding = ($ 79,400 / $1,904,000 )* 365 Days |
Days Sales Outstanding = 15.22 Days (Rounded to 2 decimals ) |
The following information is for ABC Ltd. for the last financial year Current Ratio: 5...
just a quick summary answer A. The following ratios are reproduced from Morningstar for four Australian companies in the same industry. Comment briefly on their performance from the point of view of a lender and make a ranking of their desirability as clients. Company A 30/06/2016 30/06/2017 30/06/2018 30/06/20194 30/06/20202 36.76 24.67 24.68 23.92 27.342 ROE Inventory Turnovere Current Ratio Quick Ratio Gearing 7.242 1.572 0.35 2.45 6.54 1.32 0.352 2.872 7.69 1.32 0.35 2.632 82 1.38 0.42 2.442 10.712...
The following information is for DE Ltd. for the last financial year Current Ratio: 5 Quick Ratio: 1.8 Inventory Turnover: 7 Total Current Assets: $340,000 Cash: $43,000 COGS = 80% of Sales Required: What were the total sales for the year? How many day’s sales were outstanding in Accounts Receivable?
Ratio Sustainable Technologies Comparison to Industry Example: Current ratio .7418 Less than median. Quick ratio 0.3900 Less than the median Cash ratio 0.1496 Less than the median. Total asset turnover 2.014 Inventory turnover 27.34 More than the upper quartile More than the upper quartile More than the upper quartile Receivables turnover 54.915 0.7477 Less than the median Debt-to-equity ratio Equity multiplier 1.748 Less than the median Times interest earned 6.365 Less than the median Cash coverage 9.227 Less than the...
I created a schedule of the ratio analysis with the information given. I am missing three ratios. I need to show work and find: 'Quality of Income' and 'Times interest earned ratio' and 'cash coverage ratio'. Use the photos to help find those three ratios. Blue Water Prime Fish Balance sheet: $ 42,100 $ Cash Accounts receivable (net) 19,900 34,300 43,500 Inventory 93,500 46,600 156,500 414,200 Property & equipment (net) Other assets 85,100 316,000 Total assets $ 831,000 $ 420,700...
An analysis of last year's financial statements produced the following results. 3.6 78.0 days Current ratio Quick ratio Average collection period Inventory turnover Fixed asset turnover Operating profit margin Net profit margin Return on assets Return on equity Debt ratio Times-interest-earned Payout ratio 11.946 6.146 8.996 13.7% 35.5 9.3% 41.4% Use the following data to compute the comparable financial ratios for next fiscal year. Has the film's financial position changed Current assets Cash and short-term investments Accounts receivable Inventory Plant...
The following financial data relate to Big Bang Pty Ltd for the years ended 30 June Year 2019 and 30 June Year 2018. Financial item 30 June Year 2019 Year 2018 $630 000 $490 000 Net credit sales Cost of goods sold Cash 290 000 250 000 12 000 18 000 Accounts receivable 70 000 60 000 130 000 Inventory 150 000 Current liabilities 105 000 81 000 Additional information: The amount of Accounts receivables at 30 June Year 2017...
The current year financial statements for Blue Water Company and Prime Fish Company are presented below. Blue Water Prime Fish Balance sheet: Cash Accounts receivable (net) Inventory Property & equipment (net) Other assets Total assets Current liabilities Long-term debt (interest rate: 10%) Capital stock $10 par value) Additional paid-in capital Retained earnings Total liabilities and stockholders' equity Income statement: Sales revenue (1/3 on credit) Cost of goods sold Operating expenses Net income Other data: Per share stock price at end...
The current year financial statements for Blue Water Company and Prime Fish Company are presented below. Blue Water Prime Fish Balance sheet: Cash Accounts receivable (net) Inventory Property & equipment (net) Other assets Total assets 21,000 31,000 40,000 401,000 305,000 $ 798,000 49,000 60,000 512,000 106,000 71,000 $ 798,000 $ 41,000 38,000 99,000 140,000 84,000 $ 402,000 99,000 65,000 148,000 29,000 61,000 $ 402,000 $ Current liabilities $ Long-term debt (interest rate: 10%) Capital stock ($10 par value) Additional paid-in...
The following financial data relate to Big Bang Pty Ltd for the years ended 30 June Year 2019 and 30 June Year 2018. Year 2018 $490 000 250 000 $630 000 Net credit sales Cost of goods sold Cash Accounts receivable 290 000 12 000 18 000 60000 70 000 150 000 81 000 130 000 Inventory Current liabilities 105 000 Additional information: The amount of Accounts receivables at 30 June Year 2017 was $78 000 (net). The inventory figure...
what is the current ratio? 0 D E F 6/30/15 A B 1 Microsoft Corporation 2 Balance Sheet 3 (Thousand $) 4 5 Period Ending 6/30/17 6/30/16 6 7 Cash And Cash Equivalents 7,663,000 6,510,000 8 Short Term Investments 125,318,000 106,730,000 9 Net Receivables 19,792,000 18,277,000 10 Inventory 2,181,000 2,251,000 11 Other Current Assets 4,897,000 5,892,000 12 Total Current Assets 159,851,000 139,660,000 13 Long Term Investments 6,023,000 10,431,000 14 Property Plant and Equipment litie 23,734,000 18,356,000 15 Goodwill 35,122,000 17,872,000...