The Nightclub

Start your own business plan »

Nightclub Saloon 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
Beverage Sales 0% $44,600 $77,100 $96,300 $131,700 $152,800 $167,100 $165,700 $155,200 $134,900 $108,500 $76,800 $35,400
Food Sales 0% $4,900 $6,300 $7,100 $7,900 $9,100 $9,900 $10,000 $9,400 $8,700 $7,500 $6,600 $6,100
Admission Sales 0% $34,100 $56,800 $74,600 $76,900 $75,100 $82,900 $88,440 $87,000 $82,400 $74,200 $60,400 $43,900
Total Sales $83,600 $140,200 $178,000 $216,500 $237,000 $259,900 $264,140 $251,600 $226,000 $190,200 $143,800 $85,400
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
Beverage Sales 25% $11,150 $19,275 $24,075 $32,925 $38,200 $41,775 $41,425 $38,800 $33,725 $27,125 $19,200 $8,850
Food Sales 33% $1,617 $2,079 $2,343 $2,607 $3,003 $3,267 $3,300 $3,102 $2,871 $2,475 $2,178 $2,013
Admission Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $12,767 $21,354 $26,418 $35,532 $41,203 $45,042 $44,725 $41,902 $36,596 $29,600 $21,378 $10,863
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
Salaried Staff 0% $23,728 $23,728 $23,728 $23,728 $23,728 $23,728 $23,728 $23,728 $23,728 $23,728 $23,728 $23,728
Hourly Staff 0% $5,100 $8,700 $9,400 $9,500 $9,900 $10,600 $10,900 $10,700 $9,500 $8,500 $7,600 $6,800
Total People 0 0 0 0 0 0 0 0 0 0 0 0
Total Payroll $28,828 $32,428 $33,128 $33,228 $33,628 $34,328 $34,628 $34,428 $33,228 $32,228 $31,328 $30,528
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% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.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 $83,600 $140,200 $178,000 $216,500 $237,000 $259,900 $264,140 $251,600 $226,000 $190,200 $143,800 $85,400
Direct Cost of Sales $12,767 $21,354 $26,418 $35,532 $41,203 $45,042 $44,725 $41,902 $36,596 $29,600 $21,378 $10,863
Other Production Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $12,767 $21,354 $26,418 $35,532 $41,203 $45,042 $44,725 $41,902 $36,596 $29,600 $21,378 $10,863
Gross Margin $70,833 $118,846 $151,582 $180,968 $195,797 $214,858 $219,415 $209,698 $189,404 $160,600 $122,422 $74,537
Gross Margin % 84.73% 84.77% 85.16% 83.59% 82.61% 82.67% 83.07% 83.35% 83.81% 84.44% 85.13% 87.28%
Expenses
Payroll $28,828 $32,428 $33,128 $33,228 $33,628 $34,328 $34,628 $34,428 $33,228 $32,228 $31,328 $30,528
Sales and Marketing and Other Expenses $34,298 $34,298 $34,298 $34,298 $34,298 $34,298 $34,298 $34,298 $34,298 $34,298 $34,298 $34,298
Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Fees--Credit Card $897 $897 $897 $897 $897 $897 $897 $897 $897 $897 $897 $897
Fees--Professional $625 $625 $625 $625 $625 $625 $625 $625 $625 $625 $625 $625
Taxes--Admission $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Taxes--Excise $32,628 $32,628 $32,628 $32,628 $32,628 $32,628 $32,628 $32,628 $32,628 $32,628 $32,628 $32,628
Taxes--Property $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Leased Equipment $208 $208 $208 $208 $208 $208 $208 $208 $208 $208 $208 $208
Utilities $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Insurance $1,875 $1,875 $1,875 $1,875 $1,875 $1,875 $1,875 $1,875 $1,875 $1,875 $1,875 $1,875
Rent $6,250 $6,250 $6,250 $6,250 $6,250 $6,250 $6,250 $6,250 $6,250 $6,250 $6,250 $6,250
Payroll Taxes 17% $4,901 $5,513 $5,632 $5,649 $5,717 $5,836 $5,887 $5,853 $5,649 $5,479 $5,326 $5,190
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $113,510 $117,722 $118,541 $118,658 $119,126 $119,945 $120,296 $120,062 $118,658 $117,488 $116,435 $115,499
Profit Before Interest and Taxes ($42,677) $1,124 $33,041 $62,310 $76,671 $94,913 $99,119 $89,636 $70,746 $43,112 $5,987 ($40,962)
EBITDA ($42,677) $1,124 $33,041 $62,310 $76,671 $94,913 $99,119 $89,636 $70,746 $43,112 $5,987 ($40,962)
Interest Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Taxes Incurred ($12,803) $281 $8,260 $15,578 $19,168 $23,728 $24,780 $22,409 $17,687 $10,778 $1,497 ($10,240)
Net Profit ($29,874) $843 $24,781 $46,733 $57,503 $71,185 $74,339 $67,227 $53,060 $32,334 $4,490 ($30,721)
Net Profit/Sales -35.73% 0.60% 13.92% 21.59% 24.26% 27.39% 28.14% 26.72% 23.48% 17.00% 3.12% -35.97%
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 $75,240 $126,180 $160,200 $194,850 $213,300 $233,910 $237,726 $226,440 $203,400 $171,180 $129,420 $76,860
Cash from Receivables $0 $279 $8,549 $14,146 $17,928 $21,718 $23,776 $26,004 $26,372 $25,075 $22,481 $18,865
Subtotal Cash from Operations $75,240 $126,459 $168,749 $208,996 $231,228 $255,628 $261,502 $252,444 $229,772 $196,255 $151,901 $95,725
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 $75,240 $126,459 $168,749 $208,996 $231,228 $255,628 $261,502 $252,444 $229,772 $196,255 $151,901 $95,725
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 $28,828 $32,428 $33,128 $33,228 $33,628 $34,328 $34,628 $34,428 $33,228 $32,228 $31,328 $30,528
Bill Payments $3,040 $92,029 $116,684 $126,358 $146,749 $152,323 $158,484 $154,558 $146,407 $133,345 $117,309 $98,130
Subtotal Spent on Operations $31,868 $124,457 $149,812 $159,586 $180,377 $186,651 $193,112 $188,986 $179,635 $165,573 $148,637 $128,658
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 $31,868 $124,457 $149,812 $159,586 $180,377 $186,651 $193,112 $188,986 $179,635 $165,573 $148,637 $128,658
Net Cash Flow $43,372 $2,002 $18,937 $49,410 $50,851 $68,977 $68,391 $63,458 $50,137 $30,682 $3,264 ($32,933)
Cash Balance $118,372 $120,374 $139,311 $188,720 $239,571 $308,548 $376,939 $440,397 $490,534 $521,216 $524,480 $491,547
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 $75,000 $118,372 $120,374 $139,311 $188,720 $239,571 $308,548 $376,939 $440,397 $490,534 $521,216 $524,480 $491,547
Accounts Receivable $0 $8,360 $22,101 $31,353 $38,857 $44,628 $48,900 $51,538 $50,694 $46,921 $40,867 $32,766 $22,441
Inventory $7,500 $14,044 $23,489 $29,060 $39,085 $45,323 $49,546 $49,198 $46,092 $40,256 $32,560 $23,516 $12,653
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $82,500 $140,776 $165,965 $199,723 $266,662 $329,523 $406,994 $477,674 $537,183 $577,711 $594,643 $580,762 $526,640
Long-term Assets
Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Accumulated Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Assets $82,500 $140,776 $165,965 $199,723 $266,662 $329,523 $406,994 $477,674 $537,183 $577,711 $594,643 $580,762 $526,640
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 $88,150 $112,495 $121,473 $141,679 $147,036 $153,323 $149,663 $141,945 $129,413 $114,011 $95,639 $72,239
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 $88,150 $112,495 $121,473 $141,679 $147,036 $153,323 $149,663 $141,945 $129,413 $114,011 $95,639 $72,239
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $0 $88,150 $112,495 $121,473 $141,679 $147,036 $153,323 $149,663 $141,945 $129,413 $114,011 $95,639 $72,239
Paid-in Capital $567,750 $567,750 $567,750 $567,750 $567,750 $567,750 $567,750 $567,750 $567,750 $567,750 $567,750 $567,750 $567,750
Retained Earnings ($485,250) ($485,250) ($485,250) ($485,250) ($485,250) ($485,250) ($485,250) ($485,250) ($485,250) ($485,250) ($485,250) ($485,250) ($485,250)
Earnings $0 ($29,874) ($29,031) ($4,250) $42,483 $99,986 $171,171 $245,511 $312,738 $365,798 $398,132 $402,622 $371,901
Total Capital $82,500 $52,626 $53,469 $78,250 $124,983 $182,486 $253,671 $328,011 $395,238 $448,298 $480,632 $485,122 $454,401
Total Liabilities and Capital $82,500 $140,776 $165,965 $199,723 $266,662 $329,523 $406,994 $477,674 $537,183 $577,711 $594,643 $580,762 $526,640
Net Worth $82,500 $52,626 $53,469 $78,250 $124,983 $182,486 $253,671 $328,011 $395,238 $448,298 $480,632 $485,122 $454,401