Status July August September Beginning cash balance 5000 20000 20000 Add: I For Blank Total cash available Less: Cash payments for Total cash payments Preliminary cash balance Loan city Additional loan from bank 5000 0 0 Repayment of loan to bank 0 (3000) (2000) Ending cash balance 20000 20000 22980 Loan balance end of month Click Save and the Jones Consulting, a service company, budgeted the following for July, August, and September: August $240,000 September $245,000 July Cash Receipts (excluding any funds $235.000 received from loans) Operating Expenses includes salaries of $30,000 and $10,000 of depreciation expense excludes any repayment of 5235,000 loans or interest expense) $246,950 $250,000 All cash operating expenses are paid in the month incurred. According to a credit agreement with its bank. Jones requires a minimum cash balance of $20,000 at each month-end. In return, the bank has agreed that the company can borrow up to $100,000 at an annual Interest rate of 12%, with interest paid monthly on the last day of each month. The interest is computed based on the loan balance at the beginning of the month. The company repays loan principal with any cash in excess of $20,000 on the last day of each month. On July 1. Jones had a the following balances: cash, $5,000; loan payable, SO. Prepare monthly cash budgets for July August, and September. Answers in the first (left) column should contain words. Answers in the other three columns should contain numbers Do not use commas. dollar signs or decimals in your numbers. Round to the nearest whole dollar. if necessary. For any negative balances or loan repayments, use parenthesis in your answers