Our biggest savings of the year
Bioring SA
Appendix
Sales Forecast | |||||||||||||
Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
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 |