| 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 | |||||||||||||
| All services | 0% | $8,500 | $6,800 | $10,800 | $16,800 | $25,800 | $34,800 | $40,800 | $40,800 | $40,800 | $46,800 | $46,800 | $46,800 |
| Other | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Sales | $8,500 | $6,800 | $10,800 | $16,800 | $25,800 | $34,800 | $40,800 | $40,800 | $40,800 | $46,800 | $46,800 | $46,800 | |
| 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 | |
| All services | $1,250 | $1,500 | $2,250 | $3,000 | $5,000 | $9,500 | $9,500 | $9,500 | $9,500 | $9,500 | $9,500 | $9,500 | |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Subtotal Direct Cost of Sales | $1,250 | $1,500 | $2,250 | $3,000 | $5,000 | $9,500 | $9,500 | $9,500 | $9,500 | $9,500 | $9,500 | $9,500 | |
| 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 | ||
| Partners | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Internal Consultants | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $4,000 | $4,000 | $4,000 | $4,000 |
| External Consultants | 0% | $0 | $0 | $0 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $4,000 | $4,000 | $4,000 | $4,000 |
| Office Manager | 0% | $0 | $0 | $0 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 |
| Personal Assistant | 0% | $600 | $600 | $600 | $600 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $1,200 |
| Secretarial Staff | 0% | $0 | $0 | $0 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 |
| Research Staff | 0% | $0 | $0 | $0 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 |
| Other | 0% | $0 | $0 | $0 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 |
| Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Payroll | $600 | $600 | $600 | $5,500 | $5,700 | $5,700 | $5,700 | $5,700 | $11,700 | $11,700 | $11,700 | $12,100 | |
| 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 | $8,500 | $6,800 | $10,800 | $16,800 | $25,800 | $34,800 | $40,800 | $40,800 | $40,800 | $46,800 | $46,800 | $46,800 | |
| Direct Cost of Sales | $1,250 | $1,500 | $2,250 | $3,000 | $5,000 | $9,500 | $9,500 | $9,500 | $9,500 | $9,500 | $9,500 | $9,500 | |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Cost of Sales | $1,250 | $1,500 | $2,250 | $3,000 | $5,000 | $9,500 | $9,500 | $9,500 | $9,500 | $9,500 | $9,500 | $9,500 | |
| Gross Margin | $7,250 | $5,300 | $8,550 | $13,800 | $20,800 | $25,300 | $31,300 | $31,300 | $31,300 | $37,300 | $37,300 | $37,300 | |
| Gross Margin % | 85.29% | 77.94% | 79.17% | 82.14% | 80.62% | 72.70% | 76.72% | 76.72% | 76.72% | 79.70% | 79.70% | 79.70% | |
| Expenses | |||||||||||||
| Payroll | $600 | $600 | $600 | $5,500 | $5,700 | $5,700 | $5,700 | $5,700 | $11,700 | $11,700 | $11,700 | $12,100 | |
| Sales and Marketing and Other Expenses | $1,500 | $1,230 | $1,230 | $1,230 | $1,230 | $1,230 | $1,230 | $1,230 | $1,230 | $1,230 | $1,230 | $1,230 | |
| Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Public Relations | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | |
| Utilities | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | |
| Insurance | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Rent | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | |
| Payroll Taxes | 0% | $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 | $3,650 | $3,380 | $3,380 | $8,280 | $8,480 | $8,480 | $8,480 | $8,480 | $14,480 | $14,480 | $14,480 | $14,880 | |
| Profit Before Interest and Taxes | $3,600 | $1,920 | $5,170 | $5,520 | $12,320 | $16,820 | $22,820 | $22,820 | $16,820 | $22,820 | $22,820 | $22,420 | |
| EBITDA | $3,600 | $1,920 | $5,170 | $5,520 | $12,320 | $16,820 | $22,820 | $22,820 | $16,820 | $22,820 | $22,820 | $22,420 | |
| Interest Expense | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Taxes Incurred | $1,080 | $480 | $1,293 | $1,380 | $3,080 | $4,205 | $5,705 | $5,705 | $4,205 | $5,705 | $5,705 | $5,605 | |
| Net Profit | $2,520 | $1,440 | $3,878 | $4,140 | $9,240 | $12,615 | $17,115 | $17,115 | $12,615 | $17,115 | $17,115 | $16,815 | |
| Net Profit/Sales | 29.65% | 21.18% | 35.90% | 24.64% | 35.81% | 36.25% | 41.95% | 41.95% | 30.92% | 36.57% | 36.57% | 35.93% | |
| 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 | $2,125 | $1,700 | $2,700 | $4,200 | $6,450 | $8,700 | $10,200 | $10,200 | $10,200 | $11,700 | $11,700 | $11,700 | |
| Cash from Receivables | $0 | $213 | $6,333 | $5,200 | $8,250 | $12,825 | $19,575 | $26,250 | $30,600 | $30,600 | $30,750 | $35,100 | |
| Subtotal Cash from Operations | $2,125 | $1,913 | $9,033 | $9,400 | $14,700 | $21,525 | $29,775 | $36,450 | $40,800 | $42,300 | $42,450 | $46,800 | |
| 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 | $2,125 | $1,913 | $9,033 | $9,400 | $14,700 | $21,525 | $29,775 | $36,450 | $40,800 | $42,300 | $42,450 | $46,800 | |
| 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 | $600 | $600 | $600 | $5,500 | $5,700 | $5,700 | $5,700 | $5,700 | $11,700 | $11,700 | $11,700 | $12,100 | |
| Bill Payments | $179 | $5,359 | $4,812 | $6,350 | $7,283 | $11,048 | $16,535 | $17,985 | $17,935 | $16,535 | $17,985 | $17,982 | |
| Subtotal Spent on Operations | $779 | $5,959 | $5,412 | $11,850 | $12,983 | $16,748 | $22,235 | $23,685 | $29,635 | $28,235 | $29,685 | $30,082 | |
| 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 | $779 | $5,959 | $5,412 | $11,850 | $12,983 | $16,748 | $22,235 | $23,685 | $29,635 | $28,235 | $29,685 | $30,082 | |
| Net Cash Flow | $1,346 | ($4,047) | $3,620 | ($2,450) | $1,717 | $4,778 | $7,540 | $12,765 | $11,165 | $14,065 | $12,765 | $16,718 | |
| Cash Balance | $21,746 | $17,699 | $21,319 | $18,869 | $20,586 | $25,363 | $32,903 | $45,668 | $56,833 | $70,898 | $83,663 | $100,381 | |
| 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 | $20,400 | $21,746 | $17,699 | $21,319 | $18,869 | $20,586 | $25,363 | $32,903 | $45,668 | $56,833 | $70,898 | $83,663 | $100,381 |
| Accounts Receivable | $0 | $6,375 | $11,263 | $13,030 | $20,430 | $31,530 | $44,805 | $55,830 | $60,180 | $60,180 | $64,680 | $69,030 | $69,030 |
| Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Current Assets | $20,400 | $28,121 | $28,961 | $34,349 | $39,299 | $52,116 | $70,168 | $88,733 | $105,848 | $117,013 | $135,578 | $152,693 | $169,411 |
| Long-term Assets | |||||||||||||
| Long-term Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Accumulated Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Long-term Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Assets | $20,400 | $28,121 | $28,961 | $34,349 | $39,299 | $52,116 | $70,168 | $88,733 | $105,848 | $117,013 | $135,578 | $152,693 | $169,411 |
| 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 | $5,201 | $4,601 | $6,112 | $6,921 | $10,498 | $15,936 | $17,386 | $17,386 | $15,936 | $17,386 | $17,386 | $17,289 |
| 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 | $5,201 | $4,601 | $6,112 | $6,921 | $10,498 | $15,936 | $17,386 | $17,386 | $15,936 | $17,386 | $17,386 | $17,289 |
| Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Liabilities | $0 | $5,201 | $4,601 | $6,112 | $6,921 | $10,498 | $15,936 | $17,386 | $17,386 | $15,936 | $17,386 | $17,386 | $17,289 |
| Paid-in Capital | $70,000 | $70,000 | $70,000 | $70,000 | $70,000 | $70,000 | $70,000 | $70,000 | $70,000 | $70,000 | $70,000 | $70,000 | $70,000 |
| Retained Earnings | ($49,600) | ($49,600) | ($49,600) | ($49,600) | ($49,600) | ($49,600) | ($49,600) | ($49,600) | ($49,600) | ($49,600) | ($49,600) | ($49,600) | ($49,600) |
| Earnings | $0 | $2,520 | $3,960 | $7,838 | $11,978 | $21,218 | $33,833 | $50,948 | $68,063 | $80,678 | $97,793 | $114,908 | $131,723 |
| Total Capital | $20,400 | $22,920 | $24,360 | $28,238 | $32,378 | $41,618 | $54,233 | $71,348 | $88,463 | $101,078 | $118,193 | $135,308 | $152,123 |
| Total Liabilities and Capital | $20,400 | $28,121 | $28,961 | $34,349 | $39,299 | $52,116 | $70,168 | $88,733 | $105,848 | $117,013 | $135,578 | $152,693 | $169,411 |
| Net Worth | $20,400 | $22,920 | $24,360 | $28,238 | $32,378 | $41,618 | $54,233 | $71,348 | $88,463 | $101,078 | $118,193 | $135,308 | $152,122 |