Project Overview:
XYZ Capital (client name withheld) is a mid-market institutional investor backed by a senior asset manager and focused on acquiring open-air retail centers across the Midwest, 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. Analysts can now underwrite acquisitions efficiently, while senior management can review assumptions with confidence. The platform scales with the firm’s capital deployment capacity, and deal flow remained uninterrupted throughout implementation.
ARGUS Mapping & Import System
This integration project delivered seamless data transfer and automated reporting for a commercial real estate client. Leveraging ARGUS, we unified disparate financial models, streamlined analysis, and improved forecasting accuracy across the portfolio. The result was significant efficiency gains and more informed business decisions.
Lease Audit Platform
We implemented automated workflows to eliminate manual data entry, reducing errors and accelerating delivery times. Our custom tools integrated ARGUS outputs directly into client-specific templates, creating a fluid experience for all project stakeholders.
Cash Flow & Capital Stack
A suite of analytics was developed on top of ARGUS, enabling deeper insight into asset performance, cash flow trends, and risk exposure. Clients could now evaluate key metrics with unprecedented clarity and speed.
Validation & Auditability
We created interactive dashboards to visualize financial scenarios in real time. Decision-makers could instantly compare outcomes and identify new opportunities for portfolio optimization.
David S., Portfolio Manager