← All writing← 全部文章 Essay · 2026-11-08 · 13 min read

Your Financial Model Is a Zip File Nobody Unzipped

A 52,148-formula underwriting model is really 951 hand-written formulas dragged across rows and columns. Unzip that logic from the grid and you can run the deal in 19 milliseconds and ask what it takes to hit a return.

这篇暂时只有英文版。

Excel is the most used programming language on earth. Hundreds of millions of people use it. A model that decides an $80 million real-estate acquisition is written in it, emailed as an attachment, opened by someone else, changed, and emailed back. When it returns, it is hard to prove what changed.

For forty years, every other programming language grew tools to keep changes safe: a way to run the program without opening an editor, a way to compare two versions line by line, and an automated check that turns red the second an edit breaks something three files away. Excel got Track Changes.

Then AI arrived and took the easy path. It learned to write new spreadsheets from scratch. Ask any assistant to build a discounted cash flow model and you get a clean one in a minute. Ask it to work across the models your acquisitions team has actually used since 2019 (one deal in three versions side by side, ten properties rolled into a fund, or thirty deals checked against the appraiser’s model) and you are back on your own.

The assistant inside Excel is a colleague sitting next to you, looking at your screen. It reads one workbook at a time: the one you have open. Every time you ask a question, it flips through the cells again. Because the grid shows where the numbers landed, not the logic that produced them, the assistant cannot see the whole machine, so it guesses. To check it, you go back into Excel and run the case yourself.

I have spent twelve years in commercial real-estate investment and the past year building a different layer. It starts from how every financial model is built: an analyst writes a few hundred formulas and drags them across every month and every schedule. Your model is a zip file of logic packed inside a giant grid, and it has never been unzipped.


What Sits Inside a Real Model

Start with what a deal model contains. Here is one real acquisition model, in round numbers:

Part of the Workbook Count
Formula cells about 105,000
OFFSET calls (a function that shifts which cells a formula points to while the sheet calculates) about 3,000
Defined names (named labels for cell ranges, most of which now point at nothing) about 9,000
Hidden sheets more than a dozen
Circular references (a loop where cells depend on their own output, which Excel resolves by repeating the math) one loop of a few hundred cells

That is not a table of numbers. It is a program. It has a web of cell-to-cell links, shifting addresses, thousands of dead labels from old deals, and a calculation loop. It has every property that makes software hard to change, and none of the tools that make changing software safe.

Counts like these are hard to picture. So here is my own senior-living model, about half that size, drawn as what it really is: a machine. Every box is a region of the workbook, and every pipe is a bundle of formulas feeding one region from another. The thicker the pipe, the more formulas run through it.

Assumptionsthe inputs, 23 formulas · feed the regions belowTimeline193 monthly periods, 3,137 formulas · feeds every regionChecks166 formulas · read every regionDashboard278 formulas · the summary page, reads the resultsCapital budget2,376 formulasCensus4,246 formulasStaffing14,335 formulasRevenue3,690 formulasExpenses3,980 formulasNOI2,581 formulasExit1,230 formulasDebt6,716 formulasSensitivity4,880 formulasWaterfall4,510 formulas304,038 links
My 52,148-formula senior-living model as a machine: 14 regions and 1,656,807 formula links. The assumptions and the timeline feed the regions below them; the checks and the summary page read the results. The thickest pipe runs from the capital budget into the census, because renovation takes units offline. Open the moving version in the Lab.

Dump a workbook like this straight into a language model and it fails. Even my senior-living workbook turns into more than six million tokens of text, the small word-pieces a language model reads. No memory window can hold it cleanly, and even if one could, the AI would spend almost all of its attention reading the same monthly formula fifty thousand times.


The Zip File in Plain Sight

Almost every formula in a financial model is a copy of the formula to its left or the formula above it.

An analyst writes one formula for January in column C, drags it right to the last month of the hold period, and drags it down to the last unit type. The column letter changes from C to D to E. The logic is the same line. Every analyst knows this in their hands. Because every financial model stretches across a timeline of months or years, a single row of logic always turns into dozens of identical cells.

When I scanned three underwriting models I built myself, 98 to 99 formulas out of every 100 were drag-copies of this kind:

Senior-living DCF
951 of 52,148 formulas written by hand

Student-housing development
589 of 53,619 formulas written by hand

Senior-living acquisition
245 of 20,238 formulas written by hand

written by handa copy of the formula beside it

Each grid is 100 formulas from one of my models, to scale. The dark squares are the ones somebody actually wrote. The rest are dragged from the cell to the left or the cell above: 98 or 99 out of every 100 in all three models.

Look at the first grid. My senior-living model has 52,148 formulas, and I only ever wrote 951 of them. The other 51,197 are copies. That workbook is 951 lines of hand-written logic plus a layout map showing where each line sits on the grid.

Excel stores the logic and the layout tangled together, a formula in every cell, because a grid is how people read. The program is small. My three workbooks repeat theirs fifty-five to ninety-one times over, sealing the logic inside the copies. That is the zip file from the title: a sealed package, sitting in plain sight on every analyst’s screen.

I spent the past year building the unzipper. It pulls the 951 lines of hand-written logic apart from the layout map and runs them as a standalone calculation engine. With the copies gone, the engine holds 70 to 80 times fewer formulas than the workbook on average (55, 91 and 83 times fewer on my three models). The engine exports back out to a standard Excel file with every formula intact, any time. It also makes the calculation itself faster without changing an answer. Drop the exported file back into Excel and recalculate: not one number changes.

In the workbook 193 formula cells on the occupied-units row, one for each month

 43
D=D41*D42
E=E41*E42
F=F41*F42
……
GM=GM41*GM42
GN=GN41*GN42

Unzipped one line of logic, and a note of where it sits

Logic

occupied units = units × occupancy

Layout

Ops & Staffing · row 43 · D to GN

One real row of my senior-living model, before and after. Do the same for every row and 52,148 formula cells come down to 951 lines of logic and a layout map. Put the two back together and you have the Excel file again.

In 2024, Microsoft published a research paper called SpreadsheetLLM, which also compresses spreadsheets for AI. Their method compresses what a sheet looks like: cell values, number formats, and addresses. My system compresses what a sheet computes: the formulas and the logic. If you are reviewing a table layout, you want the first. If you are underwriting a deal, you need the second.

Separate the logic from the layout and those six million tokens shrink to about sixty-six thousand. An AI can read the entire model in a single pass. And because the logic now runs in a dedicated calculation engine, the AI never does the arithmetic itself. The AI reads your question, calls the engine, and reads you the result. Every number comes from the engine, and every cell has already been checked against the values Excel saved in the file. And not only the saved case. In October, Excel itself recalculated my senior-living model under 582 different sets of inputs, and the engine agreed with it on all 52,148 formula cells every time (to one part in a million, or one millionth for numbers smaller than one).


What You Can Do Once It Is Unzipped

Unzipped, a job that took hours of clicking in Excel becomes one question.

The five-minute explainer. The model numbers in it are engine runs on my own senior-living model.

1. Recompute the whole model in 19 milliseconds

On my senior-living model, the engine recomputes the entire workbook from its 2,357 input cells in 19 milliseconds, about one tenth of a blink. A year ago, my first version took 8.7 seconds on the same file. The other models I keep for timing all recalculate in under a tenth of a second. Even on a model with a circular loop of about 2,800 cells, changing one assumption comes back in under a second. It runs every pass of that loop just as Excel does.

In Excel, sensitivity analysis means picking a few step sizes in advance, waiting for a data table to run, and pasting the outputs into a deck. Pick steps too wide and you miss the exact cliff where a deal breaks. Pick steps too narrow and the table outgrows the slide. At 19 milliseconds a run, you do not need to build scenario tables before a meeting. You keep only the inputs and the model version, and you run the exact case someone asks for on the spot.

Try a case on the live model: occupancy at 90 percent instead of 94 →

2. Ask the model backwards across three or four assumptions at once

Start with the questions you already ask. As my senior-living model stands, occupancy is 94 percent and the deal’s IRR is 14.31 percent. Move the assisted-living units alone to 95 percent and the IRR moves to 14.66 percent. Ask for the lowest assisted-living occupancy that clears a 15 percent IRR: 97 percent clears it, 96 just misses.

Ask the live model this question →

Then the questions Excel makes you work for. Nudge every assumption up one notch and rank them by how far the IRR moves: concessions come first (one point up, IRR down 1.06 points), resident rates second (one percent up, IRR up 0.97 points).

You can do all of that in Excel if you have the patience. Goal Seek handles one variable at a time. A Data Table stops at two axes, say occupancy by resident rate, and drags the workbook to a crawl while it fills in. Two axes is the ceiling for a Data Table. Add exit cap rate as a third axis, and it has no cell to put it in.

On the engine, three axes (15 assisted-living occupancy steps by 11 rate steps by 9 exit-cap steps) is 1,485 combinations. The engine recomputes all 52,148 formulas 1,485 times in 48 seconds (about 32 milliseconds per case, start to finish) and hands back the 596 combinations that clear a 15 percent IRR. Add concessions as a fourth axis and it runs over 13,000 combinations in under ten minutes, finding the more than 6,300 cases that clear the hurdle. Instead of one break-even occupancy, you see the whole region of assumptions where the deal still works.

Assisted-living occupancy 86%, rates −5%, exit cap −50 bp: IRR 7.08%Assisted-living occupancy 87%, rates −5%, exit cap −50 bp: IRR 7.44%Assisted-living occupancy 88%, rates −5%, exit cap −50 bp: IRR 7.81%Assisted-living occupancy 89%, rates −5%, exit cap −50 bp: IRR 8.17%Assisted-living occupancy 90%, rates −5%, exit cap −50 bp: IRR 8.55%Assisted-living occupancy 91%, rates −5%, exit cap −50 bp: IRR 8.92%Assisted-living occupancy 92%, rates −5%, exit cap −50 bp: IRR 9.30%Assisted-living occupancy 93%, rates −5%, exit cap −50 bp: IRR 9.69%Assisted-living occupancy 94%, rates −5%, exit cap −50 bp: IRR 10.08%Assisted-living occupancy 95%, rates −5%, exit cap −50 bp: IRR 10.47%Assisted-living occupancy 96%, rates −5%, exit cap −50 bp: IRR 10.87%Assisted-living occupancy 97%, rates −5%, exit cap −50 bp: IRR 11.28%Assisted-living occupancy 98%, rates −5%, exit cap −50 bp: IRR 11.69%Assisted-living occupancy 99%, rates −5%, exit cap −50 bp: IRR 12.10%Assisted-living occupancy 100%, rates −5%, exit cap −50 bp: IRR 12.45%Assisted-living occupancy 86%, rates −4%, exit cap −50 bp: IRR 8.14%Assisted-living occupancy 87%, rates −4%, exit cap −50 bp: IRR 8.52%Assisted-living occupancy 88%, rates −4%, exit cap −50 bp: IRR 8.90%Assisted-living occupancy 89%, rates −4%, exit cap −50 bp: IRR 9.29%Assisted-living occupancy 90%, rates −4%, exit cap −50 bp: IRR 9.68%Assisted-living occupancy 91%, rates −4%, exit cap −50 bp: IRR 10.08%Assisted-living occupancy 92%, rates −4%, exit cap −50 bp: IRR 10.48%Assisted-living occupancy 93%, rates −4%, exit cap −50 bp: IRR 10.88%Assisted-living occupancy 94%, rates −4%, exit cap −50 bp: IRR 11.29%Assisted-living occupancy 95%, rates −4%, exit cap −50 bp: IRR 11.71%Assisted-living occupancy 96%, rates −4%, exit cap −50 bp: IRR 12.13%Assisted-living occupancy 97%, rates −4%, exit cap −50 bp: IRR 12.49%Assisted-living occupancy 98%, rates −4%, exit cap −50 bp: IRR 12.83%Assisted-living occupancy 99%, rates −4%, exit cap −50 bp: IRR 13.18%Assisted-living occupancy 100%, rates −4%, exit cap −50 bp: IRR 13.52%Assisted-living occupancy 86%, rates −3%, exit cap −50 bp: IRR 9.24%Assisted-living occupancy 87%, rates −3%, exit cap −50 bp: IRR 9.63%Assisted-living occupancy 88%, rates −3%, exit cap −50 bp: IRR 10.03%Assisted-living occupancy 89%, rates −3%, exit cap −50 bp: IRR 10.44%Assisted-living occupancy 90%, rates −3%, exit cap −50 bp: IRR 10.85%Assisted-living occupancy 91%, rates −3%, exit cap −50 bp: IRR 11.27%Assisted-living occupancy 92%, rates −3%, exit cap −50 bp: IRR 11.70%Assisted-living occupancy 93%, rates −3%, exit cap −50 bp: IRR 12.13%Assisted-living occupancy 94%, rates −3%, exit cap −50 bp: IRR 12.49%Assisted-living occupancy 95%, rates −3%, exit cap −50 bp: IRR 12.84%Assisted-living occupancy 96%, rates −3%, exit cap −50 bp: IRR 13.19%Assisted-living occupancy 97%, rates −3%, exit cap −50 bp: IRR 13.54%Assisted-living occupancy 98%, rates −3%, exit cap −50 bp: IRR 13.88%Assisted-living occupancy 99%, rates −3%, exit cap −50 bp: IRR 14.22%Assisted-living occupancy 100%, rates −3%, exit cap −50 bp: IRR 14.55%Assisted-living occupancy 86%, rates −2%, exit cap −50 bp: IRR 10.37%Assisted-living occupancy 87%, rates −2%, exit cap −50 bp: IRR 10.79%Assisted-living occupancy 88%, rates −2%, exit cap −50 bp: IRR 11.21%Assisted-living occupancy 89%, rates −2%, exit cap −50 bp: IRR 11.64%Assisted-living occupancy 90%, rates −2%, exit cap −50 bp: IRR 12.08%Assisted-living occupancy 91%, rates −2%, exit cap −50 bp: IRR 12.46%Assisted-living occupancy 92%, rates −2%, exit cap −50 bp: IRR 12.82%Assisted-living occupancy 93%, rates −2%, exit cap −50 bp: IRR 13.18%Assisted-living occupancy 94%, rates −2%, exit cap −50 bp: IRR 13.53%Assisted-living occupancy 95%, rates −2%, exit cap −50 bp: IRR 13.88%Assisted-living occupancy 96%, rates −2%, exit cap −50 bp: IRR 14.22%Assisted-living occupancy 97%, rates −2%, exit cap −50 bp: IRR 14.56%Assisted-living occupancy 98%, rates −2%, exit cap −50 bp: IRR 14.89%Assisted-living occupancy 99%, rates −2%, exit cap −50 bp: IRR 15.22%Assisted-living occupancy 100%, rates −2%, exit cap −50 bp: IRR 15.55%Assisted-living occupancy 86%, rates −1%, exit cap −50 bp: IRR 11.55%Assisted-living occupancy 87%, rates −1%, exit cap −50 bp: IRR 11.99%Assisted-living occupancy 88%, rates −1%, exit cap −50 bp: IRR 12.39%Assisted-living occupancy 89%, rates −1%, exit cap −50 bp: IRR 12.76%Assisted-living occupancy 90%, rates −1%, exit cap −50 bp: IRR 13.13%Assisted-living occupancy 91%, rates −1%, exit cap −50 bp: IRR 13.49%Assisted-living occupancy 92%, rates −1%, exit cap −50 bp: IRR 13.84%Assisted-living occupancy 93%, rates −1%, exit cap −50 bp: IRR 14.19%Assisted-living occupancy 94%, rates −1%, exit cap −50 bp: IRR 14.53%Assisted-living occupancy 95%, rates −1%, exit cap −50 bp: IRR 14.87%Assisted-living occupancy 96%, rates −1%, exit cap −50 bp: IRR 15.21%Assisted-living occupancy 97%, rates −1%, exit cap −50 bp: IRR 15.54%Assisted-living occupancy 98%, rates −1%, exit cap −50 bp: IRR 15.87%Assisted-living occupancy 99%, rates −1%, exit cap −50 bp: IRR 16.19%Assisted-living occupancy 100%, rates −1%, exit cap −50 bp: IRR 16.51%Assisted-living occupancy 86%, rates 0%, exit cap −50 bp: IRR 12.67%Assisted-living occupancy 87%, rates 0%, exit cap −50 bp: IRR 13.04%Assisted-living occupancy 88%, rates 0%, exit cap −50 bp: IRR 13.41%Assisted-living occupancy 89%, rates 0%, exit cap −50 bp: IRR 13.77%Assisted-living occupancy 90%, rates 0%, exit cap −50 bp: IRR 14.13%Assisted-living occupancy 91%, rates 0%, exit cap −50 bp: IRR 14.48%Assisted-living occupancy 92%, rates 0%, exit cap −50 bp: IRR 14.82%Assisted-living occupancy 93%, rates 0%, exit cap −50 bp: IRR 15.17%Assisted-living occupancy 94%, rates 0%, exit cap −50 bp: IRR 15.50%Assisted-living occupancy 95%, rates 0%, exit cap −50 bp: IRR 15.84%Assisted-living occupancy 96%, rates 0%, exit cap −50 bp: IRR 16.17%Assisted-living occupancy 97%, rates 0%, exit cap −50 bp: IRR 16.49%Assisted-living occupancy 98%, rates 0%, exit cap −50 bp: IRR 16.82%Assisted-living occupancy 99%, rates 0%, exit cap −50 bp: IRR 17.14%Assisted-living occupancy 100%, rates 0%, exit cap −50 bp: IRR 17.45%Assisted-living occupancy 86%, rates +1%, exit cap −50 bp: IRR 13.67%Assisted-living occupancy 87%, rates +1%, exit cap −50 bp: IRR 14.03%Assisted-living occupancy 88%, rates +1%, exit cap −50 bp: IRR 14.39%Assisted-living occupancy 89%, rates +1%, exit cap −50 bp: IRR 14.74%Assisted-living occupancy 90%, rates +1%, exit cap −50 bp: IRR 15.09%Assisted-living occupancy 91%, rates +1%, exit cap −50 bp: IRR 15.44%Assisted-living occupancy 92%, rates +1%, exit cap −50 bp: IRR 15.78%Assisted-living occupancy 93%, rates +1%, exit cap −50 bp: IRR 16.11%Assisted-living occupancy 94%, rates +1%, exit cap −50 bp: IRR 16.45%Assisted-living occupancy 95%, rates +1%, exit cap −50 bp: IRR 16.77%Assisted-living occupancy 96%, rates +1%, exit cap −50 bp: IRR 17.10%Assisted-living occupancy 97%, rates +1%, exit cap −50 bp: IRR 17.42%Assisted-living occupancy 98%, rates +1%, exit cap −50 bp: IRR 17.74%Assisted-living occupancy 99%, rates +1%, exit cap −50 bp: IRR 18.06%Assisted-living occupancy 100%, rates +1%, exit cap −50 bp: IRR 18.37%Assisted-living occupancy 86%, rates +2%, exit cap −50 bp: IRR 14.63%Assisted-living occupancy 87%, rates +2%, exit cap −50 bp: IRR 14.99%Assisted-living occupancy 88%, rates +2%, exit cap −50 bp: IRR 15.34%Assisted-living occupancy 89%, rates +2%, exit cap −50 bp: IRR 15.69%Assisted-living occupancy 90%, rates +2%, exit cap −50 bp: IRR 16.03%Assisted-living occupancy 91%, rates +2%, exit cap −50 bp: IRR 16.37%Assisted-living occupancy 92%, rates +2%, exit cap −50 bp: IRR 16.70%Assisted-living occupancy 93%, rates +2%, exit cap −50 bp: IRR 17.04%Assisted-living occupancy 94%, rates +2%, exit cap −50 bp: IRR 17.36%Assisted-living occupancy 95%, rates +2%, exit cap −50 bp: IRR 17.69%Assisted-living occupancy 96%, rates +2%, exit cap −50 bp: IRR 18.01%Assisted-living occupancy 97%, rates +2%, exit cap −50 bp: IRR 18.33%Assisted-living occupancy 98%, rates +2%, exit cap −50 bp: IRR 18.64%Assisted-living occupancy 99%, rates +2%, exit cap −50 bp: IRR 18.95%Assisted-living occupancy 100%, rates +2%, exit cap −50 bp: IRR 19.26%Assisted-living occupancy 86%, rates +3%, exit cap −50 bp: IRR 15.57%Assisted-living occupancy 87%, rates +3%, exit cap −50 bp: IRR 15.92%Assisted-living occupancy 88%, rates +3%, exit cap −50 bp: IRR 16.26%Assisted-living occupancy 89%, rates +3%, exit cap −50 bp: IRR 16.60%Assisted-living occupancy 90%, rates +3%, exit cap −50 bp: IRR 16.94%Assisted-living occupancy 91%, rates +3%, exit cap −50 bp: IRR 17.28%Assisted-living occupancy 92%, rates +3%, exit cap −50 bp: IRR 17.61%Assisted-living occupancy 93%, rates +3%, exit cap −50 bp: IRR 17.93%Assisted-living occupancy 94%, rates +3%, exit cap −50 bp: IRR 18.26%Assisted-living occupancy 95%, rates +3%, exit cap −50 bp: IRR 18.58%Assisted-living occupancy 96%, rates +3%, exit cap −50 bp: IRR 18.89%Assisted-living occupancy 97%, rates +3%, exit cap −50 bp: IRR 19.21%Assisted-living occupancy 98%, rates +3%, exit cap −50 bp: IRR 19.52%Assisted-living occupancy 99%, rates +3%, exit cap −50 bp: IRR 19.83%Assisted-living occupancy 100%, rates +3%, exit cap −50 bp: IRR 20.13%Assisted-living occupancy 86%, rates +4%, exit cap −50 bp: IRR 16.47%Assisted-living occupancy 87%, rates +4%, exit cap −50 bp: IRR 16.82%Assisted-living occupancy 88%, rates +4%, exit cap −50 bp: IRR 17.16%Assisted-living occupancy 89%, rates +4%, exit cap −50 bp: IRR 17.50%Assisted-living occupancy 90%, rates +4%, exit cap −50 bp: IRR 17.83%Assisted-living occupancy 91%, rates +4%, exit cap −50 bp: IRR 18.16%Assisted-living occupancy 92%, rates +4%, exit cap −50 bp: IRR 18.49%Assisted-living occupancy 93%, rates +4%, exit cap −50 bp: IRR 18.81%Assisted-living occupancy 94%, rates +4%, exit cap −50 bp: IRR 19.13%Assisted-living occupancy 95%, rates +4%, exit cap −50 bp: IRR 19.45%Assisted-living occupancy 96%, rates +4%, exit cap −50 bp: IRR 19.76%Assisted-living occupancy 97%, rates +4%, exit cap −50 bp: IRR 20.07%Assisted-living occupancy 98%, rates +4%, exit cap −50 bp: IRR 20.38%Assisted-living occupancy 99%, rates +4%, exit cap −50 bp: IRR 20.68%Assisted-living occupancy 100%, rates +4%, exit cap −50 bp: IRR 20.99%Assisted-living occupancy 86%, rates +5%, exit cap −50 bp: IRR 17.36%Assisted-living occupancy 87%, rates +5%, exit cap −50 bp: IRR 17.70%Assisted-living occupancy 88%, rates +5%, exit cap −50 bp: IRR 18.03%Assisted-living occupancy 89%, rates +5%, exit cap −50 bp: IRR 18.37%Assisted-living occupancy 90%, rates +5%, exit cap −50 bp: IRR 18.70%Assisted-living occupancy 91%, rates +5%, exit cap −50 bp: IRR 19.02%Assisted-living occupancy 92%, rates +5%, exit cap −50 bp: IRR 19.34%Assisted-living occupancy 93%, rates +5%, exit cap −50 bp: IRR 19.66%Assisted-living occupancy 94%, rates +5%, exit cap −50 bp: IRR 19.98%Assisted-living occupancy 95%, rates +5%, exit cap −50 bp: IRR 20.30%Assisted-living occupancy 96%, rates +5%, exit cap −50 bp: IRR 20.61%Assisted-living occupancy 97%, rates +5%, exit cap −50 bp: IRR 20.91%Assisted-living occupancy 98%, rates +5%, exit cap −50 bp: IRR 21.22%Assisted-living occupancy 99%, rates +5%, exit cap −50 bp: IRR 21.52%Assisted-living occupancy 100%, rates +5%, exit cap −50 bp: IRR 21.83%

