Cabin Fever

Start your own business plan »

Children's Recreation Center 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
Child Admission 0% $8,550 $9,894 $10,986 $12,456 $13,296 $12,944 $11,532 $9,908 $9,740 $9,880 $7,962 $8,074
Additional Parent Spending 0% $2,160 $2,711 $3,244 $3,574 $3,840 $3,498 $2,442 $2,410 $2,646 $2,659 $1,962 $2,026
Total Sales $10,710 $12,605 $14,230 $16,030 $17,136 $16,442 $13,974 $12,318 $12,386 $12,539 $9,924 $10,100
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
Child Admission $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Additional Parent Spending $432 $542 $649 $715 $768 $700 $488 $482 $529 $532 $392 $405
Subtotal Direct Cost of Sales $432 $542 $649 $715 $768 $700 $488 $482 $529 $532 $392 $405
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
Owner/Manager 0% $0 $0 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
FT Employee 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
PT Employee 0% $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600
PT Employee 0% $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 4 4 4 4 4 4 4 4 4 4 4 4
Total Payroll $3,200 $3,200 $5,200 $5,200 $5,200 $5,200 $5,200 $5,200 $5,200 $5,200 $5,200 $5,200
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 $10,710 $12,605 $14,230 $16,030 $17,136 $16,442 $13,974 $12,318 $12,386 $12,539 $9,924 $10,100
Direct Cost of Sales $432 $542 $649 $715 $768 $700 $488 $482 $529 $532 $392 $405
Other Costs of Goods $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $432 $542 $649 $715 $768 $700 $488 $482 $529 $532 $392 $405
Gross Margin $10,278 $12,063 $13,581 $15,315 $16,368 $15,742 $13,485 $11,836 $11,857 $12,007 $9,531 $9,694
Gross Margin % 95.97% 95.70% 95.44% 95.54% 95.52% 95.75% 96.51% 96.09% 95.73% 95.76% 96.05% 95.99%
Expenses
Payroll $3,200 $3,200 $5,200 $5,200 $5,200 $5,200 $5,200 $5,200 $5,200 $5,200 $5,200 $5,200
Marketing/Promotion 8% $857 $1,008 $1,138 $1,282 $1,370 $1,315 $1,118 $985 $990 $1,003 $794 $808
Depreciation $580 $580 $580 $580 $580 $580 $580 $580 $580 $580 $580 $580
Rent $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Utilities / Phone / Internet $640 $640 $640 $640 $640 $640 $640 $640 $640 $640 $640 $640
Insurance $1,200 $0 $0 $1,200 $0 $0 $1,200 $0 $0 $1,200 $0 $0
Payroll Taxes 15% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
CPA $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250
Website hosting 15% $0 $0 $25 $25 $25 $25 $25 $25 $25 $25 $25 $25
Office Expenses $125 $125 $125 $125 $125 $125 $125 $125 $125 $125 $125 $125
Total Operating Expenses $7,852 $6,803 $8,958 $10,302 $9,190 $9,135 $10,138 $8,805 $8,810 $10,023 $8,614 $8,628
Profit Before Interest and Taxes $2,426 $5,260 $4,623 $5,013 $7,178 $6,607 $3,347 $3,031 $3,047 $1,984 $917 $1,066
EBITDA $3,006 $5,840 $5,203 $5,593 $7,758 $7,187 $3,927 $3,611 $3,627 $2,564 $1,497 $1,646
Interest Expense $628 $622 $615 $608 $602 $595 $589 $582 $576 $569 $563 $556
Taxes Incurred $539 $1,392 $1,202 $1,321 $1,973 $1,804 $828 $735 $741 $425 $106 $153
Net Profit $1,259 $3,247 $2,805 $3,083 $4,603 $4,208 $1,931 $1,714 $1,730 $991 $248 $357
Net Profit/Sales 11.75% 25.76% 19.72% 19.23% 26.86% 25.59% 13.82% 13.91% 13.97% 7.90% 2.50% 3.54%
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 $10,710 $12,605 $14,230 $16,030 $17,136 $16,442 $13,974 $12,318 $12,386 $12,539 $9,924 $10,100
Subtotal Cash from Operations $10,710 $12,605 $14,230 $16,030 $17,136 $16,442 $13,974 $12,318 $12,386 $12,539 $9,924 $10,100
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 $10,710 $12,605 $14,230 $16,030 $17,136 $16,442 $13,974 $12,318 $12,386 $12,539 $9,924 $10,100
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 $3,200 $3,200 $5,200 $5,200 $5,200 $5,200 $5,200 $5,200 $5,200 $5,200 $5,200 $5,200
Bill Payments $189 $5,668 $5,581 $5,695 $7,153 $6,743 $6,447 $6,215 $4,825 $4,906 $5,706 $3,898
Subtotal Spent on Operations $3,389 $8,868 $10,781 $10,895 $12,353 $11,943 $11,647 $11,415 $10,025 $10,106 $10,906 $9,098
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 $222 $222 $222 $222 $222 $222 $222 $222 $222 $222 $222 $223
Other Liabilities Principal Repayment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Long-term Liabilities Principal Repayment $900 $900 $900 $900 $900 $900 $900 $900 $900 $900 $900 $900
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 $4,511 $9,990 $11,903 $12,017 $13,475 $13,065 $12,769 $12,537 $11,147 $11,228 $12,028 $10,221
Net Cash Flow $6,199 $2,615 $2,327 $4,013 $3,661 $3,377 $1,205 ($219) $1,239 $1,311 ($2,105) ($121)
Cash Balance $14,199 $16,814 $19,141 $23,154 $26,815 $30,192 $31,396 $31,177 $32,416 $33,727 $31,622 $31,501
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 $8,000 $14,199 $16,814 $19,141 $23,154 $26,815 $30,192 $31,396 $31,177 $32,416 $33,727 $31,622 $31,501
Other Current Assets $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000
Total Current Assets $33,000 $39,199 $41,814 $44,141 $48,154 $51,815 $55,192 $56,396 $56,177 $57,416 $58,727 $56,622 $56,501
Long-term Assets
Long-term Assets $90,000 $90,000 $90,000 $90,000 $90,000 $90,000 $90,000 $90,000 $90,000 $90,000 $90,000 $90,000 $90,000
Accumulated Depreciation $0 $580 $1,160 $1,740 $2,320 $2,900 $3,480 $4,060 $4,640 $5,220 $5,800 $6,380 $6,960
Total Long-term Assets $90,000 $89,420 $88,840 $88,260 $87,680 $87,100 $86,520 $85,940 $85,360 $84,780 $84,200 $83,620 $83,040
Total Assets $123,000 $128,619 $130,654 $132,401 $135,834 $138,915 $141,712 $142,336 $141,537 $142,196 $142,927 $140,242 $139,541
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 $5,482 $5,392 $5,456 $6,928 $6,528 $6,238 $6,054 $4,663 $4,714 $5,576 $3,766 $3,830
Current Borrowing $8,000 $7,778 $7,556 $7,334 $7,112 $6,890 $6,668 $6,446 $6,224 $6,002 $5,780 $5,558 $5,335
Other Current Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Current Liabilities $8,000 $13,260 $12,948 $12,790 $14,040 $13,418 $12,906 $12,500 $10,887 $10,716 $11,356 $9,324 $9,165
Long-term Liabilities $100,800 $99,900 $99,000 $98,100 $97,200 $96,300 $95,400 $94,500 $93,600 $92,700 $91,800 $90,900 $90,000
Total Liabilities $108,800 $113,160 $111,948 $110,890 $111,240 $109,718 $108,306 $107,000 $104,487 $103,416 $103,156 $100,224 $99,165
Paid-in Capital $32,000 $32,000 $32,000 $32,000 $32,000 $32,000 $32,000 $32,000 $32,000 $32,000 $32,000 $32,000 $32,000
Retained Earnings ($17,800) ($17,800) ($17,800) ($17,800) ($17,800) ($17,800) ($17,800) ($17,800) ($17,800) ($17,800) ($17,800) ($17,800) ($17,800)
Earnings $0 $1,259 $4,505 $7,311 $10,394 $14,997 $19,205 $21,136 $22,850 $24,580 $25,571 $25,819 $26,176
Total Capital $14,200 $15,459 $18,705 $21,511 $24,594 $29,197 $33,405 $35,336 $37,050 $38,780 $39,771 $40,019 $40,376
Total Liabilities and Capital $123,000 $128,619 $130,654 $132,401 $135,834 $138,915 $141,712 $142,336 $141,537 $142,196 $142,927 $140,242 $139,541
Net Worth $14,200 $15,459 $18,705 $21,511 $24,594 $29,197 $33,405 $35,336 $37,050 $38,780 $39,771 $40,019 $40,376