CMBA - Connecticut Motorsports Business Association

Start your own business plan »

Nonprofit Trade Association Business Plan

Appendix

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