Arz al-Lubnan Hookah Bar

Start your own business plan »

Hookah 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
Unit Sales
Tobacco 500 600 720 864 1,037 1,244 1,493 1,792 2,150 2,580 3,096 3,715
Drinks 600 720 864 1,037 1,244 1,493 1,792 2,150 2,580 3,096 3,715 4,458
Food 400 480 576 691 829 995 1,194 1,433 1,720 2,064 2,477 2,972
Total Unit Sales 1,500 1,800 2,160 2,592 3,110 3,732 4,479 5,375 6,450 7,740 9,288 11,145
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
Tobacco $14.00 $14.00 $14.00 $14.00 $14.00 $14.00 $14.00 $14.00 $14.00 $14.00 $14.00 $14.00
Drinks $6.00 $6.00 $6.00 $6.00 $6.00 $6.00 $6.00 $6.00 $6.00 $6.00 $6.00 $6.00
Food $5.00 $5.00 $5.00 $5.00 $5.00 $5.00 $5.00 $5.00 $5.00 $5.00 $5.00 $5.00
Sales
Tobacco $7,000 $8,400 $10,080 $12,096 $14,518 $17,416 $20,902 $25,088 $30,100 $36,120 $43,344 $52,010
Drinks $3,600 $4,320 $5,184 $6,222 $7,464 $8,958 $10,752 $12,900 $15,480 $18,576 $22,290 $26,748
Food $2,000 $2,400 $2,880 $3,455 $4,145 $4,975 $5,970 $7,165 $8,600 $10,320 $12,385 $14,860
Total Sales $12,600 $15,120 $18,144 $21,773 $26,127 $31,349 $37,624 $45,153 $54,180 $65,016 $78,019 $93,618
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
Tobacco 30.00% $4.20 $4.20 $4.20 $4.20 $4.20 $4.20 $4.20 $4.20 $4.20 $4.20 $4.20 $4.20
Drinks 20.00% $1.20 $1.20 $1.20 $1.20 $1.20 $1.20 $1.20 $1.20 $1.20 $1.20 $1.20 $1.20
Food 30.00% $1.50 $1.50 $1.50 $1.50 $1.50 $1.50 $1.50 $1.50 $1.50 $1.50 $1.50 $1.50
Direct Cost of Sales
Tobacco $2,100 $2,520 $3,024 $3,629 $4,355 $5,225 $6,271 $7,526 $9,030 $10,836 $13,003 $15,603
Drinks $720 $864 $1,037 $1,244 $1,493 $1,792 $2,150 $2,580 $3,096 $3,715 $4,458 $5,350
Food $600 $720 $864 $1,037 $1,244 $1,493 $1,791 $2,150 $2,580 $3,096 $3,716 $4,458
Subtotal Direct Cost of Sales $3,420 $4,104 $4,925 $5,910 $7,092 $8,509 $10,212 $12,256 $14,706 $17,647 $21,177 $25,411
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
Sayed Batroun $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Yamine Batroun $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Bar Staff $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000
Wait Staff $2,800 $2,800 $2,800 $2,800 $2,800 $2,800 $2,800 $2,800 $2,800 $2,800 $2,800 $2,800
Kitchen Staff $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500
General Manager $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 7 7 7 7 7 7 7 7 7 7 7 7
Total Payroll $15,300 $15,300 $15,300 $15,300 $15,300 $15,300 $15,300 $15,300 $15,300 $15,300 $15,300 $15,300
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 $12,600 $15,120 $18,144 $21,773 $26,127 $31,349 $37,624 $45,153 $54,180 $65,016 $78,019 $93,618
Direct Cost of Sales $3,420 $4,104 $4,925 $5,910 $7,092 $8,509 $10,212 $12,256 $14,706 $17,647 $21,177 $25,411
Other Costs of Sales $1,000 $1,050 $1,102 $1,157 $1,215 $1,276 $1,340 $1,407 $1,477 $1,551 $1,629 $1,710
Total Cost of Sales $4,420 $5,154 $6,027 $7,067 $8,307 $9,785 $11,552 $13,663 $16,183 $19,198 $22,806 $27,121
Gross Margin $8,180 $9,966 $12,117 $14,706 $17,820 $21,564 $26,072 $31,490 $37,997 $45,818 $55,213 $66,497
Gross Margin % 64.92% 65.91% 66.78% 67.54% 68.21% 68.79% 69.30% 69.74% 70.13% 70.47% 70.77% 71.03%
Expenses
Payroll $15,300 $15,300 $15,300 $15,300 $15,300 $15,300 $15,300 $15,300 $15,300 $15,300 $15,300 $15,300
Marketing/Promotion $5,000 $5,000 $5,000 $5,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Depreciation $1,400 $1,400 $1,400 $1,400 $1,400 $1,400 $1,400 $1,400 $1,400 $1,400 $1,400 $1,400
Rent $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Utilities $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300
Insurance $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Payroll Taxes 15% $2,295 $2,295 $2,295 $2,295 $2,295 $2,295 $2,295 $2,295 $2,295 $2,295 $2,295 $2,295
Permit Renewals 15% $0 $0 $0 $0 $0 $0 $0 $0 $0 $500 $0 $0
Supplies $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Total Operating Expenses $26,995 $26,995 $26,995 $26,995 $24,995 $24,995 $24,995 $24,995 $24,995 $25,495 $24,995 $24,995
Profit Before Interest and Taxes ($18,815) ($17,029) ($14,878) ($12,289) ($7,175) ($3,431) $1,077 $6,495 $13,002 $20,323 $30,218 $41,502
EBITDA ($17,415) ($15,629) ($13,478) ($10,889) ($5,775) ($2,031) $2,477 $7,895 $14,402 $21,723 $31,618 $42,902
Interest Expense $513 $509 $505 $495 $485 $475 $453 $428 $403 $378 $354 $342
Taxes Incurred ($5,798) ($5,261) ($4,615) ($3,835) ($2,298) ($1,172) $187 $1,820 $3,780 $5,983 $8,959 $12,348
Net Profit ($13,530) ($12,277) ($10,768) ($8,949) ($5,362) ($2,734) $437 $4,247 $8,819 $13,961 $20,905 $28,813
Net Profit/Sales -107.38% -81.20% -59.35% -41.10% -20.52% -8.72% 1.16% 9.41% 16.28% 21.47% 26.79% 30.78%
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 $12,600 $15,120 $18,144 $21,773 $26,127 $31,349 $37,624 $45,153 $54,180 $65,016 $78,019 $93,618
Subtotal Cash from Operations $12,600 $15,120 $18,144 $21,773 $26,127 $31,349 $37,624 $45,153 $54,180 $65,016 $78,019 $93,618
Additional Cash Received
Sales Tax, VAT, HST/GST Received 9.00% $1,134 $1,361 $1,633 $1,960 $2,351 $2,821 $3,386 $4,064 $4,876 $5,851 $7,022 $8,426
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 $13,734 $16,481 $19,777 $23,733 $28,478 $34,170 $41,010 $49,217 $59,056 $70,867 $85,041 $102,044
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 $15,300 $15,300 $15,300 $15,300 $15,300 $15,300 $15,300 $15,300 $15,300 $15,300 $15,300 $15,300
Bill Payments $314 $9,472 $10,747 $12,273 $14,047 $14,876 $17,487 $20,611 $24,354 $28,850 $34,557 $40,670
Subtotal Spent on Operations $15,614 $24,772 $26,047 $27,573 $29,347 $30,176 $32,787 $35,911 $39,654 $44,150 $49,857 $55,970
Additional Cash Spent
Sales Tax, VAT, HST/GST Paid Out $1,134 $1,361 $1,633 $1,960 $2,351 $2,821 $3,386 $4,064 $4,876 $5,851 $7,022 $8,426
Principal Repayment of Current Borrowing $300 $300 $300 $800 $800 $800 $800 $1,000 $1,000 $1,000 $900 $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 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500
Purchase Other Current Assets $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
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 $17,248 $26,633 $28,180 $30,532 $32,699 $33,997 $38,673 $42,675 $47,231 $52,702 $59,478 $66,096
Net Cash Flow ($3,514) ($10,152) ($8,403) ($6,800) ($4,220) $173 $2,337 $6,542 $11,826 $18,166 $25,562 $35,948
Cash Balance $36,486 $26,334 $17,931 $11,131 $6,911 $7,084 $9,421 $15,963 $27,789 $45,954 $71,517 $107,464
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 $40,000 $36,486 $26,334 $17,931 $11,131 $6,911 $7,084 $9,421 $15,963 $27,789 $45,954 $71,517 $107,464
Other Current Assets $40,000 $40,200 $40,400 $40,600 $40,800 $41,000 $41,200 $41,400 $41,600 $41,800 $42,000 $42,200 $42,400
Total Current Assets $80,000 $76,686 $66,734 $58,531 $51,931 $47,911 $48,284 $50,821 $57,563 $69,589 $87,954 $113,717 $149,864
Long-term Assets
Long-term Assets $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
Accumulated Depreciation $0 $1,400 $2,800 $4,200 $5,600 $7,000 $8,400 $9,800 $11,200 $12,600 $14,000 $15,400 $16,800
Total Long-term Assets $95,000 $93,600 $92,200 $90,800 $89,400 $88,000 $86,600 $85,200 $83,800 $82,400 $81,000 $79,600 $78,200
Total Assets $175,000 $170,286 $158,934 $149,331 $141,331 $135,911 $134,884 $136,021 $141,363 $151,989 $168,954 $193,317 $228,064
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 $9,115 $10,340 $11,805 $13,554 $14,296 $16,804 $19,804 $23,399 $27,705 $33,209 $39,067 $46,502
Current Borrowing $8,000 $7,700 $7,400 $7,100 $6,300 $5,500 $4,700 $3,900 $2,900 $1,900 $900 $0 $0
Other Current Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Current Liabilities $8,000 $16,815 $17,740 $18,905 $19,854 $19,796 $21,504 $23,704 $26,299 $29,605 $34,109 $39,067 $46,502
Long-term Liabilities $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $48,500 $47,000 $45,500 $44,000 $42,500 $41,000
Total Liabilities $58,000 $66,815 $67,740 $68,905 $69,854 $69,796 $71,504 $72,204 $73,299 $75,105 $78,109 $81,567 $87,502
Paid-in Capital $197,000 $197,000 $197,000 $197,000 $197,000 $197,000 $197,000 $197,000 $197,000 $197,000 $197,000 $197,000 $197,000
Retained Earnings ($80,000) ($80,000) ($80,000) ($80,000) ($80,000) ($80,000) ($80,000) ($80,000) ($80,000) ($80,000) ($80,000) ($80,000) ($80,000)
Earnings $0 ($13,530) ($25,806) ($36,575) ($45,523) ($50,885) ($53,620) ($53,183) ($48,936) ($40,117) ($26,155) ($5,250) $23,562
Total Capital $117,000 $103,470 $91,194 $80,425 $71,477 $66,115 $63,380 $63,817 $68,064 $76,883 $90,845 $111,750 $140,562
Total Liabilities and Capital $175,000 $170,286 $158,934 $149,331 $141,331 $135,911 $134,884 $136,021 $141,363 $151,989 $168,954 $193,317 $228,064
Net Worth $117,000 $103,470 $91,194 $80,425 $71,477 $66,115 $63,380 $63,817 $68,064 $76,883 $90,845 $111,750 $140,562