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