Test one driver, two drivers, or several ranges. Find a supported input that reaches a selected target.
Change the question without losing the starting point. Each analysis helps you examine a different relationship.
Vary one input across a selected range and compare its effect on a return measure.
Test combinations of two inputs to see how they interact.
Compare driver effects over selected ranges to see which assumptions deserve attention.
This worked example varies construction cost per square foot. The base row stays marked so you can compare the effect on cost, equity, cash, and return.
One input changes: construction cost per SF.
| Cost/SF | Total cost | Equity | Annual cash | Cash-on-cash |
|---|---|---|---|---|
| $175 | $2,400,000 | $960,000 | $116,400 | 12.13% |
| $185Base case | $2,500,000 | $1,000,000 | $112,500 | 11.25% |
| $195 | $2,600,000 | $1,040,000 | $108,600 | 10.44% |
| $205 | $2,700,000 | $1,080,000 | $104,700 | 9.69% |
| $215 | $2,800,000 | $1,120,000 | $100,800 | 9.00% |
Total cost = 10,000 SF × Cost/SF + $650,000. Loan = total cost × 60%. Equity = total cost − loan. Annual cash = $210,000 NOI − loan × 6.5%. Cash-on-cash = annual cash ÷ equity.
The solver finds a supported input that reaches a selected result. Review the proposed change before applying it.
Choose the return measure and target you want to test. The target belongs to this question, not to every project.
Workflow illustration · This website does not run a solve.
Select a supported input, such as land price, and the range the solver can examine. Keep the rest of the plan in view.
Model's calculation engine evaluates the result.
Review the proposed input and resulting returns. Compare the plan, then choose whether to apply the change.
A target is an assumption to examine, not a prediction.
The proposed plans place one-way tests in Free, deeper comparisons in Pro, and two-way tests and the solver in Business. Packaging is under review.
No. It shows how the model responds to the assumptions you choose.
Yes. Select a supported input, range, and return measure. This website illustration uses a fixed range rather than running an analysis.