Question

The following data are taken from or calculated from the financial statements: Current Year Preceding Year...

  1. The following data are taken from or calculated from the financial statements:

    Current Year Preceding Year
    Average accounts receivable (net) $123,000      $95,000     
    Sales on account 950,000      825,000     

    a. Assuming that credit terms on all sales are n/45, determine for each year (1) the accounts receivable turnover and (2) the number of days' sales in receivables. Round intermediate calculations to whole numbers and final answers to two decimal places.

    1. The accounts receivable turnover:

    Current Year

    Preceding Year

    2. The number of days' sales in receivables: Assume a 365-day year.

    Current Year
    days

    Preceding Year
    days

    b. Comment on any significant trends revealed by the data.

    Sales   during the current year, indicating a(n)   trend. The accounts receivable turnover has  . Based on credit terms of n/45, the current year turnover indicates that   receivables are not being collected within the 45-day period. Likewise, the number of days' sales in receivables indicates a(n)   trend.

Homework Answers

Answer #1

a)

1)

Accounts receivable turnover = Net Credit sales / Average accounts receivable

Current year = 950,000 / 123,000 = 7.72 (Approximately)

Preceding year = 825,000 / 95,000 = 8.68 (Approximately)

2)

The number of days sales in receivables = (Accounts receivable / Total credit sales) * No. of days in a year

Current year = (123,000 / 950,000) * 365 = 47.25 (or) 47 days

Preceding year = (95,000 / 825,000) * 365 = 42.03 (or) 42 days

b)

Sales INCREASED during the current year.

The accounts receivable turnover indicates a FAVOURABLE trend.

Based on credit terms of n/45, the current year turnover indicates that some receivables are not being collected within the 45-day period. (Since, number of days sales in receivables for current year is greater than 45 days)

The number of days' sales in receivables indicates UNFAVOURABLE trend. (Since, increased to 47 days from 42 days)

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
The following data are taken from the financial statements of Sigmon Inc. Terms of all sales...
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 $113,600 $120,000 $128,200 Sales on account 747,520 732,190 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 receivables days days...
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...
Accounts Receivable Analysis The following data are taken from the financial statements of Outdoor Patio Inc....
Accounts Receivable Analysis The following data are taken from the financial statements of Outdoor Patio Inc. Terms of all sales are 2/10, n/60. Year 3 Year 2 Year 1 Accounts receivable, end of year $190,200 $204,000 $219,400 Sales 1,123,470 1,100,840 a. For Years 2 and 3, determine (1) the accounts receivable turnover and (2) the number of days' sales in receivables. Assume there are 365 days in the year. Round intermediate calculations to the nearest whole dollar and final answers...
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 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...
Assignment title is: Liquidity The following financial data were taken from the annual financial statements of...
Assignment title is: Liquidity The following financial data were taken from the annual financial statements of Smith Corporation:                                   2017                      2018                   2019 Current assets     $   450,000             $   400,000           $    500,000 Current liabilities     390,000                  300,000                 340,000 Sales                     1,450,000               1,500,000             1,400,000 Cost of sales         1,180,000                1,020,000              1,120,000 Inventory                 280,000                   200,000                 250,000 Accounts receivable 120,000                  110,000                105,000 Required: Based on these data, calculate the following for 2018 and 2019 Working capital Current ratio Acid-test ratio Accounts receivable turnover Merchandise inventory turnover Inventory turnover...
Rosco Co. manufactures and markets food products throughout the world. The following sales and receivable data...
Rosco Co. manufactures and markets food products throughout the world. The following sales and receivable data were reported by Rosco for two recent years:    Year 2    Year 1 Sales $6,598,835 $6,285,300 Accounts receivable 660,650 646,050 Assume that the accounts receivable were $551,150 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 at the end of...
Use the financial data shown below to calculate the following ratios for the current year: (a)...
Use the financial data shown below to calculate the following ratios for the current year: (a) Current ratio. (b) Acid-test ratio. (c) Accounts receivable turnover. (d) Days' sales uncollected. (e) Inventory turnover. (f) Days' sales in inventory. Income statement data Sales (all on credit) $650,000 Cost of goods sold 425,000 Income before taxes 78,000 Net income 54,600 Ending Balances Beginning Balances Cash $19,500 $15,000 Accounts receivable (net) 65,000 60,000 Inventory 71,500 64,500 Plant and equipment (net) 195,000 183,900 Total assets...