SoulSpace

Start your own business plan »

Health Spa 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
Salon Styles Only Revenue 0% $48,000 $54,000 $60,000 $60,000 $60,000 $60,000 $60,000 $60,000 $62,000 $63,500 $65,000 $65,000
Spa Massage Only Revenue 0% $12,000 $13,500 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $16,000 $16,000 $17,500 $17,500
Total Sales $60,000 $67,500 $75,000 $75,000 $75,000 $75,000 $75,000 $75,000 $78,000 $79,500 $82,500 $82,500
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
Salon Styles Only Revenue $28,800 $32,400 $36,000 $36,000 $36,000 $36,000 $36,000 $36,000 $36,000 $38,100 $39,000 $39,000
Spa Massage Only Revenue $7,200 $8,100 $9,000 $9,000 $9,000 $9,000 $9,000 $9,000 $9,600 $9,600 $10,500 $10,500
Subtotal Direct Cost of Sales $36,000 $40,500 $45,000 $45,000 $45,000 $45,000 $45,000 $45,000 $45,600 $47,700 $49,500 $49,500
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
Steve Long, Owner, President 0% $5,420 $5,420 $5,420 $5,420 $5,420 $5,420 $5,420 $5,420 $5,420 $5,420 $5,420 $5,420
General Manager 0% $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
%100 Commissioned Employees 0% $10 $10 $13 $13 $13 $13 $13 $13 $13 $13 $13 $13
Receptionist 0% $1,280 $1,280 $1,280 $1,280 $1,280 $1,280 $1,280 $1,280 $1,280 $1,280 $1,280 $1,280
Receptionist 0% $1,280 $1,280 $1,280 $1,280 $1,280 $1,280 $1,280 $1,280 $1,280 $1,280 $1,280 $1,280
Total People 14 14 17 17 17 17 17 17 17 17 17 17
Total Payroll $12,990 $12,990 $12,993 $12,993 $12,993 $12,993 $12,993 $12,993 $12,993 $12,993 $12,993 $12,993
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% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.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 $60,000 $67,500 $75,000 $75,000 $75,000 $75,000 $75,000 $75,000 $78,000 $79,500 $82,500 $82,500
Direct Cost of Sales $36,000 $40,500 $45,000 $45,000 $45,000 $45,000 $45,000 $45,000 $45,600 $47,700 $49,500 $49,500
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $36,000 $40,500 $45,000 $45,000 $45,000 $45,000 $45,000 $45,000 $45,600 $47,700 $49,500 $49,500
Gross Margin $24,000 $27,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $32,400 $31,800 $33,000 $33,000
Gross Margin % 40.00% 40.00% 40.00% 40.00% 40.00% 40.00% 40.00% 40.00% 41.54% 40.00% 40.00% 40.00%
Expenses
Payroll $12,990 $12,990 $12,993 $12,993 $12,993 $12,993 $12,993 $12,993 $12,993 $12,993 $12,993 $12,993
Sales and Marketing and Other Expenses $7,000 $2,300 $2,300 $2,300 $2,300 $2,300 $2,300 $2,300 $2,300 $2,300 $4,000 $2,300
Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Rent $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000
Leased Equipment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Utilities $750 $750 $750 $750 $750 $750 $750 $750 $750 $750 $750 $750
Insurance $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Payroll Taxes 15% $1,949 $1,949 $1,949 $1,949 $1,949 $1,949 $1,949 $1,949 $1,949 $1,949 $1,949 $1,949
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $33,689 $28,989 $28,992 $28,992 $28,992 $28,992 $28,992 $28,992 $28,992 $28,992 $30,692 $28,992
Profit Before Interest and Taxes ($9,689) ($1,989) $1,008 $1,008 $1,008 $1,008 $1,008 $1,008 $3,408 $2,808 $2,308 $4,008
EBITDA ($9,689) ($1,989) $1,008 $1,008 $1,008 $1,008 $1,008 $1,008 $3,408 $2,808 $2,308 $4,008
Interest Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Taxes Incurred ($2,907) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit ($6,782) ($1,989) $1,008 $1,008 $1,008 $1,008 $1,008 $1,008 $3,408 $2,808 $2,308 $4,008
Net Profit/Sales -11.30% -2.95% 1.34% 1.34% 1.34% 1.34% 1.34% 1.34% 4.37% 3.53% 2.80% 4.86%
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 $60,000 $67,500 $75,000 $75,000 $75,000 $75,000 $75,000 $75,000 $78,000 $79,500 $82,500 $82,500
Subtotal Cash from Operations $60,000 $67,500 $75,000 $75,000 $75,000 $75,000 $75,000 $75,000 $78,000 $79,500 $82,500 $82,500
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 $60,000 $67,500 $75,000 $75,000 $75,000 $75,000 $75,000 $75,000 $78,000 $79,500 $82,500 $82,500
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 $12,990 $12,990 $12,993 $12,993 $12,993 $12,993 $12,993 $12,993 $12,993 $12,993 $12,993 $12,993
Bill Payments $2,913 $86,527 $61,599 $65,784 $60,999 $60,999 $60,999 $60,999 $61,041 $62,384 $66,115 $69,056
Subtotal Spent on Operations $15,903 $99,517 $74,592 $78,777 $73,992 $73,992 $73,992 $73,992 $74,034 $75,377 $79,108 $82,049
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 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
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 $15,903 $99,517 $74,592 $78,777 $73,992 $73,992 $73,992 $73,992 $74,034 $75,377 $79,108 $82,049
Net Cash Flow $44,097 ($32,017) $408 ($3,777) $1,008 $1,008 $1,008 $1,008 $3,966 $4,123 $3,392 $451
Cash Balance $104,097 $72,080 $72,488 $68,711 $69,719 $70,727 $71,735 $72,744 $76,710 $80,833 $84,225 $84,676
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 $60,000 $104,097 $72,080 $72,488 $68,711 $69,719 $70,727 $71,735 $72,744 $76,710 $80,833 $84,225 $84,676
Inventory $6,000 $39,600 $44,550 $49,500 $49,500 $49,500 $49,500 $49,500 $49,500 $50,160 $52,470 $54,450 $54,450
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $66,000 $143,697 $116,630 $121,988 $118,211 $119,219 $120,227 $121,235 $122,244 $126,870 $133,303 $138,675 $139,126
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 $66,000 $143,697 $116,630 $121,988 $118,211 $119,219 $120,227 $121,235 $122,244 $126,870 $133,303 $138,675 $139,126
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 $84,479 $59,400 $63,751 $58,966 $58,966 $58,966 $58,966 $58,966 $60,184 $63,809 $66,873 $63,316
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 $84,479 $59,400 $63,751 $58,966 $58,966 $58,966 $58,966 $58,966 $60,184 $63,809 $66,873 $63,316
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $0 $84,479 $59,400 $63,751 $58,966 $58,966 $58,966 $58,966 $58,966 $60,184 $63,809 $66,873 $63,316
Paid-in Capital $160,000 $160,000 $160,000 $160,000 $160,000 $160,000 $160,000 $160,000 $160,000 $160,000 $160,000 $160,000 $160,000
Retained Earnings ($94,000) ($94,000) ($94,000) ($94,000) ($94,000) ($94,000) ($94,000) ($94,000) ($94,000) ($94,000) ($94,000) ($94,000) ($94,000)
Earnings $0 ($6,782) ($8,770) ($7,762) ($6,754) ($5,746) ($4,738) ($3,730) ($2,722) $686 $3,494 $5,802 $9,810
Total Capital $66,000 $59,218 $57,230 $58,238 $59,246 $60,254 $61,262 $62,270 $63,278 $66,686 $69,494 $71,802 $75,810
Total Liabilities and Capital $66,000 $143,697 $116,630 $121,988 $118,211 $119,219 $120,227 $121,235 $122,244 $126,870 $133,303 $138,675 $139,126
Net Worth $66,000 $59,218 $57,230 $58,238 $59,246 $60,254 $61,262 $62,270 $63,278 $66,686 $69,494 $71,802 $75,810