Wheatland Health Services

Start your own business plan »

Home Health Care Services 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
Home Health Care Sales 0% $25,000 $27,000 $27,900 $29,390 $31,000 $33,000 $35,000 $37,000 $39,000 $41,000 $42,900 $45,550
Personal Injury Case Management Sales 0% $900 $1,000 $1,200 $1,200 $1,400 $1,500 $1,600 $1,800 $1,900 $2,000 $2,200 $2,500
Total Sales $25,900 $28,000 $29,100 $30,590 $32,400 $34,500 $36,600 $38,800 $40,900 $43,000 $45,100 $48,050
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
Home Health Care Sales $1,313 $1,418 $1,465 $1,543 $1,628 $1,733 $1,838 $1,943 $2,048 $2,153 $2,252 $2,391
Personal Injury Case Management Sales $113 $125 $150 $150 $175 $188 $200 $225 $238 $250 $275 $313
Subtotal Direct Cost of Sales $1,425 $1,543 $1,615 $1,693 $1,803 $1,920 $2,038 $2,168 $2,285 $2,403 $2,527 $2,704
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
Administrative Director - Elizabeth Patzer, MSW/MPA 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Clinical Director - Kellene Walker, RN 0% $4,333 $4,333 $4,333 $4,333 $4,333 $4,333 $4,333 $4,333 $4,333 $4,333 $4,333 $4,333
Administrative Assistant 0% $1,560 $1,560 $1,560 $1,560 $1,560 $1,560 $1,560 $1,560 $1,560 $1,560 $1,560 $1,560
Skilled Nurse 0% $0 $0 $2,011 $2,011 $2,011 $2,011 $2,011 $2,011 $2,011 $2,011 $2,011 $2,011
Nurses Aide 0% $867 $867 $867 $867 $867 $876 $867 $867 $867 $867 $867 $867
Social Worker 0% $0 $0 $810 $810 $810 $810 $810 $810 $810 $810 $810 $810
Total People 7 7 7 7 7 7 7 7 7 7 7 7
Total Payroll $6,760 $6,760 $9,581 $9,581 $9,581 $9,590 $9,581 $9,581 $9,581 $9,581 $9,581 $9,581
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 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% 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 $25,900 $28,000 $29,100 $30,590 $32,400 $34,500 $36,600 $38,800 $40,900 $43,000 $45,100 $48,050
Direct Cost of Sales $1,425 $1,543 $1,615 $1,693 $1,803 $1,920 $2,038 $2,168 $2,285 $2,403 $2,527 $2,704
Other Costs of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $1,425 $1,543 $1,615 $1,693 $1,803 $1,920 $2,038 $2,168 $2,285 $2,403 $2,527 $2,704
Gross Margin $24,475 $26,458 $27,485 $28,897 $30,598 $32,580 $34,563 $36,633 $38,615 $40,598 $42,573 $45,346
Gross Margin % 94.50% 94.49% 94.45% 94.47% 94.44% 94.43% 94.43% 94.41% 94.41% 94.41% 94.40% 94.37%
Expenses
Payroll $6,760 $6,760 $9,581 $9,581 $9,581 $9,590 $9,581 $9,581 $9,581 $9,581 $9,581 $9,581
Payroll Taxes 15% $2,493 $2,493 $2,493 $2,493 $2,493 $2,493 $2,493 $2,493 $2,493 $2,493 $2,493 $2,493
Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Rent $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Heat and Lights $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150
Phone $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250
Cell Phones $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150
Water and Garbage $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50
Internet Access $25 $25 $25 $25 $25 $25 $25 $25 $25 $25 $25 $25
Professional Liability Insurance $750 $750 $750 $750 $750 $750 $750 $750 $750 $750 $750 $750
Workman's Comp Insurance $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50
Premises and Content Insurance $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50
Advertising and Marketing $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
Meals and Entertainment $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50
Professional Development $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
Office Equipment and Supplies 15% $400 $400 $400 $400 $400 $400 $400 $400 $400 $400 $400 $400
Contracted Therapists: OT/PT/ST 15% $1,625 $1,625 $1,625 $1,625 $1,625 $1,625 $1,625 $1,625 $1,625 $1,625 $1,625 $1,625
Nursing Supplies $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Total Operating Expenses $14,204 $14,204 $17,025 $17,025 $17,025 $17,034 $17,025 $17,025 $17,025 $17,025 $17,025 $17,025
Profit Before Interest and Taxes $10,271 $12,254 $10,461 $11,872 $13,573 $15,546 $17,538 $19,608 $21,590 $23,573 $25,548 $28,321
EBITDA $10,271 $12,254 $10,461 $11,872 $13,573 $15,546 $17,538 $19,608 $21,590 $23,573 $25,548 $28,321
Interest Expense $333 $333 $333 $333 $333 $333 $333 $333 $333 $333 $333 $333
Taxes Incurred $2,981 $3,576 $3,038 $3,462 $3,972 $4,564 $5,161 $5,782 $6,377 $6,972 $7,564 $8,396
Net Profit $6,957 $8,344 $7,089 $8,077 $9,268 $10,649 $12,043 $13,492 $14,880 $16,268 $17,650 $19,592
Net Profit/Sales 26.86% 29.80% 24.36% 26.41% 28.60% 30.87% 32.90% 34.77% 36.38% 37.83% 39.14% 40.77%
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 $863 $25,970 $28,037 $29,150 $30,650 $32,470 $34,570 $36,673 $38,870 $40,970 $43,070
Subtotal Cash from Operations $0 $863 $25,970 $28,037 $29,150 $30,650 $32,470 $34,570 $36,673 $38,870 $40,970 $43,070
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 $863 $25,970 $28,037 $29,150 $30,650 $32,470 $34,570 $36,673 $38,870 $40,970 $43,070
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 $6,760 $6,760 $9,581 $9,581 $9,581 $9,590 $9,581 $9,581 $9,581 $9,581 $9,581 $9,581
Bill Payments $406 $12,207 $12,880 $12,446 $12,952 $13,575 $14,284 $15,001 $15,750 $16,462 $17,175 $17,902
Subtotal Spent on Operations $7,166 $18,967 $22,461 $22,028 $22,533 $23,165 $23,866 $24,582 $25,332 $26,044 $26,756 $27,483
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 $7,166 $18,967 $22,461 $22,028 $22,533 $23,165 $23,866 $24,582 $25,332 $26,044 $26,756 $27,483
Net Cash Flow ($7,166) ($18,104) $3,509 $6,009 $6,616 $7,485 $8,604 $9,988 $11,342 $12,826 $14,214 $15,587
Cash Balance $37,433 $19,329 $22,838 $28,847 $35,463 $42,948 $51,553 $61,541 $72,883 $85,709 $99,923 $115,509
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 $44,599 $37,433 $19,329 $22,838 $28,847 $35,463 $42,948 $51,553 $61,541 $72,883 $85,709 $99,923 $115,509
Accounts Receivable $0 $25,900 $53,037 $56,167 $58,720 $61,970 $65,820 $69,950 $74,180 $78,407 $82,537 $86,667 $91,647
Other Current Assets $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500
Total Current Assets $48,099 $66,833 $75,865 $82,504 $91,067 $100,933 $112,268 $125,003 $139,221 $154,789 $171,745 $190,089 $210,656
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 $48,099 $66,833 $75,865 $82,504 $91,067 $100,933 $112,268 $125,003 $139,221 $154,789 $171,745 $190,089 $210,656
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,777 $12,465 $12,015 $12,500 $13,099 $13,785 $14,476 $15,202 $15,891 $16,579 $17,273 $18,248
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,777 $12,465 $12,015 $12,500 $13,099 $13,785 $14,476 $15,202 $15,891 $16,579 $17,273 $18,248
Long-term Liabilities $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $50,000
Total Liabilities $50,000 $61,777 $62,465 $62,015 $62,500 $63,099 $63,785 $64,476 $65,202 $65,891 $66,579 $67,273 $68,248
Paid-in Capital $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000
Retained Earnings ($21,901) ($21,901) ($21,901) ($21,901) ($21,901) ($21,901) ($21,901) ($21,901) ($21,901) ($21,901) ($21,901) ($21,901) ($21,901)
Earnings $0 $6,957 $15,301 $22,390 $30,467 $39,735 $50,384 $62,427 $75,920 $90,800 $107,067 $124,718 $144,309
Total Capital ($1,901) $5,056 $13,400 $20,489 $28,566 $37,834 $48,483 $60,526 $74,019 $88,899 $105,166 $122,817 $142,408
Total Liabilities and Capital $48,099 $66,833 $75,865 $82,504 $91,067 $100,933 $112,268 $125,003 $139,221 $154,789 $171,745 $190,089 $210,656
Net Worth ($1,901) $5,056 $13,400 $20,489 $28,566 $37,834 $48,483 $60,526 $74,019 $88,899 $105,166 $122,817 $142,408