Candlelight Cichlid Breeders
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 | ||
| Unit Sales | |||||||||||||
| Internet Sales | 0% | 400 | 500 | 650 | 800 | 1,000 | 1,200 | 1,500 | 1,650 | 1,750 | 1,750 | 1,750 | 1,750 |
| Retailers | 0% | 200 | 200 | 200 | 300 | 300 | 300 | 400 | 400 | 400 | 400 | 400 | 400 |
| Other | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Total Unit Sales | 600 | 700 | 850 | 1,100 | 1,300 | 1,500 | 1,900 | 2,050 | 2,150 | 2,150 | 2,150 | 2,150 | |
| Unit Prices | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Internet Sales | $6.00 | $6.00 | $6.00 | $6.00 | $6.00 | $6.00 | $6.00 | $6.00 | $6.00 | $6.00 | $6.00 | $6.00 | |
| Retailers | $0.00 | $2.00 | $2.00 | $2.00 | $2.00 | $2.00 | $2.00 | $2.00 | $2.00 | $2.00 | $2.00 | $2.00 | |
| Other | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
| Sales | |||||||||||||
| Internet Sales | $2,400 | $3,000 | $3,900 | $4,800 | $6,000 | $7,200 | $9,000 | $9,900 | $10,500 | $10,500 | $10,500 | $10,500 | |
| Retailers | $0 | $400 | $400 | $600 | $600 | $600 | $800 | $800 | $800 | $800 | $800 | $800 | |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Sales | $2,400 | $3,400 | $4,300 | $5,400 | $6,600 | $7,800 | $9,800 | $10,700 | $11,300 | $11,300 | $11,300 | $11,300 | |
| Direct Unit Costs | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Internet Sales | 0.00% | $0.50 | $0.50 | $0.50 | $0.50 | $0.50 | $0.50 | $0.50 | $0.50 | $0.50 | $0.50 | $0.50 | $0.50 |
| Retailers | 0.00% | $0.50 | $0.50 | $0.50 | $0.50 | $0.50 | $0.50 | $0.50 | $0.50 | $0.50 | $0.50 | $0.50 | $0.50 |
| Other | 0.00% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Direct Cost of Sales | |||||||||||||
| Internet Sales | $200 | $250 | $325 | $400 | $500 | $600 | $750 | $825 | $875 | $875 | $875 | $875 | |
| Retailers | $100 | $100 | $100 | $150 | $150 | $150 | $200 | $200 | $200 | $200 | $200 | $200 | |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Subtotal Direct Cost of Sales | $300 | $350 | $425 | $550 | $650 | $750 | $950 | $1,025 | $1,075 | $1,075 | $1,075 | $1,075 | |
| 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 | ||
| Production Personnel | |||||||||||||
| General assistant | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | |
| Second general assistant | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Subtotal | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | |
| Sales and Marketing Personnel | |||||||||||||
| Name or title | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Subtotal | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| General and Administrative Personnel | |||||||||||||
| Owner | $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 | |
| Subtotal | $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 Personnel | |||||||||||||
| Name or title | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Name or title | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Name or title | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Subtotal | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total People | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | |
| Total Payroll | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | |
| 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 | $2,400 | $3,400 | $4,300 | $5,400 | $6,600 | $7,800 | $9,800 | $10,700 | $11,300 | $11,300 | $11,300 | $11,300 | |
| Direct Cost of Sales | $300 | $350 | $425 | $550 | $650 | $750 | $950 | $1,025 | $1,075 | $1,075 | $1,075 | $1,075 | |
| Production Payroll | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Cost of Sales | $1,800 | $1,850 | $1,925 | $2,050 | $2,150 | $2,250 | $2,450 | $2,525 | $2,575 | $2,575 | $2,575 | $2,575 | |
| Gross Margin | $600 | $1,550 | $2,375 | $3,350 | $4,450 | $5,550 | $7,350 | $8,175 | $8,725 | $8,725 | $8,725 | $8,725 | |
| Gross Margin % | 25.00% | 45.59% | 55.23% | 62.04% | 67.42% | 71.15% | 75.00% | 76.40% | 77.21% | 77.21% | 77.21% | 77.21% | |
| Operating Expenses | |||||||||||||
| Sales and Marketing Expenses | |||||||||||||
| Sales and Marketing Payroll | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Advertising/Promotion | $120 | $120 | $120 | $120 | $120 | $120 | $120 | $120 | $120 | $120 | $120 | $120 | |
| Travel | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | |
| Miscellaneous | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | |
| Total Sales and Marketing Expenses | $370 | $370 | $370 | $370 | $370 | $370 | $370 | $370 | $370 | $370 | $370 | $370 | |
| Sales and Marketing % | 15.42% | 10.88% | 8.60% | 6.85% | 5.61% | 4.74% | 3.78% | 3.46% | 3.27% | 3.27% | 3.27% | 3.27% | |
| General and Administrative Expenses | |||||||||||||
| General and Administrative 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 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Depreciation | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | |
| Leased Equipment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Utilities | $105 | $105 | $105 | $105 | $105 | $105 | $105 | $105 | $105 | $105 | $105 | $105 | |
| Rent | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Payroll Taxes | 15% | $675 | $675 | $675 | $675 | $675 | $675 | $675 | $675 | $675 | $675 | $675 | $675 |
| Other General and Administrative Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total General and Administrative Expenses | $4,780 | $4,780 | $4,780 | $4,780 | $4,780 | $4,780 | $4,780 | $4,780 | $4,780 | $4,780 | $4,780 | $4,780 | |
| General and Administrative % | 199.17% | 140.59% | 111.16% | 88.52% | 72.42% | 61.28% | 48.78% | 44.67% | 42.30% | 42.30% | 42.30% | 42.30% | |
| Other Expenses: | |||||||||||||
| Other Payroll | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Consultants | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Contract/Consultants | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Other Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Other % | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |
| Total Operating Expenses | $5,150 | $5,150 | $5,150 | $5,150 | $5,150 | $5,150 | $5,150 | $5,150 | $5,150 | $5,150 | $5,150 | $5,150 | |
| Profit Before Interest and Taxes | ($4,550) | ($3,600) | ($2,775) | ($1,800) | ($700) | $400 | $2,200 | $3,025 | $3,575 | $3,575 | $3,575 | $3,575 | |
| EBITDA | ($3,550) | ($2,600) | ($1,775) | ($800) | $300 | $1,400 | $3,200 | $4,025 | $4,575 | $4,575 | $4,575 | $4,575 | |
| Interest Expense | $348 | $344 | $339 | $334 | $330 | $325 | $320 | $316 | $311 | $306 | $302 | $297 | |
| Taxes Incurred | ($1,470) | ($986) | ($779) | ($534) | ($257) | $19 | $470 | $677 | $816 | $817 | $818 | $819 | |
| Net Profit | ($3,429) | ($2,958) | ($2,336) | ($1,601) | ($772) | $56 | $1,410 | $2,032 | $2,448 | $2,451 | $2,455 | $2,458 | |
| Net Profit/Sales | -142.87% | -86.99% | -54.31% | -29.64% | -11.70% | 0.72% | 14.38% | 18.99% | 21.66% | 21.69% | 21.73% | 21.76% | |
| 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 | $1,440 | $2,040 | $2,580 | $3,240 | $3,960 | $4,680 | $5,880 | $6,420 | $6,780 | $6,780 | $6,780 | $6,780 | |
| Cash from Receivables | $0 | $32 | $973 | $1,372 | $1,735 | $2,176 | $2,656 | $3,147 | $3,932 | $4,288 | $4,520 | $4,520 | |
| Subtotal Cash from Operations | $1,440 | $2,072 | $3,553 | $4,612 | $5,695 | $6,856 | $8,536 | $9,567 | $10,712 | $11,068 | $11,300 | $11,300 | |
| 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 | $1,440 | $2,072 | $3,553 | $4,612 | $5,695 | $6,856 | $8,536 | $9,567 | $10,712 | $11,068 | $11,300 | $11,300 | |
| 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 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | |
| Bill Payments | $1 | $78 | $1,481 | $752 | $1,960 | $2,198 | $1,546 | $3,067 | $3,256 | $3,405 | $3,348 | $3,345 | |
| Subtotal Spent on Operations | $4,501 | $4,578 | $5,981 | $5,252 | $6,460 | $6,698 | $6,046 | $7,567 | $7,756 | $7,905 | $7,848 | $7,845 | |
| 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 | $559 | $559 | $559 | $559 | $559 | $559 | $559 | $559 | $559 | $559 | $559 | $559 | |
| 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 | $5,060 | $5,137 | $6,540 | $5,811 | $7,019 | $7,257 | $6,605 | $8,126 | $8,315 | $8,464 | $8,407 | $8,404 | |
| Net Cash Flow | ($3,620) | ($3,065) | ($2,987) | ($1,199) | ($1,324) | ($401) | $1,931 | $1,441 | $2,397 | $2,604 | $2,893 | $2,896 | |
| Cash Balance | $36,380 | $33,315 | $30,328 | $29,129 | $27,805 | $27,404 | $29,335 | $30,776 | $33,173 | $35,777 | $38,670 | $41,566 | |
| 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 | $40,000 | $36,380 | $33,315 | $30,328 | $29,129 | $27,805 | $27,404 | $29,335 | $30,776 | $33,173 | $35,777 | $38,670 | $41,566 |
| Accounts Receivable | $0 | $960 | $2,288 | $3,035 | $3,823 | $4,728 | $5,672 | $6,936 | $8,069 | $8,657 | $8,889 | $8,889 | $8,889 |
| Inventory | $900 | $600 | $1,250 | $825 | $1,275 | $1,625 | $875 | $1,045 | $1,128 | $1,183 | $1,183 | $1,183 | $1,183 |
| Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Current Assets | $40,900 | $37,940 | $36,853 | $34,188 | $34,227 | $34,158 | $33,951 | $37,316 | $39,973 | $43,013 | $45,849 | $48,742 | $51,638 |
| Long-term Assets | |||||||||||||
| Long-term Assets | $35,000 | $35,000 | $35,000 | $35,000 | $35,000 | $35,000 | $35,000 | $35,000 | $35,000 | $35,000 | $35,000 | $35,000 | $35,000 |
| Accumulated Depreciation | $0 | $1,000 | $2,000 | $3,000 | $4,000 | $5,000 | $6,000 | $7,000 | $8,000 | $9,000 | $10,000 | $11,000 | $12,000 |
| Total Long-term Assets | $35,000 | $34,000 | $33,000 | $32,000 | $31,000 | $30,000 | $29,000 | $28,000 | $27,000 | $26,000 | $25,000 | $24,000 | $23,000 |
| Total Assets | $75,900 | $71,940 | $69,853 | $66,188 | $65,227 | $64,158 | $62,951 | $65,316 | $66,973 | $69,013 | $70,849 | $72,742 | $74,638 |
| 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 | $28 | $1,458 | $687 | $1,886 | $2,148 | $1,444 | $2,958 | $3,142 | $3,293 | $3,237 | $3,234 | $3,230 |
| 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 | $28 | $1,458 | $687 | $1,886 | $2,148 | $1,444 | $2,958 | $3,142 | $3,293 | $3,237 | $3,234 | $3,230 |
| Long-term Liabilities | $42,360 | $41,801 | $41,242 | $40,683 | $40,124 | $39,565 | $39,006 | $38,447 | $37,888 | $37,329 | $36,770 | $36,211 | $35,652 |
| Total Liabilities | $42,360 | $41,829 | $42,700 | $41,370 | $42,010 | $41,713 | $40,450 | $41,405 | $41,030 | $40,622 | $40,007 | $39,445 | $38,882 |
| Paid-in Capital | $59,590 | $59,590 | $59,590 | $59,590 | $59,590 | $59,590 | $59,590 | $59,590 | $59,590 | $59,590 | $59,590 | $59,590 | $59,590 |
| Retained Earnings | ($26,050) | ($26,050) | ($26,050) | ($26,050) | ($26,050) | ($26,050) | ($26,050) | ($26,050) | ($26,050) | ($26,050) | ($26,050) | ($26,050) | ($26,050) |
| Earnings | $0 | ($3,429) | ($6,387) | ($8,722) | ($10,323) | ($11,095) | ($11,039) | ($9,629) | ($7,597) | ($5,149) | ($2,698) | ($243) | $2,215 |
| Total Capital | $33,540 | $30,111 | $27,153 | $24,818 | $23,217 | $22,445 | $22,501 | $23,911 | $25,943 | $28,391 | $30,842 | $33,297 | $35,755 |
| Total Liabilities and Capital | $75,900 | $71,940 | $69,853 | $66,188 | $65,227 | $64,158 | $62,951 | $65,316 | $66,973 | $69,013 | $70,849 | $72,742 | $74,638 |
| Net Worth | $33,540 | $30,111 | $27,153 | $24,818 | $23,217 | $22,445 | $22,501 | $23,911 | $25,943 | $28,391 | $30,842 | $33,297 | $35,755 |