Creative Concepts Computer Design

Start your own business plan »

SOHO Computer Consulting 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
Unit Sales
Home PC Unit 0% 10 12 14 17 21 25 30 36 43 52 62 74
Small Business Unit 0% 10 11 12 13 15 16 18 19 21 24 26 29
Other 0% 0 0 0 0 0 0 0 0 0 0 0 0
Total Unit Sales 20 23 27 31 35 41 48 55 64 75 88 103
Unit Prices Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Home PC Unit $30.00 $30.00 $30.00 $30.00 $30.00 $30.00 $30.00 $30.00 $30.00 $30.00 $30.00 $30.00
Small Business Unit $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.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Sales
Home PC Unit $300 $360 $432 $518 $622 $746 $896 $1,075 $1,290 $1,548 $1,858 $2,229
Small Business Unit $300 $330 $363 $399 $439 $483 $531 $585 $643 $707 $778 $856
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales $600 $690 $795 $918 $1,061 $1,230 $1,427 $1,660 $1,933 $2,255 $2,636 $3,085
Direct Unit Costs Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Home PC Unit 0.00% $5.00 $5.00 $5.00 $5.00 $5.00 $5.00 $5.00 $5.00 $5.00 $5.00 $5.00 $5.00
Small Business Unit 0.00% $7.00 $7.00 $7.00 $7.00 $7.00 $7.00 $7.00 $7.00 $7.00 $7.00 $7.00 $7.00
Other 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Direct Cost of Sales
Home PC Unit $50 $60 $72 $86 $104 $124 $149 $179 $215 $258 $310 $372
Small Business Unit $70 $77 $85 $93 $102 $113 $124 $136 $150 $165 $182 $200
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $120 $137 $157 $180 $206 $237 $273 $316 $365 $423 $491 $571
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
Owner 0% $0 $0 $0 $459 $531 $615 $714 $830 $967 $1,128 $1,318 $1,542
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 $0 $0 $0 $459 $531 $615 $714 $830 $967 $1,128 $1,318 $1,542
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% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.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 $600 $690 $795 $918 $1,061 $1,230 $1,427 $1,660 $1,933 $2,255 $2,636 $3,085
Direct Cost of Sales $120 $137 $157 $180 $206 $237 $273 $316 $365 $423 $491 $571
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $120 $137 $157 $180 $206 $237 $273 $316 $365 $423 $491 $571
Gross Margin $480 $553 $638 $738 $855 $992 $1,154 $1,344 $1,568 $1,832 $2,144 $2,514
Gross Margin % 80.00% 80.14% 80.29% 80.43% 80.57% 80.71% 80.85% 80.98% 81.12% 81.24% 81.37% 81.48%
Expenses
Payroll $0 $0 $0 $459 $531 $615 $714 $830 $967 $1,128 $1,318 $1,542
Sales and Marketing and Other Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
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 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Insurance $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Rent $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Payroll Taxes 0% $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
Total Operating Expenses $0 $0 $0 $459 $531 $615 $714 $830 $967 $1,128 $1,318 $1,542
Profit Before Interest and Taxes $480 $553 $638 $279 $324 $378 $440 $514 $601 $705 $827 $971
EBITDA $480 $553 $638 $279 $324 $378 $440 $514 $601 $705 $827 $971
Interest Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Taxes Incurred $144 $138 $160 $70 $81 $94 $110 $129 $150 $176 $207 $243
Net Profit $336 $415 $479 $209 $243 $283 $330 $386 $451 $528 $620 $728
Net Profit/Sales 56.00% 60.11% 60.22% 22.82% 22.93% 23.04% 23.14% 23.24% 23.34% 23.43% 23.52% 23.61%
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 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Cash from Receivables $0 $20 $603 $694 $799 $922 $1,067 $1,236 $1,435 $1,669 $1,944 $2,268
Subtotal Cash from Operations $0 $20 $603 $694 $799 $922 $1,067 $1,236 $1,435 $1,669 $1,944 $2,268
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 $20 $603 $694 $799 $922 $1,067 $1,236 $1,435 $1,669 $1,944 $2,268
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 $0 $0 $0 $459 $531 $615 $714 $830 $967 $1,128 $1,318 $1,542
Bill Payments $9 $264 $277 $314 $251 $289 $333 $385 $446 $518 $602 $702
Subtotal Spent on Operations $9 $264 $277 $773 $781 $904 $1,047 $1,215 $1,413 $1,646 $1,920 $2,244
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 $9 $264 $277 $773 $781 $904 $1,047 $1,215 $1,413 $1,646 $1,920 $2,244
Net Cash Flow ($9) ($244) $326 ($79) $18 $19 $20 $21 $22 $23 $23 $24
Cash Balance $271 $27 $353 $274 $292 $310 $330 $352 $374 $396 $420 $444
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 $280 $271 $27 $353 $274 $292 $310 $330 $352 $374 $396 $420 $444
Accounts Receivable $0 $600 $1,270 $1,462 $1,686 $1,948 $2,256 $2,616 $3,039 $3,537 $4,124 $4,816 $5,633
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $280 $871 $1,297 $1,815 $1,960 $2,240 $2,566 $2,946 $3,391 $3,911 $4,520 $5,236 $6,076
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 $280 $871 $1,297 $1,815 $1,960 $2,240 $2,566 $2,946 $3,391 $3,911 $4,520 $5,236 $6,076
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 $255 $266 $306 $241 $278 $321 $371 $429 $498 $579 $675 $787
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 $255 $266 $306 $241 $278 $321 $371 $429 $498 $579 $675 $787
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $0 $255 $266 $306 $241 $278 $321 $371 $429 $498 $579 $675 $787
Paid-in Capital $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Retained Earnings ($720) ($720) ($720) ($720) ($720) ($720) ($720) ($720) ($720) ($720) ($720) ($720) ($720)
Earnings $0 $336 $751 $1,229 $1,439 $1,682 $1,966 $2,296 $2,681 $3,133 $3,661 $4,281 $5,009
Total Capital $280 $616 $1,031 $1,509 $1,719 $1,962 $2,246 $2,576 $2,961 $3,413 $3,941 $4,561 $5,289
Total Liabilities and Capital $280 $871 $1,297 $1,815 $1,960 $2,240 $2,566 $2,946 $3,391 $3,911 $4,520 $5,236 $6,076
Net Worth $280 $616 $1,031 $1,509 $1,719 $1,962 $2,246 $2,576 $2,961 $3,413 $3,941 $4,561 $5,289