A promote paid early out of a refinancing, a capital call, a weak sale, and the giveback that the lookback clause calculates.
A lookback re-tests the investor's return when the venture ends and makes the sponsor give back promote already received, up to the amount paid, until the investor reaches its hurdle. On an illustrative 50.0 million joint venture that paid a 3.03 promote out of a year 3 refinancing and then had a bad year 5, the investor finishes at 6.45 per cent against an 8 per cent hurdle. The lookback requires 2.59 back from the sponsor, 86 per cent of the promote it was paid, which takes the investor to exactly 8.00 per cent.
Worked in full in Real Estate Joint Ventures by Julian R. Sterling, with every figure reproduced in a free workbook.See the book on Amazon →
A waterfall is run distribution by distribution. If an early distribution clears the investor's capital and preferred return, the promote is paid on what is left, and that payment is never revisited by the waterfall itself, whatever happens afterwards. The investor's protection against an early promote followed by a poor ending is a separate clause: at the final distribution, compute the investor's whole-life IRR; if it is below the hurdle, the sponsor returns promote, capped at what it received, until the hurdle is met.
An investor puts up 45.0 and a sponsor 5.0, 90/10. Tier 1 returns capital plus an 8 per cent preferred return compounded annually, 90/10; above it the sponsor takes a 20 per cent promote, a 72/28 split. The property pays 2.5 a year for three years and is refinanced at the end of year 3, distributing 70.0, as in how refinance proceeds are split in a JV waterfall. Then the anchor tenant leaves. In year 4 the partners fund a 25.0 capital call to re-let the space, 22.5 from the investor and 2.5 from the sponsor, and at the end of year 5 the property is sold for 10.0 of equity. All figures are illustrative, in millions.
| Year | Opening account | Cash flow | Investor | Sponsor | Promote | Closing account |
|---|---|---|---|---|---|---|
| 1 | 50.00 | 2.50 | 2.25 | 0.25 | 0.00 | 51.50 |
| 2 | 51.50 | 2.50 | 2.25 | 0.25 | 0.00 | 53.12 |
| 3 | 53.12 | 72.50 | 62.53 | 9.97 | 3.03 | 0.00 |
| 4 | 0.00 | −25.00 | −22.50 | −2.50 | 0.00 | 25.00 |
| 5 | 25.00 | 10.00 | 9.00 | 1.00 | 0.00 | 17.00 |
The capital call reopens the account at 25.0; it accrues to 27.0 and the 10.0 sale repays only part of it, all within tier 1. The investor ends with 76.03 on 67.5 contributed, an IRR of 6.45 per cent. The deal itself returned 8.34 per cent, above the hurdle: the investor is below it only because 3.03 of promote left in year 3.
Step 1: test the hurdle. Discount the investor's cash flows at 8 per cent. A negative net present value means the hurdle has not been met.
NPV8% = −45.0 + 2.25/1.08 + 2.25/1.082 + 62.53/1.083 − 22.50/1.084 + 9.00/1.085 = −1.77
Excel: =NPV(8%,C2:C6)+C1
Step 2: size the giveback. The amount that, paid at the final distribution, brings the NPV to zero is the shortfall carried forward to that date.
Lookback = 1.77 × 1.085 = 2.59, capped at promote received, 3.03
Excel: =MIN(-NPV8*(1.08)^5, PromotePaid)
Step 3: apply it. The sponsor pays 2.59 to the investor out of its year 5 receipts and its own pocket. The investor's IRR becomes 8.00 per cent; the sponsor's falls from 22.92 to 12.29 per cent and it keeps 0.43 of the promote.
| Exit equity | Deal IRR | Investor IRR before | Giveback needed | Lookback paid | Investor IRR after | Promote kept |
|---|---|---|---|---|---|---|
| 0.0 | 2.06% | −0.45% | 11.59 | 3.03 | 2.22% | 0.00 |
| 5.0 | 5.50% | 3.37% | 7.09 | 3.03 | 5.50% | 0.00 |
| 10.0 | 8.34% | 6.45% | 2.59 | 2.59 | 8.00% | 0.43 |
| 15.0 | 10.79% | 9.06% | 0.00 | 0.00 | 9.06% | 3.03 |
| 20.0 | 12.95% | 11.35% | 0.00 | 0.00 | 11.35% | 3.03 |
No lookback is due once the sale returns 12.88 of equity. Below that, the giveback grows quickly and soon exceeds the cap: at a sale of 5.0 the investor would need 7.09 and gets 3.03, and its IRR after the lookback, 5.50 per cent, is no better than the deal's. With every unit of promote returned, the investor is back to roughly its pro rata share of the deal, a touch more at the very bottom because the 3.03 returned exceeds the 2.72 the promote took out of the investor's 90 per cent. That is the most a lookback can do: it cannot protect the investor from the deal itself.
The common mistake is to test the deal IRR rather than the investor's. Here the deal earns 8.34 per cent, comfortably above 8, and a model that tests the wrong line concludes no lookback is due, leaving 2.59 with the sponsor. The test is on the investor's own cash flows, capital calls included, and the giveback is sized from the NPV shortfall, not from the IRR gap. For how promote erodes the investor's return when nothing goes wrong, see how much the promote reduces the investor's IRR.
The book's complete venture, with its refinancing, deemed liquidation and lookback, is rebuilt in the free workbooks for Real Estate Joint Ventures.
Discount the investor's actual cash flows, contributions and distributions, at the hurdle rate. If the net present value is negative, carry the shortfall forward to the final distribution date; that is the giveback, capped at the promote received. In the illustrative case the NPV at 8 per cent is minus 1.77, and 1.77 times 1.08 to the fifth gives 2.59 of a 3.03 promote.
In practice the terms overlap: both return promote already paid. Lookback usually describes the JV test at the end of the venture on the investor's IRR; clawback is more often the fund-level term. Either way the cap matters. If the clause returns promote only net of tax, an illustrative 25 per cent, a 3.03 promote can return at most 2.27, leaving the investor at 7.81 per cent rather than 8.00.
A holdback is easier to collect, because the money is in escrow, but it is usually smaller than what a bad ending requires. Holding back 30 per cent of a 3.03 promote secures 0.91, against 2.59 needed in the illustrative downside, and leaves the investor at 7.01 per cent. Investors often ask for both: a holdback for collection and a lookback for the amount.
This article is one calculation from Real Estate Joint Ventures. The book takes the same case from first principles to the decision, chapter by chapter, and every figure it prints is a live formula in the free companion workbooks.
Get the book on Amazon →Free companion files
Also on Amazon UK · Amazon Germany · Amazon France · Amazon Canada
Reading guide: real estate investing, finance and fund management → · All 1340 articles →
If this book helped, or didn’t, a few lines on Amazon are worth more than they look: they are what the next reader goes on. Write a review. The workbook stays free either way.