| Funding Forecast | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Funding | |||||||||||||
| 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 | |
| Direct Cost of Funding | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| 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 | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| 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 | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| 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 | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| 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 | |
| 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% | |
| Expenses | |||||||||||||
| 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 | |
| Total Operating Expenses | £34,220 | £34,220 | £34,220 | £24,220 | £24,220 | £26,220 | £28,220 | £29,220 | £30,220 | £32,220 | £34,220 | £34,220 | |
| 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 | £22,734 | £32,086 | £21,606 | (£12,587) | (£11,228) | (£12,200) | (£13,844) | (£14,106) | (£13,728) | (£10,620) | (£11,896) | £18,773 | |
| 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 | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Cash Received | |||||||||||||
| 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 | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| 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 | |
| Net Cash Flow | £50,930 | £25,065 | £20,596 | (£21,889) | (£10,052) | (£9,361) | (£11,449) | (£13,193) | (£13,019) | (£7,747) | (£10,842) | £20,188 | |
| 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 | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Assets | Starting Balances | ||||||||||||
| 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 |
| Liabilities and Capital | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| 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 | £64,113 | £52,217 | £70,990 |
| Funding Forecast | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Funding | |||||||||||||
| 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 | |
| Direct Cost of Funding | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| 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 | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| 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 | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| 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 | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| 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 | |
| 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% | |
| Expenses | |||||||||||||
| 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 | |
| Total Operating Expenses | £34,220 | £34,220 | £34,220 | £24,220 | £24,220 | £26,220 | £28,220 | £29,220 | £30,220 | £32,220 | £34,220 | £34,220 | |
| 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 | £22,734 | £32,086 | £21,606 | (£12,587) | (£11,228) | (£12,200) | (£13,844) | (£14,106) | (£13,728) | (£10,620) | (£11,896) | £18,773 | |
| 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 | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Cash Received | |||||||||||||
| 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 | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| 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 | |
| Net Cash Flow | £50,930 | £25,065 | £20,596 | (£21,889) | (£10,052) | (£9,361) | (£11,449) | (£13,193) | (£13,019) | (£7,747) | (£10,842) | £20,188 | |
| 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 | |||||||||||||
| Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
| Assets | Starting Balances | ||||||||||||
| 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 |
| Liabilities and Capital | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| 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 | £64,113 | £52,217 | £70,990 |