Cash Budget with Supporting Cash Collections and Disbursements Schedules 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 H > Cash Budget with Supporting Cash Collections and Disbursements Schedules - Excel INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW 7 FILE HOME Sign In Ruler Formula Bar Normal Page Break Page Custom Preview Layout Views Workbook Views Gridlines Headings Zoom 100% Zoom to Window Macros Selection Zoom Macros Show A1 X S&P Enterprises needs a cash budget for March. The following information is D 1 S&P Enterprises needs a cash budget for March. The following information is available. 2 January February March 6 $ 1,600 $ 3,750 $ 5,100 25,000 30,000 40,000 $ 26,600 $33.750 $45.100 3 Data 4 Actual January and February and expected March sales: 5 Cash sales Sales on account 7 Total Sales 8 9 Accounts Receivable Collections: Month of sale 11 Month following sale Second month following sale Uncollectible 10 15% 60% 22% 3% 12 13 14 15 Accounts payable for inventory purchases, March 1 balance $10,500 $10,500 $23,500 60% 40% 15 Accounts payable for inventory purchases, March 1 balance 16 Budgeted inventory purchases in March 17 Inventory payments: 18 Month of purchase 19 Month following purchase 21 Total budgeted selling & administrative expenses in March 22 Budgeted selling & administrative depreciation in March 23 24 Other hudentartrach dichureamante in March Budget Data Schedules and Cash Budget 20 $12,500 $3,200 100% B D E 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 13 14 15 S & P Enterprises Cash Budget For the Month of March 16 17 18 Cash balance, March 1 19 Add cash receipts: 20 Collections from customers 21 Total cash available 22 Less disbursements: 23 Payments to suppliers 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 4