please use Excel formula format in answer as shown in the picture taken with a yellow slot solved

mework i Saved Styles Clipboard Formatting Table Styles Font B10 fo ='Budget Data'!B15 B D $ 5,100 1 Expected cash collections: 2 March cash collections 3 March collections on account: 4 January sales 5 February sales 6 March sales 7 Total cash collections 8 9 Payments to suppliers: 10 Accounts payable for inventory purchases, beginning balance 11 March purchases 12 Total cash payments $ 10,500 13 14 15 16 17 S&P Enterprises Cash Budget For the Month of March 18 Cash balance, March 1 19 Add cash receipts: 20 Collections from customers 21 Total cash available 22 Less disbursements: Payments in sinnliers $ 11,500 9 I OLIE Jlyies d Font Styles V fx B D Cash Budget For the Month of March $ 11,500 Cash balance, March 1 add cash receipts: Collections from customers Total cash available Less disbursements: Payments to suppliers Selling and administrative expenses Equipment purchases Dividends paid 7 Total disbursements * Preliminary cash balance 29 Financing Additional loan 31 Loan repayments Interest 33 Total financing 34 Cash balance, March 31 35 36 9,300 14,000 2,000 Submi 1. Prepare a sales budget, including a schedule of expected cash collections 2. Prepare a direct materials budget, including a schedule of expected cash disbursements for purchases of materials. 3. Prepare a cash budget. 7 D KI 5 Cash Budget with Supporting Cash Collections and Disbursements Schedules - Excel INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign in FILE HOME Ruler Formula Bar Gridlines Headings Normal Page Break Page Custom Preview Layout Views Workbook Views Zoom 100% Zoom to Window Macros Selection Zoom Macros