Scan Lab

Start your own business plan »

Medical Scanning Lab 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
X-ray 0% $0 $0 $5,500 $8,565 $10,005 $12,454 $13,121 $14,005 $14,989 $15,114 $15,265 $15,274
Ultrasound 0% $0 $0 $3,245 $5,053 $5,903 $7,348 $7,741 $8,263 $8,844 $8,917 $9,006 $9,012
CAT scan 0% $0 $0 $6,050 $9,422 $11,006 $13,699 $14,433 $15,406 $16,488 $16,625 $16,792 $16,801
MRI 0% $0 $0 $3,894 $6,064 $7,084 $8,817 $9,290 $9,916 $10,612 $10,701 $10,808 $10,814
Total Sales $0 $0 $18,689 $29,104 $33,997 $42,319 $44,585 $47,589 $50,933 $51,357 $51,870 $51,901
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
X-ray $0 $0 $1,265 $1,970 $2,301 $2,864 $3,018 $3,221 $3,447 $3,476 $3,511 $3,513
Ultrasound $0 $0 $746 $1,162 $1,358 $1,690 $1,781 $1,900 $2,034 $2,051 $2,071 $2,073
CAT scan $0 $0 $1,392 $2,167 $2,531 $3,151 $3,320 $3,543 $3,792 $3,824 $3,862 $3,864
MRI $0 $0 $896 $1,395 $1,629 $2,028 $2,137 $2,281 $2,441 $2,461 $2,486 $2,487
Subtotal Direct Cost of Sales $0 $0 $4,298 $6,694 $7,819 $9,733 $10,255 $10,945 $11,715 $11,812 $11,930 $11,937
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
Dr. Jones 0% $0 $0 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000
Technicians 0% $0 $0 $0 $3,000 $3,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000
Other 0% $0 $0 $0 $1,200 $1,200 $2,400 $2,400 $2,400 $2,400 $2,400 $2,400 $2,400
Total People 0 0 0 3 3 5 5 5 5 5 5 5
Total Payroll $0 $0 $6,000 $10,200 $10,200 $14,400 $14,400 $14,400 $14,400 $14,400 $14,400 $14,400
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 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 $18,689 $29,104 $33,997 $42,319 $44,585 $47,589 $50,933 $51,357 $51,870 $51,901
Direct Cost of Sales $0 $0 $4,298 $6,694 $7,819 $9,733 $10,255 $10,945 $11,715 $11,812 $11,930 $11,937
Other Costs of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $0 $0 $4,298 $6,694 $7,819 $9,733 $10,255 $10,945 $11,715 $11,812 $11,930 $11,937
Gross Margin $0 $0 $14,391 $22,410 $26,178 $32,585 $34,331 $36,644 $39,218 $39,545 $39,940 $39,964
Gross Margin % 0.00% 0.00% 77.00% 77.00% 77.00% 77.00% 77.00% 77.00% 77.00% 77.00% 77.00% 77.00%
Expenses
Payroll $0 $0 $6,000 $10,200 $10,200 $14,400 $14,400 $14,400 $14,400 $14,400 $14,400 $14,400
Sales and Marketing and Other Expenses $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Depreciation $14,358 $14,358 $14,358 $14,358 $14,358 $14,358 $14,358 $14,358 $14,358 $14,358 $14,358 $14,358
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
Utilities $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Insurance $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500
Payroll Taxes 15% $0 $0 $900 $1,530 $1,530 $2,160 $2,160 $2,160 $2,160 $2,160 $2,160 $2,160
Other $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Total Operating Expenses $19,058 $19,058 $25,958 $30,788 $30,788 $35,618 $35,618 $35,618 $35,618 $35,618 $35,618 $35,618
Profit Before Interest and Taxes ($19,058) ($19,058) ($11,568) ($8,378) ($4,611) ($3,033) ($1,288) $1,025 $3,600 $3,927 $4,322 $4,346
EBITDA ($4,700) ($4,700) $2,791 $5,980 $9,748 $11,325 $13,071 $15,384 $17,958 $18,285 $18,680 $18,704
Interest Expense $7,083 $7,000 $6,917 $6,833 $6,750 $6,667 $6,583 $6,500 $6,417 $6,333 $6,250 $6,167
Taxes Incurred $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit ($26,142) ($26,058) ($18,484) ($15,212) ($11,361) ($9,700) ($7,871) ($5,475) ($2,817) ($2,406) ($1,928) ($1,821)
Net Profit/Sales 0.00% 0.00% -98.91% -52.27% -33.42% -22.92% -17.65% -11.50% -5.53% -4.69% -3.72% -3.51%
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 $4,672 $7,276 $8,499 $10,580 $11,146 $11,897 $12,733 $12,839 $12,968 $12,975
Cash from Receivables $0 $0 $0 $467 $14,277 $21,950 $25,706 $31,796 $33,514 $35,775 $38,210 $38,531
Subtotal Cash from Operations $0 $0 $4,672 $7,743 $22,776 $32,530 $36,852 $43,693 $46,247 $48,615 $51,178 $51,506
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 $0 $0 $4,672 $7,743 $22,776 $32,530 $36,852 $43,693 $46,247 $48,615 $51,178 $51,506
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 $6,000 $10,200 $10,200 $14,400 $14,400 $14,400 $14,400 $14,400 $14,400 $14,400
Bill Payments $393 $11,781 $11,871 $16,913 $19,792 $20,881 $23,275 $23,718 $24,328 $24,992 $25,007 $25,038
Subtotal Spent on Operations $393 $11,781 $17,871 $27,113 $29,992 $35,281 $37,675 $38,118 $38,728 $39,392 $39,407 $39,438
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 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000
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 $10,393 $21,781 $27,871 $37,113 $39,992 $45,281 $47,675 $48,118 $48,728 $49,392 $49,407 $49,438
Net Cash Flow ($10,393) ($21,781) ($23,198) ($29,370) ($17,216) ($12,751) ($10,822) ($4,425) ($2,481) ($777) $1,771 $2,068
Cash Balance $307,507 $285,727 $262,528 $233,158 $215,943 $203,191 $192,369 $187,944 $185,462 $184,685 $186,456 $188,525
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 $317,900 $307,507 $285,727 $262,528 $233,158 $215,943 $203,191 $192,369 $187,944 $185,462 $184,685 $186,456 $188,525
Accounts Receivable $0 $0 $0 $14,017 $35,377 $46,598 $56,387 $64,120 $68,016 $72,701 $75,444 $76,137 $76,532
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $317,900 $307,507 $285,727 $276,545 $268,536 $262,541 $259,578 $256,489 $255,960 $258,164 $260,130 $262,593 $265,057
Long-term Assets
Long-term Assets $861,500 $861,500 $861,500 $861,500 $861,500 $861,500 $861,500 $861,500 $861,500 $861,500 $861,500 $861,500 $861,500
Accumulated Depreciation $0 $14,358 $28,717 $43,075 $57,433 $71,792 $86,150 $100,508 $114,866 $129,225 $143,583 $157,941 $172,300
Total Long-term Assets $861,500 $847,142 $832,783 $818,425 $804,067 $789,709 $775,350 $760,992 $746,634 $732,275 $717,917 $703,559 $689,200
Total Assets $1,179,400 $1,154,649 $1,118,510 $1,094,970 $1,072,603 $1,052,249 $1,034,928 $1,017,481 $1,002,593 $990,439 $978,047 $966,152 $954,257
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 $11,391 $11,310 $16,255 $19,099 $20,106 $22,485 $22,908 $23,495 $24,158 $24,172 $24,206 $24,132
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 $11,391 $11,310 $16,255 $19,099 $20,106 $22,485 $22,908 $23,495 $24,158 $24,172 $24,206 $24,132
Long-term Liabilities $860,000 $850,000 $840,000 $830,000 $820,000 $810,000 $800,000 $790,000 $780,000 $770,000 $760,000 $750,000 $740,000
Total Liabilities $860,000 $861,391 $851,310 $846,255 $839,099 $830,106 $822,485 $812,908 $803,495 $794,158 $784,172 $774,206 $764,132
Paid-in Capital $330,000 $330,000 $330,000 $330,000 $330,000 $330,000 $330,000 $330,000 $330,000 $330,000 $330,000 $330,000 $330,000
Retained Earnings ($10,600) ($10,600) ($10,600) ($10,600) ($10,600) ($10,600) ($10,600) ($10,600) ($10,600) ($10,600) ($10,600) ($10,600) ($10,600)
Earnings $0 ($26,142) ($52,200) ($70,684) ($85,896) ($97,257) ($106,956) ($114,827) ($120,302) ($123,119) ($125,525) ($127,453) ($129,275)
Total Capital $319,400 $293,258 $267,200 $248,716 $233,504 $222,143 $212,444 $204,573 $199,098 $196,281 $193,875 $191,947 $190,125
Total Liabilities and Capital $1,179,400 $1,154,649 $1,118,510 $1,094,970 $1,072,603 $1,052,249 $1,034,928 $1,017,481 $1,002,593 $990,439 $978,047 $966,152 $954,257
Net Worth $319,400 $293,258 $267,200 $248,716 $233,504 $222,143 $212,444 $204,573 $199,098 $196,281 $193,875 $191,947 $190,125