Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Excel McGraw Hill Excel Question - Saved V Search (Option Q) File Home Insert Draw Formulas Data Review View Help Editing Calibri 11 B
Excel McGraw Hill Excel Question - Saved V Search (Option Q) File Home Insert Draw Formulas Data Review View Help Editing Calibri 11 B General A1 S&P Enterprises needs a cash budget for March. The following information is available. B C D E 1 S&P Enterprises needs a cash budget for March. The following information is available. 2 3 Data January February March 5 Cash sales 4 Actual January and February and expected March sales: 6 Sales on account 7 Total Sales 8 9 Accounts Receivable Collections: $1,600 $3,750 $5,100 25,000 30,000 40,000 $26,600 $33,750 $45,100 10 Month of sale 15% 11 Month following sale 60% 12 Second month following sale 22% 13 Uncollectible 3% 14 Accounts payable for inventory purchases, March 1 balance $10,500 15 Budgeted inventory purchases in March $23,500 16 Inventory payments: 17 Month of purchase 18 Month following purchase 19 20 Total budgeted selling & administrative expenses in March (including depreciation) $12,500 21 Budgeted depreciation in March (included in total selling and admin exp) $3,200 22 60% 40% 23 Other budgeted cash disbursements in March 24 Equipment purchases 25 Dividends torbe paid 26 27 Minimum cash balance to be maintained 28 March 1 cash balance $14,000 $2,000 $10,000 $11,500 Budget Data Schedules and Cash Budget + Calculation Mode: Automatic Workbook Statistics
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