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