The Nightclub
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 |