About this video
An analyst attaches their own multifamily pro forma to a conversation and runs one skill.
Full description
Rebuild of the classic stress-test demo on the current platform. An investment manager attaches a 110-unit San Francisco value-add pro forma straight into a thread, no data room, and runs the stress and sensitivity skill in plain English. Ellie builds a complete Python-based financial model of the deal and returns a six-sheet institutional workbook: four multi-factor scenarios, every sensitivity, the IC recommendation with a negotiating anchor at 13 percent below ask, and, on a follow-up question, the DSCR covenant break-even by year: revenue can fall 24.8 percent before 1.0x, binding in Year 4 where the loan flips to amortising.
Key points
- Attach the model you already have; no data room, no setup
- A complete Python-based financial model, computed not guessed
- Multi-factor scenarios and break-evens a two-variable data table cannot show
- The covenant question answered to the binding year in seconds
Transcript
This is a standard multifamily acquisition model. 110 units in San Francisco, a $36 million purchase, 10-year hold. To stress test this today, you adjust assumption cells, you build data tables, and you hunt for break even points by trial and error. And a data table moves two variables at a time. A real downturn moves the exit cap, income growth, and interest rates together. And notice where the file is. Not in a data room, not uploaded through a portal, attached straight into the conversation, the same workbook the analyst already has open.
Here is the deal. the purchase at 70% loan to value and a refinance at month 60, a two loan capital structure. Keep that in mind. It decides the whole stress story. One request in plain English, run the stress and sensitivity skill on the attachment. And under the hood, Ellie is not skimming the spreadsheet. She builds a complete financial model of the deal in Python, replicating the workbook's two loan structure. So every number that comes back is computed, not guessed.
Minutes later, a six sheet institutional workbook and a written read of what the numbers mean. The base case 13.3% levered IRR a 166 basis points short of the 15% target. The deal does not clear its hurdle on base assumptions. The sensitivities name the driver exit cap is the dominant variable and the cushion to the 10% floor is 18 basis points. a rounding error in market terms hold income growth flat and the return collapses to around 3%. This deal lives or dies on the renovation program delivering four scenarios moving all the drivers together 19% in the upside 5.3 in a moderate correction negative in a severe one and then the part a grid never gives you the IC recommendation the lever is price at 31.1 million 13% below ask the deal achieves its target that is the negotiating anchor now the question every lender conversation comes down to asked the way an analyst would type it.
What is the maximum revenue decline before breaking the 1.0 covenant? Ellie does not just divide two numbers. She walks the whole capital structure and finds the binding year, year four, when the acquisition loan flips from interest only to amortizing and debt service jumps 43%. Revenue can fall 24.8% before DSCR touches 1.0. And here is the cushion for every debt regime in the hold yearbyear. A 20% decline in year four still clears. 25 is a breach.
That used to be an afternoon of goal seek. It took seconds with the reasoning shown. And the deliverable is not a chat transcript. It is the workbook itself. The summary sheet, the property, the capital structure and all four scenarios colorcoded for the IC pack. every base case input laid out where a reviewer can challenge it. Seven single variable tables, an afternoon of Excel already built, the two variable matrices, a data table could never keep up with.
Base case marked in every grid. The full scenario logic written out, not just the numbers, and the break even sheet. The cushion on every key variable, each one flagged strong, thin, or miss. Instead of two-dimensional sensitivity tables, multifactor stress testing, instead of trial and error, automatic break even analysis down to the binding year, instead of raw numbers, an IC ready workbook and a negotiating anchor, that is how you make better investment decisions.
Portfolio intelligence across the fund
Video details
- Roles
- Portfolio Manager
- Processes
- Risk & Compliance, Acquisitions
- Geographies
- US
- Markets
- United States
- Tags
- multifamily-stress-test