Forecast Monthly Cash Flow Budget Statement for the Year 2012

Forecast Monthly Cash Flow Budget Statement for the Year 2012

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: Forecast Monthly Cash Flow Budget Statement for the Year 2012-13 Particula rs Start up Jan. Feb. Mar. Apr. May Jun Jul. Aug. Sep. Oct. Nov. Dec. Total Estimated Sales Units 1200 2300 4000 6500 9000 10000 10000 10500 10500 11500 12000 12500 100000 Sales Revenue 21,600 41,400 72,000 117,0 00 162,000 180,0 00 180,00 189,00 189,00 207,00 216,00 225,00 1,800,00 Cash Inflow- Accounts Receivabl e 19,000 35,000 69,000 115,0 00 145,000 177,0 00 180,00 175,00 175,50 190,00 195,00 204,50 168000 Initial capital 300,00 300,000 Long- term Loan 420,00 420,000 Total (A) 720,00 24,500 35,000 69,000 115,0 00 145,000 177,0 00 180,00 175,00 175,50 190,00 195,00 204,50 2,405,50 Cash outflow Accounts Payable 24,500 36,000 52,000 65,00 65,000 70,00 70,200 65,000 55,000 84,000 90,000 98,500 775200 Worker wages 25,400 25,400 25,400 25,40 25,400 25,40 25,400 25,400 25,400 25,400 25,400 25,400 304800 Factory Rent 10,000 10,000 10,000 10,00 10,000 10,00 10,000 10,000 10,000 10,000 10,000 10,000 120000 Electricity and Utilities 2,500 2,500 2,500 2,500 2,800 2,800 2,800 2,800 2,800 2,800 2,800 2,800 32400 Other Admin expenses 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 36000 Sales Promotio n 22,000 6,500 6,500 4,000 4000 4,000...
View Full Document

This note was uploaded on 01/18/2012 for the course DEP 235 taught by Professor Eeer during the Spring '11 term at Assoc. of Chartered Certified Accountants.

Page1 / 6

Forecast Monthly Cash Flow Budget Statement for the Year 2012

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