Voice Control
Appendix
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 | ||
Production Personnel | |||||||||||||
Shipping Clerk | $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 | |
Other | $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 | |
Subtotal | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Sales and Marketing Personnel | |||||||||||||
EMR Sales Representatives | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $8,500 | $8,500 | $8,500 | |
VRS Sales Representatives | $8,500 | $8,500 | $8,500 | $8,500 | $8,500 | $8,500 | $8,500 | $8,500 | $8,500 | $4,792 | $4,792 | $4,792 | |
Name or title | $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 | |
Subtotal | $8,500 | $8,500 | $8,500 | $8,500 | $8,500 | $8,500 | $8,500 | $8,500 | $8,500 | $13,292 | $13,292 | $13,292 | |
General and Administrative Personnel | |||||||||||||
CEO | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
President | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | |
VP VRS | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | |
VP EMR | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | |
Data Base Coordinator | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | $7,500 | |
Project Manager | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $5,000 | $5,000 | $5,000 | |
Administrative Ass’t | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Customer Service Mgr. | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Human Resources Mrg | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
CFO | $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 | |
Subtotal | $32,499 | $32,499 | $32,499 | $32,499 | $32,499 | $32,499 | $32,499 | $32,499 | $32,499 | $37,499 | $37,499 | $37,499 | |
Other Personnel | |||||||||||||
Programmers | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Customer Support | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $4,167 | $4,167 | $4,167 | |
Software Installation Team | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $4,167 | $4,167 | $4,167 | |
Bookkeeper | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Secretary/Bookkeeper | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
HR Consultant | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Software Development Consultant | $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 | |
Subtotal | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $8,334 | $8,334 | $8,334 | |
Total People | 4 | 4 | 4 | 4 | 4 | 4 | 5 | 5 | 5 | 9 | 9 | 9 | |
Total Payroll | $40,999 | $40,999 | $40,999 | $40,999 | $40,999 | $40,999 | $40,999 | $40,999 | $40,999 | $59,125 | $59,125 | $59,125 |
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 | 25.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 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 | $9,600 | $13,400 | $26,500 | $17,900 | $15,900 | $28,500 | $28,500 | $17,900 | $19,300 | $22,300 | $21,000 | $26,200 | |
Direct Cost of Sales | $4,000 | $5,700 | $9,510 | $6,470 | $5,640 | $10,240 | $10,240 | $6,440 | $6,940 | $7,940 | $7,440 | $9,440 | |
Production Payroll | $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 Cost of Sales | $4,000 | $5,700 | $9,510 | $6,470 | $5,640 | $10,240 | $10,240 | $6,440 | $6,940 | $7,940 | $7,440 | $9,440 | |
Gross Margin | $5,600 | $7,700 | $16,990 | $11,430 | $10,260 | $18,260 | $18,260 | $11,460 | $12,360 | $14,360 | $13,560 | $16,760 | |
Gross Margin % | 58.33% | 57.46% | 64.11% | 63.85% | 64.53% | 64.07% | 64.07% | 64.02% | 64.04% | 64.39% | 64.57% | 63.97% | |
Operating Expenses | |||||||||||||
Sales and Marketing Expenses | |||||||||||||
Sales and Marketing Payroll | $8,500 | $8,500 | $8,500 | $8,500 | $8,500 | $8,500 | $8,500 | $8,500 | $8,500 | $13,292 | $13,292 | $13,292 | |
Advertising/Promotion | $29,167 | $29,167 | $29,167 | $29,167 | $29,167 | $29,167 | $29,167 | $29,167 | $29,167 | $29,167 | $29,167 | $29,163 | |
Travel – trade shows | $4,000 | $3,000 | $0 | $2,500 | $0 | $2,500 | $0 | $0 | $0 | $0 | $0 | $0 | |
Trade Shows & Exhibits | $0 | $0 | $2,500 | $13,750 | $0 | $0 | $0 | $12,500 | $0 | $0 | $0 | $1,250 | |
Travel | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | $15,000 | |
Miscellaneous | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | |
Total Sales and Marketing Expenses | $57,667 | $56,667 | $56,167 | $69,917 | $53,667 | $56,167 | $53,667 | $66,167 | $53,667 | $58,459 | $58,459 | $59,705 | |
Sales and Marketing % | 600.70% | 422.89% | 211.95% | 390.60% | 337.53% | 197.08% | 188.31% | 369.65% | 278.07% | 262.15% | 278.38% | 227.88% | |
General and Administrative Expenses | |||||||||||||
General and Administrative Payroll | $32,499 | $32,499 | $32,499 | $32,499 | $32,499 | $32,499 | $32,499 | $32,499 | $32,499 | $37,499 | $37,499 | $37,499 | |
Account Name | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Depreciation | $4,884 | $5,463 | $6,042 | $6,621 | $7,200 | $7,779 | $9,858 | $10,437 | $11,016 | $11,595 | $12,174 | $12,753 | |
Leased Equipment | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | |
Utilities | $992 | $992 | $992 | $992 | $992 | $992 | $992 | $992 | $992 | $992 | $992 | $988 | |
Insurance | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | |
Bank Service charges (credit cards) | $342 | $342 | $342 | $342 | $342 | $342 | $342 | $342 | $342 | $342 | $342 | $338 | |
Dues & Subscriptions | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | |
Meals & Entertainment | $625 | $625 | $625 | $625 | $625 | $625 | $625 | $625 | $625 | $625 | $625 | $625 | |
Meetings & Training | $583 | $583 | $583 | $583 | $583 | $583 | $583 | $583 | $583 | $583 | $583 | $587 | |
Misc | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | |
Office Supplies | $460 | $460 | $460 | $460 | $460 | $460 | $460 | $460 | $460 | $460 | $460 | $440 | |
Postage | $30 | $30 | $30 | $30 | $30 | $30 | $30 | $30 | $30 | $30 | $30 | $30 | |
RV Insurance | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $100 | $100 | $100 | $100 | $100 | |
RV Mileage | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $1,200 | $1,200 | $1,200 | $900 | |
Install/Training Costs | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Royalties | $960 | $1,340 | $1,180 | $760 | $660 | $1,280 | $1,280 | $760 | $830 | $970 | $910 | $1,170 | |
R&D | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Rent | 15% | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 |
Payroll Taxes | 25% | $10,250 | $10,250 | $10,250 | $10,250 | $10,250 | $10,250 | $10,250 | $10,250 | $10,250 | $14,781 | $14,781 | $14,781 |
Total General and Administrative Expenses | $54,875 | $55,834 | $56,253 | $56,412 | $56,891 | $58,090 | $60,169 | $60,328 | $62,177 | $72,427 | $72,946 | $73,461 | |
General and Administrative % | 571.61% | 416.67% | 212.28% | 315.15% | 357.81% | 203.82% | 211.12% | 337.03% | 322.16% | 324.78% | 347.36% | 280.39% | |
Other Expenses: | |||||||||||||
Other Payroll | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $8,334 | $8,334 | $8,334 | |
Consultants | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Executive Hire Search | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Professional Fees | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | |
Human Resources Consultant | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | |
Total Other Expenses | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $10,834 | $10,834 | $10,834 | |
Other % | 26.04% | 18.66% | 9.43% | 13.97% | 15.72% | 8.77% | 8.77% | 13.97% | 12.95% | 48.58% | 51.59% | 41.35% | |
Total Operating Expenses | $115,042 | $115,001 | $114,920 | $128,829 | $113,058 | $116,757 | $116,336 | $128,995 | $118,344 | $141,720 | $142,239 | $144,000 | |
Profit Before Interest and Taxes | ($109,442) | ($107,301) | ($97,930) | ($117,399) | ($102,798) | ($98,497) | ($98,076) | ($117,535) | ($105,984) | ($127,360) | ($128,679) | ($127,240) | |
EBITDA | ($104,558) | ($101,838) | ($91,888) | ($110,778) | ($95,598) | ($90,718) | ($88,218) | ($107,098) | ($94,968) | ($115,765) | ($116,505) | ($114,487) | |
Interest Expense | $0 | $0 | $0 | $0 | $0 | $0 | $750 | $740 | $731 | $721 | $711 | $701 | |
Taxes Incurred | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Net Profit | ($109,442) | ($107,301) | ($97,930) | ($117,399) | ($102,798) | ($98,497) | ($98,826) | ($118,275) | ($106,715) | ($128,081) | ($129,390) | ($127,941) | |
Net Profit/Sales | -1140.02% | -800.75% | -369.55% | -655.86% | -646.53% | -345.60% | -346.76% | -660.76% | -552.93% | -574.35% | -616.14% | -488.32% |
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 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Cash from Receivables | $0 | $320 | $9,727 | $13,837 | $26,213 | $17,833 | $16,320 | $28,500 | $28,147 | $17,947 | $19,400 | $22,257 | |
Subtotal Cash from Operations | $0 | $320 | $9,727 | $13,837 | $26,213 | $17,833 | $16,320 | $28,500 | $28,147 | $17,947 | $19,400 | $22,257 | |
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 | $90,000 | $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 | $604,000 | $0 | |
Subtotal Cash Received | $0 | $320 | $9,727 | $13,837 | $26,213 | $17,833 | $106,320 | $28,500 | $28,147 | $17,947 | $623,400 | $22,257 | |
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 | $40,999 | $40,999 | $40,999 | $40,999 | $40,999 | $40,999 | $40,999 | $40,999 | $40,999 | $59,125 | $59,125 | $59,125 | |
Bill Payments | $2,585 | $77,511 | $76,291 | $81,672 | $83,843 | $70,042 | $83,052 | $76,605 | $80,359 | $74,757 | $80,687 | $78,738 | |
Subtotal Spent on Operations | $43,584 | $118,510 | $117,290 | $122,671 | $124,842 | $111,041 | $124,051 | $117,604 | $121,358 | $133,882 | $139,812 | $137,863 | |
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 | $1,162 | $1,171 | $1,181 | $1,191 | $1,201 | |
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 | $145,833 | $20,833 | $20,833 | $20,833 | $20,833 | $20,833 | $110,833 | $20,833 | $20,833 | $20,833 | $20,833 | $20,837 | |
Dividends | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Cash Spent | $189,417 | $139,343 | $138,123 | $143,504 | $145,675 | $131,874 | $234,884 | $139,599 | $143,362 | $155,896 | $161,836 | $159,901 | |
Net Cash Flow | ($189,417) | ($139,023) | ($128,397) | ($129,667) | ($119,462) | ($114,041) | ($128,564) | ($111,099) | ($115,215) | ($137,949) | $461,564 | ($137,645) | |
Cash Balance | $1,264,217 | $1,125,194 | $996,797 | $867,130 | $747,668 | $633,627 | $505,063 | $393,964 | $278,748 | $140,799 | $602,364 | $464,719 |
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 | $1,453,634 | $1,264,217 | $1,125,194 | $996,797 | $867,130 | $747,668 | $633,627 | $505,063 | $393,964 | $278,748 | $140,799 | $602,364 | $464,719 |
Accounts Receivable | $0 | $9,600 | $22,680 | $39,453 | $43,517 | $33,203 | $43,870 | $56,050 | $45,450 | $36,603 | $40,957 | $42,557 | $46,500 |
Inventory | $0 | $4,400 | $6,270 | $10,461 | $7,117 | $6,204 | $11,264 | $11,264 | $7,084 | $7,634 | $8,734 | $8,184 | $10,384 |
Other Current Assets | $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 |
Total Current Assets | $1,483,634 | $1,308,217 | $1,184,144 | $1,076,712 | $947,764 | $817,075 | $718,761 | $602,377 | $476,498 | $352,986 | $220,490 | $683,104 | $551,603 |
Long-term Assets | |||||||||||||
Long-term Assets | $0 | $145,833 | $166,666 | $187,499 | $208,332 | $229,165 | $249,998 | $360,831 | $381,664 | $402,497 | $423,330 | $444,163 | $465,000 |
Accumulated Depreciation | $0 | $4,884 | $10,347 | $16,389 | $23,010 | $30,210 | $37,989 | $47,847 | $58,284 | $69,300 | $80,895 | $93,069 | $105,822 |
Total Long-term Assets | $0 | $140,949 | $156,319 | $171,110 | $185,322 | $198,955 | $212,009 | $312,984 | $323,380 | $333,197 | $342,435 | $351,094 | $359,178 |
Total Assets | $1,483,634 | $1,449,166 | $1,340,463 | $1,247,822 | $1,133,086 | $1,016,030 | $930,770 | $915,361 | $799,878 | $686,183 | $562,925 | $1,034,198 | $910,781 |
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 | $74,974 | $73,572 | $78,861 | $81,524 | $67,266 | $80,503 | $73,920 | $77,874 | $72,065 | $78,069 | $75,923 | $81,647 |
Current Borrowing | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $90,000 | $88,838 | $87,667 | $86,486 | $85,295 | $84,094 |
Other Current Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Subtotal Current Liabilities | $0 | $74,974 | $73,572 | $78,861 | $81,524 | $67,266 | $80,503 | $163,920 | $166,712 | $159,732 | $164,555 | $161,218 | $165,741 |
Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Liabilities | $0 | $74,974 | $73,572 | $78,861 | $81,524 | $67,266 | $80,503 | $163,920 | $166,712 | $159,732 | $164,555 | $161,218 | $165,741 |
Paid-in Capital | $1,630,000 | $1,630,000 | $1,630,000 | $1,630,000 | $1,630,000 | $1,630,000 | $1,630,000 | $1,630,000 | $1,630,000 | $1,630,000 | $1,630,000 | $2,234,000 | $2,234,000 |
Retained Earnings | ($146,366) | ($146,366) | ($146,366) | ($146,366) | ($146,366) | ($146,366) | ($146,366) | ($146,366) | ($146,366) | ($146,366) | ($146,366) | ($146,366) | ($146,366) |
Earnings | $0 | ($109,442) | ($216,743) | ($314,673) | ($432,072) | ($534,870) | ($633,367) | ($732,193) | ($850,468) | ($957,183) | ($1,085,264) | ($1,214,653) | ($1,342,594) |
Total Capital | $1,483,634 | $1,374,192 | $1,266,891 | $1,168,961 | $1,051,562 | $948,764 | $850,267 | $751,441 | $633,166 | $526,451 | $398,370 | $872,981 | $745,040 |
Total Liabilities and Capital | $1,483,634 | $1,449,166 | $1,340,463 | $1,247,822 | $1,133,086 | $1,016,030 | $930,770 | $915,361 | $799,878 | $686,183 | $562,925 | $1,034,198 | $910,781 |
Net Worth | $1,483,634 | $1,374,192 | $1,266,891 | $1,168,961 | $1,051,562 | $948,764 | $850,267 | $751,441 | $633,166 | $526,451 | $398,370 | $872,981 | $745,040 |
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 | |||||||||||||
EMR | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
VRS | 0% | $0 | $0 | $14,700 | $10,300 | $9,300 | $15,700 | $15,700 | $10,300 | $11,000 | $12,600 | $11,900 | $14,500 |
Ophthalmic Products | 0% | $9,600 | $13,400 | $11,800 | $7,600 | $6,600 | $12,800 | $12,800 | $7,600 | $8,300 | $9,700 | $9,100 | $11,700 |
Installation & Training Income | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Sales | $9,600 | $13,400 | $26,500 | $17,900 | $15,900 | $28,500 | $28,500 | $17,900 | $19,300 | $22,300 | $21,000 | $26,200 | |
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 | |
EMR | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
VRS | $0 | $0 | $4,510 | $3,270 | $2,840 | $4,840 | $4,840 | $3,240 | $3,440 | $3,840 | $3,640 | $4,540 | |
Ophthalmic Products | $4,000 | $5,700 | $5,000 | $3,200 | $2,800 | $5,400 | $5,400 | $3,200 | $3,500 | $4,100 | $3,800 | $4,900 | |
Installation & Training Income | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Direct Cost of Sales | $4,000 | $5,700 | $9,510 | $6,470 | $5,640 | $10,240 | $10,240 | $6,440 | $6,940 | $7,940 | $7,440 | $9,440 |