This preview shows pages 1–2. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: ACME Heating and Cooling Company Cash Budget 2010 2011 WORKSHEET November December January February March April May June July August Sales Collections: Cash (20%) First Month: (20%) Second Month (60%) Total Collections Purchases (55% of second month’s sales) Payments (one month lag) CASH BUDGET Cash Receipts Total Collections Cash Disbursements Purchases Wages & Salaries Rent Other Expenses Interest Expense (on new debt) Taxes Purchases of Equipment Loan Repayment Total Disbursements Net Monthly Change in Cash Plus: Beginning Cash Balance Equals: Ending Cash Bal. before ST borrowing Financing Needed Ending Cash Balance Cum Debt Prepare a Cash Budget for the first 6 months of 2011 usng the following information: 1 ACME Forecasted Sales are as follows in 2011: January February March April May June July August 100,000 95,000 88,000 88,000 98,000 111,000 111,000 125,000 2 Historical Sales for 2010 were: November December 97,000 123,000 3 20% of ACME's Sales are CASH. 20% is collected the month after the sale, and the remaning 60% is collected the second month after the sale.20% of ACME's Sales are CASH....
View Full Document
This note was uploaded on 01/10/2012 for the course FINANCE 370 taught by Professor Jones during the Winter '08 term at University of Phoenix.
- Winter '08