Exercise 7 12_Month_Cash_Flow_2

Exercise 7 12_Month_Cash_Flow_2 - Cash Flow (12 months)...

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

View Full Document Right Arrow Icon
Cash Flow (12 months) Enter Company Name Here Fiscal Year Begins: Jan-11 Pre-Startup EST Jan-11 Feb-11 Mar-11 Apr-11 May-11 Jun-11 Jul-11 Aug-11 Sep-11 Oct-11 Nov-11 Dec-11 Total Item EST Cash on Hand (beginning of month) 10,000 10,000 -71,650 -85,500 -96,397 -104,520 -110,074 -111,309 -112,523 -113,671 -114,756 -115,811 -117,001 10,000 CASH RECEIPTS Cash Sales 0 0 0 0 0 0 0 0 0 0 0 0 0 Collections fm CR accounts 46,000 46,000 46,000 46,000 46,000 46,000 46,000 46,000 46,000 46,000 46,000 46,000 552,000 Reoccuring Payments 0 6,000 7,441 7,784 7,869 7,893 7,914 7,964 8,089 8,120 7,949 8,862 85,884 Loss Collections 0 -1,200 -1,488 -1,556 -1,573 -1,578 -1,578 -1,563 -1,624 -1,624 -1,590 -1,679 -17,053 Loan/ other cash inj. 0 TOTAL CASH RECEIPTS 0 46,000 50,800 51,953 52,227 52,296 52,315 52,336 52,401 52,465 52,496 52,359 53,183 620,832 Total Cash Available (before cash out) 10,000 56,000 -20,850 -33,547 -44,170 -52,224 -57,759 -58,973 -60,121 -61,206 -62,261 -63,451 -63,818 630,832 CASH PAID OUT Purchases (merchandise) 20,000 20,000 20,000 20,000 20,000 20,000
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 08/23/2011 for the course ENT 4113 taught by Professor Borda during the Summer '10 term at FIU.

Ask a homework question - tutors are online