| 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 | ||
| Unit Sales | |||||||||||||
| Home PC Unit | 3 | 5 | 3 | 15 | 18 | 20 | 20 | 20 | 17 | 15 | 10 | 20 | |
| Small Business Unit | 3 | 3 | 3 | 10 | 25 | 35 | 40 | 45 | 50 | 15 | 10 | 25 | |
| Promo | 0 | 0 | 10 | 30 | 40 | 0 | 40 | 40 | 40 | 0 | 0 | 35 | |
| Maintenance Contracts | 0 | 1 | 1 | 2 | 3 | 3 | 3 | 4 | 4 | 3 | 4 | 4 | |
| Total Unit Sales | 6 | 9 | 17 | 57 | 86 | 58 | 103 | 109 | 111 | 33 | 24 | 84 | |
| Unit Prices | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Home PC Unit | $280.00 | $280.00 | $280.00 | $280.00 | $280.00 | $280.00 | $280.00 | $280.00 | $280.00 | $280.00 | $280.00 | $280.00 | |
| Small Business Unit | $500.00 | $500.00 | $500.00 | $500.00 | $500.00 | $500.00 | $500.00 | $500.00 | $500.00 | $500.00 | $500.00 | $500.00 | |
| Promo | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | |
| Maintenance Contracts | $400.00 | $400.00 | $400.00 | $400.00 | $400.00 | $400.00 | $400.00 | $400.00 | $400.00 | $400.00 | $400.00 | $400.00 | |
| Sales | |||||||||||||
| Home PC Unit | $840 | $1,400 | $840 | $4,200 | $5,040 | $5,600 | $5,600 | $5,600 | $4,760 | $4,200 | $2,800 | $5,600 | |
| Small Business Unit | $1,500 | $1,500 | $1,500 | $5,000 | $12,500 | $17,500 | $20,000 | $22,500 | $25,000 | $7,500 | $5,000 | $12,500 | |
| Promo | $0 | $0 | $500 | $1,500 | $2,000 | $0 | $2,000 | $2,000 | $2,000 | $0 | $0 | $1,750 | |
| Maintenance Contracts | $0 | $400 | $400 | $800 | $1,200 | $1,200 | $1,200 | $1,600 | $1,600 | $1,200 | $1,600 | $1,600 | |
| Total Sales | $2,340 | $3,300 | $3,240 | $11,500 | $20,740 | $24,300 | $28,800 | $31,700 | $33,360 | $12,900 | $9,400 | $21,450 | |
| Direct Unit Costs | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| Home PC Unit | 30.00% | $84.00 | $84.00 | $84.00 | $84.00 | $84.00 | $84.00 | $84.00 | $84.00 | $84.00 | $84.00 | $84.00 | $84.00 |
| Small Business Unit | 21.00% | $105.00 | $105.00 | $105.00 | $105.00 | $105.00 | $105.00 | $105.00 | $105.00 | $105.00 | $105.00 | $105.00 | $105.00 |
| Promo | 8.00% | $4.00 | $4.00 | $4.00 | $4.00 | $4.00 | $4.00 | $4.00 | $4.00 | $4.00 | $4.00 | $4.00 | $4.00 |
| Maintenance Contracts | 12.00% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Direct Cost of Sales | |||||||||||||
| Home PC Unit | $252 | $420 | $252 | $1,260 | $1,512 | $1,680 | $1,680 | $1,680 | $1,428 | $1,260 | $840 | $1,680 | |
| Small Business Unit | $315 | $315 | $315 | $1,050 | $2,625 | $3,675 | $4,200 | $4,725 | $5,250 | $1,575 | $1,050 | $2,625 | |
| Promo | $0 | $0 | $40 | $120 | $160 | $0 | $160 | $160 | $160 | $0 | $0 | $140 | |
| Maintenance Contracts | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Subtotal Direct Cost of Sales | $567 | $735 | $607 | $2,430 | $4,297 | $5,355 | $6,040 | $6,565 | $6,838 | $2,835 | $1,890 | $4,445 | |
| 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 | ||
| Owner | 0% | $2,000 | $2,000 | $2,500 | $2,500 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 |
| Tech1 | 0% | $0 | $0 | $0 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 |
| Tech2 | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 | $2,400 |
| Part Time | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total People | 1 | 1 | 1 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 3 | |
| Total Payroll | $2,000 | $2,000 | $2,500 | $4,900 | $5,400 | $5,400 | $7,800 | $7,800 | $7,800 | $7,800 | $7,800 | $7,800 | |
| 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 | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.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% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.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 | $2,340 | $3,300 | $3,240 | $11,500 | $20,740 | $24,300 | $28,800 | $31,700 | $33,360 | $12,900 | $9,400 | $21,450 | |
| Direct Cost of Sales | $567 | $735 | $607 | $2,430 | $4,297 | $5,355 | $6,040 | $6,565 | $6,838 | $2,835 | $1,890 | $4,445 | |
| Costs of Fulfilling Maintenance Contracts | $0 | $0 | $48 | $96 | $144 | $144 | $144 | $192 | $192 | $144 | $192 | $192 | |
| Total Cost of Sales | $567 | $735 | $655 | $2,526 | $4,441 | $5,499 | $6,184 | $6,757 | $7,030 | $2,979 | $2,082 | $4,637 | |
| Gross Margin | $1,773 | $2,565 | $2,585 | $8,974 | $16,299 | $18,801 | $22,616 | $24,943 | $26,330 | $9,921 | $7,318 | $16,813 | |
| Gross Margin % | 75.77% | 77.73% | 79.78% | 78.03% | 78.59% | 77.37% | 78.53% | 78.68% | 78.93% | 76.91% | 77.85% | 78.38% | |
| Expenses | |||||||||||||
| Payroll | $2,000 | $2,000 | $2,500 | $4,900 | $5,400 | $5,400 | $7,800 | $7,800 | $7,800 | $7,800 | $7,800 | $7,800 | |
| Marketing/Promotion | $4,000 | $1,000 | $3,000 | $2,000 | $2,000 | $3,000 | $3,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | |
| Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Lease | $0 | $0 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | |
| Expensed Equipment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Insurance | $150 | $0 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | |
| Website | $40 | $40 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | |
| Answering Service | $200 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Mileage | $80 | $85 | $95 | $100 | $200 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | |
| Vehicles | $0 | $0 | $6,000 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | |
| Cell Phones | $0 | $60 | $120 | $120 | $120 | $120 | $120 | $120 | $120 | $120 | $120 | $120 | |
| Utilities | $0 | $0 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | |
| Internet | 15% | $0 | $0 | $120 | $120 | $120 | $120 | $120 | $120 | $120 | $120 | $120 | $120 |
| Moving Expenses | $0 | $0 | $2,000 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Operating Expenses | $6,470 | $3,185 | $15,835 | $10,040 | $10,640 | $11,740 | $14,140 | $13,140 | $13,140 | $13,140 | $13,140 | $13,140 | |
| Profit Before Interest and Taxes | ($4,697) | ($620) | ($13,250) | ($1,066) | $5,659 | $7,061 | $8,476 | $11,803 | $13,190 | ($3,219) | ($5,822) | $3,673 | |
| EBITDA | ($4,697) | ($620) | ($13,250) | ($1,066) | $5,659 | $7,061 | $8,476 | $11,803 | $13,190 | ($3,219) | ($5,822) | $3,673 | |
| Interest Expense | $109 | $106 | $103 | $99 | $96 | $93 | $90 | $87 | $83 | $80 | $77 | $74 | |
| Taxes Incurred | ($1,442) | ($218) | ($4,006) | ($350) | $1,669 | $2,090 | $2,516 | $3,515 | $3,932 | ($990) | ($1,770) | $1,080 | |
| Net Profit | ($3,364) | ($508) | ($9,347) | ($816) | $3,894 | $4,878 | $5,870 | $8,201 | $9,175 | ($2,309) | ($4,129) | $2,519 | |
| Net Profit/Sales | -143.77% | -15.39% | -288.48% | -7.09% | 18.78% | 20.07% | 20.38% | 25.87% | 27.50% | -17.90% | -43.93% | 11.75% | |
| 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,340 | $3,300 | $3,240 | $11,500 | $20,740 | $24,300 | $28,800 | $31,700 | $33,360 | $12,900 | $9,400 | $21,450 | |
| Subtotal Cash from Operations | $2,340 | $3,300 | $3,240 | $11,500 | $20,740 | $24,300 | $28,800 | $31,700 | $33,360 | $12,900 | $9,400 | $21,450 | |
| 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,340 | $3,300 | $3,240 | $11,500 | $20,740 | $24,300 | $28,800 | $31,700 | $33,360 | $12,900 | $9,400 | $21,450 | |
| 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 | $2,000 | $2,000 | $2,500 | $4,900 | $5,400 | $5,400 | $7,800 | $7,800 | $7,800 | $7,800 | $7,800 | $7,800 | |
| Bill Payments | $105 | $3,102 | $2,353 | $10,424 | $8,954 | $13,556 | $15,209 | $15,896 | $16,290 | $16,282 | $4,550 | $4,152 | |
| Subtotal Spent on Operations | $2,105 | $5,102 | $4,853 | $15,324 | $14,354 | $18,956 | $23,009 | $23,696 | $24,090 | $24,082 | $12,350 | $11,952 | |
| 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 | $547 | $547 | $547 | $547 | $547 | $547 | $547 | $547 | $547 | $547 | $547 | $547 | |
| 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 | $2,652 | $5,649 | $5,400 | $15,871 | $14,901 | $19,503 | $23,556 | $24,243 | $24,637 | $24,629 | $12,897 | $12,499 | |
| Net Cash Flow | ($312) | ($2,349) | ($2,160) | ($4,371) | $5,839 | $4,797 | $5,244 | $7,457 | $8,723 | ($11,729) | ($3,497) | $8,951 | |
| Cash Balance | $27,688 | $25,340 | $23,179 | $18,809 | $24,647 | $29,444 | $34,688 | $42,145 | $50,868 | $39,139 | $35,642 | $44,593 | |
| 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 | $28,000 | $27,688 | $25,340 | $23,179 | $18,809 | $24,647 | $29,444 | $34,688 | $42,145 | $50,868 | $39,139 | $35,642 | $44,593 |
| Inventory | $1,200 | $633 | $898 | $1,291 | $2,673 | $4,727 | $5,891 | $6,644 | $7,222 | $7,522 | $4,687 | $2,797 | $4,890 |
| 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 | $39,200 | $38,321 | $36,238 | $34,470 | $31,482 | $39,374 | $45,335 | $51,332 | $59,366 | $68,390 | $53,826 | $48,439 | $59,482 |
| 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 | $39,200 | $38,321 | $36,238 | $34,470 | $31,482 | $39,374 | $45,335 | $51,332 | $59,366 | $68,390 | $53,826 | $48,439 | $59,482 |
| 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 | $3,033 | $2,004 | $10,130 | $8,505 | $13,050 | $14,680 | $15,354 | $15,733 | $16,130 | $4,422 | $3,711 | $12,783 |
| Current Borrowing | $19,225 | $18,678 | $18,131 | $17,584 | $17,037 | $16,490 | $15,943 | $15,396 | $14,849 | $14,302 | $13,755 | $13,208 | $12,661 |
| Other Current Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Subtotal Current Liabilities | $19,225 | $21,711 | $20,135 | $27,714 | $25,542 | $29,540 | $30,623 | $30,750 | $30,582 | $30,432 | $18,177 | $16,919 | $25,444 |
| Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Liabilities | $19,225 | $21,711 | $20,135 | $27,714 | $25,542 | $29,540 | $30,623 | $30,750 | $30,582 | $30,432 | $18,177 | $16,919 | $25,444 |
| Paid-in Capital | $23,000 | $23,000 | $23,000 | $23,000 | $23,000 | $23,000 | $23,000 | $23,000 | $23,000 | $23,000 | $23,000 | $23,000 | $23,000 |
| Retained Earnings | ($3,025) | ($3,025) | ($3,025) | ($3,025) | ($3,025) | ($3,025) | ($3,025) | ($3,025) | ($3,025) | ($3,025) | ($3,025) | ($3,025) | ($3,025) |
| Earnings | $0 | ($3,364) | ($3,872) | ($13,219) | ($14,035) | ($10,141) | ($5,263) | $607 | $8,809 | $17,983 | $15,674 | $11,544 | $14,064 |
| Total Capital | $19,975 | $16,611 | $16,103 | $6,756 | $5,940 | $9,834 | $14,712 | $20,582 | $28,784 | $37,958 | $35,649 | $31,519 | $34,039 |
| Total Liabilities and Capital | $39,200 | $38,321 | $36,238 | $34,470 | $31,482 | $39,374 | $45,335 | $51,332 | $59,366 | $68,390 | $53,826 | $48,439 | $59,482 |
| Net Worth | $19,975 | $16,611 | $16,103 | $6,756 | $5,940 | $9,834 | $14,712 | $20,582 | $28,784 | $37,958 | $35,649 | $31,519 | $34,039 |