Exit cap −50 bp
84 of 165 clear

Assisted-living occupancy 86%, rates −5%, exit cap −37.5 bp: IRR 6.75%Assisted-living occupancy 87%, rates −5%, exit cap −37.5 bp: IRR 7.11%Assisted-living occupancy 88%, rates −5%, exit cap −37.5 bp: IRR 7.48%Assisted-living occupancy 89%, rates −5%, exit cap −37.5 bp: IRR 7.85%Assisted-living occupancy 90%, rates −5%, exit cap −37.5 bp: IRR 8.22%Assisted-living occupancy 91%, rates −5%, exit cap −37.5 bp: IRR 8.59%Assisted-living occupancy 92%, rates −5%, exit cap −37.5 bp: IRR 8.97%Assisted-living occupancy 93%, rates −5%, exit cap −37.5 bp: IRR 9.36%Assisted-living occupancy 94%, rates −5%, exit cap −37.5 bp: IRR 9.75%Assisted-living occupancy 95%, rates −5%, exit cap −37.5 bp: IRR 10.14%Assisted-living occupancy 96%, rates −5%, exit cap −37.5 bp: IRR 10.54%Assisted-living occupancy 97%, rates −5%, exit cap −37.5 bp: IRR 10.94%Assisted-living occupancy 98%, rates −5%, exit cap −37.5 bp: IRR 11.35%Assisted-living occupancy 99%, rates −5%, exit cap −37.5 bp: IRR 11.77%Assisted-living occupancy 100%, rates −5%, exit cap −37.5 bp: IRR 12.12%Assisted-living occupancy 86%, rates −4%, exit cap −37.5 bp: IRR 7.81%Assisted-living occupancy 87%, rates −4%, exit cap −37.5 bp: IRR 8.19%Assisted-living occupancy 88%, rates −4%, exit cap −37.5 bp: IRR 8.57%Assisted-living occupancy 89%, rates −4%, exit cap −37.5 bp: IRR 8.96%Assisted-living occupancy 90%, rates −4%, exit cap −37.5 bp: IRR 9.35%Assisted-living occupancy 91%, rates −4%, exit cap −37.5 bp: IRR 9.74%Assisted-living occupancy 92%, rates −4%, exit cap −37.5 bp: IRR 10.14%Assisted-living occupancy 93%, rates −4%, exit cap −37.5 bp: IRR 10.55%Assisted-living occupancy 94%, rates −4%, exit cap −37.5 bp: IRR 10.96%Assisted-living occupancy 95%, rates −4%, exit cap −37.5 bp: IRR 11.38%Assisted-living occupancy 96%, rates −4%, exit cap −37.5 bp: IRR 11.80%Assisted-living occupancy 97%, rates −4%, exit cap −37.5 bp: IRR 12.15%Assisted-living occupancy 98%, rates −4%, exit cap −37.5 bp: IRR 12.51%Assisted-living occupancy 99%, rates −4%, exit cap −37.5 bp: IRR 12.85%Assisted-living occupancy 100%, rates −4%, exit cap −37.5 bp: IRR 13.20%Assisted-living occupancy 86%, rates −3%, exit cap −37.5 bp: IRR 8.90%Assisted-living occupancy 87%, rates −3%, exit cap −37.5 bp: IRR 9.30%Assisted-living occupancy 88%, rates −3%, exit cap −37.5 bp: IRR 9.70%Assisted-living occupancy 89%, rates −3%, exit cap −37.5 bp: IRR 10.11%Assisted-living occupancy 90%, rates −3%, exit cap −37.5 bp: IRR 10.52%Assisted-living occupancy 91%, rates −3%, exit cap −37.5 bp: IRR 10.94%Assisted-living occupancy 92%, rates −3%, exit cap −37.5 bp: IRR 11.36%Assisted-living occupancy 93%, rates −3%, exit cap −37.5 bp: IRR 11.79%Assisted-living occupancy 94%, rates −3%, exit cap −37.5 bp: IRR 12.16%Assisted-living occupancy 95%, rates −3%, exit cap −37.5 bp: IRR 12.52%Assisted-living occupancy 96%, rates −3%, exit cap −37.5 bp: IRR 12.87%Assisted-living occupancy 97%, rates −3%, exit cap −37.5 bp: IRR 13.22%Assisted-living occupancy 98%, rates −3%, exit cap −37.5 bp: IRR 13.56%Assisted-living occupancy 99%, rates −3%, exit cap −37.5 bp: IRR 13.90%Assisted-living occupancy 100%, rates −3%, exit cap −37.5 bp: IRR 14.24%Assisted-living occupancy 86%, rates −2%, exit cap −37.5 bp: IRR 10.04%Assisted-living occupancy 87%, rates −2%, exit cap −37.5 bp: IRR 10.46%Assisted-living occupancy 88%, rates −2%, exit cap −37.5 bp: IRR 10.88%Assisted-living occupancy 89%, rates −2%, exit cap −37.5 bp: IRR 11.31%Assisted-living occupancy 90%, rates −2%, exit cap −37.5 bp: IRR 11.75%Assisted-living occupancy 91%, rates −2%, exit cap −37.5 bp: IRR 12.13%Assisted-living occupancy 92%, rates −2%, exit cap −37.5 bp: IRR 12.49%Assisted-living occupancy 93%, rates −2%, exit cap −37.5 bp: IRR 12.85%Assisted-living occupancy 94%, rates −2%, exit cap −37.5 bp: IRR 13.21%Assisted-living occupancy 95%, rates −2%, exit cap −37.5 bp: IRR 13.56%Assisted-living occupancy 96%, rates −2%, exit cap −37.5 bp: IRR 13.90%Assisted-living occupancy 97%, rates −2%, exit cap −37.5 bp: IRR 14.24%Assisted-living occupancy 98%, rates −2%, exit cap −37.5 bp: IRR 14.58%Assisted-living occupancy 99%, rates −2%, exit cap −37.5 bp: IRR 14.91%Assisted-living occupancy 100%, rates −2%, exit cap −37.5 bp: IRR 15.24%Assisted-living occupancy 86%, rates −1%, exit cap −37.5 bp: IRR 11.22%Assisted-living occupancy 87%, rates −1%, exit cap −37.5 bp: IRR 11.66%Assisted-living occupancy 88%, rates −1%, exit cap −37.5 bp: IRR 12.06%Assisted-living occupancy 89%, rates −1%, exit cap −37.5 bp: IRR 12.43%Assisted-living occupancy 90%, rates −1%, exit cap −37.5 bp: IRR 12.80%Assisted-living occupancy 91%, rates −1%, exit cap −37.5 bp: IRR 13.16%Assisted-living occupancy 92%, rates −1%, exit cap −37.5 bp: IRR 13.52%Assisted-living occupancy 93%, rates −1%, exit cap −37.5 bp: IRR 13.87%Assisted-living occupancy 94%, rates −1%, exit cap −37.5 bp: IRR 14.22%Assisted-living occupancy 95%, rates −1%, exit cap −37.5 bp: IRR 14.56%Assisted-living occupancy 96%, rates −1%, exit cap −37.5 bp: IRR 14.90%Assisted-living occupancy 97%, rates −1%, exit cap −37.5 bp: IRR 15.24%Assisted-living occupancy 98%, rates −1%, exit cap −37.5 bp: IRR 15.57%Assisted-living occupancy 99%, rates −1%, exit cap −37.5 bp: IRR 15.89%Assisted-living occupancy 100%, rates −1%, exit cap −37.5 bp: IRR 16.22%Assisted-living occupancy 86%, rates 0%, exit cap −37.5 bp: IRR 12.34%Assisted-living occupancy 87%, rates 0%, exit cap −37.5 bp: IRR 12.72%Assisted-living occupancy 88%, rates 0%, exit cap −37.5 bp: IRR 13.09%Assisted-living occupancy 89%, rates 0%, exit cap −37.5 bp: IRR 13.45%Assisted-living occupancy 90%, rates 0%, exit cap −37.5 bp: IRR 13.81%Assisted-living occupancy 91%, rates 0%, exit cap −37.5 bp: IRR 14.16%Assisted-living occupancy 92%, rates 0%, exit cap −37.5 bp: IRR 14.51%Assisted-living occupancy 93%, rates 0%, exit cap −37.5 bp: IRR 14.86%Assisted-living occupancy 94%, rates 0%, exit cap −37.5 bp: IRR 15.20%Assisted-living occupancy 95%, rates 0%, exit cap −37.5 bp: IRR 15.54%Assisted-living occupancy 96%, rates 0%, exit cap −37.5 bp: IRR 15.87%Assisted-living occupancy 97%, rates 0%, exit cap −37.5 bp: IRR 16.20%Assisted-living occupancy 98%, rates 0%, exit cap −37.5 bp: IRR 16.52%Assisted-living occupancy 99%, rates 0%, exit cap −37.5 bp: IRR 16.84%Assisted-living occupancy 100%, rates 0%, exit cap −37.5 bp: IRR 17.16%Assisted-living occupancy 86%, rates +1%, exit cap −37.5 bp: IRR 13.35%Assisted-living occupancy 87%, rates +1%, exit cap −37.5 bp: IRR 13.71%Assisted-living occupancy 88%, rates +1%, exit cap −37.5 bp: IRR 14.08%Assisted-living occupancy 89%, rates +1%, exit cap −37.5 bp: IRR 14.43%Assisted-living occupancy 90%, rates +1%, exit cap −37.5 bp: IRR 14.78%Assisted-living occupancy 91%, rates +1%, exit cap −37.5 bp: IRR 15.13%Assisted-living occupancy 92%, rates +1%, exit cap −37.5 bp: IRR 15.47%Assisted-living occupancy 93%, rates +1%, exit cap −37.5 bp: IRR 15.81%Assisted-living occupancy 94%, rates +1%, exit cap −37.5 bp: IRR 16.15%Assisted-living occupancy 95%, rates +1%, exit cap −37.5 bp: IRR 16.48%Assisted-living occupancy 96%, rates +1%, exit cap −37.5 bp: IRR 16.81%Assisted-living occupancy 97%, rates +1%, exit cap −37.5 bp: IRR 17.13%Assisted-living occupancy 98%, rates +1%, exit cap −37.5 bp: IRR 17.45%Assisted-living occupancy 99%, rates +1%, exit cap −37.5 bp: IRR 17.77%Assisted-living occupancy 100%, rates +1%, exit cap −37.5 bp: IRR 18.08%Assisted-living occupancy 86%, rates +2%, exit cap −37.5 bp: IRR 14.32%Assisted-living occupancy 87%, rates +2%, exit cap −37.5 bp: IRR 14.68%Assisted-living occupancy 88%, rates +2%, exit cap −37.5 bp: IRR 15.03%Assisted-living occupancy 89%, rates +2%, exit cap −37.5 bp: IRR 15.38%Assisted-living occupancy 90%, rates +2%, exit cap −37.5 bp: IRR 15.73%Assisted-living occupancy 91%, rates +2%, exit cap −37.5 bp: IRR 16.07%Assisted-living occupancy 92%, rates +2%, exit cap −37.5 bp: IRR 16.41%Assisted-living occupancy 93%, rates +2%, exit cap −37.5 bp: IRR 16.74%Assisted-living occupancy 94%, rates +2%, exit cap −37.5 bp: IRR 17.07%Assisted-living occupancy 95%, rates +2%, exit cap −37.5 bp: IRR 17.40%Assisted-living occupancy 96%, rates +2%, exit cap −37.5 bp: IRR 17.72%Assisted-living occupancy 97%, rates +2%, exit cap −37.5 bp: IRR 18.04%Assisted-living occupancy 98%, rates +2%, exit cap −37.5 bp: IRR 18.36%Assisted-living occupancy 99%, rates +2%, exit cap −37.5 bp: IRR 18.67%Assisted-living occupancy 100%, rates +2%, exit cap −37.5 bp: IRR 18.98%Assisted-living occupancy 86%, rates +3%, exit cap −37.5 bp: IRR 15.26%Assisted-living occupancy 87%, rates +3%, exit cap −37.5 bp: IRR 15.61%Assisted-living occupancy 88%, rates +3%, exit cap −37.5 bp: IRR 15.96%Assisted-living occupancy 89%, rates +3%, exit cap −37.5 bp: IRR 16.31%Assisted-living occupancy 90%, rates +3%, exit cap −37.5 bp: IRR 16.65%Assisted-living occupancy 91%, rates +3%, exit cap −37.5 bp: IRR 16.98%Assisted-living occupancy 92%, rates +3%, exit cap −37.5 bp: IRR 17.32%Assisted-living occupancy 93%, rates +3%, exit cap −37.5 bp: IRR 17.65%Assisted-living occupancy 94%, rates +3%, exit cap −37.5 bp: IRR 17.97%Assisted-living occupancy 95%, rates +3%, exit cap −37.5 bp: IRR 18.29%Assisted-living occupancy 96%, rates +3%, exit cap −37.5 bp: IRR 18.61%Assisted-living occupancy 97%, rates +3%, exit cap −37.5 bp: IRR 18.93%Assisted-living occupancy 98%, rates +3%, exit cap −37.5 bp: IRR 19.24%Assisted-living occupancy 99%, rates +3%, exit cap −37.5 bp: IRR 19.55%Assisted-living occupancy 100%, rates +3%, exit cap −37.5 bp: IRR 19.86%Assisted-living occupancy 86%, rates +4%, exit cap −37.5 bp: IRR 16.17%Assisted-living occupancy 87%, rates +4%, exit cap −37.5 bp: IRR 16.52%Assisted-living occupancy 88%, rates +4%, exit cap −37.5 bp: IRR 16.87%Assisted-living occupancy 89%, rates +4%, exit cap −37.5 bp: IRR 17.21%Assisted-living occupancy 90%, rates +4%, exit cap −37.5 bp: IRR 17.54%Assisted-living occupancy 91%, rates +4%, exit cap −37.5 bp: IRR 17.87%Assisted-living occupancy 92%, rates +4%, exit cap −37.5 bp: IRR 18.20%Assisted-living occupancy 93%, rates +4%, exit cap −37.5 bp: IRR 18.53%Assisted-living occupancy 94%, rates +4%, exit cap −37.5 bp: IRR 18.85%Assisted-living occupancy 95%, rates +4%, exit cap −37.5 bp: IRR 19.17%Assisted-living occupancy 96%, rates +4%, exit cap −37.5 bp: IRR 19.48%Assisted-living occupancy 97%, rates +4%, exit cap −37.5 bp: IRR 19.80%Assisted-living occupancy 98%, rates +4%, exit cap −37.5 bp: IRR 20.11%Assisted-living occupancy 99%, rates +4%, exit cap −37.5 bp: IRR 20.42%Assisted-living occupancy 100%, rates +4%, exit cap −37.5 bp: IRR 20.72%Assisted-living occupancy 86%, rates +5%, exit cap −37.5 bp: IRR 17.06%Assisted-living occupancy 87%, rates +5%, exit cap −37.5 bp: IRR 17.41%Assisted-living occupancy 88%, rates +5%, exit cap −37.5 bp: IRR 17.75%Assisted-living occupancy 89%, rates +5%, exit cap −37.5 bp: IRR 18.08%Assisted-living occupancy 90%, rates +5%, exit cap −37.5 bp: IRR 18.41%Assisted-living occupancy 91%, rates +5%, exit cap −37.5 bp: IRR 18.74%Assisted-living occupancy 92%, rates +5%, exit cap −37.5 bp: IRR 19.07%Assisted-living occupancy 93%, rates +5%, exit cap −37.5 bp: IRR 19.39%Assisted-living occupancy 94%, rates +5%, exit cap −37.5 bp: IRR 19.71%Assisted-living occupancy 95%, rates +5%, exit cap −37.5 bp: IRR 20.02%Assisted-living occupancy 96%, rates +5%, exit cap −37.5 bp: IRR 20.34%Assisted-living occupancy 97%, rates +5%, exit cap −37.5 bp: IRR 20.65%Assisted-living occupancy 98%, rates +5%, exit cap −37.5 bp: IRR 20.95%Assisted-living occupancy 99%, rates +5%, exit cap −37.5 bp: IRR 21.26%Assisted-living occupancy 100%, rates +5%, exit cap −37.5 bp: IRR 21.56%

