Water Tubes Plumbing

Start your own business plan »

Plumbing 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
Non-custom homes 0% $0 $4,000 $8,000 $5,000 $6,000 $6,545 $7,332 $9,876 $11,232 $14,454 $15,654 $16,765
Custom homes 0% $0 $0 $0 $7,000 $4,000 $3,000 $0 $3,500 $2,500 $3,000 $3,500 $2,500
Total Sales $0 $4,000 $8,000 $12,000 $10,000 $9,545 $7,332 $13,376 $13,732 $17,454 $19,154 $19,265
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
Non-custom homes $0 $400 $800 $500 $600 $655 $733 $988 $1,123 $1,445 $1,565 $1,677
Custom homes $0 $0 $0 $700 $400 $300 $0 $350 $250 $300 $350 $250
Subtotal Direct Cost of Sales $0 $400 $800 $1,200 $1,000 $955 $733 $1,338 $1,373 $1,745 $1,915 $1,927
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
Don 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
Journeymen employee 0% $0 $0 $2,880 $2,880 $2,880 $2,880 $2,880 $2,880 $2,880 $2,880 $2,880 $2,880
Apprentice employee 0% $0 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600
Apprentice employee 0% $0 $0 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600 $1,600
Total People 1 2 4 4 4 4 4 4 4 4 4 4
Total Payroll $3,000 $4,600 $9,080 $9,080 $9,080 $9,080 $9,080 $9,080 $9,080 $9,080 $9,080 $9,080
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,000 $8,000 $12,000 $10,000 $9,545 $7,332 $13,376 $13,732 $17,454 $19,154 $19,265
Direct Cost of Sales $0 $400 $800 $1,200 $1,000 $955 $733 $1,338 $1,373 $1,745 $1,915 $1,927
Other Production Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $0 $400 $800 $1,200 $1,000 $955 $733 $1,338 $1,373 $1,745 $1,915 $1,927
Gross Margin $0 $3,600 $7,200 $10,800 $9,000 $8,591 $6,599 $12,038 $12,359 $15,709 $17,239 $17,339
Gross Margin % 0.00% 90.00% 90.00% 90.00% 90.00% 90.00% 90.00% 90.00% 90.00% 90.00% 90.00% 90.00%
Expenses
Payroll $3,000 $4,600 $9,080 $9,080 $9,080 $9,080 $9,080 $9,080 $9,080 $9,080 $9,080 $9,080
Sales and Marketing and Other Expenses $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150
Depreciation $288 $288 $288 $288 $288 $288 $288 $288 $288 $288 $288 $288
Insurance/ License/ Bonds $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Rent $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Payroll Taxes 15% $450 $690 $1,362 $1,362 $1,362 $1,362 $1,362 $1,362 $1,362 $1,362 $1,362 $1,362
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $4,388 $6,228 $11,380 $11,380 $11,380 $11,380 $11,380 $11,380 $11,380 $11,380 $11,380 $11,380
Profit Before Interest and Taxes ($4,388) ($2,628) ($4,180) ($580) ($2,380) ($2,790) ($4,781) $658 $979 $4,329 $5,859 $5,959
EBITDA ($4,100) ($2,340) ($3,892) ($292) ($2,092) ($2,502) ($4,493) $946 $1,267 $4,617 $6,147 $6,247
Interest Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Taxes Incurred $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit ($4,388) ($2,628) ($4,180) ($580) ($2,380) ($2,790) ($4,781) $658 $979 $4,329 $5,859 $5,959
Net Profit/Sales 0.00% -65.70% -52.25% -4.83% -23.80% -29.22% -65.21% 4.92% 7.13% 24.80% 30.59% 30.93%
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,000 $8,000 $12,000 $10,000 $9,545 $7,332 $13,376 $13,732 $17,454 $19,154 $19,265
Subtotal Cash from Operations $0 $4,000 $8,000 $12,000 $10,000 $9,545 $7,332 $13,376 $13,732 $17,454 $19,154 $19,265
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 $4,000 $8,000 $12,000 $10,000 $9,545 $7,332 $13,376 $13,732 $17,454 $19,154 $19,265
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,000 $4,600 $9,080 $9,080 $9,080 $9,080 $9,080 $9,080 $9,080 $9,080 $9,080 $9,080
Bill Payments $37 $1,121 $1,776 $2,825 $3,205 $3,010 $2,959 $2,765 $3,351 $3,398 $3,763 $3,928
Subtotal Spent on Operations $3,037 $5,721 $10,856 $11,905 $12,285 $12,090 $12,039 $11,845 $12,431 $12,478 $12,843 $13,008
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,037 $5,721 $10,856 $11,905 $12,285 $12,090 $12,039 $11,845 $12,431 $12,478 $12,843 $13,008
Net Cash Flow ($3,037) ($1,721) ($2,856) $95 ($2,285) ($2,545) ($4,707) $1,531 $1,301 $4,976 $6,311 $6,257
Cash Balance $16,613 $14,892 $12,036 $12,131 $9,846 $7,300 $2,593 $4,124 $5,425 $10,401 $16,712 $22,969
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 $19,650 $16,613 $14,892 $12,036 $12,131 $9,846 $7,300 $2,593 $4,124 $5,425 $10,401 $16,712 $22,969
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $19,650 $16,613 $14,892 $12,036 $12,131 $9,846 $7,300 $2,593 $4,124 $5,425 $10,401 $16,712 $22,969
Long-term Assets
Long-term Assets $24,000 $24,000 $24,000 $24,000 $24,000 $24,000 $24,000 $24,000 $24,000 $24,000 $24,000 $24,000 $24,000
Accumulated Depreciation $0 $288 $576 $864 $1,152 $1,440 $1,728 $2,016 $2,304 $2,592 $2,880 $3,168 $3,456
Total Long-term Assets $24,000 $23,712 $23,424 $23,136 $22,848 $22,560 $22,272 $21,984 $21,696 $21,408 $21,120 $20,832 $20,544
Total Assets $43,650 $40,325 $38,316 $35,172 $34,979 $32,406 $29,572 $24,577 $25,820 $26,833 $31,521 $37,544 $43,513
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,063 $1,682 $2,718 $3,105 $2,912 $2,868 $2,654 $3,238 $3,272 $3,632 $3,796 $3,807
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,063 $1,682 $2,718 $3,105 $2,912 $2,868 $2,654 $3,238 $3,272 $3,632 $3,796 $3,807
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $0 $1,063 $1,682 $2,718 $3,105 $2,912 $2,868 $2,654 $3,238 $3,272 $3,632 $3,796 $3,807
Paid-in Capital $44,000 $44,000 $44,000 $44,000 $44,000 $44,000 $44,000 $44,000 $44,000 $44,000 $44,000 $44,000 $44,000
Retained Earnings ($350) ($350) ($350) ($350) ($350) ($350) ($350) ($350) ($350) ($350) ($350) ($350) ($350)
Earnings $0 ($4,388) ($7,016) ($11,196) ($11,776) ($14,156) ($16,946) ($21,727) ($21,068) ($20,090) ($15,761) ($9,902) ($3,944)
Total Capital $43,650 $39,262 $36,634 $32,454 $31,874 $29,494 $26,705 $21,923 $22,582 $23,560 $27,889 $33,748 $39,706
Total Liabilities and Capital $43,650 $40,325 $38,316 $35,172 $34,979 $32,406 $29,572 $24,577 $25,820 $26,833 $31,521 $37,544 $43,513
Net Worth $43,650 $39,262 $36,634 $32,454 $31,874 $29,494 $26,705 $21,923 $22,582 $23,560 $27,889 $33,748 $39,706