| 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 | ||
| Unit Sales | |||||||||||||
| K. Biodegradable Ring | 0% | 0 | 0 | 0 | 0 | 0 | 1,000 | 500 | 500 | 500 | 500 | 500 | 500 |
| Other | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Total Unit Sales | 0 | 0 | 0 | 0 | 0 | 1,000 | 500 | 500 | 500 | 500 | 500 | 500 | |
| Unit Prices | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| K. Biodegradable Ring | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £625.00 | £625.00 | £625.00 | £625.00 | £625.00 | £625.00 | £625.00 | |
| Other | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | |
| Sales | |||||||||||||
| K. Biodegradable Ring | £0 | £0 | £0 | £0 | £0 | £625,000 | £312,500 | £312,500 | £312,500 | £312,500 | £312,500 | £312,500 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Sales | £0 | £0 | £0 | £0 | £0 | £625,000 | £312,500 | £312,500 | £312,500 | £312,500 | £312,500 | £312,500 | |
| Direct Unit Costs | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| K. Biodegradable Ring | 0.00% | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £35.00 | £35.00 | £35.00 | £35.00 | £35.00 | £35.00 | £35.00 |
| Other | 0.00% | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 |
| Direct Cost of Sales | |||||||||||||
| K. Biodegradable Ring | £0 | £0 | £0 | £0 | £0 | £35,000 | £17,500 | £17,500 | £17,500 | £17,500 | £17,500 | £17,500 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £0 | £0 | £0 | £35,000 | £17,500 | £17,500 | £17,500 | £17,500 | £17,500 | £17,500 | |
| 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 | |||||||||||||
| M. Bertholet | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £1,505 | £3,050 | £3,050 | |
| M.J. Raposo | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £1,425 | £2,850 | £2,850 | |
| 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 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £2,930 | £5,900 | £5,900 | |
| Sales and Marketing Personnel | |||||||||||||
| R. Andrieu 80% | £0 | £0 | £0 | £6,500 | £6,500 | £6,500 | £6,500 | £6,500 | £6,500 | £6,500 | £6,500 | £6,500 | |
| D. Collomb 20% | £0 | £0 | £0 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | |
| Clinical Director | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Marketing Executive | £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 | £7,250 | £7,250 | £7,250 | £7,250 | £7,250 | £7,250 | £7,250 | £7,250 | £7,250 | |
| General and Administrative Personnel | |||||||||||||
| R. Andrieu 20% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| D. Collomb 80% | £0 | £0 | £0 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| CE mark consulting fees | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| FDA consulting fees | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other | £0 | £0 | £0 | £235 | £235 | £235 | £235 | £235 | £235 | £235 | £235 | £235 | |
| Subtotal | £0 | £0 | £0 | £3,235 | £3,235 | £3,235 | £3,235 | £3,235 | £3,235 | £3,235 | £3,235 | £3,235 | |
| Other Personnel | |||||||||||||
| P.Le Goff | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Name or title | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| 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 | £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 | £0 | £0 | £0 | £10,485 | £10,485 | £10,485 | £10,485 | £10,485 | £10,485 | £13,415 | £16,385 | £16,385 | |
| 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 | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | |
| Long-term Interest Rate | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | |
| Tax Rate | 30.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.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 | £0 | £0 | £0 | £0 | £0 | £625,000 | £312,500 | £312,500 | £312,500 | £312,500 | £312,500 | £312,500 | |
| Direct Cost of Sales | £0 | £0 | £0 | £0 | £0 | £35,000 | £17,500 | £17,500 | £17,500 | £17,500 | £17,500 | £17,500 | |
| Production Payroll | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £2,930 | £5,900 | £5,900 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £0 | £0 | £0 | £0 | £35,000 | £17,500 | £17,500 | £17,500 | £20,430 | £23,400 | £23,400 | |
| Gross Margin | £0 | £0 | £0 | £0 | £0 | £590,000 | £295,000 | £295,000 | £295,000 | £292,070 | £289,100 | £289,100 | |
| Gross Margin % | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 94.40% | 94.40% | 94.40% | 94.40% | 93.46% | 92.51% | 92.51% | |
| Operating Expenses | |||||||||||||
| Sales and Marketing Expenses | |||||||||||||
| Sales and Marketing Payroll | £0 | £0 | £0 | £7,250 | £7,250 | £7,250 | £7,250 | £7,250 | £7,250 | £7,250 | £7,250 | £7,250 | |
| Advertising/Promotion | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Travel | £0 | £0 | £0 | £0 | £0 | £2,000 | £0 | £0 | £2,000 | £0 | £2,000 | £0 | |
| Miscellaneous | £0 | £0 | £0 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | |
| Total Sales and Marketing Expenses | £0 | £0 | £0 | £8,750 | £8,750 | £10,750 | £8,750 | £8,750 | £10,750 | £8,750 | £10,750 | £8,750 | |
| Sales and Marketing % | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 1.72% | 2.80% | 2.80% | 3.44% | 2.80% | 3.44% | 2.80% | |
| General and Administrative Expenses | |||||||||||||
| General and Administrative Payroll | £0 | £0 | £0 | £3,235 | £3,235 | £3,235 | £3,235 | £3,235 | £3,235 | £3,235 | £3,235 | £3,235 | |
| Sales and Marketing and Other Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Depreciation | £0 | £0 | £0 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | |
| Patent fees for PCT | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £10,000 | |
| Utilities | £0 | £0 | £0 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | |
| Insurance | £0 | £0 | £0 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Rent | £0 | £0 | £0 | £3,700 | £3,700 | £3,700 | £3,700 | £3,700 | £3,700 | £3,700 | £3,700 | £3,700 | |
| Payroll Taxes | 25% | £0 | £0 | £0 | £2,621 | £2,621 | £2,621 | £2,621 | £2,621 | £2,621 | £3,354 | £4,096 | £4,096 |
| Other General and Administrative Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total General and Administrative Expenses | £0 | £0 | £0 | £18,906 | £18,906 | £18,906 | £18,906 | £18,906 | £18,906 | £19,639 | £20,381 | £30,381 | |
| General and Administrative % | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 3.03% | 6.05% | 6.05% | 6.05% | 6.28% | 6.52% | 9.72% | |
| Other Expenses: | |||||||||||||
| Other Payroll | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Consultants | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Royalties Dr. A.Kalangos | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Other Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other % | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |
| Total Operating Expenses | £0 | £0 | £0 | £27,656 | £27,656 | £29,656 | £27,656 | £27,656 | £29,656 | £28,389 | £31,131 | £39,131 | |
| Profit Before Interest and Taxes | £0 | £0 | £0 | (£27,656) | (£27,656) | £560,344 | £267,344 | £267,344 | £265,344 | £263,681 | £257,969 | £249,969 | |
| EBITDA | £0 | £0 | £0 | (£19,656) | (£19,656) | £568,344 | £275,344 | £275,344 | £273,344 | £271,681 | £265,969 | £257,969 | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes Incurred | £0 | £0 | £0 | (£2,766) | (£2,766) | £56,034 | £26,734 | £26,734 | £26,534 | £26,368 | £25,797 | £24,997 | |
| Net Profit | £0 | £0 | £0 | (£24,891) | (£24,891) | £504,309 | £240,609 | £240,609 | £238,809 | £237,313 | £232,172 | £224,972 | |
| Net Profit/Sales | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 80.69% | 77.00% | 77.00% | 76.42% | 75.94% | 74.30% | 71.99% | |
| 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 | £156,250 | £78,125 | £78,125 | £78,125 | £78,125 | £78,125 | £78,125 | |
| Cash from Receivables | £0 | £0 | £0 | £0 | £0 | £0 | £15,625 | £460,938 | £234,375 | £234,375 | £234,375 | £234,375 | |
| Subtotal Cash from Operations | £0 | £0 | £0 | £0 | £0 | £156,250 | £93,750 | £539,063 | £312,500 | £312,500 | £312,500 | £312,500 | |
| 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 | £100,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £0 | £0 | £0 | £100,000 | £0 | £156,250 | £93,750 | £539,063 | £312,500 | £312,500 | £312,500 | £312,500 | |
| 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 | £0 | £0 | £0 | £10,485 | £10,485 | £10,485 | £10,485 | £10,485 | £10,485 | £13,415 | £16,385 | £16,385 | |
| Bill Payments | £0 | £0 | £0 | £214 | £6,406 | £8,432 | £66,162 | £36,381 | £50,324 | £55,158 | £53,844 | £56,183 | |
| Subtotal Spent on Operations | £0 | £0 | £0 | £10,699 | £16,891 | £18,917 | £76,647 | £46,866 | £60,809 | £68,573 | £70,229 | £72,568 | |
| 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 | £0 | £0 | £0 | £10,699 | £16,891 | £18,917 | £76,647 | £46,866 | £60,809 | £68,573 | £70,229 | £72,568 | |
| Net Cash Flow | £0 | £0 | £0 | £89,301 | (£16,891) | £137,333 | £17,103 | £492,197 | £251,691 | £243,927 | £242,271 | £239,932 | |
| Cash Balance | £29,000 | £29,000 | £29,000 | £118,301 | £101,411 | £238,744 | £255,846 | £748,043 | £999,734 | £1,243,661 | £1,485,932 | £1,725,864 | |
| 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 | £29,000 | £29,000 | £29,000 | £29,000 | £118,301 | £101,411 | £238,744 | £255,846 | £748,043 | £999,734 | £1,243,661 | £1,485,932 | £1,725,864 |
| Accounts Receivable | £0 | £0 | £0 | £0 | £0 | £0 | £468,750 | £687,500 | £460,938 | £460,938 | £460,938 | £460,938 | £460,938 |
| Inventory | £75,000 | £75,000 | £75,000 | £75,000 | £75,000 | £75,000 | £40,000 | £22,500 | £19,250 | £19,250 | £19,250 | £19,250 | £19,250 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £104,000 | £104,000 | £104,000 | £104,000 | £193,301 | £176,411 | £747,494 | £965,846 | £1,228,231 | £1,479,922 | £1,723,849 | £1,966,120 | £2,206,051 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £280,000 | £280,000 | £280,000 | £280,000 | £280,000 | £280,000 | £280,000 | £280,000 | £280,000 | £280,000 | £280,000 | £280,000 | £280,000 |
| Accumulated Depreciation | £0 | £0 | £0 | £0 | £8,000 | £16,000 | £24,000 | £32,000 | £40,000 | £48,000 | £56,000 | £64,000 | £72,000 |
| Total Long-term Assets | £280,000 | £280,000 | £280,000 | £280,000 | £272,000 | £264,000 | £256,000 | £248,000 | £240,000 | £232,000 | £224,000 | £216,000 | £208,000 |
| Total Assets | £384,000 | £384,000 | £384,000 | £384,000 | £465,301 | £440,411 | £1,003,494 | £1,213,846 | £1,468,231 | £1,711,922 | £1,947,849 | £2,182,120 | £2,414,051 |
| 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 | £0 | £0 | £0 | £6,192 | £6,192 | £64,965 | £34,709 | £48,484 | £53,365 | £51,979 | £54,078 | £61,038 |
| 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 | £0 | £0 | £0 | £6,192 | £6,192 | £64,965 | £34,709 | £48,484 | £53,365 | £51,979 | £54,078 | £61,038 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £0 | £0 | £0 | £6,192 | £6,192 | £64,965 | £34,709 | £48,484 | £53,365 | £51,979 | £54,078 | £61,038 |
| Paid-in Capital | £642,500 | £642,500 | £642,500 | £642,500 | £742,500 | £742,500 | £742,500 | £742,500 | £742,500 | £742,500 | £742,500 | £742,500 | £742,500 |
| Retained Earnings | (£258,500) | (£258,500) | (£258,500) | (£258,500) | (£258,500) | (£258,500) | (£258,500) | (£258,500) | (£258,500) | (£258,500) | (£258,500) | (£258,500) | (£258,500) |
| Earnings | £0 | £0 | £0 | £0 | (£24,891) | (£49,781) | £454,528 | £695,138 | £935,747 | £1,174,556 | £1,411,869 | £1,644,041 | £1,869,013 |
| Total Capital | £384,000 | £384,000 | £384,000 | £384,000 | £459,109 | £434,219 | £938,528 | £1,179,138 | £1,419,747 | £1,658,556 | £1,895,869 | £2,128,041 | £2,353,013 |
| Total Liabilities and Capital | £384,000 | £384,000 | £384,000 | £384,000 | £465,301 | £440,411 | £1,003,494 | £1,213,846 | £1,468,231 | £1,711,922 | £1,947,849 | £2,182,120 | £2,414,051 |
| Net Worth | £384,000 | £384,000 | £384,000 | £384,000 | £459,109 | £434,219 | £938,528 | £1,179,138 | £1,419,747 | £1,658,556 | £1,895,869 | £2,128,041 | £2,353,013 |
| 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 | ||
| Unit Sales | |||||||||||||
| K. Biodegradable Ring | 0% | 0 | 0 | 0 | 0 | 0 | 1,000 | 500 | 500 | 500 | 500 | 500 | 500 |
| Other | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Total Unit Sales | 0 | 0 | 0 | 0 | 0 | 1,000 | 500 | 500 | 500 | 500 | 500 | 500 | |
| Unit Prices | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| K. Biodegradable Ring | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £625.00 | £625.00 | £625.00 | £625.00 | £625.00 | £625.00 | £625.00 | |
| Other | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | |
| Sales | |||||||||||||
| K. Biodegradable Ring | £0 | £0 | £0 | £0 | £0 | £625,000 | £312,500 | £312,500 | £312,500 | £312,500 | £312,500 | £312,500 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Sales | £0 | £0 | £0 | £0 | £0 | £625,000 | £312,500 | £312,500 | £312,500 | £312,500 | £312,500 | £312,500 | |
| Direct Unit Costs | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
| K. Biodegradable Ring | 0.00% | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £35.00 | £35.00 | £35.00 | £35.00 | £35.00 | £35.00 | £35.00 |
| Other | 0.00% | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 |
| Direct Cost of Sales | |||||||||||||
| K. Biodegradable Ring | £0 | £0 | £0 | £0 | £0 | £35,000 | £17,500 | £17,500 | £17,500 | £17,500 | £17,500 | £17,500 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £0 | £0 | £0 | £0 | £0 | £35,000 | £17,500 | £17,500 | £17,500 | £17,500 | £17,500 | £17,500 | |
| 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 | |||||||||||||
| M. Bertholet | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £1,505 | £3,050 | £3,050 | |
| M.J. Raposo | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £1,425 | £2,850 | £2,850 | |
| 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 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £2,930 | £5,900 | £5,900 | |
| Sales and Marketing Personnel | |||||||||||||
| R. Andrieu 80% | £0 | £0 | £0 | £6,500 | £6,500 | £6,500 | £6,500 | £6,500 | £6,500 | £6,500 | £6,500 | £6,500 | |
| D. Collomb 20% | £0 | £0 | £0 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | |
| Clinical Director | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Marketing Executive | £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 | £7,250 | £7,250 | £7,250 | £7,250 | £7,250 | £7,250 | £7,250 | £7,250 | £7,250 | |
| General and Administrative Personnel | |||||||||||||
| R. Andrieu 20% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| D. Collomb 80% | £0 | £0 | £0 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | £3,000 | |
| CE mark consulting fees | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| FDA consulting fees | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other | £0 | £0 | £0 | £235 | £235 | £235 | £235 | £235 | £235 | £235 | £235 | £235 | |
| Subtotal | £0 | £0 | £0 | £3,235 | £3,235 | £3,235 | £3,235 | £3,235 | £3,235 | £3,235 | £3,235 | £3,235 | |
| Other Personnel | |||||||||||||
| P.Le Goff | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Name or title | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| 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 | £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 | £0 | £0 | £0 | £10,485 | £10,485 | £10,485 | £10,485 | £10,485 | £10,485 | £13,415 | £16,385 | £16,385 | |
| 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 | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | |
| Long-term Interest Rate | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | |
| Tax Rate | 30.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.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 | £0 | £0 | £0 | £0 | £0 | £625,000 | £312,500 | £312,500 | £312,500 | £312,500 | £312,500 | £312,500 | |
| Direct Cost of Sales | £0 | £0 | £0 | £0 | £0 | £35,000 | £17,500 | £17,500 | £17,500 | £17,500 | £17,500 | £17,500 | |
| Production Payroll | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £2,930 | £5,900 | £5,900 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £0 | £0 | £0 | £0 | £0 | £35,000 | £17,500 | £17,500 | £17,500 | £20,430 | £23,400 | £23,400 | |
| Gross Margin | £0 | £0 | £0 | £0 | £0 | £590,000 | £295,000 | £295,000 | £295,000 | £292,070 | £289,100 | £289,100 | |
| Gross Margin % | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 94.40% | 94.40% | 94.40% | 94.40% | 93.46% | 92.51% | 92.51% | |
| Operating Expenses | |||||||||||||
| Sales and Marketing Expenses | |||||||||||||
| Sales and Marketing Payroll | £0 | £0 | £0 | £7,250 | £7,250 | £7,250 | £7,250 | £7,250 | £7,250 | £7,250 | £7,250 | £7,250 | |
| Advertising/Promotion | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Travel | £0 | £0 | £0 | £0 | £0 | £2,000 | £0 | £0 | £2,000 | £0 | £2,000 | £0 | |
| Miscellaneous | £0 | £0 | £0 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | |
| Total Sales and Marketing Expenses | £0 | £0 | £0 | £8,750 | £8,750 | £10,750 | £8,750 | £8,750 | £10,750 | £8,750 | £10,750 | £8,750 | |
| Sales and Marketing % | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 1.72% | 2.80% | 2.80% | 3.44% | 2.80% | 3.44% | 2.80% | |
| General and Administrative Expenses | |||||||||||||
| General and Administrative Payroll | £0 | £0 | £0 | £3,235 | £3,235 | £3,235 | £3,235 | £3,235 | £3,235 | £3,235 | £3,235 | £3,235 | |
| Sales and Marketing and Other Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Depreciation | £0 | £0 | £0 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | £8,000 | |
| Patent fees for PCT | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £10,000 | |
| Utilities | £0 | £0 | £0 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | £350 | |
| Insurance | £0 | £0 | £0 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | |
| Rent | £0 | £0 | £0 | £3,700 | £3,700 | £3,700 | £3,700 | £3,700 | £3,700 | £3,700 | £3,700 | £3,700 | |
| Payroll Taxes | 25% | £0 | £0 | £0 | £2,621 | £2,621 | £2,621 | £2,621 | £2,621 | £2,621 | £3,354 | £4,096 | £4,096 |
| Other General and Administrative Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total General and Administrative Expenses | £0 | £0 | £0 | £18,906 | £18,906 | £18,906 | £18,906 | £18,906 | £18,906 | £19,639 | £20,381 | £30,381 | |
| General and Administrative % | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 3.03% | 6.05% | 6.05% | 6.05% | 6.28% | 6.52% | 9.72% | |
| Other Expenses: | |||||||||||||
| Other Payroll | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Consultants | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Royalties Dr. A.Kalangos | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Other Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Other % | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |
| Total Operating Expenses | £0 | £0 | £0 | £27,656 | £27,656 | £29,656 | £27,656 | £27,656 | £29,656 | £28,389 | £31,131 | £39,131 | |
| Profit Before Interest and Taxes | £0 | £0 | £0 | (£27,656) | (£27,656) | £560,344 | £267,344 | £267,344 | £265,344 | £263,681 | £257,969 | £249,969 | |
| EBITDA | £0 | £0 | £0 | (£19,656) | (£19,656) | £568,344 | £275,344 | £275,344 | £273,344 | £271,681 | £265,969 | £257,969 | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes Incurred | £0 | £0 | £0 | (£2,766) | (£2,766) | £56,034 | £26,734 | £26,734 | £26,534 | £26,368 | £25,797 | £24,997 | |
| Net Profit | £0 | £0 | £0 | (£24,891) | (£24,891) | £504,309 | £240,609 | £240,609 | £238,809 | £237,313 | £232,172 | £224,972 | |
| Net Profit/Sales | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 80.69% | 77.00% | 77.00% | 76.42% | 75.94% | 74.30% | 71.99% | |
| 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 | £156,250 | £78,125 | £78,125 | £78,125 | £78,125 | £78,125 | £78,125 | |
| Cash from Receivables | £0 | £0 | £0 | £0 | £0 | £0 | £15,625 | £460,938 | £234,375 | £234,375 | £234,375 | £234,375 | |
| Subtotal Cash from Operations | £0 | £0 | £0 | £0 | £0 | £156,250 | £93,750 | £539,063 | £312,500 | £312,500 | £312,500 | £312,500 | |
| 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 | £100,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Received | £0 | £0 | £0 | £100,000 | £0 | £156,250 | £93,750 | £539,063 | £312,500 | £312,500 | £312,500 | £312,500 | |
| 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 | £0 | £0 | £0 | £10,485 | £10,485 | £10,485 | £10,485 | £10,485 | £10,485 | £13,415 | £16,385 | £16,385 | |
| Bill Payments | £0 | £0 | £0 | £214 | £6,406 | £8,432 | £66,162 | £36,381 | £50,324 | £55,158 | £53,844 | £56,183 | |
| Subtotal Spent on Operations | £0 | £0 | £0 | £10,699 | £16,891 | £18,917 | £76,647 | £46,866 | £60,809 | £68,573 | £70,229 | £72,568 | |
| 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 | £0 | £0 | £0 | £10,699 | £16,891 | £18,917 | £76,647 | £46,866 | £60,809 | £68,573 | £70,229 | £72,568 | |
| Net Cash Flow | £0 | £0 | £0 | £89,301 | (£16,891) | £137,333 | £17,103 | £492,197 | £251,691 | £243,927 | £242,271 | £239,932 | |
| Cash Balance | £29,000 | £29,000 | £29,000 | £118,301 | £101,411 | £238,744 | £255,846 | £748,043 | £999,734 | £1,243,661 | £1,485,932 | £1,725,864 | |
| 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 | £29,000 | £29,000 | £29,000 | £29,000 | £118,301 | £101,411 | £238,744 | £255,846 | £748,043 | £999,734 | £1,243,661 | £1,485,932 | £1,725,864 |
| Accounts Receivable | £0 | £0 | £0 | £0 | £0 | £0 | £468,750 | £687,500 | £460,938 | £460,938 | £460,938 | £460,938 | £460,938 |
| Inventory | £75,000 | £75,000 | £75,000 | £75,000 | £75,000 | £75,000 | £40,000 | £22,500 | £19,250 | £19,250 | £19,250 | £19,250 | £19,250 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £104,000 | £104,000 | £104,000 | £104,000 | £193,301 | £176,411 | £747,494 | £965,846 | £1,228,231 | £1,479,922 | £1,723,849 | £1,966,120 | £2,206,051 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £280,000 | £280,000 | £280,000 | £280,000 | £280,000 | £280,000 | £280,000 | £280,000 | £280,000 | £280,000 | £280,000 | £280,000 | £280,000 |
| Accumulated Depreciation | £0 | £0 | £0 | £0 | £8,000 | £16,000 | £24,000 | £32,000 | £40,000 | £48,000 | £56,000 | £64,000 | £72,000 |
| Total Long-term Assets | £280,000 | £280,000 | £280,000 | £280,000 | £272,000 | £264,000 | £256,000 | £248,000 | £240,000 | £232,000 | £224,000 | £216,000 | £208,000 |
| Total Assets | £384,000 | £384,000 | £384,000 | £384,000 | £465,301 | £440,411 | £1,003,494 | £1,213,846 | £1,468,231 | £1,711,922 | £1,947,849 | £2,182,120 | £2,414,051 |
| 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 | £0 | £0 | £0 | £6,192 | £6,192 | £64,965 | £34,709 | £48,484 | £53,365 | £51,979 | £54,078 | £61,038 |
| 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 | £0 | £0 | £0 | £6,192 | £6,192 | £64,965 | £34,709 | £48,484 | £53,365 | £51,979 | £54,078 | £61,038 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £0 | £0 | £0 | £0 | £6,192 | £6,192 | £64,965 | £34,709 | £48,484 | £53,365 | £51,979 | £54,078 | £61,038 |
| Paid-in Capital | £642,500 | £642,500 | £642,500 | £642,500 | £742,500 | £742,500 | £742,500 | £742,500 | £742,500 | £742,500 | £742,500 | £742,500 | £742,500 |
| Retained Earnings | (£258,500) | (£258,500) | (£258,500) | (£258,500) | (£258,500) | (£258,500) | (£258,500) | (£258,500) | (£258,500) | (£258,500) | (£258,500) | (£258,500) | (£258,500) |
| Earnings | £0 | £0 | £0 | £0 | (£24,891) | (£49,781) | £454,528 | £695,138 | £935,747 | £1,174,556 | £1,411,869 | £1,644,041 | £1,869,013 |
| Total Capital | £384,000 | £384,000 | £384,000 | £384,000 | £459,109 | £434,219 | £938,528 | £1,179,138 | £1,419,747 | £1,658,556 | £1,895,869 | £2,128,041 | £2,353,013 |
| Total Liabilities and Capital | £384,000 | £384,000 | £384,000 | £384,000 | £465,301 | £440,411 | £1,003,494 | £1,213,846 | £1,468,231 | £1,711,922 | £1,947,849 | £2,182,120 | £2,414,051 |
| Net Worth | £384,000 | £384,000 | £384,000 | £384,000 | £459,109 | £434,219 | £938,528 | £1,179,138 | £1,419,747 | £1,658,556 | £1,895,869 | £2,128,041 | £2,353,013 |