5. 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. General Services Corp. has used its historical sales and asset data to estimate the following regression equations: Accounts Receivable = –$99,220 + 0.225(Sales) Inventories = $9,110 + 0.180(Sales)   General Services Corp. currently has sales of $900,000, but it expects sales to grow by 30% 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 year’s sales. Forecasted Values for Next Year   Accounts receivable      Inventories        Based on the next year’s accounts receivable and inventory levels predicted by General Services 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 calculations.

Cornerstones of Financial Accounting
4th Edition
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Jay Rich, Jeff Jones
Chapter7: Operating Assets
Section: Chapter Questions
Problem 12MCQ: Which of the following statements is true? a. The fixed asset turnover ratio assists managers in...
icon
Related questions
Question
 

5. 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.
General Services Corp. has used its historical sales and asset data to estimate the following regression equations:
Accounts Receivable = –$99,220 + 0.225(Sales)
Inventories = $9,110 + 0.180(Sales)
 
General Services Corp. currently has sales of $900,000, but it expects sales to grow by 30% 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 year’s sales.
Forecasted Values for Next Year
 
Accounts receivable     
Inventories     
 
Based on the next year’s accounts receivable and inventory levels predicted by General Services 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 calculations.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 4 images

Blurred answer
Knowledge Booster
Ratio Analysis
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Corporate Fin Focused Approach
Corporate Fin Focused Approach
Finance
ISBN:
9781285660516
Author:
EHRHARDT
Publisher:
Cengage
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Financial Accounting: The Impact on Decision Make…
Financial Accounting: The Impact on Decision Make…
Accounting
ISBN:
9781305654174
Author:
Gary A. Porter, Curtis L. Norton
Publisher:
Cengage Learning
Fundamentals of Financial Management, Concise Edi…
Fundamentals of Financial Management, Concise Edi…
Finance
ISBN:
9781305635937
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Auditing: A Risk Based-Approach (MindTap Course L…
Auditing: A Risk Based-Approach (MindTap Course L…
Accounting
ISBN:
9781337619455
Author:
Karla M Johnstone, Audrey A. Gramling, Larry E. Rittenberg
Publisher:
Cengage Learning