Enter Formulas***

1. Prepare a sa es 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 7 Cash Budget with Supporting Cash Collections and Disbursements Schedules - Excel INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW FLE HOME Sign in Cat 99 BU- Cells Alignment Number Conditional Formatas Cell Formatting Table Styles Clipboard Fant A1 S&P Enterprises needs a cash budget for March. The following information is A C D E . 1 a enterprises neeos a cash ouoget for Marcn. ine Tollowing intornanon is available. 2 3 ata January February March ctual January and February and expected March sales: 5 ash sales 5 1,600 5 3,750 5 5,100 iles on account 25,000 30.000 40.000 7 al Sales 25.60039.750 S 45.100 9 10 11 12 13 ccounts Receivable Collections: Month of sale Month following sale Second month following sale Uncollectible 1596 6096 229 396 $10,500 $23,500 17 609 15 ccounts payable for inventory purchases, March 1 balance 16 udgeted inventory purchases in March ventory payments: 18 Month of purchase 19 Month following purchase 20 21 stal budgeted selling & administrative expenses in March 22 udeeted selling & administrative depreciation in March 409 512,500 $3,200 7 5 X HS FILE Cash Budget with Supporting Cash Collections and Disbursement Schedules Gel INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW HOME Sign up Cat 11 AA Paste BU- Cell Alignment Number Conditional Format Cell Formatting Table Styles Clipboard Foot A1 S&P Enterprises needs a cash budget for March. The following information is 0 E . 22 SO 22 Budgeted selling & administrative depreciation in March $3,200 23 24 Other budgeted cash disbursements in March 25 Equipment purchases 514,000 26 Dividends to be paid $2,000 28 Minimum cash balance to be maintained 510,000 29 March 1 cash balance 511 500 30 March 1 outstanding borrowings 31 March 1 interest due 50 32 13 The company has a line of credit available to bolster the cash balance as needed. 34 as when preparing budgets, the company maintains their data on a separate sheet from the actual budget and schedules 27 click the schedules and Cash Budget tab to prepare the following 38 1. Schedule of expected cash collections for March 39 2. Schedule of expected cash disbursements for inventory purchases for March 403. Cash budget for March. Indicate in the financing section any borrowing that will be needed in March. Assume that 41 any interest will not be paid until the following month 42 a 36 43 64 45 FO Budget Data Schedules and Cash Budget 100% READY Attempt(s) 1 FILE HOME Cash Budget with Supporting Cash Collections and Disbursements Schedules Excel PAGE LAYOUT FORMULAS DATA REVIEW VIEW INSERT Sign In Caribe 11 AA Cells Alignment Number Conditional Format as Cell Formatting - Table Styles - Chipboard font > A1 Expected cash collections: C D D E . 1 Expected cash collections: 2 March cash collections 3 March collections on account: 4 January sales 5 February sales G 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 15 Cash Budget 16 For the Month of March 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 24 Selline and administrative pent Budget Data Schedules and Cash Budget READY Attempt(s) 100%. St Me PLE con suger with supporting cocoon and useme soneome LACE INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW HOME Sign Calit ka Pante BU Cell Alignment Number Conditional Formats Cell Formatting Table Styles Styles Clipboard Font A1 Expected cash collections: C D E 14 S&P Enterprises 15 Cash Budget IG For the Month of March 17 18 Cash balance, March 1 19 Add cash receipts 20 Collections from customers 21 Total cash available 22 Less disbursements: 22 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 21 Loan repayments 32 Interest 33 Total financing 34 Cash balance, March 31 35 36 37 Budget Data Schedules and Cash Budget READY Attemptis) E 100% Sche