Please show how to do the formulas.Thank you.

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. X 5 ? X Cash Budget with Supporting Cash Collections and Disbursements Schedules - Excel INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW - Sign In FILE HOME Calibri 11 A A = % DD M Paste B I U 1 - A Alignment Number Cells Editing Conditional Format as Cell Formatting Table Styles Styles Clipboard F Font E2 D B C 1 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: 5 Cash sales 6 Sales on account 7 Total Sales $ 1,600 $ 25,000 $ 26,600 $ 3,750 $ 5,100 30.000 40.000 33.750 $ 45.100 Accounts Receivable Collections: Month of sale Month following sale Second month following sale Uncollectible 15% 60% 22% 3% 15 Accounts payable for inventory purchases, March 1 balance 16 Budgeted inventory purchases in March 17 Inventory payments: $10,500 $23,500 ? X X B S FILE D HOME Cash Budget with Supporting Cash Collections and Disbursements Schedules - Excel INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW - Sign In Calibri Paste B IV Alignment Number Cells Editing - 11 A A . 2. - A Font xv fic Conditional Format as Cell Formatting Table Styles Styles Clipboard C20 D E F G H 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 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 18 Cash balance, March 1 19 Add cash receipts: 20 Collections from customers 21 Total cash available 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 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. X 5 ? X Cash Budget with Supporting Cash Collections and Disbursements Schedules - Excel INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW - Sign In FILE HOME Calibri 11 A A = % DD M Paste B I U 1 - A Alignment Number Cells Editing Conditional Format as Cell Formatting Table Styles Styles Clipboard F Font E2 D B C 1 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: 5 Cash sales 6 Sales on account 7 Total Sales $ 1,600 $ 25,000 $ 26,600 $ 3,750 $ 5,100 30.000 40.000 33.750 $ 45.100 Accounts Receivable Collections: Month of sale Month following sale Second month following sale Uncollectible 15% 60% 22% 3% 15 Accounts payable for inventory purchases, March 1 balance 16 Budgeted inventory purchases in March 17 Inventory payments: $10,500 $23,500 ? X X B S FILE D HOME Cash Budget with Supporting Cash Collections and Disbursements Schedules - Excel INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW - Sign In Calibri Paste B IV Alignment Number Cells Editing - 11 A A . 2. - A Font xv fic Conditional Format as Cell Formatting Table Styles Styles Clipboard C20 D E F G H 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 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 18 Cash balance, March 1 19 Add cash receipts: 20 Collections from customers 21 Total cash available 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