Use the actual dates
Record contributions and distributions on their relevant dates. A different timing assumption can change the calculated return even when the total profit is unchanged.
Apply the correct calculation base
Confirm which contributions, fees and distributions enter the hurdle calculation. Follow the agreement’s treatment of returned capital, accrued amounts, reinvestment and subsequent contributions.
Test the change in tiers
Model cash distributions immediately below and above the hurdle. Check the effect of any catch-up and confirm the model does not distribute more cash than the property has available after its obligations.
Use the model for decisions
Compare operating, financing and exit scenarios using supported assumptions. Do not change those assumptions simply to produce a target return.
Timing changes the hurdle calculation
IRR measures both amounts and dates. A contribution at the beginning of a project and a distribution three years later produce a different result from the same distribution one year later. Use actual or explicitly assumed contribution and distribution dates, and state whether the model uses an annual-period or dated cash-flow calculation.
Before allocating a distribution, identify the amount available after operating requirements, debt service and reserves. Then apply the ownership agreement’s sequence. Test the model with small cases where the correct allocation can be calculated by hand, including a distribution that crosses from one tier to the next.
What the sponsor should receive
A usable model should show the inputs, the calculation for each tier, the distributions to each existing ownership interest and a reconciliation to total available cash. Include a plain-language explanation of the assumptions and the questions that require clarification from transaction counsel.
Discuss your property financing or explore sponsor consulting.