Kid's Community College

Start your own business plan »

Child Day Care Services 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
Unit Sales
Full-time Couples 0% 6 8 10 12 12 10 10 20 27 27 27 30
After School Care 0% 6 6 6 6 6 8 8 15 20 20 20 20
Summer Camp 0% 0 0 0 0 0 13 13 0 0 0 0 0
Part-time Workers/Drop-Ins 0% 1 1 1 1 1 1 1 1 1 1 1 1
Total Unit Sales 13 15 17 19 19 32 32 36 48 48 48 51
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
Full-time Couples $460.00 $460.00 $460.00 $460.00 $460.00 $460.00 $460.00 $460.00 $460.00 $460.00 $460.00 $460.00
After School Care $240.00 $240.00 $240.00 $240.00 $240.00 $240.00 $240.00 $240.00 $240.00 $240.00 $240.00 $240.00
Summer Camp $460.00 $460.00 $460.00 $460.00 $460.00 $460.00 $460.00 $460.00 $460.00 $460.00 $460.00 $460.00
Part-time Workers/Drop-Ins $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00
Sales
Full-time Couples $2,760 $3,680 $4,600 $5,520 $5,520 $4,600 $4,600 $9,200 $12,420 $12,420 $12,420 $13,800
After School Care $1,440 $1,440 $1,440 $1,440 $1,440 $1,920 $1,920 $3,600 $4,800 $4,800 $4,800 $4,800
Summer Camp $0 $0 $0 $0 $0 $5,980 $5,980 $0 $0 $0 $0 $0
Part-time Workers/Drop-Ins $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
Total Sales $4,300 $5,220 $6,140 $7,060 $7,060 $12,600 $12,600 $12,900 $17,320 $17,320 $17,320 $18,700
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
Full-time Couples 2.90% $13.34 $13.34 $13.34 $13.34 $13.34 $13.34 $13.34 $13.34 $13.34 $13.34 $13.34 $13.34
After School Care 1.90% $4.56 $4.56 $4.56 $4.56 $4.56 $4.56 $4.56 $4.56 $4.56 $4.56 $4.56 $4.56
Summer Camp 3.00% $13.80 $13.80 $13.80 $13.80 $13.80 $13.80 $13.80 $13.80 $13.80 $13.80 $13.80 $13.80
Part-time Workers/Drop-Ins 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Direct Cost of Sales
Full-time Couples $80 $107 $133 $160 $160 $133 $133 $267 $360 $360 $360 $400
After School Care $27 $27 $27 $27 $27 $36 $36 $68 $91 $91 $91 $91
Summer Camp $0 $0 $0 $0 $0 $179 $179 $0 $0 $0 $0 $0
Part-time Workers/Drop-Ins $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $107 $134 $161 $187 $187 $349 $349 $335 $451 $451 $451 $491
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
Campus Director 0% $1,833 $1,833 $1,833 $2,042 $2,042 $2,042 $2,042 $2,042 $2,042 $2,042 $2,042 $2,042
F/T Instructors 0% $1,280 $1,280 $1,280 $1,280 $1,280 $1,280 $1,280 $2,560 $2,560 $2,560 $2,560 $2,560
P/T Instructors 0% $600 $600 $600 $600 $600 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200
Total People 3 3 3 3 3 4 4 5 5 5 5 5
Total Payroll $3,713 $3,713 $3,713 $3,922 $3,922 $4,522 $4,522 $5,802 $5,802 $5,802 $5,802 $5,802
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 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00%
Long-term Interest Rate 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00%
Tax Rate 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00% 30.00%
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 $4,300 $5,220 $6,140 $7,060 $7,060 $12,600 $12,600 $12,900 $17,320 $17,320 $17,320 $18,700
Direct Cost of Sales $107 $134 $161 $187 $187 $349 $349 $335 $451 $451 $451 $491
Hidden Row $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $107 $134 $161 $187 $187 $349 $349 $335 $451 $451 $451 $491
Gross Margin $4,193 $5,086 $5,979 $6,873 $6,873 $12,251 $12,251 $12,565 $16,869 $16,869 $16,869 $18,209
Gross Margin % 97.50% 97.43% 97.38% 97.35% 97.35% 97.23% 97.23% 97.40% 97.39% 97.39% 97.39% 97.37%
Expenses
Payroll $3,713 $3,713 $3,713 $3,922 $3,922 $4,522 $4,522 $5,802 $5,802 $5,802 $5,802 $5,802
Sales and Marketing and Other Expenses $0 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Rent $4,900 $4,900 $4,900 $4,900 $4,900 $4,900 $4,900 $4,900 $4,900 $4,900 $4,900 $4,900
Utilities $875 $875 $875 $875 $875 $875 $875 $875 $875 $875 $875 $875
Insurance $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600
Payroll Taxes 15% $557 $557 $557 $588 $588 $678 $678 $870 $870 $870 $870 $870
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $10,645 $10,845 $10,845 $11,085 $11,085 $11,775 $11,775 $13,247 $13,247 $13,247 $13,247 $13,247
Profit Before Interest and Taxes ($6,452) ($5,759) ($4,866) ($4,213) ($4,213) $475 $475 ($683) $3,621 $3,621 $3,621 $4,961
EBITDA ($6,452) ($5,759) ($4,866) ($4,213) ($4,213) $475 $475 ($683) $3,621 $3,621 $3,621 $4,961
Interest Expense $345 $340 $335 $330 $326 $321 $316 $311 $306 $301 $296 $291
Taxes Incurred $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit ($6,797) ($6,099) ($5,201) ($4,543) ($4,538) $155 $160 ($993) $3,315 $3,320 $3,325 $4,670
Net Profit/Sales -158.08% -116.84% -84.71% -64.35% -64.28% 1.23% 1.27% -7.70% 19.14% 19.17% 19.20% 24.97%
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 $4,300 $5,220 $6,140 $7,060 $7,060 $12,600 $12,600 $12,900 $17,320 $17,320 $17,320 $18,700
Subtotal Cash from Operations $4,300 $5,220 $6,140 $7,060 $7,060 $12,600 $12,600 $12,900 $17,320 $17,320 $17,320 $18,700
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 $4,300 $5,220 $6,140 $7,060 $7,060 $12,600 $12,600 $12,900 $17,320 $17,320 $17,320 $18,700
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,713 $3,713 $3,713 $3,922 $3,922 $4,522 $4,522 $5,802 $5,802 $5,802 $5,802 $5,802
Bill Payments $246 $7,392 $7,607 $7,630 $7,681 $7,685 $7,923 $7,924 $8,095 $8,203 $8,198 $8,194
Subtotal Spent on Operations $3,959 $11,105 $11,320 $11,552 $11,603 $12,207 $12,445 $13,726 $13,897 $14,005 $14,000 $13,996
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 $838 $838 $838 $838 $838 $838 $838 $838 $838 $838 $838 $838
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,797 $11,943 $12,158 $12,390 $12,441 $13,045 $13,283 $14,564 $14,735 $14,843 $14,838 $14,834
Net Cash Flow ($497) ($6,723) ($6,018) ($5,330) ($5,381) ($445) ($683) ($1,664) $2,585 $2,477 $2,482 $3,866
Cash Balance $65,053 $58,330 $52,312 $46,982 $41,601 $41,156 $40,473 $38,809 $41,394 $43,871 $46,353 $50,219
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 $65,550 $65,053 $58,330 $52,312 $46,982 $41,601 $41,156 $40,473 $38,809 $41,394 $43,871 $46,353 $50,219
Other Current Assets $14,130 $14,130 $14,130 $14,130 $14,130 $14,130 $14,130 $14,130 $14,130 $14,130 $14,130 $14,130 $14,130
Total Current Assets $79,680 $79,183 $72,460 $66,442 $61,112 $55,731 $55,286 $54,603 $52,939 $55,524 $58,001 $60,483 $64,349
Long-term Assets
Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Accumulated Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Assets $79,680 $79,183 $72,460 $66,442 $61,112 $55,731 $55,286 $54,603 $52,939 $55,524 $58,001 $60,483 $64,349
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 $7,138 $7,353 $7,374 $7,425 $7,420 $7,659 $7,654 $7,822 $7,929 $7,925 $7,920 $7,954
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 $7,138 $7,353 $7,374 $7,425 $7,420 $7,659 $7,654 $7,822 $7,929 $7,925 $7,920 $7,954
Long-term Liabilities $60,000 $59,162 $58,324 $57,486 $56,648 $55,810 $54,972 $54,134 $53,295 $52,457 $51,619 $50,781 $49,943
Total Liabilities $60,000 $66,300 $65,677 $64,860 $64,073 $63,230 $62,631 $61,788 $61,117 $60,387 $59,544 $58,701 $57,897
Paid-in Capital $59,130 $59,130 $59,130 $59,130 $59,130 $59,130 $59,130 $59,130 $59,130 $59,130 $59,130 $59,130 $59,130
Retained Earnings ($39,450) ($39,450) ($39,450) ($39,450) ($39,450) ($39,450) ($39,450) ($39,450) ($39,450) ($39,450) ($39,450) ($39,450) ($39,450)
Earnings $0 ($6,797) ($12,897) ($18,098) ($22,641) ($27,179) ($27,024) ($26,865) ($27,858) ($24,543) ($21,223) ($17,898) ($13,228)
Total Capital $19,680 $12,883 $6,783 $1,582 ($2,961) ($7,499) ($7,344) ($7,185) ($8,178) ($4,863) ($1,543) $1,782 $6,452
Total Liabilities and Capital $79,680 $79,183 $72,460 $66,442 $61,112 $55,731 $55,286 $54,603 $52,939 $55,524 $58,001 $60,483 $64,349
Net Worth $19,680 $12,883 $6,783 $1,582 ($2,961) ($7,499) ($7,344) ($7,185) ($8,178) ($4,863) ($1,543) $1,782 $6,452