William's Environmental

Start your own business plan »

Septic Tank 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
Septic Tank Replacement 0% $10,000 $14,000 $17,000 $36,000 $42,000 $35,000 $25,000 $20,000 $8,000 $5,000 $5,000 $20,000
Septic Tank Installation 0% $7,000 $8,000 $10,000 $15,000 $20,000 $20,000 $12,000 $15,000 $3,000 $3,000 $3,000 $14,000
Septic Tank Removal 0% $2,000 $3,000 $4,000 $6,000 $8,000 $8,000 $3,000 $4,000 $2,000 $2,000 $2,000 $5,000
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales $19,000 $25,000 $31,000 $57,000 $70,000 $63,000 $40,000 $39,000 $13,000 $10,000 $10,000 $39,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
Septic Tank Replacement $5,000 $7,000 $8,500 $18,000 $21,000 $17,500 $12,500 $10,000 $4,000 $2,500 $2,500 $10,000
Septic Tank Installation $3,000 $3,500 $4,000 $6,500 $8,000 $8,000 $5,000 $6,500 $1,000 $1,000 $1,000 $5,000
Septic Tank Removal $500 $750 $1,000 $1,500 $2,000 $2,000 $750 $1,000 $500 $500 $500 $1,250
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $8,500 $11,250 $13,500 $26,000 $31,000 $27,500 $18,250 $17,500 $5,500 $4,000 $4,000 $16,250
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
Manager 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
Salesperson 0% $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 Installation/Removal Staff 0% $8,400 $8,400 $8,400 $8,400 $8,400 $8,400 $8,400 $8,400 $8,400 $8,400 $8,400 $8,400
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 3 3 3 3 3 3 3 3 3 3 3 3
Total Payroll $14,900 $14,900 $14,900 $14,900 $14,900 $14,900 $14,900 $14,900 $14,900 $14,900 $14,900 $14,900
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 $19,000 $25,000 $31,000 $57,000 $70,000 $63,000 $40,000 $39,000 $13,000 $10,000 $10,000 $39,000
Direct Cost of Sales $8,500 $11,250 $13,500 $26,000 $31,000 $27,500 $18,250 $17,500 $5,500 $4,000 $4,000 $16,250
Other Production Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $8,500 $11,250 $13,500 $26,000 $31,000 $27,500 $18,250 $17,500 $5,500 $4,000 $4,000 $16,250
Gross Margin $10,500 $13,750 $17,500 $31,000 $39,000 $35,500 $21,750 $21,500 $7,500 $6,000 $6,000 $22,750
Gross Margin % 55.26% 55.00% 56.45% 54.39% 55.71% 56.35% 54.37% 55.13% 57.69% 60.00% 60.00% 58.33%
Expenses
Payroll $14,900 $14,900 $14,900 $14,900 $14,900 $14,900 $14,900 $14,900 $14,900 $14,900 $14,900 $14,900
Sales and Marketing and Other Expenses $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Depreciation $738 $738 $738 $738 $738 $738 $738 $738 $738 $738 $738 $738
Leased Equipment $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500
Utilities $200 $200 $200 $200 $200 $200 $200 $200 $200 $0 $0 $0
Insurance $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Rent $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Payroll Taxes 15% $2,235 $2,235 $2,235 $2,235 $2,235 $2,235 $2,235 $2,235 $2,235 $2,235 $2,235 $2,235
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $22,773 $22,773 $22,773 $22,773 $22,773 $22,773 $22,773 $22,773 $22,773 $22,573 $22,573 $22,573
Profit Before Interest and Taxes ($12,273) ($9,023) ($5,273) $8,227 $16,227 $12,727 ($1,023) ($1,273) ($15,273) ($16,573) ($16,573) $177
EBITDA ($11,535) ($8,285) ($4,535) $8,965 $16,965 $13,465 ($285) ($535) ($14,535) ($15,835) ($15,835) $915
Interest Expense $826 $819 $813 $806 $799 $792 $785 $778 $771 $764 $757 $750
Taxes Incurred $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit ($13,099) ($9,842) ($6,086) $7,421 $15,428 $11,935 ($1,808) ($2,051) ($16,044) ($17,337) ($17,330) ($573)
Net Profit/Sales -68.94% -39.37% -19.63% 13.02% 22.04% 18.94% -4.52% -5.26% -123.41% -173.37% -173.30% -1.47%
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 $9,500 $12,500 $15,500 $28,500 $35,000 $31,500 $20,000 $19,500 $6,500 $5,000 $5,000 $19,500
Cash from Receivables $0 $317 $9,600 $12,600 $15,933 $28,717 $34,883 $31,117 $19,983 $19,067 $6,450 $5,000
Subtotal Cash from Operations $9,500 $12,817 $25,100 $41,100 $50,933 $60,217 $54,883 $50,617 $26,483 $24,067 $11,450 $24,500
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 $9,500 $12,817 $25,100 $41,100 $50,933 $60,217 $54,883 $50,617 $26,483 $24,067 $11,450 $24,500
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 $14,900 $14,900 $14,900 $14,900 $14,900 $14,900 $14,900 $14,900 $14,900 $14,900 $14,900 $14,900
Bill Payments $860 $25,692 $22,286 $24,715 $47,582 $44,005 $31,057 $16,281 $24,032 $7,899 $7,699 $8,638
Subtotal Spent on Operations $15,760 $40,592 $37,186 $39,615 $62,482 $58,905 $45,957 $31,181 $38,932 $22,799 $22,599 $23,538
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 $833 $833 $833 $833 $833 $833 $833 $833 $833 $833 $833 $833
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 $16,593 $41,425 $38,019 $40,448 $63,315 $59,738 $46,790 $32,014 $39,765 $23,632 $23,432 $24,371
Net Cash Flow ($7,093) ($28,608) ($12,919) $652 ($12,382) $479 $8,093 $18,602 ($13,281) $435 ($11,982) $129
Cash Balance $73,707 $45,098 $32,179 $32,832 $20,450 $20,929 $29,022 $47,624 $34,343 $34,777 $22,796 $22,925
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 $80,800 $73,707 $45,098 $32,179 $32,832 $20,450 $20,929 $29,022 $47,624 $34,343 $34,777 $22,796 $22,925
Accounts Receivable $0 $9,500 $21,683 $27,583 $43,483 $62,550 $65,333 $50,450 $38,833 $25,350 $11,283 $9,833 $24,333
Inventory $0 $9,350 $12,375 $14,850 $28,600 $34,100 $30,250 $20,075 $19,250 $13,750 $9,750 $5,750 $17,875
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $80,800 $92,557 $79,157 $74,613 $104,915 $117,100 $116,512 $99,547 $105,707 $73,443 $55,811 $38,379 $65,133
Long-term Assets
Long-term Assets $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000
Accumulated Depreciation $0 $738 $1,476 $2,214 $2,952 $3,690 $4,428 $5,166 $5,904 $6,642 $7,380 $8,118 $8,856
Total Long-term Assets $30,000 $29,262 $28,524 $27,786 $27,048 $26,310 $25,572 $24,834 $24,096 $23,358 $22,620 $21,882 $21,144
Total Assets $110,800 $121,819 $107,681 $102,399 $131,963 $143,410 $142,084 $124,381 $129,803 $96,801 $78,431 $60,261 $86,277
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 $24,951 $21,488 $23,125 $46,101 $42,953 $30,524 $15,462 $23,768 $7,642 $7,442 $7,436 $34,858
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 $24,951 $21,488 $23,125 $46,101 $42,953 $30,524 $15,462 $23,768 $7,642 $7,442 $7,436 $34,858
Long-term Liabilities $100,000 $99,167 $98,334 $97,501 $96,668 $95,835 $95,002 $94,169 $93,336 $92,503 $91,670 $90,837 $90,004
Total Liabilities $100,000 $124,118 $119,822 $120,626 $142,769 $138,788 $125,526 $109,631 $117,104 $100,145 $99,112 $98,273 $124,862
Paid-in Capital $110,000 $110,000 $110,000 $110,000 $110,000 $110,000 $110,000 $110,000 $110,000 $110,000 $110,000 $110,000 $110,000
Retained Earnings ($99,200) ($99,200) ($99,200) ($99,200) ($99,200) ($99,200) ($99,200) ($99,200) ($99,200) ($99,200) ($99,200) ($99,200) ($99,200)
Earnings $0 ($13,099) ($22,942) ($29,027) ($21,606) ($6,178) $5,758 $3,950 $1,899 ($14,145) ($31,482) ($48,812) ($49,385)
Total Capital $10,800 ($2,299) ($12,142) ($18,227) ($10,806) $4,622 $16,558 $14,750 $12,699 ($3,345) ($20,682) ($38,012) ($38,585)
Total Liabilities and Capital $110,800 $121,819 $107,681 $102,399 $131,963 $143,410 $142,084 $124,381 $129,803 $96,801 $78,431 $60,261 $86,277
Net Worth $10,800 ($2,299) ($12,142) ($18,227) ($10,806) $4,622 $16,558 $14,750 $12,699 ($3,345) ($20,682) ($38,012) ($38,585)