Please help me!!! i need the numbers for Interest Expense and Additional Loan (loan repayment)

Aztec Compony selis its product for $160 per unit: its octual and budpeted sales follow. Ail sales are on credit. Collections are as follows: 30% is collected in the monch of the salo, and the remaining 70% is collected in the month following the saie. Merchandise purchases cost $1% per unit. For those purchases, 60% is paid in the month of purchuse and the other 40% is paid in the month following purchase. The company has a policy to maintain an ending monthly inventory of 21% of the next month's unit sales. The May 31 actual inventacy level of 1,050 units is consistent with this policy. Selling and administrative expenses of $119,000 per month are paid in chah. The company's minimum cash balance at monthend is $150,000. Loans are obtained ot the end of any month when the preliminary cash bolance is below $150,000. Any preliminary cash balance above $150,000 is used to repay loans at month-end. This loan has a 0.5\% monthly interest rate. On May 31 , the loan batance is 546500 , and the company/s cash balance is $150,000. Required: 1. Prepare a schedule of cash recelpts from sales for each of the months of June and July 2. Prepare the merchandise purchases budget for June and July. 3. Prepare a schedule of cash payments for merchandise purchases for June and July. Assume May/s budgeted merchandise purchases is $306,680 4. Prepsre a cash budget for June and July, including any loan activity and interest expense. Compute the loan balance at the end of each month. Complete this question by entering your answers in the tabs below. Prepare a cash budget for June and July, including any loan activity and interest expense. Compute the loan balance at the end of each month. (Negative balances and Loun repayment amounts (if any) should be indicated with minus sign. Round your answers to the nearest whole dollars.)