Dash Shoes Inc. Cash Budget
For the Three Months Ending May 31, 2016
March April May
Estimated cash receipts from:
Cash sales $16,500 $21,000 $27,450
Collection of accounts receivable $62,400 $91,000 $118,950
Dividends $3,300 - -
Total cash receipts $82,200 $112,000 $146,400
Estimated cash payments for:
Manufacturing costs $36,800 $48,000 $52,800
Selling and administrative expenses $32,000 $38,000 $40,000
Capital expenditures - - $44,000
Other purposes:
Note payable (including interest) - - -
Income tax - $17,000 -
Dividends - - $10,000
Total cash payments $68,800 $103,000 $146,800
Cash increase or decrease $13,400 $9,000 $(400)
Cash balance at beginning of month $42,000 $55,400 $64,400
Cash balance at end of month $55,400 $64,400 $64,000
Minimum cash balance $33,000 $33,000 $33,000
Excess or (deficiency) $22,400 $31,400 $(1,000)
