Helping Hand

Start your own business plan »

Nonprofit Food Bank Business Plan

Appendix

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