cash budget spreadsheet Spring 2010

cash budget spreadsheet Spring 2010 - Example of a Cash...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Example of a Cash Budget From Hockey Den Example in Book Cash Received From Collection of Accounts Receivable Oct Nov Dec Sept $70,000 28,000 Remember, 40% of Sept is collected in Oct Oct $100,000 60,000 40,000 60% of Oct collected in Oct, 40% in Nov Nov $80,000 48,000 32,000 60% of Nov collected in Nov, 40% in Dec Dec $140,000 84,000 60% of Dec collected in Dec, 40% in Jan Jan $90,000 Total Collections 88,000 88,000 116,000 Mechandise Purchases Cash Budget Oct Nov Dec Sept 30 AP Balance $58,200 43,650 14,550 75% of Sept AP paid in Oct, 25% in Nov Oct 31 AP Balance $49,200 36,900 12,300 75% of Oct AP paid in Nov, 25% in Dec Nov 30 AP Balance $80,400 60,300 75% Nov AP paid in Dec, 25% in Jan Dec 31 AP Balance $57,000 Nothing paid because it is Due in Jan/Feb Total Payments 43,650 51,450 72,600 EXAMPLE OF A CASH BUDGET Oct Nov Dec Beginning Cash Balance 20,000 5,350 $7,900 Cash Inflows 88,000 88,000 116,000 Taken from Calculation ABOVE Other misc cash receipts
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.
Ask a homework question - tutors are online