Electronic Detectives

Start your own business plan »

Data Recovery 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
Malpractice lawsuits 0% $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $5,000 $7,000 $7,000 $9,000 $9,000 $9,000
Corporate/business lawsuits 0% $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $5,000 $5,000 $5,000 $9,000 $11,000 $13,000
Intellectual property lawsuits 0% $0 $0 $0 $0 $0 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
General practice lawsuits 0% $0 $0 $0 $0 $2,000 $2,000 $3,000 $4,000 $4,000 $5,000 $5,000 $5,000
Environmental lawsuits 0% $0 $0 $0 $0 $0 $0 $5,000 $6,000 $6,000 $6,000 $6,000 $6,000
Total Sales $7,000 $7,000 $7,000 $7,000 $9,000 $11,000 $20,000 $24,000 $24,000 $31,000 $33,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. Radcliffe - 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
Mrs. Walters - CFO 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. Rinke - Operations 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. Orcott - Law 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
Computer Forensics Analyst 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
Computer Forensics Analyst 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
Computer Forensics Analyst 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Computer Forensics Analyst 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 0 0 0 0 0 0 0 0 0 0 0 0
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 $7,000 $7,000 $7,000 $7,000 $9,000 $11,000 $20,000 $24,000 $24,000 $31,000 $33,000 $35,000
Direct Cost of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other Costs of Sales $500 $500 $500 $500 $500 $600 $700 $1,000 $2,000 $2,000 $2,000 $5,000
Total Cost of Sales $500 $500 $500 $500 $500 $600 $700 $1,000 $2,000 $2,000 $2,000 $5,000
Gross Margin $6,500 $6,500 $6,500 $6,500 $8,500 $10,400 $19,300 $23,000 $22,000 $29,000 $31,000 $30,000
Gross Margin % 92.86% 92.86% 92.86% 92.86% 94.44% 94.55% 96.50% 95.83% 91.67% 93.55% 93.94% 85.71%
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 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500
Depreciation $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
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
Utilities $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Insurance $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Travel $600 $0 $600 $1,000 $1,000 $0 $1,000 $0 $1,000 $1,000 $1,000 $1,000
Payroll Taxes 15% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600
Total Operating Expenses $25,400 $24,800 $25,400 $25,800 $25,800 $24,800 $25,800 $24,800 $25,800 $25,800 $25,800 $25,800
Profit Before Interest and Taxes ($18,900) ($18,300) ($18,900) ($19,300) ($17,300) ($14,400) ($6,500) ($1,800) ($3,800) $3,200 $5,200 $4,200
EBITDA ($18,700) ($18,100) ($18,700) ($19,100) ($17,100) ($14,200) ($6,300) ($1,600) ($3,600) $3,400 $5,400 $4,400
Interest Expense $1,417 $1,417 $1,417 $1,417 $1,417 $1,417 $1,417 $1,417 $1,417 $1,417 $1,417 $1,417
Taxes Incurred $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit ($20,317) ($19,717) ($20,317) ($20,717) ($18,717) ($15,817) ($7,917) ($3,217) ($5,217) $1,783 $3,783 $2,783
Net Profit/Sales -290.24% -281.67% -290.24% -295.95% -207.96% -143.79% -39.58% -13.40% -21.74% 5.75% 11.46% 7.95%
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,750 $1,750 $1,750 $1,750 $2,250 $2,750 $5,000 $6,000 $6,000 $7,750 $8,250 $8,750
Cash from Receivables $0 $175 $5,250 $5,250 $5,250 $5,300 $6,800 $8,475 $15,100 $18,000 $18,175 $23,300
Subtotal Cash from Operations $1,750 $1,925 $7,000 $7,000 $7,500 $8,050 $11,800 $14,475 $21,100 $25,750 $26,425 $32,050
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 $1,750 $1,925 $7,000 $7,000 $7,500 $8,050 $11,800 $14,475 $21,100 $25,750 $26,425 $32,050
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 $44,054 $9,097 $8,537 $9,130 $9,517 $9,487 $8,653 $9,693 $9,083 $11,017 $11,017 $11,117
Subtotal Spent on Operations $62,054 $27,097 $26,537 $27,130 $27,517 $27,487 $26,653 $27,693 $27,083 $29,017 $29,017 $29,117
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 $62,054 $27,097 $26,537 $27,130 $27,517 $27,487 $26,653 $27,693 $27,083 $29,017 $29,017 $29,117
Net Cash Flow ($60,304) ($25,172) ($19,537) ($20,130) ($20,017) ($19,437) ($14,853) ($13,218) ($5,983) ($3,267) ($2,592) $2,933
Cash Balance $281,246 $256,074 $236,538 $216,408 $196,391 $176,954 $162,101 $148,883 $142,899 $139,633 $137,041 $139,974
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 $341,550 $281,246 $256,074 $236,538 $216,408 $196,391 $176,954 $162,101 $148,883 $142,899 $139,633 $137,041 $139,974
Accounts Receivable $0 $5,250 $10,325 $10,325 $10,325 $11,825 $14,775 $22,975 $32,500 $35,400 $40,650 $47,225 $50,175
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $341,550 $286,496 $266,399 $246,863 $226,733 $208,216 $191,729 $185,076 $181,383 $178,299 $180,283 $184,266 $190,149
Long-term Assets
Long-term Assets $128,000 $128,000 $128,000 $128,000 $128,000 $128,000 $128,000 $128,000 $128,000 $128,000 $128,000 $128,000 $128,000
Accumulated Depreciation $0 $200 $400 $600 $800 $1,000 $1,200 $1,400 $1,600 $1,800 $2,000 $2,200 $2,400
Total Long-term Assets $128,000 $127,800 $127,600 $127,400 $127,200 $127,000 $126,800 $126,600 $126,400 $126,200 $126,000 $125,800 $125,600
Total Assets $469,550 $414,296 $393,999 $374,263 $353,933 $335,216 $318,529 $311,676 $307,783 $304,499 $306,283 $310,066 $315,749
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 $43,750 $8,813 $8,233 $8,813 $9,199 $9,199 $8,329 $9,393 $8,716 $10,649 $10,649 $10,649 $13,549
Current Borrowing $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000
Other Current Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Current Liabilities $93,750 $58,813 $58,233 $58,813 $59,199 $59,199 $58,329 $59,393 $58,716 $60,649 $60,649 $60,649 $63,549
Long-term Liabilities $120,000 $120,000 $120,000 $120,000 $120,000 $120,000 $120,000 $120,000 $120,000 $120,000 $120,000 $120,000 $120,000
Total Liabilities $213,750 $178,813 $178,233 $178,813 $179,199 $179,199 $178,329 $179,393 $178,716 $180,649 $180,649 $180,649 $183,549
Paid-in Capital $297,000 $297,000 $297,000 $297,000 $297,000 $297,000 $297,000 $297,000 $297,000 $297,000 $297,000 $297,000 $297,000
Retained Earnings ($41,200) ($41,200) ($41,200) ($41,200) ($41,200) ($41,200) ($41,200) ($41,200) ($41,200) ($41,200) ($41,200) ($41,200) ($41,200)
Earnings $0 ($20,317) ($40,033) ($60,350) ($81,067) ($99,783) ($115,600) ($123,517) ($126,733) ($131,950) ($130,167) ($126,383) ($123,600)
Total Capital $255,800 $235,483 $215,767 $195,450 $174,733 $156,017 $140,200 $132,283 $129,067 $123,850 $125,633 $129,417 $132,200
Total Liabilities and Capital $469,550 $414,296 $393,999 $374,263 $353,933 $335,216 $318,529 $311,676 $307,783 $304,499 $306,283 $310,066 $315,749
Net Worth $255,800 $235,483 $215,767 $195,450 $174,733 $156,017 $140,200 $132,283 $129,067 $123,850 $125,633 $129,417 $132,200