Foosball Hall
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 | |||||||||||||
Alcohol | 0% | $2,511 | $2,787 | $3,254 | $4,587 | $4,354 | $5,656 | $3,877 | $6,141 | $8,454 | $8,654 | $9,848 | $7,414 |
Soft drinks | 0% | $1,356 | $1,505 | $1,757 | $2,477 | $2,351 | $3,054 | $2,094 | $3,316 | $4,565 | $4,673 | $5,318 | $4,004 |
Food | 0% | $1,180 | $1,310 | $1,529 | $2,156 | $2,046 | $2,658 | $1,822 | $2,886 | $3,973 | $4,067 | $4,629 | $3,485 |
Table fees | 0% | $477 | $530 | $618 | $872 | $827 | $1,075 | $737 | $1,167 | $1,606 | $1,644 | $1,871 | $1,409 |
Total Sales | $5,524 | $6,131 | $7,159 | $10,091 | $9,579 | $12,443 | $8,529 | $13,510 | $18,599 | $19,039 | $21,666 | $16,311 | |
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 | |
Alcohol | $628 | $697 | $814 | $1,147 | $1,089 | $1,414 | $969 | $1,535 | $2,114 | $2,164 | $2,462 | $1,854 | |
Soft drinks | $339 | $376 | $439 | $619 | $588 | $764 | $523 | $829 | $241 | $247 | $281 | $211 | |
Food | $389 | $432 | $505 | $711 | $675 | $877 | $601 | $952 | $1,311 | $1,342 | $1,527 | $1,150 | |
Table fees | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Direct Cost of Sales | $1,356 | $1,505 | $1,757 | $2,477 | $2,352 | $3,055 | $2,094 | $3,317 | $3,666 | $3,752 | $4,270 | $3,215 |
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 | ||
Stan | 0% | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 |
Bartenders | 0% | $0 | $0 | $1,500 | $1,500 | $1,700 | $1,700 | $1,900 | $1,900 | $1,900 | $1,900 | $1,900 | $1,900 |
Bartender assistants | 0% | $0 | $0 | $1,200 | $1,200 | $1,400 | $1,400 | $1,550 | $1,550 | $1,550 | $1,550 | $1,550 | $1,550 |
Bookkeeper | 0% | $0 | $0 | $0 | $0 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 |
Total People | 1 | 1 | 6 | 6 | 6 | 7 | 8 | 8 | 8 | 8 | 8 | 8 | |
Total Payroll | $2,000 | $2,000 | $4,700 | $4,700 | $6,000 | $6,000 | $6,350 | $6,350 | $6,350 | $6,350 | $6,350 | $6,350 |
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% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.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 | $5,524 | $6,131 | $7,159 | $10,091 | $9,579 | $12,443 | $8,529 | $13,510 | $18,599 | $19,039 | $21,666 | $16,311 | |
Direct Cost of Sales | $1,356 | $1,505 | $1,757 | $2,477 | $2,352 | $3,055 | $2,094 | $3,317 | $3,666 | $3,752 | $4,270 | $3,215 | |
Other Costs of Goods | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $1,356 | $1,505 | $1,757 | $2,477 | $2,352 | $3,055 | $2,094 | $3,317 | $3,666 | $3,752 | $4,270 | $3,215 | |
Gross Margin | $4,168 | $4,626 | $5,401 | $7,614 | $7,227 | $9,388 | $6,435 | $10,193 | $14,933 | $15,286 | $17,396 | $13,096 | |
Gross Margin % | 75.45% | 75.45% | 75.45% | 75.45% | 75.45% | 75.45% | 75.45% | 75.45% | 80.29% | 80.29% | 80.29% | 80.29% | |
Expenses | |||||||||||||
Payroll | $2,000 | $2,000 | $4,700 | $4,700 | $6,000 | $6,000 | $6,350 | $6,350 | $6,350 | $6,350 | $6,350 | $6,350 | |
Sales and Marketing and Other Expenses | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | |
Depreciation | $666 | $666 | $666 | $666 | $666 | $666 | $666 | $666 | $666 | $666 | $666 | $666 | |
Rent | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | |
Utilities | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | |
Insurance | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | |
Payroll Taxes | 15% | $300 | $300 | $705 | $705 | $900 | $900 | $953 | $953 | $953 | $953 | $953 | $953 |
Other | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | |
Total Operating Expenses | $6,216 | $6,216 | $9,321 | $9,321 | $10,816 | $10,816 | $11,219 | $11,219 | $11,219 | $11,219 | $11,219 | $11,219 | |
Profit Before Interest and Taxes | ($2,048) | ($1,590) | ($3,920) | ($1,707) | ($3,589) | ($1,428) | ($4,783) | ($1,025) | $3,715 | $4,068 | $6,177 | $1,878 | |
EBITDA | ($1,382) | ($924) | ($3,254) | ($1,041) | ($2,923) | ($762) | ($4,117) | ($359) | $4,381 | $4,734 | $6,843 | $2,544 | |
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 | ($2,048) | ($1,590) | ($3,920) | ($1,707) | ($3,589) | ($1,428) | ($4,783) | ($1,025) | $3,715 | $4,068 | $6,177 | $1,878 | |
Net Profit/Sales | -37.07% | -25.93% | -54.75% | -16.92% | -37.47% | -11.47% | -56.08% | -7.59% | 19.97% | 21.37% | 28.51% | 11.51% |
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 | $5,524 | $6,131 | $7,159 | $10,091 | $9,579 | $12,443 | $8,529 | $13,510 | $18,599 | $19,039 | $21,666 | $16,311 | |
Subtotal Cash from Operations | $5,524 | $6,131 | $7,159 | $10,091 | $9,579 | $12,443 | $8,529 | $13,510 | $18,599 | $19,039 | $21,666 | $16,311 | |
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 | $5,524 | $6,131 | $7,159 | $10,091 | $9,579 | $12,443 | $8,529 | $13,510 | $18,599 | $19,039 | $21,666 | $16,311 | |
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 | $2,000 | $2,000 | $4,700 | $4,700 | $6,000 | $6,000 | $6,350 | $6,350 | $6,350 | $6,350 | $6,350 | $6,350 | |
Bill Payments | $164 | $4,911 | $5,077 | $5,736 | $6,435 | $6,525 | $7,175 | $6,337 | $7,531 | $7,871 | $7,972 | $8,437 | |
Subtotal Spent on Operations | $2,164 | $6,911 | $9,777 | $10,436 | $12,435 | $12,525 | $13,525 | $12,687 | $13,881 | $14,221 | $14,322 | $14,787 | |
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 | $2,164 | $6,911 | $9,777 | $10,436 | $12,435 | $12,525 | $13,525 | $12,687 | $13,881 | $14,221 | $14,322 | $14,787 | |
Net Cash Flow | $3,361 | ($780) | ($2,618) | ($345) | ($2,856) | ($82) | ($4,995) | $823 | $4,718 | $4,818 | $7,343 | $1,523 | |
Cash Balance | $47,661 | $46,881 | $44,263 | $43,917 | $41,062 | $40,980 | $35,985 | $36,808 | $41,525 | $46,343 | $53,687 | $55,210 |
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 | $44,300 | $47,661 | $46,881 | $44,263 | $43,917 | $41,062 | $40,980 | $35,985 | $36,808 | $41,525 | $46,343 | $53,687 | $55,210 |
Other Current Assets | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 |
Total Current Assets | $47,300 | $50,661 | $49,881 | $47,263 | $46,917 | $44,062 | $43,980 | $38,985 | $39,808 | $44,525 | $49,343 | $56,687 | $58,210 |
Long-term Assets | |||||||||||||
Long-term Assets | $40,000 | $40,000 | $40,000 | $40,000 | $40,000 | $40,000 | $40,000 | $40,000 | $40,000 | $40,000 | $40,000 | $40,000 | $40,000 |
Accumulated Depreciation | $0 | $666 | $1,332 | $1,998 | $2,664 | $3,330 | $3,996 | $4,662 | $5,328 | $5,994 | $6,660 | $7,326 | $7,992 |
Total Long-term Assets | $40,000 | $39,334 | $38,668 | $38,002 | $37,336 | $36,670 | $36,004 | $35,338 | $34,672 | $34,006 | $33,340 | $32,674 | $32,008 |
Total Assets | $87,300 | $89,995 | $88,549 | $85,265 | $84,253 | $80,732 | $79,984 | $74,323 | $74,480 | $78,531 | $82,683 | $89,361 | $90,218 |
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 | $4,743 | $4,887 | $5,522 | $6,218 | $6,285 | $6,965 | $6,087 | $7,269 | $7,606 | $7,690 | $8,190 | $7,170 |
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 | $4,743 | $4,887 | $5,522 | $6,218 | $6,285 | $6,965 | $6,087 | $7,269 | $7,606 | $7,690 | $8,190 | $7,170 |
Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Liabilities | $0 | $4,743 | $4,887 | $5,522 | $6,218 | $6,285 | $6,965 | $6,087 | $7,269 | $7,606 | $7,690 | $8,190 | $7,170 |
Paid-in Capital | $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 |
Retained Earnings | ($7,700) | ($7,700) | ($7,700) | ($7,700) | ($7,700) | ($7,700) | ($7,700) | ($7,700) | ($7,700) | ($7,700) | ($7,700) | ($7,700) | ($7,700) |
Earnings | $0 | ($2,048) | ($3,638) | ($7,558) | ($9,265) | ($12,853) | ($14,281) | ($19,064) | ($20,089) | ($16,374) | ($12,307) | ($6,130) | ($4,252) |
Total Capital | $87,300 | $85,252 | $83,662 | $79,742 | $78,035 | $74,447 | $73,019 | $68,236 | $67,211 | $70,926 | $74,993 | $81,170 | $83,048 |
Total Liabilities and Capital | $87,300 | $89,995 | $88,549 | $85,265 | $84,253 | $80,732 | $79,984 | $74,323 | $74,480 | $78,531 | $82,683 | $89,361 | $90,218 |
Net Worth | $87,300 | $85,252 | $83,662 | $79,742 | $78,035 | $74,447 | $73,019 | $68,236 | $67,211 | $70,926 | $74,993 | $81,170 | $83,048 |