| 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 | |||||||||||||
| Website Development | 0% | $0 | $0 | $4,800 | $5,400 | $7,200 | $8,400 | $8,400 | $11,200 | $14,000 | $19,200 | $19,200 | $19,200 |
| Result-based Marketing | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $1,750 | $2,100 | $2,800 | $3,500 | $4,200 | $4,900 |
| Maintenance | 0% | $0 | $0 | $110 | $280 | $510 | $750 | $1,010 | $1,350 | $1,790 | $2,290 | $2,810 | $3,330 |
| Hosting | 0% | $0 | $0 | $200 | $300 | $540 | $780 | $1,020 | $1,340 | $1,740 | $2,200 | $2,700 | $3,220 |
| Total Sales | $0 | $0 | $5,110 | $5,980 | $8,250 | $9,930 | $12,180 | $15,990 | $20,330 | $27,190 | $28,910 | $30,650 | |
| 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 | |
| Website Development | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Result-based Marketing | $0 | $0 | $0 | $0 | $0 | $0 | $900 | $1,080 | $1,440 | $1,800 | $2,160 | $2,520 | |
| Maintenance | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Hosting | $0 | $0 | $350 | $350 | $350 | $350 | $350 | $1,100 | $700 | $700 | $700 | $700 | |
| Subtotal Direct Cost of Sales | $0 | $0 | $350 | $350 | $350 | $350 | $1,250 | $2,180 | $2,140 | $2,500 | $2,860 | $3,220 | |
| 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 | |||||||||||||
| Brandon/Web Developer | $0 | $200 | $200 | $200 | $300 | $300 | $300 | $300 | $400 | $400 | $400 | $400 | |
| Keith/Hired in Oct | $0 | $0 | $1,836 | $1,152 | $1,584 | $1,440 | $1,584 | $1,512 | $1,840 | $1,680 | $1,760 | $1,840 | |
| Developer #2/Hired in Feb | $0 | $0 | $0 | $0 | $0 | $1,440 | $1,584 | $1,512 | $1,656 | $1,512 | $1,584 | $1,656 | |
| Developer #3/Hired in Apr | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $1,512 | $1,656 | $1,512 | $1,584 | $1,656 | |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Subtotal | $0 | $200 | $2,036 | $1,352 | $1,884 | $3,180 | $3,468 | $4,836 | $5,552 | $5,104 | $5,328 | $5,552 | |
| Sales and Marketing Personnel | |||||||||||||
| Dave/Marketing | $0 | $200 | $200 | $200 | $300 | $300 | $300 | $300 | $400 | $400 | $400 | $400 | |
| Sales Position #1/Hired in Oct | $0 | $0 | $1,904 | $1,080 | $1,440 | $1,680 | $1,680 | $1,680 | $1,760 | $1,760 | $1,760 | $1,760 | |
| Sales Position #2/Hired in Feb | $0 | $0 | $0 | $0 | $0 | $1,120 | $1,232 | $1,176 | $1,288 | $1,760 | $1,760 | $1,760 | |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Subtotal | $0 | $200 | $2,104 | $1,280 | $1,740 | $3,100 | $3,212 | $3,156 | $3,448 | $3,920 | $3,920 | $3,920 | |
| General and Administrative Personnel | |||||||||||||
| N/A | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| N/A | $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 | |
| Other Personnel | |||||||||||||
| N/A | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| N/A | $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 | 0 | 2 | 4 | 4 | 4 | 6 | 6 | 7 | 7 | 7 | 7 | 7 | |
| Total Payroll | $0 | $400 | $4,140 | $2,632 | $3,624 | $6,280 | $6,680 | $7,992 | $9,000 | $9,024 | $9,248 | $9,472 | |
| 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 | 13.00% | 13.00% | 13.00% | 13.00% | 13.00% | 13.00% | 13.00% | 13.00% | 13.00% | 13.00% | 13.00% | 13.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 | $0 | $0 | $5,110 | $5,980 | $8,250 | $9,930 | $12,180 | $15,990 | $20,330 | $27,190 | $28,910 | $30,650 | |
| Direct Cost of Sales | $0 | $0 | $350 | $350 | $350 | $350 | $1,250 | $2,180 | $2,140 | $2,500 | $2,860 | $3,220 | |
| Production Payroll | $0 | $200 | $2,036 | $1,352 | $1,884 | $3,180 | $3,468 | $4,836 | $5,552 | $5,104 | $5,328 | $5,552 | |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Cost of Sales | $0 | $200 | $2,386 | $1,702 | $2,234 | $3,530 | $4,718 | $7,016 | $7,692 | $7,604 | $8,188 | $8,772 | |
| Gross Margin | $0 | ($200) | $2,724 | $4,278 | $6,016 | $6,400 | $7,462 | $8,974 | $12,638 | $19,586 | $20,722 | $21,878 | |
| Gross Margin % | 0.00% | 0.00% | 53.31% | 71.54% | 72.92% | 64.45% | 61.26% | 56.12% | 62.16% | 72.03% | 71.68% | 71.38% | |
| Operating Expenses | |||||||||||||
| Sales and Marketing Expenses | |||||||||||||
| Sales and Marketing Payroll | $0 | $200 | $2,104 | $1,280 | $1,740 | $3,100 | $3,212 | $3,156 | $3,448 | $3,920 | $3,920 | $3,920 | |
| Advertising/Promotion | $0 | $0 | $230 | $230 | $230 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | |
| Travel | $0 | $0 | $60 | $60 | $60 | $120 | $120 | $120 | $120 | $120 | $120 | $120 | |
| Miscellaneous | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Sales and Marketing Expenses | $0 | $200 | $2,394 | $1,570 | $2,030 | $3,520 | $3,632 | $3,576 | $3,868 | $4,340 | $4,340 | $4,340 | |
| Sales and Marketing % | 0.00% | 0.00% | 46.85% | 26.25% | 24.61% | 35.45% | 29.82% | 22.36% | 19.03% | 15.96% | 15.01% | 14.16% | |
| General and Administrative Expenses | |||||||||||||
| General and Administrative Payroll | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Sales and Marketing and Other Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Depreciation | $0 | $0 | $300 | $300 | $300 | $300 | $330 | $330 | $330 | $330 | $330 | $330 | |
| Rent | $0 | $0 | $450 | $450 | $450 | $450 | $450 | $450 | $450 | $450 | $450 | $450 | |
| Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Leased Equipment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Utilities | $0 | $0 | $55 | $70 | $70 | $80 | $80 | $90 | $90 | $90 | $90 | $90 | |
| Insurance | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Payroll Taxes | 12% | $0 | $48 | $497 | $316 | $435 | $754 | $802 | $959 | $1,080 | $1,083 | $1,110 | $1,137 |
| Other General and Administrative Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total General and Administrative Expenses | $0 | $48 | $1,302 | $1,136 | $1,255 | $1,584 | $1,662 | $1,829 | $1,950 | $1,953 | $1,980 | $2,007 | |
| General and Administrative % | 0.00% | 0.00% | 25.48% | 18.99% | 15.21% | 15.95% | 13.64% | 11.44% | 9.59% | 7.18% | 6.85% | 6.55% | |
| 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 | $0 | $248 | $3,696 | $2,706 | $3,285 | $5,104 | $5,294 | $5,405 | $5,818 | $6,293 | $6,320 | $6,347 | |
| Profit Before Interest and Taxes | $0 | ($448) | ($972) | $1,572 | $2,731 | $1,296 | $2,168 | $3,569 | $6,820 | $13,293 | $14,402 | $15,531 | |
| EBITDA | $0 | ($448) | ($672) | $1,872 | $3,031 | $1,596 | $2,498 | $3,899 | $7,150 | $13,623 | $14,732 | $15,861 | |
| Interest Expense | $217 | $217 | $217 | $217 | $217 | $217 | $217 | $217 | $217 | $217 | $217 | $217 | |
| Taxes Incurred | ($65) | ($166) | ($297) | $339 | $629 | $270 | $488 | $838 | $1,651 | $3,269 | $3,546 | $3,829 | |
| Net Profit | ($152) | ($499) | ($891) | $1,017 | $1,886 | $810 | $1,464 | $2,514 | $4,953 | $9,807 | $10,639 | $11,486 | |
| Net Profit/Sales | 0.00% | 0.00% | -17.44% | 17.00% | 22.86% | 8.16% | 12.02% | 15.72% | 24.36% | 36.07% | 36.80% | 37.47% | |
| 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 | $1,686 | $1,973 | $2,723 | $3,277 | $4,019 | $5,277 | $6,709 | $8,973 | $9,540 | $10,115 | |
| Cash from Receivables | $0 | $0 | $0 | $114 | $3,443 | $4,057 | $5,565 | $6,703 | $8,246 | $10,810 | $13,774 | $18,256 | |
| Subtotal Cash from Operations | $0 | $0 | $1,686 | $2,088 | $6,166 | $7,334 | $9,584 | $11,980 | $14,955 | $19,783 | $23,315 | $28,370 | |
| 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 | $10,700 | $0 | $0 | $0 | $0 | $0 | |
| Subtotal Cash Received | $0 | $0 | $1,686 | $2,088 | $6,166 | $7,334 | $20,284 | $11,980 | $14,955 | $19,783 | $23,315 | $28,370 | |
| 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 | $0 | $400 | $4,140 | $2,632 | $3,624 | $6,280 | $6,680 | $7,992 | $9,000 | $9,024 | $9,248 | $9,472 | |
| Bill Payments | $5 | $150 | $147 | $1,577 | $2,045 | $2,443 | $2,579 | $3,754 | $5,184 | $6,114 | $8,051 | $8,715 | |
| Subtotal Spent on Operations | $5 | $550 | $4,287 | $4,209 | $5,669 | $8,723 | $9,259 | $11,746 | $14,184 | $15,138 | $17,299 | $18,187 | |
| 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 | $5 | $550 | $4,287 | $4,209 | $5,669 | $8,723 | $9,259 | $11,746 | $14,184 | $15,138 | $17,299 | $18,187 | |
| Net Cash Flow | ($5) | ($550) | ($2,601) | ($2,121) | $497 | ($1,389) | $11,025 | $234 | $771 | $4,645 | $6,016 | $10,183 | |
| Cash Balance | $16,995 | $16,445 | $13,844 | $11,723 | $12,219 | $10,830 | $21,855 | $22,089 | $22,860 | $27,505 | $33,521 | $43,704 | |
| 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 | $17,000 | $16,995 | $16,445 | $13,844 | $11,723 | $12,219 | $10,830 | $21,855 | $22,089 | $22,860 | $27,505 | $33,521 | $43,704 |
| Accounts Receivable | $0 | $0 | $0 | $3,424 | $7,316 | $9,401 | $11,996 | $14,592 | $18,602 | $23,977 | $31,384 | $36,980 | $39,260 |
| Other Current Assets | $7,650 | $7,650 | $7,650 | $7,650 | $7,650 | $7,650 | $7,650 | $7,650 | $7,650 | $7,650 | $7,650 | $7,650 | $7,650 |
| Total Current Assets | $24,650 | $24,645 | $24,095 | $24,918 | $26,689 | $29,270 | $30,476 | $44,097 | $48,341 | $54,487 | $66,540 | $78,151 | $90,614 |
| Long-term Assets | |||||||||||||
| Long-term Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Accumulated Depreciation | $0 | $0 | $0 | $300 | $600 | $900 | $1,200 | $1,530 | $1,860 | $2,190 | $2,520 | $2,850 | $3,180 |
| Total Long-term Assets | $0 | $0 | $0 | ($300) | ($600) | ($900) | ($1,200) | ($1,530) | ($1,860) | ($2,190) | ($2,520) | ($2,850) | ($3,180) |
| Total Assets | $24,650 | $24,645 | $24,095 | $24,618 | $26,089 | $28,370 | $29,276 | $42,567 | $46,481 | $52,297 | $64,020 | $75,301 | $87,434 |
| 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 | $147 | $95 | $1,509 | $1,964 | $2,359 | $2,456 | $3,583 | $4,982 | $5,846 | $7,761 | $8,403 | $9,050 |
| 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 | $147 | $95 | $1,509 | $1,964 | $2,359 | $2,456 | $3,583 | $4,982 | $5,846 | $7,761 | $8,403 | $9,050 |
| Long-term Liabilities | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 | $20,000 |
| Total Liabilities | $20,000 | $20,147 | $20,095 | $21,509 | $21,964 | $22,359 | $22,456 | $23,583 | $24,982 | $25,846 | $27,761 | $28,403 | $29,050 |
| Paid-in Capital | $7,300 | $7,300 | $7,300 | $7,300 | $7,300 | $7,300 | $7,300 | $18,000 | $18,000 | $18,000 | $18,000 | $18,000 | $18,000 |
| Retained Earnings | ($2,650) | ($2,650) | ($2,650) | ($2,650) | ($2,650) | ($2,650) | ($2,650) | ($2,650) | ($2,650) | ($2,650) | ($2,650) | ($2,650) | ($2,650) |
| Earnings | $0 | ($152) | ($650) | ($1,542) | ($525) | $1,361 | $2,171 | $3,635 | $6,149 | $11,101 | $20,909 | $31,548 | $43,034 |
| Total Capital | $4,650 | $4,498 | $4,000 | $3,108 | $4,125 | $6,011 | $6,821 | $18,985 | $21,499 | $26,451 | $36,259 | $46,898 | $58,384 |
| Total Liabilities and Capital | $24,650 | $24,645 | $24,095 | $24,618 | $26,089 | $28,370 | $29,276 | $42,567 | $46,481 | $52,297 | $64,020 | $75,301 | $87,434 |
| Net Worth | $4,650 | $4,498 | $4,000 | $3,108 | $4,125 | $6,011 | $6,821 | $18,985 | $21,499 | $26,451 | $36,259 | $46,898 | $58,384 |