Required 1 Required 2
Required 3 Required 4
Required 5
Required 6
Required 7
Required 8
Cash budgets.
Note: Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Round your fina
to the nearest whole dollar.
DIMSDALE SPORTS COMPANY
Cash Budget
January
February
March
Beginning cash balance
$
20,500
Add: Cash receipts from sales
235,500
719,550
503,044
Total cash available
256,000
Less: Cash payments for:
Merchandise purchases
65,000
291,000
101,200
Sales commissions
Sales salaries
6,000
6,000
6,000
General and administrative salaries
12,000
12,000
12,000
Maintenance
2,200
2,200
2,200
Loan interest
Taxes
0
0
89,000
Purchases of equipment
31,200
96,000
21,600
Purchase of land
0
0
140,000
Total cash payments
116,400
407,200
372,000
Preliminary cash balance
Additional loan (loan repayment)
Ending cash balance
Loan balance
January
February
March
Loan balance - Beginning of month
Additional loan (loan repayment)
Loan balance - End of month
< Required 5
Required 7 >