please show how it was done

1 Data sheet Collections: Collected in next month = Collected in the 2 nd month after sale = Total Collections Payments: Paid in next month after purchase = Total Payments for Purchases Other Disbursements: Wages Lease Payment Interest Total Other Disbursements Net Cash Inflow/Outflow Cash Balance beginning month Cash Balance at end of month Additional Information: Dividends are paid 2x a year, June 1 and November 1 in the amount of $50,000 Monthly depreciation is equal to $10,000 Interest on loans are paid every 6 months, June 1 and November 1 in the amount of $30,000 Wages are estimated at 20% of sales Lease payments are $20,000 monthly Cash Balance June 1=$20,000 Data for Cash Budget Demonstration Problem: ABC Company wants you to prepare a cash budget for June thru Sept. based on the information below. 7 Net credit sales: (ABC Company has found that on average they do not collect 2% of all credit sales) 16 Collections: Purchases are paid : Current month 75% One month after purchase 25% Other Disbursements: Adminstrative Expense for all months $50,000