Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Accessibility tab summary: Financial information for S and P enterprises, is presented in cells A3 to D7 and rows 9 to 30. A statement for
Accessibility tab summary: Financial information for S and P enterprises, is presented in cells A3 to D7 and rows 9 to 30. A statement for requirement is presented in rows 36 to 43. A table of expected cash collections for student presentation is presented in cells A2 to B8. A table for payment to suppliers for student presentation is presented in cells A10 to B13. The cash budget for student presentation is presented in cells A15 to C34. | ||
Expected cash collections: | ||
March cash collections | $5,100 | |
March collections on account: | ||
January sales | 5,500 | |
February sales | 18,000 | |
March sales | 6,000 | |
Total cash collections | $34,600 | |
Payments to suppliers: | ||
Accounts payable for inventory purchases, beginning balance | $10,500 | |
March purchases | 14,100 | |
Total cash payments | $24,600 | |
S&P Enterprises | ||
Cash Budget | ||
For the Month of March | ||
Cash balance, March 1 | $11,500 | |
Add cash receipts: | ||
Collections from customers | 34,600 | |
Total cash available | 46,100 | |
Less disbursements: | ||
Payments to suppliers | $24,600 | |
Selling and administrative expenses | 9,300 | |
Equipment purchases | 14,000 | |
Dividends paid | 2,000 | |
Total disbursements | 49,900 | |
Preliminary cash balance | (3,800) | |
Financing: | ? | |
Additional loan | ? | |
Loan repayments | ? | |
Interest | ? | |
Total financing | ? | |
Cash balance, March 31 | ? | |
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