| Funding Forecast | |||||||||||||
| Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | ||
| Funding | |||||||||||||
| Dues | 0% | $5,000 | $5,000 | $2,500 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Monthly Meetings | 0% | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 |
| Motorcycle Show | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $10,000 | $11,000 | $0 | $0 | $0 |
| SuperRide | 0% | $0 | $0 | $5,800 | $1,800 | $5,600 | $9,400 | $3,200 | $8,000 | $13,000 | $24,000 | $29,000 | $7,500 |
| Awards Banquet | 0% | $0 | $0 | $3,500 | $3,500 | $10,000 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Conference | 0% | $0 | $0 | $0 | $0 | $6,000 | $6,000 | $6,000 | $12,000 | $0 | $0 | $0 | $0 |
| Newsletter | 0% | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 |
| Total Funding | $5,600 | $5,600 | $12,400 | $5,900 | $22,200 | $16,000 | $9,800 | $30,600 | $24,600 | $24,600 | $29,600 | $8,100 | |
| Direct Cost of Funding | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | |
| Dues | $150 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Monthly Meetings | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | |
| Motorcycle Show | $0 | $0 | $0 | $0 | $0 | $0 | $10,000 | $9,000 | $0 | $0 | $0 | $0 | |
| SuperRide | $500 | $500 | $2,300 | $1,800 | $3,000 | $4,000 | $10,000 | $14,000 | $4,000 | $16,000 | $18,000 | $600 | |
| Awards Banquet | $0 | $0 | $1,000 | $0 | $12,500 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Conference | $0 | $0 | $6,000 | $500 | $500 | $0 | $500 | $8,000 | $0 | $0 | $0 | $0 | |
| Newsletter | $75 | $75 | $75 | $75 | $75 | $75 | $75 | $75 | $75 | $75 | $75 | $75 | |
| Subtotal Cost of Funding | $1,125 | $975 | $9,775 | $2,775 | $16,475 | $4,475 | $20,975 | $31,475 | $4,475 | $16,475 | $18,475 | $1,075 | |
| Personnel Plan | |||||||||||||
| Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | ||
| Executive Director | 0% | $3,250 | $3,250 | $3,250 | $3,250 | $3,250 | $3,250 | $3,250 | $3,250 | $3,250 | $3,250 | $3,250 | $3,250 |
| Other | 0% | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 |
| Total People | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | |
| Total Payroll | $3,600 | $3,600 | $3,600 | $3,600 | $3,600 | $3,600 | $3,600 | $3,600 | $3,600 | $3,600 | $3,600 | $3,600 | |
| Surplus and Deficit | |||||||||||||
| Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | ||
| Funding | $5,600 | $5,600 | $12,400 | $5,900 | $22,200 | $16,000 | $9,800 | $30,600 | $24,600 | $24,600 | $29,600 | $8,100 | |
| Direct Cost | $1,125 | $975 | $9,775 | $2,775 | $16,475 | $4,475 | $20,975 | $31,475 | $4,475 | $16,475 | $18,475 | $1,075 | |
| Other Costs of Funding | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Direct Cost | $1,125 | $975 | $9,775 | $2,775 | $16,475 | $4,475 | $20,975 | $31,475 | $4,475 | $16,475 | $18,475 | $1,075 | |
| Gross Surplus | $4,475 | $4,625 | $2,625 | $3,125 | $5,725 | $11,525 | ($11,175) | ($875) | $20,125 | $8,125 | $11,125 | $7,025 | |
| Gross Surplus % | 79.91% | 82.59% | 21.17% | 52.97% | 25.79% | 72.03% | -114.03% | -2.86% | 81.81% | 33.03% | 37.58% | 86.73% | |
| Expenses | |||||||||||||
| Payroll | $3,600 | $3,600 | $3,600 | $3,600 | $3,600 | $3,600 | $3,600 | $3,600 | $3,600 | $3,600 | $3,600 | $3,600 | |
| Marketing/Promotion | $115 | $115 | $115 | $115 | $115 | $115 | $115 | $115 | $115 | $115 | $115 | $115 | |
| Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Rent | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | |
| Telephone Service | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | |
| Payroll Taxes | 15% | $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 | |
| Total Operating Expenses | $4,315 | $4,315 | $4,315 | $4,315 | $4,315 | $4,315 | $4,315 | $4,315 | $4,315 | $4,315 | $4,315 | $4,315 | |
| Surplus Before Interest and Taxes | $160 | $310 | ($1,690) | ($1,190) | $1,410 | $7,210 | ($15,490) | ($5,190) | $15,810 | $3,810 | $6,810 | $2,710 | |
| EBITDA | $160 | $310 | ($1,690) | ($1,190) | $1,410 | $7,210 | ($15,490) | ($5,190) | $15,810 | $3,810 | $6,810 | $2,710 | |
| 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 | $160 | $310 | ($1,690) | ($1,190) | $1,410 | $7,210 | ($15,490) | ($5,190) | $15,810 | $3,810 | $6,810 | $2,710 | |
| Net Surplus/Funding | 2.86% | 5.54% | -13.63% | -20.17% | 6.35% | 45.06% | -158.06% | -16.96% | 64.27% | 15.49% | 23.01% | 33.46% | |
| Pro Forma Cash Flow | |||||||||||||
| Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Funding | $5,600 | $5,600 | $12,400 | $5,900 | $22,200 | $16,000 | $9,800 | $30,600 | $24,600 | $24,600 | $29,600 | $8,100 | |
| Subtotal Cash from Operations | $5,600 | $5,600 | $12,400 | $5,900 | $22,200 | $16,000 | $9,800 | $30,600 | $24,600 | $24,600 | $29,600 | $8,100 | |
| 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 | $5,600 | $5,600 | $12,400 | $5,900 | $22,200 | $16,000 | $9,800 | $30,600 | $24,600 | $24,600 | $29,600 | $8,100 | |
| Expenditures | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | $3,600 | $3,600 | $3,600 | $3,600 | $3,600 | $3,600 | $3,600 | $3,600 | $3,600 | $3,600 | $3,600 | $3,600 | |
| Bill Payments | $61 | $1,835 | $1,983 | $10,257 | $3,947 | $16,790 | $5,740 | $22,040 | $31,290 | $5,590 | $17,257 | $18,610 | |
| Subtotal Spent on Operations | $3,661 | $5,435 | $5,583 | $13,857 | $7,547 | $20,390 | $9,340 | $25,640 | $34,890 | $9,190 | $20,857 | $22,210 | |
| 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 | $3,661 | $5,435 | $5,583 | $13,857 | $7,547 | $20,390 | $9,340 | $25,640 | $34,890 | $9,190 | $20,857 | $22,210 | |
| Net Cash Flow | $1,939 | $165 | $6,817 | ($7,957) | $14,653 | ($4,390) | $460 | $4,960 | ($10,290) | $15,410 | $8,743 | ($14,110) | |
| Cash Balance | $13,939 | $14,104 | $20,920 | $12,964 | $27,617 | $23,227 | $23,687 | $28,647 | $18,357 | $33,767 | $42,510 | $28,400 | |
| Pro Forma Balance Sheet | |||||||||||||
| Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | $12,000 | $13,939 | $14,104 | $20,920 | $12,964 | $27,617 | $23,227 | $23,687 | $28,647 | $18,357 | $33,767 | $42,510 | $28,400 |
| Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Current Assets | $12,000 | $13,939 | $14,104 | $20,920 | $12,964 | $27,617 | $23,227 | $23,687 | $28,647 | $18,357 | $33,767 | $42,510 | $28,400 |
| 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 | $12,000 | $13,939 | $14,104 | $20,920 | $12,964 | $27,617 | $23,227 | $23,687 | $28,647 | $18,357 | $33,767 | $42,510 | $28,400 |
| Liabilities and Capital | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | |
| Current Liabilities | |||||||||||||
| Accounts Payable | $0 | $1,779 | $1,634 | $10,140 | $3,374 | $16,617 | $5,017 | $20,967 | $31,117 | $5,017 | $16,617 | $18,550 | $1,730 |
| 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 | $1,779 | $1,634 | $10,140 | $3,374 | $16,617 | $5,017 | $20,967 | $31,117 | $5,017 | $16,617 | $18,550 | $1,730 |
| Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Liabilities | $0 | $1,779 | $1,634 | $10,140 | $3,374 | $16,617 | $5,017 | $20,967 | $31,117 | $5,017 | $16,617 | $18,550 | $1,730 |
| Paid-in Capital | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Accumulated Surplus/Deficit | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 |
| Surplus/Deficit | $0 | $160 | $470 | ($1,220) | ($2,410) | ($1,000) | $6,210 | ($9,280) | ($14,470) | $1,340 | $5,150 | $11,960 | $14,670 |
| Total Capital | $12,000 | $12,160 | $12,470 | $10,780 | $9,590 | $11,000 | $18,210 | $2,720 | ($2,470) | $13,340 | $17,150 | $23,960 | $26,670 |
| Total Liabilities and Capital | $12,000 | $13,939 | $14,104 | $20,920 | $12,964 | $27,617 | $23,227 | $23,687 | $28,647 | $18,357 | $33,767 | $42,510 | $28,400 |
| Net Worth | $12,000 | $12,160 | $12,470 | $10,780 | $9,590 | $11,000 | $18,210 | $2,720 | ($2,470) | $13,340 | $17,150 | $23,960 | $26,670 |