Water Factory

Start your own business plan »

MLM Water Filter 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
Personal contacts 0% $0 $784 $1,025 $1,354 $3,204 $3,654 $3,841 $4,215 $4,687 $5,124 $5,325 $5,878
Recurring revenue stream 0% $0 $0 $0 $0 $0 $125 $135 $187 $265 $365 $458 $654
Total Sales $0 $784 $1,025 $1,354 $3,204 $3,779 $3,976 $4,402 $4,952 $5,489 $5,783 $6,532
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
Personal contacts $0 $392 $513 $677 $1,602 $1,827 $1,921 $2,108 $2,344 $2,562 $2,663 $2,939
Recurring revenue stream $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $0 $392 $513 $677 $1,602 $1,827 $1,921 $2,108 $2,344 $2,562 $2,663 $2,939
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
Aitch Tuoo 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
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 0 0 0 0 0 0 0 0 0 0 0 0
Total Payroll $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
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% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.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 $784 $1,025 $1,354 $3,204 $3,779 $3,976 $4,402 $4,952 $5,489 $5,783 $6,532
Direct Cost of Sales $0 $392 $513 $677 $1,602 $1,827 $1,921 $2,108 $2,344 $2,562 $2,663 $2,939
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $0 $392 $513 $677 $1,602 $1,827 $1,921 $2,108 $2,344 $2,562 $2,663 $2,939
Gross Margin $0 $392 $513 $677 $1,602 $1,952 $2,056 $2,295 $2,609 $2,927 $3,121 $3,593
Gross Margin % 0.00% 50.00% 50.00% 50.00% 50.00% 51.65% 51.70% 52.12% 52.68% 53.32% 53.96% 55.01%
Expenses
Payroll $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Sales and Marketing and Other Expenses $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50
Depreciation $64 $64 $64 $64 $64 $64 $64 $64 $64 $64 $64 $64
Leased Equipment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Utilities $75 $75 $75 $75 $75 $75 $75 $75 $75 $75 $75 $75
Insurance $60 $60 $60 $60 $60 $60 $60 $60 $60 $60 $60 $60
Rent $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Payroll Taxes 15% $450 $450 $450 $450 $450 $450 $450 $450 $450 $450 $450 $450
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $3,699 $3,699 $3,699 $3,699 $3,699 $3,699 $3,699 $3,699 $3,699 $3,699 $3,699 $3,699
Profit Before Interest and Taxes ($3,699) ($3,307) ($3,187) ($3,022) ($2,097) ($1,747) ($1,644) ($1,405) ($1,091) ($772) ($579) ($106)
EBITDA ($3,635) ($3,243) ($3,123) ($2,958) ($2,033) ($1,683) ($1,580) ($1,341) ($1,027) ($708) ($515) ($42)
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 ($3,699) ($3,307) ($3,187) ($3,022) ($2,097) ($1,747) ($1,644) ($1,405) ($1,091) ($772) ($579) ($106)
Net Profit/Sales 0.00% -421.81% -310.88% -223.19% -65.45% -46.23% -41.34% -31.91% -22.02% -14.06% -10.00% -1.62%
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 $784 $1,025 $1,354 $3,204 $3,779 $3,976 $4,402 $4,952 $5,489 $5,783 $6,532
Subtotal Cash from Operations $0 $784 $1,025 $1,354 $3,204 $3,779 $3,976 $4,402 $4,952 $5,489 $5,783 $6,532
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 $5,000 $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 $784 $1,025 $1,354 $3,204 $3,779 $8,976 $4,402 $4,952 $5,489 $5,783 $6,532
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 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Bill Payments $21 $648 $1,031 $1,153 $1,343 $2,245 $2,465 $2,562 $2,750 $2,986 $3,200 $3,307
Subtotal Spent on Operations $3,021 $3,648 $4,031 $4,153 $4,343 $5,245 $5,465 $5,562 $5,750 $5,986 $6,200 $6,307
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,021 $3,648 $4,031 $4,153 $4,343 $5,245 $5,465 $5,562 $5,750 $5,986 $6,200 $6,307
Net Cash Flow ($3,021) ($2,864) ($3,006) ($2,799) ($1,139) ($1,466) $3,511 ($1,160) ($798) ($497) ($417) $225
Cash Balance $12,079 $9,215 $6,209 $3,410 $2,271 $805 $4,316 $3,157 $2,358 $1,861 $1,444 $1,669
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 $15,100 $12,079 $9,215 $6,209 $3,410 $2,271 $805 $4,316 $3,157 $2,358 $1,861 $1,444 $1,669
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $15,100 $12,079 $9,215 $6,209 $3,410 $2,271 $805 $4,316 $3,157 $2,358 $1,861 $1,444 $1,669
Long-term Assets
Long-term Assets $2,300 $2,300 $2,300 $2,300 $2,300 $2,300 $2,300 $2,300 $2,300 $2,300 $2,300 $2,300 $2,300
Accumulated Depreciation $0 $64 $128 $192 $256 $320 $384 $448 $512 $576 $640 $704 $768
Total Long-term Assets $2,300 $2,236 $2,172 $2,108 $2,044 $1,980 $1,916 $1,852 $1,788 $1,724 $1,660 $1,596 $1,532
Total Assets $17,400 $14,315 $11,387 $8,317 $5,454 $4,251 $2,721 $6,168 $4,945 $4,082 $3,521 $3,040 $3,201
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 $614 $993 $1,109 $1,268 $2,162 $2,380 $2,470 $2,651 $2,879 $3,090 $3,188 $3,455
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 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
Subtotal Current Liabilities $0 $614 $993 $1,109 $1,268 $2,162 $2,380 $7,470 $7,651 $7,879 $8,090 $8,188 $8,455
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $0 $614 $993 $1,109 $1,268 $2,162 $2,380 $7,470 $7,651 $7,879 $8,090 $8,188 $8,455
Paid-in Capital $18,000 $18,000 $18,000 $18,000 $18,000 $18,000 $18,000 $18,000 $18,000 $18,000 $18,000 $18,000 $18,000
Retained Earnings ($600) ($600) ($600) ($600) ($600) ($600) ($600) ($600) ($600) ($600) ($600) ($600) ($600)
Earnings $0 ($3,699) ($7,006) ($10,193) ($13,215) ($15,312) ($17,059) ($18,702) ($20,107) ($21,197) ($21,969) ($22,548) ($22,654)
Total Capital $17,400 $13,701 $10,394 $7,208 $4,186 $2,089 $342 ($1,302) ($2,707) ($3,797) ($4,569) ($5,148) ($5,254)
Total Liabilities and Capital $17,400 $14,315 $11,387 $8,317 $5,454 $4,251 $2,721 $6,168 $4,945 $4,082 $3,521 $3,040 $3,201
Net Worth $17,400 $13,701 $10,394 $7,208 $4,186 $2,089 $342 ($1,302) ($2,706) ($3,797) ($4,569) ($5,147) ($5,253)