Foosball Hall

Start your own business plan »

Bar and Tavern 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
Alcohol 0% $2,511 $2,787 $3,254 $4,587 $4,354 $5,656 $3,877 $6,141 $8,454 $8,654 $9,848 $7,414
Soft drinks 0% $1,356 $1,505 $1,757 $2,477 $2,351 $3,054 $2,094 $3,316 $4,565 $4,673 $5,318 $4,004
Food 0% $1,180 $1,310 $1,529 $2,156 $2,046 $2,658 $1,822 $2,886 $3,973 $4,067 $4,629 $3,485
Table fees 0% $477 $530 $618 $872 $827 $1,075 $737 $1,167 $1,606 $1,644 $1,871 $1,409
Total Sales $5,524 $6,131 $7,159 $10,091 $9,579 $12,443 $8,529 $13,510 $18,599 $19,039 $21,666 $16,311
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
Alcohol $628 $697 $814 $1,147 $1,089 $1,414 $969 $1,535 $2,114 $2,164 $2,462 $1,854
Soft drinks $339 $376 $439 $619 $588 $764 $523 $829 $241 $247 $281 $211
Food $389 $432 $505 $711 $675 $877 $601 $952 $1,311 $1,342 $1,527 $1,150
Table fees $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $1,356 $1,505 $1,757 $2,477 $2,352 $3,055 $2,094 $3,317 $3,666 $3,752 $4,270 $3,215
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
Stan 0% $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Bartenders 0% $0 $0 $1,500 $1,500 $1,700 $1,700 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900
Bartender assistants 0% $0 $0 $1,200 $1,200 $1,400 $1,400 $1,550 $1,550 $1,550 $1,550 $1,550 $1,550
Bookkeeper 0% $0 $0 $0 $0 $900 $900 $900 $900 $900 $900 $900 $900
Total People 1 1 6 6 6 7 8 8 8 8 8 8
Total Payroll $2,000 $2,000 $4,700 $4,700 $6,000 $6,000 $6,350 $6,350 $6,350 $6,350 $6,350 $6,350
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 $5,524 $6,131 $7,159 $10,091 $9,579 $12,443 $8,529 $13,510 $18,599 $19,039 $21,666 $16,311
Direct Cost of Sales $1,356 $1,505 $1,757 $2,477 $2,352 $3,055 $2,094 $3,317 $3,666 $3,752 $4,270 $3,215
Other Costs of Goods $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $1,356 $1,505 $1,757 $2,477 $2,352 $3,055 $2,094 $3,317 $3,666 $3,752 $4,270 $3,215
Gross Margin $4,168 $4,626 $5,401 $7,614 $7,227 $9,388 $6,435 $10,193 $14,933 $15,286 $17,396 $13,096
Gross Margin % 75.45% 75.45% 75.45% 75.45% 75.45% 75.45% 75.45% 75.45% 80.29% 80.29% 80.29% 80.29%
Expenses
Payroll $2,000 $2,000 $4,700 $4,700 $6,000 $6,000 $6,350 $6,350 $6,350 $6,350 $6,350 $6,350
Sales and Marketing and Other Expenses $400 $400 $400 $400 $400 $400 $400 $400 $400 $400 $400 $400
Depreciation $666 $666 $666 $666 $666 $666 $666 $666 $666 $666 $666 $666
Rent $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200
Utilities $350 $350 $350 $350 $350 $350 $350 $350 $350 $350 $350 $350
Insurance $800 $800 $800 $800 $800 $800 $800 $800 $800 $800 $800 $800
Payroll Taxes 15% $300 $300 $705 $705 $900 $900 $953 $953 $953 $953 $953 $953
Other $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Total Operating Expenses $6,216 $6,216 $9,321 $9,321 $10,816 $10,816 $11,219 $11,219 $11,219 $11,219 $11,219 $11,219
Profit Before Interest and Taxes ($2,048) ($1,590) ($3,920) ($1,707) ($3,589) ($1,428) ($4,783) ($1,025) $3,715 $4,068 $6,177 $1,878
EBITDA ($1,382) ($924) ($3,254) ($1,041) ($2,923) ($762) ($4,117) ($359) $4,381 $4,734 $6,843 $2,544
Interest Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Taxes Incurred $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit ($2,048) ($1,590) ($3,920) ($1,707) ($3,589) ($1,428) ($4,783) ($1,025) $3,715 $4,068 $6,177 $1,878
Net Profit/Sales -37.07% -25.93% -54.75% -16.92% -37.47% -11.47% -56.08% -7.59% 19.97% 21.37% 28.51% 11.51%
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 $5,524 $6,131 $7,159 $10,091 $9,579 $12,443 $8,529 $13,510 $18,599 $19,039 $21,666 $16,311
Subtotal Cash from Operations $5,524 $6,131 $7,159 $10,091 $9,579 $12,443 $8,529 $13,510 $18,599 $19,039 $21,666 $16,311
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 $5,524 $6,131 $7,159 $10,091 $9,579 $12,443 $8,529 $13,510 $18,599 $19,039 $21,666 $16,311
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 $2,000 $2,000 $4,700 $4,700 $6,000 $6,000 $6,350 $6,350 $6,350 $6,350 $6,350 $6,350
Bill Payments $164 $4,911 $5,077 $5,736 $6,435 $6,525 $7,175 $6,337 $7,531 $7,871 $7,972 $8,437
Subtotal Spent on Operations $2,164 $6,911 $9,777 $10,436 $12,435 $12,525 $13,525 $12,687 $13,881 $14,221 $14,322 $14,787
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 $2,164 $6,911 $9,777 $10,436 $12,435 $12,525 $13,525 $12,687 $13,881 $14,221 $14,322 $14,787
Net Cash Flow $3,361 ($780) ($2,618) ($345) ($2,856) ($82) ($4,995) $823 $4,718 $4,818 $7,343 $1,523
Cash Balance $47,661 $46,881 $44,263 $43,917 $41,062 $40,980 $35,985 $36,808 $41,525 $46,343 $53,687 $55,210
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 $44,300 $47,661 $46,881 $44,263 $43,917 $41,062 $40,980 $35,985 $36,808 $41,525 $46,343 $53,687 $55,210
Other Current Assets $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Total Current Assets $47,300 $50,661 $49,881 $47,263 $46,917 $44,062 $43,980 $38,985 $39,808 $44,525 $49,343 $56,687 $58,210
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 $666 $1,332 $1,998 $2,664 $3,330 $3,996 $4,662 $5,328 $5,994 $6,660 $7,326 $7,992
Total Long-term Assets $40,000 $39,334 $38,668 $38,002 $37,336 $36,670 $36,004 $35,338 $34,672 $34,006 $33,340 $32,674 $32,008
Total Assets $87,300 $89,995 $88,549 $85,265 $84,253 $80,732 $79,984 $74,323 $74,480 $78,531 $82,683 $89,361 $90,218
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,743 $4,887 $5,522 $6,218 $6,285 $6,965 $6,087 $7,269 $7,606 $7,690 $8,190 $7,170
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,743 $4,887 $5,522 $6,218 $6,285 $6,965 $6,087 $7,269 $7,606 $7,690 $8,190 $7,170
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $0 $4,743 $4,887 $5,522 $6,218 $6,285 $6,965 $6,087 $7,269 $7,606 $7,690 $8,190 $7,170
Paid-in Capital $95,000 $95,000 $95,000 $95,000 $95,000 $95,000 $95,000 $95,000 $95,000 $95,000 $95,000 $95,000 $95,000
Retained Earnings ($7,700) ($7,700) ($7,700) ($7,700) ($7,700) ($7,700) ($7,700) ($7,700) ($7,700) ($7,700) ($7,700) ($7,700) ($7,700)
Earnings $0 ($2,048) ($3,638) ($7,558) ($9,265) ($12,853) ($14,281) ($19,064) ($20,089) ($16,374) ($12,307) ($6,130) ($4,252)
Total Capital $87,300 $85,252 $83,662 $79,742 $78,035 $74,447 $73,019 $68,236 $67,211 $70,926 $74,993 $81,170 $83,048
Total Liabilities and Capital $87,300 $89,995 $88,549 $85,265 $84,253 $80,732 $79,984 $74,323 $74,480 $78,531 $82,683 $89,361 $90,218
Net Worth $87,300 $85,252 $83,662 $79,742 $78,035 $74,447 $73,019 $68,236 $67,211 $70,926 $74,993 $81,170 $83,048