Exit cap −37.5 bp
80 of 165 clear

Assisted-living occupancy 86%, rates −5%, exit cap −25 bp: IRR 6.43%Assisted-living occupancy 87%, rates −5%, exit cap −25 bp: IRR 6.79%Assisted-living occupancy 88%, rates −5%, exit cap −25 bp: IRR 7.15%Assisted-living occupancy 89%, rates −5%, exit cap −25 bp: IRR 7.52%Assisted-living occupancy 90%, rates −5%, exit cap −25 bp: IRR 7.89%Assisted-living occupancy 91%, rates −5%, exit cap −25 bp: IRR 8.27%Assisted-living occupancy 92%, rates −5%, exit cap −25 bp: IRR 8.65%Assisted-living occupancy 93%, rates −5%, exit cap −25 bp: IRR 9.03%Assisted-living occupancy 94%, rates −5%, exit cap −25 bp: IRR 9.42%Assisted-living occupancy 95%, rates −5%, exit cap −25 bp: IRR 9.81%Assisted-living occupancy 96%, rates −5%, exit cap −25 bp: IRR 10.21%Assisted-living occupancy 97%, rates −5%, exit cap −25 bp: IRR 10.61%Assisted-living occupancy 98%, rates −5%, exit cap −25 bp: IRR 11.02%Assisted-living occupancy 99%, rates −5%, exit cap −25 bp: IRR 11.44%Assisted-living occupancy 100%, rates −5%, exit cap −25 bp: IRR 11.79%Assisted-living occupancy 86%, rates −4%, exit cap −25 bp: IRR 7.49%Assisted-living occupancy 87%, rates −4%, exit cap −25 bp: IRR 7.86%Assisted-living occupancy 88%, rates −4%, exit cap −25 bp: IRR 8.25%Assisted-living occupancy 89%, rates −4%, exit cap −25 bp: IRR 8.63%Assisted-living occupancy 90%, rates −4%, exit cap −25 bp: IRR 9.02%Assisted-living occupancy 91%, rates −4%, exit cap −25 bp: IRR 9.42%Assisted-living occupancy 92%, rates −4%, exit cap −25 bp: IRR 9.82%Assisted-living occupancy 93%, rates −4%, exit cap −25 bp: IRR 10.22%Assisted-living occupancy 94%, rates −4%, exit cap −25 bp: IRR 10.63%Assisted-living occupancy 95%, rates −4%, exit cap −25 bp: IRR 11.05%Assisted-living occupancy 96%, rates −4%, exit cap −25 bp: IRR 11.47%Assisted-living occupancy 97%, rates −4%, exit cap −25 bp: IRR 11.83%Assisted-living occupancy 98%, rates −4%, exit cap −25 bp: IRR 12.18%Assisted-living occupancy 99%, rates −4%, exit cap −25 bp: IRR 12.54%Assisted-living occupancy 100%, rates −4%, exit cap −25 bp: IRR 12.88%Assisted-living occupancy 86%, rates −3%, exit cap −25 bp: IRR 8.58%Assisted-living occupancy 87%, rates −3%, exit cap −25 bp: IRR 8.97%Assisted-living occupancy 88%, rates −3%, exit cap −25 bp: IRR 9.38%Assisted-living occupancy 89%, rates −3%, exit cap −25 bp: IRR 9.78%Assisted-living occupancy 90%, rates −3%, exit cap −25 bp: IRR 10.19%Assisted-living occupancy 91%, rates −3%, exit cap −25 bp: IRR 10.61%Assisted-living occupancy 92%, rates −3%, exit cap −25 bp: IRR 11.04%Assisted-living occupancy 93%, rates −3%, exit cap −25 bp: IRR 11.46%Assisted-living occupancy 94%, rates −3%, exit cap −25 bp: IRR 11.83%Assisted-living occupancy 95%, rates −3%, exit cap −25 bp: IRR 12.19%Assisted-living occupancy 96%, rates −3%, exit cap −25 bp: IRR 12.55%Assisted-living occupancy 97%, rates −3%, exit cap −25 bp: IRR 12.90%Assisted-living occupancy 98%, rates −3%, exit cap −25 bp: IRR 13.25%Assisted-living occupancy 99%, rates −3%, exit cap −25 bp: IRR 13.59%Assisted-living occupancy 100%, rates −3%, exit cap −25 bp: IRR 13.93%Assisted-living occupancy 86%, rates −2%, exit cap −25 bp: IRR 9.71%Assisted-living occupancy 87%, rates −2%, exit cap −25 bp: IRR 10.13%Assisted-living occupancy 88%, rates −2%, exit cap −25 bp: IRR 10.55%Assisted-living occupancy 89%, rates −2%, exit cap −25 bp: IRR 10.98%Assisted-living occupancy 90%, rates −2%, exit cap −25 bp: IRR 11.42%Assisted-living occupancy 91%, rates −2%, exit cap −25 bp: IRR 11.80%Assisted-living occupancy 92%, rates −2%, exit cap −25 bp: IRR 12.17%Assisted-living occupancy 93%, rates −2%, exit cap −25 bp: IRR 12.53%Assisted-living occupancy 94%, rates −2%, exit cap −25 bp: IRR 12.89%Assisted-living occupancy 95%, rates −2%, exit cap −25 bp: IRR 13.24%Assisted-living occupancy 96%, rates −2%, exit cap −25 bp: IRR 13.59%Assisted-living occupancy 97%, rates −2%, exit cap −25 bp: IRR 13.94%Assisted-living occupancy 98%, rates −2%, exit cap −25 bp: IRR 14.28%Assisted-living occupancy 99%, rates −2%, exit cap −25 bp: IRR 14.61%Assisted-living occupancy 100%, rates −2%, exit cap −25 bp: IRR 14.94%Assisted-living occupancy 86%, rates −1%, exit cap −25 bp: IRR 10.89%Assisted-living occupancy 87%, rates −1%, exit cap −25 bp: IRR 11.33%Assisted-living occupancy 88%, rates −1%, exit cap −25 bp: IRR 11.73%Assisted-living occupancy 89%, rates −1%, exit cap −25 bp: IRR 12.11%Assisted-living occupancy 90%, rates −1%, exit cap −25 bp: IRR 12.48%Assisted-living occupancy 91%, rates −1%, exit cap −25 bp: IRR 12.85%Assisted-living occupancy 92%, rates −1%, exit cap −25 bp: IRR 13.21%Assisted-living occupancy 93%, rates −1%, exit cap −25 bp: IRR 13.56%Assisted-living occupancy 94%, rates −1%, exit cap −25 bp: IRR 13.91%Assisted-living occupancy 95%, rates −1%, exit cap −25 bp: IRR 14.26%Assisted-living occupancy 96%, rates −1%, exit cap −25 bp: IRR 14.60%Assisted-living occupancy 97%, rates −1%, exit cap −25 bp: IRR 14.94%Assisted-living occupancy 98%, rates −1%, exit cap −25 bp: IRR 15.27%Assisted-living occupancy 99%, rates −1%, exit cap −25 bp: IRR 15.60%Assisted-living occupancy 100%, rates −1%, exit cap −25 bp: IRR 15.93%Assisted-living occupancy 86%, rates 0%, exit cap −25 bp: IRR 12.02%Assisted-living occupancy 87%, rates 0%, exit cap −25 bp: IRR 12.40%Assisted-living occupancy 88%, rates 0%, exit cap −25 bp: IRR 12.77%Assisted-living occupancy 89%, rates 0%, exit cap −25 bp: IRR 13.14%Assisted-living occupancy 90%, rates 0%, exit cap −25 bp: IRR 13.50%Assisted-living occupancy 91%, rates 0%, exit cap −25 bp: IRR 13.85%Assisted-living occupancy 92%, rates 0%, exit cap −25 bp: IRR 14.21%Assisted-living occupancy 93%, rates 0%, exit cap −25 bp: IRR 14.56%Assisted-living occupancy 94%, rates 0%, exit cap −25 bp: IRR 14.90%Assisted-living occupancy 95%, rates 0%, exit cap −25 bp: IRR 15.24%Assisted-living occupancy 96%, rates 0%, exit cap −25 bp: IRR 15.57%Assisted-living occupancy 97%, rates 0%, exit cap −25 bp: IRR 15.91%Assisted-living occupancy 98%, rates 0%, exit cap −25 bp: IRR 16.23%Assisted-living occupancy 99%, rates 0%, exit cap −25 bp: IRR 16.56%Assisted-living occupancy 100%, rates 0%, exit cap −25 bp: IRR 16.88%Assisted-living occupancy 86%, rates +1%, exit cap −25 bp: IRR 13.03%Assisted-living occupancy 87%, rates +1%, exit cap −25 bp: IRR 13.40%Assisted-living occupancy 88%, rates +1%, exit cap −25 bp: IRR 13.77%Assisted-living occupancy 89%, rates +1%, exit cap −25 bp: IRR 14.13%Assisted-living occupancy 90%, rates +1%, exit cap −25 bp: IRR 14.48%Assisted-living occupancy 91%, rates +1%, exit cap −25 bp: IRR 14.83%Assisted-living occupancy 92%, rates +1%, exit cap −25 bp: IRR 15.18%Assisted-living occupancy 93%, rates +1%, exit cap −25 bp: IRR 15.52%Assisted-living occupancy 94%, rates +1%, exit cap −25 bp: IRR 15.86%Assisted-living occupancy 95%, rates +1%, exit cap −25 bp: IRR 16.19%Assisted-living occupancy 96%, rates +1%, exit cap −25 bp: IRR 16.52%Assisted-living occupancy 97%, rates +1%, exit cap −25 bp: IRR 16.85%Assisted-living occupancy 98%, rates +1%, exit cap −25 bp: IRR 17.17%Assisted-living occupancy 99%, rates +1%, exit cap −25 bp: IRR 17.49%Assisted-living occupancy 100%, rates +1%, exit cap −25 bp: IRR 17.81%Assisted-living occupancy 86%, rates +2%, exit cap −25 bp: IRR 14.01%Assisted-living occupancy 87%, rates +2%, exit cap −25 bp: IRR 14.37%Assisted-living occupancy 88%, rates +2%, exit cap −25 bp: IRR 14.73%Assisted-living occupancy 89%, rates +2%, exit cap −25 bp: IRR 15.08%Assisted-living occupancy 90%, rates +2%, exit cap −25 bp: IRR 15.43%Assisted-living occupancy 91%, rates +2%, exit cap −25 bp: IRR 15.78%Assisted-living occupancy 92%, rates +2%, exit cap −25 bp: IRR 16.12%Assisted-living occupancy 93%, rates +2%, exit cap −25 bp: IRR 16.45%Assisted-living occupancy 94%, rates +2%, exit cap −25 bp: IRR 16.79%Assisted-living occupancy 95%, rates +2%, exit cap −25 bp: IRR 17.12%Assisted-living occupancy 96%, rates +2%, exit cap −25 bp: IRR 17.44%Assisted-living occupancy 97%, rates +2%, exit cap −25 bp: IRR 17.76%Assisted-living occupancy 98%, rates +2%, exit cap −25 bp: IRR 18.08%Assisted-living occupancy 99%, rates +2%, exit cap −25 bp: IRR 18.40%Assisted-living occupancy 100%, rates +2%, exit cap −25 bp: IRR 18.71%Assisted-living occupancy 86%, rates +3%, exit cap −25 bp: IRR 14.96%Assisted-living occupancy 87%, rates +3%, exit cap −25 bp: IRR 15.32%Assisted-living occupancy 88%, rates +3%, exit cap −25 bp: IRR 15.67%Assisted-living occupancy 89%, rates +3%, exit cap −25 bp: IRR 16.01%Assisted-living occupancy 90%, rates +3%, exit cap −25 bp: IRR 16.36%Assisted-living occupancy 91%, rates +3%, exit cap −25 bp: IRR 16.70%Assisted-living occupancy 92%, rates +3%, exit cap −25 bp: IRR 17.03%Assisted-living occupancy 93%, rates +3%, exit cap −25 bp: IRR 17.36%Assisted-living occupancy 94%, rates +3%, exit cap −25 bp: IRR 17.69%Assisted-living occupancy 95%, rates +3%, exit cap −25 bp: IRR 18.02%Assisted-living occupancy 96%, rates +3%, exit cap −25 bp: IRR 18.34%Assisted-living occupancy 97%, rates +3%, exit cap −25 bp: IRR 18.66%Assisted-living occupancy 98%, rates +3%, exit cap −25 bp: IRR 18.97%Assisted-living occupancy 99%, rates +3%, exit cap −25 bp: IRR 19.28%Assisted-living occupancy 100%, rates +3%, exit cap −25 bp: IRR 19.59%Assisted-living occupancy 86%, rates +4%, exit cap −25 bp: IRR 15.88%Assisted-living occupancy 87%, rates +4%, exit cap −25 bp: IRR 16.23%Assisted-living occupancy 88%, rates +4%, exit cap −25 bp: IRR 16.58%Assisted-living occupancy 89%, rates +4%, exit cap −25 bp: IRR 16.92%Assisted-living occupancy 90%, rates +4%, exit cap −25 bp: IRR 17.26%Assisted-living occupancy 91%, rates +4%, exit cap −25 bp: IRR 17.59%Assisted-living occupancy 92%, rates +4%, exit cap −25 bp: IRR 17.92%Assisted-living occupancy 93%, rates +4%, exit cap −25 bp: IRR 18.25%Assisted-living occupancy 94%, rates +4%, exit cap −25 bp: IRR 18.58%Assisted-living occupancy 95%, rates +4%, exit cap −25 bp: IRR 18.90%Assisted-living occupancy 96%, rates +4%, exit cap −25 bp: IRR 19.21%Assisted-living occupancy 97%, rates +4%, exit cap −25 bp: IRR 19.53%Assisted-living occupancy 98%, rates +4%, exit cap −25 bp: IRR 19.84%Assisted-living occupancy 99%, rates +4%, exit cap −25 bp: IRR 20.15%Assisted-living occupancy 100%, rates +4%, exit cap −25 bp: IRR 20.46%Assisted-living occupancy 86%, rates +5%, exit cap −25 bp: IRR 16.78%Assisted-living occupancy 87%, rates +5%, exit cap −25 bp: IRR 17.12%Assisted-living occupancy 88%, rates +5%, exit cap −25 bp: IRR 17.46%Assisted-living occupancy 89%, rates +5%, exit cap −25 bp: IRR 17.80%Assisted-living occupancy 90%, rates +5%, exit cap −25 bp: IRR 18.14%Assisted-living occupancy 91%, rates +5%, exit cap −25 bp: IRR 18.47%Assisted-living occupancy 92%, rates +5%, exit cap −25 bp: IRR 18.79%Assisted-living occupancy 93%, rates +5%, exit cap −25 bp: IRR 19.12%Assisted-living occupancy 94%, rates +5%, exit cap −25 bp: IRR 19.44%Assisted-living occupancy 95%, rates +5%, exit cap −25 bp: IRR 19.76%Assisted-living occupancy 96%, rates +5%, exit cap −25 bp: IRR 20.07%Assisted-living occupancy 97%, rates +5%, exit cap −25 bp: IRR 20.38%Assisted-living occupancy 98%, rates +5%, exit cap −25 bp: IRR 20.69%Assisted-living occupancy 99%, rates +5%, exit cap −25 bp: IRR 21.00%Assisted-living occupancy 100%, rates +5%, exit cap −25 bp: IRR 21.31%

Exit cap −25 bp
74 of 165 clear

