Question: Please do it on paper, not on excel. Thank you! 3. You are working as a financial analyst for XYZ Co. , and you prepared

Please do it on paper, not on excel. Thank you! 3. YouPlease do it on paper, not on excel. Thank you!

3. You are working as a financial analyst for XYZ Co. , and you prepared the following sales and cash disbursement estimates for the period August through December of the current year. Month August September October November December Sales $400 500 500 600 700 Cash Disbursements $300 500 700 400 500 80% of sales are for cash, the remaining 20% percent are collected one month later. All disbursements are on a cash basis. The firm wishes to maintain a minimum cash balance of $50. The beginning cash balance in September is $25. Prepare a cash budget for the months of October, November, and December, noting any needed financing or excess cash available

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!