PC Repair

Start your own business plan »

Computer Repair 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 3 5 3 15 18 20 20 20 17 15 10 20
Small Business Unit 3 3 3 10 25 35 40 45 50 15 10 25
Promo 0 0 10 30 40 0 40 40 40 0 0 35
Maintenance Contracts 0 1 1 2 3 3 3 4 4 3 4 4
Total Unit Sales 6 9 17 57 86 58 103 109 111 33 24 84
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 $280.00 $280.00 $280.00 $280.00 $280.00 $280.00 $280.00 $280.00 $280.00 $280.00 $280.00 $280.00
Small Business Unit $500.00 $500.00 $500.00 $500.00 $500.00 $500.00 $500.00 $500.00 $500.00 $500.00 $500.00 $500.00
Promo $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $50.00
Maintenance Contracts $400.00 $400.00 $400.00 $400.00 $400.00 $400.00 $400.00 $400.00 $400.00 $400.00 $400.00 $400.00
Sales
Home PC Unit $840 $1,400 $840 $4,200 $5,040 $5,600 $5,600 $5,600 $4,760 $4,200 $2,800 $5,600
Small Business Unit $1,500 $1,500 $1,500 $5,000 $12,500 $17,500 $20,000 $22,500 $25,000 $7,500 $5,000 $12,500
Promo $0 $0 $500 $1,500 $2,000 $0 $2,000 $2,000 $2,000 $0 $0 $1,750
Maintenance Contracts $0 $400 $400 $800 $1,200 $1,200 $1,200 $1,600 $1,600 $1,200 $1,600 $1,600
Total Sales $2,340 $3,300 $3,240 $11,500 $20,740 $24,300 $28,800 $31,700 $33,360 $12,900 $9,400 $21,450
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 30.00% $84.00 $84.00 $84.00 $84.00 $84.00 $84.00 $84.00 $84.00 $84.00 $84.00 $84.00 $84.00
Small Business Unit 21.00% $105.00 $105.00 $105.00 $105.00 $105.00 $105.00 $105.00 $105.00 $105.00 $105.00 $105.00 $105.00
Promo 8.00% $4.00 $4.00 $4.00 $4.00 $4.00 $4.00 $4.00 $4.00 $4.00 $4.00 $4.00 $4.00
Maintenance Contracts 12.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 $252 $420 $252 $1,260 $1,512 $1,680 $1,680 $1,680 $1,428 $1,260 $840 $1,680
Small Business Unit $315 $315 $315 $1,050 $2,625 $3,675 $4,200 $4,725 $5,250 $1,575 $1,050 $2,625
Promo $0 $0 $40 $120 $160 $0 $160 $160 $160 $0 $0 $140
Maintenance Contracts $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $567 $735 $607 $2,430 $4,297 $5,355 $6,040 $6,565 $6,838 $2,835 $1,890 $4,445
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% $2,000 $2,000 $2,500 $2,500 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Tech1 0% $0 $0 $0 $2,400 $2,400 $2,400 $2,400 $2,400 $2,400 $2,400 $2,400 $2,400
Tech2 0% $0 $0 $0 $0 $0 $0 $2,400 $2,400 $2,400 $2,400 $2,400 $2,400
Part Time 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 1 1 1 2 2 2 3 3 3 3 3 3
Total Payroll $2,000 $2,000 $2,500 $4,900 $5,400 $5,400 $7,800 $7,800 $7,800 $7,800 $7,800 $7,800
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 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.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 $2,340 $3,300 $3,240 $11,500 $20,740 $24,300 $28,800 $31,700 $33,360 $12,900 $9,400 $21,450
Direct Cost of Sales $567 $735 $607 $2,430 $4,297 $5,355 $6,040 $6,565 $6,838 $2,835 $1,890 $4,445
Costs of Fulfilling Maintenance Contracts $0 $0 $48 $96 $144 $144 $144 $192 $192 $144 $192 $192
Total Cost of Sales $567 $735 $655 $2,526 $4,441 $5,499 $6,184 $6,757 $7,030 $2,979 $2,082 $4,637
Gross Margin $1,773 $2,565 $2,585 $8,974 $16,299 $18,801 $22,616 $24,943 $26,330 $9,921 $7,318 $16,813
Gross Margin % 75.77% 77.73% 79.78% 78.03% 78.59% 77.37% 78.53% 78.68% 78.93% 76.91% 77.85% 78.38%
Expenses
Payroll $2,000 $2,000 $2,500 $4,900 $5,400 $5,400 $7,800 $7,800 $7,800 $7,800 $7,800 $7,800
Marketing/Promotion $4,000 $1,000 $3,000 $2,000 $2,000 $3,000 $3,000 $2,000 $2,000 $2,000 $2,000 $2,000
Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Lease $0 $0 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Expensed Equipment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Insurance $150 $0 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300
Website $40 $40 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Answering Service $200 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Mileage $80 $85 $95 $100 $200 $300 $300 $300 $300 $300 $300 $300
Vehicles $0 $0 $6,000 $800 $800 $800 $800 $800 $800 $800 $800 $800
Cell Phones $0 $60 $120 $120 $120 $120 $120 $120 $120 $120 $120 $120
Utilities $0 $0 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Internet 15% $0 $0 $120 $120 $120 $120 $120 $120 $120 $120 $120 $120
Moving Expenses $0 $0 $2,000 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $6,470 $3,185 $15,835 $10,040 $10,640 $11,740 $14,140 $13,140 $13,140 $13,140 $13,140 $13,140
Profit Before Interest and Taxes ($4,697) ($620) ($13,250) ($1,066) $5,659 $7,061 $8,476 $11,803 $13,190 ($3,219) ($5,822) $3,673
EBITDA ($4,697) ($620) ($13,250) ($1,066) $5,659 $7,061 $8,476 $11,803 $13,190 ($3,219) ($5,822) $3,673
Interest Expense $109 $106 $103 $99 $96 $93 $90 $87 $83 $80 $77 $74
Taxes Incurred ($1,442) ($218) ($4,006) ($350) $1,669 $2,090 $2,516 $3,515 $3,932 ($990) ($1,770) $1,080
Net Profit ($3,364) ($508) ($9,347) ($816) $3,894 $4,878 $5,870 $8,201 $9,175 ($2,309) ($4,129) $2,519
Net Profit/Sales -143.77% -15.39% -288.48% -7.09% 18.78% 20.07% 20.38% 25.87% 27.50% -17.90% -43.93% 11.75%
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 $2,340 $3,300 $3,240 $11,500 $20,740 $24,300 $28,800 $31,700 $33,360 $12,900 $9,400 $21,450
Subtotal Cash from Operations $2,340 $3,300 $3,240 $11,500 $20,740 $24,300 $28,800 $31,700 $33,360 $12,900 $9,400 $21,450
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 $2,340 $3,300 $3,240 $11,500 $20,740 $24,300 $28,800 $31,700 $33,360 $12,900 $9,400 $21,450
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 $2,000 $2,000 $2,500 $4,900 $5,400 $5,400 $7,800 $7,800 $7,800 $7,800 $7,800 $7,800
Bill Payments $105 $3,102 $2,353 $10,424 $8,954 $13,556 $15,209 $15,896 $16,290 $16,282 $4,550 $4,152
Subtotal Spent on Operations $2,105 $5,102 $4,853 $15,324 $14,354 $18,956 $23,009 $23,696 $24,090 $24,082 $12,350 $11,952
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 $547 $547 $547 $547 $547 $547 $547 $547 $547 $547 $547 $547
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 $2,652 $5,649 $5,400 $15,871 $14,901 $19,503 $23,556 $24,243 $24,637 $24,629 $12,897 $12,499
Net Cash Flow ($312) ($2,349) ($2,160) ($4,371) $5,839 $4,797 $5,244 $7,457 $8,723 ($11,729) ($3,497) $8,951
Cash Balance $27,688 $25,340 $23,179 $18,809 $24,647 $29,444 $34,688 $42,145 $50,868 $39,139 $35,642 $44,593
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 $28,000 $27,688 $25,340 $23,179 $18,809 $24,647 $29,444 $34,688 $42,145 $50,868 $39,139 $35,642 $44,593
Inventory $1,200 $633 $898 $1,291 $2,673 $4,727 $5,891 $6,644 $7,222 $7,522 $4,687 $2,797 $4,890
Other Current Assets $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000
Total Current Assets $39,200 $38,321 $36,238 $34,470 $31,482 $39,374 $45,335 $51,332 $59,366 $68,390 $53,826 $48,439 $59,482
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 $39,200 $38,321 $36,238 $34,470 $31,482 $39,374 $45,335 $51,332 $59,366 $68,390 $53,826 $48,439 $59,482
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,033 $2,004 $10,130 $8,505 $13,050 $14,680 $15,354 $15,733 $16,130 $4,422 $3,711 $12,783
Current Borrowing $19,225 $18,678 $18,131 $17,584 $17,037 $16,490 $15,943 $15,396 $14,849 $14,302 $13,755 $13,208 $12,661
Other Current Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Current Liabilities $19,225 $21,711 $20,135 $27,714 $25,542 $29,540 $30,623 $30,750 $30,582 $30,432 $18,177 $16,919 $25,444
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $19,225 $21,711 $20,135 $27,714 $25,542 $29,540 $30,623 $30,750 $30,582 $30,432 $18,177 $16,919 $25,444
Paid-in Capital $23,000 $23,000 $23,000 $23,000 $23,000 $23,000 $23,000 $23,000 $23,000 $23,000 $23,000 $23,000 $23,000
Retained Earnings ($3,025) ($3,025) ($3,025) ($3,025) ($3,025) ($3,025) ($3,025) ($3,025) ($3,025) ($3,025) ($3,025) ($3,025) ($3,025)
Earnings $0 ($3,364) ($3,872) ($13,219) ($14,035) ($10,141) ($5,263) $607 $8,809 $17,983 $15,674 $11,544 $14,064
Total Capital $19,975 $16,611 $16,103 $6,756 $5,940 $9,834 $14,712 $20,582 $28,784 $37,958 $35,649 $31,519 $34,039
Total Liabilities and Capital $39,200 $38,321 $36,238 $34,470 $31,482 $39,374 $45,335 $51,332 $59,366 $68,390 $53,826 $48,439 $59,482
Net Worth $19,975 $16,611 $16,103 $6,756 $5,940 $9,834 $14,712 $20,582 $28,784 $37,958 $35,649 $31,519 $34,039