Assisted-living occupancy 86%, rates −5%, exit cap −12.5 bp: IRR 6.11%Assisted-living occupancy 87%, rates −5%, exit cap −12.5 bp: IRR 6.47%Assisted-living occupancy 88%, rates −5%, exit cap −12.5 bp: IRR 6.83%Assisted-living occupancy 89%, rates −5%, exit cap −12.5 bp: IRR 7.20%Assisted-living occupancy 90%, rates −5%, exit cap −12.5 bp: IRR 7.57%Assisted-living occupancy 91%, rates −5%, exit cap −12.5 bp: IRR 7.95%Assisted-living occupancy 92%, rates −5%, exit cap −12.5 bp: IRR 8.32%Assisted-living occupancy 93%, rates −5%, exit cap −12.5 bp: IRR 8.71%Assisted-living occupancy 94%, rates −5%, exit cap −12.5 bp: IRR 9.10%Assisted-living occupancy 95%, rates −5%, exit cap −12.5 bp: IRR 9.49%Assisted-living occupancy 96%, rates −5%, exit cap −12.5 bp: IRR 9.89%Assisted-living occupancy 97%, rates −5%, exit cap −12.5 bp: IRR 10.29%Assisted-living occupancy 98%, rates −5%, exit cap −12.5 bp: IRR 10.70%Assisted-living occupancy 99%, rates −5%, exit cap −12.5 bp: IRR 11.11%Assisted-living occupancy 100%, rates −5%, exit cap −12.5 bp: IRR 11.47%Assisted-living occupancy 86%, rates −4%, exit cap −12.5 bp: IRR 7.17%Assisted-living occupancy 87%, rates −4%, exit cap −12.5 bp: IRR 7.54%Assisted-living occupancy 88%, rates −4%, exit cap −12.5 bp: IRR 7.92%Assisted-living occupancy 89%, rates −4%, exit cap −12.5 bp: IRR 8.31%Assisted-living occupancy 90%, rates −4%, exit cap −12.5 bp: IRR 8.70%Assisted-living occupancy 91%, rates −4%, exit cap −12.5 bp: IRR 9.09%Assisted-living occupancy 92%, rates −4%, exit cap −12.5 bp: IRR 9.49%Assisted-living occupancy 93%, rates −4%, exit cap −12.5 bp: IRR 9.90%Assisted-living occupancy 94%, rates −4%, exit cap −12.5 bp: IRR 10.31%Assisted-living occupancy 95%, rates −4%, exit cap −12.5 bp: IRR 10.72%Assisted-living occupancy 96%, rates −4%, exit cap −12.5 bp: IRR 11.14%Assisted-living occupancy 97%, rates −4%, exit cap −12.5 bp: IRR 11.51%Assisted-living occupancy 98%, rates −4%, exit cap −12.5 bp: IRR 11.87%Assisted-living occupancy 99%, rates −4%, exit cap −12.5 bp: IRR 12.22%Assisted-living occupancy 100%, rates −4%, exit cap −12.5 bp: IRR 12.57%Assisted-living occupancy 86%, rates −3%, exit cap −12.5 bp: IRR 8.26%Assisted-living occupancy 87%, rates −3%, exit cap −12.5 bp: IRR 8.65%Assisted-living occupancy 88%, rates −3%, exit cap −12.5 bp: IRR 9.05%Assisted-living occupancy 89%, rates −3%, exit cap −12.5 bp: IRR 9.46%Assisted-living occupancy 90%, rates −3%, exit cap −12.5 bp: IRR 9.87%Assisted-living occupancy 91%, rates −3%, exit cap −12.5 bp: IRR 10.29%Assisted-living occupancy 92%, rates −3%, exit cap −12.5 bp: IRR 10.71%Assisted-living occupancy 93%, rates −3%, exit cap −12.5 bp: IRR 11.14%Assisted-living occupancy 94%, rates −3%, exit cap −12.5 bp: IRR 11.51%Assisted-living occupancy 95%, rates −3%, exit cap −12.5 bp: IRR 11.87%Assisted-living occupancy 96%, rates −3%, exit cap −12.5 bp: IRR 12.23%Assisted-living occupancy 97%, rates −3%, exit cap −12.5 bp: IRR 12.59%Assisted-living occupancy 98%, rates −3%, exit cap −12.5 bp: IRR 12.94%Assisted-living occupancy 99%, rates −3%, exit cap −12.5 bp: IRR 13.29%Assisted-living occupancy 100%, rates −3%, exit cap −12.5 bp: IRR 13.63%Assisted-living occupancy 86%, rates −2%, exit cap −12.5 bp: IRR 9.39%Assisted-living occupancy 87%, rates −2%, exit cap −12.5 bp: IRR 9.80%Assisted-living occupancy 88%, rates −2%, exit cap −12.5 bp: IRR 10.23%Assisted-living occupancy 89%, rates −2%, exit cap −12.5 bp: IRR 10.65%Assisted-living occupancy 90%, rates −2%, exit cap −12.5 bp: IRR 11.09%Assisted-living occupancy 91%, rates −2%, exit cap −12.5 bp: IRR 11.48%Assisted-living occupancy 92%, rates −2%, exit cap −12.5 bp: IRR 11.85%Assisted-living occupancy 93%, rates −2%, exit cap −12.5 bp: IRR 12.22%Assisted-living occupancy 94%, rates −2%, exit cap −12.5 bp: IRR 12.58%Assisted-living occupancy 95%, rates −2%, exit cap −12.5 bp: IRR 12.93%Assisted-living occupancy 96%, rates −2%, exit cap −12.5 bp: IRR 13.29%Assisted-living occupancy 97%, rates −2%, exit cap −12.5 bp: IRR 13.63%Assisted-living occupancy 98%, rates −2%, exit cap −12.5 bp: IRR 13.98%Assisted-living occupancy 99%, rates −2%, exit cap −12.5 bp: IRR 14.31%Assisted-living occupancy 100%, rates −2%, exit cap −12.5 bp: IRR 14.65%Assisted-living occupancy 86%, rates −1%, exit cap −12.5 bp: IRR 10.56%Assisted-living occupancy 87%, rates −1%, exit cap −12.5 bp: IRR 11.00%Assisted-living occupancy 88%, rates −1%, exit cap −12.5 bp: IRR 11.41%Assisted-living occupancy 89%, rates −1%, exit cap −12.5 bp: IRR 11.79%Assisted-living occupancy 90%, rates −1%, exit cap −12.5 bp: IRR 12.16%Assisted-living occupancy 91%, rates −1%, exit cap −12.5 bp: IRR 12.53%Assisted-living occupancy 92%, rates −1%, exit cap −12.5 bp: IRR 12.90%Assisted-living occupancy 93%, rates −1%, exit cap −12.5 bp: IRR 13.25%Assisted-living occupancy 94%, rates −1%, exit cap −12.5 bp: IRR 13.61%Assisted-living occupancy 95%, rates −1%, exit cap −12.5 bp: IRR 13.96%Assisted-living occupancy 96%, rates −1%, exit cap −12.5 bp: IRR 14.30%Assisted-living occupancy 97%, rates −1%, exit cap −12.5 bp: IRR 14.64%Assisted-living occupancy 98%, rates −1%, exit cap −12.5 bp: IRR 14.98%Assisted-living occupancy 99%, rates −1%, exit cap −12.5 bp: IRR 15.31%Assisted-living occupancy 100%, rates −1%, exit cap −12.5 bp: IRR 15.64%Assisted-living occupancy 86%, rates 0%, exit cap −12.5 bp: IRR 11.70%Assisted-living occupancy 87%, rates 0%, exit cap −12.5 bp: IRR 12.08%Assisted-living occupancy 88%, rates 0%, exit cap −12.5 bp: IRR 12.45%Assisted-living occupancy 89%, rates 0%, exit cap −12.5 bp: IRR 12.82%Assisted-living occupancy 90%, rates 0%, exit cap −12.5 bp: IRR 13.19%Assisted-living occupancy 91%, rates 0%, exit cap −12.5 bp: IRR 13.55%Assisted-living occupancy 92%, rates 0%, exit cap −12.5 bp: IRR 13.91%Assisted-living occupancy 93%, rates 0%, exit cap −12.5 bp: IRR 14.26%Assisted-living occupancy 94%, rates 0%, exit cap −12.5 bp: IRR 14.60%Assisted-living occupancy 95%, rates 0%, exit cap −12.5 bp: IRR 14.95%Assisted-living occupancy 96%, rates 0%, exit cap −12.5 bp: IRR 15.28%Assisted-living occupancy 97%, rates 0%, exit cap −12.5 bp: IRR 15.62%Assisted-living occupancy 98%, rates 0%, exit cap −12.5 bp: IRR 15.95%Assisted-living occupancy 99%, rates 0%, exit cap −12.5 bp: IRR 16.27%Assisted-living occupancy 100%, rates 0%, exit cap −12.5 bp: IRR 16.60%Assisted-living occupancy 86%, rates +1%, exit cap −12.5 bp: IRR 12.72%Assisted-living occupancy 87%, rates +1%, exit cap −12.5 bp: IRR 13.09%Assisted-living occupancy 88%, rates +1%, exit cap −12.5 bp: IRR 13.46%Assisted-living occupancy 89%, rates +1%, exit cap −12.5 bp: IRR 13.82%Assisted-living occupancy 90%, rates +1%, exit cap −12.5 bp: IRR 14.18%Assisted-living occupancy 91%, rates +1%, exit cap −12.5 bp: IRR 14.53%Assisted-living occupancy 92%, rates +1%, exit cap −12.5 bp: IRR 14.88%Assisted-living occupancy 93%, rates +1%, exit cap −12.5 bp: IRR 15.23%Assisted-living occupancy 94%, rates +1%, exit cap −12.5 bp: IRR 15.57%Assisted-living occupancy 95%, rates +1%, exit cap −12.5 bp: IRR 15.90%Assisted-living occupancy 96%, rates +1%, exit cap −12.5 bp: IRR 16.24%Assisted-living occupancy 97%, rates +1%, exit cap −12.5 bp: IRR 16.57%Assisted-living occupancy 98%, rates +1%, exit cap −12.5 bp: IRR 16.89%Assisted-living occupancy 99%, rates +1%, exit cap −12.5 bp: IRR 17.21%Assisted-living occupancy 100%, rates +1%, exit cap −12.5 bp: IRR 17.53%Assisted-living occupancy 86%, rates +2%, exit cap −12.5 bp: IRR 13.71%Assisted-living occupancy 87%, rates +2%, exit cap −12.5 bp: IRR 14.07%Assisted-living occupancy 88%, rates +2%, exit cap −12.5 bp: IRR 14.43%Assisted-living occupancy 89%, rates +2%, exit cap −12.5 bp: IRR 14.79%Assisted-living occupancy 90%, rates +2%, exit cap −12.5 bp: IRR 15.14%Assisted-living occupancy 91%, rates +2%, exit cap −12.5 bp: IRR 15.49%Assisted-living occupancy 92%, rates +2%, exit cap −12.5 bp: IRR 15.83%Assisted-living occupancy 93%, rates +2%, exit cap −12.5 bp: IRR 16.17%Assisted-living occupancy 94%, rates +2%, exit cap −12.5 bp: IRR 16.50%Assisted-living occupancy 95%, rates +2%, exit cap −12.5 bp: IRR 16.84%Assisted-living occupancy 96%, rates +2%, exit cap −12.5 bp: IRR 17.16%Assisted-living occupancy 97%, rates +2%, exit cap −12.5 bp: IRR 17.49%Assisted-living occupancy 98%, rates +2%, exit cap −12.5 bp: IRR 17.81%Assisted-living occupancy 99%, rates +2%, exit cap −12.5 bp: IRR 18.13%Assisted-living occupancy 100%, rates +2%, exit cap −12.5 bp: IRR 18.44%Assisted-living occupancy 86%, rates +3%, exit cap −12.5 bp: IRR 14.66%Assisted-living occupancy 87%, rates +3%, exit cap −12.5 bp: IRR 15.02%Assisted-living occupancy 88%, rates +3%, exit cap −12.5 bp: IRR 15.38%Assisted-living occupancy 89%, rates +3%, exit cap −12.5 bp: IRR 15.73%Assisted-living occupancy 90%, rates +3%, exit cap −12.5 bp: IRR 16.07%Assisted-living occupancy 91%, rates +3%, exit cap −12.5 bp: IRR 16.41%Assisted-living occupancy 92%, rates +3%, exit cap −12.5 bp: IRR 16.75%Assisted-living occupancy 93%, rates +3%, exit cap −12.5 bp: IRR 17.09%Assisted-living occupancy 94%, rates +3%, exit cap −12.5 bp: IRR 17.42%Assisted-living occupancy 95%, rates +3%, exit cap −12.5 bp: IRR 17.74%Assisted-living occupancy 96%, rates +3%, exit cap −12.5 bp: IRR 18.07%Assisted-living occupancy 97%, rates +3%, exit cap −12.5 bp: IRR 18.39%Assisted-living occupancy 98%, rates +3%, exit cap −12.5 bp: IRR 18.71%Assisted-living occupancy 99%, rates +3%, exit cap −12.5 bp: IRR 19.02%Assisted-living occupancy 100%, rates +3%, exit cap −12.5 bp: IRR 19.33%Assisted-living occupancy 86%, rates +4%, exit cap −12.5 bp: IRR 15.59%Assisted-living occupancy 87%, rates +4%, exit cap −12.5 bp: IRR 15.95%Assisted-living occupancy 88%, rates +4%, exit cap −12.5 bp: IRR 16.29%Assisted-living occupancy 89%, rates +4%, exit cap −12.5 bp: IRR 16.64%Assisted-living occupancy 90%, rates +4%, exit cap −12.5 bp: IRR 16.98%Assisted-living occupancy 91%, rates +4%, exit cap −12.5 bp: IRR 17.32%Assisted-living occupancy 92%, rates +4%, exit cap −12.5 bp: IRR 17.65%Assisted-living occupancy 93%, rates +4%, exit cap −12.5 bp: IRR 17.98%Assisted-living occupancy 94%, rates +4%, exit cap −12.5 bp: IRR 18.31%Assisted-living occupancy 95%, rates +4%, exit cap −12.5 bp: IRR 18.63%Assisted-living occupancy 96%, rates +4%, exit cap −12.5 bp: IRR 18.95%Assisted-living occupancy 97%, rates +4%, exit cap −12.5 bp: IRR 19.27%Assisted-living occupancy 98%, rates +4%, exit cap −12.5 bp: IRR 19.58%Assisted-living occupancy 99%, rates +4%, exit cap −12.5 bp: IRR 19.89%Assisted-living occupancy 100%, rates +4%, exit cap −12.5 bp: IRR 20.20%Assisted-living occupancy 86%, rates +5%, exit cap −12.5 bp: IRR 16.50%Assisted-living occupancy 87%, rates +5%, exit cap −12.5 bp: IRR 16.84%Assisted-living occupancy 88%, rates +5%, exit cap −12.5 bp: IRR 17.19%Assisted-living occupancy 89%, rates +5%, exit cap −12.5 bp: IRR 17.53%Assisted-living occupancy 90%, rates +5%, exit cap −12.5 bp: IRR 17.86%Assisted-living occupancy 91%, rates +5%, exit cap −12.5 bp: IRR 18.20%Assisted-living occupancy 92%, rates +5%, exit cap −12.5 bp: IRR 18.53%Assisted-living occupancy 93%, rates +5%, exit cap −12.5 bp: IRR 18.85%Assisted-living occupancy 94%, rates +5%, exit cap −12.5 bp: IRR 19.18%Assisted-living occupancy 95%, rates +5%, exit cap −12.5 bp: IRR 19.50%Assisted-living occupancy 96%, rates +5%, exit cap −12.5 bp: IRR 19.81%Assisted-living occupancy 97%, rates +5%, exit cap −12.5 bp: IRR 20.13%Assisted-living occupancy 98%, rates +5%, exit cap −12.5 bp: IRR 20.44%Assisted-living occupancy 99%, rates +5%, exit cap −12.5 bp: IRR 20.75%Assisted-living occupancy 100%, rates +5%, exit cap −12.5 bp: IRR 21.05%

Exit cap −12.5 bp
70 of 165 clear

