An asterisk (*) will appear to the right of an incorrect entry. The essay answer will not be graded.
Enter a zero in cells you would otherwise leave blank.
1.
May June July
Estimated cash receipts from:
Cash sales
Collections from accounts receivable
Total cash receipts
Estimated cash payments for:
Manufacturing costs
Selling and administrative expenses
Capital expenditures
Other purposes:
Income tax
Dividends
Total cash payments
Cash increase (decrease)
Cash balance at beginning of month
Cash balance at end of month
Minimum cash balance
Excess (deficiency)
Supporting calculations:
Collections of accounts receivable:
Sales on
Account Percentage
May June July
March sales
April sales:
Collected in May
Collected in June
May sales:
Collected in June
Collected in July
June sales
Totals
Payments for manufacturing costs:
Costs on
Account Percentage
Payments
Paid in May:
Incurred in April
Incurred in May
Total
Paid in June:
Incurred in May
Incurred in June
Total
Paid in July
Incurred in June
Incurred in July
Total
2.
0%
Problem 22-4A
Name:
Section:
Score:
[Key essay answer here]
SONOMA HOUSEWARES INC.
Cash Budget
For the Three Months Ending July 31, 2014
Key Code:
Cells with non-gray backgrounds are protected and cannot be edited.
[Key code here]
Answers are entered in the cells with gray backgrounds.
Instructions
Cells with non-gray backgrounds are protected and cannot be edited.
Problem 22-4A
Name:
Solution
Section:
Score:
Instructions
Answers are entered in the cells with gray backgrounds.
ON
SONOMA HOUSEWARES INC.
Cash Budget
For the Three Months Ending July 31, 2014