E3 Playhouse
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 | |||||||||||||
Combined Annual Revenue Streams | $0 | $0 | $15,800 | $34,300 | $35,900 | $37,700 | $39,500 | $42,400 | $43,400 | $45,700 | $49,500 | $49,957 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Sales | $0 | $0 | $15,800 | $34,300 | $35,900 | $37,700 | $39,500 | $42,400 | $43,400 | $45,700 | $49,500 | $49,957 | |
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 | |
Combined Annual Revenue Streams | 60% | $0 | $0 | $9,480 | $20,580 | $21,540 | $22,620 | $23,700 | $25,440 | $26,040 | $27,420 | $29,700 | $29,974 |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Direct Cost of Sales | $0 | $0 | $9,480 | $20,580 | $21,540 | $22,620 | $23,700 | $25,440 | $26,040 | $27,420 | $29,700 | $29,974 |
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 | ||
Owner | $0 | $0 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | |
Managers (2) | $0 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | $3,500 | |
Full-time staff (4) | $0 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | |
Temp staff | $0 | $0 | $0 | $0 | $0 | $0 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | |
Total People | 0 | 7 | 7 | 7 | 7 | 7 | 8 | 8 | 8 | 8 | 8 | 8 | |
Total Payroll | $0 | $8,000 | $11,000 | $11,000 | $11,000 | $11,000 | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 |
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 | $15,800 | $34,300 | $35,900 | $37,700 | $39,500 | $42,400 | $43,400 | $45,700 | $49,500 | $49,957 | |
Direct Cost of Sales | $0 | $0 | $9,480 | $20,580 | $21,540 | $22,620 | $23,700 | $25,440 | $26,040 | $27,420 | $29,700 | $29,974 | |
Other Costs of Goods | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $0 | $0 | $9,480 | $20,580 | $21,540 | $22,620 | $23,700 | $25,440 | $26,040 | $27,420 | $29,700 | $29,974 | |
Gross Margin | $0 | $0 | $6,320 | $13,720 | $14,360 | $15,080 | $15,800 | $16,960 | $17,360 | $18,280 | $19,800 | $19,983 | |
Gross Margin % | 0.00% | 0.00% | 40.00% | 40.00% | 40.00% | 40.00% | 40.00% | 40.00% | 40.00% | 40.00% | 40.00% | 40.00% | |
Expenses | |||||||||||||
Payroll | $0 | $8,000 | $11,000 | $11,000 | $11,000 | $11,000 | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 | |
Sales & Marketing and Other Expenses | $2,126 | $2,126 | $2,126 | $2,126 | $2,126 | $2,126 | $2,126 | $2,126 | $2,126 | $2,126 | $2,126 | $2,126 | |
Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Building Build-Out ($20,000) | $10,000 | $10,000 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Lights, Audio, Bumper | $10,000 | $10,000 | $10,000 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Permits & Licenses (Beer & Wine) | $5,000 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Rent | $12,000 | $0 | $3,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | |
Utilities | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | |
Legal and Accounting | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | |
Consulting | $500 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Insurance | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | |
Payroll Taxes & Employee Benefits | 7% | $149 | $149 | $149 | $149 | $149 | $149 | $149 | $149 | $149 | $149 | $149 | $149 |
General and Adminstrative Expenses | 15% | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 | $750 |
Other | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | |
Total Operating Expenses | $42,775 | $33,275 | $29,275 | $22,275 | $22,275 | $22,275 | $23,275 | $23,275 | $23,275 | $23,275 | $23,275 | $23,275 | |
Profit Before Interest and Taxes | ($42,775) | ($33,275) | ($22,955) | ($8,555) | ($7,915) | ($7,195) | ($7,475) | ($6,315) | ($5,915) | ($4,995) | ($3,475) | ($3,292) | |
EBITDA | ($42,775) | ($33,275) | ($22,955) | ($8,555) | ($7,915) | ($7,195) | ($7,475) | ($6,315) | ($5,915) | ($4,995) | ($3,475) | ($3,292) | |
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 | ($42,775) | ($33,275) | ($22,955) | ($8,555) | ($7,915) | ($7,195) | ($7,475) | ($6,315) | ($5,915) | ($4,995) | ($3,475) | ($3,292) | |
Net Profit/Sales | 0.00% | 0.00% | -145.28% | -24.94% | -22.05% | -19.08% | -18.92% | -14.89% | -13.63% | -10.93% | -7.02% | -6.59% |
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 | $15,800 | $34,300 | $35,900 | $37,700 | $39,500 | $42,400 | $43,400 | $45,700 | $49,500 | $49,957 | |
Subtotal Cash from Operations | $0 | $0 | $15,800 | $34,300 | $35,900 | $37,700 | $39,500 | $42,400 | $43,400 | $45,700 | $49,500 | $49,957 | |
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 | $150,000 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Cash Received | $150,000 | $0 | $15,800 | $34,300 | $35,900 | $37,700 | $39,500 | $42,400 | $43,400 | $45,700 | $49,500 | $49,957 | |
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 | $0 | $8,000 | $11,000 | $11,000 | $11,000 | $11,000 | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 | $12,000 | |
Bill Payments | $1,426 | $42,192 | $25,437 | $30,275 | $34,577 | $33,092 | $34,201 | $35,308 | $37,160 | $37,517 | $39,123 | $41,537 | |
Subtotal Spent on Operations | $1,426 | $50,192 | $36,437 | $41,275 | $45,577 | $44,092 | $46,201 | $47,308 | $49,160 | $49,517 | $51,123 | $53,537 | |
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 | $1,426 | $50,192 | $36,437 | $41,275 | $45,577 | $44,092 | $46,201 | $47,308 | $49,160 | $49,517 | $51,123 | $53,537 | |
Net Cash Flow | $148,574 | ($50,192) | ($20,637) | ($6,975) | ($9,677) | ($6,392) | ($6,701) | ($4,908) | ($5,760) | ($3,817) | ($1,623) | ($3,580) | |
Cash Balance | $149,574 | $99,383 | $78,746 | $71,771 | $62,093 | $55,701 | $49,000 | $44,092 | $38,331 | $34,514 | $32,890 | $29,310 |
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 | $1,000 | $149,574 | $99,383 | $78,746 | $71,771 | $62,093 | $55,701 | $49,000 | $44,092 | $38,331 | $34,514 | $32,890 | $29,310 |
Inventory | $0 | $0 | $0 | $2,370 | $5,145 | $5,385 | $5,655 | $5,925 | $6,360 | $6,510 | $6,855 | $7,425 | $7,494 |
Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Current Assets | $1,000 | $149,574 | $99,383 | $81,116 | $76,916 | $67,478 | $61,356 | $54,925 | $50,452 | $44,841 | $41,369 | $40,315 | $36,804 |
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 | $1,000 | $149,574 | $99,383 | $81,116 | $76,916 | $67,478 | $61,356 | $54,925 | $50,452 | $44,841 | $41,369 | $40,315 | $36,804 |
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 | $41,349 | $24,432 | $29,121 | $33,476 | $31,953 | $33,026 | $34,070 | $35,912 | $36,216 | $37,739 | $40,160 | $39,940 |
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 | $41,349 | $24,432 | $29,121 | $33,476 | $31,953 | $33,026 | $34,070 | $35,912 | $36,216 | $37,739 | $40,160 | $39,940 |
Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Liabilities | $0 | $41,349 | $24,432 | $29,121 | $33,476 | $31,953 | $33,026 | $34,070 | $35,912 | $36,216 | $37,739 | $40,160 | $39,940 |
Paid-in Capital | $40,260 | $190,260 | $190,260 | $190,260 | $190,260 | $190,260 | $190,260 | $190,260 | $190,260 | $190,260 | $190,260 | $190,260 | $190,260 |
Retained Earnings | ($39,260) | ($39,260) | ($39,260) | ($39,260) | ($39,260) | ($39,260) | ($39,260) | ($39,260) | ($39,260) | ($39,260) | ($39,260) | ($39,260) | ($39,260) |
Earnings | $0 | ($42,775) | ($76,050) | ($99,005) | ($107,560) | ($115,475) | ($122,670) | ($130,145) | ($136,460) | ($142,375) | ($147,370) | ($150,845) | ($154,137) |
Total Capital | $1,000 | $108,225 | $74,950 | $51,995 | $43,440 | $35,525 | $28,330 | $20,855 | $14,540 | $8,625 | $3,630 | $155 | ($3,137) |
Total Liabilities and Capital | $1,000 | $149,574 | $99,383 | $81,116 | $76,916 | $67,478 | $61,356 | $54,925 | $50,452 | $44,841 | $41,369 | $40,315 | $36,804 |
Net Worth | $1,000 | $108,225 | $74,950 | $51,995 | $43,440 | $35,525 | $28,330 | $20,855 | $14,540 | $8,625 | $3,630 | $155 | ($3,137) |