of 3 Pages Dana Mackay, controller for Gulf Coast Retailers, has assembled the following data to assist in the preparation of a cash budget for the third quarter of the year: a. Sales: May (actual) $100,000 June (actual) $120,000 July (estimated) $ 90,000 August (estimated) $100,000 September (estimated) $135,000 October (estimated) $110,000 b. Each month, 30% of sales are for cash and 70% are on credit. The collection pattern for credit sales is 20% in the month of sale, 50% in the following month, and 30% in the second month following the sale. c. Each month, the ending inventory exactly equals sox of the cost of next month's sales. The gross margin percentage is 20%. d. Inventory purchases are paid for in the month following the purchase. e. Recurring monthly expenses are as follows: Salaries and wages Depreciation on PPE Utilities $5,000 $4,000 $1,000 4. Property taxes of $900 are due and payable on July 15 & Advertising fees of $600 is incurred in July and must be paid on August 20 h. The company has a policy to maintain a minimum cash balance of $30,000. If necessary. It will borrow to meet its short-term needs. All borrowing is done at the beginning of the month. All payments on principal and interest are made at the end of a month. The annual interest rate is 9%. The company must borrow in multiples of $1,000 LA partially completed balance sheet as of June 30 follows. (Note: Accounts payable is for inventory purchases only.) Cash A/R Inventory PPE, net A/P Common Stock Retained Earnings $13,550 588,200 $35,000 $425,000 584,000 $210,000 5268,750 MacBook Air 30 000 f. Property taxes of $900 are due and payable on July 15 8. Advertising fees of $600 is incurred in July and must be paid on August 20. h. The company has a policy to maintain a minimum cash balance of $30,000. If necessary, it will borrow to meet its short-term needs. All borrowing is done at the beginning of the month. All payments on principal and interest are made at the end of a month. The annual interest rate is 9%. The company must borrow in multiples of $1,000. 1. A partially completed balance sheet as of June 30 follows. (Note: Accounts payable is for inventory purchases only.) Cash A/R Inventory PPE, net $13,550 $88,200 $36,000 $425,000 $84,000 $210,000 $268,750 A/P Common Stock Retained Earnings Required 1. Prepare a cash budget for the month of July: Prepare a supporting schedule of cash collections. [25 points) 2. Prepare and income Statement for the month of July (12 points) 3. Prepare a budgeted balance sheet as of July 31 (14 points) MacBook DOO OOO