80.2K

Verified Solution

Link Copied!

A1 for S&P Enterprises needs a cash budget for March. The following information is E A B C D 1 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 $ 1,600 $ 3,750 $ 5,100 6 Sales on account 25,000 30,000 40,000 7 Total Sales $ 26,600 $ 33.750 $45.100 8 9 Accounts Receivable Collections: 10 Month of sale 15% Month following sale 60% 12 Second month following sale 22% 13 Uncollectible 3% 11 14 $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 20 21 Total budgeted selling & administrative expenses in March 22 Budgeted selling & administrative depreciation in March 23 24 Other hudatedrach dichureements in March Budget Data Schedules and Cash Budget $12.500 $3,200 4 HIP EN 100% READY Attempt(o) Hint A1 fx Expected cash collections: B D E A 19 Add cash receipts: 20 Collections from customers 21 Total cash available 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 35 36 37 38 39 40 41 42 Budget Data Schedules and Cash Budget E READY Attempt(s) 100% Hint Please answer with formula! Thank you! A1 for S&P Enterprises needs a cash budget for March. The following information is E A B C D 1 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 $ 1,600 $ 3,750 $ 5,100 6 Sales on account 25,000 30,000 40,000 7 Total Sales $ 26,600 $ 33.750 $45.100 8 9 Accounts Receivable Collections: 10 Month of sale 15% Month following sale 60% 12 Second month following sale 22% 13 Uncollectible 3% 11 14 $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 20 21 Total budgeted selling & administrative expenses in March 22 Budgeted selling & administrative depreciation in March 23 24 Other hudatedrach dichureements in March Budget Data Schedules and Cash Budget $12.500 $3,200 4 HIP EN 100% READY Attempt(o) Hint A1 fx Expected cash collections: B D E A 19 Add cash receipts: 20 Collections from customers 21 Total cash available 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 35 36 37 38 39 40 41 42 Budget Data Schedules and Cash Budget E READY Attempt(s) 100% Hint Please answer with formula! Thank you

Answer & Explanation Solved by verified expert

See Answer