Property
Save to track over time
Sensitivity
One question, on your own numbers: how does the projected levered return move as one of your assumptions moves? Enter your deal, pick an assumption to sweep, set the range, and read the return at each point.
Unit mix
One row per unit type: how many units, and the in-place rent each one carries per month. These roll up into gross potential rent.
Unit type 1
Purchase and financing
Income adjustments
Operating expenses (annual)
Hold and exit assumptions
What to sweep
Pick one assumption to vary. The table centers on the value you entered for it above, then steps out by the increment you set, both ways. You set the range; nothing is assumed.
Add at least one unit type with a count and a rent, enter a purchase price, a hold, and an exit cap, then set a step to sweep your chosen assumption.