Barney's Bullpen

Start your own business plan »

Baseball Batting Cages 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
Iron Mikes 0% $12,240 $5,508 $5,508 $2,754 $2,754 $2,754 $5,508 $12,240 $12,240 $12,240 $12,240 $12,240
Pitching Lanes 0% $6,120 $6,120 $2,754 $1,377 $1,377 $1,377 $2,754 $6,120 $6,120 $6,120 $6,120 $6,120
Hitting league 0% $0 $0 $0 $0 $6,000 $3,000 $6,000 $0 $6,000 $0 $6,000 $0
Instructor fees collected 0% $200 $300 $400 $400 $400 $400 $400 $500 $600 $700 $800 $800
Skills & Drills League registration fees 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $900 $900 $0
Utility Lanes 0% $6,120 $6,120 $2,754 $1,377 $1,377 $1,377 $2,754 $6,120 $6,120 $6,120 $6,120 $6,120
Total Sales $24,680 $18,048 $11,416 $5,908 $11,908 $8,908 $17,416 $24,980 $31,080 $26,080 $32,180 $25,280
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
Skills & Drills League prizes $0 $0 $0 $0 $0 $0 $0 $0 $0 $450 $450 $0
Instructor fees paid 80% $160 $240 $320 $320 $320 $320 $320 $400 $480 $560 $640 $640
Row 3 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $160 $240 $320 $320 $320 $320 $320 $400 $480 $1,010 $1,090 $640
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
Owner 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
Bookkeeper 0% $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Part time #1 0% $600 $600 $700 $400 $400 $400 $600 $700 $800 $800 $800 $800
Part time #2 0% $600 $600 $700 $0 $0 $0 $600 $700 $800 $800 $800 $800
Total People 4 4 4 3 3 3 4 4 4 4 4 4
Total Payroll $4,700 $4,700 $4,900 $3,900 $3,900 $3,900 $4,700 $4,900 $5,100 $5,100 $5,100 $5,100
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 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00%
Long-term Interest Rate 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.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 $24,680 $18,048 $11,416 $5,908 $11,908 $8,908 $17,416 $24,980 $31,080 $26,080 $32,180 $25,280
Direct Cost of Sales $160 $240 $320 $320 $320 $320 $320 $400 $480 $1,010 $1,090 $640
Other Costs of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $160 $240 $320 $320 $320 $320 $320 $400 $480 $1,010 $1,090 $640
Gross Margin $24,520 $17,808 $11,096 $5,588 $11,588 $8,588 $17,096 $24,580 $30,600 $25,070 $31,090 $24,640
Gross Margin % 99.35% 98.67% 97.20% 94.58% 97.31% 96.41% 98.16% 98.40% 98.46% 96.13% 96.61% 97.47%
Expenses
Payroll $4,700 $4,700 $4,900 $3,900 $3,900 $3,900 $4,700 $4,900 $5,100 $5,100 $5,100 $5,100
Marketing/Promotion $1,200 $500 $500 $100 $750 $100 $100 $100 $250 $250 $250 $500
Depreciation $429 $429 $429 $429 $429 $429 $429 $429 $429 $429 $429 $429
Rent $5,734 $5,734 $5,734 $5,734 $5,734 $5,734 $8,600 $8,600 $8,600 $8,600 $8,600 $8,600
Utilities $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Insurance $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Payroll Taxes 15% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Equipment Repair and Maintenance $306 $306 $138 $69 $295 $69 $138 $306 $306 $367 $367 $367
Ball and bat replacement 15% $122 $122 $55 $28 $28 $28 $55 $122 $122 $122 $122 $122
Other (incl. property taxes) $850 $825 $825 $825 $825 $825 $825 $825 $825 $825 $825 $825
Total Operating Expenses $13,841 $13,116 $13,080 $11,584 $12,460 $11,584 $15,346 $15,782 $16,132 $16,193 $16,193 $16,443
Profit Before Interest and Taxes $10,679 $4,692 ($1,984) ($5,996) ($872) ($2,996) $1,750 $8,798 $14,468 $8,877 $14,897 $8,197
EBITDA $11,108 $5,121 ($1,556) ($5,567) ($444) ($2,567) $2,178 $9,227 $14,897 $9,305 $15,325 $8,625
Interest Expense $467 $467 $467 $459 $451 $443 $436 $428 $420 $412 $404 $397
Taxes Incurred $3,064 $1,268 ($735) ($1,936) ($397) ($1,032) $394 $2,511 $4,214 $2,539 $4,348 $2,340
Net Profit $7,149 $2,958 ($1,716) ($4,518) ($926) ($2,408) $920 $5,859 $9,834 $5,925 $10,145 $5,460
Net Profit/Sales 28.97% 16.39% -15.03% -76.48% -7.78% -27.03% 5.28% 23.46% 31.64% 22.72% 31.52% 21.60%
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 $22,212 $16,243 $10,274 $5,317 $10,717 $8,017 $15,674 $22,482 $27,972 $23,472 $28,962 $22,752
Cash from Receivables $0 $82 $2,446 $1,783 $1,123 $611 $1,181 $919 $1,767 $2,518 $3,091 $2,628
Subtotal Cash from Operations $22,212 $16,325 $12,720 $7,100 $11,840 $8,628 $16,855 $23,401 $29,739 $25,990 $32,053 $25,380
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,212 $16,325 $12,720 $7,100 $11,840 $8,628 $16,855 $23,401 $29,739 $25,990 $32,053 $25,380
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 $4,700 $4,700 $4,900 $3,900 $3,900 $3,900 $4,700 $4,900 $5,100 $5,100 $5,100 $5,100
Bill Payments $413 $12,321 $9,890 $7,746 $6,178 $8,455 $7,133 $11,448 $13,856 $15,681 $14,689 $16,433
Subtotal Spent on Operations $5,113 $17,021 $14,790 $11,646 $10,078 $12,355 $11,833 $16,348 $18,956 $20,781 $19,789 $21,533
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 $1,167 $1,167 $1,167 $1,167 $1,167 $1,167 $1,167 $1,167 $1,167
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 $5,113 $17,021 $14,790 $12,813 $11,245 $13,522 $13,000 $17,515 $20,123 $21,948 $20,956 $22,700
Net Cash Flow $17,099 ($696) ($2,069) ($5,713) $596 ($4,894) $3,856 $5,886 $9,616 $4,042 $11,098 $2,681
Cash Balance $20,099 $19,403 $17,333 $11,620 $12,216 $7,322 $11,178 $17,064 $26,679 $30,722 $41,820 $44,500
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 $3,000 $20,099 $19,403 $17,333 $11,620 $12,216 $7,322 $11,178 $17,064 $26,679 $30,722 $41,820 $44,500
Accounts Receivable $0 $2,468 $4,191 $2,886 $1,694 $1,762 $2,042 $2,603 $4,182 $5,523 $5,612 $5,739 $5,639
Other Current Assets $11,150 $11,150 $11,150 $11,150 $11,150 $11,150 $11,150 $11,150 $11,150 $11,150 $11,150 $11,150 $11,150
Total Current Assets $14,150 $33,717 $34,743 $31,369 $24,464 $25,128 $20,514 $24,930 $32,395 $43,352 $47,484 $58,709 $61,289
Long-term Assets
Long-term Assets $36,000 $36,000 $36,000 $36,000 $36,000 $36,000 $36,000 $36,000 $36,000 $36,000 $36,000 $36,000 $36,000
Accumulated Depreciation $0 $429 $857 $1,286 $1,714 $2,143 $2,571 $3,000 $3,429 $3,857 $4,286 $4,714 $5,143
Total Long-term Assets $36,000 $35,571 $35,143 $34,714 $34,286 $33,857 $33,429 $33,000 $32,571 $32,143 $31,714 $31,286 $30,857
Total Assets $50,150 $69,288 $69,886 $66,084 $58,750 $58,985 $53,943 $57,930 $64,967 $75,495 $79,198 $89,994 $92,146
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 $11,989 $9,630 $7,543 $5,895 $8,222 $6,754 $10,989 $13,333 $15,194 $14,139 $15,957 $13,815
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 $11,989 $9,630 $7,543 $5,895 $8,222 $6,754 $10,989 $13,333 $15,194 $14,139 $15,957 $13,815
Long-term Liabilities $70,000 $70,000 $70,000 $70,000 $68,833 $67,667 $66,500 $65,333 $64,167 $63,000 $61,833 $60,667 $59,500
Total Liabilities $70,000 $81,989 $79,630 $77,543 $74,728 $75,889 $73,254 $76,322 $77,499 $78,194 $75,972 $76,623 $73,315
Paid-in Capital $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000
Retained Earnings ($27,850) ($27,850) ($27,850) ($27,850) ($27,850) ($27,850) ($27,850) ($27,850) ($27,850) ($27,850) ($27,850) ($27,850) ($27,850)
Earnings $0 $7,149 $10,106 $8,391 $3,872 $2,946 $539 $1,458 $7,318 $17,151 $23,076 $33,221 $38,681
Total Capital ($19,850) ($12,701) ($9,744) ($11,459) ($15,978) ($16,904) ($19,311) ($18,392) ($12,532) ($2,699) $3,226 $13,371 $18,831
Total Liabilities and Capital $50,150 $69,288 $69,886 $66,084 $58,750 $58,985 $53,943 $57,930 $64,967 $75,495 $79,198 $89,994 $92,146
Net Worth ($19,850) ($12,701) ($9,744) ($11,459) ($15,978) ($16,904) ($19,311) ($18,392) ($12,532) ($2,699) $3,226 $13,371 $18,831