Bright House nursing home business plan appendix. Bright House is a small-scale, nonprofit home for the elderly, focusing on quality of life as much as on skilled nursing and medical care.

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

Get the Bplans newsletter:

Expert business tips and advice delivered weekly.

\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n
Bright House nursing home business plan appendix. Bright House is a small-scale, nonprofit home for the elderly, focusing on quality of life as much as on skilled nursing and medical care.
\n