scenario-stress-testerlisted

Runs 27 scenario permutations on an existing base case financial model to stress-test a multifamily or mixed-use CRE acquisition. Varies rent growth, expense growth, and exit cap rate across downside, base, and upside states, then calculates probability-weighted returns, identifies best and worst cases, runs stress tests against DSCR, cash flow, IRR, and principal thresholds, and ranks variable sensitivities by IRR spread. Use after a pro forma has been built (from the acquisition-model-builder skill or any equivalent source) and before the IC memo. Triggers include any request to "stress-test the deal," "run scenarios," "sensitivity analysis," "what if rent growth is lower," "how does the deal hold up in a downturn," or any attachment of a completed pro forma with deal terms. Default to this skill for any scenario, sensitivity, or stress-test request even if the user does not name it.
cre-ai-skills/CRE-AI-Skills · ★ 5 · AI & Automation · score 65

Install: claude install-skill cre-ai-skills/CRE-AI-Skills

# Scenario stress tester 27-scenario stress test with probability-weighted returns and variable sensitivity ranking, grounded in a completed base case pro forma. The skill takes a base case financial model (Years 1 through 5 NOI, debt service, and deal terms), systematically varies rent growth, expense growth, and exit cap rate across three states each, and produces a full scenario matrix, probability-weighted returns, stress test results, and a ranked sensitivity analysis showing which assumptions drive the most return variance. ## Scope Up to one scenario analysis per session. The analysis requires a completed base case pro forma as input; it does not build the pro forma from scratch. It does not replace a licensed appraiser's valuation or a lender's internal stress test. **This skill produces a scenario analysis, not an investment recommendation. Every scenario carries the assumptions it was built on and must be reviewed by a qualified professional before any capital commitment.** ## Security and confidentiality > All uploaded financial models, deal terms, and DD outputs are treated as confidential. Nothing is stored, forwarded, or used beyond this session. Handle the files as you would any material non-public deal information. ## How a session starts When the user requests a scenario analysis, respond with a single message containing the security note above, the three questions below, and the file and data request. **Q1. Objective** (multi-select, pick all that