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 |
By 
