FILE HOME INSERT Cash Budget with Supporting Cash Collections and Disbursements Schedules-Excel 7 PAGE LAYOUT FORMULAS DATA REVIEW VIEW Ruler Formula Bar Normal Page Break Page Custom Gridlines Headings Preview Layout Views Zoom 100% Zoom to Window Macros Selection Workbook Views Show Zoom Macros X 8 x Sign In S&P Enterprises needs a cash budget for March. The following information is B C D E S&P Enterprises needs a cash budget for March. The following information is available. 2 3 Data January February March 4 Actual January and February and expected March sales: 5 Cash sales 6 Sales on account 7 Total Sales 8 9 Accounts Receivable Collections: $ 1,600 $ 25,000 3,750 $ 5,100 30,000 40,000 $ 26.600 $ 33,750 $ 45.100 10 Month of sale 11 Month following sale 12 Second month following sale 13 Uncollectible 14 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 20 21 Total budgeted selling & administrative expenses in March 22 Budgeted selling & administrative depreciation in March 23 24 Char hudoated each dichroments in March Budget Data Schedules and Cash Budget READY Attempt(s) 15% 60% 22% 3% $10,500 $23,500 60% 40% $12,500 $3,200 E 100% Hint