Employee Benefits Administration

Start your own business plan »

Benefits 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
Unit Sales
COBRA/HIPAA 0% 0 0 0 20 25 30 35 40 45 50 55 60
Flexible Spending 0% 0 0 0 10 10 10 10 10 10 40 40 40
Basic Admin 0% 0 0 0 100 100 100 200 200 200 400 400 400
All Inclusive 0% 0 0 0 100 100 100 200 200 200 400 400 400
Start-up Fees 0% 0 0 0 65 5 5 45 5 5 100 5 5
Total Unit Sales 0 0 0 295 240 245 490 455 460 990 900 905
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
COBRA/HIPAA $12.75 $12.75 $12.75 $12.75 $12.75 $12.75 $12.75 $12.75 $12.75 $12.75 $12.75 $12.75
Flexible Spending $7.50 $7.50 $7.50 $7.50 $7.50 $7.50 $7.50 $7.50 $7.50 $7.50 $7.50 $7.50
Basic Admin $12.00 $12.00 $12.00 $12.00 $12.00 $12.00 $12.00 $12.00 $12.00 $12.00 $12.00 $12.00
All Inclusive $18.00 $18.00 $18.00 $18.00 $18.00 $18.00 $18.00 $18.00 $18.00 $18.00 $18.00 $18.00
Start-up Fees $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00
Sales
COBRA/HIPAA $0 $0 $0 $255 $319 $383 $446 $510 $574 $638 $701 $765
Flexible Spending $0 $0 $0 $75 $75 $75 $75 $75 $75 $300 $300 $300
Basic Admin $0 $0 $0 $1,200 $1,200 $1,200 $2,400 $2,400 $2,400 $4,800 $4,800 $4,800
All Inclusive $0 $0 $0 $1,800 $1,800 $1,800 $3,600 $3,600 $3,600 $7,200 $7,200 $7,200
Start-up Fees $0 $0 $0 $6,500 $500 $500 $4,500 $500 $500 $10,000 $500 $500
Total Sales $0 $0 $0 $9,830 $3,894 $3,958 $11,021 $7,085 $7,149 $22,938 $13,501 $13,565
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
COBRA/HIPAA 0.00% $2.75 $2.75 $2.75 $2.75 $2.75 $2.75 $2.75 $2.75 $2.75 $2.75 $2.75 $2.75
Flexible Spending 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Basic Admin 0.00% $2.75 $2.75 $2.75 $2.75 $2.75 $2.75 $2.75 $2.75 $2.75 $2.75 $2.75 $2.75
All Inclusive 0.00% $2.75 $2.75 $2.75 $2.75 $2.75 $2.75 $2.75 $2.75 $2.75 $2.75 $2.75 $2.75
Start-up Fees 0.00% $2.75 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Direct Cost of Sales
COBRA/HIPAA $0 $0 $0 $55 $69 $83 $96 $110 $124 $138 $151 $165
Flexible Spending $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Basic Admin $0 $0 $0 $275 $275 $275 $550 $550 $550 $1,100 $1,100 $1,100
All Inclusive $0 $0 $0 $275 $275 $275 $550 $550 $550 $1,100 $1,100 $1,100
Start-up Fees $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $0 $0 $0 $605 $619 $633 $1,196 $1,210 $1,224 $2,338 $2,351 $2,365
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
Name or title $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Name or title $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Name or title $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
Marketer Part Time $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Name or title $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Name or title $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
General and Administrative Personnel
Cindy Wells $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500
Diane Davis $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 Assistant Part Time $0 $0 $0 $0 $0 $0 $0 $0 $0 $1,084 $1,084 $1,084
Benefits Administrator $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Receptionist Part Time $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Benefits Administrator $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $6,084 $6,084 $6,084
Other Personnel
Name or title $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Name or title $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Name or title $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
Total People 2 2 2 2 2 2 2 2 2 3 3 3
Total Payroll $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $6,084 $6,084 $6,084
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 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00%
Long-term 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%
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 $0 $0 $0 $9,830 $3,894 $3,958 $11,021 $7,085 $7,149 $22,938 $13,501 $13,565
Direct Cost of Sales $0 $0 $0 $605 $619 $633 $1,196 $1,210 $1,224 $2,338 $2,351 $2,365
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 $605 $619 $633 $1,196 $1,210 $1,224 $2,338 $2,351 $2,365
Gross Margin $0 $0 $0 $9,225 $3,275 $3,325 $9,825 $5,875 $5,925 $20,600 $11,150 $11,200
Gross Margin % 0.00% 0.00% 0.00% 93.85% 84.11% 84.02% 89.15% 82.92% 82.88% 89.81% 82.58% 82.57%
Operating Expenses
Sales and Marketing Expenses
Sales and Marketing Payroll $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Advertising/Promotion $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
Travel $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Miscellaneous $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50
Total Sales and Marketing Expenses $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150
Sales and Marketing % 0.00% 0.00% 0.00% 1.53% 3.85% 3.79% 1.36% 2.12% 2.10% 0.65% 1.11% 1.11%
General and Administrative Expenses
General and Administrative Payroll $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $6,084 $6,084 $6,084
Sales and Marketing and Other Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Depreciation $85 $85 $85 $85 $85 $85 $85 $85 $85 $85 $85 $85
Dues and Subscriptions $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150
Professional Fees $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50
Rent $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600 $600
Software Purchases $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Insurance $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
Telephone and Internet Access $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Utilities $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Miscellaneous $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Payroll Taxes 8% $400 $400 $400 $400 $400 $400 $400 $400 $400 $487 $487 $487
Other General and Administrative Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total General and Administrative Expenses $6,985 $6,985 $6,985 $6,985 $6,985 $6,985 $6,985 $6,985 $6,985 $8,156 $8,156 $8,156
General and Administrative % 0.00% 0.00% 0.00% 71.06% 179.39% 176.50% 63.38% 98.59% 97.71% 35.56% 60.41% 60.12%
Other Expenses:
Other Payroll $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
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 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other % 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Total Operating Expenses $7,135 $7,135 $7,135 $7,135 $7,135 $7,135 $7,135 $7,135 $7,135 $8,306 $8,306 $8,306
Profit Before Interest and Taxes ($7,135) ($7,135) ($7,135) $2,090 ($3,860) ($3,810) $2,690 ($1,260) ($1,210) $12,294 $2,844 $2,894
EBITDA ($7,050) ($7,050) ($7,050) $2,175 ($3,775) ($3,725) $2,775 ($1,175) ($1,125) $12,379 $2,929 $2,979
Interest Expense $0 $375 $375 $370 $365 $360 $355 $350 $345 $339 $334 $329
Taxes Incurred $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit ($7,135) ($7,510) ($7,510) $1,720 ($4,225) ($4,170) $2,335 ($1,610) ($1,555) $11,955 $2,510 $2,565
Net Profit/Sales 0.00% 0.00% 0.00% 17.50% -108.51% -105.37% 21.19% -22.72% -21.75% 52.12% 18.59% 18.91%
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 $0 $0 $0 $328 $9,632 $3,896 $4,193 $10,890 $7,087 $7,675 $22,623
Subtotal Cash from Operations $0 $0 $0 $0 $328 $9,632 $3,896 $4,193 $10,890 $7,087 $7,675 $22,623
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 $50,000 $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 $50,000 $0 $0 $328 $9,632 $3,896 $4,193 $10,890 $7,087 $7,675 $22,623
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 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $6,084 $6,084 $6,084
Bill Payments $68 $2,063 $2,425 $2,445 $3,025 $3,034 $3,061 $3,601 $3,610 $3,658 $4,814 $4,822
Subtotal Spent on Operations $5,068 $7,063 $7,425 $7,445 $8,025 $8,034 $8,061 $8,601 $8,610 $9,742 $10,898 $10,906
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 $663 $669 $673 $678 $683 $688 $693 $699 $704
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 $5,068 $7,063 $7,425 $8,108 $8,694 $8,707 $8,739 $9,284 $9,298 $10,435 $11,597 $11,610
Net Cash Flow ($5,068) $42,938 ($7,425) ($8,108) ($8,367) $925 ($4,843) ($5,091) $1,592 ($3,348) ($3,922) $11,013
Cash Balance $5,932 $48,869 $41,444 $33,336 $24,970 $25,895 $21,051 $15,960 $17,552 $14,204 $10,282 $21,295
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 $11,000 $5,932 $48,869 $41,444 $33,336 $24,970 $25,895 $21,051 $15,960 $17,552 $14,204 $10,282 $21,295
Accounts Receivable $0 $0 $0 $0 $9,830 $13,396 $7,721 $14,847 $17,739 $13,998 $29,848 $35,674 $26,616
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $11,000 $5,932 $48,869 $41,444 $43,166 $38,366 $33,616 $35,898 $33,699 $31,550 $44,052 $45,956 $47,911
Long-term Assets
Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Accumulated Depreciation $0 $85 $170 $255 $340 $425 $510 $595 $680 $765 $850 $935 $1,020
Total Long-term Assets $0 ($85) ($170) ($255) ($340) ($425) ($510) ($595) ($680) ($765) ($850) ($935) ($1,020)
Total Assets $11,000 $5,847 $48,699 $41,189 $42,826 $37,941 $33,106 $35,303 $33,019 $30,785 $43,202 $45,021 $46,891
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 $1,982 $2,344 $2,344 $2,924 $2,933 $2,941 $3,481 $3,489 $3,498 $4,653 $4,661 $4,670
Current Borrowing $0 $0 $50,000 $50,000 $49,337 $48,668 $47,995 $47,317 $46,634 $45,946 $45,253 $44,554 $43,850
Other Current Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Current Liabilities $0 $1,982 $52,344 $52,344 $52,261 $51,601 $50,936 $50,798 $50,123 $49,444 $49,906 $49,215 $48,520
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $0 $1,982 $52,344 $52,344 $52,261 $51,601 $50,936 $50,798 $50,123 $49,444 $49,906 $49,215 $48,520
Paid-in Capital $31,428 $31,428 $31,428 $31,428 $31,428 $31,428 $31,428 $31,428 $31,428 $31,428 $31,428 $31,428 $31,428
Retained Earnings ($20,428) ($20,428) ($20,428) ($20,428) ($20,428) ($20,428) ($20,428) ($20,428) ($20,428) ($20,428) ($20,428) ($20,428) ($20,428)
Earnings $0 ($7,135) ($14,645) ($22,155) ($20,435) ($24,660) ($28,830) ($26,495) ($28,105) ($29,659) ($17,704) ($15,194) ($12,629)
Total Capital $11,000 $3,865 ($3,645) ($11,155) ($9,435) ($13,660) ($17,830) ($15,495) ($17,105) ($18,659) ($6,704) ($4,194) ($1,629)
Total Liabilities and Capital $11,000 $5,847 $48,699 $41,189 $42,826 $37,941 $33,106 $35,303 $33,019 $30,785 $43,202 $45,021 $46,891
Net Worth $11,000 $3,865 ($3,645) ($11,155) ($9,435) ($13,660) ($17,830) ($15,495) ($17,105) ($18,659) ($6,704) ($4,194) ($1,629)