Rockin Roll

Start your own business plan »

Karaoke Bar - Bowling Alley 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
Youths 0% $0 $0 $0 $1,200 $1,200 $4,200 $4,200 $4,200 $2,800 $2,800 $2,800 $2,800
Senior Citizens 0% $0 $0 $0 $2,880 $2,880 $2,880 $2,880 $2,880 $2,880 $2,880 $2,880 $2,880
Food 0% $0 $0 $0 $14,000 $15,750 $16,000 $14,000 $14,000 $14,000 $15,750 $15,750 $16,000
Video Games 0% $0 $0 $0 $1,500 $1,800 $2,000 $2,800 $3,400 $2,800 $2,800 $2,800 $3,200
Pull Tabs 0% $0 $0 $0 $12,000 $12,000 $12,000 $12,000 $12,000 $7,500 $15,000 $15,000 $15,000
Liquor 0% $0 $0 $0 $8,000 $7,000 $7,000 $10,000 $7,000 $7,000 $12,000 $7,000 $10,000
Leaguers 0% $0 $0 $0 $4,400 $4,400 $4,400 $2,200 $2,200 $2,200 $6,600 $6,600 $6,600
Total Sales $0 $0 $0 $43,980 $45,030 $48,480 $48,080 $45,680 $39,180 $57,830 $52,830 $56,480
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
Youths $0 $0 $0 $480 $480 $480 $480 $480 $480 $480 $480 $480
Senior Citizens $0 $0 $0 $424 $424 $424 $424 $424 $424 $424 $424 $424
Food $0 $0 $0 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000
Video Games $0 $0 $0 $500 $500 $500 $500 $500 $500 $500 $500 $500
Pull Tabs $0 $0 $0 $400 $400 $400 $400 $400 $400 $400 $400 $400
Liquor $0 $0 $0 $96 $96 $96 $96 $96 $96 $96 $96 $96
Leaguers $0 $0 $0 $650 $650 $650 $650 $650 $650 $650 $650 $650
Subtotal Direct Cost of Sales $0 $0 $0 $12,550 $12,550 $12,550 $12,550 $12,550 $12,550 $12,550 $12,550 $12,550
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
Pelvis 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
Kitchen Manager 0% $0 $0 $0 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Lane Maintenance 0% $0 $0 $0 $640 $640 $640 $640 $640 $640 $640 $640 $640
League Manager 0% $0 $0 $0 $640 $640 $640 $640 $640 $640 $640 $640 $640
Cashier 0% $0 $0 $0 $1,120 $1,120 $1,120 $1,120 $1,120 $1,120 $1,120 $1,120 $1,120
Bartender 0% $0 $0 $0 $1,120 $1,120 $1,120 $1,120 $1,120 $1,120 $1,120 $1,120 $1,120
Total People 1 1 5 5 5 6 6 6 6 6 6 6
Total Payroll $3,000 $3,000 $3,000 $8,520 $8,520 $8,520 $8,520 $8,520 $8,520 $8,520 $8,520 $8,520
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 $43,980 $45,030 $48,480 $48,080 $45,680 $39,180 $57,830 $52,830 $56,480
Direct Cost of Sales $0 $0 $0 $12,550 $12,550 $12,550 $12,550 $12,550 $12,550 $12,550 $12,550 $12,550
Hidden Row $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $0 $0 $0 $12,550 $12,550 $12,550 $12,550 $12,550 $12,550 $12,550 $12,550 $12,550
Gross Margin $0 $0 $0 $31,430 $32,480 $35,930 $35,530 $33,130 $26,630 $45,280 $40,280 $43,930
Gross Margin % 0.00% 0.00% 0.00% 71.46% 72.13% 74.11% 73.90% 72.53% 67.97% 78.30% 76.24% 77.78%
Expenses
Payroll $3,000 $3,000 $3,000 $8,520 $8,520 $8,520 $8,520 $8,520 $8,520 $8,520 $8,520 $8,520
Sales and Marketing and Other Expenses $3,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Depreciation $649 $649 $649 $649 $649 $649 $649 $649 $649 $649 $649 $649
Rent $0 $0 $0 $0 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000
Utilities $280 $280 $280 $280 $280 $280 $280 $280 $280 $280 $280 $280
Insurance 15% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Payroll Taxes 15% $450 $450 $450 $1,278 $1,278 $1,278 $1,278 $1,278 $1,278 $1,278 $1,278 $1,278
Total Operating Expenses $7,379 $4,379 $4,379 $10,727 $20,727 $20,727 $20,727 $20,727 $20,727 $20,727 $20,727 $20,727
Profit Before Interest and Taxes ($7,379) ($4,379) ($4,379) $20,703 $11,753 $15,203 $14,803 $12,403 $5,903 $24,553 $19,553 $23,203
EBITDA ($6,730) ($3,730) ($3,730) $21,352 $12,402 $15,852 $15,452 $13,052 $6,552 $25,202 $20,202 $23,852
Interest Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Taxes Incurred ($2,214) ($1,314) ($1,314) $6,211 $3,526 $4,561 $4,441 $3,721 $1,771 $7,366 $5,866 $6,961
Other Income
Interest Income $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other Income Account Name $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Other Income $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other Expense
Account Name $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other Expense Account Name $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Other Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Other Income $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit ($5,165) ($3,065) ($3,065) $14,492 $8,227 $10,642 $10,362 $8,682 $4,132 $17,187 $13,687 $16,242
Net Profit/Sales 0.00% 0.00% 0.00% 32.95% 18.27% 21.95% 21.55% 19.01% 10.55% 29.72% 25.91% 28.76%
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 $43,980 $45,030 $48,480 $48,080 $45,680 $39,180 $57,830 $52,830 $56,480
Subtotal Cash from Operations $0 $0 $0 $43,980 $45,030 $48,480 $48,080 $45,680 $39,180 $57,830 $52,830 $56,480
Additional Cash Received
Non Operating (Other) Income $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
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 $43,980 $45,030 $48,480 $48,080 $45,680 $39,180 $57,830 $52,830 $56,480
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 $3,000 $3,000 $3,000 $8,520 $8,520 $8,520 $8,520 $8,520 $8,520 $8,520 $8,520 $8,520
Bill Payments $51 $882 ($1,148) $340 $27,141 $27,668 $28,665 $28,525 $27,764 $26,065 $31,424 $30,010
Subtotal Spent on Operations $3,051 $3,882 $1,852 $8,860 $35,661 $36,188 $37,185 $37,045 $36,284 $34,585 $39,944 $38,530
Additional Cash Spent
Non Operating (Other) Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
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,051 $3,882 $1,852 $8,860 $35,661 $36,188 $37,185 $37,045 $36,284 $34,585 $39,944 $38,530
Net Cash Flow ($3,051) ($3,882) ($1,852) $35,120 $9,369 $12,292 $10,895 $8,635 $2,896 $23,245 $12,886 $17,950
Cash Balance $47,049 $43,167 $41,315 $76,435 $85,805 $98,096 $108,991 $117,626 $120,522 $143,767 $156,653 $174,603
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 $50,100 $47,049 $43,167 $41,315 $76,435 $85,805 $98,096 $108,991 $117,626 $120,522 $143,767 $156,653 $174,603
Inventory $7,000 $7,000 $7,000 $7,000 $13,805 $13,805 $13,805 $13,805 $13,805 $13,805 $13,805 $13,805 $13,805
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $57,100 $54,049 $50,167 $48,315 $90,240 $99,610 $111,901 $122,796 $131,431 $134,327 $157,572 $170,458 $188,408
Long-term Assets
Long-term Assets $77,900 $77,900 $77,900 $77,900 $77,900 $77,900 $77,900 $77,900 $77,900 $77,900 $77,900 $77,900 $77,900
Accumulated Depreciation $0 $649 $1,298 $1,947 $2,596 $3,245 $3,894 $4,543 $5,192 $5,841 $6,490 $7,139 $7,788
Total Long-term Assets $77,900 $77,251 $76,602 $75,953 $75,304 $74,655 $74,006 $73,357 $72,708 $72,059 $71,410 $70,761 $70,112
Total Assets $135,000 $131,300 $126,769 $124,268 $165,544 $174,265 $185,907 $196,153 $204,139 $206,386 $228,982 $241,219 $258,520
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 $1,466 $0 $564 $27,348 $27,841 $28,842 $28,726 $28,030 $26,145 $31,553 $30,103 $31,162
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,466 $0 $564 $27,348 $27,841 $28,842 $28,726 $28,030 $26,145 $31,553 $30,103 $31,162
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $0 $1,466 $0 $564 $27,348 $27,841 $28,842 $28,726 $28,030 $26,145 $31,553 $30,103 $31,162
Paid-in Capital $200,000 $200,000 $200,000 $200,000 $200,000 $200,000 $200,000 $200,000 $200,000 $200,000 $200,000 $200,000 $200,000
Retained Earnings ($65,000) ($65,000) ($65,000) ($65,000) ($65,000) ($65,000) ($65,000) ($65,000) ($65,000) ($65,000) ($65,000) ($65,000) ($65,000)
Earnings $0 ($5,165) ($8,231) ($11,296) $3,196 $11,423 $22,065 $32,428 $41,110 $45,242 $62,429 $76,116 $92,358
Total Capital $135,000 $129,835 $126,769 $123,704 $138,196 $146,423 $157,065 $167,428 $176,110 $180,242 $197,429 $211,116 $227,358
Total Liabilities and Capital $135,000 $131,300 $126,769 $124,268 $165,544 $174,265 $185,907 $196,153 $204,139 $206,386 $228,982 $241,219 $258,520
Net Worth $135,000 $129,835 $126,769 $123,704 $138,196 $146,423 $157,065 $167,427 $176,110 $180,242 $197,429 $211,116 $227,358