REGRESSION AND RECEIVABLES Edwards Industries has $320 million in sales. The company expects that its sales will increase 12% 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: 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 and its year-end days sales outstanding (DSO) ratio? Assume that DSO is calculated on the basis of a 365-day year.

REGRESSION AND RECEIVABLES Edwards Industries has $320 million in sales. The company expects that its sales will increase 12% 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: 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 and its year-end days sales outstanding (DSO) ratio? Assume that DSO is calculated on the basis of a 365-day year.

Intermediate Financial Management (MindTap Course List)

13th Edition

ISBN:9781337395083

Author:Eugene F. Brigham, Phillip R. Daves

Publisher:Eugene F. Brigham, Phillip R. Daves

Chapter22: Providing And Obtaining Credit

Section: Chapter Questions

Problem 2MC

See similar textbooks

Similar questions

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
Edwards Industries has $320 million in sales. The companyexpects that its sales will increase 12% this year. Edwards’ CFO uses a simple linearregression 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 (inmillions of dollars) is as follows:Receivables = $9.25 + 0.07(Sales)Given the estimated sales forecast and the estimated relationship between receivables andsales, what are your forecasts of the company’s year-end balance for receivables and itsyear-end days sales outstanding (DSO) ratio? Assume that DSO is calculated on the basisof a 365-day year.
Use the "percent of sales method" of preparing pro forma financial statements to determine the projection for next year's accounts receivable. Make the following assumptions: current year's sales are $55,750,000; current year's cost of goods sold is $25,350,000; sales are expected to rise by 25%, The firm's investment in accounts receivable in the current year is $12,600,000. The firm's marginal tax rate is 35%. What is the projection for next year's accounts receivable? $10,320,000 $11,345,000 O $15,750,000 $8,772,000
Suppose that Gyp Sum Industries currently has the balance sheet shown. below, and that sales for the year just ended were $9.5 million. The firm also has a profit margin of 25 percent and a retention ratio of 30 percent, and expects sales of $7.5 million next year.
Suppose a firm has had the following historic sales figures. Year: 2016 Sales $1,420,000 2017 $1,720,000 Next year's sales 2018 2019 2020 $1,600,000 $2,010,000 $1,770,000 What would be the forecast for next year's sales using FORECAST.ETS to estimate a trend? Note: Round your answer to the nearest whole dollar. 27
Jace Furnishings has $325 million in sales. The company expects that its sales will increase 8% this year. Jace'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 = $30 + 0.105(Sales) Given the estimated sales forecast and the estimated relationship between inventories and sales, what are your forecasts of the company's year-end inventory level? Write out your answer completely. For example, 5 million should be entered as 5,000,000. Do not round intermediate calculations. Round your answer to the nearest dollar.$ What are your forecasts of the company's year-end inventory turnover ratio? Do not round intermediate calculations. Round your answer to two decimal places. x
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
Using the AFN formula in financial forecasting approach, Determine the following for Piano Co. given the following accounting information assuming that the firm’s profit margin remains constant and the company is at full capacity. · Sales this year is P6,000,000· Percentage increase projected for next year sales = 20%· Net income this year amounts to P600,000· Retention ratio = 50%· Accounts payable = P1,100,000· Notes payable = P180,000· Accrued expenses = P500,000· Projected excess funds available next year is determined to be P200,000 Questions: 1. Determine the spontaneous liabilities increase. 2. How much is the increase in Retained Earnings? 3. How much is the total assets?
The current year financial statements of Your Health Corporation reported sales of $142,021 million and accounts receivable of $9,731 million. If sales are projected to increase 4% next year, what is the projected accounts receivable balance for the following year? Note: Use a rounded forecasting factor in your computations (for example, 0.044555 = 4.5%). Select one: O a. $8,659 million O O O O b. $9,920 million c. $8,330 million d. $10,191 million e. $9,731 million
Problem: Jasper Jewelry has $150 million in sales. The company expects that its sales will increase 4% 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 = $10 + 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.
Moore Money is a financial services firm specializing in fixed-income investments. You have beenasked by the accounting manager to analyze the company’s financial data from the last quarter. Youfind the firm had return on investment (ROI) of 15% and asset turnover of 0.5. What was the returnon sales (ROS) for the quarter?
Suppose a firm has had the following historic sales figures. What would be the forecast for next year's sales using the average approach? Year: 2009 2010 2011 2012 2013 Sales $1,500,000 $1,750,000 $1,400,000 $2,000,000 $1,600,000