help with excel project plz

Excel SIM: Cash Budget with Supporting Cash Collections and Disbursements Schedules 1. Prepare a sales budget, including a schedule of expected cash collections 2. Prepare a direct materiais budget, including a scheduie of expected cash distargentents for puichases of materiak: 3. Prepare a cash budget A1 S\&P Enterprises needs a cash budget for March. The following information is \begin{tabular}{|ll} 12 & Second month \\ 13 & Uncollectible \\ 14 & 33 \\ \hline 15 & Accounts payable \\ \hline 0 \end{tabular} 15 Accounts payable for inventory purchases, March 1 balance 16 Budgeted inventory purchases in March $10,500 $23,500 Inventory payments: 18. Month of purchase Month following purchase 20 Total budgeted selling \& administrative expenses in March Budgeted selling \& administrative depreciation in March 22 24 Other budgeted cash disbursements in March 25 Equipment purchases. Dividends to be paid 28 Minimum cash balance to be maintained March 1 cash balance 0. March 1 outstanding borrowings 1 March 1 interest due 3 The company has a line of credit available to bolster the cash balance as needed. 5 When preparing budgets, the company maintains their data on a separate sheet from the actual budget and schedules. 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 18 Cash balance, March 1 Add cash receipts: 20 Collections from customers 21 Total cash available 22 Less disbursements: 23 Payments to suppliers Selling and administrative expenses Equipment purchases Dividends paid Total disbursements Preliminary cash balance Financing: Additional loan Loan repayments Interest 33 Total financing