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 |