The Medical Group

Start your own business plan »

Medical Services Management 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
Customers 0% $10,000 $10,000 $15,000 $15,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000
Physician membership 0% $10,000 $15,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000
Other services 0% $15,000 $20,000 $25,000 $40,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000
Total Sales $35,000 $45,000 $70,000 $85,000 $105,000 $105,000 $105,000 $105,000 $105,000 $105,000 $105,000 $105,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
Customers $1,333 $1,333 $2,000 $2,000 $3,333 $3,333 $3,333 $3,333 $3,333 $3,333 $3,333 $3,333
Physician membership $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other services $2,000 $2,667 $3,333 $5,334 $6,667 $6,667 $6,667 $6,667 $6,667 $6,667 $6,667 $6,667
Subtotal Direct Cost of Sales $3,333 $4,000 $5,333 $7,334 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000
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
All Staff 0% $21,375 $21,377 $21,377 $21,377 $21,377 $21,377 $21,377 $21,377 $21,377 $21,377 $21,377 $21,377
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 7 7 7 7 7 7 7 7 7 7 7 7
Total Payroll $21,375 $21,377 $21,377 $21,377 $21,377 $21,377 $21,377 $21,377 $21,377 $21,377 $21,377 $21,377
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% 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 $35,000 $45,000 $70,000 $85,000 $105,000 $105,000 $105,000 $105,000 $105,000 $105,000 $105,000 $105,000
Direct Cost of Sales $3,333 $4,000 $5,333 $7,334 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000
Other $2,500 $2,500 $2,500 $2,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500
Total Cost of Sales $5,833 $6,500 $7,833 $9,834 $13,500 $13,500 $13,500 $13,500 $13,500 $13,500 $13,500 $13,500
Gross Margin $29,167 $38,500 $62,167 $75,166 $91,500 $91,500 $91,500 $91,500 $91,500 $91,500 $91,500 $91,500
Gross Margin % 83.33% 85.56% 88.81% 88.43% 87.14% 87.14% 87.14% 87.14% 87.14% 87.14% 87.14% 87.14%
Expenses
Payroll $21,375 $21,377 $21,377 $21,377 $21,377 $21,377 $21,377 $21,377 $21,377 $21,377 $21,377 $21,377
Sales and Marketing and Other Expenses $38,500 $31,000 $29,000 $36,500 $29,000 $29,000 $36,500 $29,000 $29,000 $36,500 $29,000 $29,000
Depreciation $700 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700
Continued education $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Utilities $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300
Insurance $800 $800 $800 $800 $800 $800 $800 $800 $800 $800 $800 $800
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 15% $3,206 $3,207 $3,207 $3,207 $3,207 $3,207 $3,207 $3,207 $3,207 $3,207 $3,207 $3,207
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $69,881 $62,384 $60,384 $67,884 $60,384 $60,384 $67,884 $60,384 $60,384 $67,884 $60,384 $60,384
Profit Before Interest and Taxes ($40,714) ($23,884) $1,783 $7,282 $31,116 $31,116 $23,616 $31,116 $31,116 $23,616 $31,116 $31,116
EBITDA ($40,014) ($23,184) $2,483 $7,982 $31,816 $31,816 $24,316 $31,816 $31,816 $24,316 $31,816 $31,816
Interest Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Taxes Incurred ($12,214) ($5,971) $446 $1,821 $7,779 $7,779 $5,904 $7,779 $7,779 $5,904 $7,779 $7,779
Net Profit ($28,500) ($17,913) $1,338 $5,462 $23,337 $23,337 $17,712 $23,337 $23,337 $17,712 $23,337 $23,337
Net Profit/Sales -81.43% -39.81% 1.91% 6.43% 22.23% 22.23% 16.87% 22.23% 22.23% 16.87% 22.23% 22.23%
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 $0
Cash from Receivables $0 $1,167 $35,333 $45,833 $70,500 $85,667 $105,000 $105,000 $105,000 $105,000 $105,000 $105,000
Subtotal Cash from Operations $0 $1,167 $35,333 $45,833 $70,500 $85,667 $105,000 $105,000 $105,000 $105,000 $105,000 $105,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 $0 $0 $0 $500,000 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Received $0 $1,167 $35,333 $545,833 $70,500 $85,667 $105,000 $105,000 $105,000 $105,000 $105,000 $105,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 $21,375 $21,377 $21,377 $21,377 $21,377 $21,377 $21,377 $21,377 $21,377 $21,377 $21,377 $21,377
Bill Payments $1,381 $41,405 $41,027 $46,948 $57,532 $59,586 $59,773 $65,023 $59,586 $59,773 $65,023 $59,586
Subtotal Spent on Operations $22,756 $62,782 $62,404 $68,325 $78,909 $80,963 $81,150 $86,400 $80,963 $81,150 $86,400 $80,963
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 $25,000 $25,000 $25,000 $25,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000
Dividends $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Spent $47,756 $87,782 $87,404 $93,325 $128,909 $130,963 $131,150 $136,400 $130,963 $131,150 $136,400 $130,963
Net Cash Flow ($47,756) ($86,616) ($52,071) $452,508 ($58,409) ($45,296) ($26,150) ($31,400) ($25,963) ($26,150) ($31,400) ($25,963)
Cash Balance $202,244 $115,629 $63,558 $516,066 $457,657 $412,361 $386,211 $354,811 $328,848 $302,698 $271,298 $245,335
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 $250,000 $202,244 $115,629 $63,558 $516,066 $457,657 $412,361 $386,211 $354,811 $328,848 $302,698 $271,298 $245,335
Accounts Receivable $0 $35,000 $78,833 $113,500 $152,667 $187,167 $206,500 $206,500 $206,500 $206,500 $206,500 $206,500 $206,500
Other Current Assets $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
Total Current Assets $255,000 $242,244 $199,462 $182,058 $673,733 $649,824 $623,861 $597,711 $566,311 $540,348 $514,198 $482,798 $456,835
Long-term Assets
Long-term Assets $0 $25,000 $50,000 $75,000 $100,000 $150,000 $200,000 $250,000 $300,000 $350,000 $400,000 $450,000 $500,000
Accumulated Depreciation $0 $700 $1,400 $2,100 $2,800 $3,500 $4,200 $4,900 $5,600 $6,300 $7,000 $7,700 $8,400
Total Long-term Assets $0 $24,300 $48,600 $72,900 $97,200 $146,500 $195,800 $245,100 $294,400 $343,700 $393,000 $442,300 $491,600
Total Assets $255,000 $266,544 $248,062 $254,958 $770,933 $796,324 $819,661 $842,811 $860,711 $884,048 $907,198 $925,098 $948,435
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 $40,044 $39,474 $45,033 $55,546 $57,599 $57,599 $63,037 $57,599 $57,599 $63,037 $57,599 $57,599
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 $40,044 $39,474 $45,033 $55,546 $57,599 $57,599 $63,037 $57,599 $57,599 $63,037 $57,599 $57,599
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $0 $40,044 $39,474 $45,033 $55,546 $57,599 $57,599 $63,037 $57,599 $57,599 $63,037 $57,599 $57,599
Paid-in Capital $350,000 $350,000 $350,000 $350,000 $850,000 $850,000 $850,000 $850,000 $850,000 $850,000 $850,000 $850,000 $850,000
Retained Earnings ($95,000) ($95,000) ($95,000) ($95,000) ($95,000) ($95,000) ($95,000) ($95,000) ($95,000) ($95,000) ($95,000) ($95,000) ($95,000)
Earnings $0 ($28,500) ($46,413) ($45,075) ($39,613) ($16,276) $7,061 $24,774 $48,111 $71,448 $89,161 $112,498 $135,835
Total Capital $255,000 $226,500 $208,587 $209,925 $715,387 $738,724 $762,061 $779,774 $803,111 $826,448 $844,161 $867,498 $890,835
Total Liabilities and Capital $255,000 $266,544 $248,062 $254,958 $770,933 $796,324 $819,661 $842,811 $860,711 $884,048 $907,198 $925,098 $948,435
Net Worth $255,000 $226,500 $208,587 $209,925 $715,387 $738,724 $762,061 $779,774 $803,111 $826,448 $844,161 $867,498 $890,835