Assisted-living occupancy 86%, rates −5%, exit cap as modelled: IRR 5.79%Assisted-living occupancy 87%, rates −5%, exit cap as modelled: IRR 6.15%Assisted-living occupancy 88%, rates −5%, exit cap as modelled: IRR 6.52%Assisted-living occupancy 89%, rates −5%, exit cap as modelled: IRR 6.88%Assisted-living occupancy 90%, rates −5%, exit cap as modelled: IRR 7.25%Assisted-living occupancy 91%, rates −5%, exit cap as modelled: IRR 7.63%Assisted-living occupancy 92%, rates −5%, exit cap as modelled: IRR 8.01%Assisted-living occupancy 93%, rates −5%, exit cap as modelled: IRR 8.39%Assisted-living occupancy 94%, rates −5%, exit cap as modelled: IRR 8.78%Assisted-living occupancy 95%, rates −5%, exit cap as modelled: IRR 9.17%Assisted-living occupancy 96%, rates −5%, exit cap as modelled: IRR 9.57%Assisted-living occupancy 97%, rates −5%, exit cap as modelled: IRR 9.97%Assisted-living occupancy 98%, rates −5%, exit cap as modelled: IRR 10.38%Assisted-living occupancy 99%, rates −5%, exit cap as modelled: IRR 10.79%Assisted-living occupancy 100%, rates −5%, exit cap as modelled: IRR 11.15%Assisted-living occupancy 86%, rates −4%, exit cap as modelled: IRR 6.85%Assisted-living occupancy 87%, rates −4%, exit cap as modelled: IRR 7.23%Assisted-living occupancy 88%, rates −4%, exit cap as modelled: IRR 7.61%Assisted-living occupancy 89%, rates −4%, exit cap as modelled: IRR 7.99%Assisted-living occupancy 90%, rates −4%, exit cap as modelled: IRR 8.38%Assisted-living occupancy 91%, rates −4%, exit cap as modelled: IRR 8.77%Assisted-living occupancy 92%, rates −4%, exit cap as modelled: IRR 9.17%Assisted-living occupancy 93%, rates −4%, exit cap as modelled: IRR 9.58%Assisted-living occupancy 94%, rates −4%, exit cap as modelled: IRR 9.99%Assisted-living occupancy 95%, rates −4%, exit cap as modelled: IRR 10.40%Assisted-living occupancy 96%, rates −4%, exit cap as modelled: IRR 10.82%Assisted-living occupancy 97%, rates −4%, exit cap as modelled: IRR 11.19%Assisted-living occupancy 98%, rates −4%, exit cap as modelled: IRR 11.55%Assisted-living occupancy 99%, rates −4%, exit cap as modelled: IRR 11.91%Assisted-living occupancy 100%, rates −4%, exit cap as modelled: IRR 12.26%Assisted-living occupancy 86%, rates −3%, exit cap as modelled: IRR 7.94%Assisted-living occupancy 87%, rates −3%, exit cap as modelled: IRR 8.33%Assisted-living occupancy 88%, rates −3%, exit cap as modelled: IRR 8.73%Assisted-living occupancy 89%, rates −3%, exit cap as modelled: IRR 9.14%Assisted-living occupancy 90%, rates −3%, exit cap as modelled: IRR 9.55%Assisted-living occupancy 91%, rates −3%, exit cap as modelled: IRR 9.96%Assisted-living occupancy 92%, rates −3%, exit cap as modelled: IRR 10.39%Assisted-living occupancy 93%, rates −3%, exit cap as modelled: IRR 10.81%Assisted-living occupancy 94%, rates −3%, exit cap as modelled: IRR 11.19%Assisted-living occupancy 95%, rates −3%, exit cap as modelled: IRR 11.56%Assisted-living occupancy 96%, rates −3%, exit cap as modelled: IRR 11.92%Assisted-living occupancy 97%, rates −3%, exit cap as modelled: IRR 12.28%Assisted-living occupancy 98%, rates −3%, exit cap as modelled: IRR 12.64%Assisted-living occupancy 99%, rates −3%, exit cap as modelled: IRR 12.98%Assisted-living occupancy 100%, rates −3%, exit cap as modelled: IRR 13.33%Assisted-living occupancy 86%, rates −2%, exit cap as modelled: IRR 9.06%Assisted-living occupancy 87%, rates −2%, exit cap as modelled: IRR 9.48%Assisted-living occupancy 88%, rates −2%, exit cap as modelled: IRR 9.90%Assisted-living occupancy 89%, rates −2%, exit cap as modelled: IRR 10.33%Assisted-living occupancy 90%, rates −2%, exit cap as modelled: IRR 10.77%Assisted-living occupancy 91%, rates −2%, exit cap as modelled: IRR 11.16%Assisted-living occupancy 92%, rates −2%, exit cap as modelled: IRR 11.53%Assisted-living occupancy 93%, rates −2%, exit cap as modelled: IRR 11.90%Assisted-living occupancy 94%, rates −2%, exit cap as modelled: IRR 12.27%Assisted-living occupancy 95%, rates −2%, exit cap as modelled: IRR 12.63%Assisted-living occupancy 96%, rates −2%, exit cap as modelled: IRR 12.98%Assisted-living occupancy 97%, rates −2%, exit cap as modelled: IRR 13.33%Assisted-living occupancy 98%, rates −2%, exit cap as modelled: IRR 13.68%Assisted-living occupancy 99%, rates −2%, exit cap as modelled: IRR 14.02%Assisted-living occupancy 100%, rates −2%, exit cap as modelled: IRR 14.36%Assisted-living occupancy 86%, rates −1%, exit cap as modelled: IRR 10.24%Assisted-living occupancy 87%, rates −1%, exit cap as modelled: IRR 10.68%Assisted-living occupancy 88%, rates −1%, exit cap as modelled: IRR 11.09%Assisted-living occupancy 89%, rates −1%, exit cap as modelled: IRR 11.47%Assisted-living occupancy 90%, rates −1%, exit cap as modelled: IRR 11.85%Assisted-living occupancy 91%, rates −1%, exit cap as modelled: IRR 12.22%Assisted-living occupancy 92%, rates −1%, exit cap as modelled: IRR 12.59%Assisted-living occupancy 93%, rates −1%, exit cap as modelled: IRR 12.95%Assisted-living occupancy 94%, rates −1%, exit cap as modelled: IRR 13.31%Assisted-living occupancy 95%, rates −1%, exit cap as modelled: IRR 13.66%Assisted-living occupancy 96%, rates −1%, exit cap as modelled: IRR 14.01%Assisted-living occupancy 97%, rates −1%, exit cap as modelled: IRR 14.35%Assisted-living occupancy 98%, rates −1%, exit cap as modelled: IRR 14.69%Assisted-living occupancy 99%, rates −1%, exit cap as modelled: IRR 15.02%Assisted-living occupancy 100%, rates −1%, exit cap as modelled: IRR 15.36%Assisted-living occupancy 86%, rates 0%, exit cap as modelled: IRR 11.38%Assisted-living occupancy 87%, rates 0%, exit cap as modelled: IRR 11.76%Assisted-living occupancy 88%, rates 0%, exit cap as modelled: IRR 12.14%Assisted-living occupancy 89%, rates 0%, exit cap as modelled: IRR 12.52%Assisted-living occupancy 90%, rates 0%, exit cap as modelled: IRR 12.89%Assisted-living occupancy 91%, rates 0%, exit cap as modelled: IRR 13.25%Assisted-living occupancy 92%, rates 0%, exit cap as modelled: IRR 13.61%Assisted-living occupancy 93%, rates 0%, exit cap as modelled: IRR 13.96%Assisted-living occupancy 94%, rates 0%, exit cap as modelled: IRR 14.31%Assisted-living occupancy 95%, rates 0%, exit cap as modelled: IRR 14.66%Assisted-living occupancy 96%, rates 0%, exit cap as modelled: IRR 14.998%Assisted-living occupancy 97%, rates 0%, exit cap as modelled: IRR 15.33%Assisted-living occupancy 98%, rates 0%, exit cap as modelled: IRR 15.67%Assisted-living occupancy 99%, rates 0%, exit cap as modelled: IRR 16.00%Assisted-living occupancy 100%, rates 0%, exit cap as modelled: IRR 16.32%Assisted-living occupancy 86%, rates +1%, exit cap as modelled: IRR 12.41%Assisted-living occupancy 87%, rates +1%, exit cap as modelled: IRR 12.79%Assisted-living occupancy 88%, rates +1%, exit cap as modelled: IRR 13.16%Assisted-living occupancy 89%, rates +1%, exit cap as modelled: IRR 13.52%Assisted-living occupancy 90%, rates +1%, exit cap as modelled: IRR 13.89%Assisted-living occupancy 91%, rates +1%, exit cap as modelled: IRR 14.24%Assisted-living occupancy 92%, rates +1%, exit cap as modelled: IRR 14.59%Assisted-living occupancy 93%, rates +1%, exit cap as modelled: IRR 14.94%Assisted-living occupancy 94%, rates +1%, exit cap as modelled: IRR 15.28%Assisted-living occupancy 95%, rates +1%, exit cap as modelled: IRR 15.62%Assisted-living occupancy 96%, rates +1%, exit cap as modelled: IRR 15.96%Assisted-living occupancy 97%, rates +1%, exit cap as modelled: IRR 16.29%Assisted-living occupancy 98%, rates +1%, exit cap as modelled: IRR 16.62%Assisted-living occupancy 99%, rates +1%, exit cap as modelled: IRR 16.94%Assisted-living occupancy 100%, rates +1%, exit cap as modelled: IRR 17.26%Assisted-living occupancy 86%, rates +2%, exit cap as modelled: IRR 13.41%Assisted-living occupancy 87%, rates +2%, exit cap as modelled: IRR 13.78%Assisted-living occupancy 88%, rates +2%, exit cap as modelled: IRR 14.14%Assisted-living occupancy 89%, rates +2%, exit cap as modelled: IRR 14.50%Assisted-living occupancy 90%, rates +2%, exit cap as modelled: IRR 14.85%Assisted-living occupancy 91%, rates +2%, exit cap as modelled: IRR 15.20%Assisted-living occupancy 92%, rates +2%, exit cap as modelled: IRR 15.55%Assisted-living occupancy 93%, rates +2%, exit cap as modelled: IRR 15.89%Assisted-living occupancy 94%, rates +2%, exit cap as modelled: IRR 16.23%Assisted-living occupancy 95%, rates +2%, exit cap as modelled: IRR 16.56%Assisted-living occupancy 96%, rates +2%, exit cap as modelled: IRR 16.89%Assisted-living occupancy 97%, rates +2%, exit cap as modelled: IRR 17.22%Assisted-living occupancy 98%, rates +2%, exit cap as modelled: IRR 17.54%Assisted-living occupancy 99%, rates +2%, exit cap as modelled: IRR 17.86%Assisted-living occupancy 100%, rates +2%, exit cap as modelled: IRR 18.18%Assisted-living occupancy 86%, rates +3%, exit cap as modelled: IRR 14.37%Assisted-living occupancy 87%, rates +3%, exit cap as modelled: IRR 14.73%Assisted-living occupancy 88%, rates +3%, exit cap as modelled: IRR 15.09%Assisted-living occupancy 89%, rates +3%, exit cap as modelled: IRR 15.44%Assisted-living occupancy 90%, rates +3%, exit cap as modelled: IRR 15.79%Assisted-living occupancy 91%, rates +3%, exit cap as modelled: IRR 16.14%Assisted-living occupancy 92%, rates +3%, exit cap as modelled: IRR 16.48%Assisted-living occupancy 93%, rates +3%, exit cap as modelled: IRR 16.81%Assisted-living occupancy 94%, rates +3%, exit cap as modelled: IRR 17.15%Assisted-living occupancy 95%, rates +3%, exit cap as modelled: IRR 17.48%Assisted-living occupancy 96%, rates +3%, exit cap as modelled: IRR 17.80%Assisted-living occupancy 97%, rates +3%, exit cap as modelled: IRR 18.12%Assisted-living occupancy 98%, rates +3%, exit cap as modelled: IRR 18.44%Assisted-living occupancy 99%, rates +3%, exit cap as modelled: IRR 18.76%Assisted-living occupancy 100%, rates +3%, exit cap as modelled: IRR 19.07%Assisted-living occupancy 86%, rates +4%, exit cap as modelled: IRR 15.31%Assisted-living occupancy 87%, rates +4%, exit cap as modelled: IRR 15.66%Assisted-living occupancy 88%, rates +4%, exit cap as modelled: IRR 16.02%Assisted-living occupancy 89%, rates +4%, exit cap as modelled: IRR 16.36%Assisted-living occupancy 90%, rates +4%, exit cap as modelled: IRR 16.71%Assisted-living occupancy 91%, rates +4%, exit cap as modelled: IRR 17.04%Assisted-living occupancy 92%, rates +4%, exit cap as modelled: IRR 17.38%Assisted-living occupancy 93%, rates +4%, exit cap as modelled: IRR 17.71%Assisted-living occupancy 94%, rates +4%, exit cap as modelled: IRR 18.04%Assisted-living occupancy 95%, rates +4%, exit cap as modelled: IRR 18.37%Assisted-living occupancy 96%, rates +4%, exit cap as modelled: IRR 18.69%Assisted-living occupancy 97%, rates +4%, exit cap as modelled: IRR 19.01%Assisted-living occupancy 98%, rates +4%, exit cap as modelled: IRR 19.32%Assisted-living occupancy 99%, rates +4%, exit cap as modelled: IRR 19.64%Assisted-living occupancy 100%, rates +4%, exit cap as modelled: IRR 19.95%Assisted-living occupancy 86%, rates +5%, exit cap as modelled: IRR 16.22%Assisted-living occupancy 87%, rates +5%, exit cap as modelled: IRR 16.57%Assisted-living occupancy 88%, rates +5%, exit cap as modelled: IRR 16.91%Assisted-living occupancy 89%, rates +5%, exit cap as modelled: IRR 17.26%Assisted-living occupancy 90%, rates +5%, exit cap as modelled: IRR 17.60%Assisted-living occupancy 91%, rates +5%, exit cap as modelled: IRR 17.93%Assisted-living occupancy 92%, rates +5%, exit cap as modelled: IRR 18.26%Assisted-living occupancy 93%, rates +5%, exit cap as modelled: IRR 18.59%Assisted-living occupancy 94%, rates +5%, exit cap as modelled: IRR 18.92%Assisted-living occupancy 95%, rates +5%, exit cap as modelled: IRR 19.24%Assisted-living occupancy 96%, rates +5%, exit cap as modelled: IRR 19.56%Assisted-living occupancy 97%, rates +5%, exit cap as modelled: IRR 19.87%Assisted-living occupancy 98%, rates +5%, exit cap as modelled: IRR 20.19%Assisted-living occupancy 99%, rates +5%, exit cap as modelled: IRR 20.50%Assisted-living occupancy 100%, rates +5%, exit cap as modelled: IRR 20.80%

Exit cap as modelled
66 of 165 clear

Assisted-living occupancy 86%, rates −5%, exit cap +12.5 bp: IRR 5.48%Assisted-living occupancy 87%, rates −5%, exit cap +12.5 bp: IRR 5.84%Assisted-living occupancy 88%, rates −5%, exit cap +12.5 bp: IRR 6.20%Assisted-living occupancy 89%, rates −5%, exit cap +12.5 bp: IRR 6.57%Assisted-living occupancy 90%, rates −5%, exit cap +12.5 bp: IRR 6.94%Assisted-living occupancy 91%, rates −5%, exit cap +12.5 bp: IRR 7.31%Assisted-living occupancy 92%, rates −5%, exit cap +12.5 bp: IRR 7.69%Assisted-living occupancy 93%, rates −5%, exit cap +12.5 bp: IRR 8.07%Assisted-living occupancy 94%, rates −5%, exit cap +12.5 bp: IRR 8.46%Assisted-living occupancy 95%, rates −5%, exit cap +12.5 bp: IRR 8.85%Assisted-living occupancy 96%, rates −5%, exit cap +12.5 bp: IRR 9.25%Assisted-living occupancy 97%, rates −5%, exit cap +12.5 bp: IRR 9.65%Assisted-living occupancy 98%, rates −5%, exit cap +12.5 bp: IRR 10.06%Assisted-living occupancy 99%, rates −5%, exit cap +12.5 bp: IRR 10.47%Assisted-living occupancy 100%, rates −5%, exit cap +12.5 bp: IRR 10.84%Assisted-living occupancy 86%, rates −4%, exit cap +12.5 bp: IRR 6.53%Assisted-living occupancy 87%, rates −4%, exit cap +12.5 bp: IRR 6.91%Assisted-living occupancy 88%, rates −4%, exit cap +12.5 bp: IRR 7.29%Assisted-living occupancy 89%, rates −4%, exit cap +12.5 bp: IRR 7.67%Assisted-living occupancy 90%, rates −4%, exit cap +12.5 bp: IRR 8.06%Assisted-living occupancy 91%, rates −4%, exit cap +12.5 bp: IRR 8.46%Assisted-living occupancy 92%, rates −4%, exit cap +12.5 bp: IRR 8.85%Assisted-living occupancy 93%, rates −4%, exit cap +12.5 bp: IRR 9.26%Assisted-living occupancy 94%, rates −4%, exit cap +12.5 bp: IRR 9.67%Assisted-living occupancy 95%, rates −4%, exit cap +12.5 bp: IRR 10.08%Assisted-living occupancy 96%, rates −4%, exit cap +12.5 bp: IRR 10.50%Assisted-living occupancy 97%, rates −4%, exit cap +12.5 bp: IRR 10.87%Assisted-living occupancy 98%, rates −4%, exit cap +12.5 bp: IRR 11.24%Assisted-living occupancy 99%, rates −4%, exit cap +12.5 bp: IRR 11.60%Assisted-living occupancy 100%, rates −4%, exit cap +12.5 bp: IRR 11.96%Assisted-living occupancy 86%, rates −3%, exit cap +12.5 bp: IRR 7.62%Assisted-living occupancy 87%, rates −3%, exit cap +12.5 bp: IRR 8.02%Assisted-living occupancy 88%, rates −3%, exit cap +12.5 bp: IRR 8.42%Assisted-living occupancy 89%, rates −3%, exit cap +12.5 bp: IRR 8.82%Assisted-living occupancy 90%, rates −3%, exit cap +12.5 bp: IRR 9.23%Assisted-living occupancy 91%, rates −3%, exit cap +12.5 bp: IRR 9.65%Assisted-living occupancy 92%, rates −3%, exit cap +12.5 bp: IRR 10.07%Assisted-living occupancy 93%, rates −3%, exit cap +12.5 bp: IRR 10.50%Assisted-living occupancy 94%, rates −3%, exit cap +12.5 bp: IRR 10.87%Assisted-living occupancy 95%, rates −3%, exit cap +12.5 bp: IRR 11.25%Assisted-living occupancy 96%, rates −3%, exit cap +12.5 bp: IRR 11.62%Assisted-living occupancy 97%, rates −3%, exit cap +12.5 bp: IRR 11.98%Assisted-living occupancy 98%, rates −3%, exit cap +12.5 bp: IRR 12.33%Assisted-living occupancy 99%, rates −3%, exit cap +12.5 bp: IRR 12.69%Assisted-living occupancy 100%, rates −3%, exit cap +12.5 bp: IRR 13.03%Assisted-living occupancy 86%, rates −2%, exit cap +12.5 bp: IRR 8.75%Assisted-living occupancy 87%, rates −2%, exit cap +12.5 bp: IRR 9.16%Assisted-living occupancy 88%, rates −2%, exit cap +12.5 bp: IRR 9.59%Assisted-living occupancy 89%, rates −2%, exit cap +12.5 bp: IRR 10.01%Assisted-living occupancy 90%, rates −2%, exit cap +12.5 bp: IRR 10.45%Assisted-living occupancy 91%, rates −2%, exit cap +12.5 bp: IRR 10.84%Assisted-living occupancy 92%, rates −2%, exit cap +12.5 bp: IRR 11.22%Assisted-living occupancy 93%, rates −2%, exit cap +12.5 bp: IRR 11.60%Assisted-living occupancy 94%, rates −2%, exit cap +12.5 bp: IRR 11.96%Assisted-living occupancy 95%, rates −2%, exit cap +12.5 bp: IRR 12.33%Assisted-living occupancy 96%, rates −2%, exit cap +12.5 bp: IRR 12.69%Assisted-living occupancy 97%, rates −2%, exit cap +12.5 bp: IRR 13.04%Assisted-living occupancy 98%, rates −2%, exit cap +12.5 bp: IRR 13.39%Assisted-living occupancy 99%, rates −2%, exit cap +12.5 bp: IRR 13.73%Assisted-living occupancy 100%, rates −2%, exit cap +12.5 bp: IRR 14.07%Assisted-living occupancy 86%, rates −1%, exit cap +12.5 bp: IRR 9.92%Assisted-living occupancy 87%, rates −1%, exit cap +12.5 bp: IRR 10.36%Assisted-living occupancy 88%, rates −1%, exit cap +12.5 bp: IRR 10.77%Assisted-living occupancy 89%, rates −1%, exit cap +12.5 bp: IRR 11.16%Assisted-living occupancy 90%, rates −1%, exit cap +12.5 bp: IRR 11.54%Assisted-living occupancy 91%, rates −1%, exit cap +12.5 bp: IRR 11.92%Assisted-living occupancy 92%, rates −1%, exit cap +12.5 bp: IRR 12.29%Assisted-living occupancy 93%, rates −1%, exit cap +12.5 bp: IRR 12.65%Assisted-living occupancy 94%, rates −1%, exit cap +12.5 bp: IRR 13.01%Assisted-living occupancy 95%, rates −1%, exit cap +12.5 bp: IRR 13.37%Assisted-living occupancy 96%, rates −1%, exit cap +12.5 bp: IRR 13.72%Assisted-living occupancy 97%, rates −1%, exit cap +12.5 bp: IRR 14.06%Assisted-living occupancy 98%, rates −1%, exit cap +12.5 bp: IRR 14.41%Assisted-living occupancy 99%, rates −1%, exit cap +12.5 bp: IRR 14.74%Assisted-living occupancy 100%, rates −1%, exit cap +12.5 bp: IRR 15.08%Assisted-living occupancy 86%, rates 0%, exit cap +12.5 bp: IRR 11.06%Assisted-living occupancy 87%, rates 0%, exit cap +12.5 bp: IRR 11.45%Assisted-living occupancy 88%, rates 0%, exit cap +12.5 bp: IRR 11.84%Assisted-living occupancy 89%, rates 0%, exit cap +12.5 bp: IRR 12.21%Assisted-living occupancy 90%, rates 0%, exit cap +12.5 bp: IRR 12.59%Assisted-living occupancy 91%, rates 0%, exit cap +12.5 bp: IRR 12.95%Assisted-living occupancy 92%, rates 0%, exit cap +12.5 bp: IRR 13.32%Assisted-living occupancy 93%, rates 0%, exit cap +12.5 bp: IRR 13.67%Assisted-living occupancy 94%, rates 0%, exit cap +12.5 bp: IRR 14.02%Assisted-living occupancy 95%, rates 0%, exit cap +12.5 bp: IRR 14.37%Assisted-living occupancy 96%, rates 0%, exit cap +12.5 bp: IRR 14.72%Assisted-living occupancy 97%, rates 0%, exit cap +12.5 bp: IRR 15.06%Assisted-living occupancy 98%, rates 0%, exit cap +12.5 bp: IRR 15.39%Assisted-living occupancy 99%, rates 0%, exit cap +12.5 bp: IRR 15.72%Assisted-living occupancy 100%, rates 0%, exit cap +12.5 bp: IRR 16.05%Assisted-living occupancy 86%, rates +1%, exit cap +12.5 bp: IRR 12.11%Assisted-living occupancy 87%, rates +1%, exit cap +12.5 bp: IRR 12.49%Assisted-living occupancy 88%, rates +1%, exit cap +12.5 bp: IRR 12.86%Assisted-living occupancy 89%, rates +1%, exit cap +12.5 bp: IRR 13.23%Assisted-living occupancy 90%, rates +1%, exit cap +12.5 bp: IRR 13.59%Assisted-living occupancy 91%, rates +1%, exit cap +12.5 bp: IRR 13.95%Assisted-living occupancy 92%, rates +1%, exit cap +12.5 bp: IRR 14.31%Assisted-living occupancy 93%, rates +1%, exit cap +12.5 bp: IRR 14.66%Assisted-living occupancy 94%, rates +1%, exit cap +12.5 bp: IRR 15.00%Assisted-living occupancy 95%, rates +1%, exit cap +12.5 bp: IRR 15.35%Assisted-living occupancy 96%, rates +1%, exit cap +12.5 bp: IRR 15.68%Assisted-living occupancy 97%, rates +1%, exit cap +12.5 bp: IRR 16.02%Assisted-living occupancy 98%, rates +1%, exit cap +12.5 bp: IRR 16.35%Assisted-living occupancy 99%, rates +1%, exit cap +12.5 bp: IRR 16.67%Assisted-living occupancy 100%, rates +1%, exit cap +12.5 bp: IRR 17.00%Assisted-living occupancy 86%, rates +2%, exit cap +12.5 bp: IRR 13.11%Assisted-living occupancy 87%, rates +2%, exit cap +12.5 bp: IRR 13.48%Assisted-living occupancy 88%, rates +2%, exit cap +12.5 bp: IRR 13.85%Assisted-living occupancy 89%, rates +2%, exit cap +12.5 bp: IRR 14.21%Assisted-living occupancy 90%, rates +2%, exit cap +12.5 bp: IRR 14.57%Assisted-living occupancy 91%, rates +2%, exit cap +12.5 bp: IRR 14.92%Assisted-living occupancy 92%, rates +2%, exit cap +12.5 bp: IRR 15.27%Assisted-living occupancy 93%, rates +2%, exit cap +12.5 bp: IRR 15.61%Assisted-living occupancy 94%, rates +2%, exit cap +12.5 bp: IRR 15.95%Assisted-living occupancy 95%, rates +2%, exit cap +12.5 bp: IRR 16.29%Assisted-living occupancy 96%, rates +2%, exit cap +12.5 bp: IRR 16.62%Assisted-living occupancy 97%, rates +2%, exit cap +12.5 bp: IRR 16.95%Assisted-living occupancy 98%, rates +2%, exit cap +12.5 bp: IRR 17.28%Assisted-living occupancy 99%, rates +2%, exit cap +12.5 bp: IRR 17.60%Assisted-living occupancy 100%, rates +2%, exit cap +12.5 bp: IRR 17.92%Assisted-living occupancy 86%, rates +3%, exit cap +12.5 bp: IRR 14.09%Assisted-living occupancy 87%, rates +3%, exit cap +12.5 bp: IRR 14.45%Assisted-living occupancy 88%, rates +3%, exit cap +12.5 bp: IRR 14.81%Assisted-living occupancy 89%, rates +3%, exit cap +12.5 bp: IRR 15.16%Assisted-living occupancy 90%, rates +3%, exit cap +12.5 bp: IRR 15.52%Assisted-living occupancy 91%, rates +3%, exit cap +12.5 bp: IRR 15.86%Assisted-living occupancy 92%, rates +3%, exit cap +12.5 bp: IRR 16.21%Assisted-living occupancy 93%, rates +3%, exit cap +12.5 bp: IRR 16.54%Assisted-living occupancy 94%, rates +3%, exit cap +12.5 bp: IRR 16.88%Assisted-living occupancy 95%, rates +3%, exit cap +12.5 bp: IRR 17.21%Assisted-living occupancy 96%, rates +3%, exit cap +12.5 bp: IRR 17.54%Assisted-living occupancy 97%, rates +3%, exit cap +12.5 bp: IRR 17.86%Assisted-living occupancy 98%, rates +3%, exit cap +12.5 bp: IRR 18.19%Assisted-living occupancy 99%, rates +3%, exit cap +12.5 bp: IRR 18.50%Assisted-living occupancy 100%, rates +3%, exit cap +12.5 bp: IRR 18.82%Assisted-living occupancy 86%, rates +4%, exit cap +12.5 bp: IRR 15.03%Assisted-living occupancy 87%, rates +4%, exit cap +12.5 bp: IRR 15.39%Assisted-living occupancy 88%, rates +4%, exit cap +12.5 bp: IRR 15.74%Assisted-living occupancy 89%, rates +4%, exit cap +12.5 bp: IRR 16.09%Assisted-living occupancy 90%, rates +4%, exit cap +12.5 bp: IRR 16.44%Assisted-living occupancy 91%, rates +4%, exit cap +12.5 bp: IRR 16.78%Assisted-living occupancy 92%, rates +4%, exit cap +12.5 bp: IRR 17.12%Assisted-living occupancy 93%, rates +4%, exit cap +12.5 bp: IRR 17.45%Assisted-living occupancy 94%, rates +4%, exit cap +12.5 bp: IRR 17.78%Assisted-living occupancy 95%, rates +4%, exit cap +12.5 bp: IRR 18.11%Assisted-living occupancy 96%, rates +4%, exit cap +12.5 bp: IRR 18.43%Assisted-living occupancy 97%, rates +4%, exit cap +12.5 bp: IRR 18.75%Assisted-living occupancy 98%, rates +4%, exit cap +12.5 bp: IRR 19.07%Assisted-living occupancy 99%, rates +4%, exit cap +12.5 bp: IRR 19.39%Assisted-living occupancy 100%, rates +4%, exit cap +12.5 bp: IRR 19.70%Assisted-living occupancy 86%, rates +5%, exit cap +12.5 bp: IRR 15.94%Assisted-living occupancy 87%, rates +5%, exit cap +12.5 bp: IRR 16.30%Assisted-living occupancy 88%, rates +5%, exit cap +12.5 bp: IRR 16.65%Assisted-living occupancy 89%, rates +5%, exit cap +12.5 bp: IRR 16.99%Assisted-living occupancy 90%, rates +5%, exit cap +12.5 bp: IRR 17.33%Assisted-living occupancy 91%, rates +5%, exit cap +12.5 bp: IRR 17.67%Assisted-living occupancy 92%, rates +5%, exit cap +12.5 bp: IRR 18.00%Assisted-living occupancy 93%, rates +5%, exit cap +12.5 bp: IRR 18.33%Assisted-living occupancy 94%, rates +5%, exit cap +12.5 bp: IRR 18.66%Assisted-living occupancy 95%, rates +5%, exit cap +12.5 bp: IRR 18.98%Assisted-living occupancy 96%, rates +5%, exit cap +12.5 bp: IRR 19.31%Assisted-living occupancy 97%, rates +5%, exit cap +12.5 bp: IRR 19.62%Assisted-living occupancy 98%, rates +5%, exit cap +12.5 bp: IRR 19.94%Assisted-living occupancy 99%, rates +5%, exit cap +12.5 bp: IRR 20.25%Assisted-living occupancy 100%, rates +5%, exit cap +12.5 bp: IRR 20.56%

