Question

Ch 16: Assignment - Financial Planning and Forecasting Attempts: Keep the Highest: 12 5. Using regression analysis to forecast assets The APN 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. U.S. Robotics Inc. has used its historical sales and asset data to estimate the following regression equations Accounts Receivable Inventories - -$98,770 +0.225(Sales) - $9,110 +0.211(Sales) U.S. Robotics Inc. Currently has sales of $984,000, but it expects sales to grow by 30% over the next year. Use the regression models to calculate U.S. Robotics Inc.'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 U.S. Robotics Inc.'s regression equations, the firm's DSO for next year is expected to be Use 365 days as the length of a year in all calculations. Grade It Now Save & Continue Continue without saving

Answer 1

Sales next year = 984,000 x (1 + 30%) = 1,279,200

Accounts receivables = -98,770 + 0.225 x 1,279,200 = 189,050

Inventories = 9,110 + 0.211 x 1,279,200 = 279,21