Dribbling Indoor Soccer

Start your own business plan »

Indoor Soccer Facility Business Plan

Appendix

Sales 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
Sales
Memberships 0% $3,000 $6,000 $7,000 $3,000 $3,000 $3,000 $3,000 $3,000 $1,000 $3,000 $3,000 $4,000
Leagues 0% $8,000 $11,000 $15,000 $19,000 $19,000 $21,000 $21,000 $3,000 $6,000 $21,000 $21,000 $20,000
Rentals 0% $3,000 $3,000 $3,000 $3,000 $3,000 $4,000 $5,000 $5,000 $2,000 $4,000 $4,000 $4,000
Clinics 0% $0 $3,000 $3,000 $3,000 $3,000 $4,000 $4,000 $4,000 $2,000 $4,000 $4,000 $4,000
Soccer Shop 0% $3,000 $4,000 $4,000 $4,000 $4,000 $5,000 $4,000 $4,000 $5,000 $4,000 $4,000 $4,000
Cafe 0% $0 $4,000 $5,000 $5,000 $5,000 $5,000 $5,000 $3,000 $1,000 $5,000 $5,000 $5,000
Total Sales $17,000 $31,000 $37,000 $37,000 $37,000 $42,000 $42,000 $22,000 $17,000 $41,000 $41,000 $41,000
Direct Cost of Sales Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Memberships $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Leagues $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Rentals $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Clinics $1,500 $1,500 $1,500 $1,500 $1,500 $2,000 $2,000 $2,000 $1,000 $2,000 $2,000 $2,000
Soccer Shop $1,000 $1,500 $1,500 $1,500 $1,500 $2,000 $1,500 $1,500 $2,000 $1,500 $1,500 $1,500
Cafe $0 $1,000 $1,250 $1,250 $1,250 $1,250 $1,250 $750 $250 $1,250 $1,250 $1,250
Subtotal Direct Cost of Sales $2,500 $4,000 $4,250 $4,250 $4,250 $5,250 $4,750 $4,250 $3,250 $4,750 $4,750 $4,750
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
Manager - Klew, Les 0% $2,800 $2,800 $2,800 $2,800 $2,800 $2,800 $2,800 $2,800 $2,800 $2,800 $2,800 $2,800
Asst. Manager - Noh Klew 0% $2,800 $2,800 $2,800 $2,800 $2,800 $2,800 $2,800 $2,800 $2,800 $2,800 $2,800 $2,800
Senior Staff 0% $4,400 $4,400 $4,400 $4,400 $4,400 $4,400 $4,400 $4,400 $4,400 $4,400 $4,400 $4,400
Staff Members 0% $3,900 $3,900 $3,900 $3,900 $3,900 $3,900 $3,900 $3,900 $3,900 $3,900 $3,900 $3,900
Soccer Store Staff Person 0% $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600
Cafe Staff 0% $2,400 $2,400 $2,400 $2,400 $2,400 $2,400 $2,400 $2,400 $2,400 $2,400 $2,400 $2,400
Total People 7 7 7 7 7 7 7 7 7 7 7 7
Total Payroll $17,900 $17,900 $17,900 $17,900 $17,900 $17,900 $17,900 $17,900 $17,900 $17,900 $17,900 $17,900
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 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00%
Other 0 0 0 0 0 0 0 0 0 0 0 0
Pro Forma Profit and Loss
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Sales $17,000 $31,000 $37,000 $37,000 $37,000 $42,000 $42,000 $22,000 $17,000 $41,000 $41,000 $41,000
Direct Cost of Sales $2,500 $4,000 $4,250 $4,250 $4,250 $5,250 $4,750 $4,250 $3,250 $4,750 $4,750 $4,750
Other Production Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $2,500 $4,000 $4,250 $4,250 $4,250 $5,250 $4,750 $4,250 $3,250 $4,750 $4,750 $4,750
Gross Margin $14,500 $27,000 $32,750 $32,750 $32,750 $36,750 $37,250 $17,750 $13,750 $36,250 $36,250 $36,250
Gross Margin % 85.29% 87.10% 88.51% 88.51% 88.51% 87.50% 88.69% 80.68% 80.88% 88.41% 88.41% 88.41%
Expenses
Payroll $17,900 $17,900 $17,900 $17,900 $17,900 $17,900 $17,900 $17,900 $17,900 $17,900 $17,900 $17,900
Sales and Marketing and Other Expenses $800 $2,800 $2,800 $2,800 $2,800 $2,800 $2,800 $2,800 $2,800 $2,800 $2,800 $2,800
Depreciation $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Leased Equipment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Utilities $400 $400 $400 $400 $400 $400 $400 $400 $400 $400 $400 $400
Insurance $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Rent $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000
Payroll Taxes 15% $2,685 $2,685 $2,685 $2,685 $2,685 $2,685 $2,685 $2,685 $2,685 $2,685 $2,685 $2,685
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $26,785 $28,785 $28,785 $28,785 $28,785 $28,785 $28,785 $28,785 $28,785 $28,785 $28,785 $28,785
Profit Before Interest and Taxes ($12,285) ($1,785) $3,965 $3,965 $3,965 $7,965 $8,465 ($11,035) ($15,035) $7,465 $7,465 $7,465
EBITDA ($11,785) ($1,285) $4,465 $4,465 $4,465 $8,465 $8,965 ($10,535) ($14,535) $7,965 $7,965 $7,965
Interest Expense $833 $833 $833 $833 $833 $833 $833 $833 $833 $833 $833 $833
Taxes Incurred ($3,936) ($786) $939 $939 $939 $2,140 $2,290 ($3,561) ($4,761) $1,990 $1,990 $1,990
Net Profit ($9,183) ($1,833) $2,192 $2,192 $2,192 $4,992 $5,342 ($8,308) ($11,108) $4,642 $4,642 $4,642
Net Profit/Sales -54.02% -5.91% 5.92% 5.92% 5.92% 11.89% 12.72% -37.76% -65.34% 11.32% 11.32% 11.32%
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 Sales $17,000 $31,000 $37,000 $37,000 $37,000 $42,000 $42,000 $22,000 $17,000 $41,000 $41,000 $41,000
Subtotal Cash from Operations $17,000 $31,000 $37,000 $37,000 $37,000 $42,000 $42,000 $22,000 $17,000 $41,000 $41,000 $41,000
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 $17,000 $31,000 $37,000 $37,000 $37,000 $42,000 $42,000 $22,000 $17,000 $41,000 $41,000 $41,000
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 $17,900 $17,900 $17,900 $17,900 $17,900 $17,900 $17,900 $17,900 $17,900 $17,900 $17,900 $17,900
Bill Payments $209 $6,584 $15,378 $16,674 $16,408 $16,518 $19,641 $17,496 $11,266 $8,975 $19,553 $17,958
Subtotal Spent on Operations $18,109 $24,485 $33,278 $34,574 $34,308 $34,418 $37,541 $35,396 $29,166 $26,875 $37,453 $35,858
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 $18,109 $24,485 $33,278 $34,574 $34,308 $34,418 $37,541 $35,396 $29,166 $26,875 $37,453 $35,858
Net Cash Flow ($1,109) $6,516 $3,722 $2,426 $2,692 $7,582 $4,459 ($13,396) ($12,166) $14,126 $3,547 $5,142
Cash Balance $28,891 $35,406 $39,128 $41,555 $44,247 $51,829 $56,288 $42,892 $30,725 $44,851 $48,398 $53,540
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 $30,000 $28,891 $35,406 $39,128 $41,555 $44,247 $51,829 $56,288 $42,892 $30,725 $44,851 $48,398 $53,540
Inventory $5,000 $3,500 $4,400 $4,675 $4,675 $4,675 $5,775 $5,225 $4,675 $3,575 $5,225 $5,225 $5,225
Other Current Assets $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
Total Current Assets $40,000 $37,391 $44,806 $48,803 $51,230 $53,922 $62,604 $66,513 $52,567 $39,300 $55,076 $58,623 $63,765
Long-term Assets
Long-term Assets $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000
Accumulated Depreciation $0 $500 $1,000 $1,500 $2,000 $2,500 $3,000 $3,500 $4,000 $4,500 $5,000 $5,500 $6,000
Total Long-term Assets $40,000 $39,500 $39,000 $38,500 $38,000 $37,500 $37,000 $36,500 $36,000 $35,500 $35,000 $34,500 $34,000
Total Assets $80,000 $76,891 $83,806 $87,303 $89,230 $91,422 $99,604 $103,013 $88,567 $74,800 $90,076 $93,123 $97,765
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 $6,073 $14,822 $16,127 $15,861 $15,861 $19,051 $17,118 $10,979 $8,321 $18,954 $17,359 $17,359
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 $6,073 $14,822 $16,127 $15,861 $15,861 $19,051 $17,118 $10,979 $8,321 $18,954 $17,359 $17,359
Long-term Liabilities $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000
Total Liabilities $100,000 $106,073 $114,822 $116,127 $115,861 $115,861 $119,051 $117,118 $110,979 $108,321 $118,954 $117,359 $117,359
Paid-in Capital $60,000 $60,000 $60,000 $60,000 $60,000 $60,000 $60,000 $60,000 $60,000 $60,000 $60,000 $60,000 $60,000
Retained Earnings ($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)
Earnings $0 ($9,183) ($11,016) ($8,824) ($6,631) ($4,439) $553 $5,895 ($2,413) ($13,521) ($8,878) ($4,236) $406
Total Capital ($20,000) ($29,183) ($31,016) ($28,824) ($26,631) ($24,439) ($19,447) ($14,105) ($22,413) ($33,521) ($28,878) ($24,236) ($19,594)
Total Liabilities and Capital $80,000 $76,891 $83,806 $87,303 $89,230 $91,422 $99,604 $103,013 $88,567 $74,800 $90,076 $93,123 $97,765
Net Worth ($20,000) ($29,183) ($31,016) ($28,823) ($26,631) ($24,439) ($19,447) ($14,105) ($22,413) ($33,520) ($28,878) ($24,236) ($19,594)