Jungle Zone Paintball
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 | ||
Unit Sales | |||||||||||||
Admission | 0% | 0 | 0 | 0 | 1,000 | 1,000 | 1,500 | 1,800 | 2,000 | 1,600 | 1,400 | 1,200 | 1,000 |
Rentals | 0% | 0 | 0 | 0 | 750 | 750 | 1,250 | 1,500 | 1,700 | 1,375 | 1,150 | 900 | 750 |
Paint Balls | 0% | 0 | 0 | 0 | 2,000 | 2,000 | 3,000 | 3,800 | 4,000 | 3,000 | 2,500 | 2,200 | 2,000 |
Food | 0% | 0 | 0 | 0 | 500 | 500 | 760 | 760 | 860 | 950 | 900 | 650 | 600 |
Other | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Total Unit Sales | 0 | 0 | 0 | 4,250 | 4,250 | 6,510 | 7,860 | 8,560 | 6,925 | 5,950 | 4,950 | 4,350 | |
Unit Prices | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
Admission | $12.00 | $12.00 | $12.00 | $12.00 | $12.00 | $12.00 | $12.00 | $12.00 | $12.00 | $12.00 | $12.00 | $12.00 | |
Rentals | $15.00 | $15.00 | $15.00 | $15.00 | $15.00 | $15.00 | $15.00 | $15.00 | $15.00 | $15.00 | $15.00 | $15.00 | |
Paint Balls | $25.00 | $25.00 | $25.00 | $25.00 | $25.00 | $25.00 | $25.00 | $25.00 | $25.00 | $25.00 | $25.00 | $25.00 | |
Food | $10.00 | $5.00 | $5.00 | $5.00 | $5.00 | $5.00 | $5.00 | $5.00 | $5.00 | $5.00 | $5.00 | $5.00 | |
Other | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
Sales | |||||||||||||
Admission | $0 | $0 | $0 | $12,000 | $12,000 | $18,000 | $21,600 | $24,000 | $19,200 | $16,800 | $14,400 | $12,000 | |
Rentals | $0 | $0 | $0 | $11,250 | $11,250 | $18,750 | $22,500 | $25,500 | $20,625 | $17,250 | $13,500 | $11,250 | |
Paint Balls | $0 | $0 | $0 | $50,000 | $50,000 | $75,000 | $95,000 | $100,000 | $75,000 | $62,500 | $55,000 | $50,000 | |
Food | $0 | $0 | $0 | $2,500 | $2,500 | $3,800 | $3,800 | $4,300 | $4,750 | $4,500 | $3,250 | $3,000 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Sales | $0 | $0 | $0 | $75,750 | $75,750 | $115,550 | $142,900 | $153,800 | $119,575 | $101,050 | $86,150 | $76,250 | |
Direct Unit Costs | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
Admission | 0.00% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
Rentals | 0.00% | $0.00 | $0.00 | $0.00 | $1.00 | $1.00 | $1.00 | $1.00 | $1.00 | $1.00 | $1.00 | $1.00 | $1.00 |
Paint Balls | 0.00% | $0.00 | $0.00 | $0.00 | $3.00 | $3.00 | $3.00 | $3.00 | $3.00 | $3.00 | $3.00 | $3.00 | $3.00 |
Food | 0.00% | $0.00 | $0.00 | $0.00 | $1.00 | $1.00 | $1.00 | $1.00 | $1.00 | $1.00 | $1.00 | $1.00 | $1.00 |
Other | 0.00% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
Direct Cost of Sales | |||||||||||||
Admission | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Rentals | $0 | $0 | $0 | $750 | $750 | $1,250 | $1,500 | $1,700 | $1,375 | $1,150 | $900 | $750 | |
Paint Balls | $0 | $0 | $0 | $6,000 | $6,000 | $9,000 | $11,400 | $12,000 | $9,000 | $7,500 | $6,600 | $6,000 | |
Food | $0 | $0 | $0 | $500 | $500 | $760 | $760 | $860 | $950 | $900 | $650 | $600 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Direct Cost of Sales | $0 | $0 | $0 | $7,250 | $7,250 | $11,010 | $13,660 | $14,560 | $11,325 | $9,550 | $8,150 | $7,350 |
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 | 0% | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 |
Accountant | 0% | $0 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 |
Assistant Manager | 0% | $0 | $0 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 |
Facility Maintenance | 0% | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 |
Counter Staff | 0% | $0 | $0 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 |
Concession Person | 0% | $0 | $0 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 |
Referee/Safety Inspectors | 0% | $0 | $0 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 |
Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
Total Payroll | $7,500 | $11,000 | $27,500 | $27,500 | $27,500 | $27,500 | $27,500 | $27,500 | $27,500 | $27,500 | $27,500 | $27,500 |
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 | $0 | $0 | $0 | $75,750 | $75,750 | $115,550 | $142,900 | $153,800 | $119,575 | $101,050 | $86,150 | $76,250 | |
Direct Cost of Sales | $0 | $0 | $0 | $7,250 | $7,250 | $11,010 | $13,660 | $14,560 | $11,325 | $9,550 | $8,150 | $7,350 | |
Other Production Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $0 | $0 | $0 | $7,250 | $7,250 | $11,010 | $13,660 | $14,560 | $11,325 | $9,550 | $8,150 | $7,350 | |
Gross Margin | $0 | $0 | $0 | $68,500 | $68,500 | $104,540 | $129,240 | $139,240 | $108,250 | $91,500 | $78,000 | $68,900 | |
Gross Margin % | 0.00% | 0.00% | 0.00% | 90.43% | 90.43% | 90.47% | 90.44% | 90.53% | 90.53% | 90.55% | 90.54% | 90.36% | |
Expenses | |||||||||||||
Payroll | $7,500 | $11,000 | $27,500 | $27,500 | $27,500 | $27,500 | $27,500 | $27,500 | $27,500 | $27,500 | $27,500 | $27,500 | |
Sales and Marketing and Other Expenses | $0 | $0 | $20,000 | $50,000 | $50,000 | $45,000 | $45,000 | $45,000 | $45,000 | $23,000 | $22,000 | $21,000 | |
Depreciation | $0 | $0 | $600 | $600 | $600 | $600 | $600 | $600 | $600 | $600 | $600 | $600 | |
Leased Equipment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Utilities | $0 | $1,000 | $1,000 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | $1,800 | |
Insurance | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | |
Rent | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | |
Payroll Taxes | 15% | $1,125 | $1,650 | $4,125 | $4,125 | $4,125 | $4,125 | $4,125 | $4,125 | $4,125 | $4,125 | $4,125 | $4,125 |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Operating Expenses | $15,625 | $20,650 | $60,225 | $91,025 | $91,025 | $86,025 | $86,025 | $86,025 | $86,025 | $64,025 | $63,025 | $62,025 | |
Profit Before Interest and Taxes | ($15,625) | ($20,650) | ($60,225) | ($22,525) | ($22,525) | $18,515 | $43,215 | $53,215 | $22,225 | $27,475 | $14,975 | $6,875 | |
EBITDA | ($15,625) | ($20,650) | ($59,625) | ($21,925) | ($21,925) | $19,115 | $43,815 | $53,815 | $22,825 | $28,075 | $15,575 | $7,475 | |
Interest Expense | $1,237 | $1,224 | $1,211 | $1,198 | $1,185 | $1,172 | $1,159 | $1,146 | $1,133 | $1,120 | $1,107 | $1,094 | |
Taxes Incurred | ($5,059) | ($6,562) | ($18,431) | ($7,117) | ($7,113) | $5,203 | $12,617 | $15,621 | $6,328 | $7,907 | $4,160 | $1,734 | |
Net Profit | ($11,803) | ($15,312) | ($43,005) | ($16,606) | ($16,597) | $12,140 | $29,439 | $36,448 | $14,765 | $18,449 | $9,708 | $4,047 | |
Net Profit/Sales | 0.00% | 0.00% | 0.00% | -21.92% | -21.91% | 10.51% | 20.60% | 23.70% | 12.35% | 18.26% | 11.27% | 5.31% |
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 | $0 | $0 | $0 | $75,750 | $75,750 | $115,550 | $142,900 | $153,800 | $119,575 | $101,050 | $86,150 | $76,250 | |
Subtotal Cash from Operations | $0 | $0 | $0 | $75,750 | $75,750 | $115,550 | $142,900 | $153,800 | $119,575 | $101,050 | $86,150 | $76,250 | |
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 | $0 | $0 | $0 | $75,750 | $75,750 | $115,550 | $142,900 | $153,800 | $119,575 | $101,050 | $86,150 | $76,250 | |
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 | $7,500 | $11,000 | $27,500 | $27,500 | $27,500 | $27,500 | $27,500 | $27,500 | $27,500 | $27,500 | $27,500 | $27,500 | |
Bill Payments | $143 | $4,304 | $4,665 | $16,516 | $63,265 | $64,754 | $79,740 | $88,341 | $89,672 | $72,465 | $52,357 | $46,683 | |
Subtotal Spent on Operations | $7,643 | $15,304 | $32,165 | $44,016 | $90,765 | $92,254 | $107,240 | $115,841 | $117,172 | $99,965 | $79,857 | $74,183 | |
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 | $1,563 | $1,563 | $1,563 | $1,563 | $1,563 | $1,563 | $1,563 | $1,563 | $1,563 | $1,563 | $1,563 | $1,563 | |
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 | $9,206 | $16,866 | $33,727 | $45,579 | $92,327 | $93,816 | $108,803 | $117,404 | $118,734 | $101,528 | $81,420 | $75,745 | |
Net Cash Flow | ($9,206) | ($16,866) | ($33,727) | $30,171 | ($16,577) | $21,734 | $34,097 | $36,396 | $841 | ($478) | $4,730 | $505 | |
Cash Balance | $159,594 | $142,728 | $109,001 | $139,172 | $122,595 | $144,329 | $178,426 | $214,822 | $215,663 | $215,185 | $219,915 | $220,420 |
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 | $168,800 | $159,594 | $142,728 | $109,001 | $139,172 | $122,595 | $144,329 | $178,426 | $214,822 | $215,663 | $215,185 | $219,915 | $220,420 |
Inventory | $9,000 | $9,000 | $9,000 | $9,000 | $7,975 | $7,975 | $12,111 | $15,026 | $16,016 | $12,458 | $10,505 | $8,965 | $8,085 |
Other Current Assets | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 |
Total Current Assets | $192,800 | $183,594 | $166,728 | $133,001 | $162,147 | $145,570 | $171,440 | $208,452 | $245,838 | $243,120 | $240,690 | $243,880 | $243,505 |
Long-term Assets | |||||||||||||
Long-term Assets | $128,000 | $128,000 | $128,000 | $128,000 | $128,000 | $128,000 | $128,000 | $128,000 | $128,000 | $128,000 | $128,000 | $128,000 | $128,000 |
Accumulated Depreciation | $0 | $0 | $0 | $600 | $1,200 | $1,800 | $2,400 | $3,000 | $3,600 | $4,200 | $4,800 | $5,400 | $6,000 |
Total Long-term Assets | $128,000 | $128,000 | $128,000 | $127,400 | $126,800 | $126,200 | $125,600 | $125,000 | $124,400 | $123,800 | $123,200 | $122,600 | $122,000 |
Total Assets | $320,800 | $311,594 | $294,728 | $260,401 | $288,947 | $271,770 | $297,040 | $333,452 | $370,238 | $366,920 | $363,890 | $366,480 | $365,505 |
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 | $4,160 | $4,168 | $14,408 | $61,123 | $62,105 | $76,798 | $85,333 | $87,234 | $70,714 | $50,797 | $45,242 | $41,782 |
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 | $4,160 | $4,168 | $14,408 | $61,123 | $62,105 | $76,798 | $85,333 | $87,234 | $70,714 | $50,797 | $45,242 | $41,782 |
Long-term Liabilities | $150,000 | $148,438 | $146,875 | $145,313 | $143,750 | $142,188 | $140,625 | $139,063 | $137,500 | $135,938 | $134,375 | $132,813 | $131,250 |
Total Liabilities | $150,000 | $152,597 | $151,043 | $159,721 | $204,873 | $204,293 | $217,423 | $224,396 | $224,734 | $206,651 | $185,172 | $178,055 | $173,032 |
Paid-in Capital | $250,000 | $250,000 | $250,000 | $250,000 | $250,000 | $250,000 | $250,000 | $250,000 | $250,000 | $250,000 | $250,000 | $250,000 | $250,000 |
Retained Earnings | ($79,200) | ($79,200) | ($79,200) | ($79,200) | ($79,200) | ($79,200) | ($79,200) | ($79,200) | ($79,200) | ($79,200) | ($79,200) | ($79,200) | ($79,200) |
Earnings | $0 | ($11,803) | ($27,115) | ($70,120) | ($86,726) | ($103,323) | ($91,183) | ($61,744) | ($25,295) | ($10,531) | $7,918 | $17,626 | $21,672 |
Total Capital | $170,800 | $158,997 | $143,685 | $100,680 | $84,074 | $67,477 | $79,617 | $109,056 | $145,505 | $160,269 | $178,718 | $188,426 | $192,472 |
Total Liabilities and Capital | $320,800 | $311,594 | $294,728 | $260,401 | $288,947 | $271,770 | $297,040 | $333,452 | $370,238 | $366,920 | $363,890 | $366,480 | $365,505 |
Net Worth | $170,800 | $158,997 | $143,685 | $100,680 | $84,074 | $67,477 | $79,617 | $109,056 | $145,505 | $160,269 | $178,718 | $188,426 | $192,472 |