Laser Tag
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 | ||
Unit Sales | |||||||||||||
Lasertag | 0% | 6,400 | 5,319 | 6,054 | 6,693 | 6,134 | 5,194 | 4,837 | 4,962 | 5,815 | 6,535 | 6,715 | 6,876 |
Video Games | 0% | 8,345 | 8,973 | 8,076 | 7,806 | 7,537 | 7,178 | 6,550 | 5,832 | 5,832 | 6,999 | 8,076 | 8,076 |
Makoto | 0% | 1,393 | 1,625 | 1,858 | 1,858 | 1,672 | 1,533 | 1,393 | 1,161 | 1,161 | 1,625 | 1,858 | 2,090 |
Soft Drinks and Snacks | 0% | 656 | 547 | 609 | 662 | 550 | 591 | 537 | 508 | 518 | 590 | 651 | 667 |
Souvenirs | 0% | 5 | 6 | 7 | 8 | 7 | 5 | 3 | 2 | 2 | 3 | 5 | 7 |
Total Unit Sales | 16,799 | 16,470 | 16,604 | 17,027 | 15,900 | 14,501 | 13,320 | 12,465 | 13,328 | 15,752 | 17,305 | 17,716 | |
Unit Prices | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
Lasertag | $5.00 | $5.00 | $5.00 | $5.00 | $5.00 | $5.00 | $5.00 | $5.00 | $5.00 | $5.00 | $5.00 | $5.00 | |
Video Games | $0.50 | $0.50 | $0.50 | $0.50 | $0.50 | $0.50 | $0.50 | $0.50 | $0.50 | $0.50 | $0.50 | $0.50 | |
Makoto | $1.00 | $1.00 | $1.00 | $1.00 | $1.00 | $1.00 | $1.00 | $1.00 | $1.00 | $1.00 | $1.00 | $1.00 | |
Soft Drinks and Snacks | $0.75 | $0.75 | $0.75 | $0.75 | $0.75 | $0.75 | $0.75 | $0.75 | $0.75 | $0.75 | $0.75 | $0.75 | |
Souvenirs | $9.50 | $9.50 | $9.50 | $9.50 | $9.50 | $9.50 | $9.50 | $9.50 | $9.50 | $9.50 | $9.50 | $9.50 | |
Sales | |||||||||||||
Lasertag | $32,000 | $26,595 | $30,270 | $33,465 | $30,670 | $25,970 | $24,185 | $24,810 | $29,075 | $32,675 | $33,575 | $34,380 | |
Video Games | $4,173 | $4,487 | $4,038 | $3,903 | $3,769 | $3,589 | $3,275 | $2,916 | $2,916 | $3,500 | $4,038 | $4,038 | |
Makoto | $1,393 | $1,625 | $1,858 | $1,858 | $1,672 | $1,533 | $1,393 | $1,161 | $1,161 | $1,625 | $1,858 | $2,090 | |
Soft Drinks and Snacks | $492 | $410 | $457 | $497 | $413 | $443 | $403 | $381 | $389 | $443 | $488 | $500 | |
Souvenirs | $48 | $57 | $67 | $76 | $67 | $48 | $29 | $19 | $19 | $29 | $48 | $67 | |
Total Sales | $38,105 | $33,174 | $36,689 | $39,799 | $36,590 | $31,583 | $29,284 | $29,287 | $33,560 | $38,271 | $40,007 | $41,075 | |
Direct Unit Costs | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
Lasertag | 10.00% | $0.50 | $0.50 | $0.50 | $0.50 | $0.50 | $0.50 | $0.50 | $0.50 | $0.50 | $0.50 | $0.50 | $0.50 |
Video Games | 50.00% | $0.25 | $0.25 | $0.25 | $0.25 | $0.25 | $0.25 | $0.25 | $0.25 | $0.25 | $0.25 | $0.25 | $0.25 |
Makoto | 10.00% | $0.10 | $0.10 | $0.10 | $0.10 | $0.10 | $0.10 | $0.10 | $0.10 | $0.10 | $0.10 | $0.10 | $0.10 |
Soft Drinks and Snacks | 50.00% | $0.38 | $0.08 | $0.08 | $0.08 | $0.08 | $0.08 | $0.08 | $0.08 | $0.08 | $0.08 | $0.08 | $0.08 |
Souvenirs | 75.00% | $7.13 | $7.13 | $7.13 | $7.13 | $7.13 | $7.13 | $7.13 | $7.13 | $7.13 | $7.13 | $7.13 | $7.13 |
Direct Cost of Sales | |||||||||||||
Lasertag | $3,200 | $2,660 | $3,027 | $3,347 | $3,067 | $2,597 | $2,419 | $2,481 | $2,908 | $3,268 | $3,358 | $3,438 | |
Video Games | $2,086 | $2,243 | $2,019 | $1,952 | $1,884 | $1,795 | $1,638 | $1,458 | $1,458 | $1,750 | $2,019 | $2,019 | |
Makoto | $139 | $163 | $186 | $186 | $167 | $153 | $139 | $116 | $116 | $163 | $186 | $209 | |
Soft Drinks and Snacks | $246 | $41 | $46 | $50 | $41 | $44 | $40 | $38 | $39 | $44 | $49 | $50 | |
Souvenirs | $36 | $43 | $50 | $57 | $50 | $36 | $21 | $14 | $14 | $21 | $36 | $50 | |
Subtotal Direct Cost of Sales | $5,707 | $5,149 | $5,327 | $5,590 | $5,210 | $4,625 | $4,257 | $4,107 | $4,535 | $5,245 | $5,647 | $5,766 |
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 | ||
General Manager | 50% | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 |
Shift Manager | 0% | $1,443 | $1,443 | $1,443 | $1,443 | $1,443 | $1,443 | $1,443 | $1,443 | $1,443 | $1,443 | $1,443 | $1,443 |
Laser Tag attendants | 6% | $1,920 | $1,596 | $1,816 | $2,008 | $1,840 | $1,558 | $1,451 | $1,489 | $1,745 | $1,961 | $2,015 | $2,063 |
Arcade attendants | 43% | $1,794 | $1,929 | $1,736 | $1,678 | $1,620 | $1,543 | $1,408 | $1,254 | $1,254 | $1,505 | $1,736 | $1,736 |
Total People | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | |
Total Payroll | $6,657 | $6,468 | $6,496 | $6,629 | $6,404 | $6,044 | $5,802 | $5,685 | $5,941 | $6,408 | $6,694 | $6,742 |
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 | $38,105 | $33,174 | $36,689 | $39,799 | $36,590 | $31,583 | $29,284 | $29,287 | $33,560 | $38,271 | $40,007 | $41,075 | |
Direct Cost of Sales | $5,707 | $5,149 | $5,327 | $5,590 | $5,210 | $4,625 | $4,257 | $4,107 | $4,535 | $5,245 | $5,647 | $5,766 | |
Other Costs of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $5,707 | $5,149 | $5,327 | $5,590 | $5,210 | $4,625 | $4,257 | $4,107 | $4,535 | $5,245 | $5,647 | $5,766 | |
Gross Margin | $32,398 | $28,025 | $31,362 | $34,208 | $31,380 | $26,958 | $25,027 | $25,180 | $29,025 | $33,025 | $34,360 | $35,309 | |
Gross Margin % | 85.02% | 84.48% | 85.48% | 85.95% | 85.76% | 85.36% | 85.46% | 85.98% | 86.49% | 86.29% | 85.89% | 85.96% | |
Expenses | |||||||||||||
Payroll | $6,657 | $6,468 | $6,496 | $6,629 | $6,404 | $6,044 | $5,802 | $5,685 | $5,941 | $6,408 | $6,694 | $6,742 | |
Marketing/Promotion | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | |
Depreciation | $490 | $490 | $490 | $490 | $490 | $490 | $490 | $490 | $490 | $490 | $490 | $490 | |
Rent | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 | |
Utilities | $410 | $630 | $630 | $630 | $630 | $630 | $630 | $630 | $630 | $630 | $630 | $630 | |
Insurance | $912 | $912 | $912 | $912 | $912 | $912 | $912 | $912 | $912 | $912 | $912 | $912 | |
Professional Fees | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | |
Telephone | $170 | $170 | $170 | $170 | $170 | $170 | $170 | $170 | $170 | $170 | $170 | $170 | |
Supplies | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | |
Bank & Credit Card Fees | $110 | $110 | $110 | $110 | $110 | $110 | $110 | $110 | $110 | $110 | $110 | $110 | |
New Game Software | 15% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Miscellaneous | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | |
Total Operating Expenses | $19,449 | $19,479 | $19,507 | $19,641 | $19,415 | $19,056 | $18,814 | $18,697 | $18,953 | $19,420 | $19,705 | $19,754 | |
Profit Before Interest and Taxes | $12,949 | $8,545 | $11,855 | $14,567 | $11,965 | $7,902 | $6,213 | $6,482 | $10,072 | $13,605 | $14,655 | $15,555 | |
EBITDA | $13,439 | $9,035 | $12,344 | $15,057 | $12,454 | $8,392 | $6,703 | $6,972 | $10,561 | $14,095 | $15,144 | $16,045 | |
Interest Expense | $768 | $759 | $750 | $741 | $731 | $722 | $713 | $704 | $694 | $685 | $676 | $667 | |
Taxes Incurred | $3,654 | $2,336 | $3,331 | $4,148 | $3,370 | $2,154 | $1,650 | $1,734 | $2,813 | $3,876 | $4,194 | $4,467 | |
Net Profit | $8,526 | $5,450 | $7,773 | $9,679 | $7,863 | $5,026 | $3,850 | $4,045 | $6,564 | $9,044 | $9,785 | $10,422 | |
Net Profit/Sales | 22.38% | 16.43% | 21.19% | 24.32% | 21.49% | 15.91% | 13.15% | 13.81% | 19.56% | 23.63% | 24.46% | 25.37% |
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 | $28,579 | $24,880 | $27,517 | $29,849 | $27,442 | $23,687 | $21,963 | $21,965 | $25,170 | $28,703 | $30,005 | $30,806 | |
Cash from Receivables | $318 | $9,485 | $8,323 | $9,198 | $9,923 | $9,106 | $7,877 | $7,321 | $7,357 | $8,429 | $9,582 | $10,011 | |
Subtotal Cash from Operations | $28,896 | $34,365 | $35,840 | $39,047 | $37,365 | $32,793 | $29,840 | $29,286 | $32,527 | $37,132 | $39,587 | $40,817 | |
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 | $28,896 | $34,365 | $35,840 | $39,047 | $37,365 | $32,793 | $29,840 | $29,286 | $32,527 | $37,132 | $39,587 | $40,817 | |
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 | $6,657 | $6,468 | $6,496 | $6,629 | $6,404 | $6,044 | $5,802 | $5,685 | $5,941 | $6,408 | $6,694 | $6,742 | |
Bill Payments | $843 | $25,125 | $20,538 | $22,057 | $23,083 | $21,579 | $19,705 | $18,959 | $19,052 | $20,841 | $22,702 | $23,247 | |
Subtotal Spent on Operations | $7,500 | $31,593 | $27,034 | $28,686 | $29,487 | $27,623 | $25,507 | $24,645 | $24,993 | $27,250 | $29,396 | $29,989 | |
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 | $1,010 | $1,010 | $1,010 | $1,010 | $1,010 | $1,010 | $1,010 | $1,010 | $1,010 | $1,010 | $1,010 | $1,010 | |
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 | $8,510 | $32,603 | $28,044 | $29,696 | $30,497 | $28,633 | $26,517 | $25,655 | $26,003 | $28,260 | $30,406 | $30,999 | |
Net Cash Flow | $20,386 | $1,762 | $7,796 | $9,351 | $6,868 | $4,159 | $3,323 | $3,632 | $6,524 | $8,872 | $9,181 | $9,818 | |
Cash Balance | $30,386 | $32,148 | $39,944 | $49,295 | $56,164 | $60,323 | $63,646 | $67,277 | $73,801 | $82,674 | $91,855 | $101,672 |
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 | $10,000 | $30,386 | $32,148 | $39,944 | $49,295 | $56,164 | $60,323 | $63,646 | $67,277 | $73,801 | $82,674 | $91,855 | $101,672 |
Accounts Receivable | $0 | $9,209 | $8,017 | $8,867 | $9,618 | $8,842 | $7,632 | $7,077 | $7,078 | $8,110 | $9,249 | $9,668 | $9,926 |
Inventory | $0 | $2,854 | $2,575 | $2,664 | $2,795 | $2,605 | $2,312 | $2,128 | $2,054 | $2,267 | $2,623 | $2,823 | $2,883 |
Other Current Assets | $4,480 | $4,480 | $4,480 | $4,480 | $4,480 | $4,480 | $4,480 | $4,480 | $4,480 | $4,480 | $4,480 | $4,480 | $4,480 |
Total Current Assets | $14,480 | $46,929 | $47,220 | $55,955 | $66,189 | $72,091 | $74,748 | $77,331 | $80,889 | $88,659 | $99,025 | $108,826 | $118,961 |
Long-term Assets | |||||||||||||
Long-term Assets | $47,267 | $47,267 | $47,267 | $47,267 | $47,267 | $47,267 | $47,267 | $47,267 | $47,267 | $47,267 | $47,267 | $47,267 | $47,267 |
Accumulated Depreciation | $0 | $490 | $979 | $1,469 | $1,958 | $2,448 | $2,938 | $3,427 | $3,917 | $4,406 | $4,896 | $5,385 | $5,875 |
Total Long-term Assets | $47,267 | $46,777 | $46,288 | $45,798 | $45,309 | $44,819 | $44,329 | $43,840 | $43,350 | $42,861 | $42,371 | $41,882 | $41,392 |
Total Assets | $61,747 | $93,706 | $93,508 | $101,753 | $111,497 | $116,910 | $119,077 | $121,171 | $124,239 | $131,520 | $141,396 | $150,708 | $160,353 |
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 | $24,443 | $19,804 | $21,286 | $22,362 | $20,921 | $19,073 | $18,326 | $18,359 | $20,085 | $21,928 | $22,464 | $22,698 |
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 | $24,443 | $19,804 | $21,286 | $22,362 | $20,921 | $19,073 | $18,326 | $18,359 | $20,085 | $21,928 | $22,464 | $22,698 |
Long-term Liabilities | $84,844 | $83,834 | $82,824 | $81,814 | $80,804 | $79,794 | $78,784 | $77,774 | $76,764 | $75,754 | $74,744 | $73,734 | $72,724 |
Total Liabilities | $84,844 | $108,277 | $102,628 | $103,100 | $103,166 | $100,715 | $97,857 | $96,100 | $95,123 | $95,839 | $96,672 | $96,198 | $95,422 |
Paid-in Capital | $27,000 | $27,000 | $27,000 | $27,000 | $27,000 | $27,000 | $27,000 | $27,000 | $27,000 | $27,000 | $27,000 | $27,000 | $27,000 |
Retained Earnings | ($50,097) | ($50,097) | ($50,097) | ($50,097) | ($50,097) | ($50,097) | ($50,097) | ($50,097) | ($50,097) | ($50,097) | ($50,097) | ($50,097) | ($50,097) |
Earnings | $0 | $8,526 | $13,977 | $21,750 | $31,429 | $39,292 | $44,318 | $48,168 | $52,213 | $58,777 | $67,821 | $77,606 | $88,028 |
Total Capital | ($23,097) | ($14,571) | ($9,120) | ($1,347) | $8,332 | $16,195 | $21,221 | $25,071 | $29,116 | $35,680 | $44,724 | $54,509 | $64,931 |
Total Liabilities and Capital | $61,747 | $93,706 | $93,508 | $101,753 | $111,497 | $116,910 | $119,077 | $121,171 | $124,239 | $131,520 | $141,396 | $150,708 | $160,353 |
Net Worth | ($23,097) | ($14,571) | ($9,120) | ($1,347) | $8,332 | $16,195 | $21,221 | $25,071 | $29,116 | $35,680 | $44,724 | $54,509 | $64,931 |