| Personnel Plan | |||||||||||||
| Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | ||
| All departments | 0% | $36,231 | $36,232 | $36,232 | $36,232 | $36,232 | $36,232 | $36,232 | $36,232 | $36,232 | $36,232 | $36,232 | $36,232 |
| Other | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total People | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | |
| Total Payroll | $36,231 | $36,232 | $36,232 | $36,232 | $36,232 | $36,232 | $36,232 | $36,232 | $36,232 | $36,232 | $36,232 | $36,232 | |
| Sales Forecast | |||||||||||||
| Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | ||
| Sales | |||||||||||||
| Hosting Services | 0% | $13,953 | $13,953 | $16,279 | $19,767 | $23,255 | $23,255 | $23,255 | $23,255 | $23,255 | $23,255 | $23,255 | $23,255 |
| Internet Sales | 0% | $18,140 | $18,140 | $21,163 | $25,698 | $30,233 | $30,233 | $30,233 | $30,233 | $30,233 | $30,233 | $30,233 | $30,233 |
| Computing Solutions | 0% | $27,907 | $27,907 | $32,558 | $39,535 | $46,512 | $46,512 | $46,512 | $46,512 | $46,512 | $46,512 | $46,512 | $46,512 |
| Total Sales | $60,000 | $60,000 | $70,000 | $85,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | |
| Direct Cost of Sales | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | |
| Hosting Services | $1,298 | $1,298 | $1,514 | $1,839 | $2,163 | $2,163 | $2,163 | $2,163 | $2,163 | $2,163 | $2,163 | $2,163 | |
| Internet Sales | $1,687 | $1,687 | $1,969 | $2,390 | $2,813 | $2,813 | $2,813 | $2,813 | $2,813 | $2,813 | $2,813 | $2,812 | |
| Computing Solutions | $2,595 | $2,595 | $3,028 | $3,677 | $4,327 | $4,327 | $4,327 | $4,327 | $4,327 | $4,327 | $4,327 | $4,327 | |
| Subtotal Direct Cost of Sales | $5,580 | $5,580 | $6,511 | $7,906 | $9,303 | $9,303 | $9,303 | $9,303 | $9,303 | $9,303 | $9,303 | $9,302 | |
| General Assumptions | |||||||||||||
| Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | ||
| 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 Cash Flow | |||||||||||||
| Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | $15,000 | $15,000 | $17,500 | $21,250 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | $25,000 | |
| Cash from Receivables | $20,000 | $21,500 | $45,000 | $45,250 | $52,875 | $64,125 | $75,000 | $75,000 | $75,000 | $75,000 | $75,000 | $75,000 | |
| Subtotal Cash from Operations | $35,000 | $36,500 | $62,500 | $66,500 | $77,875 | $89,125 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | |
| 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 | $914,900 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $3,000,000 | $0 | $0 | $0 | |
| Subtotal Cash Received | $949,900 | $36,500 | $62,500 | $66,500 | $77,875 | $89,125 | $100,000 | $100,000 | $3,100,000 | $100,000 | $100,000 | $100,000 | |
| Expenditures | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | $36,231 | $36,232 | $36,232 | $36,232 | $36,232 | $36,232 | $36,232 | $36,232 | $36,232 | $36,232 | $36,232 | $36,232 | |
| Bill Payments | $32,126 | $63,773 | $63,771 | $63,750 | $65,140 | $66,491 | $66,491 | $66,491 | $66,491 | $66,491 | $66,491 | $66,491 | |
| Subtotal Spent on Operations | $68,357 | $100,005 | $100,003 | $99,982 | $101,372 | $102,723 | $102,723 | $102,723 | $102,723 | $102,723 | $102,723 | $102,723 | |
| 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 | $646 | $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 | $22,000 | $30,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | |
| Dividends | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Subtotal Cash Spent | $90,357 | $130,005 | $200,003 | $200,628 | $201,372 | $202,723 | $202,723 | $202,723 | $202,723 | $202,723 | $202,723 | $202,723 | |
| Net Cash Flow | $859,543 | ($93,505) | ($137,503) | ($134,128) | ($123,497) | ($113,598) | ($102,723) | ($102,723) | $2,897,277 | ($102,723) | ($102,723) | ($102,723) | |
| Cash Balance | $889,543 | $796,038 | $658,535 | $524,407 | $400,910 | $287,312 | $184,589 | $81,866 | $2,979,144 | $2,876,421 | $2,773,698 | $2,670,975 | |
| Pro Forma Profit and Loss | |||||||||||||
| Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | ||
| Sales | $60,000 | $60,000 | $70,000 | $85,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | $100,000 | |
| Direct Cost of Sales | $5,580 | $5,580 | $6,511 | $7,906 | $9,303 | $9,303 | $9,303 | $9,303 | $9,303 | $9,303 | $9,303 | $9,302 | |
| Other | $4,000 | $4,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | |
| Total Cost of Sales | $9,580 | $9,580 | $9,511 | $10,906 | $12,303 | $12,303 | $12,303 | $12,303 | $12,303 | $12,303 | $12,303 | $12,302 | |
| Gross Margin | $50,420 | $50,420 | $60,489 | $74,094 | $87,697 | $87,697 | $87,697 | $87,697 | $87,697 | $87,697 | $87,697 | $87,698 | |
| Gross Margin % | 84.03% | 84.03% | 86.41% | 87.17% | 87.70% | 87.70% | 87.70% | 87.70% | 87.70% | 87.70% | 87.70% | 87.70% | |
| Expenses | |||||||||||||
| Payroll | $36,231 | $36,232 | $36,232 | $36,232 | $36,232 | $36,232 | $36,232 | $36,232 | $36,232 | $36,232 | $36,232 | $36,232 | |
| Sales and Marketing and Other Expenses | $40,300 | $40,300 | $40,300 | $40,300 | $40,300 | $40,300 | $40,300 | $40,300 | $40,300 | $40,300 | $40,300 | $40,300 | |
| Depreciation | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | |
| Utilities | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | |
| Insurance | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | |
| 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 | |
| Utilities | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | |
| Continuing Education | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | |
| Payroll Taxes | 15% | $5,435 | $5,435 | $5,435 | $5,435 | $5,435 | $5,435 | $5,435 | $5,435 | $5,435 | $5,435 | $5,435 | $5,435 |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Operating Expenses | $92,966 | $92,967 | $92,967 | $92,967 | $92,967 | $92,967 | $92,967 | $92,967 | $92,967 | $92,967 | $92,967 | $92,967 | |
| Profit Before Interest and Taxes | ($42,546) | ($42,547) | ($32,478) | ($18,873) | ($5,270) | ($5,270) | ($5,270) | ($5,270) | ($5,270) | ($5,270) | ($5,270) | ($5,269) | |
| EBITDA | ($39,546) | ($39,547) | ($29,478) | ($15,873) | ($2,270) | ($2,270) | ($2,270) | ($2,270) | ($2,270) | ($2,270) | ($2,270) | ($2,269) | |
| Interest Expense | $458 | $458 | $458 | $453 | $453 | $453 | $453 | $453 | $453 | $453 | $453 | $453 | |
| Taxes Incurred | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Net Profit | ($43,004) | ($43,005) | ($32,936) | ($19,326) | ($5,723) | ($5,723) | ($5,723) | ($5,723) | ($5,723) | ($5,723) | ($5,723) | ($5,722) | |
| Net Profit/Sales | -71.67% | -71.68% | -47.05% | -22.74% | -5.72% | -5.72% | -5.72% | -5.72% | -5.72% | -5.72% | -5.72% | -5.72% | |
| Pro Forma Balance Sheet | |||||||||||||
| Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | $30,000 | $889,543 | $796,038 | $658,535 | $524,407 | $400,910 | $287,312 | $184,589 | $81,866 | $2,979,144 | $2,876,421 | $2,773,698 | $2,670,975 |
| Accounts Receivable | $40,000 | $65,000 | $88,500 | $96,000 | $114,500 | $136,625 | $147,500 | $147,500 | $147,500 | $147,500 | $147,500 | $147,500 | $147,500 |
| Other Current Assets | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 |
| Total Current Assets | $75,000 | $959,543 | $889,538 | $759,535 | $643,907 | $542,535 | $439,812 | $337,089 | $234,366 | $3,131,644 | $3,028,921 | $2,926,198 | $2,823,475 |
| Long-term Assets | |||||||||||||
| Long-term Assets | $100,000 | $122,000 | $152,000 | $252,000 | $352,000 | $452,000 | $552,000 | $652,000 | $752,000 | $852,000 | $952,000 | $1,052,000 | $1,152,000 |
| Accumulated Depreciation | $20,000 | $23,000 | $26,000 | $29,000 | $32,000 | $35,000 | $38,000 | $41,000 | $44,000 | $47,000 | $50,000 | $53,000 | $56,000 |
| Total Long-term Assets | $80,000 | $99,000 | $126,000 | $223,000 | $320,000 | $417,000 | $514,000 | $611,000 | $708,000 | $805,000 | $902,000 | $999,000 | $1,096,000 |
| Total Assets | $155,000 | $1,058,543 | $1,015,538 | $982,535 | $963,907 | $959,535 | $953,812 | $948,089 | $942,366 | $3,936,644 | $3,930,921 | $3,925,198 | $3,919,475 |
| Liabilities and Capital | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | |
| Current Liabilities | |||||||||||||
| Accounts Payable | $30,000 | $61,647 | $61,647 | $61,581 | $62,924 | $64,274 | $64,274 | $64,274 | $64,274 | $64,274 | $64,274 | $64,274 | $64,273 |
| Current Borrowing | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 |
| Other Current Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Subtotal Current Liabilities | $35,000 | $66,647 | $66,647 | $66,581 | $67,924 | $69,274 | $69,274 | $69,274 | $69,274 | $69,274 | $69,274 | $69,274 | $69,273 |
| Long-term Liabilities | $50,000 | $50,000 | $50,000 | $50,000 | $49,354 | $49,354 | $49,354 | $49,354 | $49,354 | $49,354 | $49,354 | $49,354 | $49,354 |
| Total Liabilities | $85,000 | $116,647 | $116,647 | $116,581 | $117,278 | $118,628 | $118,628 | $118,628 | $118,628 | $118,628 | $118,628 | $118,628 | $118,627 |
| Paid-in Capital | $25,000 | $939,900 | $939,900 | $939,900 | $939,900 | $939,900 | $939,900 | $939,900 | $939,900 | $3,939,900 | $3,939,900 | $3,939,900 | $3,939,900 |
| Retained Earnings | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 | $45,000 |
| Earnings | $0 | ($43,004) | ($86,009) | ($118,945) | ($138,271) | ($143,994) | ($149,717) | ($155,439) | ($161,162) | ($166,885) | ($172,608) | ($178,330) | ($184,052) |
| Total Capital | $70,000 | $941,896 | $898,891 | $865,955 | $846,629 | $840,906 | $835,184 | $829,461 | $823,738 | $3,818,015 | $3,812,293 | $3,806,570 | $3,800,848 |
| Total Liabilities and Capital | $155,000 | $1,058,543 | $1,015,538 | $982,535 | $963,907 | $959,535 | $953,812 | $948,089 | $942,366 | $3,936,644 | $3,930,921 | $3,925,198 | $3,919,475 |
| Net Worth | $70,000 | $941,896 | $898,891 | $865,955 | $846,629 | $840,906 | $835,183 | $829,461 | $823,738 | $3,818,015 | $3,812,293 | $3,806,570 | $3,800,848 |