Homework+File+1+Week+3 - ACME Heating and Cooling Company...

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: 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.

Page1 / 2

Homework+File+1+Week+3 - ACME Heating and Cooling Company...

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