Everywhere Assistant
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 | |||||||||||||
Companies | 0% | $200 | $325 | $450 | $500 | $625 | $745 | $780 | $850 | $925 | $1,154 | $1,345 | $1,515 |
Not for profit organizations | 0% | $122 | $198 | $275 | $305 | $381 | $454 | $476 | $519 | $564 | $704 | $820 | $924 |
Individuals | 0% | $108 | $176 | $243 | $270 | $338 | $402 | $421 | $459 | $500 | $623 | $726 | $818 |
Total Sales | $430 | $699 | $968 | $1,075 | $1,344 | $1,602 | $1,677 | $1,828 | $1,989 | $2,481 | $2,892 | $3,257 | |
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 | |
Companies | $10 | $16 | $23 | $25 | $31 | $37 | $39 | $43 | $46 | $58 | $67 | $76 | |
Not for profit organizations | $6 | $10 | $14 | $15 | $19 | $23 | $24 | $26 | $28 | $35 | $41 | $46 | |
Individuals | $5 | $9 | $12 | $14 | $17 | $20 | $21 | $23 | $25 | $31 | $36 | $41 | |
Subtotal Direct Cost of Sales | $22 | $35 | $48 | $54 | $67 | $80 | $84 | $91 | $99 | $124 | $145 | $163 |
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 | ||
Sadie | 0% | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,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 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,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 | 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 | $430 | $699 | $968 | $1,075 | $1,344 | $1,602 | $1,677 | $1,828 | $1,989 | $2,481 | $2,892 | $3,257 | |
Direct Cost of Sales | $22 | $35 | $48 | $54 | $67 | $80 | $84 | $91 | $99 | $124 | $145 | $163 | |
Other Costs of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $22 | $35 | $48 | $54 | $67 | $80 | $84 | $91 | $99 | $124 | $145 | $163 | |
Gross Margin | $409 | $664 | $919 | $1,021 | $1,277 | $1,522 | $1,593 | $1,736 | $1,889 | $2,357 | $2,747 | $3,094 | |
Gross Margin % | 95.00% | 95.00% | 95.00% | 95.00% | 95.00% | 95.00% | 95.00% | 95.00% | 95.00% | 95.00% | 95.00% | 95.00% | |
Expenses | |||||||||||||
Payroll | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | |
Sales and Marketing and Other Expenses | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | |
Depreciation | $117 | $117 | $117 | $117 | $117 | $117 | $117 | $117 | $117 | $117 | $117 | $117 | |
Rent | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | |
Utilities | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | |
Insurance | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | |
Payroll Taxes | 15% | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Operating Expenses | $2,767 | $2,767 | $2,767 | $2,767 | $2,767 | $2,767 | $2,767 | $2,767 | $2,767 | $2,767 | $2,767 | $2,767 | |
Profit Before Interest and Taxes | ($2,359) | ($2,103) | ($1,848) | ($1,746) | ($1,490) | ($1,245) | ($1,174) | ($1,031) | ($878) | ($410) | ($20) | $327 | |
EBITDA | ($2,242) | ($1,986) | ($1,731) | ($1,629) | ($1,373) | ($1,128) | ($1,057) | ($914) | ($761) | ($293) | $97 | $444 | |
Interest Expense | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Taxes Incurred | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Net Profit | ($2,359) | ($2,103) | ($1,848) | ($1,746) | ($1,490) | ($1,245) | ($1,174) | ($1,031) | ($878) | ($410) | ($20) | $327 | |
Net Profit/Sales | -548.49% | -300.99% | -190.99% | -162.40% | -110.92% | -77.75% | -70.00% | -56.41% | -44.13% | -16.52% | -0.69% | 10.05% |
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 | $108 | $175 | $242 | $269 | $336 | $400 | $419 | $457 | $497 | $620 | $723 | $814 | |
Cash from Receivables | $0 | $11 | $329 | $531 | $728 | $813 | $1,014 | $1,203 | $1,262 | $1,375 | $1,504 | $1,871 | |
Subtotal Cash from Operations | $108 | $185 | $571 | $800 | $1,064 | $1,213 | $1,434 | $1,660 | $1,759 | $1,995 | $2,227 | $2,685 | |
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 | $108 | $185 | $571 | $800 | $1,064 | $1,213 | $1,434 | $1,660 | $1,759 | $1,995 | $2,227 | $2,685 | |
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,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | |
Bill Payments | $22 | $672 | $685 | $699 | $704 | $718 | $730 | $734 | $742 | $750 | $775 | $795 | |
Subtotal Spent on Operations | $2,022 | $2,672 | $2,685 | $2,699 | $2,704 | $2,718 | $2,730 | $2,734 | $2,742 | $2,750 | $2,775 | $2,795 | |
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 | $2,022 | $2,672 | $2,685 | $2,699 | $2,704 | $2,718 | $2,730 | $2,734 | $2,742 | $2,750 | $2,775 | $2,795 | |
Net Cash Flow | ($1,915) | ($2,487) | ($2,114) | ($1,899) | ($1,640) | ($1,504) | ($1,297) | ($1,074) | ($983) | ($755) | ($548) | ($110) | |
Cash Balance | $14,885 | $12,399 | $10,284 | $8,385 | $6,745 | $5,241 | $3,944 | $2,870 | $1,887 | $1,132 | $584 | $474 |
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 | $16,800 | $14,885 | $12,399 | $10,284 | $8,385 | $6,745 | $5,241 | $3,944 | $2,870 | $1,887 | $1,132 | $584 | $474 |
Accounts Receivable | $0 | $323 | $836 | $1,232 | $1,508 | $1,787 | $2,176 | $2,419 | $2,586 | $2,817 | $3,303 | $3,968 | $4,539 |
Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Current Assets | $16,800 | $15,208 | $13,234 | $11,517 | $9,893 | $8,533 | $7,417 | $6,363 | $5,457 | $4,704 | $4,435 | $4,552 | $5,014 |
Long-term Assets | |||||||||||||
Long-term Assets | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 |
Accumulated Depreciation | $0 | $117 | $234 | $351 | $468 | $585 | $702 | $819 | $936 | $1,053 | $1,170 | $1,287 | $1,404 |
Total Long-term Assets | $7,000 | $6,883 | $6,766 | $6,649 | $6,532 | $6,415 | $6,298 | $6,181 | $6,064 | $5,947 | $5,830 | $5,713 | $5,596 |
Total Assets | $23,800 | $22,091 | $20,000 | $18,166 | $16,425 | $14,948 | $13,715 | $12,544 | $11,521 | $10,651 | $10,265 | $10,265 | $10,610 |
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 | $649 | $662 | $675 | $680 | $693 | $706 | $709 | $717 | $724 | $748 | $768 | $786 |
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 | $649 | $662 | $675 | $680 | $693 | $706 | $709 | $717 | $724 | $748 | $768 | $786 |
Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Liabilities | $0 | $649 | $662 | $675 | $680 | $693 | $706 | $709 | $717 | $724 | $748 | $768 | $786 |
Paid-in Capital | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 | $30,000 |
Retained Earnings | ($6,200) | ($6,200) | ($6,200) | ($6,200) | ($6,200) | ($6,200) | ($6,200) | ($6,200) | ($6,200) | ($6,200) | ($6,200) | ($6,200) | ($6,200) |
Earnings | $0 | ($2,359) | ($4,462) | ($6,310) | ($8,055) | ($9,546) | ($10,791) | ($11,965) | ($12,996) | ($13,874) | ($14,283) | ($14,303) | ($13,976) |
Total Capital | $23,800 | $21,442 | $19,338 | $17,490 | $15,745 | $14,254 | $13,009 | $11,835 | $10,804 | $9,927 | $9,517 | $9,497 | $9,824 |
Total Liabilities and Capital | $23,800 | $22,091 | $20,000 | $18,166 | $16,425 | $14,948 | $13,715 | $12,544 | $11,521 | $10,651 | $10,265 | $10,265 | $10,610 |
Net Worth | $23,800 | $21,442 | $19,338 | $17,490 | $15,745 | $14,254 | $13,009 | $11,835 | $10,804 | $9,926 | $9,517 | $9,497 | $9,824 |