CashBudget All Office pot stuns du cash budgeting every quarter. One store is plaming its cash need for the third quarter of the year, and the following information is available to in preparing nudget. Hudged statements for July through October are as follows July August September October $5,000 $5,000 $60,000 $75,000 Conf Gro 23500 25,000 21500 26300 20,500 25,000 29.500 40.000 GOOD 000 Adv 100 10,500 8,500 10,000 8500 9400 T 15,100 1,500 17,000 10,900 SE400 $4000 $12,500 $20,00 Additional information follow 1. Other exper which are paid monthly include $3,500 of deprecation per month 2. Salsa 44% for unh and 56 un cred 3. Credit collected 50% in the month of sale, 25 one month aber and 15 two month May $40,000, jure $42,000. 4. Merchandised for 50% in the month of purchase, the mining 50% paid in the following month. Accounts payable for marchandise Jun 30 $12,000. The store mandatory has at 30% of the cost of youch to be sold in the following month the airy 30 $600 6. A of $10,000 per month being paid through August The stone mul maintain a cash balance of at least $10,000 at the end of each month. The cash baju 30 $10,000 8. the stone can borrow from its bank a rated Borrowings and repayments must be in multiples of $100. All bowings take place at the beginning of a month, and all repayments are made at the end of a month. When the principal is repaid interest on the repayment is as paid the interest rate is 600 per year. Required Proper a monthly schedule of bed operating cast recipit for july August, and September OFFICE DEPOT Schedule of Cash Receipts July, August, and September Cash sales Current mont amand Tu manth prior sa July Aug Sept Propane a monthly purchases budget and schedule of budgeted cash payments for purchase for July, August and September Note: Do not use any negative signs with your awes OFFICE DEPOT Purchase Budget July, August, and September July Pandered ending inamary Tozalary red OFFICE DEPOT Aug Sept Schedule of Cash Disbursements for Purchases July, August, and September Current month July Aug Sapt Prepare a monthly cash budget for july, Auguil, and September. Show borrowings from and repayment to the bank detain that minimum cash balance Not any regations with your tow OFFICE DEPOT CashBudget Third Quarter July Aug Sept Cash balance b Cash Cash diber Onerepenes deprecation Total d Rance before bomawing or repaymen Servings Cash balance anding Check 15 $ $