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 |