Bionex Corporation
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 | ||
Sales | |||||||||||||
Xenasys Transaction Systems | 0% | $16,000 | $16,650 | $15,548 | $15,730 | $15,239 | $25,125 | $27,444 | $31,260 | $36,649 | $39,697 | $46,501 | $49,176 |
Xenavex Identification Platforms | 0% | $15,255 | $15,793 | $13,562 | $13,597 | $13,936 | $22,626 | $28,720 | $34,279 | $34,370 | $41,000 | $41,487 | $47,710 |
BioXen Biometric Devices | 0% | $8,766 | $10,607 | $12,834 | $15,530 | $18,791 | $22,737 | $39,511 | $56,289 | $55,280 | $39,738 | $28,973 | $21,358 |
Total Sales | $40,021 | $43,050 | $41,944 | $44,857 | $47,966 | $70,488 | $95,675 | $121,828 | $126,299 | $120,435 | $116,961 | $118,244 | |
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 | |
Xenasys Transaction Systems | $7,211 | $7,524 | $7,855 | $7,206 | $7,579 | $7,973 | $7,392 | $7,835 | $7,306 | $7,804 | $7,332 | $7,892 | |
Xenavex Identification Platforms | $7,211 | $7,472 | $7,745 | $7,032 | $7,334 | $7,651 | $7,983 | $7,332 | $7,699 | $7,084 | $7,488 | $7,913 | |
BioXen Biometric Devices | $7,700 | $7,985 | $7,284 | $7,598 | $7,928 | $8,275 | $8,639 | $9,020 | $7,421 | $7,843 | $7,285 | $7,749 | |
Subtotal Direct Cost of Sales | $22,122 | $22,981 | $22,884 | $21,836 | $22,841 | $23,899 | $24,014 | $24,187 | $22,426 | $22,731 | $22,105 | $23,554 |
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 | ||
CEO | 0% | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $5,000 |
CFO | 0% | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $7,000 | $5,000 | $7,000 |
President of Engineering | 0% | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 |
President of Sales | 0% | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 |
President of Marketing | 0% | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 |
Total People | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | |
Total Payroll | $32,000 | $32,000 | $32,000 | $32,000 | $32,000 | $32,000 | $32,000 | $32,000 | $32,000 | $32,000 | $30,000 | $30,000 |
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 | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.00% | 9.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 | $40,021 | $43,050 | $41,944 | $44,857 | $47,966 | $70,488 | $95,675 | $121,828 | $126,299 | $120,435 | $116,961 | $118,244 | |
Direct Cost of Sales | $22,122 | $22,981 | $22,884 | $21,836 | $22,841 | $23,899 | $24,014 | $24,187 | $22,426 | $22,731 | $22,105 | $23,554 | |
Other Costs of Goods | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $22,122 | $22,981 | $22,884 | $21,836 | $22,841 | $23,899 | $24,014 | $24,187 | $22,426 | $22,731 | $22,105 | $23,554 | |
Gross Margin | $17,899 | $20,069 | $19,060 | $23,021 | $25,125 | $46,589 | $71,661 | $97,641 | $103,873 | $97,704 | $94,856 | $94,690 | |
Gross Margin % | 44.72% | 46.62% | 45.44% | 51.32% | 52.38% | 66.09% | 74.90% | 80.15% | 82.24% | 81.13% | 81.10% | 80.08% | |
Expenses | |||||||||||||
Payroll | $32,000 | $32,000 | $32,000 | $32,000 | $32,000 | $32,000 | $32,000 | $32,000 | $32,000 | $32,000 | $30,000 | $30,000 | |
Sales and Marketing and Other Expenses | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | |
Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Contracted Employees | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Rent | $4,166 | $4,166 | $4,166 | $4,166 | $4,166 | $4,166 | $4,166 | $4,166 | $4,166 | $4,166 | $4,166 | $4,166 | |
Utilities | $125 | $125 | $125 | $125 | $125 | $125 | $125 | $125 | $125 | $125 | $125 | $125 | |
Insurance | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | |
Payroll Taxes | 15% | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 | $4,800 | $4,500 | $4,500 |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Operating Expenses | $42,591 | $42,591 | $42,591 | $42,591 | $42,591 | $42,591 | $42,591 | $42,591 | $42,591 | $42,591 | $40,291 | $40,291 | |
Profit Before Interest and Taxes | ($24,692) | ($22,522) | ($23,531) | ($19,570) | ($17,466) | $3,998 | $29,070 | $55,050 | $61,282 | $55,113 | $54,565 | $54,399 | |
EBITDA | ($24,692) | ($22,522) | ($23,531) | ($19,570) | ($17,466) | $3,998 | $29,070 | $55,050 | $61,282 | $55,113 | $54,565 | $54,399 | |
Interest Expense | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Taxes Incurred | ($6,173) | ($5,631) | ($5,883) | ($4,893) | ($4,367) | $999 | $7,268 | $13,763 | $15,321 | $13,778 | $13,641 | $13,600 | |
Net Profit | ($18,519) | ($16,892) | ($17,648) | ($14,678) | ($13,100) | $2,998 | $21,803 | $41,288 | $45,962 | $41,335 | $40,924 | $40,799 | |
Net Profit/Sales | -46.27% | -39.24% | -42.07% | -32.72% | -27.31% | 4.25% | 22.79% | 33.89% | 36.39% | 34.32% | 34.99% | 34.50% |
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 | $24,013 | $25,830 | $25,167 | $26,914 | $28,780 | $42,293 | $57,405 | $73,097 | $75,779 | $72,261 | $70,177 | $70,946 | |
Cash from Receivables | $0 | $534 | $16,049 | $17,205 | $16,817 | $17,984 | $19,487 | $28,531 | $38,619 | $48,791 | $50,441 | $48,128 | |
Subtotal Cash from Operations | $24,013 | $26,364 | $41,215 | $44,119 | $45,596 | $60,277 | $76,892 | $101,628 | $114,398 | $121,052 | $120,618 | $119,074 | |
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 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Cash Received | $24,013 | $26,364 | $41,215 | $44,119 | $45,596 | $60,277 | $76,892 | $101,628 | $114,398 | $121,052 | $120,618 | $119,074 | |
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 | $32,000 | $32,000 | $32,000 | $32,000 | $32,000 | $32,000 | $32,000 | $32,000 | $32,000 | $32,000 | $30,000 | $30,000 | |
Bill Payments | $12,762 | $26,587 | $27,930 | $27,590 | $27,585 | $29,280 | $35,702 | $42,095 | $48,534 | $48,296 | $47,065 | $46,084 | |
Subtotal Spent on Operations | $44,762 | $58,587 | $59,930 | $59,590 | $59,585 | $61,280 | $67,702 | $74,095 | $80,534 | $80,296 | $77,065 | $76,084 | |
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 | $44,762 | $58,587 | $59,930 | $59,590 | $59,585 | $61,280 | $67,702 | $74,095 | $80,534 | $80,296 | $77,065 | $76,084 | |
Net Cash Flow | ($20,749) | ($32,223) | ($18,714) | ($15,471) | ($13,989) | ($1,003) | $9,189 | $27,533 | $33,864 | $40,756 | $43,553 | $42,990 | |
Cash Balance | $91,128 | $58,905 | $40,190 | $24,719 | $10,730 | $9,727 | $18,916 | $46,449 | $80,314 | $121,069 | $164,622 | $207,612 |
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 | $111,877 | $91,128 | $58,905 | $40,190 | $24,719 | $10,730 | $9,727 | $18,916 | $46,449 | $80,314 | $121,069 | $164,622 | $207,612 |
Accounts Receivable | $0 | $16,008 | $32,695 | $33,424 | $34,161 | $36,531 | $46,742 | $65,525 | $85,726 | $97,626 | $97,010 | $93,353 | $92,523 |
Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Current Assets | $111,877 | $107,136 | $91,599 | $73,614 | $58,880 | $47,261 | $56,469 | $84,442 | $132,175 | $177,940 | $218,079 | $257,975 | $300,135 |
Long-term Assets | |||||||||||||
Long-term Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Accumulated Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Long-term Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Assets | $111,877 | $107,136 | $91,599 | $73,614 | $58,880 | $47,261 | $56,469 | $84,442 | $132,175 | $177,940 | $218,079 | $257,975 | $300,135 |
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 | $11,877 | $25,655 | $27,010 | $26,673 | $26,617 | $28,097 | $34,306 | $40,477 | $46,922 | $46,726 | $45,530 | $44,503 | $45,863 |
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 | $11,877 | $25,655 | $27,010 | $26,673 | $26,617 | $28,097 | $34,306 | $40,477 | $46,922 | $46,726 | $45,530 | $44,503 | $45,863 |
Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Liabilities | $11,877 | $25,655 | $27,010 | $26,673 | $26,617 | $28,097 | $34,306 | $40,477 | $46,922 | $46,726 | $45,530 | $44,503 | $45,863 |
Paid-in Capital | $550,000 | $550,000 | $550,000 | $550,000 | $550,000 | $550,000 | $550,000 | $550,000 | $550,000 | $550,000 | $550,000 | $550,000 | $550,000 |
Retained Earnings | ($450,000) | ($450,000) | ($450,000) | ($450,000) | ($450,000) | ($450,000) | ($450,000) | ($450,000) | ($450,000) | ($450,000) | ($450,000) | ($450,000) | ($450,000) |
Earnings | $0 | ($18,519) | ($35,411) | ($53,059) | ($67,737) | ($80,836) | ($77,838) | ($56,035) | ($14,748) | $31,214 | $72,549 | $113,472 | $154,272 |
Total Capital | $100,000 | $81,481 | $64,589 | $46,941 | $32,263 | $19,164 | $22,162 | $43,965 | $85,252 | $131,214 | $172,549 | $213,472 | $254,272 |
Total Liabilities and Capital | $111,877 | $107,136 | $91,599 | $73,614 | $58,880 | $47,261 | $56,469 | $84,442 | $132,175 | $177,940 | $218,079 | $257,975 | $300,135 |
Net Worth | $100,000 | $81,481 | $64,589 | $46,941 | $32,263 | $19,164 | $22,162 | $43,965 | $85,252 | $131,214 | $172,549 | $213,472 | $254,272 |