Our biggest savings of the year
AgaMatrix, Inc.
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 | |||||||||||||
Test Strip Royalties (000) | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $256,000 |
Other | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $256,000 | |
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 | |
Test Strip Royalties (000) | $5,000 | $1,500 | $1,500 | $1,500 | $1,500 | $9,500 | $1,500 | $1,500 | $1,500 | $9,500 | $1,500 | $1,500 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Direct Cost of Sales | $5,000 | $1,500 | $1,500 | $1,500 | $1,500 | $9,500 | $1,500 | $1,500 | $1,500 | $9,500 | $1,500 | $1,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 | ||
Combined Payroll | 0% | $36,583 | $43,250 | $47,000 | $47,000 | $54,500 | $57,417 | $76,250 | $76,250 | $76,250 | $88,750 | $88,750 | $88,750 |
Other | 0% | $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 | $36,583 | $43,250 | $47,000 | $47,000 | $54,500 | $57,417 | $76,250 | $76,250 | $76,250 | $88,750 | $88,750 | $88,750 |
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 | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.00% | 8.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 | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.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 | $0 | $0 | $0 | $0 | $0 | $0 | $256,000 | |
Direct Cost of Sales | $5,000 | $1,500 | $1,500 | $1,500 | $1,500 | $9,500 | $1,500 | $1,500 | $1,500 | $9,500 | $1,500 | $1,500 | |
Other Production Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $5,000 | $1,500 | $1,500 | $1,500 | $1,500 | $9,500 | $1,500 | $1,500 | $1,500 | $9,500 | $1,500 | $1,500 | |
Gross Margin | ($5,000) | ($1,500) | ($1,500) | ($1,500) | ($1,500) | ($9,500) | ($1,500) | ($1,500) | ($1,500) | ($9,500) | ($1,500) | $254,500 | |
Gross Margin % | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 99.41% | |
Expenses | |||||||||||||
Payroll | $36,583 | $43,250 | $47,000 | $47,000 | $54,500 | $57,417 | $76,250 | $76,250 | $76,250 | $88,750 | $88,750 | $88,750 | |
Sales and Marketing and Other Expenses | $407,150 | $406,150 | $406,150 | $406,150 | $406,150 | $415,150 | $406,650 | $408,650 | $408,650 | $424,150 | $410,200 | $410,200 | |
Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Leased Equipment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Utilities | $220 | $240 | $260 | $260 | $260 | $260 | $260 | $320 | $320 | $320 | $340 | $340 | |
Insurance | $2,400 | $2,800 | $3,200 | $3,200 | $3,200 | $3,200 | $3,200 | $4,400 | $4,400 | $4,400 | $4,800 | $4,800 | |
Rent | $8,535 | $8,545 | $8,555 | $8,555 | $8,555 | $10,255 | $10,255 | $10,285 | $10,285 | $10,285 | $10,295 | $10,295 | |
Payroll Taxes | 15% | $5,487 | $6,488 | $7,050 | $7,050 | $8,175 | $8,613 | $11,438 | $11,438 | $11,438 | $13,313 | $13,313 | $13,313 |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Operating Expenses | $460,375 | $467,473 | $472,215 | $472,215 | $480,840 | $494,895 | $508,053 | $511,343 | $511,343 | $541,218 | $527,698 | $527,698 | |
Profit Before Interest and Taxes | ($465,375) | ($468,973) | ($473,715) | ($473,715) | ($482,340) | ($504,395) | ($509,553) | ($512,843) | ($512,843) | ($550,718) | ($529,198) | ($273,198) | |
EBITDA | ($465,375) | ($468,973) | ($473,715) | ($473,715) | ($482,340) | ($504,395) | ($509,553) | ($512,843) | ($512,843) | ($550,718) | ($529,198) | ($273,198) | |
Interest Expense | $124 | $123 | $122 | $121 | $120 | $119 | $118 | $117 | $116 | $115 | $114 | $113 | |
Taxes Incurred | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Net Profit | ($465,499) | ($469,095) | ($473,837) | ($473,836) | ($482,460) | ($504,513) | ($509,670) | ($512,959) | ($512,958) | ($550,832) | ($529,311) | ($273,310) | |
Net Profit/Sales | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | -106.76% |
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 | $256,000 | |
Subtotal Cash from Operations | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $256,000 | |
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 | $4,000,000 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $75,000 | $0 | |
Subtotal Cash Received | $4,000,000 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $75,000 | $256,000 | |
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 | $36,583 | $43,250 | $47,000 | $47,000 | $54,500 | $57,417 | $76,250 | $76,250 | $76,250 | $88,750 | $88,750 | $88,750 | |
Bill Payments | $19,297 | $428,814 | $425,878 | $426,837 | $426,873 | $428,598 | $446,640 | $433,530 | $436,709 | $437,554 | $461,365 | $440,561 | |
Subtotal Spent on Operations | $55,880 | $472,064 | $472,878 | $473,837 | $481,373 | $486,015 | $522,890 | $509,780 | $512,959 | $526,304 | $550,115 | $529,311 | |
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 | $125 | $125 | $125 | $125 | $125 | $125 | $125 | $125 | $125 | $125 | $125 | $125 | |
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 | $56,005 | $472,189 | $473,003 | $473,962 | $481,498 | $486,140 | $523,015 | $509,905 | $513,084 | $526,429 | $550,240 | $529,436 | |
Net Cash Flow | $3,943,995 | ($472,189) | ($473,003) | ($473,962) | ($481,498) | ($486,140) | ($523,015) | ($509,905) | ($513,084) | ($526,429) | ($475,240) | ($273,436) | |
Cash Balance | $5,459,095 | $4,986,906 | $4,513,902 | $4,039,940 | $3,558,442 | $3,072,302 | $2,549,287 | $2,039,382 | $1,526,298 | $999,869 | $524,629 | $251,193 |
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,515,100 | $5,459,095 | $4,986,906 | $4,513,902 | $4,039,940 | $3,558,442 | $3,072,302 | $2,549,287 | $2,039,382 | $1,526,298 | $999,869 | $524,629 | $251,193 |
Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Current Assets | $1,515,100 | $5,459,095 | $4,986,906 | $4,513,902 | $4,039,940 | $3,558,442 | $3,072,302 | $2,549,287 | $2,039,382 | $1,526,298 | $999,869 | $524,629 | $251,193 |
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 | $1,515,100 | $5,459,095 | $4,986,906 | $4,513,902 | $4,039,940 | $3,558,442 | $3,072,302 | $2,549,287 | $2,039,382 | $1,526,298 | $999,869 | $524,629 | $251,193 |
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 | $5,000 | $414,619 | $411,651 | $412,609 | $412,608 | $413,694 | $432,193 | $418,973 | $422,152 | $422,151 | $446,679 | $425,876 | $425,875 |
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 | $5,000 | $414,619 | $411,651 | $412,609 | $412,608 | $413,694 | $432,193 | $418,973 | $422,152 | $422,151 | $446,679 | $425,876 | $425,875 |
Long-term Liabilities | $15,000 | $14,875 | $14,750 | $14,625 | $14,500 | $14,375 | $14,250 | $14,125 | $14,000 | $13,875 | $13,750 | $13,625 | $13,500 |
Total Liabilities | $20,000 | $429,494 | $426,401 | $427,234 | $427,108 | $428,069 | $446,443 | $433,098 | $436,152 | $436,026 | $460,429 | $439,501 | $439,375 |
Paid-in Capital | $1,500,000 | $5,500,000 | $5,500,000 | $5,500,000 | $5,500,000 | $5,500,000 | $5,500,000 | $5,500,000 | $5,500,000 | $5,500,000 | $5,500,000 | $5,575,000 | $5,575,000 |
Retained Earnings | ($4,900) | ($4,900) | ($4,900) | ($4,900) | ($4,900) | ($4,900) | ($4,900) | ($4,900) | ($4,900) | ($4,900) | ($4,900) | ($4,900) | ($4,900) |
Earnings | $0 | ($465,499) | ($934,595) | ($1,408,432) | ($1,882,268) | ($2,364,727) | ($2,869,241) | ($3,378,911) | ($3,891,870) | ($4,404,828) | ($4,955,660) | ($5,484,971) | ($5,758,281) |
Total Capital | $1,495,100 | $5,029,601 | $4,560,505 | $4,086,668 | $3,612,832 | $3,130,373 | $2,625,859 | $2,116,189 | $1,603,230 | $1,090,272 | $539,440 | $85,129 | ($188,181) |
Total Liabilities and Capital | $1,515,100 | $5,459,095 | $4,986,906 | $4,513,902 | $4,039,940 | $3,558,442 | $3,072,302 | $2,549,287 | $2,039,382 | $1,526,298 | $999,869 | $524,629 | $251,193 |
Net Worth | $1,495,100 | $5,029,601 | $4,560,505 | $4,086,668 | $3,612,832 | $3,130,373 | $2,625,859 | $2,116,189 | $1,603,230 | $1,090,272 | $539,440 | $85,129 | ($188,181) |