| 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 |