CASHFLOW FORECAST IN RESPECT OF THE PERIOD March 2009

Document Sample
CASHFLOW FORECAST IN RESPECT OF THE PERIOD March 2009 Powered By Docstoc
					CASHFLOW FORECAST IN RESPECT OF THE PERIOD: March 2009 - March 2010
Mar 5 1000 Apr 4 May 4 Jun 5 10000 Jul 4 15500 Aug 5 500 Sep 4 5500 Oct 4 500 Nov 5 500 Dec 4 500 Jan 4 500 Feb 4 500 TOTAL

Weeks Capital Introduced Grants (Based on EEDA 40%) Loans SALES Beef Cattle Sold Online Sales Wholesale Events Visitor Centres TOTAL SALES TOTAL RECEIPTS

35000 0 0 73 0 110106 0 0 110106 145106 TOTAL 0 0 1400 350 3750 5000 330 700 200 400 300 400 300 800 1500 500 1850 400 1000 3000 567 9600 1460

0

0

0

0

3 4356

10 15030

10 15120

10 14820

10 14970

10 15270

10 15270

10 15270

0 1000 Mar Apr

0 0 May

0 0

0 10000 Jun

4356 19856 Jul

15030 15530 Aug

15120 20620 Sep

14820 15320 Oct

14970 15470 Nov

15270 15770 Dec

15270 15770 Jan

15270 15770 Feb

MATERIALS - CASH MATERIALS - CREDIT PYMTS Creation of Brand Image * Register Ltd Co and VAT Backdated Consultancy Website Styling & Building Printing of Business Plans Design of Marketing Brochure Printing of Brochure Design of Postcard Customer Flyer Printing of 5000 Postcards Design of Pull-up Banners Supply of Pull-up Banners Design of other Misc Point of Sale Supply of other Misc Point of Sale Production of DVD Promo Film Design of Packaging and Labelling Design and Production of Uniform Accountancy Legal Costs Insurance Customer Service G Warrener Labour

1400 350 500 330 700 200 400 300 400 300 800 1500 500 1850 400 1000 3000 567 0 60 1600 200 1280 200 1280 200 1600 200 1280 200 1280 200 1280 200 500 500 5000 500 500 500 500 250

Beef Producer Payments Slaughter and 21 Day Mature Distribution and Delivery Butchery, Packaging & Labelling Miscellaneous Expenses Loan Repayment(s) - Capital Loan Repayment(s) - Interest Capital Expenses Pre-Payments / Deposits DRAWINGS

0 0 0 0

2385 195 153 750 100

8460 650 510 2500 100

8550 650 510 2500 100

8250 650 510 2500 100

8400 650 510 2500 100

8700 650 510 2500 100

8700 650 510 2500 100

8700 650 510 2500 100

62145 4745 3723 18250 800 0 0 0 0 0

TOTAL PAYMENTS Cashflow Opening Balance Closing Balance

350 650 0 650

0 0 650 650

330 (330) 650 320

0 10000 320 10320

15960 3896 10320 14216

14520 1010 14216 15226

19290 1330 15226 16556

13990 1330 16556 17886

14460 1010 17886 18896

14940 830 18896 19726

14440 1330 19726 21056

15190 580 21056 21636

123470

CASHFLOW FORECAST IN RESPECT OF THE PERIOD: March 2010 - March 2011
Mar 5 10000 18120 18120 18120 18120 Apr 4 May 4 Jun 5 Jul 4 Aug 5 Sep 4 Oct 4 Nov 5 Dec 4 Jan 4 Feb 4 TOTAL

Weeks Capital Introduced Grants (Based on EEDA 40%) Loans SALES Beef Cattle Sold Online Sales Wholesale Events Visitor Centres TOTAL SALES TOTAL RECEIPTS

10000 72481 0 250 0 373353 0 0 373353 455834 TOTAL 0 0 2000 700 200 400 300 400 300 800 1500 1000 1850 7000 500 927 102 60 480 1758 1000 567 3420

20 29460

20 29460

21 30933

21 30933

21 30492

21 31563

21 31752

21 31122

21 31437

21 32067

21 32067

21 32067

29460 39460 Mar

29460 29460 Apr

30933 49053 May

30933 30933 Jun

30492 30492 Jul

31563 49683 Aug

31752 31752 Sep

31122 31122 Oct

31437 49557 Nov

32067 32067 Dec

32067 32067 Jan

32067 50187 Feb

MATERIALS - CASH MATERIALS - CREDIT PYMTS Website Updates Design of Marketing Brochure Printing of Brochure Design of Postcard Customer Flyer Printing of 5000 Postcards Design of Pull-up Banners Supply of Pull-up Banners Design of other Misc Point of Sale Supply of other Misc Point of Sale Production of DVD Promo Film Design of Packaging and Labelling Quality Assesment Program More uniforms Rent Business Rates Heat, Light, Power Telephone J Reeves/RSPB Overheads Accountancy Insurance Motor Expenses / Travel

77.24 8.52 5.00 40.00 169.00

77.24 8.52 5.00 40.00 135.20

77.24 8.52 5.00 40.00 135.20

77.24 8.52 5.00 40.00 169.00

2000 700 200 400 300 400 300 800 1500 1000 1850 7000 500 77.24 8.52 5.00 40.00 135.20 567 180

77.24 8.52 5.00 40.00 169.00

77.24 8.52 5.00 40.00 135.20

77.24 8.52 5.00 40.00 135.20

77.24 8.52 5.00 40.00 169.00

77.24 8.52 5.00 40.00 135.20

77.24 8.52 5.00 40.00 135.20

77.24 8.52 5.00 40.00 135.20 1000 360

180

180

180

180

