Premiere Electric

Start your own business plan »

Electrical Contractor 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
Gardner and Miller Customers 0% $3,000 $4,000 $6,785 $5,300 $5,400 $6,200 $6,302 $7,000 $6,400 $4,900 $4,500 $3,000
New Customers 0% $0 $0 $0 $0 $1,000 $2,500 $3,000 $3,700 $4,000 $3,000 $3,000 $2,000
Total Sales $3,000 $4,000 $6,785 $5,300 $6,400 $8,700 $9,302 $10,700 $10,400 $7,900 $7,500 $5,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
Gardner and Miller Customers $1,050 $1,400 $2,375 $1,855 $1,890 $2,170 $2,206 $2,450 $2,240 $1,715 $1,575 $1,050
New Customers $0 $0 $0 $0 $350 $875 $1,050 $1,295 $1,400 $1,050 $1,050 $700
Subtotal Direct Cost of Sales $1,050 $1,400 $2,375 $1,855 $2,240 $3,045 $3,256 $3,745 $3,640 $2,765 $2,625 $1,750
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
Robin Sullivan 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
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 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,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 $3,000 $4,000 $6,785 $5,300 $6,400 $8,700 $9,302 $10,700 $10,400 $7,900 $7,500 $5,000
Direct Cost of Sales $1,050 $1,400 $2,375 $1,855 $2,240 $3,045 $3,256 $3,745 $3,640 $2,765 $2,625 $1,750
Other Production Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $1,050 $1,400 $2,375 $1,855 $2,240 $3,045 $3,256 $3,745 $3,640 $2,765 $2,625 $1,750
Gross Margin $1,950 $2,600 $4,410 $3,445 $4,160 $5,655 $6,046 $6,955 $6,760 $5,135 $4,875 $3,250
Gross Margin % 65.00% 65.00% 65.00% 65.00% 65.00% 65.00% 65.00% 65.00% 65.00% 65.00% 65.00% 65.00%
Expenses
Payroll $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 and Marketing and Other Expenses $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $0
Depreciation $229 $229 $229 $229 $229 $229 $229 $229 $229 $229 $229 $229
Leased Equipment $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Utilities $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Insurance $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Rent $1,000 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Payroll Taxes 15% $525 $525 $525 $525 $525 $525 $525 $525 $525 $525 $525 $525
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $6,554 $6,054 $6,054 $6,054 $6,054 $6,054 $6,054 $6,054 $6,054 $6,054 $6,054 $5,954
Profit Before Interest and Taxes ($4,604) ($3,454) ($1,644) ($2,609) ($1,894) ($399) ($8) $901 $706 ($919) ($1,179) ($2,704)
EBITDA ($4,375) ($3,225) ($1,415) ($2,380) ($1,665) ($170) $221 $1,130 $935 ($690) ($950) ($2,475)
Interest Expense $183 $183 $183 $183 $183 $183 $183 $183 $183 $183 $183 $183
Taxes Incurred $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit ($4,787) ($3,637) ($1,827) ($2,792) ($2,077) ($582) ($191) $718 $523 ($1,102) ($1,362) ($2,887)
Net Profit/Sales -159.58% -90.93% -26.93% -52.69% -32.46% -6.69% -2.05% 6.71% 5.03% -13.95% -18.16% -57.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 $750 $1,000 $1,696 $1,325 $1,600 $2,175 $2,326 $2,675 $2,600 $1,975 $1,875 $1,250
Cash from Receivables $0 $75 $2,275 $3,070 $5,052 $4,003 $4,858 $6,540 $7,011 $8,018 $7,738 $5,915
Subtotal Cash from Operations $750 $1,075 $3,971 $4,395 $6,652 $6,178 $7,183 $9,215 $9,611 $9,993 $9,613 $7,165
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 $750 $1,075 $3,971 $4,395 $6,652 $6,178 $7,183 $9,215 $9,611 $9,993 $9,613 $7,165
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 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500
Bill Payments $135 $4,053 $3,941 $4,866 $4,376 $4,775 $5,560 $5,780 $6,250 $6,119 $5,269 $5,101
Subtotal Spent on Operations $3,635 $7,553 $7,441 $8,366 $7,876 $8,275 $9,060 $9,280 $9,750 $9,619 $8,769 $8,601
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 $3,635 $7,553 $7,441 $8,366 $7,876 $8,275 $9,060 $9,280 $9,750 $9,619 $8,769 $8,601
Net Cash Flow ($2,885) ($6,478) ($3,470) ($3,971) ($1,225) ($2,098) ($1,877) ($65) ($138) $373 $844 ($1,436)
Cash Balance $26,815 $20,336 $16,867 $12,896 $11,671 $9,573 $7,696 $7,631 $7,492 $7,866 $8,710 $7,274
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 $29,700 $26,815 $20,336 $16,867 $12,896 $11,671 $9,573 $7,696 $7,631 $7,492 $7,866 $8,710 $7,274
Accounts Receivable $0 $2,250 $5,175 $7,989 $8,894 $8,643 $11,165 $13,284 $14,769 $15,558 $13,465 $11,353 $9,188
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $29,700 $29,065 $25,511 $24,856 $21,790 $20,314 $20,738 $20,980 $22,400 $23,050 $21,331 $20,062 $16,461
Long-term Assets
Long-term Assets $22,000 $22,000 $22,000 $22,000 $22,000 $22,000 $22,000 $22,000 $22,000 $22,000 $22,000 $22,000 $22,000
Accumulated Depreciation $0 $229 $458 $687 $916 $1,145 $1,374 $1,603 $1,832 $2,061 $2,290 $2,519 $2,748
Total Long-term Assets $22,000 $21,771 $21,542 $21,313 $21,084 $20,855 $20,626 $20,397 $20,168 $19,939 $19,710 $19,481 $19,252
Total Assets $51,700 $50,836 $47,053 $46,169 $42,874 $41,169 $41,364 $41,377 $42,568 $42,989 $41,041 $39,543 $35,713
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,923 $3,778 $4,720 $4,218 $4,590 $5,368 $5,572 $6,045 $5,943 $5,098 $4,962 $4,020
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,923 $3,778 $4,720 $4,218 $4,590 $5,368 $5,572 $6,045 $5,943 $5,098 $4,962 $4,020
Long-term Liabilities $22,000 $22,000 $22,000 $22,000 $22,000 $22,000 $22,000 $22,000 $22,000 $22,000 $22,000 $22,000 $22,000
Total Liabilities $22,000 $25,923 $25,778 $26,720 $26,218 $26,590 $27,368 $27,572 $28,045 $27,943 $27,098 $26,962 $26,020
Paid-in Capital $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000
Retained Earnings ($10,300) ($10,300) ($10,300) ($10,300) ($10,300) ($10,300) ($10,300) ($10,300) ($10,300) ($10,300) ($10,300) ($10,300) ($10,300)
Earnings $0 ($4,787) ($8,425) ($10,252) ($13,044) ($15,121) ($15,704) ($15,895) ($15,177) ($14,654) ($15,757) ($17,119) ($20,006)
Total Capital $29,700 $24,913 $21,275 $19,448 $16,656 $14,579 $13,996 $13,805 $14,523 $15,046 $13,943 $12,581 $9,694
Total Liabilities and Capital $51,700 $50,836 $47,053 $46,169 $42,874 $41,169 $41,364 $41,377 $42,568 $42,989 $41,041 $39,543 $35,713
Net Worth $29,700 $24,913 $21,275 $19,448 $16,656 $14,579 $13,996 $13,805 $14,523 $15,046 $13,943 $12,581 $9,694