Marcos Inc. 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 $187 million and has developed the following sales and cash disbursement budgets in millions:

Q1 Q2 Q3 Q4

Sales $315 $390 $475 $435

Total cash disbursement $265 $340 $560 $375

Cash Collections $385 $363 $445 $449

Complete the following cash budget for the company.

Q1 Q2 Q3 Q4

Beginning receivables

Sales

Cash collections

Ending receivables

Total cash collections

Total cash disbursements

Net cash inflow

Beginning cash balance

Net cash inflow

Ending cash balance

Minimum cash balance

Cumulative surplus (deficit)