Returns, sensitivity & scenarios
See what moves the deal before your investment committee does
Returns always on screen, a two-way grid and tornado, named what-ifs, and earlier versions of the deal: Copy an earlier version, Branch from a saved version, or Make this the base case. A linked copy offers Rebase when the original model changes.
Answer
How do I run a sensitivity analysis on a multifamily deal?
In CRE Build's Sensitivity section, pick a row variable and a column variable to build a two-way grid, or add variables to the tornado. Results read on levered IRR, LP IRR, equity multiple, profit, yield on cost or minimum DSCR, all from the same engine that runs the model.
Answer
What returns does CRE Build show?
A returns strip stays on screen with levered IRR, equity multiple, yield on cost (untrended and trended), average cash-on-cash, minimum DSCR, profit and peak equity. The Returns section adds unlevered IRR and multiple, debt yield, and contributions and distributions. Levered IRR is solved monthly and annualized.
What you do with it
Four ways to pressure-test a deal
The full Returns table
Levered and unlevered IRR, equity and unlevered multiple, profit, peak equity, yield on cost, untrended yield on cost, debt yield, average cash-on-cash, contributions and distributions.
Two-way grid and tornado
Pick a Row variable and a Column variable and read Levered IRR, LP IRR, equity multiple, profit, yield on cost or min DSCR across the grid. Add to the tornado to rank what matters.
Named what-ifs
Add what-if: named moves on variables, compared on the outputs you choose.
Earlier versions
Copy an earlier version, Branch from any saved version, and Make this the base case, all inside one deal. A linked copy offers Rebase when the original model changes.
Everything in one place
Everything returns and scenarios do
- Returns strip
- Returns
- Untrended yield on cost
- Sensitivity
- Row variable
- Column variable
- Add to the tornado
- Scenario analysis
- Add what-if
- Base case
- Branch from
- Rebase
- Make this the base case
- Copy an earlier version
Reports
Take the deal to committee
Report presets (Investor pack, Committee memo, Lender summary) are generated from the current version.
Explainer
Yield on cost, explained
What yield on cost and untrended yield on cost measure, and how they're calculated.
How it works
How it works
- 01
Read the strip
Seven KPIs, always visible.
- 02
Run the grid
Two variables, one output.
- 03
Name the what-ifs
Compare them on chosen outputs.
- 04
Branch a case
Rebase or make it the base case.
Methodology
How the math works
One calculation engine computes every figure in the model, and the methodology page shows how each one is calculated.
FAQ
Questions
What is the difference between a what-if and a scenario case?
A what-if is a named move on one or more variables, compared on the outputs you choose. A scenario case starts from an earlier version inside the deal: Copy an earlier version, Branch from a saved version, or Make this the base case.
Can a scenario case start from an earlier version?
Yes. Copy an earlier version or Branch from a saved version. The Versions section compares any two versions line by line.
Is peak equity shown with its month?
Yes. The methodology covers peak equity with its month, alongside levered IRR solved monthly and the equity multiple.
Pricing
Explore
Related features
Related feature
Reports & Excel export
Investor packs, committee memos and lender summaries, plus an Excel snapshot.
Explore →Related feature
Versions & compare
Save versions, compare them line by line, and restore any one.
Explore →Related feature
Debt & loan sizing
Size the loan the lender will actually give, and see the binding test.
Explore →