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