International Review of Business, Trade, and Economics
Denominator-Controlled Return Closure and Equity-Premium Viability in Real-Estate Funds: Reconciling Exact-Date XIRR, Average-Equity Attribution, Financing Structure, DCF, and Economic Value Added
Abstract
Hany Hassanien Badr
This paper develops a denominator-controlled, closed-loop framework for assessing value creation and financing viability in real-estate funds. Exact-date XIRR, average-return attribution, discounted cash flow, and economic value added are assigned distinct roles rather than treated as interchangeable. The method traces dated equity, debt, and consolidated- fund cash flows; requires amount conservation before return aggregation; discloses the denominator and weights behind every average; and verifies EVA independently through capital-spread and equity-yield routes. DCF-EVA equivalence is examined in three separate control workbooks so that the real-estate cash-benefit bridge is not misrepresented as a direct DCF calculation.
Applied to a fund running from 30 June 2004 to 30 June 2011, the independently re-solved equity, debt, and fund XIRRs are 12.524602%, 5.491344%, and 8.553337%. A model-weighted claim-XIRR benchmark is 8.543440%, leaving a 0.989717-basis-point nonlinear aggregation residual. A separate period-grid NPV root of 8.563204% lies 0.986685 basis point above exact-date fund XIRR; the two differences therefore arise from different mechanisms. On the workbook- normalized exposure base, €336,346 of total benefit produces an 8.204640% fund return. The 12.939346% equity- benefit return decomposes exactly into recurring distribution, additional rental, and capital-gain components. Cumulative EVA is €95,722.461; the capital and equity routes agree in every period, while €92,716.191, or 96.8594%, arises at closure. Two weighting systems and two inverse reconstructions explain why nearby rates must not be called identical: Route A reproduces observed equity XIRR with zero residual, whereas Route B yields a counterfactual equity rate of 12.547409%. A 35/65 financing case fails the equity-premium test; a 20/80 case separates frozen-flow and two repriced regimes. The resulting architecture distinguishes exact closures, diagnostic residuals, denominator effects, and financing viability without conflating them.