usaiothilnbld- 593298odeld-216270947BelSBN-9781305635975 8 MINDTAP Assignment 16
ID: 2794418 • Letter: U
Question
usaiothilnbld- 593298odeld-216270947BelSBN-9781305635975 8 MINDTAP Assignment 16- Financial Planning and Forecasting Due on Dec 4 at 11 PM EST 6. Using regression analysis to forecast assets Aa Aa The AFN equation and the financial statement-forecasting approach both assume that assets 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 Sirius Cybernetics Corp. has used its historical sale s and asset data to estimate the following regression equations: Accounts Receivable-$95,420+0.265(Sales) Inventories $9,1100.223(Sales) Sirius Cybernetics Corp. currently has sales of $984,000, but it expects sales to grow by 10% over the next year. Use the regression models to calculate Sirius Cybernetics Corp.'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 Sirius Cybernetics Corp.'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 Flash Player WIN 27,0,0,187 Q3 3.34.1 © 2004-2016 Apia. All rights reserved ©2O 13 Cengage Learning except as noted. All rights reserved. Grade It Now Save & Continue O Type here to searchExplanation / Answer
Current Year sale = $984,000
Growth rate next year = 10%
Next year sale = $984,000 × (1 + 10%)
= $1,082,400
Next year sale will be $1,082,400.
Next year account receivables is calculated below using equation for account receivables:
Account receivables = -$95,420 + 26.50% × Sales
= -$95,420 + ($1,082,400 × 26.50%)
= $286,836 - $95,420
= $191,416.
Next year account receivables is is $191,416.
Next year Inventiry is calculated below using equation for account receivables:
Inventory = $9,110 + 22.30% × Sales
= $9,110 + ($1,082,400 × 22.30%)
= $9,110 + $241,375.20
= $250,485.20
Next year Inventory is is $250,485.20.
b.
DSO next year = $191,416 / ($1,082,400 / 365)
= $191,416 / $2,965.48
= 65 days.
DSO for company next year will be 65 days.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.