How do you do the excel work for this question?

Prepare a Cash Budget with Supporting Cash Collections and Disbursements Schedules. XD H Cash Budget with Supporting Cash Collections and Disbursements Schedules Excel 5 x FILE INSERT PAGE LAYOUT DATA Sign In HOME FORMULAS REVIEW VIEW Calibri 11 A A A. Alignment Number Conditional Format as Cell Formatting Styles Paste Cells Editing B I U Clipboard Font Styles A1 a S&P Enterprises needs a cash budget for March. The following information is S & P Enterprises needs a cash budget for March. The following information is available January February March 3 Data 4 Actual January and February and expected March sales: 3,750 5,100 1,600 5 Cash sales 30,000 40,000 6 Sales on account 25,000 750 45,100 s 26 600 S 337 S 7 Total Sales g Accounts Receivable Collections: Month of sale 10 11 Month following sale 12 second month following sale 13 Uncollectible 14 15 Accounts payable for inventory purchases, March 1 balance $10,500 16 Budgeted inventory purchases in March $23,500 17 Inventory payments: 18 Month of purchase 19 Month following purchase 40% 20 21 Total budgeted selling & administrative expenses in March $12,500 $3,200 22 Budgeted selling & administrative depreciation in March 23 other ed cash disbursements in March