5 Using regression analysis to forecast assets The AFN equation and the financial statementforecasting 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 General Services Corp has used its historical sales and asset data to estimate the following regression equations Accounts Receivable $94,555 0 225(Sales) Inventories $9,110 0 223(Sales) General Services Corp currently has sales of $1,110,000, but it expects sales to grow by 20 over the next year Use the regression models to calculate General Services Corp s forecasted values for accounts receivable and inventories needed to support next years sales Forecasted Values for Next Year Accounts receivable Inventories Based on the next years accounts receivable and inventory levels predicted by General Services Corp s regression equations, the firms DSO for next year is expected to be Use 365 days as the length of a year in all calculations

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 07, 2024

5. Using regression analysis to forecast assets The AFN equation and the financial statementforecasting approach both assume that assets grow at relatively the same rate

5. Using regression analysis to forecast assets

The AFN equation and the financial statementforecasting 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.

General Services Corp. has used its historical sales and asset data to estimate the following regression equations:

Accounts Receivable	=	$94,555 + 0.225(Sales)
Inventories	=	$9,110 + 0.223(Sales)

General Services Corp. currently has sales of $1,110,000, but it expects sales to grow by 20% over the next year. Use the regression models to calculate General Services Corp.s forecasted values for accounts receivable and inventories needed to support next years sales.

Forecasted Values for Next Year
Accounts receivable
Inventories

Based on the next years accounts receivable and inventory levels predicted by General Services Corp.s regression equations, the firms DSO for next year is expected to be . Use 365 days as the length of a year in all calculations.