with excel formulas please

Saved Project FILE HOME INSERT X Calibri - 11 PAGE LAYOUT DATA FORMULAS REVIEW A VIEW Sign In - A A 96 M Cell Alignment Number Conditional Format as Cells Editing Formatting Table Styles Sye fa S&P Enterprises needs a cash budget for March. The following information is E 8 D Uncollectible 3% 13 14 $10,500 15 Accounts payable for inventory purchases, March 1 balance 16 Budgeted inventory purchases in March $23,500 17 Inventory payments: 18 Month of purchase 60% 19 Month following purchase 40% 20 21 Total budgeted selling & administrative expenses in March $12,500 22 Budgeted selling & administrative depreciation in March $3,200 23 24 Other budgeted cash disbursements in March 23 Equipment purchases $14,000 26 Dividends to be paid $2,000 27 23 Minimum cash balance to be maintained $10,000 29 March 1 cash balance $11,500 30 March 1 outstanding borrowings $0 31 March 1 interest due 32 $0 The company has a line of credit available to bolster the cash balance as needed. 34 When preparing budgets, the company maintains their data on a separate sheet from the actual budget and schedules. Budget Data Schedules and Cash Budget el Project INSERT FILE HOME Callion -111 Opboards Font > v D E 1 Expected cosh 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 13 14 S&P Enterprises 25 Cash Budget 16 For the Month of March 17 13 Cash balance, March 1 19 Add cash receipts: 20 Collections from customers 21 Total cash available before current financing 22 less disbursements: 23 Payments to suppliers 24 Selling and administrative expenses Budget Data Schedules and Cash Budget 1 5 1 - 1 Sign In I 5 Cash Budget with Supporting Cash Collections and Disbursements Schedules - Excel INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW FILE HOME M Calibri - 11 Cells Editing -AA % A Alignment Number Conditional Format as Cell Formatting Table Styles Styles Paste BTU- A