Safe Current

Start your own business plan »

Electronics Retailer 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
Surge Arrestors 0% $0 $2,000 $2,435 $3,232 $4,090 $4,645 $5,232 $6,121 $6,653 $7,121 $7,434 $7,878
Surge Protectors 0% $0 $1,320 $1,607 $2,133 $2,699 $3,066 $3,453 $4,040 $4,391 $4,700 $4,906 $5,199
Commercial sales 0% $0 $1,320 $1,607 $2,133 $2,699 $3,066 $3,453 $4,040 $4,391 $4,700 $4,906 $5,199
Total Sales $0 $4,640 $5,649 $7,498 $9,489 $10,776 $12,138 $14,201 $15,435 $16,521 $17,247 $18,277
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
Surge Arrestors $0 $560 $682 $905 $1,145 $1,301 $1,465 $1,714 $1,863 $1,994 $2,082 $2,206
Surge Protectors $0 $502 $611 $811 $1,026 $1,165 $1,312 $1,535 $1,669 $1,786 $1,864 $1,976
Commercial sales $0 $436 $530 $704 $891 $1,012 $1,140 $1,333 $1,449 $1,551 $1,619 $1,716
Subtotal Direct Cost of Sales $0 $1,497 $1,823 $2,419 $3,062 $3,477 $3,917 $4,582 $4,980 $5,331 $5,565 $5,897
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
Project Manager 0% $4,200 $4,200 $4,200 $4,200 $4,200 $4,200 $4,200 $4,200 $4,200 $4,200 $4,200 $4,200
Customer service agent 0% $0 $400 $900 $900 $900 $900 $900 $900 $900 $900 $900 $900
Customer service agent 0% $0 $400 $900 $900 $900 $900 $900 $900 $900 $900 $900 $900
Customer service agent 0% $0 $0 $900 $900 $900 $900 $900 $900 $900 $900 $900 $900
Customer service agent 0% $0 $0 $0 $0 $900 $900 $900 $900 $900 $900 $900 $900
Total People 1 3 4 4 5 5 5 5 5 5 5 5
Total Payroll $4,200 $5,000 $6,900 $6,900 $7,800 $7,800 $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 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 $4,640 $5,649 $7,498 $9,489 $10,776 $12,138 $14,201 $15,435 $16,521 $17,247 $18,277
Direct Cost of Sales $0 $1,497 $1,823 $2,419 $3,062 $3,477 $3,917 $4,582 $4,980 $5,331 $5,565 $5,897
Other Costs of Goods $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $0 $1,497 $1,823 $2,419 $3,062 $3,477 $3,917 $4,582 $4,980 $5,331 $5,565 $5,897
Gross Margin $0 $3,143 $3,826 $5,079 $6,427 $7,299 $8,222 $9,619 $10,455 $11,190 $11,682 $12,379
Gross Margin % 0.00% 67.73% 67.73% 67.73% 67.73% 67.73% 67.73% 67.73% 67.73% 67.73% 67.73% 67.73%
Expenses
Payroll $4,200 $5,000 $6,900 $6,900 $7,800 $7,800 $7,800 $7,800 $7,800 $7,800 $7,800 $7,800
Sales and Marketing and Other Expenses $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Depreciation $117 $117 $117 $117 $117 $117 $117 $117 $117 $117 $117 $117
Rent $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
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
Payroll Taxes 15% $630 $750 $1,035 $1,035 $1,170 $1,170 $1,170 $1,170 $1,170 $1,170 $1,170 $1,170
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $5,947 $6,867 $9,052 $9,052 $10,087 $10,087 $10,087 $10,087 $10,087 $10,087 $10,087 $10,087
Profit Before Interest and Taxes ($5,947) ($3,724) ($5,226) ($3,973) ($3,660) ($2,788) ($1,865) ($468) $368 $1,103 $1,595 $2,292
EBITDA ($5,830) ($3,607) ($5,109) ($3,856) ($3,543) ($2,671) ($1,748) ($351) $485 $1,220 $1,712 $2,409
Interest Expense $412 $407 $402 $397 $392 $387 $382 $377 $372 $367 $362 $357
Taxes Incurred $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit ($6,359) ($4,131) ($5,627) ($4,370) ($4,052) ($3,175) ($2,247) ($845) ($4) $736 $1,233 $1,936
Net Profit/Sales 0.00% -89.03% -99.61% -58.28% -42.70% -29.46% -18.51% -5.95% -0.03% 4.46% 7.15% 10.59%
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 $4,640 $5,649 $7,498 $9,489 $10,776 $12,138 $14,201 $15,435 $16,521 $17,247 $18,277
Subtotal Cash from Operations $0 $4,640 $5,649 $7,498 $9,489 $10,776 $12,138 $14,201 $15,435 $16,521 $17,247 $18,277
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 $15,000 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Received $0 $4,640 $5,649 $22,498 $9,489 $10,776 $12,138 $14,201 $15,435 $16,521 $17,247 $18,277
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 $4,200 $5,000 $6,900 $6,900 $7,800 $7,800 $7,800 $7,800 $7,800 $7,800 $7,800 $7,800
Bill Payments $68 $2,150 $5,278 $4,647 $5,535 $6,335 $6,506 $6,982 $7,864 $7,970 $8,256 $8,369
Subtotal Spent on Operations $4,268 $7,150 $12,178 $11,547 $13,335 $14,135 $14,306 $14,782 $15,664 $15,770 $16,056 $16,169
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 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600
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 $4,868 $7,750 $12,778 $12,147 $13,935 $14,735 $14,906 $15,382 $16,264 $16,370 $16,656 $16,769
Net Cash Flow ($4,868) ($3,110) ($7,129) $10,351 ($4,446) ($3,959) ($2,768) ($1,181) ($829) $151 $591 $1,508
Cash Balance $17,032 $13,922 $6,793 $17,144 $12,698 $8,739 $5,971 $4,789 $3,960 $4,111 $4,702 $6,209
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 $21,900 $17,032 $13,922 $6,793 $17,144 $12,698 $8,739 $5,971 $4,789 $3,960 $4,111 $4,702 $6,209
Inventory $0 $0 $1,647 $2,005 $2,661 $3,368 $3,825 $4,308 $5,040 $5,478 $5,864 $6,122 $6,487
Other Current Assets $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Total Current Assets $24,900 $20,032 $18,569 $11,798 $22,805 $19,066 $15,564 $13,279 $12,830 $12,439 $12,975 $13,823 $15,697
Long-term Assets
Long-term Assets $14,500 $14,500 $14,500 $14,500 $14,500 $14,500 $14,500 $14,500 $14,500 $14,500 $14,500 $14,500 $14,500
Accumulated Depreciation $0 $117 $234 $351 $468 $585 $702 $819 $936 $1,053 $1,170 $1,287 $1,404
Total Long-term Assets $14,500 $14,383 $14,266 $14,149 $14,032 $13,915 $13,798 $13,681 $13,564 $13,447 $13,330 $13,213 $13,096
Total Assets $39,400 $34,415 $32,835 $25,947 $36,837 $32,981 $29,362 $26,960 $26,394 $25,886 $26,305 $27,036 $28,793
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 $1,974 $5,124 $4,464 $5,324 $6,119 $6,275 $6,720 $7,599 $7,695 $7,978 $8,076 $8,497
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 $1,974 $5,124 $4,464 $5,324 $6,119 $6,275 $6,720 $7,599 $7,695 $7,978 $8,076 $8,497
Long-term Liabilities $50,000 $49,400 $48,800 $48,200 $47,600 $47,000 $46,400 $45,800 $45,200 $44,600 $44,000 $43,400 $42,800
Total Liabilities $50,000 $51,374 $53,924 $52,664 $52,924 $53,119 $52,675 $52,520 $52,799 $52,295 $51,978 $51,476 $51,297
Paid-in Capital $5,000 $5,000 $5,000 $5,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000
Retained Earnings ($15,600) ($15,600) ($15,600) ($15,600) ($15,600) ($15,600) ($15,600) ($15,600) ($15,600) ($15,600) ($15,600) ($15,600) ($15,600)
Earnings $0 ($6,359) ($10,490) ($16,117) ($20,487) ($24,538) ($27,713) ($29,960) ($30,805) ($30,809) ($30,073) ($28,840) ($26,904)
Total Capital ($10,600) ($16,959) ($21,090) ($26,717) ($16,087) ($20,138) ($23,313) ($25,560) ($26,405) ($26,409) ($25,673) ($24,440) ($22,504)
Total Liabilities and Capital $39,400 $34,415 $32,835 $25,947 $36,837 $32,981 $29,362 $26,960 $26,394 $25,886 $26,305 $27,036 $28,793
Net Worth ($10,600) ($16,959) ($21,090) ($26,717) ($16,087) ($20,138) ($23,313) ($25,560) ($26,405) ($26,409) ($25,673) ($24,440) ($22,504)