Our biggest savings of the year
CMBA - Connecticut Motorsports Business Association
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 |