Mastering Net Effective Rent
A prominent North American real estate investment trust, known for its expansive class A office portfolio and long-standing market presence, faced a critical challenge: a legacy application used to evaluate leasing deals had become outdated, inefficient and increasingly difficult to maintain. Originally built over a decade ago, the application was no longer compatible with modern browsers and lacked the flexibility and performance required by today’s leasing teams.
Open Box Software was engaged to modernise this essential tool—used to calculate Net Effective Rent (NER)—and deliver a solution that would support more accurate, flexible and timely decision-making across leasing scenarios.
The Opportunity
The client’s existing NER tool still “worked,” but years of incremental fixes had created real barriers to productivity and risk management:
- Legacy constraints: The application was tied to one outdated browser, limiting accessibility for users and complicating support.
- Cumbersome user experience: Routine tasks—such as configuring rent schedules or applying concessions—required numerous clicks and workarounds.
- Undocumented, complex logic: NER calculations lived in code with minimal documentation, including known/unknown defects that created ambiguity and rework.
- Patchwork integrations: Inputs and references were spread across spreadsheets and enterprise systems (e.g., ERP/rent roll), with inconsistent refresh patterns.
The client needed a modern, browser-agnostic application that preserved institutional knowledge, streamlined configuration and supported decision making for new leases, renewals, expansions and contractions—all without disrupting how leasing and finance teams worked.
The Approach
Open Box combined domain consulting with pragmatic engineering to derisk the rewrite:
- Discovery with power users & executives to map real decision flows (deal → scenario → version), distinguishing what to keep, fix, or retire.
- Code-level reverse engineering of the existing application to surface the true calculation set and reconcile defects.
- Experience-led design with a specialist UX designer to introduce a consistent style guide—subsequently adopted across the client’s internal app ecosystem.
- Technical architecture & data design, including significant database restructuring to improve maintainability and performance while preserving historical decisions.
- Integration strategy to harmonise ERP/rent roll inputs with spreadsheet import/export where needed, balancing control with flexibility for power users.
This project catalysed a series of additional rewrites, with the newly established design system and delivery learnings applied across the portfolio.
The Solution
A modern, browser-agnostic NER application that brings clarity, speed and confidence to lease evaluation:
- Scenario & versioning model: Deals are created per tenant, with multiple property/region scenarios and version “what-ifs,” all rolling up to an at-a-glance NER comparison.
- Dynamic rent schedule: A flexible, cascading schedule dramatically reduces clicks, supports concessions (e.g., free rent) and handles percentage changes without manual re-entry.
- Realtime collaboration: In-app lists and views refresh automatically when teammates make changes, minimising “who has the latest?” friction.
- Enterprise-grade integrations: Data flows in from the client’s ERP/rent roll; users can also export/import structured spreadsheets for complex inputs.
- Design system & usability upgrades: Search, streamlined navigation and consistent patterns reduce cognitive load and training needs.
- Audit & history: Key changes are captured in a deal history, improving traceability around decision inputs and edits.
The Result
- Better decisions, faster: With clearer inputs and realtime updates, teams compare options quickly and converge on the most favorable deal version with greater confidence.
- Meaningful UX efficiency gains: The reworked rent schedule and navigation cut repetitive clicks and eliminated common workarounds.
- Higher data fidelity: Reverse-engineered and corrected calculations reduce ambiguity and the risk of silent errors influencing outcomes.
- Future‑proof foundation: The modern tech stack, database restructuring and reusable design system have supported ongoing enhancements and additional app rewrites for the client.
The application has remained in active use with incremental improvements handled via the client’s support stream.
Conclusion
By pairing deep real estate domain understanding with hands‑-on software engineering, Open Box modernised a complex, calculation heavy NER tool into a reliable decision companion for leasing and finance. The engagement showcased Open Box’s role as a trustworthy delivery partner able to untangle undocumented logic, align stakeholders on what “good” looks like and stand up a repeatable design and delivery approach that has since scaled across the client’s internal app estate.
Unlocking potential by reimagining net effective rent.
