Cash balance as of march 31 $74,000 inventory balance as of march 31 $104,000 merchandise purchases for march $200,000 the company maintains a minimum cash balance of at least $50,000 at the end of each month. all borrowing is done at the beginning of a month; any repayments are made at the end of a month. the company has an agreement with a bank that allows the company to borrow the exact amount needed at the beginning of each month. the interest rate on these loans is 1% per month and for simplicity we will assume that interest is not compounded. at the end of the quarter, the company will pay the bank all of the accrued interest on the loan and as much of the loan as possible while still retaining at least $50,000 in cash. required: prepare a cash budget for the three-month period ending june 30. include the following detailed budgets: 1. a. a sales budget, by month and in total. b. a schedule of expected cash collections from sales, by month and in total. c. a merchandise purchases budget in units and in dollars. show the budget by month and in total. d. a schedule of expected cash disbursements for merchandise purchases, by month and in total. 2. a cash budget. show the budget by month and in total. determine any borrowing that would be needed to maintain the minimum cash balance of $50,000.