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

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

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 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 $215....
View Full Document

This note was uploaded on 11/15/2010 for the course FINANCE FI515 taught by Professor Haertel during the Spring '10 term at DeVry Denver.

Page1 / 2

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

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online