Colloquy Grog Shop

Start your own business plan »

Singles Bar 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
Drinks 0% $0 $0 $5,012 $7,445 $7,887 $8,214 $8,998 $11,454 $13,128 $13,874 $14,454 $15,455
Food 0% $0 $0 $3,308 $4,914 $5,205 $5,421 $5,939 $7,560 $8,664 $9,157 $9,540 $10,200
Total Sales $0 $0 $8,320 $12,359 $13,092 $13,635 $14,937 $19,014 $21,792 $23,031 $23,994 $25,655
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
Drinks $0 $0 $1,253 $1,861 $1,972 $2,054 $2,250 $2,864 $3,282 $3,469 $3,614 $3,864
Food $0 $0 $1,389 $2,064 $2,186 $2,277 $2,494 $3,175 $3,639 $3,846 $4,007 $4,284
Subtotal Direct Cost of Sales $0 $0 $2,642 $3,925 $4,158 $4,330 $4,744 $6,039 $6,921 $7,314 $7,620 $8,148
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
Karen 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
Chef 0% $0 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500
Line cook 0% $0 $0 $1,440 $1,440 $1,440 $1,440 $1,440 $1,440 $1,440 $1,440 $1,440 $1,440
Server 0% $0 $0 $1,120 $1,120 $1,120 $1,120 $1,120 $1,120 $1,120 $1,120 $1,120 $1,120
Server 0% $0 $0 $1,120 $1,120 $1,120 $1,120 $1,120 $1,120 $1,120 $1,120 $1,120 $1,120
Server/bartender 0% $0 $0 $1,120 $1,120 $1,120 $1,120 $1,120 $1,120 $1,120 $1,120 $1,120 $1,120
Bartender 0% $0 $0 $1,120 $1,120 $1,120 $1,120 $1,120 $1,120 $1,120 $1,120 $1,120 $1,120
Dishwasher 0% $0 $0 $1,120 $1,120 $1,120 $1,120 $1,120 $1,120 $1,120 $1,120 $1,120 $1,120
Total People 1 2 8 8 8 8 8 8 8 8 8 8
Total Payroll $3,000 $6,500 $13,540 $13,540 $13,540 $13,540 $13,540 $13,540 $13,540 $13,540 $13,540 $13,540
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 $8,320 $12,359 $13,092 $13,635 $14,937 $19,014 $21,792 $23,031 $23,994 $25,655
Direct Cost of Sales $0 $0 $2,642 $3,925 $4,158 $4,330 $4,744 $6,039 $6,921 $7,314 $7,620 $8,148
Other Production Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $0 $0 $2,642 $3,925 $4,158 $4,330 $4,744 $6,039 $6,921 $7,314 $7,620 $8,148
Gross Margin $0 $0 $5,678 $8,434 $8,934 $9,305 $10,193 $12,975 $14,871 $15,716 $16,373 $17,507
Gross Margin % 0.00% 0.00% 68.24% 68.24% 68.24% 68.24% 68.24% 68.24% 68.24% 68.24% 68.24% 68.24%
Expenses
Payroll $3,000 $6,500 $13,540 $13,540 $13,540 $13,540 $13,540 $13,540 $13,540 $13,540 $13,540 $13,540
Sales and Marketing and Other Expenses $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Depreciation $833 $833 $833 $833 $833 $833 $833 $833 $833 $833 $833 $833
Permits $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
Utilities $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Insurance $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250
Rent $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500
Payroll Taxes 15% $450 $975 $2,031 $2,031 $2,031 $2,031 $2,031 $2,031 $2,031 $2,031 $2,031 $2,031
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $6,533 $10,558 $18,654 $18,654 $18,654 $18,654 $18,654 $18,654 $18,654 $18,654 $18,654 $18,654
Profit Before Interest and Taxes ($6,533) ($10,558) ($12,976) ($10,220) ($9,720) ($9,349) ($8,461) ($5,679) ($3,783) ($2,938) ($2,281) ($1,147)
EBITDA ($5,700) ($9,725) ($12,143) ($9,387) ($8,887) ($8,516) ($7,628) ($4,846) ($2,950) ($2,105) ($1,448) ($314)
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 ($6,533) ($10,558) ($12,976) ($10,220) ($9,720) ($9,349) ($8,461) ($5,679) ($3,783) ($2,938) ($2,281) ($1,147)
Net Profit/Sales 0.00% 0.00% -155.97% -82.70% -74.24% -68.57% -56.65% -29.87% -17.36% -12.75% -9.50% -4.47%
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 $8,320 $12,359 $13,092 $13,635 $14,937 $19,014 $21,792 $23,031 $23,994 $25,655
Subtotal Cash from Operations $0 $0 $8,320 $12,359 $13,092 $13,635 $14,937 $19,014 $21,792 $23,031 $23,994 $25,655
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 $8,320 $12,359 $13,092 $13,635 $14,937 $19,014 $21,792 $23,031 $23,994 $25,655
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 $6,500 $13,540 $13,540 $13,540 $13,540 $13,540 $13,540 $13,540 $13,540 $13,540 $13,540
Bill Payments $90 $2,718 $3,348 $6,966 $8,214 $8,445 $8,625 $9,068 $10,349 $11,215 $11,606 $11,919
Subtotal Spent on Operations $3,090 $9,218 $16,888 $20,506 $21,754 $21,985 $22,165 $22,608 $23,889 $24,755 $25,146 $25,459
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 $3,090 $9,218 $16,888 $20,506 $21,754 $21,985 $22,165 $22,608 $23,889 $24,755 $25,146 $25,459
Net Cash Flow ($3,090) ($9,218) ($8,568) ($8,147) ($8,661) ($8,350) ($7,229) ($3,594) ($2,096) ($1,724) ($1,152) $197
Cash Balance $65,760 $56,543 $47,974 $39,827 $31,165 $22,816 $15,587 $11,993 $9,897 $8,172 $7,020 $7,217
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 $68,850 $65,760 $56,543 $47,974 $39,827 $31,165 $22,816 $15,587 $11,993 $9,897 $8,172 $7,020 $7,217
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $68,850 $65,760 $56,543 $47,974 $39,827 $31,165 $22,816 $15,587 $11,993 $9,897 $8,172 $7,020 $7,217
Long-term Assets
Long-term Assets $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000
Accumulated Depreciation $0 $833 $1,666 $2,499 $3,332 $4,165 $4,998 $5,831 $6,664 $7,497 $8,330 $9,163 $9,996
Total Long-term Assets $50,000 $49,167 $48,334 $47,501 $46,668 $45,835 $45,002 $44,169 $43,336 $42,503 $41,670 $40,837 $40,004
Total Assets $118,850 $114,927 $104,877 $95,475 $86,495 $77,000 $67,818 $59,756 $55,329 $52,400 $49,842 $47,857 $47,221
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 $2,610 $3,118 $6,693 $7,932 $8,158 $8,324 $8,724 $9,976 $10,829 $11,209 $11,504 $12,015
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 $2,610 $3,118 $6,693 $7,932 $8,158 $8,324 $8,724 $9,976 $10,829 $11,209 $11,504 $12,015
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $0 $2,610 $3,118 $6,693 $7,932 $8,158 $8,324 $8,724 $9,976 $10,829 $11,209 $11,504 $12,015
Paid-in Capital $120,000 $120,000 $120,000 $120,000 $120,000 $120,000 $120,000 $120,000 $120,000 $120,000 $120,000 $120,000 $120,000
Retained Earnings ($1,150) ($1,150) ($1,150) ($1,150) ($1,150) ($1,150) ($1,150) ($1,150) ($1,150) ($1,150) ($1,150) ($1,150) ($1,150)
Earnings $0 ($6,533) ($17,091) ($30,067) ($40,288) ($50,007) ($59,356) ($67,818) ($73,496) ($77,279) ($80,217) ($82,497) ($83,644)
Total Capital $118,850 $112,317 $101,759 $88,783 $78,562 $68,843 $59,494 $51,032 $45,354 $41,571 $38,633 $36,353 $35,206
Total Liabilities and Capital $118,850 $114,927 $104,877 $95,475 $86,495 $77,000 $67,818 $59,756 $55,329 $52,400 $49,842 $47,857 $47,221
Net Worth $118,850 $112,317 $101,759 $88,783 $78,562 $68,843 $59,494 $51,032 $45,354 $41,571 $38,633 $36,353 $35,206