| 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 | |
| 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 | |