A) Accounts Receivable Turnover Ratio
Year 2 | Year 3 | |
Minkey Inc | 8.95 | 12.51 |
Armer Inc | 10.77 | 12.73 |
Average Days to collect Receivables
Year 2 | Year 3 | |
Minkey Inc | 41 | 30 |
Armer Inc | 34 | 29 |
Calculations
Accounts Receivable Turnover Ratio = Net Credit Sale / Average Accounts Receivable
Average Accounts Receivable = Accounts Receivable at Beginning + Accounts Receivable at End / 2
Average Days to collect Receivables = 365 / Accounts Receivable Turnover Ratio
I) Minkey Inc for Year 2
Accounts Receivable Turnover Ratio
Net Credit Sale = 33661.1 $
Average Accounts Receivable = 4167.9 + 3358 / 2
= 3762.95 $
Accounts Receivable Turnover Ratio = 33661.1 / 3762.95
= 8.95 Times
Average Days to collect Receivables = 365 / 8.95
= 40.78 = 41 Days
Minkey Inc for Year 3
Accounts Receivable Turnover Ratio
Net Credit Sale = 45326.4
Average Accounts Receivable = 3358 + 3889.2 / 2
= 3623.6 $
Accounts Receivable Turnover Ratio = 45326.4 / 3623.6
= 12.51 Times
Average Days to collect Receivables = 365 / 12.51
= 29.18 = 30 Days
Armer Inc for Year 2
Accounts Receivable Turnover Ratio
Net Credit Sale = 3392.8
Average Accounts Receivable = 298 + 332.3 / 2 = 315.15
Accounts Receivable Turnover Ratio = 3392.8 / 315.15
= 10.77 Times
Average Days to collect Receivables = 365 / 10.77
= 33.89 = 34 Days
Armer Inc for Year 3
Accounts Receivable Turnover Ratio
Net Credit Sale = 5152.3
Average Accounts Receivable = 332.3 + 477 / 2
= 404.65
Accounts Receivable Turnover Ratio = 5152.3 / 404.65
= 12.73 Times
Average Days to collect Receivables = 365 / 12.73
= 28.67 = 29 Days
B)
(I) Change in Financial Position in Year 3 compared to Year 2 Minkey Inc
Accounts Receivable Turnover Ratio of Minkey Inc has increased from 8.95 to 12.51
Average Days to collect Receivables of Minkey Inc has decreased from 41 days to 30 days
This shows an increase in Liquidity and Improvement in Performance
(II) Change in Financial Position in Year 3 compared to Year 2 Armer Inc
Accounts Receivable Turnover Ratio of Armer Inc has increased from 10.77 to 12.73
Average Days to collect Receivables of Armer Inc has decreased from 34 days to 29 days
This shows an increase in Liquidity and Improvement in Performance
Mikey Inc. designs, develops, markets, and sells athletic footwear, apparel, equipment, and accessories worldwide. Armer Inc....
The professor wants the information in the left column for the Inductry average of footwear & accessories. Year 1 Billion 10.85 What is the industry average for tootear & accessories Ratios Year 3 Industry 2014 2 2017 2018 All Liquidity & Efficiency 2.80 2.93 1 2.51 Current ratio: * 21.396 $23.259 22.536 Current Billion 1.121 Billion Billion assets/current liabilities Billion 12.17 Billion Accounts receivable 9.99 9.34 1 10.41 9.38 turnover: Days sales uncollected: 36.54 | 39.07 135.08 Solvency Debt ratio...
Broadway Inc. recognized credit sales of $440,000 for the year ended December 31, 2020. The accounts receivable balances at December 31, 2019, and at December 31, 2020, were $39,648 and $50,600, respectively. Compute Broadway's receivable turnover ratio and its average days to collect receivables for 2020. Note: Round your answers to one decimal place (for example, enter 5.2 for 5.1555). 0 Accounts receivable turnover Average days to collect receivables 0
Need help with receiables turnover ratio and days to collect. Cola Inc. and Soda Co. are two of the largest and most successful beverage companies in the world in terms of the products that they sell and their receivables management practices. To evaluate their ability to collect on credit sales, consider the following rounded amounts reported in their annual reports (amounts in millions). Tiscal Year Ended: Net Sales Accounts Receivable Allowance for Doubtful hecounts Accounts Receivable, Net of Allowance cola...
Quasar, Inc. sells clothing, accessories, and personal care products for men and women through its retail stores. Quasar reported the following data for two recent years: Year 2 Year 1 Sales $3,228,060 $3,321,500 Accounts receivable 244,550 237,250 Assume that accounts receivable were $273,750 at the beginning of Year 1. a. Compute the accounts receivable turnover for Year 2 and Year 1. Round to one decimal place. Year 2: Year 1: b. Compute the days' sales in receivables for Year 2...
Cola Inc. and Soda Co. are two of the largest and most successful beverage companies in the world in terms of the products that they sell and their receivables management practices. To evaluate their ability to collect on credit sales, consider the following rounded amounts reported in their annual reports (amounts in millions) Fiscal Year Ended: Net Sales Accounts Receivable Allowance for Doubtful Accounts Accounts Receivable, Net of Allowance Cola Inc. 2015 2014 2013 530,819 526,190 527,444 4,388 3,723 3,051...
You are planning the audit of Buchanan, Inc., a publicly traded company that develops and markets products used in the prevention and treatment of infectious diseases. Buchanan markets two products and has eight new product candidates in various stages of development The following information for the current year is available to the auditor. All credit sales terms are 30 days BUCHANAN, INC. LIST OF FINANCIAL ITEMS AND THEIR RELATED BALANCES Average Accounts Receivable Average Inventory Average Total Assets Total Assets...
E13-7 Computing and Interpreting Selected Liquidity Ratios (LO 13-4, LO 13-5] Double West Suppliers (DWS) reported sales for the year of $200,000, all on credit. The average gross profit percentage was 30 percent on sales. Account balances follow: Accounts receivable (net) Inventory Beginning $35,000 50,000 Ending $45,000 30,000 Required: 1. Compute the following turnover ratios. 2. By dividing 365 by your ratios from requirement 1, calculate the average days to collect receivables and the average days to sell inventory. Required...
Accounts Receivable Analysis Xavier Stores Company and Lestrade Stores Inc. are large retail department stores. Both companies offer credit to their customers through their own credit card operations. Information from the financial statements for both companies for two recent years is as follows (in millions): Xavier Lestrade Sales $302,950 $423,400 Credit card receivables-beginning 54,192 43,387 Credit card receivables-ending 45,242 33,405 a. Determine the (1) accounts receivable turnover and (2) the number of days' sales in receivables for both companies. Round...
Cola Inc. and Soda Co. are two of the largest and most successful beverage companies in the world in terms of the products that they sell and their receivables management practices. To evaluate their ability to collect on credit sales, consider the following rounded amounts reported in their annual reports (amounts in millions). Cola Inc. Soda Co. Fiscal Year Ended: 2015 2014 2013 2015 2014 2013 Net Sales $39,319 $35, 190 $35,944 $61,938 $47,432 $47, 251 Accounts Receivable 4,578 3,893...
Presented below is information for Sheffield Company. 1. Beginning of-the year Accounts Receivable balance was $21,500. Net sales (all on account) for the year were $109,100. Sheffield does not offer cash discounts 2. Collections on accounts receivable during the year were $88,900. 3. Prepare (summary) journal entries to record the items noted above. (If no entry is required, select "No Entry" for the account titles and enter 0for the amounts Credit account tities are automatically indented when the amount is...