Exit cap +12.5 bp
63 of 165 clear

Assisted-living occupancy 86%, rates −5%, exit cap +25 bp: IRR 5.17%Assisted-living occupancy 87%, rates −5%, exit cap +25 bp: IRR 5.53%Assisted-living occupancy 88%, rates −5%, exit cap +25 bp: IRR 5.89%Assisted-living occupancy 89%, rates −5%, exit cap +25 bp: IRR 6.26%Assisted-living occupancy 90%, rates −5%, exit cap +25 bp: IRR 6.63%Assisted-living occupancy 91%, rates −5%, exit cap +25 bp: IRR 7.00%Assisted-living occupancy 92%, rates −5%, exit cap +25 bp: IRR 7.38%Assisted-living occupancy 93%, rates −5%, exit cap +25 bp: IRR 7.76%Assisted-living occupancy 94%, rates −5%, exit cap +25 bp: IRR 8.15%Assisted-living occupancy 95%, rates −5%, exit cap +25 bp: IRR 8.54%Assisted-living occupancy 96%, rates −5%, exit cap +25 bp: IRR 8.93%Assisted-living occupancy 97%, rates −5%, exit cap +25 bp: IRR 9.34%Assisted-living occupancy 98%, rates −5%, exit cap +25 bp: IRR 9.74%Assisted-living occupancy 99%, rates −5%, exit cap +25 bp: IRR 10.15%Assisted-living occupancy 100%, rates −5%, exit cap +25 bp: IRR 10.52%Assisted-living occupancy 86%, rates −4%, exit cap +25 bp: IRR 6.22%Assisted-living occupancy 87%, rates −4%, exit cap +25 bp: IRR 6.60%Assisted-living occupancy 88%, rates −4%, exit cap +25 bp: IRR 6.98%Assisted-living occupancy 89%, rates −4%, exit cap +25 bp: IRR 7.36%Assisted-living occupancy 90%, rates −4%, exit cap +25 bp: IRR 7.75%Assisted-living occupancy 91%, rates −4%, exit cap +25 bp: IRR 8.14%Assisted-living occupancy 92%, rates −4%, exit cap +25 bp: IRR 8.54%Assisted-living occupancy 93%, rates −4%, exit cap +25 bp: IRR 8.94%Assisted-living occupancy 94%, rates −4%, exit cap +25 bp: IRR 9.35%Assisted-living occupancy 95%, rates −4%, exit cap +25 bp: IRR 9.77%Assisted-living occupancy 96%, rates −4%, exit cap +25 bp: IRR 10.19%Assisted-living occupancy 97%, rates −4%, exit cap +25 bp: IRR 10.56%Assisted-living occupancy 98%, rates −4%, exit cap +25 bp: IRR 10.93%Assisted-living occupancy 99%, rates −4%, exit cap +25 bp: IRR 11.30%Assisted-living occupancy 100%, rates −4%, exit cap +25 bp: IRR 11.66%Assisted-living occupancy 86%, rates −3%, exit cap +25 bp: IRR 7.31%Assisted-living occupancy 87%, rates −3%, exit cap +25 bp: IRR 7.70%Assisted-living occupancy 88%, rates −3%, exit cap +25 bp: IRR 8.10%Assisted-living occupancy 89%, rates −3%, exit cap +25 bp: IRR 8.51%Assisted-living occupancy 90%, rates −3%, exit cap +25 bp: IRR 8.92%Assisted-living occupancy 91%, rates −3%, exit cap +25 bp: IRR 9.33%Assisted-living occupancy 92%, rates −3%, exit cap +25 bp: IRR 9.75%Assisted-living occupancy 93%, rates −3%, exit cap +25 bp: IRR 10.18%Assisted-living occupancy 94%, rates −3%, exit cap +25 bp: IRR 10.56%Assisted-living occupancy 95%, rates −3%, exit cap +25 bp: IRR 10.94%Assisted-living occupancy 96%, rates −3%, exit cap +25 bp: IRR 11.31%Assisted-living occupancy 97%, rates −3%, exit cap +25 bp: IRR 11.68%Assisted-living occupancy 98%, rates −3%, exit cap +25 bp: IRR 12.04%Assisted-living occupancy 99%, rates −3%, exit cap +25 bp: IRR 12.39%Assisted-living occupancy 100%, rates −3%, exit cap +25 bp: IRR 12.74%Assisted-living occupancy 86%, rates −2%, exit cap +25 bp: IRR 8.43%Assisted-living occupancy 87%, rates −2%, exit cap +25 bp: IRR 8.85%Assisted-living occupancy 88%, rates −2%, exit cap +25 bp: IRR 9.27%Assisted-living occupancy 89%, rates −2%, exit cap +25 bp: IRR 9.70%Assisted-living occupancy 90%, rates −2%, exit cap +25 bp: IRR 10.13%Assisted-living occupancy 91%, rates −2%, exit cap +25 bp: IRR 10.53%Assisted-living occupancy 92%, rates −2%, exit cap +25 bp: IRR 10.91%Assisted-living occupancy 93%, rates −2%, exit cap +25 bp: IRR 11.29%Assisted-living occupancy 94%, rates −2%, exit cap +25 bp: IRR 11.66%Assisted-living occupancy 95%, rates −2%, exit cap +25 bp: IRR 12.03%Assisted-living occupancy 96%, rates −2%, exit cap +25 bp: IRR 12.39%Assisted-living occupancy 97%, rates −2%, exit cap +25 bp: IRR 12.75%Assisted-living occupancy 98%, rates −2%, exit cap +25 bp: IRR 13.10%Assisted-living occupancy 99%, rates −2%, exit cap +25 bp: IRR 13.45%Assisted-living occupancy 100%, rates −2%, exit cap +25 bp: IRR 13.79%Assisted-living occupancy 86%, rates −1%, exit cap +25 bp: IRR 9.60%Assisted-living occupancy 87%, rates −1%, exit cap +25 bp: IRR 10.05%Assisted-living occupancy 88%, rates −1%, exit cap +25 bp: IRR 10.46%Assisted-living occupancy 89%, rates −1%, exit cap +25 bp: IRR 10.85%Assisted-living occupancy 90%, rates −1%, exit cap +25 bp: IRR 11.24%Assisted-living occupancy 91%, rates −1%, exit cap +25 bp: IRR 11.62%Assisted-living occupancy 92%, rates −1%, exit cap +25 bp: IRR 11.99%Assisted-living occupancy 93%, rates −1%, exit cap +25 bp: IRR 12.36%Assisted-living occupancy 94%, rates −1%, exit cap +25 bp: IRR 12.72%Assisted-living occupancy 95%, rates −1%, exit cap +25 bp: IRR 13.08%Assisted-living occupancy 96%, rates −1%, exit cap +25 bp: IRR 13.43%Assisted-living occupancy 97%, rates −1%, exit cap +25 bp: IRR 13.78%Assisted-living occupancy 98%, rates −1%, exit cap +25 bp: IRR 14.13%Assisted-living occupancy 99%, rates −1%, exit cap +25 bp: IRR 14.47%Assisted-living occupancy 100%, rates −1%, exit cap +25 bp: IRR 14.80%Assisted-living occupancy 86%, rates 0%, exit cap +25 bp: IRR 10.75%Assisted-living occupancy 87%, rates 0%, exit cap +25 bp: IRR 11.15%Assisted-living occupancy 88%, rates 0%, exit cap +25 bp: IRR 11.53%Assisted-living occupancy 89%, rates 0%, exit cap +25 bp: IRR 11.91%Assisted-living occupancy 90%, rates 0%, exit cap +25 bp: IRR 12.29%Assisted-living occupancy 91%, rates 0%, exit cap +25 bp: IRR 12.66%Assisted-living occupancy 92%, rates 0%, exit cap +25 bp: IRR 13.03%Assisted-living occupancy 93%, rates 0%, exit cap +25 bp: IRR 13.39%Assisted-living occupancy 94%, rates 0%, exit cap +25 bp: IRR 13.74%Assisted-living occupancy 95%, rates 0%, exit cap +25 bp: IRR 14.09%Assisted-living occupancy 96%, rates 0%, exit cap +25 bp: IRR 14.44%Assisted-living occupancy 97%, rates 0%, exit cap +25 bp: IRR 14.78%Assisted-living occupancy 98%, rates 0%, exit cap +25 bp: IRR 15.12%Assisted-living occupancy 99%, rates 0%, exit cap +25 bp: IRR 15.45%Assisted-living occupancy 100%, rates 0%, exit cap +25 bp: IRR 15.78%Assisted-living occupancy 86%, rates +1%, exit cap +25 bp: IRR 11.81%Assisted-living occupancy 87%, rates +1%, exit cap +25 bp: IRR 12.19%Assisted-living occupancy 88%, rates +1%, exit cap +25 bp: IRR 12.57%Assisted-living occupancy 89%, rates +1%, exit cap +25 bp: IRR 12.94%Assisted-living occupancy 90%, rates +1%, exit cap +25 bp: IRR 13.31%Assisted-living occupancy 91%, rates +1%, exit cap +25 bp: IRR 13.67%Assisted-living occupancy 92%, rates +1%, exit cap +25 bp: IRR 14.03%Assisted-living occupancy 93%, rates +1%, exit cap +25 bp: IRR 14.38%Assisted-living occupancy 94%, rates +1%, exit cap +25 bp: IRR 14.73%Assisted-living occupancy 95%, rates +1%, exit cap +25 bp: IRR 15.07%Assisted-living occupancy 96%, rates +1%, exit cap +25 bp: IRR 15.41%Assisted-living occupancy 97%, rates +1%, exit cap +25 bp: IRR 15.75%Assisted-living occupancy 98%, rates +1%, exit cap +25 bp: IRR 16.08%Assisted-living occupancy 99%, rates +1%, exit cap +25 bp: IRR 16.41%Assisted-living occupancy 100%, rates +1%, exit cap +25 bp: IRR 16.74%Assisted-living occupancy 86%, rates +2%, exit cap +25 bp: IRR 12.82%Assisted-living occupancy 87%, rates +2%, exit cap +25 bp: IRR 13.20%Assisted-living occupancy 88%, rates +2%, exit cap +25 bp: IRR 13.57%Assisted-living occupancy 89%, rates +2%, exit cap +25 bp: IRR 13.93%Assisted-living occupancy 90%, rates +2%, exit cap +25 bp: IRR 14.29%Assisted-living occupancy 91%, rates +2%, exit cap +25 bp: IRR 14.65%Assisted-living occupancy 92%, rates +2%, exit cap +25 bp: IRR 14.996%Assisted-living occupancy 93%, rates +2%, exit cap +25 bp: IRR 15.34%Assisted-living occupancy 94%, rates +2%, exit cap +25 bp: IRR 15.69%Assisted-living occupancy 95%, rates +2%, exit cap +25 bp: IRR 16.02%Assisted-living occupancy 96%, rates +2%, exit cap +25 bp: IRR 16.36%Assisted-living occupancy 97%, rates +2%, exit cap +25 bp: IRR 16.69%Assisted-living occupancy 98%, rates +2%, exit cap +25 bp: IRR 17.02%Assisted-living occupancy 99%, rates +2%, exit cap +25 bp: IRR 17.34%Assisted-living occupancy 100%, rates +2%, exit cap +25 bp: IRR 17.66%Assisted-living occupancy 86%, rates +3%, exit cap +25 bp: IRR 13.80%Assisted-living occupancy 87%, rates +3%, exit cap +25 bp: IRR 14.17%Assisted-living occupancy 88%, rates +3%, exit cap +25 bp: IRR 14.53%Assisted-living occupancy 89%, rates +3%, exit cap +25 bp: IRR 14.89%Assisted-living occupancy 90%, rates +3%, exit cap +25 bp: IRR 15.24%Assisted-living occupancy 91%, rates +3%, exit cap +25 bp: IRR 15.59%Assisted-living occupancy 92%, rates +3%, exit cap +25 bp: IRR 15.94%Assisted-living occupancy 93%, rates +3%, exit cap +25 bp: IRR 16.28%Assisted-living occupancy 94%, rates +3%, exit cap +25 bp: IRR 16.62%Assisted-living occupancy 95%, rates +3%, exit cap +25 bp: IRR 16.95%Assisted-living occupancy 96%, rates +3%, exit cap +25 bp: IRR 17.28%Assisted-living occupancy 97%, rates +3%, exit cap +25 bp: IRR 17.61%Assisted-living occupancy 98%, rates +3%, exit cap +25 bp: IRR 17.93%Assisted-living occupancy 99%, rates +3%, exit cap +25 bp: IRR 18.25%Assisted-living occupancy 100%, rates +3%, exit cap +25 bp: IRR 18.57%Assisted-living occupancy 86%, rates +4%, exit cap +25 bp: IRR 14.75%Assisted-living occupancy 87%, rates +4%, exit cap +25 bp: IRR 15.11%Assisted-living occupancy 88%, rates +4%, exit cap +25 bp: IRR 15.47%Assisted-living occupancy 89%, rates +4%, exit cap +25 bp: IRR 15.82%Assisted-living occupancy 90%, rates +4%, exit cap +25 bp: IRR 16.17%Assisted-living occupancy 91%, rates +4%, exit cap +25 bp: IRR 16.51%Assisted-living occupancy 92%, rates +4%, exit cap +25 bp: IRR 16.85%Assisted-living occupancy 93%, rates +4%, exit cap +25 bp: IRR 17.19%Assisted-living occupancy 94%, rates +4%, exit cap +25 bp: IRR 17.52%Assisted-living occupancy 95%, rates +4%, exit cap +25 bp: IRR 17.85%Assisted-living occupancy 96%, rates +4%, exit cap +25 bp: IRR 18.18%Assisted-living occupancy 97%, rates +4%, exit cap +25 bp: IRR 18.50%Assisted-living occupancy 98%, rates +4%, exit cap +25 bp: IRR 18.82%Assisted-living occupancy 99%, rates +4%, exit cap +25 bp: IRR 19.14%Assisted-living occupancy 100%, rates +4%, exit cap +25 bp: IRR 19.46%Assisted-living occupancy 86%, rates +5%, exit cap +25 bp: IRR 15.67%Assisted-living occupancy 87%, rates +5%, exit cap +25 bp: IRR 16.03%Assisted-living occupancy 88%, rates +5%, exit cap +25 bp: IRR 16.38%Assisted-living occupancy 89%, rates +5%, exit cap +25 bp: IRR 16.73%Assisted-living occupancy 90%, rates +5%, exit cap +25 bp: IRR 17.07%Assisted-living occupancy 91%, rates +5%, exit cap +25 bp: IRR 17.41%Assisted-living occupancy 92%, rates +5%, exit cap +25 bp: IRR 17.75%Assisted-living occupancy 93%, rates +5%, exit cap +25 bp: IRR 18.08%Assisted-living occupancy 94%, rates +5%, exit cap +25 bp: IRR 18.41%Assisted-living occupancy 95%, rates +5%, exit cap +25 bp: IRR 18.74%Assisted-living occupancy 96%, rates +5%, exit cap +25 bp: IRR 19.06%Assisted-living occupancy 97%, rates +5%, exit cap +25 bp: IRR 19.38%Assisted-living occupancy 98%, rates +5%, exit cap +25 bp: IRR 19.70%Assisted-living occupancy 99%, rates +5%, exit cap +25 bp: IRR 20.01%Assisted-living occupancy 100%, rates +5%, exit cap +25 bp: IRR 20.32%

