SmartHelping / Assisted Living & Care Homes / Excel
Assisted Living Financial Model
Plan an assisted living facility, nursing home, or care home over 10 years. Connect room types, care levels, occupancy, staffing, development costs, and financing to three financial statements and investment returns.
Immediate download after purchase. By purchasing, you agree to the Terms of Service.
Video walkthrough & spreadsheet preview
See the facility forecast in action.
Upgraded planning tools
Explore the model updates.
Updates include a dynamic sources-and-uses summary, improved equity contribution inputs, a joint-venture waterfall, refreshed formatting, and an income statement organized to show contribution margin.
Version 2 update
Watch the walkthrough of the version 2 changes.
Recent updates
See the additional improvements to the workbook.
Revenue assumptions
Build revenue from rooms, care levels, and occupancy.
Five room types, six tiers of care
Configure up to five room types, each with up to six tiers of care. Separate the economics of different resident and room combinations.
Room rates and care charges
Set a base room rate, tier-of-care add-on charge, and room count for each room-type and care-tier combination.
Occupancy ramp
Define starting occupancy, monthly occupancy improvement, and stabilized occupancy for each combination to model the ramp toward an operating target.
Ancillary income
Enter other monthly ancillary income alongside the room and care revenue assumptions.
Staffing & operating expenses
Plan the people and operating costs behind the facility.
In-house salaried positions
Set headcount, start month, and payroll taxes and benefits to forecast fully loaded staffing costs.
Outsourced care and professional teams
Model outsourced therapy teams and other professionals. Define the headcount, timing, and applicable taxes and benefits for these roles.
Separate expense escalation
Apply separate global annual expense increases to in-house and outsourced staff to test how labor costs develop.
Operating overhead
Use a separate operating expense schedule for utilities, insurance, and other overhead costs.
Acquisition, development & debt
Connect the acquisition or development budget to funding.
Six monthly cost schedules
Enter acquisition and development costs in six cost sections, each with 22 line-item slots. Schedule the costs on a monthly timeline.
Financing by cost item
Choose whether each cost item is financed with a yes/no selector, then set the percentage financed.
Initial interest-only financing
Configure the initial loan and interest-only period. Choose whether interest accrues or is paid monthly, and define financing assumptions and the period for funding negative cash flows before equity-only funding.
Principal-and-interest loan
Roll the initial interest-only loan into a traditional principal-and-interest loan with its own terms.
Refinancing
Configure a final refinance loan with separate terms and LTV assumptions using the model’s annualized-EBITDA-based valuation approach.
Sources, uses, and equity contributions
Review the dynamic sources-and-uses summary and use the improved equity contribution inputs to understand the funding structure.
Model outputs
Review the statements, funding needs, and investor returns.
Three financial statements
Review monthly and annual income statements, balance sheets, and cash-flow statements over the 10-year forecast.
Detailed cash-flow schedules
Trace the assumptions through monthly and annual cash-flow detail to the main financial subtotals.
Executive summary and visuals
Use the annual executive summary and visualizations to communicate the financial outlook.
Discounted cash-flow analysis
Review a DCF analysis based on monthly periods, with IRR, ROI, and equity multiple for the project and investor-versus-owner perspectives where applicable.
Optional terminal value
Include a terminal value to evaluate the investment through the end of the modeled holding period.
Optional joint-venture waterfall
Model annual waterfall distributions with LP IRR hurdles when the investment uses a joint-venture structure.
How to use the model
Test the operating plan before committing capital.
Pricing and occupancy decisions
Compare room pricing and care-tier charges. Test different occupancy paths to understand the effect on revenue and facility economics.
Staffing and cost planning
Evaluate staffing counts, timing, in-house and outsourced costs, and general overhead assumptions.
Investment requirements
Estimate initial funding needs and evaluate the financial feasibility of acquiring or developing and operating the facility.
Investment analysis
Review the modeled cash flows and returns across the holding period and optional terminal value.
Who this model is for
Built for the property and operating sides of care.
Assisted living, nursing homes, and care homes
Combine room-based revenue with detailed staffing and operating assumptions in one facility forecast.
Development, acquisition, and other facility uses
Model a new development or an acquisition followed by operations. The structure can also be adapted for a hospital by adjusting the assumptions to fit the facility.
More templates in one purchase
Explore the bundles that include this model.
The Assisted Living Financial Model is included in the Real Estate, Hospitality, and Industry-Specific bundles, as well as the complete Super Smart collection.
Real Estate Financial Models
Explore models for property investment, acquisition, and development.
Explore the templateHospitality Financial Models
Explore other models for hospitality operations and related facilities.
Explore the templateIndustry-Specific Financial Models
Explore financial models built around the drivers of different businesses.
Explore the templateSuper Smart Bundle
Explore the complete public SmartHelping financial model collection.
Explore the templateAdditional resources
Explore the supporting tools and explanations.
Questions before you start
A few useful details.
How long is the forecast?
The model covers up to 10 years with monthly and annual financial reporting.
How many room types and care tiers can I model?
The revenue assumptions support up to five room types, each with up to six care tiers. Each combination has its own rates, room count, and occupancy assumptions.
Does the model include staffing?
Yes. It includes fully loaded assumptions for in-house salaried positions, outsourced therapy teams, and outsourced professionals, including headcount, start dates, taxes, and benefits.
Can I model an acquisition or a new development?
Yes. The six monthly cost schedules support acquisition and development costs, with financing selections for individual cost items.
What financing options are included?
The model includes initial interest-only financing, a transition to a principal-and-interest loan, and a final refinancing option with its own terms.
Does it include an investor waterfall?
Yes. An optional annual joint-venture waterfall includes LP IRR hurdles. The return analysis also includes investor-versus-owner outputs where applicable.
Which reports are included?
Monthly and annual income statements, balance sheets, cash-flow statements, detailed cash-flow schedules, an annual executive summary, DCF analysis, and visualizations.
How is the model delivered?
The $75 one-time purchase provides an immediate Excel download. The template is also included in the bundles listed above.
Plan the facility with the numbers in view
Connect care capacity, staffing, financing, and returns.
Assisted Living Financial Model — $75, one-time purchase.