360

360

360

360

360

360

J Reeves Labour R Sanderson Labour Customer Service G Warrener Labour Beef Producer Payments Slaughter and 21 Day Mature Distribution and Delivery Butchery, Packaging & Labelling Miscellaneous Expenses Loan Repayment(s) - Capital Loan Repayment(s) - Interest Capital Expenses Pre-Payments / Deposits DRAWINGS

1500 2500 1600 400 16320 1300 1020 5000 100

1200 2000 1280 400 16320 1300 1020 5000 100

1200 2000 1280 420 17136 1365 1071 5250 100

1500 2500 1600 420 17136 1365 1071 5250 100

1200 2000 1280 420 16695 1365 1071 5250 100

1500 2500 1600 420 17766 1365 1071 5250 100

1200 2000 1280 420 17955 1365 1071 5250 100

1200 2000 1280 420 17325 1365 1071 5250 100

1500 2500 1600 420 17640 1365 1071 5250 100

1200 2000 1280 420 18270 1365 1071 5250 100

1200 2000 1280 420 18270 1365 1071 5250 100

1200 2000 1280 420 18270 1365 1071 5250 100

15600 26000 16640 5000 209103 16250 12750 62500 1200 0 0 0 0 0

TOTAL PAYMENTS Cashflow Opening Balance Closing Balance

30220 9240 0 9240

29066 394 9240 9634

30268 18785 9634 28420

31422 (489) 28420 27931

47344 (16852) 27931 11079

32232 17452 11079 28531

31267 485 28531 29016

30637 485 29016 29501

32106 17452 29501 46953

31582 485 46953 47438

31582 485 47438 47923

32582 17605 47923 65528

390306

CASHFLOW FORECAST IN RESPECT OF THE PERIOD: March 2011 - March 2012
Mar 5 Apr 4 May 4 Jun 5 Jul 4 Aug 5 Sep 4 Oct 4 Nov 5 Dec 4 Jan 4 Feb 4 TOTAL

Weeks Capital Introduced Grants (Based on EEDA 30%) Loans SALES Beef Cattle Sold Online Sales Wholesale Events Visitor Centres TOTAL SALES TOTAL RECEIPTS

34377

34377

34377

34377

0 137510 0 85 129795 85 129795 1000 0 1486114 0 0 1486114 1623624 TOTAL 0 0 1000 1000 800 200 1400 1000 1500 7000 300 1000 927 102 60 600 1758 540 4320 41600 5460 20000 836385

83 122259

83 114988

83 122259

83 122259

83 120516

83 124749

83 125496

83 123006

83 124251

83 126741

122259 156636 Mar

114988 114988 Apr

122259 122259 May

122259 156636 Jun

120516 120516 Jul

124749 124749 Aug

125496 159873 Sep

123006 123006 Oct

124251 124251 Nov

126741 161118 Dec

129795 129795 Jan

129795 129795 Feb

MATERIALS - CASH MATERIALS - CREDIT PYMTS * Update Business Plan & Cash Flow * Farm Cost Analysis Website Hosting & Promotion Printing of Brochures Printing of 30000 Postcards Design of other Misc Point of Sale Supply of other Misc Point of Sale Quality Assesment Program Production of Uniforms Accountancy Rent Business Rates Heat, Light, Power Telephone J Reeves/RSPB Overheads Insurance Motor Expenses / Travel R Sanderson Labour Customer Service G Warrener Labour Beef Producer Payments

1000 1000 800 200 1400 1000 1500 7000 300 1000 77.24 8.52 5.00 50.00 169.00 360 3467 525 1660 67728 77.24 8.52 5.00 50.00 135.20 360 3467 420 1660 67728 77.24 8.52 5.00 50.00 135.20 360 3467 420 1660 67728 77.24 8.52 5.00 50.00 169.00 360 3467 525 1660 67728 77.24 8.52 5.00 50.00 135.20 540 360 3467 420 1660 65985 77.24 8.52 5.00 50.00 169.00 360 3467 525 1660 70218 77.24 8.52 5.00 50.00 135.20 360 3467 420 1660 70965 77.24 8.52 5.00 50.00 135.20 360 3467 420 1660 68475 77.24 8.52 5.00 50.00 169.00 360 3467 525 1660 69720 77.24 8.52 5.00 50.00 135.20 360 3467 420 1660 72210 77.24 8.52 5.00 50.00 135.20 360 3467 420 1700 73950 77.24 8.52 5.00 50.00 135.20 360 3463 420 1700 73950

Slaughter and 21 Day Mature Distribution and Delivery Butchery, Packaging & Labelling Miscellaneous Expenses Loan Repayment(s) - Capital Loan Repayment(s) - Interest Capital Expenses Pre-Payments / Deposits DRAWINGS

5395 4233 20750 150

5395 4233 20750 150

5395 4233 20750 150

5395 4233 20750 150

5395 4233 20750 150

5395 4233 20750 150

5395 4233 20750 150

5395 4233 20750 150

5395 4233 20750 150

5395 4233 20750 150

5525 4335 21250 150

5525 4335 21250 150

65000 51000 250000 1800 0 0 0 0 0

TOTAL PAYMENTS Cashflow Opening Balance Closing Balance

106577 50059 0 50059

104439 10549 50059 60608

104439 17820 60608 78428

105578 51059 78428 129487

108436 12080 129487 141567

107068 17681 141567 159248

107676 52198 159248 211446

105186 17820 211446 229266

113570 10681 229266 239947

108921 52198 239947 292145

111433 18362 292145 310507

111429 18366 310507 328873

1294751


				
DOCUMENT INFO
Shared By:
Stats:
views:5
posted:6/30/2009
language:English
pages:6