Variables
You can set either axis to any of these variables:- Exit cap rate
- Sale price
- Hold period
Output metrics
The matrix shows one of these metrics per cell:- LP IRR
- LP equity multiple
- Net proceeds
Color coding
Cells are color coded automatically:- Green — strong returns
- Amber — moderate returns
- Red — weak or negative returns
How to run
- Go to Scenarios and click Sensitivity
- Choose row and column variables
- Set the center value and step size for each axis
- Select the output metric
- The matrix populates instantly from your baseline scenario