Three-Scenario Feasibility Study for Real Estate Capital Structures
Real Estate · New Jersey, United States

A developer was weighing three real acquisition paths for the same project: a 17-unit property at $1.005 million with 11 units still to build, a larger 28-unit version at the same purchase price with 22 to build, and a smaller, already completed 4-unit property at $355,000, a lower-risk alternative to the other two.
He didn’t just want a one-time comparison, he wanted a live tool detailing all three scenarios in full, one he could bring into investor meetings and use on the spot to test assumptions and adjust variables in real time.
Each path needed to be modelled as its own complete development case, not a variation on a shared template. The 17-unit and 28-unit scenarios each carried their own construction budget and build-out timeline for the units still to be built, while the 4-unit scenario, already complete, needed none of that and started generating rent immediately.
Market comparables, pulled from properties within roughly a mile of the site, grounded every rent assumption in what was actually happening nearby, and each scenario rolled up into its own full 30-year proforma, live-adjustable enough that he could change a build cost or unit mix mid-meeting without breaking the comparison to the other two.
The real difficulty wasn’t just comparing three different numbers, it was keeping the comparison fair when the three paths weren’t actually equivalent to begin with, different purchase prices, different construction risk, different stages of completion, and making sure the model held up just as reliably live, in the middle of a meeting, as it did sitting untouched.
What came out of it was a clear, data-backed comparison of all three paths and their respective profitability metrics, ready for the developer to make his decision from, and to carry into the room with investors. Getting there took months of tweaking, since three genuinely different acquisitions don’t sit on the same fair footing on the first pass, and this wasn’t a quick build.