Our biggest savings of the year
Vashon Solicitation Services
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 |