1. Use the Budget Data tab to complete the Schedules and Cash Budget tab. Formulas must be entered so that all cash flow amounts are positive numbers. Cash Budget with Supporting Cash Collections and Disbursements Schedules - Excel FILE HOME INSERT Paste Clipboard A1 *] Calibri BIU ? Sign In PAGE LAYOUT FORMULAS DATA REVIEW VIEW 11 . % Alignment Number Font Conditional Format as Cell Formatting Table Styles Styles Cells Editing x fx Expected cash collections: A B D E 1 Expected cash collections: 2 March cash collections 3 March collections on account: January sales 4 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 15 16 17 18 Cash balance, March 1 19 Add cash receipts: 20 Collections from customers 21 Total cash available S&P Enterprises Cash Budget For the Month of March 22 Less disbursements: 23 Payments to suppliers 24 Selling and administrative exnences Budget Data READY Attempt(s) Schedules and Cash Budget + ^ > + 100% Hint 1. Use the Budget Data tab to complete the Schedules and Cash Budget tab. Formulas must be entered so that all cash flow amounts are positive numbers. Cash Budget with Supporting Cash Collections and Disbursements Schedules - Excel ? FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri 11 A A % M Paste Clipboard A1 BIU *| Font Cell Alignment Number Conditional Format as Formatting Table Styles Styles Cells Editing v fx Expected cash collections: A B C D E 24 Selling and administrative expenses 25 26 Equipment purchases Dividends paid 27 Total disbursements 28 Cash balance before financing 29 Financing: 30 Borrowings/Repayments 31 Cash balance, March 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 READY Attempt(s) Budget Data Schedules and Cash Budget B + 100% Hint