Question
Piano Man, Inc., has a 50-day average collection period and wants to maintain a minimum cash balance of $35 million, which is what the company
Piano Man, Inc., has a 50-day average collection period and wants to maintain a minimum cash balance of $35 million, which is what the company currently has on hand. The company currently has a receivables balance of $189 million and has developed the following sales and cash disbursement budgets in millions: |
Q1 | Q2 | Q3 | Q4 | |||||||||||||
Sales | $ | 378 | $ | 450 | $ | 531 | $ | 495 | ||||||||
Total cash disbursement | 268 | 390 | 617 | 412 | ||||||||||||
Required: |
Complete the following cash budget for the company. (Do not include the dollar signs ($). Negative amounts should be indicated by a minus sign. Enter your answers in millions of dollars. Round your answers to the nearest whole dollar amount (e.g., 32).) |
PIANO MAN, INC. Cash Budget (in millions) | ||||
Q1 | Q2 | Q3 | Q4 | |
Beginning receivables | $ | $ | $ | $ |
Sales | 378 | 450 | 531 | 495 |
Cash collections | ||||
Ending receivables | $ | $ | $ | $ |
Total cash collections | $ | $ | $ | $ |
Total cash disbursements | 268 | 390 | 617 | 412 |
Net cash inflow | $ | $ | $ | $ |
Beginning cash balance | $ | $ | $ | $ |
Net cash inflow | ||||
Ending cash balance | $ | $ | $ | $ |
Minimum cash balance | $ | $ | $ | $ |
Cumulative surplus (deficit) | $ | $ | $ | $ |
Step 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