CBC company has provided the following estimates for the month of July 2021:

The cash balance first January 2021 $8,600 Credit sales 68,400 Receipts from debtors 62,000 Wages incurred (90% paid) 42,000 Office furniture purchased in cash 9,500 Purchase of office computer on credit 2,000 Utilities expenses paid 3,800 Accounts payable 500 Administrative expenses paid 29,000 Depreciation on office furniture 8,200 Received of loan 15,000 Credit purchase 59,200 Payments to creditors 48,600 Cash sales 42,000

Required: Prepare a cash budget for the month of July