16-10 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: Receivables = $9.25 + 0.07(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 and its year-end days sales outstanding (DSO) ratio? Assume that DSO is calculated on the basis of a 365-day year.

16-10 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: Receivables = $9.25 + 0.07(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 and its year-end days sales outstanding (DSO) ratio? Assume that DSO is calculated on the basis of a 365-day year.

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter4: Financial Planning And Forecasting

Section: Chapter Questions

Problem 10P

See similar textbooks

Receivables = $9.25 + 0.07(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 and its year-end days sales outstanding (DSO) ratio? Assume that DSO is calculated on the basis of a 365-day year.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step by step

Solved in 2 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.

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
4.1 Calculating EFN Based on the following information for the Skandia Mining Company, what is EFN if sales are predicted to grow by 10 percent? Use the percentage of sales approach and assume the company is operating at full capacity. The payout ratio is constant. Income Statement Sales Costs Taxable income Taxes (34%) Net income Dividends Addition to retained earnings $4,250.0 3,875.0 $ 375.0 127.5 $ 247.5 $82.6 164.9 SKANDIA MINING COMPANY Financial Statements Assets Current assets Net fixed assets Total assets Balance Sheet $ 900.0 2,200.0 $3,100.0 Liabilities and Owners' Equity Current liabilities Long-term debt Owners' equity Total liabilities and owners' equity 4.2 EFN and Capacity Use Based on the information in Problem 4.1, what is EFN, assuming 60 percent capacity usage for net fixed assets? Assuming 95 percent capacity? 4.3 Sustainable Growth Based on the information in Problem 4.1, what growth rate can Skandia maintain if no external financing is used? What is the…
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.
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.
on the pro forma income statement sales are expected to increase by 23%. If the net margin is expected to increase by 18% and net profit last year was 100 million, what is the net profit projected to be? A) 118 million. B)123 million. C )158 million D) 141 million
Strickler Technology is considering changes in its working capital policies to improve its cash flow cycle. Stricklers sales last year were 3,250,000 (all on credit), and its net profit margin was 7%. Its inventory turnover was 6.0 times during the year, and its DSO was 41 days. Its annual cost of goods sold was 1,800,000. The firm had fixed assets totaling 535,000. Stricklers payables deferral period is 45 days. a. Calculate Stricklers cash conversion cycle. b. Assuming Strickler holds negligible amounts of cash and marketable securities, calculate its total assets turnover and ROA. c. Suppose Stricklers managers believe the annual inventory turnover can be raised to 9 times without affecting sale or profit margins. What would Stricklers cash conversion cycle, total assets turnover, and ROA have been if the inventory turnover had been 9 for the year?