Answered step by step
Verified Expert Solution
Question
1 Approved Answer
S&P Enterprises needs a cash budget for March. The following information is available. Data Actual January and February and expected March sales: Cash sales
S&P Enterprises needs a cash budget for March. The following information is available. Data Actual January and February and expected March sales: Cash sales Sales on account Total Sales Accounts Receivable Collections: Month of sale January February March $1,600 $3,750 $5,100 25,000 30,000 40,000 $26,600 $33,750 $45,100 15% Month following sale 60% Second month following sale 22% Uncollectible 3% Accounts payable for inventory purchases, March 1 balance $10,500 Budgeted inventory purchases in March $23,500 Inventory payments: Month of purchase 60% Month following purchase 40% Total budgeted selling & administrative expenses in March (including depreciation) Budgeted depreciation in March (included in total selling and admin exp) $12,500 $3,200 Other budgeted cash disbursements in March Equipment purchases Dividends to be paid $14,000 $2,000 Minimum cash balance to be maintained $10,000 March 1 cash balance March 1 outstanding borrowings $11,500 $0 March 1 interest due $0 The company has a line of credit available to bolster the cash balance as needed.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started