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 |
By 
