Crest Systems

Start your own business plan »

Computers Reseller 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
Promerit Inventory Basic 0% $0 $0 $70,000 $80,000 $120,000 $120,000 $160,000 $160,000 $160,000 $140,000 $200,000 $240,000
Hardware 0% $0 $0 $54,000 $60,000 $75,000 $75,000 $105,000 $105,000 $105,000 $80,000 $100,000 $150,000
Software Modules 0% $0 $0 $0 $11,000 $13,000 $15,000 $15,000 $15,000 $15,000 $10,000 $15,000 $20,000
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales $0 $0 $124,000 $151,000 $208,000 $210,000 $280,000 $280,000 $280,000 $230,000 $315,000 $410,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
Promerit Inventory Basic $0 $0 $57,000 $60,000 $90,000 $90,000 $120,000 $120,000 $120,000 $90,000 $150,000 $190,000
Hardware $0 $0 $36,000 $40,000 $50,000 $50,000 $63,000 $63,000 $63,000 $50,000 $65,000 $100,000
Software Modules $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 $93,000 $100,000 $140,000 $140,000 $183,000 $183,000 $183,000 $140,000 $215,000 $290,000
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% $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
Accounting Manager 0% $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500
Sales Staff 0% $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000
Software Engineers 0% $5,000 $5,000 $5,000 $5,000 $5,000 $0 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000
Other 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 $28,500 $28,500 $28,500 $28,500 $28,500 $23,500 $33,500 $33,500 $33,500 $33,500 $33,500 $33,500
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 $0 $124,000 $151,000 $208,000 $210,000 $280,000 $280,000 $280,000 $230,000 $315,000 $410,000
Direct Cost of Sales $0 $0 $93,000 $100,000 $140,000 $140,000 $183,000 $183,000 $183,000 $140,000 $215,000 $290,000
Other Production Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $0 $0 $93,000 $100,000 $140,000 $140,000 $183,000 $183,000 $183,000 $140,000 $215,000 $290,000
Gross Margin $0 $0 $31,000 $51,000 $68,000 $70,000 $97,000 $97,000 $97,000 $90,000 $100,000 $120,000
Gross Margin % 0.00% 0.00% 25.00% 33.77% 32.69% 33.33% 34.64% 34.64% 34.64% 39.13% 31.75% 29.27%
Expenses
Payroll $28,500 $28,500 $28,500 $28,500 $28,500 $23,500 $33,500 $33,500 $33,500 $33,500 $33,500 $33,500
Sales and Marketing and Other Expenses $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,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 $140 $140 $140 $140 $140 $140 $140 $140 $140 $140 $140 $140
Insurance $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
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% $4,275 $4,275 $4,275 $4,275 $4,275 $3,525 $5,025 $5,025 $5,025 $5,025 $5,025 $5,025
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $44,915 $44,915 $44,915 $44,915 $44,915 $39,165 $50,665 $50,665 $50,665 $50,665 $50,665 $50,665
Profit Before Interest and Taxes ($44,915) ($44,915) ($13,915) $6,085 $23,085 $30,835 $46,335 $46,335 $46,335 $39,335 $49,335 $69,335
EBITDA ($44,915) ($44,915) ($13,915) $6,085 $23,085 $30,835 $46,335 $46,335 $46,335 $39,335 $49,335 $69,335
Interest Expense $819 $805 $791 $777 $763 $749 $735 $721 $707 $693 $679 $665
Taxes Incurred ($13,720) ($13,716) ($4,412) $1,592 $6,697 $9,026 $13,680 $13,684 $13,688 $11,593 $14,597 $20,601
Net Profit ($32,014) ($32,004) ($10,294) $3,716 $15,625 $21,060 $31,920 $31,930 $31,940 $27,050 $34,059 $48,069
Net Profit/Sales 0.00% 0.00% -8.30% 2.46% 7.51% 10.03% 11.40% 11.40% 11.41% 11.76% 10.81% 11.72%
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 $0 $31,000 $37,750 $52,000 $52,500 $70,000 $70,000 $70,000 $57,500 $78,750 $102,500
Cash from Receivables $0 $0 $0 $3,100 $93,675 $114,675 $156,050 $159,250 $210,000 $210,000 $208,750 $174,625
Subtotal Cash from Operations $0 $0 $31,000 $40,850 $145,675 $167,175 $226,050 $229,250 $280,000 $267,500 $287,500 $277,125
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 $66,000 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Received $0 $0 $31,000 $106,850 $145,675 $167,175 $226,050 $229,250 $280,000 $267,500 $287,500 $277,125
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 $28,500 $28,500 $28,500 $28,500 $28,500 $23,500 $33,500 $33,500 $33,500 $33,500 $33,500 $33,500
Bill Payments $117 $3,514 $6,914 $106,227 $120,287 $163,927 $167,078 $214,580 $214,570 $213,057 $172,050 $250,140
Subtotal Spent on Operations $28,617 $32,014 $35,414 $134,727 $148,787 $187,427 $200,578 $248,080 $248,070 $246,557 $205,550 $283,640
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,688 $1,688 $1,688 $1,688 $1,688 $1,688 $1,688 $1,688 $1,688 $1,688 $1,688 $1,688
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 $30,305 $33,702 $37,102 $136,415 $150,475 $189,115 $202,266 $249,768 $249,758 $248,245 $207,238 $285,328
Net Cash Flow ($30,305) ($33,702) ($6,102) ($29,565) ($4,800) ($21,940) $23,784 ($20,518) $30,242 $19,255 $80,262 ($8,203)
Cash Balance $103,395 $69,693 $63,591 $34,026 $29,226 $7,286 $31,070 $10,553 $40,795 $60,050 $140,312 $132,109
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 $133,700 $103,395 $69,693 $63,591 $34,026 $29,226 $7,286 $31,070 $10,553 $40,795 $60,050 $140,312 $132,109
Accounts Receivable $0 $0 $0 $93,000 $203,150 $265,475 $308,300 $362,250 $413,000 $413,000 $375,500 $403,000 $535,875
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $133,700 $103,395 $69,693 $156,591 $237,176 $294,701 $315,586 $393,320 $423,553 $453,795 $435,550 $543,312 $667,984
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 $133,700 $103,395 $69,693 $156,591 $237,176 $294,701 $315,586 $393,320 $423,553 $453,795 $435,550 $543,312 $667,984
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 $3,397 $3,387 $102,268 $114,825 $158,412 $159,925 $207,427 $207,418 $207,408 $163,802 $239,193 $317,483
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 $3,397 $3,387 $102,268 $114,825 $158,412 $159,925 $207,427 $207,418 $207,408 $163,802 $239,193 $317,483
Long-term Liabilities $100,000 $98,312 $96,624 $94,936 $93,248 $91,560 $89,872 $88,184 $86,496 $84,808 $83,120 $81,432 $79,744
Total Liabilities $100,000 $101,709 $100,011 $197,204 $208,073 $249,972 $249,797 $295,611 $293,914 $292,216 $246,922 $320,625 $397,227
Paid-in Capital $50,000 $50,000 $50,000 $50,000 $116,000 $116,000 $116,000 $116,000 $116,000 $116,000 $116,000 $116,000 $116,000
Retained Earnings ($16,300) ($16,300) ($16,300) ($16,300) ($16,300) ($16,300) ($16,300) ($16,300) ($16,300) ($16,300) ($16,300) ($16,300) ($16,300)
Earnings $0 ($32,014) ($64,018) ($74,312) ($70,597) ($54,971) ($33,911) ($1,991) $29,939 $61,879 $88,928 $122,988 $171,057
Total Capital $33,700 $1,686 ($30,318) ($40,612) $29,103 $44,729 $65,789 $97,709 $129,639 $161,579 $188,628 $222,688 $270,757
Total Liabilities and Capital $133,700 $103,395 $69,693 $156,591 $237,176 $294,701 $315,586 $393,320 $423,553 $453,795 $435,550 $543,312 $667,984
Net Worth $33,700 $1,686 ($30,318) ($40,612) $29,103 $44,729 $65,789 $97,709 $129,639 $161,579 $188,628 $222,688 $270,757