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 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
0%
Problem 22(8)-5B
Name:
Section:
Score:
Mercury Shoes Inc.
Cash Budget
For the Three Months Ending August 31
Key Code:
Cells with non-gray backgrounds are protected and cannot be edited.
Answers are entered in the cells with gray backgrounds.
Instructions
Incurred in July
Total
Paid in August:
Incurred in July
Incurred in August
Total
2.
[Key essay answer here]
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 payments for:
Supporting calculations:
Collections of accounts receivable:
Sales on
Account Percentage
June July August
April sales 120,000$ 40% 48,000$ –$ –$
May sales:
Payments for manufacturing costs:
Costs on
Account Percentage
Payments
Problem 22(8)-5B
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 August 31
Key Code:
Cells with non-gray backgrounds are protected and cannot be edited.
Paid in July:
Paid in August:
2.