Question: Attempts Ch 17: Assignment - Financial Planning and Forecasting Keep the Highest / 2 4. Using regression analysis to forecast assets The AFN equation and

 Attempts Ch 17: Assignment - Financial Planning and Forecasting Keep the

Attempts Ch 17: Assignment - Financial Planning and Forecasting Keep the Highest / 2 4. Using regression analysis to forecast assets The AFN equation and the financial statement-forecasting approach both assume that assets grow at relatively the same rate as sales. However, the relationship between assets and sales is often a little more difficult than that. In particular, some firms use regression analysis to predict the required assets needed to support a given level of sales. Mile Brewing Co. has used its historical sales and asset data to estimate the following regression equations: Accounts Receivable Inventories -$99,220 +0.265(Sales) - $9,340 +0.243(Sales) Mile Brewing Co. currently has sales of $1,230,000, but it expects sales to grow by 10% over the next year. Use the regression models to calculate Mile Brewing Co.'s forecasted values for accounts receivable and Inventories needed to support next year's sales Forecasted Values for Next Year Accounts receivable Inventories Based on the next year's accounts receivable and inventory levels predicted by Mile Brewing Co.'s regression equations, the firm's DSO for next year is Use 365 days as the length of a year in all calculations, expected to be Grade It Now Save & Continue Axe W P

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!