Sammy's Family Entertainment Center

Start your own business plan »

Miniature Golf Course Business Plan

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