Security First Shredding
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 | |||||||||||||
On-site Disposal | 0% | $0 | $6,000 | $8,000 | $10,000 | $14,000 | $19,000 | $20,000 | $23,000 | $26,000 | $29,000 | $32,000 | $33,000 |
Off-site Disposal | 0% | $0 | $5,000 | $6,000 | $10,000 | $17,000 | $21,000 | $23,000 | $25,000 | $28,000 | $31,000 | $33,000 | $33,000 |
Other | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Sales | $0 | $11,000 | $14,000 | $20,000 | $31,000 | $40,000 | $43,000 | $48,000 | $54,000 | $60,000 | $65,000 | $66,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 | |
On-site Disposal | $0 | $400 | $500 | $600 | $1,000 | $1,500 | $1,600 | $1,600 | $2,000 | $2,400 | $2,600 | $3,000 | |
Off-site Disposal | $0 | $300 | $400 | $600 | $1,300 | $1,600 | $1,600 | $1,600 | $2,200 | $2,400 | $2,600 | $2,800 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Direct Cost of Sales | $0 | $700 | $900 | $1,200 | $2,300 | $3,100 | $3,200 | $3,200 | $4,200 | $4,800 | $5,200 | $5,800 |
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 | ||
Janet Wilson | 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 |
Off-site Facility Manager | 0% | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 |
Off-site Facility Staff | 0% | $6,500 | $6,500 | $6,500 | $6,500 | $6,500 | $6,500 | $6,500 | $6,500 | $6,500 | $6,500 | $6,500 | $6,500 |
On-site Staff/Drivers | 0% | $6,500 | $6,500 | $6,500 | $6,500 | $6,500 | $6,500 | $6,500 | $6,500 | $6,500 | $6,500 | $6,500 | $6,500 |
Customer Service Staff | 0% | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 |
Sales Staff | 0% | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 |
Other | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total People | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | |
Total Payroll | $22,100 | $22,100 | $22,100 | $22,100 | $22,100 | $22,100 | $22,100 | $22,100 | $22,100 | $22,100 | $22,100 | $22,100 |
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 | $0 | $11,000 | $14,000 | $20,000 | $31,000 | $40,000 | $43,000 | $48,000 | $54,000 | $60,000 | $65,000 | $66,000 | |
Direct Cost of Sales | $0 | $700 | $900 | $1,200 | $2,300 | $3,100 | $3,200 | $3,200 | $4,200 | $4,800 | $5,200 | $5,800 | |
Other Production Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $0 | $700 | $900 | $1,200 | $2,300 | $3,100 | $3,200 | $3,200 | $4,200 | $4,800 | $5,200 | $5,800 | |
Gross Margin | $0 | $10,300 | $13,100 | $18,800 | $28,700 | $36,900 | $39,800 | $44,800 | $49,800 | $55,200 | $59,800 | $60,200 | |
Gross Margin % | 0.00% | 93.64% | 93.57% | 94.00% | 92.58% | 92.25% | 92.56% | 93.33% | 92.22% | 92.00% | 92.00% | 91.21% | |
Expenses | |||||||||||||
Payroll | $22,100 | $22,100 | $22,100 | $22,100 | $22,100 | $22,100 | $22,100 | $22,100 | $22,100 | $22,100 | $22,100 | $22,100 | |
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 | |
Leased Equipment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Utilities | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | |
Insurance | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | |
Rent | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | |
Payroll Taxes | 15% | $3,315 | $3,315 | $3,315 | $3,315 | $3,315 | $3,315 | $3,315 | $3,315 | $3,315 | $3,315 | $3,315 | $3,315 |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Operating Expenses | $29,115 | $29,115 | $29,115 | $29,115 | $29,115 | $29,115 | $29,115 | $29,115 | $29,115 | $29,115 | $29,115 | $29,115 | |
Profit Before Interest and Taxes | ($29,115) | ($18,815) | ($16,015) | ($10,315) | ($415) | $7,785 | $10,685 | $15,685 | $20,685 | $26,085 | $30,685 | $31,085 | |
EBITDA | ($29,115) | ($18,815) | ($16,015) | ($10,315) | ($415) | $7,785 | $10,685 | $15,685 | $20,685 | $26,085 | $30,685 | $31,085 | |
Interest Expense | $825 | $817 | $808 | $800 | $792 | $783 | $775 | $767 | $758 | $750 | $742 | $733 | |
Taxes Incurred | ($8,982) | ($5,890) | ($5,047) | ($3,335) | ($362) | $2,101 | $2,973 | $4,476 | $5,978 | $7,601 | $8,983 | $9,106 | |
Net Profit | ($20,958) | ($13,742) | ($11,776) | ($7,781) | ($845) | $4,901 | $6,937 | $10,443 | $13,949 | $17,735 | $20,960 | $21,246 | |
Net Profit/Sales | 0.00% | -124.93% | -84.12% | -38.90% | -2.72% | 12.25% | 16.13% | 21.76% | 25.83% | 29.56% | 32.25% | 32.19% |
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 | $2,750 | $3,500 | $5,000 | $7,750 | $10,000 | $10,750 | $12,000 | $13,500 | $15,000 | $16,250 | $16,500 | |
Cash from Receivables | $0 | $0 | $275 | $8,325 | $10,650 | $15,275 | $23,475 | $30,075 | $32,375 | $36,150 | $40,650 | $45,125 | |
Subtotal Cash from Operations | $0 | $2,750 | $3,775 | $13,325 | $18,400 | $25,275 | $34,225 | $42,075 | $45,875 | $51,150 | $56,900 | $61,625 | |
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 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $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 | $10,000 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Cash Received | $0 | $2,750 | $3,775 | $15,325 | $30,400 | $27,275 | $36,225 | $44,075 | $45,875 | $51,150 | $56,900 | $61,625 | |
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 | $22,100 | $22,100 | $22,100 | $22,100 | $22,100 | $22,100 | $22,100 | $22,100 | $22,100 | $22,100 | $22,100 | $22,100 | |
Bill Payments | ($1,142) | ($1,016) | $2,677 | $3,743 | $5,816 | $9,853 | $13,031 | $14,013 | $15,540 | $18,025 | $20,225 | $21,963 | |
Subtotal Spent on Operations | $20,958 | $21,084 | $24,777 | $25,843 | $27,916 | $31,953 | $35,131 | $36,113 | $37,640 | $40,125 | $42,325 | $44,063 | |
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 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | |
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 | $21,958 | $22,084 | $25,777 | $26,843 | $28,916 | $32,953 | $36,131 | $37,113 | $38,640 | $41,125 | $43,325 | $45,063 | |
Net Cash Flow | ($21,958) | ($19,334) | ($22,002) | ($11,518) | $1,484 | ($5,678) | $94 | $6,962 | $7,235 | $10,025 | $13,575 | $16,562 | |
Cash Balance | $58,442 | $39,108 | $17,106 | $5,588 | $7,072 | $1,394 | $1,488 | $8,450 | $15,685 | $25,710 | $39,285 | $55,847 |
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 | $80,400 | $58,442 | $39,108 | $17,106 | $5,588 | $7,072 | $1,394 | $1,488 | $8,450 | $15,685 | $25,710 | $39,285 | $55,847 |
Accounts Receivable | $0 | $0 | $8,250 | $18,475 | $25,150 | $37,750 | $52,475 | $61,250 | $67,175 | $75,300 | $84,150 | $92,250 | $96,625 |
Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Current Assets | $80,400 | $58,442 | $47,358 | $35,581 | $30,738 | $44,822 | $53,869 | $62,738 | $75,625 | $90,985 | $109,860 | $131,535 | $152,472 |
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 | $80,400 | $58,442 | $47,358 | $35,581 | $30,738 | $44,822 | $53,869 | $62,738 | $75,625 | $90,985 | $109,860 | $131,535 | $152,472 |
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 | $3,658 | $4,658 | $6,595 | $10,524 | $13,669 | $14,602 | $16,046 | $18,457 | $20,597 | $22,312 | $23,003 |
Current Borrowing | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Other Current Liabilities | $0 | $0 | $0 | $0 | $2,000 | $4,000 | $6,000 | $8,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 |
Subtotal Current Liabilities | $0 | $0 | $3,658 | $4,658 | $8,595 | $14,524 | $19,669 | $22,602 | $26,046 | $28,457 | $30,597 | $32,312 | $33,003 |
Long-term Liabilities | $100,000 | $99,000 | $98,000 | $97,000 | $96,000 | $95,000 | $94,000 | $93,000 | $92,000 | $91,000 | $90,000 | $89,000 | $88,000 |
Total Liabilities | $100,000 | $99,000 | $101,658 | $101,658 | $104,595 | $109,524 | $113,669 | $115,602 | $118,046 | $119,457 | $120,597 | $121,312 | $121,003 |
Paid-in Capital | $230,000 | $230,000 | $230,000 | $230,000 | $230,000 | $240,000 | $240,000 | $240,000 | $240,000 | $240,000 | $240,000 | $240,000 | $240,000 |
Retained Earnings | ($249,600) | ($249,600) | ($249,600) | ($249,600) | ($249,600) | ($249,600) | ($249,600) | ($249,600) | ($249,600) | ($249,600) | ($249,600) | ($249,600) | ($249,600) |
Earnings | $0 | ($20,958) | ($34,700) | ($46,477) | ($54,257) | ($55,102) | ($50,201) | ($43,264) | ($32,821) | ($18,872) | ($1,137) | $19,823 | $41,069 |
Total Capital | ($19,600) | ($40,558) | ($54,300) | ($66,077) | ($73,857) | ($64,702) | ($59,801) | ($52,864) | ($42,421) | ($28,472) | ($10,737) | $10,223 | $31,469 |
Total Liabilities and Capital | $80,400 | $58,442 | $47,358 | $35,581 | $30,738 | $44,822 | $53,869 | $62,738 | $75,625 | $90,985 | $109,860 | $131,535 | $152,472 |
Net Worth | ($19,600) | ($40,558) | ($54,300) | ($66,077) | ($73,857) | ($64,702) | ($59,801) | ($52,864) | ($42,421) | ($28,472) | ($10,738) | $10,223 | $31,469 |