This page explains every input field in the Care Home Leaseback Modeler and how to read each output table. Use the links below to jump to a section.
Fields are grouped exactly as they appear on the left-hand side of the calculator.
Payroll & benefits, food/dietary, utilities, property insurance, liability/other insurance, property taxes, repairs & maintenance, marketing, admin/office, licensing/supplies/misc, capex reserve, and credit loss/bad debt. These are the Operator’s day-to-day operating costs, netted against revenue to produce EBITDAR (see glossary). Most are entered as flat annual dollar amounts or per-resident/month amounts, except payroll and credit loss, which are entered as a percentage of revenue.
These three fields size the loan the Operator would use to buy the property back from the Landlord at the end of the lease term: down payment (borrower equity, as a % of the net buyback price), interest rate, and amortization (years). Together they determine the SBA 7(a) loan amount and annual debt service shown in the buyback tables.
Every table on the results side updates live as you change inputs. Here’s what each one is telling you.
A snapshot comparing the Landlord and Operator in the first year at stabilized occupancy.
The same metrics as the Year 1 table, projected across all five years of the lease with the annual escalator applied. Use this to see the trend over the full lease term, not just the opening year.
These two sections model what happens if the Landlord sells the property back to the Operator at the end of Year 3 or Year 5 — compare both to see how the timing of the buyback affects returns.
A side-by-side “what if” scenario: instead of the Landlord funding the renovation, the Operator funds it. In this preset, the Landlord’s basis is purchase price only (no renovation cost added), so rent is lower for the entire lease, since rent is charged on the Landlord’s basis. The table shows Year-1 rent, coverage, Operator profit, and Landlord NOI under this scenario, plus 3-year and 5-year Landlord IRR alongside the Operator’s cumulative profit over the same period — so you can compare who funding the buildout benefits more, the Landlord or the Operator.
Reruns the Year 1 numbers at five occupancy levels — your base-case occupancy, 75%, 65%, 50%, and the “Other” column you set above — while holding rent fixed at the Year 1 base rent (no escalation). This isolates the effect of occupancy alone, so you can see exactly how the deal performs if occupancy comes in below (or above) plan before you commit to it.
One row often surprises people: Landlord NOI still moves even though rent is fixed. That’s because NOI here is “rent” MINUS the “management fee”, and the management fee is a percentage of revenue (EGR) — which scales directly with occupancy. So as occupancy rises, the Landlord collects the same rent but owes the Operator a bigger fee out of it, which pulls NOI down. The relationship runs the opposite of what you’d expect: Landlord NOI is highest at low occupancy and lowest at high occupancy. Using this tool’s default assumptions (rent fixed at $140,100; 5% management fee):
| Occupancy | EGR | Mgmt fee (5% of EGR) | Landlord NOI (rent − fee) |
|---|---|---|---|
| 50% | $481,140 | $24,057 | $116,043 |
| 65% | $625,482 | $31,274 | $108,826 |
| 75% | $721,710 | $36,085 | $104,015 |
| 85% (default) | $817,938 | $40,897 | $99,203 |
| 95% | $914,166 | $45,708 | $94,392 |
This is why structuring the management fee as a percentage of revenue — rather than a flat dollar amount — matters: it gives the Operator a direct financial stake in maintaining the highest occupancy/census level, since their fee (and the Landlord’s fee expense) scales with actual performance.
For illustrative and educational purposes only. Not investment, tax, or legal advice. Projections use user-supplied assumptions and are not guaranteed. Consult qualified professionals.