| 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 | |||||||||||||
| Private Donations | 0% | $3,644 | $3,512 | $3,446 | $2,918 | $3,578 | $3,182 | $3,314 | $3,314 | $2,984 | $3,380 | $3,248 | $3,446 |
| Federal/State Contracts | 0% | $7,426 | $7,426 | $7,426 | $7,426 | $7,426 | $7,426 | $7,426 | $7,426 | $7,426 | $7,426 | $7,426 | $7,426 |
| Private Foundations | 0% | $3,446 | $3,578 | $3,578 | $3,578 | $3,380 | $3,512 | $3,512 | $3,512 | $3,446 | $3,644 | $3,578 | $3,552 |
| School Districts | 0% | $4,370 | $4,370 | $4,370 | $4,304 | $4,304 | $4,304 | $4,436 | $4,304 | $4,304 | $4,370 | $4,304 | $4,416 |
| Business Sponsors | 0% | $2,184 | $2,184 | $2,208 | $2,208 | $2,208 | $2,208 | $2,208 | $2,208 | $2,208 | $2,208 | $2,232 | $2,208 |
| Fundraising Campaign | 0% | $1,446 | $1,456 | $1,439 | $1,439 | $1,439 | $1,439 | $1,423 | $1,456 | $1,456 | $1,456 | $1,472 | $1,456 |
| Total Funding | $22,516 | $22,526 | $22,467 | $21,873 | $22,335 | $22,071 | $22,319 | $22,220 | $21,824 | $22,484 | $22,260 | $22,504 | |
| 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 | |
| Costs | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Subtotal Cost of Funding | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| 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 | ||
| Executive Director | 0% | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 |
| Fundraising/Grant Coordinator | 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 |
| Mentor Recruitment Coordinator | 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 |
| Youth Referral Coordinator | 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 |
| Office Manager | 0% | $1,700 | $1,700 | $1,700 | $1,700 | $1,700 | $1,700 | $1,700 | $1,700 | $1,700 | $1,700 | $1,700 | $1,700 |
| Total People | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | |
| Total Payroll | $10,200 | $10,200 | $10,200 | $10,200 | $10,200 | $10,200 | $10,200 | $10,200 | $10,200 | $10,200 | $10,200 | $10,200 | |
| 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 | $22,516 | $22,526 | $22,467 | $21,873 | $22,335 | $22,071 | $22,319 | $22,220 | $21,824 | $22,484 | $22,260 | $22,504 | |
| Direct Cost | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Other Costs of Funding | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Direct Cost | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Gross Surplus | $22,516 | $22,526 | $22,467 | $21,873 | $22,335 | $22,071 | $22,319 | $22,220 | $21,824 | $22,484 | $22,260 | $22,504 | |
| Gross Surplus % | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | |
| Expenses | |||||||||||||
| Payroll | $10,200 | $10,200 | $10,200 | $10,200 | $10,200 | $10,200 | $10,200 | $10,200 | $10,200 | $10,200 | $10,200 | $10,200 | |
| Sales and Marketing and Other Expenses | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | |
| Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Rent | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | |
| Utilities | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | |
| Insurance | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Activities | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | |
| Payroll Taxes | 15% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Training | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | |
| Total Operating Expenses | $19,600 | $19,600 | $19,600 | $19,600 | $19,600 | $19,600 | $19,600 | $19,600 | $19,600 | $19,600 | $19,600 | $19,600 | |
| Surplus Before Interest and Taxes | $2,916 | $2,926 | $2,867 | $2,273 | $2,735 | $2,471 | $2,719 | $2,620 | $2,224 | $2,884 | $2,660 | $2,904 | |
| EBITDA | $2,916 | $2,926 | $2,867 | $2,273 | $2,735 | $2,471 | $2,719 | $2,620 | $2,224 | $2,884 | $2,660 | $2,904 | |
| 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 | $2,916 | $2,926 | $2,867 | $2,273 | $2,735 | $2,471 | $2,719 | $2,620 | $2,224 | $2,884 | $2,660 | $2,904 | |
| Net Surplus/Funding | 12.95% | 12.99% | 12.76% | 10.39% | 12.25% | 11.20% | 12.18% | 11.79% | 10.19% | 12.82% | 11.95% | 12.90% | |
| 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 | $22,516 | $22,526 | $22,467 | $21,873 | $22,335 | $22,071 | $22,319 | $22,220 | $21,824 | $22,484 | $22,260 | $22,504 | |
| Subtotal Cash from Operations | $22,516 | $22,526 | $22,467 | $21,873 | $22,335 | $22,071 | $22,319 | $22,220 | $21,824 | $22,484 | $22,260 | $22,504 | |
| 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 | $22,516 | $22,526 | $22,467 | $21,873 | $22,335 | $22,071 | $22,319 | $22,220 | $21,824 | $22,484 | $22,260 | $22,504 | |
| 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 | $10,200 | $10,200 | $10,200 | $10,200 | $10,200 | $10,200 | $10,200 | $10,200 | $10,200 | $10,200 | $10,200 | $10,200 | |
| Bill Payments | $313 | $9,400 | $9,400 | $9,400 | $9,400 | $9,400 | $9,400 | $9,400 | $9,400 | $9,400 | $9,400 | $9,400 | |
| Subtotal Spent on Operations | $10,513 | $19,600 | $19,600 | $19,600 | $19,600 | $19,600 | $19,600 | $19,600 | $19,600 | $19,600 | $19,600 | $19,600 | |
| 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 | $10,513 | $19,600 | $19,600 | $19,600 | $19,600 | $19,600 | $19,600 | $19,600 | $19,600 | $19,600 | $19,600 | $19,600 | |
| Net Cash Flow | $12,003 | $2,926 | $2,867 | $2,273 | $2,735 | $2,471 | $2,719 | $2,620 | $2,224 | $2,884 | $2,660 | $2,904 | |
| Cash Balance | $83,503 | $86,428 | $89,295 | $91,568 | $94,303 | $96,774 | $99,493 | $102,112 | $104,336 | $107,219 | $109,879 | $112,783 | |
| 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 | $71,500 | $83,503 | $86,428 | $89,295 | $91,568 | $94,303 | $96,774 | $99,493 | $102,112 | $104,336 | $107,219 | $109,879 | $112,783 |
| Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Current Assets | $71,500 | $83,503 | $86,428 | $89,295 | $91,568 | $94,303 | $96,774 | $99,493 | $102,112 | $104,336 | $107,219 | $109,879 | $112,783 |
| Long-term Assets | |||||||||||||
| Long-term Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Accumulated Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Long-term Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Assets | $71,500 | $83,503 | $86,428 | $89,295 | $91,568 | $94,303 | $96,774 | $99,493 | $102,112 | $104,336 | $107,219 | $109,879 | $112,783 |
| 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 | $9,087 | $9,087 | $9,087 | $9,087 | $9,087 | $9,087 | $9,087 | $9,087 | $9,087 | $9,087 | $9,087 | $9,087 |
| 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 | $9,087 | $9,087 | $9,087 | $9,087 | $9,087 | $9,087 | $9,087 | $9,087 | $9,087 | $9,087 | $9,087 | $9,087 |
| Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Liabilities | $0 | $9,087 | $9,087 | $9,087 | $9,087 | $9,087 | $9,087 | $9,087 | $9,087 | $9,087 | $9,087 | $9,087 | $9,087 |
| Paid-in Capital | $80,000 | $80,000 | $80,000 | $80,000 | $80,000 | $80,000 | $80,000 | $80,000 | $80,000 | $80,000 | $80,000 | $80,000 | $80,000 |
| Accumulated Surplus/Deficit | ($8,500) | ($8,500) | ($8,500) | ($8,500) | ($8,500) | ($8,500) | ($8,500) | ($8,500) | ($8,500) | ($8,500) | ($8,500) | ($8,500) | ($8,500) |
| Surplus/Deficit | $0 | $2,916 | $5,842 | $8,709 | $10,982 | $13,717 | $16,188 | $18,906 | $21,526 | $23,749 | $26,633 | $29,293 | $32,196 |
| Total Capital | $71,500 | $74,416 | $77,342 | $80,209 | $82,482 | $85,217 | $87,688 | $90,406 | $93,026 | $95,249 | $98,133 | $100,793 | $103,696 |
| Total Liabilities and Capital | $71,500 | $83,503 | $86,428 | $89,295 | $91,568 | $94,303 | $96,774 | $99,493 | $102,112 | $104,336 | $107,219 | $109,879 | $112,783 |
| Net Worth | $71,500 | $74,416 | $77,342 | $80,209 | $82,482 | $85,217 | $87,688 | $90,406 | $93,026 | $95,249 | $98,133 | $100,793 | $103,696 |