Barney's Bullpen
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 |