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.
September October November
Estimated cash receipts from:
Cash sales
Collections from accounts receivable
Total cash receipts
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
September October November
July sales
August sales:
Collected in September
Collected in October
September sales:
Collected in October
Collected in November
October sales
Totals
Payments for manufacturing costs:
Costs on
Account Percentage
Payments
Paid in September:
Incurred in August
Incurred in September
Total
Paid in October:
Incurred in September
Bridgeport Housewares Inc.
Cash Budget
For the Three Months Ending November 30
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
0%
Name:
Section:
Score:
Incurred in October
Total
Paid in November
Incurred in October
Incurred in November
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.
September October November
Estimated cash receipts from:
Other purposes:
Income tax – (55,000) –
Supporting calculations:
Collections of accounts receivable:
Sales on
Account Percentage
September October November
July sales 200,000$ 30% 60,000$ –$ –$
August sales:
Payments for manufacturing costs:
Costs on
Account Percentage
Payments
Paid in September:
Score:
Instructions
Answers are entered in the cells with gray backgrounds.
ON
Bridgeport Housewares Inc.
Cash Budget
For the Three Months Ending November 30
Cells with non-gray backgrounds are protected and cannot be edited.
Problem 22(8)-5A
Name:
Solution
Section:
Paid in October:
2.