Exit cap +25 bp
57 of 165 clear

Assisted-living occupancy 86%, rates −5%, exit cap +37.5 bp: IRR 4.87%Assisted-living occupancy 87%, rates −5%, exit cap +37.5 bp: IRR 5.22%Assisted-living occupancy 88%, rates −5%, exit cap +37.5 bp: IRR 5.59%Assisted-living occupancy 89%, rates −5%, exit cap +37.5 bp: IRR 5.95%Assisted-living occupancy 90%, rates −5%, exit cap +37.5 bp: IRR 6.32%Assisted-living occupancy 91%, rates −5%, exit cap +37.5 bp: IRR 6.69%Assisted-living occupancy 92%, rates −5%, exit cap +37.5 bp: IRR 7.07%Assisted-living occupancy 93%, rates −5%, exit cap +37.5 bp: IRR 7.45%Assisted-living occupancy 94%, rates −5%, exit cap +37.5 bp: IRR 7.84%Assisted-living occupancy 95%, rates −5%, exit cap +37.5 bp: IRR 8.23%Assisted-living occupancy 96%, rates −5%, exit cap +37.5 bp: IRR 8.62%Assisted-living occupancy 97%, rates −5%, exit cap +37.5 bp: IRR 9.02%Assisted-living occupancy 98%, rates −5%, exit cap +37.5 bp: IRR 9.43%Assisted-living occupancy 99%, rates −5%, exit cap +37.5 bp: IRR 9.84%Assisted-living occupancy 100%, rates −5%, exit cap +37.5 bp: IRR 10.22%Assisted-living occupancy 86%, rates −4%, exit cap +37.5 bp: IRR 5.92%Assisted-living occupancy 87%, rates −4%, exit cap +37.5 bp: IRR 6.29%Assisted-living occupancy 88%, rates −4%, exit cap +37.5 bp: IRR 6.67%Assisted-living occupancy 89%, rates −4%, exit cap +37.5 bp: IRR 7.05%Assisted-living occupancy 90%, rates −4%, exit cap +37.5 bp: IRR 7.44%Assisted-living occupancy 91%, rates −4%, exit cap +37.5 bp: IRR 7.83%Assisted-living occupancy 92%, rates −4%, exit cap +37.5 bp: IRR 8.23%Assisted-living occupancy 93%, rates −4%, exit cap +37.5 bp: IRR 8.63%Assisted-living occupancy 94%, rates −4%, exit cap +37.5 bp: IRR 9.04%Assisted-living occupancy 95%, rates −4%, exit cap +37.5 bp: IRR 9.46%Assisted-living occupancy 96%, rates −4%, exit cap +37.5 bp: IRR 9.87%Assisted-living occupancy 97%, rates −4%, exit cap +37.5 bp: IRR 10.25%Assisted-living occupancy 98%, rates −4%, exit cap +37.5 bp: IRR 10.63%Assisted-living occupancy 99%, rates −4%, exit cap +37.5 bp: IRR 11.00%Assisted-living occupancy 100%, rates −4%, exit cap +37.5 bp: IRR 11.36%Assisted-living occupancy 86%, rates −3%, exit cap +37.5 bp: IRR 7.00%Assisted-living occupancy 87%, rates −3%, exit cap +37.5 bp: IRR 7.39%Assisted-living occupancy 88%, rates −3%, exit cap +37.5 bp: IRR 7.79%Assisted-living occupancy 89%, rates −3%, exit cap +37.5 bp: IRR 8.19%Assisted-living occupancy 90%, rates −3%, exit cap +37.5 bp: IRR 8.60%Assisted-living occupancy 91%, rates −3%, exit cap +37.5 bp: IRR 9.02%Assisted-living occupancy 92%, rates −3%, exit cap +37.5 bp: IRR 9.44%Assisted-living occupancy 93%, rates −3%, exit cap +37.5 bp: IRR 9.87%Assisted-living occupancy 94%, rates −3%, exit cap +37.5 bp: IRR 10.25%Assisted-living occupancy 95%, rates −3%, exit cap +37.5 bp: IRR 10.63%Assisted-living occupancy 96%, rates −3%, exit cap +37.5 bp: IRR 11.01%Assisted-living occupancy 97%, rates −3%, exit cap +37.5 bp: IRR 11.38%Assisted-living occupancy 98%, rates −3%, exit cap +37.5 bp: IRR 11.74%Assisted-living occupancy 99%, rates −3%, exit cap +37.5 bp: IRR 12.10%Assisted-living occupancy 100%, rates −3%, exit cap +37.5 bp: IRR 12.45%Assisted-living occupancy 86%, rates −2%, exit cap +37.5 bp: IRR 8.12%Assisted-living occupancy 87%, rates −2%, exit cap +37.5 bp: IRR 8.54%Assisted-living occupancy 88%, rates −2%, exit cap +37.5 bp: IRR 8.96%Assisted-living occupancy 89%, rates −2%, exit cap +37.5 bp: IRR 9.39%Assisted-living occupancy 90%, rates −2%, exit cap +37.5 bp: IRR 9.82%Assisted-living occupancy 91%, rates −2%, exit cap +37.5 bp: IRR 10.22%Assisted-living occupancy 92%, rates −2%, exit cap +37.5 bp: IRR 10.61%Assisted-living occupancy 93%, rates −2%, exit cap +37.5 bp: IRR 10.99%Assisted-living occupancy 94%, rates −2%, exit cap +37.5 bp: IRR 11.36%Assisted-living occupancy 95%, rates −2%, exit cap +37.5 bp: IRR 11.73%Assisted-living occupancy 96%, rates −2%, exit cap +37.5 bp: IRR 12.10%Assisted-living occupancy 97%, rates −2%, exit cap +37.5 bp: IRR 12.46%Assisted-living occupancy 98%, rates −2%, exit cap +37.5 bp: IRR 12.81%Assisted-living occupancy 99%, rates −2%, exit cap +37.5 bp: IRR 13.16%Assisted-living occupancy 100%, rates −2%, exit cap +37.5 bp: IRR 13.51%Assisted-living occupancy 86%, rates −1%, exit cap +37.5 bp: IRR 9.29%Assisted-living occupancy 87%, rates −1%, exit cap +37.5 bp: IRR 9.73%Assisted-living occupancy 88%, rates −1%, exit cap +37.5 bp: IRR 10.15%Assisted-living occupancy 89%, rates −1%, exit cap +37.5 bp: IRR 10.54%Assisted-living occupancy 90%, rates −1%, exit cap +37.5 bp: IRR 10.93%Assisted-living occupancy 91%, rates −1%, exit cap +37.5 bp: IRR 11.32%Assisted-living occupancy 92%, rates −1%, exit cap +37.5 bp: IRR 11.69%Assisted-living occupancy 93%, rates −1%, exit cap +37.5 bp: IRR 12.07%Assisted-living occupancy 94%, rates −1%, exit cap +37.5 bp: IRR 12.43%Assisted-living occupancy 95%, rates −1%, exit cap +37.5 bp: IRR 12.79%Assisted-living occupancy 96%, rates −1%, exit cap +37.5 bp: IRR 13.15%Assisted-living occupancy 97%, rates −1%, exit cap +37.5 bp: IRR 13.50%Assisted-living occupancy 98%, rates −1%, exit cap +37.5 bp: IRR 13.85%Assisted-living occupancy 99%, rates −1%, exit cap +37.5 bp: IRR 14.19%Assisted-living occupancy 100%, rates −1%, exit cap +37.5 bp: IRR 14.53%Assisted-living occupancy 86%, rates 0%, exit cap +37.5 bp: IRR 10.44%Assisted-living occupancy 87%, rates 0%, exit cap +37.5 bp: IRR 10.84%Assisted-living occupancy 88%, rates 0%, exit cap +37.5 bp: IRR 11.23%Assisted-living occupancy 89%, rates 0%, exit cap +37.5 bp: IRR 11.62%Assisted-living occupancy 90%, rates 0%, exit cap +37.5 bp: IRR 12.00%Assisted-living occupancy 91%, rates 0%, exit cap +37.5 bp: IRR 12.37%Assisted-living occupancy 92%, rates 0%, exit cap +37.5 bp: IRR 12.74%Assisted-living occupancy 93%, rates 0%, exit cap +37.5 bp: IRR 13.10%Assisted-living occupancy 94%, rates 0%, exit cap +37.5 bp: IRR 13.46%Assisted-living occupancy 95%, rates 0%, exit cap +37.5 bp: IRR 13.81%Assisted-living occupancy 96%, rates 0%, exit cap +37.5 bp: IRR 14.16%Assisted-living occupancy 97%, rates 0%, exit cap +37.5 bp: IRR 14.51%Assisted-living occupancy 98%, rates 0%, exit cap +37.5 bp: IRR 14.85%Assisted-living occupancy 99%, rates 0%, exit cap +37.5 bp: IRR 15.19%Assisted-living occupancy 100%, rates 0%, exit cap +37.5 bp: IRR 15.52%Assisted-living occupancy 86%, rates +1%, exit cap +37.5 bp: IRR 11.51%Assisted-living occupancy 87%, rates +1%, exit cap +37.5 bp: IRR 11.90%Assisted-living occupancy 88%, rates +1%, exit cap +37.5 bp: IRR 12.28%Assisted-living occupancy 89%, rates +1%, exit cap +37.5 bp: IRR 12.65%Assisted-living occupancy 90%, rates +1%, exit cap +37.5 bp: IRR 13.02%Assisted-living occupancy 91%, rates +1%, exit cap +37.5 bp: IRR 13.39%Assisted-living occupancy 92%, rates +1%, exit cap +37.5 bp: IRR 13.75%Assisted-living occupancy 93%, rates +1%, exit cap +37.5 bp: IRR 14.10%Assisted-living occupancy 94%, rates +1%, exit cap +37.5 bp: IRR 14.46%Assisted-living occupancy 95%, rates +1%, exit cap +37.5 bp: IRR 14.80%Assisted-living occupancy 96%, rates +1%, exit cap +37.5 bp: IRR 15.15%Assisted-living occupancy 97%, rates +1%, exit cap +37.5 bp: IRR 15.48%Assisted-living occupancy 98%, rates +1%, exit cap +37.5 bp: IRR 15.82%Assisted-living occupancy 99%, rates +1%, exit cap +37.5 bp: IRR 16.15%Assisted-living occupancy 100%, rates +1%, exit cap +37.5 bp: IRR 16.48%Assisted-living occupancy 86%, rates +2%, exit cap +37.5 bp: IRR 12.53%Assisted-living occupancy 87%, rates +2%, exit cap +37.5 bp: IRR 12.91%Assisted-living occupancy 88%, rates +2%, exit cap +37.5 bp: IRR 13.28%Assisted-living occupancy 89%, rates +2%, exit cap +37.5 bp: IRR 13.65%Assisted-living occupancy 90%, rates +2%, exit cap +37.5 bp: IRR 14.01%Assisted-living occupancy 91%, rates +2%, exit cap +37.5 bp: IRR 14.37%Assisted-living occupancy 92%, rates +2%, exit cap +37.5 bp: IRR 14.73%Assisted-living occupancy 93%, rates +2%, exit cap +37.5 bp: IRR 15.08%Assisted-living occupancy 94%, rates +2%, exit cap +37.5 bp: IRR 15.42%Assisted-living occupancy 95%, rates +2%, exit cap +37.5 bp: IRR 15.76%Assisted-living occupancy 96%, rates +2%, exit cap +37.5 bp: IRR 16.10%Assisted-living occupancy 97%, rates +2%, exit cap +37.5 bp: IRR 16.43%Assisted-living occupancy 98%, rates +2%, exit cap +37.5 bp: IRR 16.76%Assisted-living occupancy 99%, rates +2%, exit cap +37.5 bp: IRR 17.09%Assisted-living occupancy 100%, rates +2%, exit cap +37.5 bp: IRR 17.41%Assisted-living occupancy 86%, rates +3%, exit cap +37.5 bp: IRR 13.52%Assisted-living occupancy 87%, rates +3%, exit cap +37.5 bp: IRR 13.89%Assisted-living occupancy 88%, rates +3%, exit cap +37.5 bp: IRR 14.26%Assisted-living occupancy 89%, rates +3%, exit cap +37.5 bp: IRR 14.62%Assisted-living occupancy 90%, rates +3%, exit cap +37.5 bp: IRR 14.97%Assisted-living occupancy 91%, rates +3%, exit cap +37.5 bp: IRR 15.33%Assisted-living occupancy 92%, rates +3%, exit cap +37.5 bp: IRR 15.67%Assisted-living occupancy 93%, rates +3%, exit cap +37.5 bp: IRR 16.02%Assisted-living occupancy 94%, rates +3%, exit cap +37.5 bp: IRR 16.36%Assisted-living occupancy 95%, rates +3%, exit cap +37.5 bp: IRR 16.69%Assisted-living occupancy 96%, rates +3%, exit cap +37.5 bp: IRR 17.03%Assisted-living occupancy 97%, rates +3%, exit cap +37.5 bp: IRR 17.36%Assisted-living occupancy 98%, rates +3%, exit cap +37.5 bp: IRR 17.68%Assisted-living occupancy 99%, rates +3%, exit cap +37.5 bp: IRR 18.00%Assisted-living occupancy 100%, rates +3%, exit cap +37.5 bp: IRR 18.32%Assisted-living occupancy 86%, rates +4%, exit cap +37.5 bp: IRR 14.48%Assisted-living occupancy 87%, rates +4%, exit cap +37.5 bp: IRR 14.84%Assisted-living occupancy 88%, rates +4%, exit cap +37.5 bp: IRR 15.20%Assisted-living occupancy 89%, rates +4%, exit cap +37.5 bp: IRR 15.56%Assisted-living occupancy 90%, rates +4%, exit cap +37.5 bp: IRR 15.91%Assisted-living occupancy 91%, rates +4%, exit cap +37.5 bp: IRR 16.25%Assisted-living occupancy 92%, rates +4%, exit cap +37.5 bp: IRR 16.60%Assisted-living occupancy 93%, rates +4%, exit cap +37.5 bp: IRR 16.94%Assisted-living occupancy 94%, rates +4%, exit cap +37.5 bp: IRR 17.27%Assisted-living occupancy 95%, rates +4%, exit cap +37.5 bp: IRR 17.60%Assisted-living occupancy 96%, rates +4%, exit cap +37.5 bp: IRR 17.93%Assisted-living occupancy 97%, rates +4%, exit cap +37.5 bp: IRR 18.26%Assisted-living occupancy 98%, rates +4%, exit cap +37.5 bp: IRR 18.58%Assisted-living occupancy 99%, rates +4%, exit cap +37.5 bp: IRR 18.90%Assisted-living occupancy 100%, rates +4%, exit cap +37.5 bp: IRR 19.21%Assisted-living occupancy 86%, rates +5%, exit cap +37.5 bp: IRR 15.41%Assisted-living occupancy 87%, rates +5%, exit cap +37.5 bp: IRR 15.77%Assisted-living occupancy 88%, rates +5%, exit cap +37.5 bp: IRR 16.12%Assisted-living occupancy 89%, rates +5%, exit cap +37.5 bp: IRR 16.47%Assisted-living occupancy 90%, rates +5%, exit cap +37.5 bp: IRR 16.82%Assisted-living occupancy 91%, rates +5%, exit cap +37.5 bp: IRR 17.16%Assisted-living occupancy 92%, rates +5%, exit cap +37.5 bp: IRR 17.50%Assisted-living occupancy 93%, rates +5%, exit cap +37.5 bp: IRR 17.83%Assisted-living occupancy 94%, rates +5%, exit cap +37.5 bp: IRR 18.16%Assisted-living occupancy 95%, rates +5%, exit cap +37.5 bp: IRR 18.49%Assisted-living occupancy 96%, rates +5%, exit cap +37.5 bp: IRR 18.82%Assisted-living occupancy 97%, rates +5%, exit cap +37.5 bp: IRR 19.14%Assisted-living occupancy 98%, rates +5%, exit cap +37.5 bp: IRR 19.46%Assisted-living occupancy 99%, rates +5%, exit cap +37.5 bp: IRR 19.77%Assisted-living occupancy 100%, rates +5%, exit cap +37.5 bp: IRR 20.09%

Exit cap +37.5 bp
53 of 165 clear

