MyHaystack.com

Start your own business plan »

Electronic Filing Storage 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
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