Sammy's Family Entertainment Center
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 | |||||||||||||
| Miniature Golf | 0% | $1,800 | $9,300 | $36,000 | $37,200 | $37,200 | $18,000 | $13,020 | $8,400 | $5,040 | $0 | $0 | $4,800 |
| Climbing Wall | 0% | $270 | $1,395 | $5,400 | $5,580 | $5,580 | $2,700 | $1,953 | $1,260 | $756 | $0 | $0 | $720 |
| Outside Concessions | 0% | $72 | $372 | $1,440 | $1,488 | $1,488 | $720 | $521 | $336 | $202 | $0 | $0 | $192 |
| Inside Concessions | 0% | $189 | $977 | $3,780 | $3,906 | $3,906 | $1,890 | $1,367 | $882 | $529 | $0 | $0 | $504 |
| Arcade Transactions | 0% | $288 | $1,488 | $5,760 | $5,952 | $5,952 | $2,880 | $2,083 | $1,344 | $806 | $0 | $0 | $768 |
| Fish Feeder | 0% | $27 | $140 | $540 | $558 | $558 | $270 | $195 | $126 | $76 | $0 | $0 | $72 |
| Total Sales | $2,646 | $13,672 | $52,920 | $54,684 | $54,684 | $26,460 | $19,139 | $12,348 | $7,409 | $0 | $0 | $7,056 | |
| 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 | |
| Outside Concessions | $18 | $93 | $360 | $372 | $372 | $180 | $130 | $84 | $50 | $0 | $0 | $48 | |
| Inside Concessions | $66 | $342 | $1,323 | $1,367 | $1,367 | $662 | $478 | $309 | $185 | $0 | $0 | $176 | |
| Arcade Transactions | $144 | $744 | $2,880 | $2,976 | $2,976 | $1,440 | $1,042 | $672 | $403 | $0 | $0 | $384 | |
| Fish Feeder | $5 | $28 | $108 | $112 | $112 | $54 | $39 | $25 | $15 | $0 | $0 | $14 | |
| Subtotal Direct Cost of Sales | $233 | $1,207 | $4,671 | $4,827 | $4,827 | $2,336 | $1,689 | $1,090 | $653 | $0 | $0 | $622 | |
| 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 | ||
| Manager | 0% | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $0 | $0 | $2,500 |
| Asst. Manager | 0% | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $0 | $0 | $1,500 |
| Part time staff (1.5 FTE) | 0% | $700 | $1,500 | $3,000 | $3,000 | $3,000 | $1,500 | $1,000 | $750 | $500 | $0 | $0 | $500 |
| Owners (1 FTE) | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total People | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 0 | 0 | 5 | |
| Total Payroll | $4,700 | $5,500 | $7,000 | $7,000 | $7,000 | $5,500 | $5,000 | $4,750 | $4,500 | $0 | $0 | $4,500 | |
| 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 | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | |
| Long-term Interest Rate | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | |
| Tax Rate | 35.50% | 35.50% | 35.50% | 35.50% | 35.50% | 35.50% | 35.50% | 35.50% | 35.50% | 35.50% | 35.50% | 35.50% | |
| 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 | $2,646 | $13,672 | $52,920 | $54,684 | $54,684 | $26,460 | $19,139 | $12,348 | $7,409 | $0 | $0 | $7,056 | |
| Direct Cost of Sales | $233 | $1,207 | $4,671 | $4,827 | $4,827 | $2,336 | $1,689 | $1,090 | $653 | $0 | $0 | $622 | |
| Other Costs of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Cost of Sales | $233 | $1,207 | $4,671 | $4,827 | $4,827 | $2,336 | $1,689 | $1,090 | $653 | $0 | $0 | $622 | |
| Gross Margin | $2,413 | $12,465 | $48,249 | $49,857 | $49,857 | $24,124 | $17,450 | $11,258 | $6,756 | $0 | $0 | $6,434 | |
| Gross Margin % | 91.19% | 91.17% | 91.17% | 91.17% | 91.17% | 91.17% | 91.18% | 91.17% | 91.19% | 0.00% | 0.00% | 91.18% | |
| Expenses | |||||||||||||
| Payroll | $4,700 | $5,500 | $7,000 | $7,000 | $7,000 | $5,500 | $5,000 | $4,750 | $4,500 | $0 | $0 | $4,500 | |
| Sales and Marketing and Other Expenses | $1,200 | $1,200 | $3,150 | $650 | $650 | $650 | $150 | $150 | $150 | $150 | $150 | $1,000 | |
| Depreciation | $2,720 | $2,720 | $2,720 | $2,720 | $2,720 | $2,720 | $2,720 | $2,720 | $2,720 | $2,720 | $2,720 | $2,720 | |
| Land Lease | $2,750 | $2,750 | $2,750 | $2,750 | $2,750 | $2,750 | $2,750 | $2,750 | $2,750 | $2,750 | $2,750 | $2,750 | |
| Utilities | $1,000 | $1,250 | $1,500 | $1,500 | $1,500 | $1,500 | $1,250 | $1,750 | $2,250 | $150 | $150 | $1,750 | |
| Insurance | $2,500 | $0 | $0 | $2,500 | $0 | $0 | $2,500 | $0 | $0 | $2,500 | $0 | $0 | |
| Payroll Taxes | 12% | $564 | $660 | $840 | $840 | $840 | $660 | $600 | $570 | $540 | $0 | $0 | $540 |
| Acctg & Legal | $500 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $0 | $0 | $250 | |
| Operating Supplies | $26 | $137 | $529 | $547 | $547 | $265 | $191 | $123 | $74 | $0 | $0 | $71 | |
| Telephone | 15% | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 |
| Continuing Education | $0 | $0 | $0 | $0 | $0 | $8,500 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Operating Expenses | $16,110 | $14,617 | $18,889 | $18,907 | $16,407 | $22,945 | $15,561 | $13,213 | $13,384 | $8,420 | $5,920 | $13,731 | |
| Profit Before Interest and Taxes | ($13,697) | ($2,152) | $29,360 | $30,950 | $33,450 | $1,179 | $1,889 | ($1,955) | ($6,628) | ($8,420) | ($5,920) | ($7,297) | |
| EBITDA | ($10,977) | $568 | $32,080 | $33,670 | $36,170 | $3,899 | $4,609 | $765 | ($3,908) | ($5,700) | ($3,200) | ($4,577) | |
| Interest Expense | $3,727 | $3,721 | $3,714 | $3,708 | $3,701 | $3,695 | $3,688 | $3,681 | $3,675 | $3,668 | $3,661 | $3,654 | |
| Taxes Incurred | ($6,186) | ($2,085) | $9,104 | $9,671 | $10,561 | ($893) | ($639) | ($2,001) | ($3,658) | ($4,291) | ($3,401) | ($3,888) | |
| Net Profit | ($11,239) | ($3,788) | $16,541 | $17,571 | $19,188 | ($1,622) | ($1,161) | ($3,636) | ($6,645) | ($7,797) | ($6,180) | ($7,063) | |
| Net Profit/Sales | -424.75% | -27.70% | 31.26% | 32.13% | 35.09% | -6.13% | -6.06% | -29.44% | -89.69% | 0.00% | 0.00% | -100.10% | |
| 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 | $2,646 | $13,672 | $52,920 | $54,684 | $54,684 | $26,460 | $19,139 | $12,348 | $7,409 | $0 | $0 | $7,056 | |
| Subtotal Cash from Operations | $2,646 | $13,672 | $52,920 | $54,684 | $54,684 | $26,460 | $19,139 | $12,348 | $7,409 | $0 | $0 | $7,056 | |
| 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 | $2,646 | $13,672 | $52,920 | $54,684 | $54,684 | $26,460 | $19,139 | $12,348 | $7,409 | $0 | $0 | $7,056 | |
| 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 | $4,700 | $5,500 | $7,000 | $7,000 | $7,000 | $5,500 | $5,000 | $4,750 | $4,500 | $0 | $0 | $4,500 | |
| Bill Payments | $215 | $6,557 | $9,820 | $26,683 | $27,339 | $25,579 | $19,620 | $12,444 | $8,458 | $6,776 | $5,023 | $3,575 | |
| Subtotal Spent on Operations | $4,915 | $12,057 | $16,820 | $33,683 | $34,339 | $31,079 | $24,620 | $17,194 | $12,958 | $6,776 | $5,023 | $8,075 | |
| 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 | $951 | $957 | $963 | $970 | $976 | $983 | $989 | $996 | $1,003 | $1,009 | $1,016 | $1,023 | |
| 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 | $5,866 | $13,014 | $17,784 | $34,653 | $35,315 | $32,062 | $25,609 | $18,190 | $13,960 | $7,785 | $6,039 | $9,097 | |
| Net Cash Flow | ($3,220) | $658 | $35,136 | $20,031 | $19,369 | ($5,602) | ($6,470) | ($5,842) | ($6,551) | ($7,785) | ($6,039) | ($2,041) | |
| Cash Balance | $10,549 | $11,206 | $46,343 | $66,374 | $85,743 | $80,141 | $73,671 | $67,829 | $61,277 | $53,492 | $47,453 | $45,412 | |
| 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 | $13,769 | $10,549 | $11,206 | $46,343 | $66,374 | $85,743 | $80,141 | $73,671 | $67,829 | $61,277 | $53,492 | $47,453 | $45,412 |
| Other Current Assets | $23,230 | $23,230 | $23,230 | $23,230 | $23,230 | $23,230 | $23,230 | $23,230 | $23,230 | $23,230 | $23,230 | $23,230 | $23,230 |
| Total Current Assets | $36,999 | $33,779 | $34,436 | $69,573 | $89,604 | $108,973 | $103,371 | $96,901 | $91,059 | $84,507 | $76,722 | $70,683 | $68,642 |
| Long-term Assets | |||||||||||||
| Long-term Assets | $649,500 | $649,500 | $649,500 | $649,500 | $649,500 | $649,500 | $649,500 | $649,500 | $649,500 | $649,500 | $649,500 | $649,500 | $649,500 |
| Accumulated Depreciation | $0 | $2,720 | $5,440 | $8,160 | $10,880 | $13,600 | $16,320 | $19,040 | $21,760 | $24,480 | $27,200 | $29,920 | $32,640 |
| Total Long-term Assets | $649,500 | $646,780 | $644,060 | $641,340 | $638,620 | $635,900 | $633,180 | $630,460 | $627,740 | $625,020 | $622,300 | $619,580 | $616,860 |
| Total Assets | $686,499 | $680,559 | $678,496 | $710,913 | $728,224 | $744,873 | $736,551 | $727,361 | $718,799 | $709,527 | $699,022 | $690,263 | $685,502 |
| 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 | $6,249 | $8,932 | $25,770 | $26,480 | $24,917 | $19,200 | $12,160 | $8,230 | $6,607 | $4,908 | $3,345 | $6,669 |
| 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 | $6,249 | $8,932 | $25,770 | $26,480 | $24,917 | $19,200 | $12,160 | $8,230 | $6,607 | $4,908 | $3,345 | $6,669 |
| Long-term Liabilities | $560,000 | $559,049 | $558,092 | $557,129 | $556,159 | $555,183 | $554,200 | $553,210 | $552,214 | $551,212 | $550,202 | $549,186 | $548,163 |
| Total Liabilities | $560,000 | $565,299 | $567,024 | $582,899 | $582,638 | $580,099 | $573,400 | $565,371 | $560,444 | $557,818 | $555,110 | $552,531 | $554,833 |
| Paid-in Capital | $140,000 | $140,000 | $140,000 | $140,000 | $140,000 | $140,000 | $140,000 | $140,000 | $140,000 | $140,000 | $140,000 | $140,000 | $140,000 |
| Retained Earnings | ($13,501) | ($13,501) | ($13,501) | ($13,501) | ($13,501) | ($13,501) | ($13,501) | ($13,501) | ($13,501) | ($13,501) | ($13,501) | ($13,501) | ($13,501) |
| Earnings | $0 | ($11,239) | ($15,026) | $1,515 | $19,086 | $38,274 | $36,652 | $35,491 | $31,856 | $25,210 | $17,414 | $11,234 | $4,170 |
| Total Capital | $126,499 | $115,260 | $111,473 | $128,014 | $145,585 | $164,773 | $163,151 | $161,990 | $158,355 | $151,709 | $143,913 | $137,733 | $130,669 |
| Total Liabilities and Capital | $686,499 | $680,559 | $678,496 | $710,913 | $728,224 | $744,873 | $736,551 | $727,361 | $718,799 | $709,527 | $699,022 | $690,263 | $685,502 |
| Net Worth | $126,499 | $115,260 | $111,473 | $128,014 | $145,585 | $164,773 | $163,151 | $161,990 | $158,355 | $151,709 | $143,913 | $137,733 | $130,669 |