Question

KUB . . HOME X FILE - 6 Sign In D alibri . Cash Budget with Supporting Cash Collections and Disbursements Schedules - Excel ? INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW MAA DVD U- BA- A Alignment Number Conditional Format as Cell Cells Editing Formatting Table Styles - Styles Paste B I Clipboard Font В38 1 S&P Enterprises needs a cash budget for March. The following information is available. January February March 3 Data 4 Actual January and February and expected March sales: 5 Cash sales 6 Sales on account 7 Total Sales $ $ 1,600 25,000 $_26,600 3,750 $ 5,100 30,000 40,000 33.750 $ 45,100 9 Accounts Receivable Collections: Month of sale Month following sale 12 Second month following sale 13 Uncollectible 15% 60% 22% 3% $10,500 $23,500 15 Accounts payable for inventory purchases, March 1 balance 16 Budgeted inventory purchases in March 17 Inventory payments: Month of purchase 19 Month following purchase 18 60% 40% 20 21 Total budgeted selling & administrative expenses in March 22 Budgeted selling & administrative depreciation in March $12,500 $3,200 24 Other humatarleach dichiaramente in March ... Budget Data Schedules and Cash Budget ... READY + 100% Attempt(s) Hist Show Me

Answer 1

Schedule of Expected Cash Collections
	March
Cash Sales	$           5,100
Credit Sales
January	$           5,500
Febraury	$         18,000
March	$           6,000
Total Cash Collections	$         34,600

Cash Disbursements
	March
March Purchases	$         14,100
Accounts Payable	$         10,500
Total Cash Disbursements	$         24,600

Cash Budget
	March
Beginning Cash	$         11,500
Total Cash Collections	$         34,600
Total Cash Available	$         46,100
Deduct : Disbursements
For Merchandise purchase	$         24,600
For Expenses	$           9,300
For Equipment	$         14,000
For Dividend	$           2,000
Total Disbursements	$         49,900
Excess (Deficiency) of cash	$         -3,800
Financing
Borrowing	$         13,800
Interest
Repayment
Total Financing	$         13,800
Ending Balance	$         10,000