Question
Hayes Inc is growing steadily, causing some concerns about its cash flow. the company's estimated sales and purchases for the past 3 months plus projected
Hayes Inc is growing steadily, causing some concerns about its cash flow. the company's estimated sales and purchases for the past 3 months plus projected sales and purchases for the next 3 months are shown below. half of hayes sales are for cash. the company's average collection period from customer isn60 days. its standard pay terms with suppliers isn30 days. a. what are the company's expected cash receipts in March? b. what would the companys account receivable balance be at the end of March? c. what are the company's expected cash expenditures for purchases in March? d. what would the companys account payable balance at the end of March?
Home insert Page Layout Formulas Data Review View Developer el me what you want cut Arial - 10 A A = 8 Wrap Text General Normal 2 Normal 3 Note 2 Nc Copy ormat Painter BIU- BA A. ES E Merge & Center - $ - % 00 000 Neutral Calculation CH Conditional Format as Good Formatting Table - oard Font Alignment Number Styles f 1 B J N C L o D E F G H M Assignment 4.4 Exercises Problem 4: Preparing a Cash Budget 10 Points Hayes, Inc. is growing steadily, causing some concerns about its cash flow. The company's estimated sales and purchases for the past three months, plus projected sales and purchases for the next three months, are shown below: Actual October November December $ 250,000 $ 275,000 $ 300,000 $ 175,000 $ 200,000 $ 225,000 Forecast January February 325,000 $ 350,000 S $ 250,000 $ 275,000 $ Sales Purchases March 400,000 300,000 Half of Hayes' sales are for cash. The company's Average Collection Period from customers is 60 days. It's standard pay terms with suppliers is 30 days. a) What are the company's expected cash receipts in March? b) What would the company's Accounts Receivable balance be at the end of March? c) What are the company's expected cash expenditures for purchases in March? d) What would be the company's Accounts Payable balance at the end of March? Create your Original Solution Below 3e sure to show all calculations and clearly indicate answersStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started