Need a,b,c For 2015, Walmart and Target had the following information (all values are in millions of dollars).AccountsReceivable(BalanceSheet)5,524753WalmartTargetSalesCost of Goods Sold(Income Statement) (Income Statement)482,74873,603361,61152,937Inventory(Balance Sheet)a. What is each company's accounts receivable days?b. What is each company's inventory turnover?c. Which company is managing its accounts receivable and inventory more efficiently?45,0088,600

Ratio analysis is one of the important techniques of management accounting.. Accounts receivable…

For 2015, Walmart and Target had the following information (all values are in millions of dollars). Accounts Receivable Walmart Target Sales Cost of Goods Sold (Income Statement) (Income Statement) 482,748 73,603 361,611 52,937 (Balance Sheet) 5,524 753 Inventory (Balance Sheet) a. What is each company's accounts receivable days? b. What is each company's inventory turnover? c. Which company is managing its accounts receivable and inventory more efficiently? 45,008 8,600

For 2015, Walmart and Target had the following information (all values are in millions of dollars). Accounts Receivable Walmart Target Sales Cost of Goods Sold (Income Statement) (Income Statement) 482,748 73,603 361,611 52,937 (Balance Sheet) 5,524 753 Inventory (Balance Sheet) a. What is each company's accounts receivable days? b. What is each company's inventory turnover? c. Which company is managing its accounts receivable and inventory more efficiently? 45,008 8,600

Managerial Accounting: The Cornerstone of Business Decision-Making

7th Edition

ISBN:9781337115773

Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Publisher:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Chapter15: Financial Statement Analysis

Section: Chapter Questions

Problem 14BEA: Last year, Nikkola Company had net sales of 2.299.500,000 and cost of goods sold of 1,755,000,000....

See similar textbooks

Similar questions

Last year, Nikkola Company had net sales of 2.299.500,000 and cost of goods sold of 1,755,000,000. Nikkola had the following balances: Refer to the information for Nikkola Company above. Required: Note: Round answers to one decimal place. 1. Calculate the average accounts receivable. 2. Calculate the accounts receivable turnover ratio. 3. Calculate the accounts receivable turnover in days.
Berry Farms has an accounts receivable balance at the end of 2018 of $425,650. The net credit sales for the year are $924,123. The balance at the end of 2017 was $378,550. What is the number of days sales in receivables ratio for 2018 (round all answers to two decimal places)?
The following select financial statement information from Vortex Computing. 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 Vortex Computing if industry average for accounts receivable turnover ratio is 4 times and days sales in receivables ratio is 85 days?
The 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?
Millennial Manufacturing has net credit sales for 2018 in the amount of $1,433,630, beginning accounts receivable balance of $585,900, and an ending accounts receivable balance of $621,450. Compute the accounts receivable turnover ratio and the number of days sales in receivables ratio for 2018 (round answers to two decimal places). What do the outcomes tell a potential investor about Millennial Manufacturing if industry average is 2.6 times and number of days sales ratio is 180 days?
The following data are taken from the financial statements of Colby Company. Accounts receivable (net), end of year Net sales on account Terms for all sales are 1/10, n/45 Accounts Receivable turnover Average collection period (b) 2022 $550,000 2022 2021 4,300,000 4,000,000 7.9 times $540,000 2021 7.5 times 46.2 days 48.7 days What conclusions about the management of accounts receivable can be drawn from the accounts receivable turnover and the average collections period.
The following data are taken from the financial statements of Sheffield Company. Accounts receivable (net), end of year Net sales on account Terms for all sales are 1/10, n/45 (a1) X Your answer is incorrect. 2022 $555,000 3,997,500 2021 $470,000 3,122,250 Compute for each year the accounts receivable turnover. At the end of 2020, accounts receivable (net) was $435,000. (Round answers to 1 decimal place, e.g. 1.6.)
The financial data for A Company is the following: Balance sheet data (in $ millions) at 12/31 Accounts receivable Less: allowance for doubtful accounts Accounts receivable (net) Income statement data, year ending 12/31 Net sales (assume all on credit) Uncollectible accounts expense 2021 $ 500 150 350 2020 $ 450 140 310 $33,400 $21,500 100 110 1. Compute the accounts receivable turnover ratio for 2021 and 2020. 2. Wat amount of accounts receivable was collected in 2021? 3. How much was the write off of uncollectible accounts in 2021? 2019 $410 160 250 $19,200 95
As of May 31, 2014, how much is the net realizable value of the accounts receivable? * Given the following unadjusted ledger balances on fiscal year ending May 31, 2014: Account Titles Debit Credit Utilities Expense Advertising Expense Rent Expense Salaries Expense 5,000 7,000 50,000 140,000 357,100 100,000 15,000 Service Income X, Capital Notes Payable Office Equipment Office Furniture 75,000 73,500 95,400 26,200 Accounts Receivable Cash Relevant information: a. No interest has yet been recorded on a 60-day 15% note issued by the company on May 3, 2014. (Use 365 days) b. Office equipment was purchased on July 1, 2013, and estimated to have a useful life of 5 years with no scrap value. c. Office furniture was purchased on June 1, 2013 and estimated to be useful for 10 years with a salvage value of P12,000 at the end of its useful life. d. Management estimated that only 90% of the receivables will be collected. O 95,400 85,860 O 9,540
The following data are taken from the financial statements of Colby Company. Accounts receivable (net), end of year Net sales on account Terms for all sales are 1/10, n/45 Accounts Receivable turnover Average collection period (b) B I U T₂ T² Ix 2022 $550,000 4,300,000 2022 7.9 times lil 2021 What conclusions about the management of accounts receivable can be drawn from the accounts receivable turnover and the average collections period. € $540,000 4,000,000 2021 46.2 days 48.7 days 7.5 times W 144 144 들 3 99 = á T ¶₁
Suppose the following information was taken from the 2017 financial statements of FedEx Corporation, a major global transportation/delivery company. (in millions) 2017 2016 Accounts receivable (gross) $ 3,302 $ 4,396 Accounts receivable (net) 3,273 4,367 Allowance for doubtful accounts 29 29 Sales revenue 32,226 39,472 Total current assets 6,758 6,532 Answer each of the following questions. (a) Calculate the accounts receivable turnover and the average collection period for 2017 for FedEx Corporation. (Round answers to 1 decimal place, e.g. 12.5. Use 365 days for calculation.)
Use the following financial statement information from Black Water Industries. BLACK WATER INDUSTRIES Ending Accounts Receivable Year Net Credit Sales 2017 $690,430 $335,250 2018 705,290 364,450 2019 770,500 406,650 A. Compute the accounts receivable turnover ratios for 2018 and 2019. Round your answers to two decimal places. 2018 times 2019 times B. Using the accounts receivable turnover, choose the statement that most closely describes the company's management of its receivables. a. The company's lending policies may be too strict. b. Collection efforts are not aggressive enough. There may be uncollectable receivables affecting the beginning and ending C. balances. d. All of the above statements may be correct. a b d