MyHaystack.com
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 | |||||||||||||
| Individual Filing | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Dynamic Posting | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Online Research | 0% | $0 | $0 | $1,810 | $1,810 | $1,810 | $1,810 | $1,810 | $1,810 | $1,810 | $1,810 | $1,810 | $1,810 |
| Research Reports | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $100 | $100 | $100 | $100 | $100 | $208 |
| Total Sales | $0 | $0 | $1,810 | $1,810 | $1,810 | $1,810 | $1,910 | $1,910 | $1,910 | $1,910 | $1,910 | $2,018 | |
| 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 | |
| Individual Filing | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Dynamic Posting | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Online Research | $0 | $0 | $1,267 | $1,267 | $1,267 | $1,267 | $1,267 | $1,267 | $1,267 | $1,267 | $1,267 | $1,267 | |
| Research Reports | $0 | $0 | $0 | $0 | $0 | $0 | $70 | $70 | $70 | $70 | $70 | $146 | |
| Subtotal Direct Cost of Sales | $0 | $0 | $1,267 | $1,267 | $1,267 | $1,267 | $1,337 | $1,337 | $1,337 | $1,337 | $1,337 | $1,413 | |
| 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 | ||
| Marketing and Sales | 0% | $12,046 | $12,046 | $12,046 | $12,046 | $12,046 | $12,046 | $12,046 | $12,046 | $12,046 | $12,046 | $12,046 | $12,046 |
| Researchers and Analysts | 0% | $9,637 | $9,637 | $9,637 | $9,637 | $9,637 | $9,637 | $9,637 | $9,637 | $9,637 | $9,637 | $9,637 | $9,637 |
| Programmers | 0% | $7,228 | $7,228 | $7,228 | $7,228 | $7,228 | $7,228 | $7,228 | $7,228 | $7,228 | $7,228 | $7,228 | $7,228 |
| Administrative | 0% | $3,212 | $3,212 | $3,212 | $3,212 | $3,212 | $3,212 | $3,212 | $3,212 | $3,212 | $3,212 | $3,212 | $3,212 |
| Total People | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | |
| Total Payroll | $32,123 | $32,123 | $32,123 | $32,123 | $32,123 | $32,123 | $32,123 | $32,123 | $32,123 | $32,123 | $32,123 | $32,123 | |
| 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 | $0 | $1,810 | $1,810 | $1,810 | $1,810 | $1,910 | $1,910 | $1,910 | $1,910 | $1,910 | $2,018 | |
| Direct Cost of Sales | $0 | $0 | $1,267 | $1,267 | $1,267 | $1,267 | $1,337 | $1,337 | $1,337 | $1,337 | $1,337 | $1,413 | |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Cost of Sales | $0 | $0 | $1,267 | $1,267 | $1,267 | $1,267 | $1,337 | $1,337 | $1,337 | $1,337 | $1,337 | $1,413 | |
| Gross Margin | $0 | $0 | $543 | $543 | $543 | $543 | $573 | $573 | $573 | $573 | $573 | $605 | |
| Gross Margin % | 0.00% | 0.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | |
| Expenses | |||||||||||||
| Payroll | $32,123 | $32,123 | $32,123 | $32,123 | $32,123 | $32,123 | $32,123 | $32,123 | $32,123 | $32,123 | $32,123 | $32,123 | |
| Marketing/Promotion | $17,223 | $17,000 | $17,000 | $17,000 | $17,000 | $17,000 | $107,000 | $127,000 | $127,000 | $127,000 | $132,000 | $133,000 | |
| Depreciation | $991 | $991 | $991 | $991 | $991 | $991 | $991 | $991 | $991 | $991 | $991 | $991 | |
| Utilities | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | |
| Insurance | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | |
| Rent | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | |
| Payroll Taxes | 15% | $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 | |
| Total Operating Expenses | $53,837 | $53,614 | $53,614 | $53,614 | $53,614 | $53,614 | $143,614 | $163,614 | $163,614 | $163,614 | $168,614 | $169,614 | |
| Profit Before Interest and Taxes | ($53,837) | ($53,614) | ($53,071) | ($53,071) | ($53,071) | ($53,071) | ($143,041) | ($163,041) | ($163,041) | ($163,041) | ($168,041) | ($169,008) | |
| EBITDA | ($52,846) | ($52,623) | ($52,080) | ($52,080) | ($52,080) | ($52,080) | ($142,050) | ($162,050) | ($162,050) | ($162,050) | ($167,050) | ($168,018) | |
| 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 | ($53,837) | ($53,614) | ($53,071) | ($53,071) | ($53,071) | ($53,071) | ($143,041) | ($163,041) | ($163,041) | ($163,041) | ($168,041) | ($169,008) | |
| Net Profit/Sales | 0.00% | 0.00% | -2932.09% | -2932.09% | -2932.09% | -2932.09% | -7489.04% | -8536.16% | -8536.16% | -8536.16% | -8797.95% | -8375.04% | |
| 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 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Cash from Receivables | $0 | $0 | $0 | $60 | $1,810 | $1,810 | $1,810 | $1,813 | $1,910 | $1,910 | $1,910 | $1,910 | |
| Subtotal Cash from Operations | $0 | $0 | $0 | $60 | $1,810 | $1,810 | $1,810 | $1,813 | $1,910 | $1,910 | $1,910 | $1,910 | |
| 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 | $3,500,000 | $0 | $0 | $0 | $0 | $0 | |
| Subtotal Cash Received | $0 | $0 | $0 | $60 | $1,810 | $1,810 | $3,501,810 | $1,813 | $1,910 | $1,910 | $1,910 | $1,910 | |
| 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 | $32,123 | $32,123 | $32,123 | $32,123 | $32,123 | $32,123 | $32,123 | $32,123 | $32,123 | $32,123 | $32,123 | $32,123 | |
| Bill Payments | $691 | $20,716 | $20,542 | $21,767 | $21,767 | $21,767 | $24,769 | $112,504 | $131,837 | $131,837 | $132,004 | $136,873 | |
| Subtotal Spent on Operations | $32,814 | $52,839 | $52,665 | $53,890 | $53,890 | $53,890 | $56,892 | $144,627 | $163,960 | $163,960 | $164,127 | $168,996 | |
| 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 | $8,208 | $8,208 | $8,208 | $8,208 | $8,208 | $8,208 | $8,208 | $8,208 | $8,208 | $8,208 | $8,208 | $8,208 | |
| Dividends | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Subtotal Cash Spent | $41,022 | $61,047 | $60,874 | $62,098 | $62,098 | $62,098 | $65,101 | $152,835 | $172,168 | $172,168 | $172,335 | $177,204 | |
| Net Cash Flow | ($41,022) | ($61,047) | ($60,874) | ($62,038) | ($60,288) | ($60,288) | $3,436,709 | ($151,022) | ($170,258) | ($170,258) | ($170,425) | ($175,294) | |
| Cash Balance | $411,978 | $350,931 | $290,057 | $228,019 | $167,731 | $107,443 | $3,544,152 | $3,393,130 | $3,222,872 | $3,052,614 | $2,882,189 | $2,706,895 | |
| 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 | $453,000 | $411,978 | $350,931 | $290,057 | $228,019 | $167,731 | $107,443 | $3,544,152 | $3,393,130 | $3,222,872 | $3,052,614 | $2,882,189 | $2,706,895 |
| Accounts Receivable | $0 | $0 | $0 | $1,810 | $3,560 | $3,560 | $3,560 | $3,660 | $3,756 | $3,756 | $3,756 | $3,756 | $3,864 |
| Other Current Assets | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 |
| Total Current Assets | $463,000 | $421,978 | $360,931 | $301,867 | $241,579 | $181,291 | $121,002 | $3,557,812 | $3,406,887 | $3,236,628 | $3,066,370 | $2,895,945 | $2,720,759 |
| Long-term Assets | |||||||||||||
| Long-term Assets | $0 | $8,208 | $16,417 | $24,625 | $32,833 | $41,042 | $49,250 | $57,458 | $65,667 | $73,875 | $82,083 | $90,292 | $98,500 |
| Accumulated Depreciation | $0 | $991 | $1,982 | $2,972 | $3,963 | $4,954 | $5,945 | $6,935 | $7,926 | $8,917 | $9,908 | $10,898 | $11,889 |
| Total Long-term Assets | $0 | $7,218 | $14,435 | $21,653 | $28,870 | $36,088 | $43,305 | $50,523 | $57,741 | $64,958 | $72,176 | $79,393 | $86,611 |
| Total Assets | $463,000 | $429,195 | $375,366 | $323,520 | $270,449 | $217,379 | $164,308 | $3,608,335 | $3,464,627 | $3,301,587 | $3,138,546 | $2,975,339 | $2,807,370 |
| 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 | $20,032 | $19,817 | $21,041 | $21,041 | $21,041 | $21,041 | $108,109 | $127,442 | $127,442 | $127,442 | $132,276 | $133,316 |
| 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 | $20,032 | $19,817 | $21,041 | $21,041 | $21,041 | $21,041 | $108,109 | $127,442 | $127,442 | $127,442 | $132,276 | $133,316 |
| Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Liabilities | $0 | $20,032 | $19,817 | $21,041 | $21,041 | $21,041 | $21,041 | $108,109 | $127,442 | $127,442 | $127,442 | $132,276 | $133,316 |
| Paid-in Capital | $500,000 | $500,000 | $500,000 | $500,000 | $500,000 | $500,000 | $500,000 | $4,000,000 | $4,000,000 | $4,000,000 | $4,000,000 | $4,000,000 | $4,000,000 |
| Retained Earnings | ($37,000) | ($37,000) | ($37,000) | ($37,000) | ($37,000) | ($37,000) | ($37,000) | ($37,000) | ($37,000) | ($37,000) | ($37,000) | ($37,000) | ($37,000) |
| Earnings | $0 | ($53,837) | ($107,451) | ($160,521) | ($213,592) | ($266,663) | ($319,734) | ($462,774) | ($625,815) | ($788,856) | ($951,897) | ($1,119,937) | ($1,288,946) |
| Total Capital | $463,000 | $409,163 | $355,550 | $302,479 | $249,408 | $196,337 | $143,267 | $3,500,226 | $3,337,185 | $3,174,144 | $3,011,104 | $2,843,063 | $2,674,054 |
| Total Liabilities and Capital | $463,000 | $429,195 | $375,366 | $323,520 | $270,449 | $217,379 | $164,308 | $3,608,335 | $3,464,627 | $3,301,587 | $3,138,546 | $2,975,339 | $2,807,370 |
| Net Worth | $463,000 | $409,163 | $355,550 | $302,479 | $249,408 | $196,337 | $143,267 | $3,500,226 | $3,337,185 | $3,174,144 | $3,011,104 | $2,843,063 | $2,674,054 |