TTR Data Recovery

Start your own business plan »

Data Recovery Services 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
VARs 0% $0 $10,000 $10,000 $12,000 $16,000 $18,000 $25,000 $29,000 $33,000 $25,000 $20,000 $22,000
IT Units 0% $0 $5,000 $4,000 $6,000 $8,000 $11,000 $16,000 $22,000 $25,000 $16,000 $18,000 $17,000
Total Sales $0 $15,000 $14,000 $18,000 $24,000 $29,000 $41,000 $51,000 $58,000 $41,000 $38,000 $39,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
VARs $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
IT Units $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
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
Customer Service/Clerical (1) 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
Data Recovery Staff (3) 0% $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000
Sales 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
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 6 6 6 6 6 6 6 6 6 6 6 6
Total Payroll $18,000 $18,000 $18,000 $18,000 $18,000 $18,000 $18,000 $18,000 $18,000 $18,000 $18,000 $18,000
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 $15,000 $14,000 $18,000 $24,000 $29,000 $41,000 $51,000 $58,000 $41,000 $38,000 $39,000
Direct Cost of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other Production Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Gross Margin $0 $15,000 $14,000 $18,000 $24,000 $29,000 $41,000 $51,000 $58,000 $41,000 $38,000 $39,000
Gross Margin % 0.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00%
Expenses
Payroll $18,000 $18,000 $18,000 $18,000 $18,000 $18,000 $18,000 $18,000 $18,000 $18,000 $18,000 $18,000
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 $240 $240 $240 $240 $240 $240 $240 $240 $240 $240 $240 $240
Leased Equipment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Utilities $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Insurance $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Rent $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Payroll Taxes 15% $2,700 $2,700 $2,700 $2,700 $2,700 $2,700 $2,700 $2,700 $2,700 $2,700 $2,700 $2,700
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $26,440 $26,440 $26,440 $26,440 $26,440 $26,440 $26,440 $26,440 $26,440 $26,440 $26,440 $26,440
Profit Before Interest and Taxes ($26,440) ($11,440) ($12,440) ($8,440) ($2,440) $2,560 $14,560 $24,560 $31,560 $14,560 $11,560 $12,560
EBITDA ($26,200) ($11,200) ($12,200) ($8,200) ($2,200) $2,800 $14,800 $24,800 $31,800 $14,800 $11,800 $12,800
Interest Expense $824 $814 $804 $794 $784 $774 $765 $755 $745 $735 $725 $715
Taxes Incurred ($8,179) ($3,676) ($3,973) ($2,770) ($967) $536 $4,139 $7,142 $9,245 $4,148 $3,250 $3,553
Net Profit ($19,084) ($8,578) ($9,271) ($6,464) ($2,257) $1,250 $9,657 $16,664 $21,571 $9,678 $7,584 $8,291
Net Profit/Sales 0.00% -57.18% -66.22% -35.91% -9.40% 4.31% 23.55% 32.67% 37.19% 23.60% 19.96% 21.26%
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 $3,750 $3,500 $4,500 $6,000 $7,250 $10,250 $12,750 $14,500 $10,250 $9,500 $9,750
Cash from Receivables $0 $0 $375 $11,225 $10,600 $13,650 $18,125 $22,050 $31,000 $38,425 $43,075 $30,675
Subtotal Cash from Operations $0 $3,750 $3,875 $15,725 $16,600 $20,900 $28,375 $34,800 $45,500 $48,675 $52,575 $40,425
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 $0 $0 $0 $0 $0 $0
Subtotal Cash Received $0 $3,750 $3,875 $15,725 $16,600 $20,900 $28,375 $34,800 $45,500 $48,675 $52,575 $40,425
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 $18,000 $18,000 $18,000 $18,000 $18,000 $18,000 $18,000 $18,000 $18,000 $18,000 $18,000 $18,000
Bill Payments $28 $994 $5,327 $5,070 $6,284 $8,067 $9,630 $13,203 $16,166 $18,019 $13,052 $12,185
Subtotal Spent on Operations $18,028 $18,994 $23,327 $23,070 $24,284 $26,067 $27,630 $31,203 $34,166 $36,019 $31,052 $30,185
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,180 $1,180 $1,180 $1,180 $1,180 $1,180 $1,180 $1,180 $1,180 $1,180 $1,180 $1,180
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 $19,208 $20,174 $24,507 $24,250 $25,464 $27,247 $28,810 $32,383 $35,346 $37,199 $32,232 $31,365
Net Cash Flow ($19,208) ($16,424) ($20,632) ($8,525) ($8,864) ($6,347) ($435) $2,417 $10,154 $11,476 $20,343 $9,060
Cash Balance $142,992 $126,568 $105,935 $97,410 $88,546 $82,200 $81,765 $84,182 $94,336 $105,812 $126,154 $135,214
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 $162,200 $142,992 $126,568 $105,935 $97,410 $88,546 $82,200 $81,765 $84,182 $94,336 $105,812 $126,154 $135,214
Accounts Receivable $0 $0 $11,250 $21,375 $23,650 $31,050 $39,150 $51,775 $67,975 $80,475 $72,800 $58,225 $56,800
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $162,200 $142,992 $137,818 $127,310 $121,060 $119,596 $121,350 $133,540 $152,157 $174,811 $178,612 $184,379 $192,014
Long-term Assets
Long-term Assets $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000
Accumulated Depreciation $0 $240 $480 $720 $960 $1,200 $1,440 $1,680 $1,920 $2,160 $2,400 $2,640 $2,880
Total Long-term Assets $100,000 $99,760 $99,520 $99,280 $99,040 $98,800 $98,560 $98,320 $98,080 $97,840 $97,600 $97,360 $97,120
Total Assets $262,200 $242,752 $237,338 $226,590 $220,100 $218,396 $219,910 $231,860 $250,237 $272,651 $276,212 $281,739 $289,134
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 $816 $5,160 $4,863 $6,016 $7,750 $9,193 $12,666 $15,560 $17,583 $12,646 $11,770 $12,053
Current Borrowing $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other Current Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Current Liabilities $0 $816 $5,160 $4,863 $6,016 $7,750 $9,193 $12,666 $15,560 $17,583 $12,646 $11,770 $12,053
Long-term Liabilities $100,000 $98,820 $97,640 $96,460 $95,280 $94,100 $92,920 $91,740 $90,560 $89,380 $88,200 $87,020 $85,840
Total Liabilities $100,000 $99,636 $102,800 $101,323 $101,296 $101,850 $102,113 $104,406 $106,120 $106,963 $100,846 $98,790 $97,893
Paid-in Capital $250,000 $250,000 $250,000 $250,000 $250,000 $250,000 $250,000 $250,000 $250,000 $250,000 $250,000 $250,000 $250,000
Retained Earnings ($87,800) ($87,800) ($87,800) ($87,800) ($87,800) ($87,800) ($87,800) ($87,800) ($87,800) ($87,800) ($87,800) ($87,800) ($87,800)
Earnings $0 ($19,084) ($27,662) ($36,933) ($43,397) ($45,653) ($44,403) ($34,747) ($18,083) $3,488 $13,165 $20,750 $29,041
Total Capital $162,200 $143,116 $134,538 $125,267 $118,804 $116,547 $117,797 $127,453 $144,117 $165,688 $175,365 $182,950 $191,241
Total Liabilities and Capital $262,200 $242,752 $237,338 $226,590 $220,100 $218,396 $219,910 $231,860 $250,237 $272,651 $276,212 $281,739 $289,134
Net Worth $162,200 $143,116 $134,538 $125,267 $118,803 $116,547 $117,797 $127,453 $144,117 $165,688 $175,365 $182,950 $191,241