I need the format for excel in how to find it

Your company's bank is concerned about your ability to pay back an outstanding loan. It has asked that you provide them with a Cash Budget for May, June and July of 2020. The following information will help you prepare that cash budget: S Cash Sales Credit Sales Cash Purchases Credit Purchases March 115,000 $ 128,000 45,000 110,000 April 125,000 $ 138,000 42,000 30,000 May 80,000 $ 94,000 88,000 80,000 June 100,000 $ 114,000 110,000 1 14,000 July 120,000 132,000 42,000 100,000 400 1,600 Additional Information: Rental Income per Month Rent Paid Per Month Wages Paid Per Month: Sales Commission Administration Distribution Other 27,600 7,200 34,400 15,600 Customers usually settle their accounts as follows: 85% pay in the month following the sale and take a 5% discount 13% pay in the second month following the sale 296 are written of as uncollectible Accounts payable are settled as follows: 85% are paid in the month of purchase and take a 5% discount 1596 are paid in the month following the purchase and no discount is received Other: Capital Expenditures are planned as follows: Other Capital Expenditures are planned as follows: May June 55,000 July The bank balance at May 1 was $ 175,000 Schedule of Cash Collected from Accounts Receivable Month of Cash Collection Schedule of Payments on Accounts Payable Month of Cash Payment Amount May June July Month of Purchasei Amount May March Month of Sale: March April May June July May June July PROJECTED CASH BUDGET MAY JUNE $ 175,000 OPENING CASH BALANCE Add: Cash Receipts From Cash Sales From Credit Sales From Rental income Total Cash Receipts Less: Cash Payments For Cash Purchases For Credit Purchases For Rent For Wages For Other Operating Costs For Capital Expenditures Total Cash Payments ENDING CASH BALANCE