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
Creative Concepts Computer Design soho computer consulting business plan appendix. Creative Concepts Computer Design offers consulting services focused on the computer system needs of small business offices and home office users.