Water Tubes Plumbing
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 |