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.
June July August
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
June July August
April sales
May sales:
Collected in June
Collected in July
June sales:
Collected in July
Collected in August
July sales
Payments for manufacturing costs:
Costs on
Account Percentage
Payments
Paid in June:
Incurred in May
Incurred in June
Total
Paid in July:
Incurred in June
Incurred in July
Total
Paid in August:
Incurred in July
Incurred in August
Total
2.
0%
Problem 21(6)-4B
Name:
Section:
Score:
[Key essay answer here]
MERCURY SHOES INC.
Cash Budget
For the Three Months Ending June 30, 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 21(6)-4B
Name:
Solution
Section:
Score:
Instructions
Answers are entered in the cells with gray backgrounds.
ON
MERCURY SHOES INC.
Cash Budget
For the Three Months Ending June 30, 2014
Key Code: