1 | Acid Test Ratio = (Current Assets excluding Inventory )/ Current Liabilities | ||||||||
In given Question, | |||||||||
Current Assets excluding inventory are: | |||||||||
2018 | 2017 | ||||||||
Total Current Assets | 283000 | 288000 | |||||||
Less: Inventory | 196000 | 192000 | |||||||
Current Assets excluding inventory are: | 87000 | 96000 | A | ||||||
Total Current liabilities | 112000 | 114000 | B | ||||||
Acid test ratio | 0.78 | 0.84 | (A/B) | ||||||
Acid test ratio Algonquin's is more than industry average in 2017 which shows that company has good liquidity position than required by industry. However in 2018, company liquidiy position gets weaker with a small change but stills its hovers around industry average. Overall we can say company is maintaining good liquidity position. | |||||||||
2 | Accounts Receivable Turnover = Annual Credit Sales / Accounts Receivable | ||||||||
2018 | 2017 | ||||||||
Annual Credit Sales | 700600 | 733000 | |||||||
Accounts Receivables (Net) | 55000 | 69000 | |||||||
AR Turnover ratio | 12.74 | 10.62 | |||||||
AR Turnover ratio shows that no. of times during the period cash collection cycle is going on. In both years company has more AR t/o ration than industry average which shows a strong liquidity position. | |||||||||
3 | Days sales in receivable = Accounts Receivable / Total Credit Sale * 365 days | ||||||||
2018 | 2017 | ||||||||
Accounts Receivables (Net) | 55000 | 69000 | |||||||
Annual Credit Sales | 700600 | 733000 | |||||||
DAYS SALES IN RECEIVABLE | 28.65 | 34.36 | |||||||
Days sales in receivable is decreased in 2018 which is a good sign of maintaining and improving liquidity position. Also when it compares with industry average it shows a steady improvement. |
Requirement 1. Calculate Algonquin's acid-test ratio for 2018. (Round to two decimals.) Determine y aver i...
Comanche Carpets reported the following amounts in its 2018 financial statements. The 2017 figures are given for comparison (Click the icon to view the comparative financial information.) Read the requirements Requirement 1. Calculate Comanche's acid-test ratio for 2018. (Round to two decimals.) Determine whether Comanche's acid-test ratio improved or deteriorated from 2017 to 2018. How does Comanche's acid-test ratio compare with the industry average of 0.80? (Abbreviations used: Cash Cash including cash equivalents: ST invest short-term investments. Round the acid...
LIIOIIVIT < 8 of 9 (1 complete) financial statements. The 2017 figures are given for comparison Data Table 3. (Rou g cash 8. How 2018 2017 Balance sheet-partial Current Assets: Cash Short-term Investments Accounts Receivable $ $ 13,500 10,000 $ 59,000 (8,000) 7,500 21,000 $ 51,000 195,000 3,000 72,000 (7,000) Less: Allowance for Bad Debts Merchandise Inventory Prepaid Insurance Total Current Assets Total Current Liabilities Income statement partial Not Sales (all on account) 65,000 191,000 3,000 282,500 105,000 277,500 103,000...
Requirement 1. Compute PilgrimPilgrim's quick (acid-test) ratio at the end of 20192019. Round to two decimal places. How does the quick ratio compare with the industry average of 0.92? Begin by selecting the formula, then enter the amounts and compute the quick (acid-test) ratio. (Abbreviation used: Cash* = Cash and cash equivalents. Round the quick (acid-test) ratio to two decimal places.) Cash* + Short-term investments + Net current receivables / Total current liabilities = Quick (acid-test) ratio 104000 / 104000...
1 Requirements Calculate the following ratios for 2018 and 2017. When calculating days, round your answer to the nearest whole number a. Current ratio b. Quick (acid-test) ratio c. Inventory turnover and days' inventory outstanding (DIO) d. Accounts receivable turnover e. Days' sales in average receivables or days' sales outstanding (DSO) f. Accounts payable turnover and days' payable outstanding (DPO). Use 1. cost of goods sold in the formula for accounts payable turnover. g. Cash conversion cycle (in days) (When...
Homework: HW assigned 11/4 due 11/6 Score: 0 of 1 pt 8 of complete) HW Score: 77.67%. 6.21 E8-26 (similar to) Question Hels Abanaki Carpets reported the following amounts in its 2018 financial statements. The 2017 figures are given for comparison Click the icon to view the comparative financial information) Read the requirements Requirement 1. Calculate Abanaki's acid-test ratio for 2018. (Round to two decimals ) Determine whether Abank's acid-test improved or deteriorated 2017 to 2018. How does Abanaki's acid-test...
Instructions For 2017 and 2018, calculate current ratio, quick (acid-test) ratio, inventory turnover and days' inventory outstanding (DIO), accounts receivable turnover, days' sales in average receivables or days' sales outstanding (DSO), accounts payable turnover, days' payable outstanding (DPO), and cash conversion cycle (in days). a. Use the cost of goods sold in the formula for accounts payable turnover. b. Use a 365-day year for calculations as needed. c. Use cell references from prior calculations, if applicable. (Always use cell references...
Instructions For 2017 and 2018, calculate current ratio, quick (acid-test) ratio, inventory turnover and days' inventory outstanding (DIO), accounts receivable turnover, days' sales in average receivables or days' sales outstanding (DSO), accounts payable turnover, days' payable outstanding (DPO), and cash conversion cycle (in days). a. Use the cost of goods sold in the formula for accounts payable turnover. b. Use a 365-day year for calculations as needed. c. Use cell references from prior calculations, if applicable. (Always use cell references...
Lindsey Shepherd & Save Homework: Chapter 8 Homework Score: 0 of 5 pts + P8-34A (similar to) 6 of 6 (5 complete) HW Score: 75.93%, 21.26 of 28 pt Question Help The comparative financial statements of Lomax Cosmetic Supply for 2018, 2017, and 2016 include the data shown here: (Click the icon to view the comparative financial data.) Read the requirements Requirement 1a. Compute the acid-test ratio for 2018 and 2017. (Round to two decimals.) (Abbreviations used: Cash Cash including...
Question Help The comparative financial statements of Norfolk Cosmetic Supply for 2018, 2017 and 2016 include the data shown here (Click the icon to view the comparative financial data.) Read the requirements Requirement 1a. Compute the acid-test ratio for 2018 and 2017. (Round to two decimals.) (Abbreviations used: Cash short-term investments. Round the acid test ratios to two decimals, XXX) Cash including cash equivalents: ST invest. = Acid-test ratio 2018 2017 © Data Table emer com 2018 2017 2016 me...
i Requirements 1. 2. Compute Creative's days' sales in receivables for 2018. (Round to the nearest day.) Suppose Creative's normal credit terms for a sale on account are 2/10, net 30. How well does Creative's collection period compare to the company's credit terms? Is this good or bad for Creative? Print Done Creative Media Sign Incorporated sells on account. Recently. Creative reported the following figures: $ Net Credit Sales Net Receivables at end of year 2018 580,800 $ 38,900 2017...