1.Single-Asset Acquisition Strategy Modeling
Dashboard · 2026
A real estate investment analyst built this dashboard to evaluate a single-asset acquisition across three strategies: ground-up development, renovation/flip, and buy-and-hold rental. The model centralizes macroeconomic inputs, including a 6.52% mortgage rate, a 4.26% 10-year Treasury hurdle, and 92.88% occupancy. Selecting the ground-up development scenario reveals a 53.18% ROI ($392.9K net profit on a $738.9K cost) and a 69.46% levered IRR. A combo chart visualizes the return stack against the Treasury hurdle. By centralizing these inputs, the analyst eliminated structural calculation errors and avoided manual re-syncing across multiple output files when adjusting assumptions.
What it shows:
Centralizing macroeconomic inputs and return metrics in a single view prevents calculation errors when comparing mutually exclusive acquisition strategies.




