Project Overview:
A large mid-market institutional investor backed by a senior money manager and focused on acquiring open-air retail centers across the East Coast, typically valued between $20 million and $150 million.
The firm maintained ARGUS and an internal underwriting model and sought a system capable of integrating the two at scale to fully leverage its internal capacity. The system needed to be developed on a tight timeline without diverting internal resources or slowing deal velocity.
Broker-provided ARGUS files vary widely in structure and assumptions, particularly across open-air retail assets where lease structures, recoverables, and tenant-specific economics can be complex. While ARGUS provides a powerful leasing and asset management platform, broker models are often difficult to audit quickly within an acquisition underwriting workflow. Translating broker assumptions into an underwriting model typically requires significant manual reconstruction.
InstitutionalModels™ developed a structured ARGUS integration layer designed to normalize broker exports into a transparent Excel-based underwriting architecture. The system accommodates variations in how assets are modeled within ARGUS while preserving the underlying lease economics and enabling efficient lease-level auditing.
The ARGUS integration layer flows directly into the Excel-based underwriting architecture, where lease-derived cash flows are integrated with the capital structure to generate investment return metrics, including levered and unlevered IRR, DSCR, and cash-on-cash yield. The full cash flow engine also provides clear cash flow traceability, allowing assumptions and calculations to be reviewed directly through standard Excel formulas or printed model outputs.
The result was the realization of the firm’s vision for a fully integrated underwriting system capable of translating broker ARGUS exports into acquisition models in minutes rather than hours. Analysts can now underwrite opportunities efficiently, while senior management can review assumptions with confidence. The platform scales with the firm’s capital deployment capacity without disrupting deal flow during implementation.
Data Integration (ARGUS -> Excel)
Broker-provided ARGUS exports were normalized into a structured Excel integration layer that preserves lease-level economics while translating tenant rents, options, and timing directly into a standardized monthly underwriting model. The system accommodates variation in broker ARGUS files while enabling analysts to review and audit lease-level cash flows without manually reconstructing rent rolls. (Mapping layer not shown.)
Dynamic Parcel and Capital Inputs
Open-air retail centers with multiple parcels present a structuring challenge that generic models can't handle cleanly — parcels may be disposed at different times and financed independently depending on the investment strategy. The input sheet accommodates this directly: each parcel carries its own square footage, allocation, exit month, and cap rate override, and the leverage structure provides enough independent loan facilities to finance each parcel and its refinance separately. Every tranche is configured for its own start month, term, rate structure, IO period, and amortization schedule. When strategy shifts, the entire model recalculates from a single, centralized input tab.
Lease-Level Cash Flow Presentation
Lease-derived cash flows are organized into a standardized reporting format that presents operating performance across the underwriting horizon in either dollar or PSF terms. Line items aggregate tenant-level rent, vacancy, recoveries, and capital assumptions into a clear operating statement while preserving full lease-level detail within the model. The structure also enables slippage analysis—measuring differences between weighted average lease economics and projected property performance—calculated dynamically in either dollar or PSF terms depending on the reporting format selected.
Model Validation Framework
Independent validation checks reconcile lease-level cash flows, operating statements, and capital structure outputs to ensure that reported performance metrics tie directly to the underlying rent roll and model calculations. These controls allow key line items—including revenue, expenses, and cash flow before debt service—to be verified across reporting layers, confirming that the underwriting model remains internally consistent. Additional internal checks operate within the cash flow engine to maintain reconciliation as assumptions or lease inputs are modified.
Cash Flow Reconciled to Client Accounts
The ARGUS cash flows are translated into the client's standard accounts within a full cash flow statement. That statement is also a complete underwriting model — layering in capital assumptions and sale proceeds to arrive at key return metrics, including IRR and DSCR. The result is a single integrated platform where broker-provided lease data flows through to investment-grade outputs without manual reconstruction at any step.
“Alex listened to our needs, developed a vision for the project, and then produced exactly what we needed. The platform he developed has transformed our underwriting."."
— Principal, Open-Air Retail Acquisition Firm