AgaMatrix, Inc.

Start your own business plan »

Medical Software Business Plan

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)