John Carpenter provides the following budgets for cash receipts and cash disbursements for the first two quarters of the year 2020. The ending cash balance on December 31, 2019 was $9,000. Q1 Q2 Receipts $16,000 $27,000 Disbursements $31,000 $19,000 Do not enter dollar signs or commas in the input boxes. Use the negative sign for negative values and values that must be subtracted. Prepare the cash budget for the quarters. John Carpenter wants to maintain a minimum cash balance of $9,000. Q1 Q2 Beginning Cash Balance $ $ Receipts $ $ Disbursements $ $ Preliminary Cash Balance $ Less: Minimum Cash Balance $ $ Cash Excess (Shortage) $ Ending Cash Balance Preliminary Cash Balance $ Financing Required (Pay Notes Payable) $ $ . Ending Cash $