need ans as soon as possible please

need answer as soon as possible please.. need explanation too

Cash Budget information Royal Company is preparing budgets for the quarter ending June 30. a) April 1st cash balance is $40,000 b) All sales are on account with the following collection pattern: 70% collected in the month of the sale 25% collected in the month following the sale 5% is uncollectible c) March 31 accounts receivable balance of $30,000 will be collected in full. d) one-half of a month's purchases are paid for in the month of the purchase; the other half is paid in the following month. e) The March 31 accounts payable balance is $12,000. f) Total selling and administration costs are as follows: April $70,000 May $85,000 June $75,000 g) Purchase of equipment costing $143,700 in May and $48,300 in June - all paid in cash h) Royal pays a cash divdend of $49,000 in April - i) Maintain a minimum cash balance of $30,000 i) Royal maintains a 16% open line of credit for $75,000. k) Borrow on first day of the month & repay on the last day of the month. Required: Prepare a cash budget with respective schedules Cash Budget information Royal Company is preparing budgets for the quarter ending June 30. a) April 1st cash balance is $40,000 b) All sales are on account with the following collection pattern: 70% collected in the month of the sale 25% collected in the month following the sale 5% is uncollectible c) March 31 accounts receivable balance of $30,000 will be collected in full. d) one-half of a month's purchases are paid for in the month of the purchase; the other half is paid in the following month. e) The March 31 accounts payable balance is $12,000. f) Total selling and administration costs are as follows: April $70,000 May $85,000 June $75,000 g) Purchase of equipment costing $143,700 in May and $48,300 in June - all paid in cash h) Royal pays a cash divdend of $49,000 in April - i) Maintain a minimum cash balance of $30,000 i) Royal maintains a 16% open line of credit for $75,000. k) Borrow on first day of the month & repay on the last day of the month. Required: Prepare a cash budget with respective schedules