Cash Balance for Greenwell Corporation The Greenwell Corporation has a 60-day average collection period and wishes to maintain a $160 million minimum cash balance. Based on this and the information given in the following cash budget, complete the cash budget. What conclusions do you draw?
GREENWELL CORPORATION
Cash Budget (in millions)
Q4 | Q3 | Q2 | Q1 | |
$240 | Beginning receivables | |||
$135 | $180 | $165 | 150 | Sales |
Cash collections | ||||
Ending receivables | ||||
Total cash collections | ||||
190 | 185 | 160 | 170 | Total cash disbursements |
Net cash inflow | ||||
$45 | Beginning cash balance | |||
Net cash inflow | ||||
Ending cash balance | ||||
Minimum cash balance | ||||
Cumulative surplus (deficit) |