MedNexis, Inc.

Start your own business plan »

Medical Equipment 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
Unit Sales
MedStim- Logic Controller 0% 0 0 0 0 0 0 0 0 0 0 0 1
MedStim- Array of Coils 0% 0 0 0 0 0 0 0 0 0 0 0 5
TheraMag- Logic Controller 0% 0 0 0 0 4 6 10 15 30 45 60 80
TheraMag- Array of Coils 0% 0 0 0 0 4 6 10 15 30 45 60 80
Total Unit Sales 0 0 0 0 8 12 20 30 60 90 120 166
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
MedStim- Logic Controller $18,500.00 $18,500.00 $18,500.00 $18,500.00 $18,500.00 $18,500.00 $18,500.00 $18,500.00 $18,500.00 $18,500.00 $18,500.00 $18,500.00
MedStim- Array of Coils $1,500.00 $1,500.00 $1,500.00 $1,500.00 $1,500.00 $1,500.00 $1,500.00 $1,500.00 $1,500.00 $1,500.00 $1,500.00 $1,500.00
TheraMag- Logic Controller $300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $300.00
TheraMag- Array of Coils $80.00 $80.00 $80.00 $80.00 $80.00 $80.00 $80.00 $80.00 $80.00 $80.00 $80.00 $80.00
Sales
MedStim- Logic Controller $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $18,500
MedStim- Array of Coils $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $7,500
TheraMag- Logic Controller $0 $0 $0 $0 $1,200 $1,800 $3,000 $4,500 $9,000 $13,500 $18,000 $24,000
TheraMag- Array of Coils $0 $0 $0 $0 $320 $480 $800 $1,200 $2,400 $3,600 $4,800 $6,400
Total Sales $0 $0 $0 $0 $1,520 $2,280 $3,800 $5,700 $11,400 $17,100 $22,800 $56,400
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
MedStim- Logic Controller 0.00% $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00
MedStim- Array of Coils 0.00% $300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $300.00 $300.00
TheraMag- Logic Controller 0.00% $200.00 $200.00 $200.00 $200.00 $200.00 $200.00 $200.00 $200.00 $200.00 $200.00 $200.00 $200.00
TheraMag- Array of Coils 0.00% $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $50.00
Direct Cost of Sales
MedStim- Logic Controller $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $3,000
MedStim- Array of Coils $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $1,500
TheraMag- Logic Controller $0 $0 $0 $0 $800 $1,200 $2,000 $3,000 $6,000 $9,000 $12,000 $16,000
TheraMag- Array of Coils $0 $0 $0 $0 $200 $300 $500 $750 $1,500 $2,250 $3,000 $4,000
Subtotal Direct Cost of Sales $0 $0 $0 $0 $1,000 $1,500 $2,500 $3,750 $7,500 $11,250 $15,000 $24,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
Production Manager $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
Sales and Marketing Personnel
VP Sales/Marketing $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Sales Manager $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Field Sales Manager $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Marketing/Product Manager $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Sales Reps $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Sales Administrator $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 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
General and Administrative Personnel
CEO $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000
CFO $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000
VP Corp Development $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $5,000 $5,000
Executive Assistant $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $2,000 $2,000
Executive Secretary $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Controller $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Adminstrative Staff (4) $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 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $17,000 $17,000
Other Personnel
VP Research & Development $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000
Quality Contol Engineer $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Design Engineer $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Research Engineers (2) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Junior Engineer $0 $0 $0 $0 $0 $0 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $9,500 $9,500 $9,500 $9,500 $9,500 $9,500
Total People 5 5 5 5 5 5 5 5 5 5 7 7
Total Payroll $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $22,500 $22,500 $22,500 $22,500 $29,500 $29,500
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 13.00% 13.00% 13.00% 13.00% 13.00% 13.00% 13.00% 13.00% 13.00% 13.00% 13.00% 13.00%
Long-term Interest Rate 12.00% 12.00% 12.00% 12.00% 12.00% 12.00% 12.00% 12.00% 12.00% 12.00% 12.00% 12.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 $1,520 $2,280 $3,800 $5,700 $11,400 $17,100 $22,800 $56,400
Direct Cost of Sales $0 $0 $0 $0 $1,000 $1,500 $2,500 $3,750 $7,500 $11,250 $15,000 $24,500
Production Payroll $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
Total Cost of Sales $0 $0 $0 $0 $1,000 $1,500 $2,500 $3,750 $7,500 $11,250 $15,000 $24,500
Gross Margin $0 $0 $0 $0 $520 $780 $1,300 $1,950 $3,900 $5,850 $7,800 $31,900
Gross Margin % 0.00% 0.00% 0.00% 0.00% 34.21% 34.21% 34.21% 34.21% 34.21% 34.21% 34.21% 56.56%
Operating Expenses
Sales and Marketing Expenses
Sales and Marketing Payroll $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Advertising/Promotion $0 $0 $0 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
Travel $0 $0 $0 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Research and Design Expenses $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000
Miscellaneous $0 $0 $0 $0 $0 $0 $500 $500 $500 $500 $500 $500
Total Sales and Marketing Expenses $23,000 $23,000 $23,000 $30,000 $30,000 $30,000 $30,500 $30,500 $30,500 $30,500 $30,500 $30,500
Sales and Marketing % 0.00% 0.00% 0.00% 0.00% 1973.68% 1315.79% 802.63% 535.09% 267.54% 178.36% 133.77% 54.08%
General and Administrative Expenses
General and Administrative Payroll $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $17,000 $17,000
Sales and Marketing and Other Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
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 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Insurance $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500
Rent $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Payroll Taxes 21% $4,200 $4,200 $4,200 $4,200 $4,200 $4,200 $4,725 $4,725 $4,725 $4,725 $6,195 $6,195
Other General and Administrative Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total General and Administrative Expenses $19,700 $19,700 $19,700 $19,700 $19,700 $19,700 $20,225 $20,225 $20,225 $20,225 $28,695 $28,695
General and Administrative % 0.00% 0.00% 0.00% 0.00% 1296.05% 864.04% 532.24% 354.82% 177.41% 118.27% 125.86% 50.88%
Other Expenses:
Other Payroll $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $9,500 $9,500 $9,500 $9,500 $9,500 $9,500
Consultants $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Contract/Consultants $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Other Expenses $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $9,500 $9,500 $9,500 $9,500 $9,500 $9,500
Other % 0.00% 0.00% 0.00% 0.00% 460.53% 307.02% 250.00% 166.67% 83.33% 55.56% 41.67% 16.84%
Total Operating Expenses $49,700 $49,700 $49,700 $56,700 $56,700 $56,700 $60,225 $60,225 $60,225 $60,225 $68,695 $68,695
Profit Before Interest and Taxes ($49,700) ($49,700) ($49,700) ($56,700) ($56,180) ($55,920) ($58,925) ($58,275) ($56,325) ($54,375) ($60,895) ($36,795)
EBITDA ($49,700) ($49,700) ($49,700) ($56,700) ($56,180) ($55,920) ($58,925) ($58,275) ($56,325) ($54,375) ($60,895) ($36,795)
Interest Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Taxes Incurred $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit ($49,700) ($49,700) ($49,700) ($56,700) ($56,180) ($55,920) ($58,925) ($58,275) ($56,325) ($54,375) ($60,895) ($36,795)
Net Profit/Sales 0.00% 0.00% 0.00% 0.00% -3696.05% -2452.63% -1550.66% -1022.37% -494.08% -317.98% -267.08% -65.24%
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 $82,000 $59,010 $757,310 $705,610 $653,677 $595,287 $535,666 $474,724 $412,592 $351,485 $288,340 $217,096 $152,954
Accounts Receivable $0 $0 $0 $0 $0 $1,140 $2,242 $3,648 $5,605 $10,545 $16,815 $23,085 $50,280
Inventory $0 $0 $0 $0 $0 $1,100 $1,650 $2,750 $4,125 $8,250 $12,375 $16,500 $26,950
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $82,000 $59,010 $757,310 $705,610 $653,677 $597,527 $539,558 $481,122 $422,322 $370,280 $317,530 $256,681 $230,184
Long-term Assets
Long-term Assets $0 $2,000 $4,000 $6,000 $8,000 $10,000 $12,000 $14,000 $16,000 $18,000 $20,000 $25,000 $30,000
Accumulated Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Long-term Assets $0 $2,000 $4,000 $6,000 $8,000 $10,000 $12,000 $14,000 $16,000 $18,000 $20,000 $25,000 $30,000
Total Assets $82,000 $61,010 $761,310 $711,610 $661,677 $607,527 $551,558 $495,122 $438,322 $388,280 $337,530 $281,681 $260,184
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 $28,710 $28,710 $28,710 $35,477 $37,507 $37,458 $39,948 $41,422 $47,705 $51,330 $56,376 $71,674
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 $28,710 $28,710 $28,710 $35,477 $37,507 $37,458 $39,948 $41,422 $47,705 $51,330 $56,376 $71,674
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $0 $28,710 $28,710 $28,710 $35,477 $37,507 $37,458 $39,948 $41,422 $47,705 $51,330 $56,376 $71,674
Paid-in Capital $250,000 $250,000 $1,000,000 $1,000,000 $1,000,000 $1,000,000 $1,000,000 $1,000,000 $1,000,000 $1,000,000 $1,000,000 $1,000,000 $1,000,000
Retained Earnings ($168,000) ($168,000) ($168,000) ($168,000) ($168,000) ($168,000) ($168,000) ($168,000) ($168,000) ($168,000) ($168,000) ($168,000) ($168,000)
Earnings $0 ($49,700) ($99,400) ($149,100) ($205,800) ($261,980) ($317,900) ($376,825) ($435,100) ($491,425) ($545,800) ($606,695) ($643,490)
Total Capital $82,000 $32,300 $732,600 $682,900 $626,200 $570,020 $514,100 $455,175 $396,900 $340,575 $286,200 $225,305 $188,510
Total Liabilities and Capital $82,000 $61,010 $761,310 $711,610 $661,677 $607,527 $551,558 $495,123 $438,322 $388,280 $337,530 $281,681 $260,184
Net Worth $82,000 $32,300 $732,600 $682,900 $626,200 $570,020 $514,100 $455,175 $396,900 $340,575 $286,200 $225,305 $188,510
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 $380 $570 $950 $1,425 $2,850 $4,275 $5,700 $14,100
Cash from Receivables $0 $0 $0 $0 $0 $608 $1,444 $2,318 $3,610 $6,555 $10,830 $15,105
Subtotal Cash from Operations $0 $0 $0 $0 $380 $1,178 $2,394 $3,743 $6,460 $10,830 $16,530 $29,205
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 $750,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Received $0 $750,000 $0 $0 $380 $1,178 $2,394 $3,743 $6,460 $10,830 $16,530 $29,205
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 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $22,500 $22,500 $22,500 $22,500 $29,500 $29,500
Bill Payments $990 $29,700 $29,700 $29,933 $36,770 $38,798 $38,836 $41,376 $43,067 $49,475 $53,274 $58,848
Subtotal Spent on Operations $20,990 $49,700 $49,700 $49,933 $56,770 $58,798 $61,336 $63,876 $65,567 $71,975 $82,774 $88,348
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 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $5,000 $5,000
Dividends $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Spent $22,990 $51,700 $51,700 $51,933 $58,770 $60,798 $63,336 $65,876 $67,567 $73,975 $87,774 $93,348
Net Cash Flow ($22,990) $698,300 ($51,700) ($51,933) ($58,390) ($59,620) ($60,942) ($62,133) ($61,107) ($63,145) ($71,244) ($64,143)
Cash Balance $59,010 $757,310 $705,610 $653,677 $595,287 $535,666 $474,724 $412,592 $351,485 $288,340 $217,096 $152,954