Roth & Calder Telemarketing Professionals, Inc.
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 | |||||||||||||
| Large Companies | 0% | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $9,000 | $24,000 |
| Medium Companies | 0% | $0 | $0 | $0 | $0 | $0 | $2,000 | $4,000 | $4,000 | $5,000 | $5,000 | $6,000 | $7,000 |
| Small Companies | 0% | $0 | $0 | $0 | $0 | $7,000 | $5,000 | $3,000 | $26,000 | $4,000 | $7,000 | $10,000 | $7,000 |
| Other | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $7,000 | $5,000 | $12,000 | $5,000 | $2,000 | $5,000 |
| Total Sales | $6,000 | $6,000 | $6,000 | $6,000 | $13,000 | $13,000 | $20,000 | $41,000 | $27,000 | $23,000 | $27,000 | $43,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 | |
| All client projects | $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. Thomas Roth – 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. Jane Calder – Operations Head/Principal Consultant | 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 |
| Mrs. Susan Howell – Telemarketing Consultant | 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. Leonard Grey – Telemarketing Consultant | 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 |
| Office Manager | 0% | $1,700 | $1,700 | $1,700 | $1,700 | $1,700 | $1,700 | $1,700 | $1,700 | $1,700 | $1,700 | $1,700 | $1,700 |
| Cold Caller | 0% | $1,120 | $1,120 | $1,120 | $1,120 | $1,120 | $1,120 | $1,120 | $1,120 | $1,120 | $1,120 | $1,120 | $1,120 |
| Total People | 0% | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 |
| Total Payroll | $14,820 | $14,820 | $14,820 | $14,820 | $14,820 | $14,820 | $14,820 | $14,820 | $14,820 | $14,820 | $14,820 | $14,820 | |
| 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 | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.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 | $6,000 | $6,000 | $6,000 | $6,000 | $13,000 | $13,000 | $20,000 | $41,000 | $27,000 | $23,000 | $27,000 | $43,000 | |
| Direct Cost of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Other Costs of Sales | $0 | $0 | $0 | $0 | $0 | $500 | $0 | $700 | $0 | $0 | $0 | $0 | |
| Total Cost of Sales | $0 | $0 | $0 | $0 | $0 | $500 | $0 | $700 | $0 | $0 | $0 | $0 | |
| Gross Margin | $6,000 | $6,000 | $6,000 | $6,000 | $13,000 | $12,500 | $20,000 | $40,300 | $27,000 | $23,000 | $27,000 | $43,000 | |
| Gross Margin % | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 96.15% | 100.00% | 98.29% | 100.00% | 100.00% | 100.00% | 100.00% | |
| Expenses | |||||||||||||
| Payroll | $14,820 | $14,820 | $14,820 | $14,820 | $14,820 | $14,820 | $14,820 | $14,820 | $14,820 | $14,820 | $14,820 | $14,820 | |
| Sales and Marketing and Other Expenses | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | |
| Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Rent | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | |
| Utilities | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | |
| Insurance | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | |
| Payroll Taxes | 15% | $2,223 | $2,223 | $2,223 | $2,223 | $2,223 | $2,223 | $2,223 | $2,223 | $2,223 | $2,223 | $2,223 | $2,223 |
| Travel | 15% | $1,200 | $3,000 | $1,000 | $2,000 | $2,000 | $3,000 | $2,000 | $1,000 | $2,000 | $3,000 | $1,000 | $3,000 |
| Other | $600 | $600 | $600 | $600 | $600 | $600 | $600 | $600 | $600 | $600 | $600 | $600 | |
| Total Operating Expenses | $21,393 | $23,193 | $21,193 | $22,193 | $22,193 | $23,193 | $22,193 | $21,193 | $22,193 | $23,193 | $21,193 | $23,193 | |
| Profit Before Interest and Taxes | ($15,393) | ($17,193) | ($15,193) | ($16,193) | ($9,193) | ($10,693) | ($2,193) | $19,107 | $4,807 | ($193) | $5,807 | $19,807 | |
| EBITDA | ($15,393) | ($17,193) | ($15,193) | ($16,193) | ($9,193) | ($10,693) | ($2,193) | $19,107 | $4,807 | ($193) | $5,807 | $19,807 | |
| Interest Expense | $433 | $431 | $428 | $425 | $422 | $420 | $417 | $414 | $412 | $409 | $406 | $403 | |
| Taxes Incurred | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Net Profit | ($15,826) | ($17,624) | ($15,621) | ($16,618) | ($9,615) | ($11,113) | ($2,610) | $18,693 | $4,395 | ($602) | $5,401 | $19,404 | |
| Net Profit/Sales | -263.77% | -293.73% | -260.35% | -276.97% | -73.97% | -85.48% | -13.05% | 45.59% | 16.28% | -2.62% | 20.00% | 45.12% | |
| 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 | $1,500 | $1,500 | $1,500 | $1,500 | $3,250 | $3,250 | $5,000 | $10,250 | $6,750 | $5,750 | $6,750 | $10,750 | |
| Cash from Receivables | $0 | $150 | $4,500 | $4,500 | $4,500 | $4,675 | $9,750 | $9,925 | $15,525 | $30,400 | $20,150 | $17,350 | |
| Subtotal Cash from Operations | $1,500 | $1,650 | $6,000 | $6,000 | $7,750 | $7,925 | $14,750 | $20,175 | $22,275 | $36,150 | $26,900 | $28,100 | |
| 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 | $1,500 | $1,500 | $0 | $0 | $0 | $0 | |
| Subtotal Cash Received | $1,500 | $1,650 | $6,000 | $6,000 | $7,750 | $7,925 | $16,250 | $21,675 | $22,275 | $36,150 | $26,900 | $28,100 | |
| 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,820 | $14,820 | $14,820 | $14,820 | $14,820 | $14,820 | $14,820 | $14,820 | $14,820 | $14,820 | $14,820 | $14,820 | |
| Bill Payments | $3,234 | $7,066 | $8,737 | $6,834 | $7,798 | $7,845 | $9,243 | $7,780 | $7,497 | $7,818 | $8,715 | $6,846 | |
| Subtotal Spent on Operations | $18,054 | $21,886 | $23,557 | $21,654 | $22,618 | $22,665 | $24,063 | $22,600 | $22,317 | $22,638 | $23,535 | $21,666 | |
| 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 | $181 | $181 | $181 | $181 | $181 | $181 | $181 | $181 | $181 | $181 | $190 | |
| Other Liabilities Principal Repayment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Long-term Liabilities Principal Repayment | $0 | $181 | $181 | $181 | $181 | $181 | $181 | $181 | $181 | $181 | $181 | $190 | |
| 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 | $15,000 | |
| Subtotal Cash Spent | $18,054 | $22,248 | $23,919 | $22,016 | $22,980 | $23,027 | $24,425 | $22,962 | $22,679 | $23,000 | $23,897 | $37,046 | |
| Net Cash Flow | ($16,554) | ($20,598) | ($17,919) | ($16,016) | ($15,230) | ($15,102) | ($8,175) | ($1,287) | ($404) | $13,150 | $3,003 | ($8,946) | |
| Cash Balance | $100,746 | $80,148 | $62,229 | $46,213 | $30,983 | $15,881 | $7,706 | $6,419 | $6,015 | $19,165 | $22,168 | $13,222 | |
| 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,300 | $100,746 | $80,148 | $62,229 | $46,213 | $30,983 | $15,881 | $7,706 | $6,419 | $6,015 | $19,165 | $22,168 | $13,222 |
| Accounts Receivable | $0 | $4,500 | $8,850 | $8,850 | $8,850 | $14,100 | $19,175 | $24,425 | $45,250 | $49,975 | $36,825 | $36,925 | $51,825 |
| 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 | $122,300 | $110,246 | $93,998 | $76,079 | $60,063 | $50,083 | $40,056 | $37,131 | $56,669 | $60,990 | $60,990 | $64,093 | $70,047 |
| Long-term Assets | |||||||||||||
| Long-term Assets | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 |
| Accumulated Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Long-term Assets | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 |
| Total Assets | $132,300 | $120,246 | $103,998 | $86,079 | $70,063 | $60,083 | $50,056 | $47,131 | $66,669 | $70,990 | $70,990 | $74,093 | $80,047 |
| 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 | $6,773 | $8,510 | $6,574 | $7,538 | $7,536 | $8,983 | $7,530 | $7,238 | $7,525 | $8,489 | $6,553 | $8,484 |
| Current Borrowing | $16,000 | $16,000 | $15,819 | $15,638 | $15,457 | $15,276 | $15,095 | $14,914 | $14,733 | $14,552 | $14,371 | $14,190 | $14,000 |
| Other Current Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Subtotal Current Liabilities | $19,000 | $22,773 | $24,329 | $22,212 | $22,995 | $22,812 | $24,078 | $22,444 | $21,971 | $22,077 | $22,860 | $20,743 | $22,484 |
| Long-term Liabilities | $45,000 | $45,000 | $44,819 | $44,638 | $44,457 | $44,276 | $44,095 | $43,914 | $43,733 | $43,552 | $43,371 | $43,190 | $43,000 |
| Total Liabilities | $64,000 | $67,773 | $69,148 | $66,850 | $67,452 | $67,088 | $68,173 | $66,358 | $65,704 | $65,629 | $66,231 | $63,933 | $65,484 |
| 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 | ($31,700) | ($31,700) | ($31,700) | ($31,700) | ($31,700) | ($31,700) | ($31,700) | ($31,700) | ($31,700) | ($31,700) | ($31,700) | ($31,700) | ($46,700) |
| Earnings | $0 | ($15,826) | ($33,450) | ($49,071) | ($65,689) | ($75,305) | ($86,417) | ($89,027) | ($70,335) | ($65,939) | ($66,541) | ($61,140) | ($41,737) |
| Total Capital | $68,300 | $52,474 | $34,850 | $19,229 | $2,611 | ($7,005) | ($18,117) | ($19,227) | $965 | $5,361 | $4,759 | $10,160 | $14,563 |
| Total Liabilities and Capital | $132,300 | $120,246 | $103,998 | $86,079 | $70,063 | $60,083 | $50,056 | $47,131 | $66,669 | $70,990 | $70,990 | $74,093 | $80,047 |
| Net Worth | $68,300 | $52,474 | $34,850 | $19,229 | $2,611 | ($7,005) | ($18,117) | ($19,227) | $965 | $5,361 | $4,759 | $10,160 | $14,563 |
By 
