U&Me Dance

Start your own business plan »

Dance Studio Business Plan

Appendix

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
Owners Salary/Distribution 0% $2,000 $3,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000
Instructors Compensation 0% $1,250 $1,250 $1,250 $2,500 $2,500 $2,800 $2,800 $2,800 $4,000 $4,000 $4,000 $4,000
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 5 5 5 5 5 5 5 5 5 5 5 5
Total Payroll $3,250 $4,250 $7,250 $8,500 $8,500 $8,800 $8,800 $8,800 $10,000 $10,000 $10,000 $10,000
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 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00%
Long-term Interest Rate 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.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 $15,600 $17,100 $23,740 $25,950 $27,000 $28,200 $26,500 $26,100 $28,100 $26,800 $27,950 $28,950
Direct Cost of Sales $1,496 $1,496 $2,312 $2,312 $2,771 $2,771 $2,771 $2,771 $2,771 $2,771 $3,001 $3,001
Other Production Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $1,496 $1,496 $2,312 $2,312 $2,771 $2,771 $2,771 $2,771 $2,771 $2,771 $3,001 $3,001
Gross Margin $14,104 $15,604 $21,428 $23,638 $24,229 $25,429 $23,729 $23,329 $25,329 $24,029 $24,949 $25,949
Gross Margin % 90.41% 91.25% 90.26% 91.09% 89.74% 90.17% 89.54% 89.38% 90.14% 89.66% 89.26% 89.63%
Expenses
Payroll $3,250 $4,250 $7,250 $8,500 $8,500 $8,800 $8,800 $8,800 $10,000 $10,000 $10,000 $10,000
Sales and Marketing and Other Expenses $3,500 $3,600 $3,600 $5,600 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600
Depreciation $295 $295 $295 $295 $295 $295 $295 $295 $295 $295 $295 $295
Utilities $750 $750 $750 $750 $750 $750 $750 $750 $750 $750 $750 $750
Telephone $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Insurance $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150
Rent $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000
Payroll Taxes 10% $325 $425 $725 $850 $850 $880 $880 $880 $1,000 $1,000 $1,000 $1,000
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $14,470 $15,670 $18,970 $22,345 $20,345 $20,675 $20,675 $20,675 $21,995 $21,995 $21,995 $21,995
Profit Before Interest and Taxes ($366) ($66) $2,458 $1,293 $3,884 $4,754 $3,054 $2,654 $3,334 $2,034 $2,954 $3,954
EBITDA ($71) $229 $2,753 $1,588 $4,179 $5,049 $3,349 $2,949 $3,629 $2,329 $3,249 $4,249
Interest Expense $0 ($8) ($17) ($25) ($33) ($42) ($50) ($58) ($67) ($75) ($83) ($92)
Taxes Incurred ($110) ($17) $742 $395 $1,175 $1,439 $931 $814 $1,020 $633 $911 $1,214
Net Profit ($256) ($40) $1,732 $923 $2,742 $3,357 $2,173 $1,899 $2,380 $1,476 $2,126 $2,832
Net Profit/Sales -1.64% -0.24% 7.30% 3.56% 10.16% 11.90% 8.20% 7.27% 8.47% 5.51% 7.61% 9.78%
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 $15,600 $17,100 $23,740 $25,950 $27,000 $28,200 $26,500 $26,100 $28,100 $26,800 $27,950 $28,950
Subtotal Cash from Operations $15,600 $17,100 $23,740 $25,950 $27,000 $28,200 $26,500 $26,100 $28,100 $26,800 $27,950 $28,950
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 $15,600 $17,100 $23,740 $25,950 $27,000 $28,200 $26,500 $26,100 $28,100 $26,800 $27,950 $28,950
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,250 $4,250 $7,250 $8,500 $8,500 $8,800 $8,800 $8,800 $10,000 $10,000 $10,000 $10,000
Bill Payments $410 $12,321 $12,658 $14,522 $16,207 $15,472 $15,731 $15,228 $15,117 $15,411 $15,045 $15,539
Subtotal Spent on Operations $3,660 $16,571 $19,908 $23,022 $24,707 $24,272 $24,531 $24,028 $25,117 $25,411 $25,045 $25,539
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 $0 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
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 $3,660 $17,571 $20,908 $24,022 $25,707 $25,272 $25,531 $25,028 $26,117 $26,411 $26,045 $26,539
Net Cash Flow $11,940 ($471) $2,832 $1,928 $1,293 $2,928 $969 $1,072 $1,983 $389 $1,905 $2,411
Cash Balance $22,690 $22,219 $25,051 $26,980 $28,273 $31,200 $32,170 $33,242 $35,225 $35,613 $37,518 $39,929
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 $10,750 $22,690 $22,219 $25,051 $26,980 $28,273 $31,200 $32,170 $33,242 $35,225 $35,613 $37,518 $39,929
Other Current Assets $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000
Total Current Assets $22,750 $34,690 $34,219 $37,051 $38,980 $40,273 $43,200 $44,170 $45,242 $47,225 $47,613 $49,518 $51,929
Long-term Assets
Long-term Assets $17,700 $17,700 $17,700 $17,700 $17,700 $17,700 $17,700 $17,700 $17,700 $17,700 $17,700 $17,700 $17,700
Accumulated Depreciation $0 $295 $590 $885 $1,180 $1,475 $1,770 $2,065 $2,360 $2,655 $2,950 $3,245 $3,540
Total Long-term Assets $17,700 $17,405 $17,110 $16,815 $16,520 $16,225 $15,930 $15,635 $15,340 $15,045 $14,750 $14,455 $14,160
Total Assets $40,450 $52,095 $51,329 $53,866 $55,500 $56,498 $59,130 $59,805 $60,582 $62,270 $62,363 $63,973 $66,089
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 $11,901 $12,176 $13,981 $15,691 $14,947 $15,223 $14,724 $14,603 $14,910 $14,528 $15,011 $15,296
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 $11,901 $12,176 $13,981 $15,691 $14,947 $15,223 $14,724 $14,603 $14,910 $14,528 $15,011 $15,296
Long-term Liabilities $0 $0 ($1,000) ($2,000) ($3,000) ($4,000) ($5,000) ($6,000) ($7,000) ($8,000) ($9,000) ($10,000) ($11,000)
Total Liabilities $0 $11,901 $11,176 $11,981 $12,691 $10,947 $10,223 $8,724 $7,603 $6,910 $5,528 $5,011 $4,296
Paid-in Capital $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000
Retained Earnings ($9,550) ($9,550) ($9,550) ($9,550) ($9,550) ($9,550) ($9,550) ($9,550) ($9,550) ($9,550) ($9,550) ($9,550) ($9,550)
Earnings $0 ($256) ($297) $1,436 $2,358 $5,100 $8,457 $10,630 $12,529 $14,909 $16,386 $18,512 $21,344
Total Capital $40,450 $40,194 $40,153 $41,886 $42,808 $45,550 $48,907 $51,080 $52,979 $55,359 $56,836 $58,962 $61,794
Total Liabilities and Capital $40,450 $52,095 $51,329 $53,866 $55,500 $56,498 $59,130 $59,805 $60,582 $62,270 $62,363 $63,973 $66,089
Net Worth $40,450 $40,194 $40,153 $41,886 $42,808 $45,550 $48,907 $51,080 $52,979 $55,359 $56,836 $58,962 $61,794