Bright House

Start your own business plan »

Nursing Home Business Plan

Appendix

Funding 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
Units
Assisted Living Main Residents 0% 8 10 10 12 12 14 14 14 14 14 14 14
Medicare Residents - Skilled Nursing Facility 0% 3 4 4 6 8 9 10 10 10 10 10 10
Other 0% 0 0 0 0 0 0 0 0 0 0 0 0
Total Units 11 14 14 18 20 23 24 24 24 24 24 24
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
Assisted Living Main Residents $3,200.00 $3,200.00 $3,200.00 $3,200.00 $3,200.00 $3,200.00 $3,200.00 $3,200.00 $3,200.00 $3,200.00 $3,200.00 $3,200.00
Medicare Residents - Skilled Nursing Facility $4,050.00 $4,050.00 $4,050.00 $4,050.00 $4,050.00 $4,050.00 $4,050.00 $4,050.00 $4,050.00 $4,050.00 $4,050.00 $4,050.00
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
Funding
Assisted Living Main Residents $25,600 $32,000 $32,000 $38,400 $38,400 $44,800 $44,800 $44,800 $44,800 $44,800 $44,800 $44,800
Medicare Residents - Skilled Nursing Facility $12,150 $16,200 $16,200 $24,300 $32,400 $36,450 $40,500 $40,500 $40,500 $40,500 $40,500 $40,500
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Funding $37,750 $48,200 $48,200 $62,700 $70,800 $81,250 $85,300 $85,300 $85,300 $85,300 $85,300 $85,300
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
Assisted Living Main Residents 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
Medicare Residents - Skilled Nursing Facility 20.00% $810.00 $810.00 $810.00 $810.00 $810.00 $810.00 $810.00 $810.00 $810.00 $810.00 $810.00 $810.00
Other 20.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
Direct Cost of Funding
Assisted Living Main Residents $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Medicare Residents - Skilled Nursing Facility $2,430 $3,240 $3,240 $4,860 $6,480 $7,290 $8,100 $8,100 $8,100 $8,100 $8,100 $8,100
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Funding $2,430 $3,240 $3,240 $4,860 $6,480 $7,290 $8,100 $8,100 $8,100 $8,100 $8,100 $8,100
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
Medical/Clinical Personnel
Medical Director 100% $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500 $5,500
LPNs - Full-time 35-40 hrs, night 200% $9,750 $9,750 $9,750 $9,750 $9,750 $9,750 $9,750 $9,750 $9,750 $9,750 $9,750 $9,750
LPNs - swing shift, 30 hours, day 100% $0 $0 $0 $0 $0 $4,875 $4,875 $4,875 $4,875 $4,875 $4,875 $4,875
Subtotal $15,250 $15,250 $15,250 $15,250 $15,250 $20,125 $20,125 $20,125 $20,125 $20,125 $20,125 $20,125
Caretaking Personnel
Elder Assistants 600% $15,600 $18,720 $18,720 $18,720 $18,720 $18,720 $18,720 $18,720 $18,720 $18,720 $18,720 $18,720
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal $15,600 $18,720 $18,720 $18,720 $18,720 $18,720 $18,720 $18,720 $18,720 $18,720 $18,720 $18,720
Administrative Personnel
Medicare Liason / Billing Specialist 100% $2,800 $2,800 $2,800 $2,800 $2,800 $2,800 $2,800 $2,800 $2,800 $2,800 $2,800 $2,800
Financial Manager 100% $5,400 $5,400 $5,400 $5,400 $5,400 $5,400 $5,400 $5,400 $5,400 $5,400 $5,400 $5,400
Janice Ruthers - Part-time Marketing 100% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal $8,200 $8,200 $8,200 $8,200 $8,200 $8,200 $8,200 $8,200 $8,200 $8,200 $8,200 $8,200
Fundraising Personnel
Development Officer - Part-time 100% $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200
Name or Title or Group $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Name or Title or Group $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200
Total People 13 13 13 13 13 14 14 14 14 14 14 14
Total Payroll $40,250 $43,370 $43,370 $43,370 $43,370 $48,245 $48,245 $48,245 $48,245 $48,245 $48,245 $48,245
Surplus and Deficit
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Funding $37,750 $48,200 $48,200 $62,700 $70,800 $81,250 $85,300 $85,300 $85,300 $85,300 $85,300 $85,300
Direct Cost $2,430 $3,240 $3,240 $4,860 $6,480 $7,290 $8,100 $8,100 $8,100 $8,100 $8,100 $8,100
Medical/Clinical Payroll $15,250 $15,250 $15,250 $15,250 $15,250 $20,125 $20,125 $20,125 $20,125 $20,125 $20,125 $20,125
Non-reusable Medical Equipment $400 $400 $400 $400 $400 $400 $400 $400 $400 $400 $400 $400
#NAME? $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Direct Cost $18,080 $18,890 $18,890 $20,510 $22,130 $27,815 $28,625 $28,625 $28,625 $28,625 $28,625 $28,625
Gross Surplus $19,670 $29,310 $29,310 $42,190 $48,670 $53,435 $56,675 $56,675 $56,675 $56,675 $56,675 $56,675
Gross Surplus % 52.11% 60.81% 60.81% 67.29% 68.74% 65.77% 66.44% 66.44% 66.44% 66.44% 66.44% 66.44%
Operating Expenses
Caretaking Expenses
Caretaking Payroll $15,600 $18,720 $18,720 $18,720 $18,720 $18,720 $18,720 $18,720 $18,720 $18,720 $18,720 $18,720
Groceries $1,400 $1,400 $1,400 $1,400 $1,400 $1,400 $1,400 $1,400 $1,400 $1,400 $1,400 $1,400
Cleaning Supplies $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
Other Caretaking Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Caretaking Expenses $17,100 $20,220 $20,220 $20,220 $20,220 $20,220 $20,220 $20,220 $20,220 $20,220 $20,220 $20,220
Caretaking % 45.30% 41.95% 41.95% 32.25% 28.56% 24.89% 23.70% 23.70% 23.70% 23.70% 23.70% 23.70%
Administrative Expenses
Administrative Payroll $8,200 $8,200 $8,200 $8,200 $8,200 $8,200 $8,200 $8,200 $8,200 $8,200 $8,200 $8,200
Other Expense Account Name $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Depreciation $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
Property Taxes $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Utilities $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Insurance $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200
Payroll Taxes 15% $6,038 $6,506 $6,506 $6,506 $6,506 $7,237 $7,237 $7,237 $7,237 $7,237 $7,237 $7,237
Grounds and Building Upkeep 15% $400 $400 $400 $400 $400 $400 $400 $400 $400 $400 $400 $400
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Administrative Expenses $18,938 $19,406 $19,406 $19,406 $19,406 $20,137 $20,137 $20,137 $20,137 $20,137 $20,137 $20,137
Administrative % 50.17% 40.26% 40.26% 30.95% 27.41% 24.78% 23.61% 23.61% 23.61% 23.61% 23.61% 23.61%
Fundraising Expenses:
Fundraising Payroll $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200
Brochures, Marketing $800 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Fundraising Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Fundraising Expenses $2,000 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200
Fundraising % 5.30% 2.49% 2.49% 1.91% 1.69% 1.48% 1.41% 1.41% 1.41% 1.41% 1.41% 1.41%
Total Operating Expenses $38,038 $40,826 $40,826 $40,826 $40,826 $41,557 $41,557 $41,557 $41,557 $41,557 $41,557 $41,557
Surplus Before Interest and Taxes ($18,368) ($11,516) ($11,516) $1,365 $7,845 $11,878 $15,118 $15,118 $15,118 $15,118 $15,118 $15,118
EBITDA ($18,268) ($11,416) ($11,416) $1,465 $7,945 $11,978 $15,218 $15,218 $15,218 $15,218 $15,218 $15,218
Interest Expense $1,821 $1,808 $1,792 $1,775 $1,750 $1,725 $1,696 $1,671 $1,646 $1,621 $1,596 $1,579
Taxes Incurred $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Surplus ($20,188) ($13,324) ($13,307) ($411) $6,095 $10,153 $13,422 $13,447 $13,472 $13,497 $13,522 $13,539
Net Surplus/Funding -53.48% -27.64% -27.61% -0.65% 8.61% 12.50% 15.74% 15.76% 15.79% 15.82% 15.85% 15.87%
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 Funding $28,313 $36,150 $36,150 $47,025 $53,100 $60,938 $63,975 $63,975 $63,975 $63,975 $63,975 $63,975
Cash from Receivables $0 $315 $9,525 $12,050 $12,171 $15,743 $17,787 $20,346 $21,325 $21,325 $21,325 $21,325
Subtotal Cash from Operations $28,313 $36,465 $45,675 $59,075 $65,271 $76,680 $81,762 $84,321 $85,300 $85,300 $85,300 $85,300
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 $5,000 $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 $25,000 $0 $0 $0 $0 $0
New Investment Received $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Received $33,313 $36,465 $45,675 $59,075 $65,271 $76,680 $106,762 $84,321 $85,300 $85,300 $85,300 $85,300
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 $40,250 $43,370 $43,370 $43,370 $43,370 $48,245 $48,245 $48,245 $48,245 $48,245 $48,245 $48,245
Bill Payments $505 $15,244 $17,734 $18,145 $21,314 $22,879 $23,588 $24,315 $23,507 $23,482 $23,457 $23,432
Subtotal Spent on Operations $40,755 $58,614 $61,104 $61,515 $64,684 $71,124 $71,833 $72,560 $71,752 $71,727 $71,702 $71,677
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 $500 $500 $1,000 $1,000 $1,000 $1,000 $500 $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 $1,000 $1,000 $1,000 $1,000 $2,000 $2,000 $3,000 $3,000 $3,000 $3,000 $3,000 $2,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 $42,255 $60,114 $63,104 $63,515 $67,684 $74,124 $75,333 $75,560 $74,752 $74,727 $74,702 $73,677
Net Cash Flow ($8,943) ($23,649) ($17,430) ($4,440) ($2,413) $2,556 $31,429 $8,761 $10,548 $10,573 $10,598 $11,623
Cash Balance $69,057 $45,408 $27,978 $23,539 $21,126 $23,682 $55,111 $63,873 $74,421 $84,994 $95,592 $107,215
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 $78,000 $69,057 $45,408 $27,978 $23,539 $21,126 $23,682 $55,111 $63,873 $74,421 $84,994 $95,592 $107,215
Accounts Receivable $0 $9,438 $21,173 $23,698 $27,323 $32,853 $37,423 $40,960 $41,939 $41,939 $41,939 $41,939 $41,939
Inventory $6,000 $3,570 $3,240 $3,240 $4,860 $6,480 $7,290 $8,100 $8,100 $8,100 $8,100 $8,100 $8,100
Other Current Assets $31,000 $31,000 $31,000 $31,000 $31,000 $31,000 $31,000 $31,000 $31,000 $31,000 $31,000 $31,000 $31,000
Total Current Assets $115,000 $113,065 $100,821 $85,917 $86,722 $91,458 $99,394 $135,171 $144,912 $155,460 $166,033 $176,631 $188,254
Long-term Assets
Long-term Assets $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 $725,000 $725,000 $725,000 $725,000 $725,000 $725,000
Accumulated Depreciation $0 $100 $200 $300 $400 $500 $600 $700 $800 $900 $1,000 $1,100 $1,200
Total Long-term Assets $750,000 $749,900 $749,800 $749,700 $749,600 $749,500 $749,400 $724,300 $724,200 $724,100 $724,000 $723,900 $723,800
Total Assets $865,000 $862,965 $850,621 $835,617 $836,322 $840,958 $848,794 $859,471 $869,112 $879,560 $890,033 $900,531 $912,054
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 $14,653 $17,133 $17,436 $20,552 $22,094 $22,776 $23,531 $22,724 $22,700 $22,676 $22,651 $22,635
Current Borrowing $5,000 $9,500 $9,000 $8,000 $7,000 $6,000 $5,000 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500
Other Current Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Current Liabilities $5,000 $24,153 $26,133 $25,436 $27,552 $28,094 $27,776 $28,031 $27,224 $27,200 $27,176 $27,151 $27,135
Long-term Liabilities $210,000 $209,000 $208,000 $207,000 $206,000 $204,000 $202,000 $199,000 $196,000 $193,000 $190,000 $187,000 $185,000
Total Liabilities $215,000 $233,153 $234,133 $232,436 $233,552 $232,094 $229,776 $227,031 $223,224 $220,200 $217,176 $214,151 $212,135
Paid-in Capital $699,150 $699,150 $699,150 $699,150 $699,150 $699,150 $699,150 $699,150 $699,150 $699,150 $699,150 $699,150 $699,150
Accumulated Surplus/Deficit ($49,150) ($49,150) ($49,150) ($49,150) ($49,150) ($49,150) ($49,150) ($49,150) ($49,150) ($49,150) ($49,150) ($49,150) ($49,150)
Surplus/Deficit $0 ($20,188) ($33,512) ($46,819) ($47,230) ($41,135) ($30,982) ($17,560) ($4,112) $9,360 $22,858 $36,380 $49,919
Total Capital $650,000 $629,812 $616,488 $603,181 $602,770 $608,865 $619,018 $632,440 $645,888 $659,360 $672,858 $686,380 $699,919
Total Liabilities and Capital $865,000 $862,965 $850,621 $835,617 $836,322 $840,958 $848,794 $859,471 $869,112 $879,560 $890,033 $900,531 $912,054
Net Worth $650,000 $629,812 $616,488 $603,181 $602,770 $608,865 $619,018 $632,440 $645,888 $659,360 $672,858 $686,380 $699,919