{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

FI_515_Cash_Budget_21-1(1)

FI_515_Cash_Budget_21-1(1) - Table 21-1 Cash Budget May...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Table 21-1 Cash Budget May June July August September October November December Assumptions (1) Sales Gross $200 $250 $300 $400 $500 $350 $250 $200 Cash Sales: 20% Of Current Month Collections During 1st month: 70% Of Previous Month (2) During the month of sale $59 $78 $98 $69 $49 $39 During 2nd month: 10% Of 2 Months Prior (3) During first month after sale $175 $210 $280 $350 $245 $175 Discount: 2% (4) During 2nd month after sale $20 $25 $30 $40 $50 $35 Total Collections $254 $313 $408 $459 $344 $249 Purchases Purchases: 70% Of Next Month (6) Of Next Month's Sales $210 $280 $350 $245 $175 $140 (7) Payments $210 $280 $350 $245 $175 $140 Cash Gain or Loss for Month (8) Collections $254 $313 $408 $459 $344 $249 (9) Payment for Purchases $210 $280 $350 $245 $175 $140 (10) Wages $30 $40 $50 $40 $30 $30 (11) Rent $15 $15 $15 $15 $15 $15 (12) Other Expenses $10 $15 $20 $15 $10 $10 (13) Taxes $30 $20 (14) Payment for construction $100 (15) Total Payments $265.0 $350.0 $465.0 $415.0 $230.0 $215.0 (16) Net Net Cash Gain or Loss $(11) $(37) $(57) $44 $114 $34 Loan Requirement/Cash Surplus (17) Cash at Start of Month $15 $4 $(33) $(90) $(46) $68 (18)Cash after Operations $4 $(33) $(90) $(46) $68 $102 (19) Target Cash Balance $10 $10 $10 $10 $10 $10 (20) Cummulative +-Cash $(6) $(43) $(100) $(56) $58 $92
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Table 21-1
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}