please use formulas for the answer thank you :))

Excel SIM: Cash Budget with Supporting Cash Collections and Disbursements Schedules 1. Prepare a sales budget, induding a schedule of expected cash collections 2. Prepare a drect materiais budgeL. Including a schedule of expected cash disbursements for purchases of materialis. 3. Piepare a cash budget. 1 Expected cash collections: 2. March cash collections 3 March collections on account: January sales February sales March sales Total cash collections 9 Payments to suppliers: 10 Accounts payable for inventory purchases, beginning balance 11 March purchases 12 Total cash payments S \& P Enterprises Cash Budget For the Month of March Cash balance, March 1 Add cash receipts: Collections from customers Total cash available Less disbursements: Payments to suppliers 24. Sellino and administrative pxnenses A1 Fole i. Signtopy 14 Cash balance.March-1 A Expected cash collections: 19 Add cash receipts: 20 Collections from customers 21 Total cash avallable 22 Less disbursements: 23. Payments to suppliers 24 Selling and administrative expenses 25 Equipment purchases 26 Dividends paid 27 Total disbursements 28 Preliminary cash balance 29 Financing: 30 Additional loan 31 Loan repayments 32 Interest 33 Total financing 34 Cash balance, March 31 35363738194041