Godsend Concierge Service

Start your own business plan »

Concierge Service 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
Corporations 0% $0 $2,577 $3,216 $3,677 $4,032 $4,706 $5,700 $7,847 $7,984 $7,998 $8,001 $8,978
Individuals 0% $0 $180 $246 $295 $341 $393 $482 $534 $543 $549 $671 $1,100
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales $0 $2,757 $3,462 $3,972 $4,373 $5,099 $6,182 $8,381 $8,527 $8,547 $8,672 $10,078
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
Corporations $0 $0 $0 $0 $0 $0 $1,325 $1,325 $1,490 $1,656 $1,822 $1,987
Individuals $0 $0 $0 $0 $0 $0 $147 $147 $165 $184 $202 $221
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $0 $0 $0 $0 $0 $0 $1,472 $1,472 $1,655 $1,840 $2,024 $2,208
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
Payroll 0% $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $3,298 $3,298 $4,689 $4,848 $4,912 $6,416
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 1 1 1 1 1 1 1 1 1 1 1 1
Total Payroll $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $3,298 $3,298 $4,689 $4,848 $4,912 $6,416
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% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.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 $2,757 $3,462 $3,972 $4,373 $5,099 $6,182 $8,381 $8,527 $8,547 $8,672 $10,078
Direct Cost of Sales $0 $0 $0 $0 $0 $0 $1,472 $1,472 $1,655 $1,840 $2,024 $2,208
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $0 $0 $0 $0 $0 $0 $1,472 $1,472 $1,655 $1,840 $2,024 $2,208
Gross Margin $0 $2,757 $3,462 $3,972 $4,373 $5,099 $4,710 $6,909 $6,872 $6,707 $6,648 $7,870
Gross Margin % 0.00% 100.00% 100.00% 100.00% 100.00% 100.00% 76.19% 82.44% 80.59% 78.47% 76.66% 78.09%
Expenses
Payroll $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $3,298 $3,298 $4,689 $4,848 $4,912 $6,416
Sales and Marketing and Other Expenses $0 $150 $150 $150 $125 $375 $150 $150 $150 $200 $200 $200
Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Depreciation $41 $41 $41 $41 $41 $41 $41 $41 $41 $41 $41 $41
Additional payroll burdens- 7.5% $0 $0 $0 $0 $110 $110 $110 $371 $371 $371 $371 $481
Comunication Equipment $150 $175 $200 $200 $200 $220 $220 $220 $220 $220 $220 $220
Utilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Insurance $0 $0 $0 $100 $100 $100 $100 $100 $100 $100 $100 $100
Payroll Taxes 15% $300 $300 $300 $300 $300 $300 $495 $495 $703 $727 $737 $962
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $2,491 $2,666 $2,691 $2,791 $2,876 $3,146 $4,414 $4,675 $6,274 $6,507 $6,581 $8,420
Profit Before Interest and Taxes ($2,491) $91 $771 $1,181 $1,497 $1,953 $296 $2,234 $598 $200 $67 ($550)
EBITDA ($2,491) $91 $771 $1,181 $1,497 $1,953 $296 $2,234 $598 $200 $67 ($550)
Interest Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Taxes Incurred ($747) $23 $193 $295 $374 $488 $74 $559 $149 $50 $17 ($138)
Net Profit ($1,744) $68 $578 $886 $1,123 $1,465 $222 $1,676 $448 $150 $50 ($413)
Net Profit/Sales 0.00% 2.48% 16.70% 22.30% 25.67% 28.73% 3.59% 19.99% 5.26% 1.75% 0.58% -4.10%
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 $1,654 $2,077 $2,383 $2,624 $3,059 $3,709 $5,029 $5,116 $5,128 $5,203 $6,047
Cash from Receivables $0 $0 $37 $1,112 $1,392 $1,594 $1,759 $2,054 $2,502 $3,354 $3,411 $3,420
Subtotal Cash from Operations $0 $1,654 $2,114 $3,495 $4,015 $4,654 $5,468 $7,083 $7,618 $8,483 $8,614 $9,467
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 $2,000 $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 $1,255 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Received $1,255 $1,654 $2,114 $3,495 $6,015 $4,654 $5,468 $7,083 $7,618 $8,483 $8,614 $9,467
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 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $3,298 $3,298 $4,689 $4,848 $4,912 $6,416
Bill Payments ($256) ($225) $695 $891 $1,092 $1,263 $1,669 $2,687 $3,407 $3,395 $3,554 $3,722
Subtotal Spent on Operations $1,744 $1,775 $2,695 $2,891 $3,092 $3,263 $4,967 $5,985 $8,096 $8,243 $8,466 $10,138
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 $1,744 $1,775 $2,695 $2,891 $3,092 $3,263 $4,967 $5,985 $8,096 $8,243 $8,466 $10,138
Net Cash Flow ($489) ($121) ($581) $605 $2,924 $1,390 $502 $1,098 ($477) $239 $148 ($671)
Cash Balance $766 $645 $64 $669 $3,593 $4,983 $5,485 $6,583 $6,105 $6,345 $6,493 $5,822
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 $1,255 $766 $645 $64 $669 $3,593 $4,983 $5,485 $6,583 $6,105 $6,345 $6,493 $5,822
Accounts Receivable $0 $0 $1,103 $2,451 $2,927 $3,285 $3,730 $4,444 $5,743 $6,651 $6,716 $6,774 $7,384
Other Current Assets $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,500
Total Current Assets $3,755 $3,266 $4,248 $5,015 $6,096 $9,378 $11,214 $12,429 $14,825 $15,257 $15,561 $15,766 $15,706
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 $3,755 $3,266 $4,248 $5,015 $6,096 $9,378 $11,214 $12,429 $14,825 $15,257 $15,561 $15,766 $15,706
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 $0 $914 $1,102 $1,298 $1,456 $1,828 $2,821 $3,541 $3,525 $3,679 $3,834 $4,187
Current Borrowing $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other Current Liabilities $0 $0 $0 $0 $0 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Subtotal Current Liabilities $0 $0 $914 $1,102 $1,298 $3,456 $3,828 $4,821 $5,541 $5,525 $5,679 $5,834 $6,187
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $0 $0 $914 $1,102 $1,298 $3,456 $3,828 $4,821 $5,541 $5,525 $5,679 $5,834 $6,187
Paid-in Capital $7,500 $8,755 $8,755 $8,755 $8,755 $8,755 $8,755 $8,755 $8,755 $8,755 $8,755 $8,755 $8,755
Retained Earnings ($3,745) ($3,745) ($3,745) ($3,745) ($3,745) ($3,745) ($3,745) ($3,745) ($3,745) ($3,745) ($3,745) ($3,745) ($3,745)
Earnings $0 ($1,744) ($1,675) ($1,097) ($211) $911 $2,376 $2,598 $4,274 $4,722 $4,872 $4,922 $4,510
Total Capital $3,755 $3,266 $3,335 $3,913 $4,799 $5,921 $7,386 $7,608 $9,284 $9,732 $9,882 $9,932 $9,520
Total Liabilities and Capital $3,755 $3,266 $4,248 $5,015 $6,096 $9,378 $11,214 $12,429 $14,825 $15,257 $15,561 $15,766 $15,706
Net Worth $3,755 $3,266 $3,335 $3,913 $4,799 $5,921 $7,386 $7,608 $9,284 $9,732 $9,882 $9,932 $9,520