1.Multi-Strategy Acquisition Analysis
Dashboard · 2026
A real estate investment analyst built this dashboard to evaluate a single-asset acquisition across ground-up development, renovation, and buy-and-hold strategies. By centralizing inputs like a 6.52% mortgage rate, 92.88% occupancy, and a $403.2K median sale price, the analyst eliminated structural calculation errors, such as conflating debt repayment with equity profit. Selecting the ground-up development scenario revealed a 53.18% ROI and a 69.46% levered IRR, generating a +65.20pp spread above the 4.26% Treasury hurdle. This workflow demonstrates how to calculate noi accurately within a broader return stack, avoiding the need to manually re-sync interconnected output files when adjusting base-case assumptions.
What it shows:
Centralizing macroeconomic inputs and property metrics prevents structural errors when comparing mutually exclusive investment strategies.




