Southeast Health Plans

Start your own business plan »

Health Plan Administration 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
Sales 0% $11,101 $11,102 $12,017 $13,845 $15,674 $18,415 $22,985 $27,554 $32,123 $36,692 $41,261 $45,830
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales $11,101 $11,102 $12,017 $13,845 $15,674 $18,415 $22,985 $27,554 $32,123 $36,692 $41,261 $45,830
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
Sales $0 $0 $1,500 $3,000 $3,000 $4,500 $7,500 $7,500 $7,500 $7,500 $7,500 $7,500
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $0 $0 $1,500 $3,000 $3,000 $4,500 $7,500 $7,500 $7,500 $7,500 $7,500 $7,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
James J. Peters 0% $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
Thomas R. Cormier 0% $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
L. Richard Schumacher 0% $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
Jeffrey Farmer, Sales Mgr. 0% $5,416 $5,416 $5,416 $5,416 $5,416 $5,416 $5,416 $5,416 $5,416 $5,416 $5,416 $5,416
Sales Executive 0% $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500
Sales Executive 0% $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500
Sales Executive 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $3,500 $3,500 $3,500
Account Service Executive 0% $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Administrative Asst. 0% $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500
Administrative Asst. 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $2,000 $2,000 $2,000
VP Corp Dev. 0% $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500
CFO 0% $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Branch Sales 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 $35,416 $35,416 $35,416 $35,416 $35,416 $35,416 $35,416 $35,416 $35,416 $40,916 $40,916 $40,916
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 $11,101 $11,102 $12,017 $13,845 $15,674 $18,415 $22,985 $27,554 $32,123 $36,692 $41,261 $45,830
Direct Cost of Sales $0 $0 $1,500 $3,000 $3,000 $4,500 $7,500 $7,500 $7,500 $7,500 $7,500 $7,500
Other Costs of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $0 $0 $1,500 $3,000 $3,000 $4,500 $7,500 $7,500 $7,500 $7,500 $7,500 $7,500
Gross Margin $11,101 $11,102 $10,517 $10,845 $12,674 $13,915 $15,485 $20,054 $24,623 $29,192 $33,761 $38,330
Gross Margin % 100.00% 100.00% 87.52% 78.33% 80.86% 75.56% 67.37% 72.78% 76.65% 79.56% 81.82% 83.64%
Expenses
Payroll $35,416 $35,416 $35,416 $35,416 $35,416 $35,416 $35,416 $35,416 $35,416 $40,916 $40,916 $40,916
Marketing/Promotion $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000
Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Rent $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500
Telephone/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
Payroll Taxes 15% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Contract/Consultants $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Total Operating Expenses $56,916 $56,916 $56,916 $56,916 $56,916 $56,916 $56,916 $56,916 $56,916 $62,416 $62,416 $62,416
Profit Before Interest and Taxes ($45,815) ($45,814) ($46,399) ($46,071) ($44,242) ($43,001) ($41,431) ($36,862) ($32,293) ($33,224) ($28,655) ($24,086)
EBITDA ($45,815) ($45,814) ($46,399) ($46,071) ($44,242) ($43,001) ($41,431) ($36,862) ($32,293) ($33,224) ($28,655) ($24,086)
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 ($45,815) ($45,814) ($46,399) ($46,071) ($44,242) ($43,001) ($41,431) ($36,862) ($32,293) ($33,224) ($28,655) ($24,086)
Net Profit/Sales -412.71% -412.66% -386.11% -332.76% -282.26% -233.51% -180.25% -133.78% -100.53% -90.55% -69.45% -52.56%
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 $11,101 $11,102 $12,017 $13,845 $15,674 $18,415 $22,985 $27,554 $32,123 $36,692 $41,261 $45,830
Subtotal Cash from Operations $11,101 $11,102 $12,017 $13,845 $15,674 $18,415 $22,985 $27,554 $32,123 $36,692 $41,261 $45,830
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 $200,000 $100,000 $200,000 $100,000 $200,000 $200,000 $0 $0 $0
Subtotal Cash Received $11,101 $11,102 $12,017 $213,845 $115,674 $218,415 $122,985 $227,554 $232,123 $36,692 $41,261 $45,830
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 $35,416 $35,416 $35,416 $35,416 $35,416 $35,416 $35,416 $35,416 $35,416 $40,916 $40,916 $40,916
Bill Payments $717 $21,500 $21,550 $23,050 $24,500 $24,550 $26,100 $29,000 $29,000 $29,000 $29,000 $29,000
Subtotal Spent on Operations $36,133 $56,916 $56,966 $58,466 $59,916 $59,966 $61,516 $64,416 $64,416 $69,916 $69,916 $69,916
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 $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 $36,133 $56,916 $56,966 $58,466 $59,916 $59,966 $61,516 $64,416 $64,416 $69,916 $69,916 $69,916
Net Cash Flow ($25,032) ($45,814) ($44,949) $155,379 $55,758 $158,449 $61,469 $163,138 $167,707 ($33,224) ($28,655) ($24,086)
Cash Balance $247,468 $201,654 $156,705 $312,084 $367,842 $526,291 $587,760 $750,898 $918,605 $885,381 $856,726 $832,640
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 $272,500 $247,468 $201,654 $156,705 $312,084 $367,842 $526,291 $587,760 $750,898 $918,605 $885,381 $856,726 $832,640
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $272,500 $247,468 $201,654 $156,705 $312,084 $367,842 $526,291 $587,760 $750,898 $918,605 $885,381 $856,726 $832,640
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 $272,500 $247,468 $201,654 $156,705 $312,084 $367,842 $526,291 $587,760 $750,898 $918,605 $885,381 $856,726 $832,640
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 $20,783 $20,783 $22,233 $23,683 $23,683 $25,133 $28,033 $28,033 $28,033 $28,033 $28,033 $28,033
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 $20,783 $20,783 $22,233 $23,683 $23,683 $25,133 $28,033 $28,033 $28,033 $28,033 $28,033 $28,033
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $0 $20,783 $20,783 $22,233 $23,683 $23,683 $25,133 $28,033 $28,033 $28,033 $28,033 $28,033 $28,033
Paid-in Capital $300,000 $300,000 $300,000 $300,000 $500,000 $600,000 $800,000 $900,000 $1,100,000 $1,300,000 $1,300,000 $1,300,000 $1,300,000
Retained Earnings ($27,500) ($27,500) ($27,500) ($27,500) ($27,500) ($27,500) ($27,500) ($27,500) ($27,500) ($27,500) ($27,500) ($27,500) ($27,500)
Earnings $0 ($45,815) ($91,629) ($138,028) ($184,099) ($228,341) ($271,342) ($312,773) ($349,635) ($381,928) ($415,152) ($443,807) ($467,893)
Total Capital $272,500 $226,685 $180,871 $134,472 $288,401 $344,159 $501,158 $559,727 $722,865 $890,572 $857,348 $828,693 $804,607
Total Liabilities and Capital $272,500 $247,468 $201,654 $156,705 $312,084 $367,842 $526,291 $587,760 $750,898 $918,605 $885,381 $856,726 $832,640
Net Worth $272,500 $226,685 $180,871 $134,472 $288,401 $344,159 $501,158 $559,727 $722,865 $890,572 $857,348 $828,693 $804,607