William's Environmental
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) |