Prepare a Cash Budget with Supporting Cash Collections and Disbursements Schedules.

All answers must be entered as a formula.

XI H 4 Ca Cash Budget with Supporting cash Collections and Disbursements Schedules Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Calib 11 A A A Alignment Number Conditional Format as Cell Cells Editing Paste B I U Formatting Table Styles Clipboard R Font Styles S & P Enterprises needs a cash budget for March. The following information is available. Januar February March Data 4 Actual January and February and expected March sales: S 1.600 3,750 5,100 5 Cash sales 25,000 30,000 40,000 6 Sales on account 7 Total Sales 9 Accounts Receivable Collections: 10 Month of sale 15% 11 Month following sale 12 second month following sale Uncollectible 14 $10,500 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 $3,200 2 Budgeted selling & administrative depreciation in March 24 Other budgeted cash disbursements in March 25 Equipment purchases 26 Dividends to be paid 27 $10,000 28 Minimum cash balance to be maintained 29 March 1 cash balance $11,500 30 March outstanding borrowings 31 March 1 interest due 32 Budget Data Schedules and Cash Budget READY Sign In 10%