Vashon Solicitation Services

Start your own business plan »

Call Center 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
Medical call center services 0% $8,000 $8,000 $8,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000
Help desk services 0% $0 $0 $0 $5,000 $5,000 $5,000 $8,000 $8,000 $8,000 $8,000 $11,000 $11,000
Short-term projects 0% $2,000 $2,500 $0 $0 $2,000 $3,000 $3,000 $6,000 $4,000 $7,000 $7,000 $7,000
Other projects 0% $1,000 $1,500 $0 $0 $0 $0 $7,000 $5,000 $7,000 $5,000 $2,000 $5,000
Total Sales $11,000 $12,000 $8,000 $17,000 $19,000 $20,000 $30,000 $31,000 $31,000 $32,000 $32,000 $35,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
Row 1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
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
Mr. Martin Gibbs - President 0% $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Ms. Mary Stuart - Office Manager 0% $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Mr. Nicholas Caput - Operations 0% $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Customer service representatives 0% $5,760 $5,760 $5,760 $5,760 $5,760 $7,680 $9,600 $10,000 $10,000 $10,000 $11,500 $13,470
Total People 0% 9 9 9 9 9 11 13 15 15 15 17 19
Total Payroll $14,760 $14,760 $14,760 $14,760 $14,760 $16,680 $18,600 $19,000 $19,000 $19,000 $20,500 $22,470
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 $11,000 $12,000 $8,000 $17,000 $19,000 $20,000 $30,000 $31,000 $31,000 $32,000 $32,000 $35,000
Direct Cost of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other Costs of Sales $200 $100 $100 $200 $300 $300 $500 $600 $500 $500 $500 $500
Total Cost of Sales $200 $100 $100 $200 $300 $300 $500 $600 $500 $500 $500 $500
Gross Margin $10,800 $11,900 $7,900 $16,800 $18,700 $19,700 $29,500 $30,400 $30,500 $31,500 $31,500 $34,500
Gross Margin % 98.18% 99.17% 98.75% 98.82% 98.42% 98.50% 98.33% 98.06% 98.39% 98.44% 98.44% 98.57%
Expenses
Payroll $14,760 $14,760 $14,760 $14,760 $14,760 $16,680 $18,600 $19,000 $19,000 $19,000 $20,500 $22,470
Sales and Marketing and Other Expenses $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500
Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Rent $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500
Utilities $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600
Insurance $1,100 $1,100 $1,100 $1,100 $1,100 $1,100 $1,100 $1,100 $1,100 $1,100 $1,100 $1,100
Payroll Taxes 15% $2,214 $2,214 $2,214 $2,214 $2,214 $2,502 $2,790 $2,850 $2,850 $2,850 $3,075 $3,371
Travel 15% $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Other $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500
Total Operating Expenses $24,174 $24,174 $24,174 $24,174 $24,174 $26,382 $28,590 $29,050 $29,050 $29,050 $30,775 $33,041
Profit Before Interest and Taxes ($13,374) ($12,274) ($16,274) ($7,374) ($5,474) ($6,682) $910 $1,350 $1,450 $2,450 $725 $1,460
EBITDA ($13,374) ($12,274) ($16,274) ($7,374) ($5,474) ($6,682) $910 $1,350 $1,450 $2,450 $725 $1,460
Interest Expense $592 $592 $592 $592 $633 $675 $717 $758 $758 $758 $758 $758
Taxes Incurred $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit ($13,966) ($12,866) ($16,866) ($7,966) ($6,107) ($7,357) $193 $592 $692 $1,692 ($33) $701
Net Profit/Sales -126.96% -107.21% -210.82% -46.86% -32.14% -36.79% 0.64% 1.91% 2.23% 5.29% -0.10% 2.00%
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 $2,750 $3,000 $2,000 $4,250 $4,750 $5,000 $7,500 $7,750 $7,750 $8,000 $8,000 $8,750
Cash from Receivables $0 $275 $8,275 $8,900 $6,225 $12,800 $14,275 $15,250 $22,525 $23,250 $23,275 $24,000
Subtotal Cash from Operations $2,750 $3,275 $10,275 $13,150 $10,975 $17,800 $21,775 $23,000 $30,275 $31,250 $31,275 $32,750
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 $5,000 $5,000 $5,000 $5,000 $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 $1,500 $1,500 $0 $0 $0 $0
Subtotal Cash Received $2,750 $3,275 $10,275 $13,150 $15,975 $22,800 $28,275 $29,500 $30,275 $31,250 $31,275 $32,750
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 $14,760 $14,760 $14,760 $14,760 $14,760 $16,680 $18,600 $19,000 $19,000 $19,000 $20,500 $22,470
Bill Payments $3,340 $10,202 $10,106 $10,109 $10,210 $10,358 $10,695 $11,213 $11,405 $11,308 $11,316 $11,543
Subtotal Spent on Operations $18,100 $24,962 $24,866 $24,869 $24,970 $27,038 $29,295 $30,213 $30,405 $30,308 $31,816 $34,013
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 $18,100 $24,962 $24,866 $24,869 $24,970 $27,038 $29,295 $30,213 $30,405 $30,308 $31,816 $34,013
Net Cash Flow ($15,350) ($21,687) ($14,591) ($11,719) ($8,995) ($4,238) ($1,020) ($713) ($130) $942 ($541) ($1,263)
Cash Balance $102,450 $80,762 $66,172 $54,453 $45,457 $41,219 $40,199 $39,486 $39,356 $40,298 $39,757 $38,494
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 $117,800 $102,450 $80,762 $66,172 $54,453 $45,457 $41,219 $40,199 $39,486 $39,356 $40,298 $39,757 $38,494
Accounts Receivable $0 $8,250 $16,975 $14,700 $18,550 $26,575 $28,775 $37,000 $45,000 $45,725 $46,475 $47,200 $49,450
Other Current Assets $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500
Total Current Assets $121,300 $114,200 $101,237 $84,372 $76,503 $75,532 $73,494 $80,699 $87,986 $88,581 $90,273 $90,457 $91,444
Long-term Assets
Long-term Assets $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000
Accumulated Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Long-term Assets $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000
Total Assets $146,300 $139,200 $126,237 $109,372 $101,503 $100,532 $98,494 $105,699 $112,986 $113,581 $115,273 $115,457 $116,444
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 $3,000 $9,865 $9,769 $9,769 $9,865 $10,002 $10,321 $10,833 $11,028 $10,931 $10,931 $11,149 $11,435
Current Borrowing $16,000 $16,000 $16,000 $16,000 $16,000 $21,000 $26,000 $31,000 $36,000 $36,000 $36,000 $36,000 $36,000
Other Current Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Current Liabilities $19,000 $25,865 $25,769 $25,769 $25,865 $31,002 $36,321 $41,833 $47,028 $46,931 $46,931 $47,149 $47,435
Long-term Liabilities $55,000 $55,000 $55,000 $55,000 $55,000 $55,000 $55,000 $55,000 $55,000 $55,000 $55,000 $55,000 $55,000
Total Liabilities $74,000 $80,865 $80,769 $80,769 $80,865 $86,002 $91,321 $96,833 $102,028 $101,931 $101,931 $102,149 $102,435
Paid-in Capital $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $101,500 $103,000 $103,000 $103,000 $103,000 $103,000
Retained Earnings ($27,700) ($27,700) ($27,700) ($27,700) ($27,700) ($27,700) ($27,700) ($27,700) ($27,700) ($27,700) ($27,700) ($27,700) ($27,700)
Earnings $0 ($13,966) ($26,831) ($43,697) ($51,663) ($57,770) ($65,127) ($64,934) ($64,342) ($63,650) ($61,959) ($61,992) ($61,291)
Total Capital $72,300 $58,334 $45,469 $28,603 $20,637 $14,530 $7,173 $8,866 $10,958 $11,650 $13,341 $13,308 $14,009
Total Liabilities and Capital $146,300 $139,200 $126,237 $109,372 $101,503 $100,532 $98,494 $105,699 $112,986 $113,581 $115,273 $115,457 $116,444
Net Worth $72,300 $58,334 $45,469 $28,603 $20,637 $14,530 $7,173 $8,866 $10,958 $11,650 $13,341 $13,308 $14,009