Docstoc

Cash flow forecast - Excel

Document Sample
Cash flow forecast - Excel Powered By Docstoc
					Page 1 of 1

0 03 4 T How to budget

Copyright 2001-04 Business Boffins Ltd

Cash flow forecast template Jan Cash flow into the business Investment capital Sales - product 1 (add rows as req'd) Sales - service 1 (add rows as req'd) TOTAL CASH FLOW IN Cash flow out of the business Capital expenditure (CapEx) Premises Vehicles Office equipment Manufacturing Equipment CapEx TOTAL Operating expenditure (OpEx) Salaries (gross amount totals) National insurance (13%) Pensions (5%) Life cover scheme Rent Rates Combined business insurance Utilities Phone Legal & intellectual property Accounting, payroll & audit charges Business travel Bank charges Health and safety Stationery Raw materials OpEx TOTAL TOTAL CASH FLOW OUT MONTHLY NET CASH FLOW MONTHLY BANK BALANCE 9,500 1,235 475 250 1,800 250 350 180 120 3,000 1,200 100 25 500 100 5,870 24,955 67,955 82,045 82,045 50 100 25 500 100 4,380 21,110 40,185 -36,185 45,860 50 100 25 250 100 1,250 17,730 18,980 -10,380 35,480 50 100 25 100 100 1,250 19,990 22,015 -11,715 23,765 11,000 1,430 550 275 1,800 250 350 180 120 11,000 1,430 550 275 1,800 250 350 180 120 13,000 1,690 650 325 1,800 250 350 180 120 13,000 1,690 650 325 1,800 250 350 180 120 2,000 50 100 25 100 100 1,250 21,990 22,315 -10,665 13,100 50 500 25 100 100 1,250 20,390 22,245 -9,495 3,605 50 500 25 100 100 1,250 20,390 20,390 -7,390 -3,785 50 100 25 100 100 1,250 21,785 21,785 -5,685 -9,470 50 100 25 100 100 1,250 21,785 22,135 -1,385 -10,855 13,000 1,690 650 325 1,800 250 350 180 120 13,000 1,690 650 325 1,800 250 350 180 120 14,500 1,885 725 350 1,800 250 350 180 120 14,500 1,885 725 350 1,800 250 350 180 120 14,500 1,885 725 350 1,800 250 350 180 120 3,000 50 100 25 100 100 1,250 24,785 24,785 3,215 -7,640 2,550 100 25 100 100 1,250 24,285 24,285 6,415 -1,225 50 100 25 100 100 1,250 21,785 22,405 5,665 4,440 14,500 1,885 725 350 1,800 250 350 180 120 14,500 1,885 725 350 1,800 250 350 180 120 156,000 20,280 7,800 3,850 21,600 3,000 4,200 2,160 1,440 8,000 4,250 2,000 300 2,150 1,200 22,750 260,980 329,480 5,500 37,500 43,000 12,000 3,500 3,575 19,075 500 750 1,250 750 1,275 2,025 325 325 1,855 1,855 0 0 350 0 0 620 350 620 0 12,000 11,220 45,280 68,500 150,000 4,000 8,600 150,000 4,000 8,600 9,750 550 10,300 11,000 650 11,650 12,000 750 12,750 12,000 1,000 13,000 15,000 1,100 16,100 19,500 1,250 20,750 26,400 1,600 28,000 28,750 1,950 30,700 26,470 1,600 28,070 150,000 173,470 10,450 333,920 Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec TOTALS


				
DOCUMENT INFO
Shared By:
Tags: Cash, flow, forecast
Stats:
views:2124
posted:1/3/2008
language:English
pages:1
destined destined
About