Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Piano Man, Inc., has a 30-day average collection period and wants to maintain a minimum cash balance of $20 million, which is what the company
Piano Man, Inc., has a 30-day average collection period and wants to maintain a minimum cash balance of $20 million, which is what the company currently has on hand. The company currently has a receivables balance of $193 million and has developed the following sales and cash disbursement budgets in millions: Q4 Sales Total cash disbursement Q1 $ 414 352 Q2 $486 439 Q3 $ 567 686 $ 531 434 Required: Complete the following cash budget for the company. (Do not round intermediate calculations. Negative amounts should be indicated by a minus sign. Enter your answers in millions of dollars. Round your answers to the nearest whole million dollar amount (e.g., 32).) PIANO MAN, INC. Cash Budget (in millions) Q1 Q2 $ 486 Q3 $ Beginning receivables Sales Cash collections Q4 $ 531 414 567 00:09 Ending receivables $ $ $ Total cash collections Total cash disbursements 352 439 686 434 Net cash inflow $ $ $ $ Beginning cash balance Net cash inflow Ending cash balance Minimum cash balance AA A A A tA A TA " 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