Question

Given the following data for 20Y1, select the correctly calculated financial ratio. Accounts Receivable on 1/1/20Y1...

Given the following data for 20Y1, select the correctly calculated financial ratio.

Accounts Receivable on 1/1/20Y1 $850,000
Accounts Receivable on 12/31/20Y1 $950,000
Inventory on 1/1/20Y1 $150,000
Inventory on 12/31/20Y1 $190,000
Net Credit Sales for 20Y1 $4,100,000
Cost of Goods Sold for 20Y1 $1,000,000

Accounts Receivable turns over 6 times per year.

The average collection period of accounts receivable is every 80 days.

Inventory is held an average of 38 days before it is sold.

Inventory turns over 9.55 times per year.

Homework Answers

Answer #1
Accounts Receivable on 1/1/20Y1 $850,000
Accounts Receivable on 12/31/20Y1 $950,000
Average accounts receivable (Accounts Receivable on 1/1/20Y1 + Accounts Receivable on 12/31/20Y1)/2 $900,000
Net Credit Sales for 20Y1 $4,100,000
Accounts receivable turnover ( Net credit sales / Average accounts receivable) 4.56
Average collection period (365/Accounts receivable turnover) 80
Inventory on 1/1/20Y1 $150,000
Inventory on 12/31/20Y1 $190,000
Average inventory ( Inventory on 1/1/20Y1+Inventory on 12/31/20Y1)/2 $170,000
Cost of Goods Sold for 20Y1 $1,000,000
Inventory turnover (Cost of good sold/Average inventory) 5.88
Days in inventory (365/Inventory turnover) 62

The average collection period of accounts receivable is every 80 days

Second option is correct.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Given the following data for 20Y1, select the correctly calculated financial ratio. Accounts Receivable on 1/1/20Y1...
Given the following data for 20Y1, select the correctly calculated financial ratio. Accounts Receivable on 1/1/20Y1 $274,000 Accounts Receivable on 12/31/20Y1 1. $240,000 Inventory on 1/1/20Y1 2. $70,000 Inventory on 12/31/20Y1 $90,000 3. Net Credit Sales for 20Y1 $2,100,000 4. Cost of Goods Sold for 20Y1 $1,500,000 Accounts Receivable turns over 8.75 times per year. The average collection period of accounts receivable is every 41 days. Inventory is held an average of 38 days before it is sold. I nventory...
The following data are taken from the financial statements of Rainsberger Company. 2018 2017 Accounts receivable...
The following data are taken from the financial statements of Rainsberger Company. 2018 2017 Accounts receivable (net), end of year $590,000 $505,000 Net sales on account 4,100,000 3,200,000 Terms for all sales are 1/10, n/60. Compute for each year the accounts receivable turnover. At the end of 2016, accounts receivable (net) was $515,000. (Round answers to 1 decimal place, e.g. 1.6.) 2018 2017 Accounts receivable turnover times times Compute for each year the average collection period. At the end of...
Accounts Receivable Analysis The following data are taken from the financial statements of Sigmon Inc. Terms...
Accounts Receivable Analysis The following data are taken from the financial statements of Sigmon Inc. Terms of all sales are 2/10, n/45. 20Y3 20Y2 20Y1 Accounts receivable, end of year $135,400 $142,000 $150,000 Sales on account 901,550 861,400 a. For 20Y2 and 20Y3, determine (1) the accounts receivable turnover and (2) the number of days' sales in receivables. Round answers to one decimal place. Assume a 365-day year. 20Y3 20Y2 1. Accounts receivable turnover 2. Number of days' sales in...
Accounts Receivable Analysis The following data are taken from the financial statements of Sigmon Inc. Terms...
Accounts Receivable Analysis The following data are taken from the financial statements of Sigmon Inc. Terms of all sales are 2/10, n/45. 20Y3 20Y2 20Y1 Accounts receivable, end of year $725,000 $650,000 $600,000 Sales on account 5,637,500 4,687,500 a. For 20Y2 and 20Y3, determine (1) the accounts receivable turnover and (2) the number of days' sales in receivables. Round interim calculations to the nearest dollar and final answers to one decimal place. Assume a 365-day year. 20Y3 20Y2 1. Accounts...
Accounts receivable analysis The following data are taken from the financial statements of Sigmon Inc. Terms...
Accounts receivable analysis The following data are taken from the financial statements of Sigmon Inc. Terms of all sales are 2/10, n/45.    20Y3 20Y2    20Y1 Accounts receivable, end of year $725,000 $660,000 $600,000 Sales on account 5,638,000 4,528,000 This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Open spreadsheet a.) For 20Y2 and 20Y3, determine (1) the accounts receivable turnover and...
The following data exists for Crane Company. 2022 2021 Accounts Receivable $84,000 $78,000 Net Sales 563,000...
The following data exists for Crane Company. 2022 2021 Accounts Receivable $84,000 $78,000 Net Sales 563,000 415,000 Calculate the accounts receivable turnover and the average collection period for accounts receivable in days for 2022. (Round answers to 1 decimal place, e.g. 15.2. Use 365 days for calculation.) Accounts receivable turnover Enter the accounts receivable turnover in times times Average collection period Enter the average collection period in days days
Accounts receivable at the end of year 1 was $50,000 and its accounts receivable at the...
Accounts receivable at the end of year 1 was $50,000 and its accounts receivable at the end of year 2 was $100,000. Inventory at the end of year 2 was $70,000 and its inventory at the end of year 1 was $120,000. The company’s sales on account for year 2 is closest to what amount if the average collection period is 20 days. Please show all work.
Accounts Receivable and Inventory Turnover The following data (in millions) were adapted from recent financial statements...
Accounts Receivable and Inventory Turnover The following data (in millions) were adapted from recent financial statements of Apple Inc (AAPL). Year 2 Year 1 Sales $233,715 $182,795 Cost of goods sold 140,089 112,258 Operating income 71,230 52,503 Average accounts receivable 33,713 27,816 Average inventory 2,230 1,938 1. Compute the accounts receivable turnover for Years 1 and 2. Round to one decimal place. Accounts Receivable Turnover Year 2 Year 1 2. Compute the number of days' sales in receivables for Years...
The following data exists for Ivanhoe Company. 2022 2021 Accounts Receivable $85,000 $77,000 Net Sales 561,000...
The following data exists for Ivanhoe Company. 2022 2021 Accounts Receivable $85,000 $77,000 Net Sales 561,000 477,000 Calculate the accounts receivable turnover and the average collection period for accounts receivable in days for 2022. (Round answers to 1 decimal place, e.g. 15.2. Use 365 days for calculation.) Accounts receivable turnover times Average collection period days
the following data exists for Carley Company. 2018 2017 Accounts Receivable $50,000 $70,000 Net Sales 500,000...
the following data exists for Carley Company. 2018 2017 Accounts Receivable $50,000 $70,000 Net Sales 500,000 410,000 Calculate the accounts receivable turnover and the average collection period for accounts receivable in days for 2018. (Use 365 days for calculation. Round answers to 1 decimal place, e.g. 15.2.) Accounts receivable turnover times Average collection period days   
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT