|
|

| Funding Forecast |
| FC |
0% |
£18,700 |
£16,180 |
£12,820 |
£9,600 |
£11,520 |
£11,760 |
£13,200 |
£13,920 |
£14,640 |
£15,600 |
£16,180 |
£17,650 |
| FtB |
0% |
£30,000 |
£40,000 |
£40,000 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£20,000 |
| FRE |
0% |
£2,434 |
£2,746 |
£2,824 |
£3,136 |
£2,590 |
£2,980 |
£2,434 |
£2,434 |
£3,292 |
£3,604 |
£3,058 |
£3,058 |
| Gleaning |
0% |
£10,000 |
£10,000 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£10,000 |
| CD |
0% |
£2,000 |
£3,000 |
£4,000 |
£1,000 |
£1,000 |
£1,500 |
£1,500 |
£2,000 |
£2,000 |
£2,000 |
£2,000 |
£2,000 |
| C/CPF |
0% |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| YF |
0% |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£5,000 |
£6,000 |
£7,000 |
| Total Funding |
|
£63,134 |
£71,926 |
£59,644 |
£13,736 |
£15,110 |
£16,240 |
£17,134 |
£18,354 |
£19,932 |
£26,204 |
£27,238 |
£59,708 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| FC |
|
£2,088 |
£1,584 |
£1,320 |
£1,224 |
£1,272 |
£1,329 |
£1,395 |
£1,632 |
£1,704 |
£1,872 |
£1,944 |
£1,992 |
| FtB |
|
£1,703 |
£1,680 |
£1,584 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£1,680 |
| FRE |
|
£298 |
£269 |
£283 |
£293 |
£264 |
£274 |
£278 |
£264 |
£288 |
£254 |
£278 |
£288 |
| Gleaning |
|
£1,000 |
£1,000 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£800 |
£1,000 |
£1,000 |
| CD |
|
£379 |
£384 |
£360 |
£360 |
£374 |
£350 |
£418 |
£398 |
£394 |
£394 |
£418 |
£398 |
| YF |
|
£712 |
£703 |
£271 |
£226 |
£208 |
£268 |
£667 |
£946 |
£1,055 |
£1,284 |
£1,274 |
£1,357 |
| Subtotal Cost of Funding |
|
£6,180 |
£5,620 |
£3,818 |
£2,103 |
£2,118 |
£2,220 |
£2,758 |
£3,240 |
£3,440 |
£4,604 |
£4,914 |
£6,715 |
| Personnel Plan |
| Volunteer
Coordinator |
0% |
£1,800 |
£1,800 |
£1,800 |
£1,800 |
£1,800 |
£1,800 |
£1,800 |
£1,800 |
£1,800 |
£1,800 |
£1,800 |
£1,800 |
| Food Solicitation
Coordinator |
0% |
£1,800 |
£1,800 |
£1,800 |
£1,800 |
£1,800 |
£1,800 |
£1,800 |
£1,800 |
£1,800 |
£1,800 |
£1,800 |
£1,800 |
| Distribution
Coordinator |
0% |
£1,800 |
£1,800 |
£1,800 |
£1,800 |
£1,800 |
£1,800 |
£1,800 |
£1,800 |
£1,800 |
£1,800 |
£1,800 |
£1,800 |
| Warehouse
Coordinator |
0% |
£1,800 |
£1,800 |
£1,800 |
£1,800 |
£1,800 |
£1,800 |
£1,800 |
£1,800 |
£1,800 |
£1,800 |
£1,800 |
£1,800 |
| Youth Farm
Coordinator |
0% |
£1,800 |
£1,800 |
£1,800 |
£1,800 |
£1,800 |
£1,800 |
£1,800 |
£1,800 |
£1,800 |
£1,800 |
£1,800 |
£1,800 |
| Executive
Director |
0% |
£2,000 |
£2,000 |
£2,000 |
£2,000 |
£2,000 |
£2,000 |
£2,000 |
£2,000 |
£2,000 |
£2,000 |
£2,000 |
£2,000 |
| Total People |
|
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
6 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Total Payroll |
|
£11,000 |
£11,000 |
£11,000 |
£11,000 |
£11,000 |
£11,000 |
£11,000 |
£11,000 |
£11,000 |
£11,000 |
£11,000 |
£11,000 |
| General Assumptions |
| Plan Month |
|
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
11 |
12 |
| Current Interest Rate |
|
10.00% |
10.00% |
10.00% |
10.00% |
10.00% |
10.00% |
10.00% |
10.00% |
10.00% |
10.00% |
10.00% |
10.00% |
| Long-term Interest Rate |
|
10.00% |
10.00% |
10.00% |
10.00% |
10.00% |
10.00% |
10.00% |
10.00% |
10.00% |
10.00% |
10.00% |
10.00% |
| Tax Rate |
|
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
0.00% |
| Other |
|
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |

| Surplus and Deficit |
| Direct Cost |
|
£6,180 |
£5,620 |
£3,818 |
£2,103 |
£2,118 |
£2,220 |
£2,758 |
£3,240 |
£3,440 |
£4,604 |
£4,914 |
£6,715 |
| Other Costs of Funding |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Total Direct Cost |
|
£6,180 |
£5,620 |
£3,818 |
£2,103 |
£2,118 |
£2,220 |
£2,758 |
£3,240 |
£3,440 |
£4,604 |
£4,914 |
£6,715 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Gross Surplus |
|
£56,954 |
£66,306 |
£55,826 |
£11,633 |
£12,992 |
£14,020 |
£14,376 |
£15,114 |
£16,492 |
£21,600 |
£22,324 |
£52,993 |
| Gross Surplus % |
|
90.21% |
92.19% |
93.60% |
84.69% |
85.98% |
86.33% |
83.90% |
82.34% |
82.74% |
82.43% |
81.96% |
88.75% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Payroll |
|
£11,000 |
£11,000 |
£11,000 |
£11,000 |
£11,000 |
£11,000 |
£11,000 |
£11,000 |
£11,000 |
£11,000 |
£11,000 |
£11,000 |
| Sales and Marketing Costs |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Depreciation |
|
£70 |
£70 |
£70 |
£70 |
£70 |
£70 |
£70 |
£70 |
£70 |
£70 |
£70 |
£70 |
| Rent |
|
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
£1,000 |
| Utilities |
|
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
£200 |
| Insurance |
|
£300 |
£300 |
£300 |
£300 |
£300 |
£300 |
£300 |
£300 |
£300 |
£300 |
£300 |
£300 |
| Payroll Taxes |
15% |
£1,650 |
£1,650 |
£1,650 |
£1,650 |
£1,650 |
£1,650 |
£1,650 |
£1,650 |
£1,650 |
£1,650 |
£1,650 |
£1,650 |
| Food
Distribution |
|
£20,000 |
£20,000 |
£20,000 |
£10,000 |
£10,000 |
£12,000 |
£14,000 |
£15,000 |
£16,000 |
£18,000 |
£20,000 |
£20,000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Surplus Before Interest and Taxes |
|
£22,734 |
£32,086 |
£21,606 |
(£12,587) |
(£11,228) |
(£12,200) |
(£13,844) |
(£14,106) |
(£13,728) |
(£10,620) |
(£11,896) |
£18,773 |
| EBITDA |
|
£22,804 |
£32,156 |
£21,676 |
(£12,517) |
(£11,158) |
(£12,130) |
(£13,774) |
(£14,036) |
(£13,658) |
(£10,550) |
(£11,826) |
£18,843 |
| Interest Expense |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Taxes Incurred |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Net Surplus/Funding |
|
36.01% |
44.61% |
36.22% |
-91.63% |
-74.31% |
-75.12% |
-80.80% |
-76.86% |
-68.87% |
-40.53% |
-43.67% |
31.44% |

| Pro Forma Cash Flow |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash from Operations |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash Funding |
|
£63,134 |
£71,926 |
£59,644 |
£13,736 |
£15,110 |
£16,240 |
£17,134 |
£18,354 |
£19,932 |
£26,204 |
£27,238 |
£59,708 |
| Subtotal Cash from Operations |
|
£63,134 |
£71,926 |
£59,644 |
£13,736 |
£15,110 |
£16,240 |
£17,134 |
£18,354 |
£19,932 |
£26,204 |
£27,238 |
£59,708 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Additional Cash Received |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Sales Tax, VAT, HST/GST Received |
0.00% |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| New Current Borrowing |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| New Other Liabilities (interest-free) |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| New Long-term Liabilities |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Sales of Other Current Assets |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Sales of Long-term Assets |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| New Investment Received |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Subtotal Cash Received |
|
£63,134 |
£71,926 |
£59,644 |
£13,736 |
£15,110 |
£16,240 |
£17,134 |
£18,354 |
£19,932 |
£26,204 |
£27,238 |
£59,708 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Expenditures from Operations |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash Spending |
|
£11,000 |
£11,000 |
£11,000 |
£11,000 |
£11,000 |
£11,000 |
£11,000 |
£11,000 |
£11,000 |
£11,000 |
£11,000 |
£11,000 |
| Bill Payments |
|
£1,204 |
£35,861 |
£28,048 |
£24,625 |
£14,162 |
£14,601 |
£17,583 |
£20,547 |
£21,951 |
£22,951 |
£27,080 |
£28,520 |
| Subtotal Spent on Operations |
|
£12,204 |
£46,861 |
£39,048 |
£35,625 |
£25,162 |
£25,601 |
£28,583 |
£31,547 |
£32,951 |
£33,951 |
£38,080 |
£39,520 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Additional Cash Spent |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Sales Tax, VAT, HST/GST Paid Out |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Principal Repayment of Current Borrowing |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Other Liabilities Principal Repayment |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Long-term Liabilities Principal Repayment |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Purchase Other Current Assets |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Purchase Long-term Assets |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Dividends |
|
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Subtotal Cash Spent |
|
£12,204 |
£46,861 |
£39,048 |
£35,625 |
£25,162 |
£25,601 |
£28,583 |
£31,547 |
£32,951 |
£33,951 |
£38,080 |
£39,520 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash Balance |
|
£119,930 |
£144,994 |
£165,590 |
£143,701 |
£133,649 |
£124,288 |
£112,840 |
£99,647 |
£86,628 |
£78,881 |
£68,039 |
£88,228 |

| Pro Forma Balance Sheet |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Current Assets |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cash |
£69,000 |
£119,930 |
£144,994 |
£165,590 |
£143,701 |
£133,649 |
£124,288 |
£112,840 |
£99,647 |
£86,628 |
£78,881 |
£68,039 |
£88,228 |
| Inventory |
£0 |
£6,798 |
£6,182 |
£4,200 |
£3,097 |
£2,330 |
£2,442 |
£3,034 |
£3,564 |
£3,784 |
£5,064 |
£5,405 |
£7,386 |
| Other Current Assets |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Total Current Assets |
£69,000 |
£126,727 |
£151,176 |
£169,790 |
£146,798 |
£135,979 |
£126,730 |
£115,873 |
£103,211 |
£90,412 |
£83,946 |
£73,445 |
£95,614 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Long-term Assets |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Long-term Assets |
£7,000 |
£7,000 |
£7,000 |
£7,000 |
£7,000 |
£7,000 |
£7,000 |
£7,000 |
£7,000 |
£7,000 |
£7,000 |
£7,000 |
£7,000 |
| Accumulated Depreciation |
£0 |
£70 |
£140 |
£210 |
£280 |
£350 |
£420 |
£490 |
£560 |
£630 |
£700 |
£770 |
£840 |
| Total Long-term Assets |
£7,000 |
£6,930 |
£6,860 |
£6,790 |
£6,720 |
£6,650 |
£6,580 |
£6,510 |
£6,440 |
£6,370 |
£6,300 |
£6,230 |
£6,160 |
| Total Assets |
£76,000 |
£133,657 |
£158,036 |
£176,580 |
£153,518 |
£142,629 |
£133,310 |
£122,383 |
£109,651 |
£96,782 |
£90,246 |
£79,675 |
£101,774 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Current Liabilities |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Accounts Payable |
£0 |
£34,923 |
£27,216 |
£24,154 |
£13,678 |
£14,018 |
£16,899 |
£19,816 |
£21,190 |
£22,049 |
£26,133 |
£27,458 |
£30,784 |
| Current Borrowing |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Other Current Liabilities |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Subtotal Current Liabilities |
£0 |
£34,923 |
£27,216 |
£24,154 |
£13,678 |
£14,018 |
£16,899 |
£19,816 |
£21,190 |
£22,049 |
£26,133 |
£27,458 |
£30,784 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Long-term Liabilities |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
£0 |
| Total Liabilities |
£0 |
£34,923 |
£27,216 |
£24,154 |
£13,678 |
£14,018 |
£16,899 |
£19,816 |
£21,190 |
£22,049 |
£26,133 |
£27,458 |
£30,784 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Paid-in Capital |
£200,000 |
£200,000 |
£200,000 |
£200,000 |
£200,000 |
£200,000 |
£200,000 |
£200,000 |
£200,000 |
£200,000 |
£200,000 |
£200,000 |
£200,000 |
| Accumulated Surplus/Deficit |
(£124,000) |
(£124,000) |
(£124,000) |
(£124,000) |
(£124,000) |
(£124,000) |
(£124,000) |
(£124,000) |
(£124,000) |
(£124,000) |
(£124,000) |
(£124,000) |
(£124,000) |
| Surplus/Deficit |
£0 |
£22,734 |
£54,821 |
£76,426 |
£63,840 |
£52,611 |
£40,411 |
£26,567 |
£12,461 |
(£1,267) |
(£11,887) |
(£23,783) |
(£5,010) |
| Total Capital |
£76,000 |
£98,734 |
£130,821 |
£152,426 |
£139,840 |
£128,611 |
£116,411 |
£102,567 |
£88,461 |
£74,733 |
£64,113 |
£52,217 |
£70,990 |
| Total Liabilities and Capital |
£76,000 |
£133,657 |
£158,036 |
£176,580 |
£153,518 |
£142,629 |
£133,310 |
£122,383 |
£109,651 |
£96,782 |
£90,246 |
£79,675 |
£101,774 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Net Worth |
£76,000 |
£98,734 |
£130,821 |
£152,426 |
£139,840 |
£128,611 |
£116,411 |
£102,567 |
£88,461 |
£74,733 |
 | |