Inventory:
Inventory is an asset of the company which includes work in progress, raw material and finished goods which are in the process of making or already ready to be sold in the market. In other words inventory is goods which are unsold and would be sold.
To compute: Day’s sales uncollected as of A Company and G Company and analyze.
Explanation of Solution
Day’s sales uncollected imply how much days a company takes to collect its accounts receivables.
Formula to calculate day’s sales uncollected is
Day’s sales uncollected for A Company
Day’s sales uncollected in current year:
Given info,
Accounts Receivable is $16,849.
Net Sales is $233,715.
Substitute $16,849 for accounts receivable, and $233,715 for net sales in the above formula,
Day’s sales uncollected in prior year:
Given info,
Accounts Receivable is $17,460.
Net Sales is $182,795.
Substitute $17,460 for accounts receivable, and $182,795 for net sales in the above formula,
Hence, day’s sales uncollected are accounted for prior year is 34.86 days and for current year is 26.31 days .
(b) Day’s sales uncollected for G Company
Day’s sales uncollected in current year:
Given info,
Accounts Receivable is $11,556.
Net Sales is $74,989.
Substitute $11,556 for accounts receivable, and $74,989 for net sales in the above formula,
Day’s sales uncollected in prior year:
Given info,
Accounts Receivable is $9,383.
Net Sales is $66,001.
Substitute $9,383 for accounts receivable, and $66,001 for net sales in the above formula,
Thus, day’s sales uncollected are accounted for 51.89 days.
Hence, day’s sales uncollected are accounted for prior year is 51.89 days and for current year is 56.24 days .
Review about trend of the companies:
- It is concluded that A Company has improved slightly in order to collect its receivables as now it would take 8.55 (34.86-26.31) less days to collect receivables.
- It is concluded that G Company has not improved in order to collect its receivables because now it would take 4.36 (56.25-51.89) more days to collect receivables.
Company with largest percentage change:
- It is ascertained that the day’s sales uncollected for A Company increased by 8.4% whereas the day’s sales uncollected for G Company decreased by 24.5%
- It is concluded that G Company has not managed its number of day’s sales uncollected as compared to previous year while A Company is much efficient than G Company.
Want to see more full solutions like this?
Chapter 6 Solutions
FINANCIAL ACCT.FUND.(LOOSELEAF)
- Perform the Reperformance or Recalculation procedures to check the mathematical accuracy ofthe Income Statement. What issue did you find? What is the next step? Create a Correctedversion of the Income Statement. Income Statement For the Year Ended For the Year Ended Revenue 3/31/2021 3/31/2022 Sales Revenue: Corporate Accounts $ 353,739.57 $ 343,050.56 Sales Revenues: Storefront $ 80,649.00 $ 91,411.50 Total Sales Revenue $ 434,388.57 $ 434,462.06 Cost of Goods Sold: Ingredients $ 69,736.39 $ 64,645.64 Cost of Goods Sold: Boxes and Cupcake Cups $ 3,875.55 $ 3,755.55 Cost of Goods Sold: Beverages $ 5,466.50 $ 5,681.50 Total COGS $ 76,078.44 $ 74,082.69 Gross Profit $ 358,310.13 $ 360,379.37 Interest Revenue $…arrow_forwardSolutions must be in good accounting form pls thank you! Note: Avoiding rounding off during computations. If final answers are not whole numbers, round them off to two decimal places (e.g., 100,450.55).BC Corp. reported a P500,000 account receivable balance at the beginning of the calendar year. For the year, it reported net credit sales of P4,000,000 and collections from customers of P4,050,000. An analysis of the sales showed that a sale amounting to P40,000 was shipped to the buyer on Dec. 31 under FOB destination term while a sale amounting to P50,000 was shipped to the buyer on Jan. 1 under FOB shipping point term. Included in the collections was an over-payment by a customer in the amount of P13,000. Not included in the initial sales and collections amounts are the following: (A) Sales made to officers made under customary terms, P200,000 of which were collected – P700,000 and (B) Claims against common carrier – P 200,000. How much should ABC report as accounts receivables as of…arrow_forwardThe following select financial statement information from Candid Photography. Compute the accounts receivable turnover ratios and the number of days sales in receivables ratios for 2018 and 2019 (round answers to two decimal places). What do the outcomes tell a potential investor about Candid Photography if industry average for accounts receivable turnover ratio is 3 times and days sales in receivables ratio is 150 days?arrow_forward
- Based on the following data for the current year, what is the number of days' sales in receivable? Net sales on account during year $498,171 Cost of goods sold during year 163,215 Accounts receivable, beginning of year 42,207 Accounts receivable, end of year 51,640 Inventory, beginning of year 92,904 Inventory, end of year 119,969 Round your answer up to the nearest whole day. Select the correct answer. 88 days 78 days 120 days 34 daysarrow_forward10. Review the select information for Bean Superstore and Legumes Plus (industry competitors), and then complete the following. A. Compute the accounts receivable turnover ratios for each company for 2018 and 2019. B. Compute the number of days' sales in receivables ratios for each company for 2018 and 2019. C. Determine which company is the better investment and why. Round answers to two decimal places. BEAN SUPERSTORE LEGUMES PLUS Comparative Balance Sheet December 31, 2017, 2018, and 2019 Comparative Balance Sheet December 31, 2017, 2018, and 2019 2019 2018 2017 2019 2018 2017 Assets Cash $345,600 67,000 145,830 100,465 $330,460 62,000 178,011 101,202 $300,000 59,000 155,205 103,085 $407,000 85,430 128,080 182,006 $386,450 82,670 40,036 23,400 $356,367 79,230 52,142 111,701 Accounts Receivable Inventory Equipment Total Assets $658,895 $671,673 $617,290 $802,516 $532,556 $599,440 Liabilities Salaries Payable Accounts Payable Notes Payable $ 91,455 $ 90,200 70,000 41,000 $ 88,563…arrow_forward10. Review the select information for Bean Superstore and Legumes Plus (industry competitors), and then complete the following. A. Compute the accounts receivable turnover ratios for each company for 2018 and 2019. B Compute the number of days sales in receivables ratios for each company for 2018 and 2019 C. Determine which company is the better investment and why. Round answers to two decimal places.arrow_forward
- Millennial Manufacturing has net credit sales for 2018 in the amount of $1,443,630, beginning accounts receivable balance of $588,900, and an ending accounts receivable balance of $624,450. A. Compute the accounts receivable turnover ratio and the number of days' sales in receivables ratio for 2018. Round answers to two decimal places. times days B. What do the outcomes tell a potential investor about Millennial Manufacturing if industry average is 2.6 times and number of day's sales ratio is 180 days? Accounts receivable turnover ratio Sales in receivables ratio a. Millennial Manufacturing collects its accounts more quickly than its competitors. b. A lender may favour Millennial Manufacturing over its competitors because of its faster collection period. c. Without prior years' data it is hard to tell if Millennial Manufacturing is really more efficient than its competitors. d. All of the above statements may be correct.arrow_forwardComplete this question by entering your answers in the tabs below. Analysis Analysis Bal Sheet Inc Stmt Prepare a vertical analysis of an income statements for Year 4 and Year 3. (Percentages may not add exactly due to rounding. Round your answers to 2 decimal places. (i.e., .2345 should be entered as 23.45).) Revenues Sales (net) Other revenues Total revenues Expenses Cost of goods sold FANNING COMPANY Vertical Analysis of Income Statements Year 4 Selling, general, and administrative expense Interest expense Income tax expense Total expenses Net income Amount $ 231,900 9,300 241,200 118,800 54,200 6,800 22,800 202,600 $ 38,600 Percentage of Total Analysis Bal Sheet % % Year 3 Amount $ 211,200 6,400 217,600 102,100 49,100 6,000 21,800 179,000 $ Percentage of Total % % 38,600 Analysis Inc Stmt > Show lessarrow_forwardRefer to the following selected financial information from Weekend Getaways Incorporated Compute the company's days' sales uncollected for Year 2. (Use 365 days a year.) Accounts receivable, net Net sales Multiple Choice O O 39.9. 43.8. 45.5. 38.4. 42.7. Year 2 98,760 823,000 Year 1 86,600 793,000arrow_forward
- Review the select information for Bean Superstore and Legumes Plus (industry competitors), and then complete the following. Compute the accounts receivable turnover ratios for each company for 2018 and 2019. Compute the number of days’ sales in receivables ratios for each company for 2018 and 2019. Determine which company is the better investment and why. Round answers to two decimal places.arrow_forwardThe following annual account balances are from Armour Sports at December 31. a. What is the change in the number of days’ sales uncollected between Year 1 and Year 2? (Round the number of days to one decimal.) b. From the analysis in part a, is the company’s collection of receivables improving?arrow_forward2. Using the following select financial statement information from Black Water Industries, compute the accounts receivable turnover ratios for 2018 and 2019 (round answers to two decimal places). What do the outcomes tell a potential investor about Black Water Industries? Year 2017 2018 2019 BLACK WATER INDUSTRIES Net Credit Sales $685,430 700,290 768,500 Ending Accounts Receivable $330,250 360,450 401,650arrow_forward
- Principles of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax CollegeFinancial AccountingAccountingISBN:9781337272124Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage LearningFinancial AccountingAccountingISBN:9781305088436Author:Carl Warren, Jim Reeve, Jonathan DuchacPublisher:Cengage Learning
- Financial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,