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 |