Corporate Software Sales
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 | |||||||||||||
| Start-up fees | 0% | $0 | $45,000 | $25,000 | $0 | $0 | $30,000 | $0 | $0 | $0 | $50,000 | $0 | $0 |
| Consulting fees | 0% | $500 | $300 | $0 | $600 | $200 | $0 | $0 | $400 | $200 | $0 | $200 | $0 |
| Training fees | 0% | $0 | $300 | $250 | $0 | $0 | $400 | $0 | $0 | $0 | $600 | $1,000 | $0 |
| Total Sales | $500 | $45,600 | $25,250 | $600 | $200 | $30,400 | $0 | $400 | $200 | $50,600 | $1,200 | $0 | |
| 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 | |
| Start-up fees | $0 | $4,500 | $2,500 | $0 | $0 | $3,000 | $0 | $0 | $0 | $5,000 | $0 | $0 | |
| Consulting fees | $200 | $120 | $0 | $240 | $80 | $0 | $0 | $160 | $80 | $0 | $80 | $0 | |
| Training fees | $0 | $150 | $125 | $0 | $0 | $200 | $0 | $0 | $0 | $300 | $500 | $0 | |
| Subtotal Direct Cost of Sales | $200 | $4,770 | $2,625 | $240 | $80 | $3,200 | $0 | $160 | $80 | $5,300 | $580 | $0 | |
| 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 | ||
| Ivanhoe | 0% | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $10,000 | $10,000 |
| Other | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Payroll | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $10,000 | $10,000 | |
| 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 | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | |
| Tax Rate | 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 | $500 | $45,600 | $25,250 | $600 | $200 | $30,400 | $0 | $400 | $200 | $50,600 | $1,200 | $0 | |
| Direct Cost of Sales | $200 | $4,770 | $2,625 | $240 | $80 | $3,200 | $0 | $160 | $80 | $5,300 | $580 | $0 | |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Cost of Sales | $200 | $4,770 | $2,625 | $240 | $80 | $3,200 | $0 | $160 | $80 | $5,300 | $580 | $0 | |
| Gross Margin | $300 | $40,830 | $22,625 | $360 | $120 | $27,200 | $0 | $240 | $120 | $45,300 | $620 | $0 | |
| Gross Margin % | 60.00% | 89.54% | 89.60% | 60.00% | 60.00% | 89.47% | 0.00% | 60.00% | 60.00% | 89.53% | 51.67% | 0.00% | |
| Expenses | |||||||||||||
| Payroll | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $10,000 | $10,000 | |
| Marketing/Promotion | $0 | $1,000 | $1,000 | $0 | $0 | $1,000 | $0 | $0 | $0 | $1,000 | $0 | $0 | |
| Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Utilities | $40 | $40 | $40 | $40 | $40 | $40 | $40 | $40 | $40 | $40 | $40 | $40 | |
| Insurance | $120 | $120 | $120 | $120 | $120 | $120 | $120 | $120 | $120 | $120 | $120 | $120 | |
| Rent | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | |
| 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 | $6,510 | $7,510 | $7,510 | $6,510 | $6,510 | $7,510 | $6,510 | $6,510 | $6,510 | $7,510 | $10,510 | $10,510 | |
| Profit Before Interest and Taxes | ($6,210) | $33,320 | $15,115 | ($6,150) | ($6,390) | $19,690 | ($6,510) | ($6,270) | ($6,390) | $37,790 | ($9,890) | ($10,510) | |
| EBITDA | ($6,210) | $33,320 | $15,115 | ($6,150) | ($6,390) | $19,690 | ($6,510) | ($6,270) | ($6,390) | $37,790 | ($9,890) | ($10,510) | |
| Interest Expense | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Taxes Incurred | ($1,863) | $9,996 | $4,535 | ($1,845) | ($1,917) | $5,907 | ($1,953) | ($1,881) | ($1,917) | $11,337 | ($2,967) | ($3,153) | |
| Net Profit | ($4,347) | $23,324 | $10,581 | ($4,305) | ($4,473) | $13,783 | ($4,557) | ($4,389) | ($4,473) | $26,453 | ($6,923) | ($7,357) | |
| Net Profit/Sales | -869.40% | 51.15% | 41.90% | -717.50% | -2236.50% | 45.34% | 0.00% | -1097.25% | -2236.50% | 52.28% | -576.92% | 0.00% | |
| 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 | $250 | $22,800 | $12,625 | $300 | $100 | $15,200 | $0 | $200 | $100 | $25,300 | $600 | $0 | |
| Cash from Receivables | $0 | $8 | $1,002 | $22,461 | $12,214 | $293 | $603 | $14,693 | $7 | $197 | $940 | $24,477 | |
| Subtotal Cash from Operations | $250 | $22,808 | $13,627 | $22,761 | $12,314 | $15,493 | $603 | $14,893 | $107 | $25,497 | $1,540 | $24,477 | |
| 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 | $250 | $22,808 | $13,627 | $22,761 | $12,314 | $15,493 | $603 | $14,893 | $107 | $25,497 | $1,540 | $24,477 | |
| 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 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $10,000 | $10,000 | |
| Bill Payments | ($653) | ($572) | $16,022 | $7,286 | ($2,386) | ($929) | $8,820 | ($2,606) | ($2,498) | ($678) | $15,665 | ($4,457) | |
| Subtotal Spent on Operations | $5,347 | $5,428 | $22,022 | $13,286 | $3,615 | $5,071 | $14,820 | $3,394 | $3,502 | $5,322 | $25,665 | $5,543 | |
| 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,347 | $5,428 | $22,022 | $13,286 | $3,615 | $5,071 | $14,820 | $3,394 | $3,502 | $5,322 | $25,665 | $5,543 | |
| Net Cash Flow | ($5,097) | $17,380 | ($8,396) | $9,475 | $8,700 | $10,422 | ($14,217) | $11,499 | ($3,396) | $20,175 | ($24,125) | $18,934 | |
| Cash Balance | $5,903 | $23,283 | $14,888 | $24,363 | $33,063 | $43,485 | $29,268 | $40,767 | $37,372 | $57,546 | $33,421 | $52,355 | |
| 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 | $11,000 | $5,903 | $23,283 | $14,888 | $24,363 | $33,063 | $43,485 | $29,268 | $40,767 | $37,372 | $57,546 | $33,421 | $52,355 |
| Accounts Receivable | $0 | $250 | $23,042 | $34,665 | $12,504 | $390 | $15,297 | $14,693 | $200 | $293 | $25,397 | $25,057 | $580 |
| Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Current Assets | $11,000 | $6,153 | $46,325 | $49,553 | $36,867 | $33,453 | $58,781 | $43,961 | $40,967 | $37,665 | $82,943 | $58,478 | $52,935 |
| 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 | $11,000 | $6,153 | $46,325 | $49,553 | $36,867 | $33,453 | $58,781 | $43,961 | $40,967 | $37,665 | $82,943 | $58,478 | $52,935 |
| 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 | $500 | $0 | $16,848 | $9,495 | $1,115 | $2,173 | $13,719 | $3,456 | $4,851 | $6,021 | $24,846 | $7,304 | $9,119 |
| 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 | $500 | $0 | $16,848 | $9,495 | $1,115 | $2,173 | $13,719 | $3,456 | $4,851 | $6,021 | $24,846 | $7,304 | $9,119 |
| Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Liabilities | $500 | $0 | $16,848 | $9,495 | $1,115 | $2,173 | $13,719 | $3,456 | $4,851 | $6,021 | $24,846 | $7,304 | $9,119 |
| Paid-in Capital | $13,550 | $13,550 | $13,550 | $13,550 | $13,550 | $13,550 | $13,550 | $13,550 | $13,550 | $13,550 | $13,550 | $13,550 | $13,550 |
| Retained Earnings | ($3,050) | ($3,050) | ($3,050) | ($3,050) | ($3,050) | ($3,050) | ($3,050) | ($3,050) | ($3,050) | ($3,050) | ($3,050) | ($3,050) | ($3,050) |
| Earnings | $0 | ($4,347) | $18,977 | $29,558 | $25,253 | $20,780 | $34,563 | $30,006 | $25,617 | $21,144 | $47,597 | $40,674 | $33,317 |
| Total Capital | $10,500 | $6,153 | $29,477 | $40,058 | $35,753 | $31,280 | $45,063 | $40,506 | $36,117 | $31,644 | $58,097 | $51,174 | $43,817 |
| Total Liabilities and Capital | $11,000 | $6,153 | $46,325 | $49,553 | $36,867 | $33,453 | $58,781 | $43,961 | $40,967 | $37,665 | $82,943 | $58,478 | $52,935 |
| Net Worth | $10,500 | $6,153 | $29,477 | $40,058 | $35,753 | $31,280 | $45,063 | $40,506 | $36,117 | $31,644 | $58,097 | $51,174 | $43,817 |