Assisted-living occupancy 86%, rates −5%, exit cap +50 bp: IRR 4.56%Assisted-living occupancy 87%, rates −5%, exit cap +50 bp: IRR 4.92%Assisted-living occupancy 88%, rates −5%, exit cap +50 bp: IRR 5.28%Assisted-living occupancy 89%, rates −5%, exit cap +50 bp: IRR 5.65%Assisted-living occupancy 90%, rates −5%, exit cap +50 bp: IRR 6.01%Assisted-living occupancy 91%, rates −5%, exit cap +50 bp: IRR 6.39%Assisted-living occupancy 92%, rates −5%, exit cap +50 bp: IRR 6.76%Assisted-living occupancy 93%, rates −5%, exit cap +50 bp: IRR 7.14%Assisted-living occupancy 94%, rates −5%, exit cap +50 bp: IRR 7.53%Assisted-living occupancy 95%, rates −5%, exit cap +50 bp: IRR 7.92%Assisted-living occupancy 96%, rates −5%, exit cap +50 bp: IRR 8.31%Assisted-living occupancy 97%, rates −5%, exit cap +50 bp: IRR 8.71%Assisted-living occupancy 98%, rates −5%, exit cap +50 bp: IRR 9.12%Assisted-living occupancy 99%, rates −5%, exit cap +50 bp: IRR 9.53%Assisted-living occupancy 100%, rates −5%, exit cap +50 bp: IRR 9.91%Assisted-living occupancy 86%, rates −4%, exit cap +50 bp: IRR 5.61%Assisted-living occupancy 87%, rates −4%, exit cap +50 bp: IRR 5.99%Assisted-living occupancy 88%, rates −4%, exit cap +50 bp: IRR 6.36%Assisted-living occupancy 89%, rates −4%, exit cap +50 bp: IRR 6.75%Assisted-living occupancy 90%, rates −4%, exit cap +50 bp: IRR 7.13%Assisted-living occupancy 91%, rates −4%, exit cap +50 bp: IRR 7.52%Assisted-living occupancy 92%, rates −4%, exit cap +50 bp: IRR 7.92%Assisted-living occupancy 93%, rates −4%, exit cap +50 bp: IRR 8.32%Assisted-living occupancy 94%, rates −4%, exit cap +50 bp: IRR 8.73%Assisted-living occupancy 95%, rates −4%, exit cap +50 bp: IRR 9.15%Assisted-living occupancy 96%, rates −4%, exit cap +50 bp: IRR 9.56%Assisted-living occupancy 97%, rates −4%, exit cap +50 bp: IRR 9.95%Assisted-living occupancy 98%, rates −4%, exit cap +50 bp: IRR 10.33%Assisted-living occupancy 99%, rates −4%, exit cap +50 bp: IRR 10.70%Assisted-living occupancy 100%, rates −4%, exit cap +50 bp: IRR 11.06%Assisted-living occupancy 86%, rates −3%, exit cap +50 bp: IRR 6.69%Assisted-living occupancy 87%, rates −3%, exit cap +50 bp: IRR 7.09%Assisted-living occupancy 88%, rates −3%, exit cap +50 bp: IRR 7.48%Assisted-living occupancy 89%, rates −3%, exit cap +50 bp: IRR 7.89%Assisted-living occupancy 90%, rates −3%, exit cap +50 bp: IRR 8.30%Assisted-living occupancy 91%, rates −3%, exit cap +50 bp: IRR 8.71%Assisted-living occupancy 92%, rates −3%, exit cap +50 bp: IRR 9.13%Assisted-living occupancy 93%, rates −3%, exit cap +50 bp: IRR 9.56%Assisted-living occupancy 94%, rates −3%, exit cap +50 bp: IRR 9.95%Assisted-living occupancy 95%, rates −3%, exit cap +50 bp: IRR 10.33%Assisted-living occupancy 96%, rates −3%, exit cap +50 bp: IRR 10.71%Assisted-living occupancy 97%, rates −3%, exit cap +50 bp: IRR 11.08%Assisted-living occupancy 98%, rates −3%, exit cap +50 bp: IRR 11.45%Assisted-living occupancy 99%, rates −3%, exit cap +50 bp: IRR 11.81%Assisted-living occupancy 100%, rates −3%, exit cap +50 bp: IRR 12.17%Assisted-living occupancy 86%, rates −2%, exit cap +50 bp: IRR 7.81%Assisted-living occupancy 87%, rates −2%, exit cap +50 bp: IRR 8.23%Assisted-living occupancy 88%, rates −2%, exit cap +50 bp: IRR 8.65%Assisted-living occupancy 89%, rates −2%, exit cap +50 bp: IRR 9.08%Assisted-living occupancy 90%, rates −2%, exit cap +50 bp: IRR 9.51%Assisted-living occupancy 91%, rates −2%, exit cap +50 bp: IRR 9.91%Assisted-living occupancy 92%, rates −2%, exit cap +50 bp: IRR 10.30%Assisted-living occupancy 93%, rates −2%, exit cap +50 bp: IRR 10.69%Assisted-living occupancy 94%, rates −2%, exit cap +50 bp: IRR 11.07%Assisted-living occupancy 95%, rates −2%, exit cap +50 bp: IRR 11.44%Assisted-living occupancy 96%, rates −2%, exit cap +50 bp: IRR 11.81%Assisted-living occupancy 97%, rates −2%, exit cap +50 bp: IRR 12.18%Assisted-living occupancy 98%, rates −2%, exit cap +50 bp: IRR 12.53%Assisted-living occupancy 99%, rates −2%, exit cap +50 bp: IRR 12.89%Assisted-living occupancy 100%, rates −2%, exit cap +50 bp: IRR 13.23%Assisted-living occupancy 86%, rates −1%, exit cap +50 bp: IRR 8.98%Assisted-living occupancy 87%, rates −1%, exit cap +50 bp: IRR 9.42%Assisted-living occupancy 88%, rates −1%, exit cap +50 bp: IRR 9.84%Assisted-living occupancy 89%, rates −1%, exit cap +50 bp: IRR 10.24%Assisted-living occupancy 90%, rates −1%, exit cap +50 bp: IRR 10.63%Assisted-living occupancy 91%, rates −1%, exit cap +50 bp: IRR 11.02%Assisted-living occupancy 92%, rates −1%, exit cap +50 bp: IRR 11.40%Assisted-living occupancy 93%, rates −1%, exit cap +50 bp: IRR 11.78%Assisted-living occupancy 94%, rates −1%, exit cap +50 bp: IRR 12.15%Assisted-living occupancy 95%, rates −1%, exit cap +50 bp: IRR 12.51%Assisted-living occupancy 96%, rates −1%, exit cap +50 bp: IRR 12.87%Assisted-living occupancy 97%, rates −1%, exit cap +50 bp: IRR 13.23%Assisted-living occupancy 98%, rates −1%, exit cap +50 bp: IRR 13.58%Assisted-living occupancy 99%, rates −1%, exit cap +50 bp: IRR 13.92%Assisted-living occupancy 100%, rates −1%, exit cap +50 bp: IRR 14.26%Assisted-living occupancy 86%, rates 0%, exit cap +50 bp: IRR 10.14%Assisted-living occupancy 87%, rates 0%, exit cap +50 bp: IRR 10.54%Assisted-living occupancy 88%, rates 0%, exit cap +50 bp: IRR 10.94%Assisted-living occupancy 89%, rates 0%, exit cap +50 bp: IRR 11.33%Assisted-living occupancy 90%, rates 0%, exit cap +50 bp: IRR 11.71%Assisted-living occupancy 91%, rates 0%, exit cap +50 bp: IRR 12.08%Assisted-living occupancy 92%, rates 0%, exit cap +50 bp: IRR 12.46%Assisted-living occupancy 93%, rates 0%, exit cap +50 bp: IRR 12.82%Assisted-living occupancy 94%, rates 0%, exit cap +50 bp: IRR 13.18%Assisted-living occupancy 95%, rates 0%, exit cap +50 bp: IRR 13.54%Assisted-living occupancy 96%, rates 0%, exit cap +50 bp: IRR 13.89%Assisted-living occupancy 97%, rates 0%, exit cap +50 bp: IRR 14.24%Assisted-living occupancy 98%, rates 0%, exit cap +50 bp: IRR 14.58%Assisted-living occupancy 99%, rates 0%, exit cap +50 bp: IRR 14.92%Assisted-living occupancy 100%, rates 0%, exit cap +50 bp: IRR 15.26%Assisted-living occupancy 86%, rates +1%, exit cap +50 bp: IRR 11.21%Assisted-living occupancy 87%, rates +1%, exit cap +50 bp: IRR 11.60%Assisted-living occupancy 88%, rates +1%, exit cap +50 bp: IRR 11.99%Assisted-living occupancy 89%, rates +1%, exit cap +50 bp: IRR 12.37%Assisted-living occupancy 90%, rates +1%, exit cap +50 bp: IRR 12.74%Assisted-living occupancy 91%, rates +1%, exit cap +50 bp: IRR 13.11%Assisted-living occupancy 92%, rates +1%, exit cap +50 bp: IRR 13.47%Assisted-living occupancy 93%, rates +1%, exit cap +50 bp: IRR 13.83%Assisted-living occupancy 94%, rates +1%, exit cap +50 bp: IRR 14.19%Assisted-living occupancy 95%, rates +1%, exit cap +50 bp: IRR 14.54%Assisted-living occupancy 96%, rates +1%, exit cap +50 bp: IRR 14.88%Assisted-living occupancy 97%, rates +1%, exit cap +50 bp: IRR 15.22%Assisted-living occupancy 98%, rates +1%, exit cap +50 bp: IRR 15.56%Assisted-living occupancy 99%, rates +1%, exit cap +50 bp: IRR 15.89%Assisted-living occupancy 100%, rates +1%, exit cap +50 bp: IRR 16.22%Assisted-living occupancy 86%, rates +2%, exit cap +50 bp: IRR 12.25%Assisted-living occupancy 87%, rates +2%, exit cap +50 bp: IRR 12.63%Assisted-living occupancy 88%, rates +2%, exit cap +50 bp: IRR 13.00%Assisted-living occupancy 89%, rates +2%, exit cap +50 bp: IRR 13.38%Assisted-living occupancy 90%, rates +2%, exit cap +50 bp: IRR 13.74%Assisted-living occupancy 91%, rates +2%, exit cap +50 bp: IRR 14.10%Assisted-living occupancy 92%, rates +2%, exit cap +50 bp: IRR 14.46%Assisted-living occupancy 93%, rates +2%, exit cap +50 bp: IRR 14.81%Assisted-living occupancy 94%, rates +2%, exit cap +50 bp: IRR 15.16%Assisted-living occupancy 95%, rates +2%, exit cap +50 bp: IRR 15.50%Assisted-living occupancy 96%, rates +2%, exit cap +50 bp: IRR 15.84%Assisted-living occupancy 97%, rates +2%, exit cap +50 bp: IRR 16.18%Assisted-living occupancy 98%, rates +2%, exit cap +50 bp: IRR 16.51%Assisted-living occupancy 99%, rates +2%, exit cap +50 bp: IRR 16.84%Assisted-living occupancy 100%, rates +2%, exit cap +50 bp: IRR 17.17%Assisted-living occupancy 86%, rates +3%, exit cap +50 bp: IRR 13.24%Assisted-living occupancy 87%, rates +3%, exit cap +50 bp: IRR 13.62%Assisted-living occupancy 88%, rates +3%, exit cap +50 bp: IRR 13.99%Assisted-living occupancy 89%, rates +3%, exit cap +50 bp: IRR 14.35%Assisted-living occupancy 90%, rates +3%, exit cap +50 bp: IRR 14.71%Assisted-living occupancy 91%, rates +3%, exit cap +50 bp: IRR 15.06%Assisted-living occupancy 92%, rates +3%, exit cap +50 bp: IRR 15.41%Assisted-living occupancy 93%, rates +3%, exit cap +50 bp: IRR 15.76%Assisted-living occupancy 94%, rates +3%, exit cap +50 bp: IRR 16.10%Assisted-living occupancy 95%, rates +3%, exit cap +50 bp: IRR 16.44%Assisted-living occupancy 96%, rates +3%, exit cap +50 bp: IRR 16.78%Assisted-living occupancy 97%, rates +3%, exit cap +50 bp: IRR 17.11%Assisted-living occupancy 98%, rates +3%, exit cap +50 bp: IRR 17.44%Assisted-living occupancy 99%, rates +3%, exit cap +50 bp: IRR 17.76%Assisted-living occupancy 100%, rates +3%, exit cap +50 bp: IRR 18.08%Assisted-living occupancy 86%, rates +4%, exit cap +50 bp: IRR 14.21%Assisted-living occupancy 87%, rates +4%, exit cap +50 bp: IRR 14.58%Assisted-living occupancy 88%, rates +4%, exit cap +50 bp: IRR 14.94%Assisted-living occupancy 89%, rates +4%, exit cap +50 bp: IRR 15.30%Assisted-living occupancy 90%, rates +4%, exit cap +50 bp: IRR 15.65%Assisted-living occupancy 91%, rates +4%, exit cap +50 bp: IRR 16.00%Assisted-living occupancy 92%, rates +4%, exit cap +50 bp: IRR 16.34%Assisted-living occupancy 93%, rates +4%, exit cap +50 bp: IRR 16.68%Assisted-living occupancy 94%, rates +4%, exit cap +50 bp: IRR 17.02%Assisted-living occupancy 95%, rates +4%, exit cap +50 bp: IRR 17.36%Assisted-living occupancy 96%, rates +4%, exit cap +50 bp: IRR 17.69%Assisted-living occupancy 97%, rates +4%, exit cap +50 bp: IRR 18.01%Assisted-living occupancy 98%, rates +4%, exit cap +50 bp: IRR 18.34%Assisted-living occupancy 99%, rates +4%, exit cap +50 bp: IRR 18.66%Assisted-living occupancy 100%, rates +4%, exit cap +50 bp: IRR 18.98%Assisted-living occupancy 86%, rates +5%, exit cap +50 bp: IRR 15.15%Assisted-living occupancy 87%, rates +5%, exit cap +50 bp: IRR 15.51%Assisted-living occupancy 88%, rates +5%, exit cap +50 bp: IRR 15.86%Assisted-living occupancy 89%, rates +5%, exit cap +50 bp: IRR 16.22%Assisted-living occupancy 90%, rates +5%, exit cap +50 bp: IRR 16.56%Assisted-living occupancy 91%, rates +5%, exit cap +50 bp: IRR 16.91%Assisted-living occupancy 92%, rates +5%, exit cap +50 bp: IRR 17.25%Assisted-living occupancy 93%, rates +5%, exit cap +50 bp: IRR 17.59%Assisted-living occupancy 94%, rates +5%, exit cap +50 bp: IRR 17.92%Assisted-living occupancy 95%, rates +5%, exit cap +50 bp: IRR 18.25%Assisted-living occupancy 96%, rates +5%, exit cap +50 bp: IRR 18.58%Assisted-living occupancy 97%, rates +5%, exit cap +50 bp: IRR 18.90%Assisted-living occupancy 98%, rates +5%, exit cap +50 bp: IRR 19.22%Assisted-living occupancy 99%, rates +5%, exit cap +50 bp: IRR 19.54%Assisted-living occupancy 100%, rates +5%, exit cap +50 bp: IRR 19.85%

Exit cap +50 bp
49 of 165 clear

clears a 15% IRRfalls shortthe model as it stands: 94% occupied, 14.31% IRRacross: assisted-living occupancy, 86% to 100%up: resident rates, −5% to +5%hover a square for its IRR

Three axes at once. Each grid is one exit-cap step, with assisted-living occupancy running across and resident rates running up. Every square is a full recompute of the model, and the 596 dark ones, out of 1,485, clear a 15 percent IRR.

3. Compare versions by logic and trace every move

Take one number, the General Partner’s IRR, and trace it all the way back to occupancy. That is 16 steps across sheets, each one named with its cell, laid out at once instead of sixteen clicks on Trace Precedents.

Each line reads the line below it.

Print Summary

  1. 1GP IRR, on the summary page21.43%H13

Cash Flow

  1. 2GP IRR21.43%C110
  2. 3GP net cash flow$6,293CT131
  3. 4GP total distribution$6,293CT129
  4. 5Project levered cash flow$62,928CT113
  5. 6Levered project cash flow$62,928CT98
  6. 7Unlevered cash flow$172,158CT84

Ops & Staffing

  1. 8Ownership-period operating cash flow$172,158CG151
  2. 9Net cash flow after reserve$172,158CG148
  3. 10Net operating income$188,576CG145
  4. 11Total revenue$642,331CG64
  5. 12Gross revenue$674,531CG61
  6. 13Assisted-living base resident revenue$284,783CG54
  7. 14Assisted-living occupied units51.7 unitsCG43
  8. 15Assisted-living occupancy94%CG42

Assumptions

  1. 16Assisted-living stabilized occupancy input94%D98
The GP’s IRR traced back to the occupancy input: 16 steps across four sheets, each with its cell address. Dollar amounts are one month of the hold.

Run this trace on the live model →

The same tracing works across versions. When a model comes back from a partner or a lender after weeks of edits, a cell-by-cell comparison floods you with thousands of false alarms because someone inserted two rows on the rent roll. With the logic separated from the layout, the comparison reads the formulas instead of the cells. A moved row is not a change. Suppose the partner sends the workbook back and the GP return has dropped. Instead of hunting through sheets line by line, you see whether they softened an assumption or rewrote a waterfall formula, because every output that moved traces back to one of the two. When I edited one formula in each of five of my own models and compared the two versions, every output that moved was traced back to that edit. None was left unexplained.

That is the line-by-line comparison every other programming language has had for forty years, arriving in the one language that decides $80 million acquisitions.


Will It Work on Your Model?

Everything above ran on models I built myself. The fair question is whether it works on yours: a workbook somebody else built over years, with hidden sheets, macros and a circular loop, that nobody is going to rebuild to suit a new tool.

Nobody has to. The workbook goes in as it is. On November 4, I timed one that other people built and that had never been set up to answer questions: about 140,000 formula cells across 21 sheets, with macros. From the raw file to an engine answering scenario questions took 13 minutes and 21 seconds. About three of those minutes were a person’s, spent picking which inputs are the deal’s drivers. The rest was the machine.

That was not one lucky file. The same route has now been run on 116 real underwriting workbooks that other people built, and 112 of them came through with no hand edits. The acquisition model from the table at the top, with its roughly 105,000 formulas, is one of them.

And “came through” means the strict thing: every formula cell equals the value Excel saved in the file. Close enough is useless in underwriting. If a waterfall cell is off by a cent, the analyst goes back to the spreadsheet.

Then there is next year. A model in its tenth year is not the file it was in its first: assumptions were retyped, rows inserted, sheets renamed, a formula rewritten here and there. Does every revision mean doing all of this again?

It means unzipping again, and that takes seconds. I tested this on my senior-living model by rewriting its formulas: fifty of them, then five hundred, then five thousand, about one in every ten, on every sheet. After the largest round, more than half of the model’s results had moved, and my edits had broken 241 cells, which now showed an error in Excel. Each time I handed the edited workbook back and did nothing else. Within sixteen seconds, a new engine agreed with Excel on all 52,148 formulas, the errors included, and every driver named the first time still answered to its name. Nothing is patched. The whole workbook is read and checked again each time, so five thousand rewritten formulas took about as long as fifty. The minutes a person spends picking the drivers are spent once.

If only those drivers changed, there is nothing to redo at all, because they are the engine’s inputs. When I also inserted rows and renamed a sheet, the names followed their cells to the new addresses in about 35 seconds, and that matching is laid out for a person to confirm before anyone relies on it. Either way, the saved scenarios run on both versions and show which outputs moved.


The Missing Layer

Every other programming language got its core machinery before it got an AI assistant. Excel got the assistant first. Right now, AI tools are trying to work with financial models by reading and dragging cells on a screen, the same way a tired analyst does at midnight, with the same fragility.

In real-estate underwriting, the logic of a deal lives locked inside tens of thousands of repeated cells. Until you unzip the workbook into the small program someone actually wrote, neither an AI nor a deal team can see the whole machine at once.

My 52,148-formula senior-living model is open in the Lab in two forms, read-only, nothing to install. On the Underwriting Desk, the engine answers scenario questions live, next to 5,001 scenarios across 20 assumptions that it ran ahead of time. In the Exploded Model View, the same model is the machine from the figure above: move one of five assumptions and watch the change travel through the pipes; every readout is one of 1,600 engine runs. Every deal team already has its own library of workbooks like this sitting on a shared drive. Once you see that a spreadsheet is a zip file, you do not go back to reading it cell by cell.

Disagree? Push back on this essay.不同意?来反驳这篇。

Ask MJ

Answers come only from what I’ve written. If it isn’t there, it says so.只根据我写过的内容回答;没写过的,它会说不知道。