Gentle Touch Creations

Start your own business plan »

Cosmetic Herbal Sundries 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
Herbal Products 0% $0 $10,000 $12,000 $14,000 $18,000 $22,000 $26,000 $36,000 $40,000 $36,000 $32,000 $36,000
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales $0 $10,000 $12,000 $14,000 $18,000 $22,000 $26,000 $36,000 $40,000 $36,000 $32,000 $36,000
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
Herbal Products $0 $5,000 $6,000 $7,000 $9,000 $11,000 $13,000 $18,000 $20,000 $18,000 $16,000 $18,000
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $0 $5,000 $6,000 $7,000 $9,000 $11,000 $13,000 $18,000 $20,000 $18,000 $16,000 $18,000
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
Joanne Lovejoy 0% $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500
2 Production Staff 0% $3,400 $3,400 $3,400 $3,400 $3,400 $3,400 $3,400 $3,400 $3,400 $3,400 $3,400 $3,400
P/T Production Staff 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 3 3 3 3 3 3 3 3 3 3 3 3
Total Payroll $5,900 $5,900 $5,900 $5,900 $5,900 $5,900 $5,900 $5,900 $5,900 $5,900 $5,900 $5,900
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 $0 $10,000 $12,000 $14,000 $18,000 $22,000 $26,000 $36,000 $40,000 $36,000 $32,000 $36,000
Direct Cost of Sales $0 $5,000 $6,000 $7,000 $9,000 $11,000 $13,000 $18,000 $20,000 $18,000 $16,000 $18,000
Other Production Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $0 $5,000 $6,000 $7,000 $9,000 $11,000 $13,000 $18,000 $20,000 $18,000 $16,000 $18,000
Gross Margin $0 $5,000 $6,000 $7,000 $9,000 $11,000 $13,000 $18,000 $20,000 $18,000 $16,000 $18,000
Gross Margin % 0.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00%
Expenses
Payroll $5,900 $5,900 $5,900 $5,900 $5,900 $5,900 $5,900 $5,900 $5,900 $5,900 $5,900 $5,900
Sales and Marketing and Other Expenses $380 $380 $380 $380 $380 $380 $380 $230 $230 $380 $380 $380
Depreciation $400 $400 $400 $400 $400 $400 $400 $400 $400 $400 $400 $400
Leased Equipment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Utilities $400 $400 $400 $400 $400 $400 $400 $400 $400 $400 $400 $400
Insurance $650 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Rent $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600
Payroll Taxes 15% $885 $885 $885 $885 $885 $885 $885 $885 $885 $885 $885 $885
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $9,215 $8,565 $8,565 $8,565 $8,565 $8,565 $8,565 $8,415 $8,415 $8,565 $8,565 $8,565
Profit Before Interest and Taxes ($9,215) ($3,565) ($2,565) ($1,565) $435 $2,435 $4,435 $9,585 $11,585 $9,435 $7,435 $9,435
EBITDA ($8,815) ($3,165) ($2,165) ($1,165) $835 $2,835 $4,835 $9,985 $11,985 $9,835 $7,835 $9,835
Interest Expense $411 $405 $399 $393 $388 $482 $472 $462 $452 $442 $432 $422
Taxes Incurred ($2,888) ($1,191) ($889) ($588) $14 $586 $1,189 $2,737 $3,340 $2,698 $2,101 $2,704
Net Profit ($6,738) ($2,779) ($2,075) ($1,371) $33 $1,367 $2,774 $6,386 $7,793 $6,295 $4,902 $6,309
Net Profit/Sales 0.00% -27.79% -17.29% -9.79% 0.18% 6.22% 10.67% 17.74% 19.48% 17.49% 15.32% 17.53%
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 $0 $2,500 $3,000 $3,500 $4,500 $5,500 $6,500 $9,000 $10,000 $9,000 $8,000 $9,000
Cash from Receivables $0 $0 $250 $7,550 $9,050 $10,600 $13,600 $16,600 $19,750 $27,100 $29,900 $26,900
Subtotal Cash from Operations $0 $2,500 $3,250 $11,050 $13,550 $16,100 $20,100 $25,600 $29,750 $36,100 $37,900 $35,900
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 $12,000 $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 $0 $2,500 $3,250 $11,050 $13,550 $28,100 $20,100 $25,600 $29,750 $36,100 $37,900 $35,900
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 $5,900 $5,900 $5,900 $5,900 $5,900 $5,900 $5,900 $5,900 $5,900 $5,900 $5,900 $5,900
Bill Payments $15 $656 $7,042 $8,918 $10,294 $13,956 $16,619 $19,449 $28,790 $27,877 $21,118 $18,831
Subtotal Spent on Operations $5,915 $6,556 $12,942 $14,818 $16,194 $19,856 $22,519 $25,349 $34,690 $33,777 $27,018 $24,731
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 $500 $500 $500 $500 $500 $500
Other Liabilities Principal Repayment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Long-term Liabilities Principal Repayment $700 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700
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 $6,615 $7,256 $13,642 $15,518 $16,894 $20,556 $23,719 $26,549 $35,890 $34,977 $28,218 $25,931
Net Cash Flow ($6,615) ($4,756) ($10,392) ($4,468) ($3,344) $7,544 ($3,619) ($949) ($6,140) $1,123 $9,682 $9,969
Cash Balance $26,785 $22,029 $11,637 $7,169 $3,825 $11,369 $7,750 $6,802 $662 $1,785 $11,467 $21,436
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 $33,400 $26,785 $22,029 $11,637 $7,169 $3,825 $11,369 $7,750 $6,802 $662 $1,785 $11,467 $21,436
Accounts Receivable $0 $0 $7,500 $16,250 $19,200 $23,650 $29,550 $35,450 $45,850 $56,100 $56,000 $50,100 $50,200
Inventory $5,000 $5,000 $5,500 $6,600 $7,700 $9,900 $12,100 $14,300 $19,800 $22,000 $19,800 $17,600 $19,800
Other Current Assets $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
Total Current Assets $43,400 $36,785 $40,029 $39,487 $39,069 $42,375 $58,019 $62,500 $77,452 $83,762 $82,585 $84,167 $96,436
Long-term Assets
Long-term Assets $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000
Accumulated Depreciation $0 $400 $800 $1,200 $1,600 $2,000 $2,400 $2,800 $3,200 $3,600 $4,000 $4,400 $4,800
Total Long-term Assets $15,000 $14,600 $14,200 $13,800 $13,400 $13,000 $12,600 $12,200 $11,800 $11,400 $11,000 $10,600 $10,200
Total Assets $58,400 $51,385 $54,229 $53,287 $52,469 $55,375 $70,619 $74,700 $89,252 $95,162 $93,585 $94,767 $106,636
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 $423 $6,746 $8,579 $9,832 $13,405 $15,982 $18,488 $27,853 $27,170 $20,498 $17,978 $24,738
Current Borrowing $0 $0 $0 $0 $0 $0 $12,000 $11,500 $11,000 $10,500 $10,000 $9,500 $9,000
Other Current Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Current Liabilities $0 $423 $6,746 $8,579 $9,832 $13,405 $27,982 $29,988 $38,853 $37,670 $30,498 $27,478 $33,738
Long-term Liabilities $50,000 $49,300 $48,600 $47,900 $47,200 $46,500 $45,800 $45,100 $44,400 $43,700 $43,000 $42,300 $41,600
Total Liabilities $50,000 $49,723 $55,346 $56,479 $57,032 $59,905 $73,782 $75,088 $83,253 $81,370 $73,498 $69,778 $75,338
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 ($41,600) ($41,600) ($41,600) ($41,600) ($41,600) ($41,600) ($41,600) ($41,600) ($41,600) ($41,600) ($41,600) ($41,600) ($41,600)
Earnings $0 ($6,738) ($9,517) ($11,592) ($12,963) ($12,930) ($11,562) ($8,788) ($2,402) $5,392 $11,687 $16,589 $22,899
Total Capital $8,400 $1,662 ($1,117) ($3,192) ($4,563) ($4,530) ($3,162) ($388) $5,998 $13,792 $20,087 $24,989 $31,299
Total Liabilities and Capital $58,400 $51,385 $54,229 $53,287 $52,469 $55,375 $70,619 $74,700 $89,252 $95,162 $93,585 $94,767 $106,636
Net Worth $8,400 $1,662 ($1,117) ($3,192) ($4,563) ($4,530) ($3,162) ($388) $5,998 $13,792 $20,087 $24,989 $31,299