Please follow chart and show work

-Extra Credit (Chapter 21) Name: Using the following data to prepare the July cash budget for Star One Enterprises. The cash budget should show expected cash receipts and cash disbursements for the month and the cash balance expected on July 31st (a) Beginning cash balance on July 1 is $75,000. (b) Cash receipts expected from sales: 20% is collected in the month of sale, 40% in the next month, and 40% in the second month after sale. Star One's actual sales were: May $1,850,000 and June $1,400,000. Budgeted sales for July are $1,650,000 (c) Star One had the following payments on merchandise: 40% in the month of purchase and 60% in the month following purchase. Purchases amounts are: June (actual), $840,000; and July (budgeted), $825,000. (d) Salary cash disbursements of $325,000 are budgeted for July. (e) Budgeted depreciation expense for July is $210,000. (t) Other cash expenses of $190,000 are budgeted for July. (g) Accrued income taxes of $100,000 are due in July (h) Star One has $6,500 due in July for interest on the bank loan. List only those items needed to prepare a Cash Budget. Ample lines are provided. Some (not all) of the titles have already been setup for you Star One Enterprises Cash Budget For the Month Ended July 31 Beginning Cash Balance Cash Receipts from Sales Total Cash Available Cash Disbursements Total Cash Disbursements Ending Cash Balance