Michael managed a mixed portfolio of office and retail assets for an institutional fund with quarterly investor reporting obligations. For three consecutive quarters, the portfolio had underperformed its IRR target by 80–90 basis points. The committee had heard various explanations, some market-driven, some tied to tenant credit performance, but nothing that fully accounted for the persistent gap.
A Firststreet analysis was run across the portfolio's 87 active leases. The platform structured every rent obligation, base rent, escalation schedules, percentage rent thresholds, CPI provisions, recovery structures, and compared them against Yardi configuration data.
Two categories of errors dominated the findings. First, percentage rent kick-in thresholds on 4 retail leases had never been configured in Yardi at all. The tenants were generating gross sales above their natural breakpoints, but the system had no record that percentage rent was owed. Second, rent escalation steps on 9 office leases had been applied against the wrong base year figure, in each case, the escalation had been calculated on the year-1 rent rather than the correct step-up base, understating the current obligation by 4–8%.
The combined annual revenue impact across both error categories was $1.4 million, enough to account for the full IRR gap the committee had been asking about.