446
Integrated Case
Chapter 15: Working Capital Management
Table IC 15.2. SKI’s Cash Budget for January and February
Nov Dec Jan Feb Mar Apr
I. Collections and Purchases Worksheet
(2) During month of sale
(3) During first month after sale
(4) During second month after sale
(0.1)(sales 2 months ago) 7,121.80 6,821.20
(7) Payments (1–month lag) 44,603.75 36,472.65
II. Cash Gain or Loss for Month
(9) Payments for purchases (from Section I) 44,603.75 36,472.65
(11) Rent 2,500.00 2,500.00
(13) Total payments $53,794.31 $44,443.55
(14) Net cash gain (loss) during month
(15) Cash at beginning of month
(18) Cumulative surplus cash or loans outstanding
to maintain $1,500 target cash balance
(Line 16 – Line 17) $15,357.64 $33,669.49
F. In his preliminary cash budget, Barnes has assumed that all sales
are collected and thus that SKI has no bad debts. Is this realistic?
If not, how would bad debts be dealt with in a cash budgeting
sense? (
Hint:
Bad debts affect collections but not purchases.)