Construct a cash flow forecast for the following cash budget and pro forma income sheet and balance statement.

set Format Pinter Formatting as Table Styles Font Number Cells E19 f. Forcast 2012 Feb Actual 2011 Oct Dec 3 Total Sales 4 Credit Sales 5 Cash Sales 6 Collection 80% of sales 20% of sales 1 month 360,000420,000 1,200,000 600,000 240,000 240,000 960,000 480,000 192,000 192,000 48,000 336,000 960,000 480,000 192,000 336,000 84,000 288,000 288,000 72,000 240,000 120,000 48,000 8 Total Receipt (A) 9 Purchase 10 11 Payment for Purchase 12 Wages Payable Monthly 13 Principal Payment on dept 14 Interest Payment 15 Dividend 16 Tax 17 Total Payment ( B) 18 Net cash Balancel A B) 1,080,000 528,000 240,000 10,000 540,000 1.200,000 300,000 120,000 120,000 2 month 540,000 1,200,000 300,000 180,000 180,000 180,000 210,000 90,000 300,000 180,000 720,000 1,560,000 1,080,000 Cash Balance In beginning 20 Total Cash 21 Borrowing 22 Total Cash bal end of Month 360,000 (1,032000)(840,000) 00,000 660,000 150,000 000- (372.000) (630,000) 522,000 840,000 660,000 150,000 150,000 141 : Sheet2 | Sheet3 Ready