Brown Corporation had an average days-of-sales- outstanding (DSO) period of 19 days in 2009. An analyst thinks that Brown's DSO will decline in 2010 (because of expected improvements in the company's collections department) to match the industry average of 15 days. Total sales (all on credit) in 2009 were $300 million, and Brown expects total sales (all on credit) to increase to $320 million in 2010. To achieve the lower DSO, the change in the average accounts receivable balance from 2009 to 2010 that must occur is closest to: A. -$3.51 million B. $2.46 million C. $2.46 million D. $3.51 million

Brown Corporation had an average days-of-sales- outstanding (DSO) period of 19 days in 2009. An analyst thinks that Brown's DSO will decline in 2010 (because of expected improvements in the company's collections department) to match the industry average of 15 days. Total sales (all on credit) in 2009 were $300 million, and Brown expects total sales (all on credit) to increase to $320 million in 2010. To achieve the lower DSO, the change in the average accounts receivable balance from 2009 to 2010 that must occur is closest to: A. -$3.51 million B. $2.46 million C. $2.46 million D. $3.51 million

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter22: Master Budget (master)

Section: Chapter Questions

Problem 4R: Suppose the company has to revise its estimates because of a downturn in the economy. Unit sales for...

See similar textbooks

Similar questions

The following information pertains to Striker Corporation, together with its DSO of the firms against which it benchmarks. The firm's new CFO believes that the company could reduce its receivables enough to reduce its DSO/ACP to the benchmarks’ average. If this were done, by how much would receivables decline? Use a 365-day year. Sales=P110,000; Accounts receivable= P16,000; Days sales outstanding (DSO/ACP)=53.09; Benchmark days sales outstanding (DSO/ACP)=20.00 *
The following information pertains to Striker Corporation, together with its DSO/ACP of the firms against which it benchmarks. The firm's new CFO believes that the company could reduce its receivables enough to reduce its DSO/ACP to the benchmarks' average. If this were done, by how much would receivables decline? Use a 365-day year. Sales=P110,000; Accounts receivable= P16,000; Days sales outstanding (DSO/ACP)= 53.09; Benchmark days sales outstanding (DSO/ACP)=20.00 * P 8,078 O P 8,975 P 9,973 P10,970 P12,067
Data on Nathan Enterprises for the most recent year are shown below, along with the days sales outstanding of the firms against which it benchmarks. The firm's new CFO believes that the company could reduce its receivables enough to reduce its DSO to the benchmarks' average. If this were done, by how much would receivables decline? Use a 365-day year. Sales $110,000 Accounts receivable $16,000 Days sales outstanding (DSO) 53.09 Benchmark days sales outstanding (DSO) 20.00 a. $9,973 b. $8,078 c. $8,975 d. $10,970 e. $12,067
Data on Shick Inc. for last year are shown below, along with the days sales outstanding of the firms against which it benchmarks. The firm's new CFO believes that the company could reduce its receivables enough to reduce its DSO to the benchmarks' average. If this were done, by how much would receivables decline? Use a 365 day year. Do not round yourData on Shick Inc. for last year are shown below, along with the days sales outstanding of the firms against which it benchmarks. The firm's new CFO believes that the company could reduce its receivables enough to reduce its DSO to the benchmarks' average. If this were done, by how much would receivables decline? Use a 365-day year. Do not round your intermediate calculations. Sales $103, 000 Accounts receivable $16,000 Days Sales Outstanding (DSO) 56.699 Benchmarks' Days Sales Outstanding (DSO) 19.000 a. $9,805 b. $11,471 c. $10, 638 d. $4,529
Data on Wentz Inc. for last year are shown below, along with the payables deferral period (PDP) for the firms against which it benchmarks. The firm's new CFO believes that the company could delay payments enough to increase its PDP to the benchmarks' average. If this were done, by how much would payables increase? Use a 365-day year. Cost of goods sold = $74,000 Payables = $5,000 Payables Deferral Period (PDP) = 24.66 Benchmark Payables Deferral Period = 34.00 Please explain process and show calculations.
xyz is trying to determine the effect of its inventory turnover ratio and days sales outstanding (DSO) on its cash flow cycle. Christie’s 2008sales (all on credit) were $150,000; and it earned a net profit of 6%, or $9,000. It turned over its inventory 6 times during the year, and its DSO was 36.5 days. The firm had fixed assets totaling $35,000. Christie’s payables deferral period is 40days. Calculate Christie’s cash conversion cycle. Assuming Christie holds negligible amounts of cash and marketable securities, calculate its total assets turnover and ROA. Suppose Christie’s managers believe that the inventory turnover can be raised to 7.3 times. What would Christie’s cash conversion cycle, total assets turnover, and ROA have been if the inventory turnover had been 7.3 for2008?
Edwards Industries has $340 million in sales. The company expects that its sales will increase 15% this year. Edwards' CFO uses a simple linear regression to forecast the company's receivables level for a given level of projected sales. On the basis of recent history, the estimated relationship between receivables and sales (in millions of dollars) is as follows: Receivables = $9.75 + 0.13(Sales) Given the estimated sales forecast and the estimated relationship between receivables and sales, what are your forecasts of the company's year-end balance for receivables? Enter your answer in millions. For example, an answer of $25,400,000 should be entered as 25.40. Do not round intermediate calculations. Round your answer to two decimal places. million What are your forecasts of the company's year-end days sales outstanding (DSO) ratio? Assume 365 days in year for your calculations. Do not round intermediate calculations. Round your answer to two decimal places. days
Jasper Jewelry has $150 million in sales. The company expects that its sales will increase 5% this year. Jasper's CFO uses a simple linear regression to forecast the company's inventory level for a given level of projected sales. On the basis of recent history, the estimated relationship between inventories and sales (in millions of dollars) is as follows: Inventories = $11 + 0.07(Sales) Given the estimated sales forecast and the estimated relationship between inventories and sales, what is your forecast of the company's year-end inventory level? Enter your answer in millions. For example, an answer of $10,550,000 should be entered as 10.55. Do not round intermediate calculations. Round your answer to two decimal places.$ million
The Manning Company has financial statements as shown next, which are representative of the company's historical average. The firm is expecting a 30 percent increase in sales next year, and management is concerned about the company's need for external funds. The increase in sales is expected to be carried out without any expansion of fixed assets, but rather through more efficient asset utilization in the existing store. Among liabilities, only current liabilities vary directly with sales. Sales Expenses Earnings before interest and taxes Interest Earnings before taxes Taxes Earnings after taxes Dividends Current assets Income Statement Cash Accounts receivable Inventory Fixed assets Total assets Assets The firm $ 250,000 184,800 $ 65,200 8,600 $ 56,600 16,600 $ 40,000 $ 16,000 Balance Sheet (in $ millions) $ 221,000 Liabilities and Stockholders' Equity $ 4,000 Accounts payable Accrued wages 53,000 68,000 Accrued taxes $ 125,000 96,000 Current liabilities Notes payable Long-term debt…
The Manning Company has financial statements as shown next, which are representative of the company's historical average. The firm is expecting a 30 percent increase in sales next year, and management is concerned about the company's need for external funds. The increase in sales is expected to be carried out without any expansion of fixed assets, but rather through more efficient asset utilization in the existing store. Among liabilities, only current liabilities vary directly with sales. Sales Expenses Earnings before interest and taxes Interest Earnings before taxes Taxes Earnings after taxes Dividends Cash Accounts receivable Inventory Current assets Fixed assets Income Statement Total assets Assets $ 280,000 222,800 $ 57,200 7,800 $ 49,400 15,800 $ 33,600 $ 6,720 Balance Sheet (in $ millions) Liabilities and Stockholders' Equity $ 5,000 Accounts payable Accrued wages 86,000 77,000 Accrued taxes $ 168,000 88,000 Current liabilities Notes payable Long-term debt Common stock Retained…
Munson Communications Company has just reported earnings for the year ended June 30, 2011. Below are the firm’s income statement and balance sheet. The Company had a 55 percent dividend payout ratio for the last 10 years and does not plan to change this policy. Based on internal forecasts, the company expects the demand for its products to grow at a rate of 27 percent for the next year and has projected the sales growth for 2012 to be 27 percent. Assume that equity accounts and long-term debt do not vary directly with sales, but change when retained earnings change or additional capital is issued. Munson Communications Company Balance Sheet as of June 30, 2011 Assets: Liabilities and Stockholders’ Equity: Cash $1,728,639 Accounts payables $4,666,673 Accounts receivables 3,009,421 Notes payables 2,507,094 Inventories 11,492,993 Total current assets $16,231,054 Total current liabilities $7,173,767 Net fixed assets 22,380,636 Long-term debt 13,345,242…
Munson Communications Company has just reported earnings for the year ended June 30, 2011. Below are the firm’s income statement and balance sheet. The Company had a 55 percent dividend payout ratio for the last 10 years and does not plan to change this policy. Based on internal forecasts, the company expects the demand for its products to grow at a rate of 27 percent for the next year and has projected the sales growth for 2012 to be 27 percent. Assume that equity accounts and long-term debt do not vary directly with sales, but change when retained earnings change or additional capital is issued. Munson Communications Company Balance Sheet as of June 30, 2011 Assets: Liabilities and Stockholders’ Equity: Cash $1,728,639 Accounts payables $4,666,673 Accounts receivables 3,009,421 Notes payables 2,507,094 Inventories 11,492,993 Total current assets $16,231,054 Total current liabilities $7,173,767 Net fixed assets 22,380,636 Long-term debt 13,345,242…