After diligence finds a defect, the buyer asks for a lower price. Taking the capex as the cut feels fair, but the return depends on leverage, timing and the loan, and the right cut is a calculation.
A buyer finds $1.8m of capex on a $42.0m acquisition. At the same price the levered IRR falls from 10.58% to 8.12%. A price cut of $1.80m, 1.0005x the capex, restores it. That ratio is specific to this structure and runs from 0.89x to 1.11x in the cases tested.
| Item | Value |
|---|---|
| Asking price | $42.0m |
| Current NOI | $2.31m, growing 3.0% a year |
| Debt | 65% of the price paid, 6.0% interest only |
| Closing costs and sale costs | 1.5% of price each |
| Exit | Year 5, cap rate 5.75% on year-6 NOI |
| Defect found in diligence | $1.8m of capex, paid in year 1 from equity |
The capex repairs the building but adds no rent, so the seller is being asked to bear a cost that only protects the asset. The buyer asks for a retrade: a lower price. The question is how much lower, and whether the intuitive answer, the capex itself, is enough.
Loan = 65% × 42.0 = $27.30m, equity = 42.0 × 1.015 − 27.30 = $15.33m
Annual interest = 27.30 × 6.0% = $1.64m
Year-6 NOI = 2.31 × 1.036 = $2.758m, sale price = 2.758 ÷ 5.75% = $47.97m
Levered IRR = 10.58%
Excel: =IRR(B2:B7) with the six equity cash flows
Adding $1.8m of equity in year 1 and changing nothing else gives 8.12%, 246 basis points lower. That is the gap a retrade has to close.
| Year | No defect, $42.0m | Defect, $42.0m | Defect, price cut $1.80m |
|---|---|---|---|
| Year 0 | −15.33 | −15.33 | −14.67 |
| Year 1 | 0.74 | −1.06 | −0.99 |
| Year 2 | 0.81 | 0.81 | 0.88 |
| Year 3 | 0.89 | 0.89 | 0.96 |
| Year 4 | 0.96 | 0.96 | 1.03 |
| Year 5 | 20.99 | 20.99 | 22.23 |
Solve for the price P at which the IRR with the $1.8m of capex equals 10.58%. The loan and the 1.5% closing cost both move with P.
Cut = $1.801m, or 4.29% of the price, a price of $40.199m
Cut ÷ capex = 1.801 ÷ 1.8 = 1.0005x
A cut of exactly $1.8m, a price of $40.2m, gives an IRR of 10.58%
Excel: Goal Seek on the IRR cell by changing the price
In this deal the dollar-for-dollar cut does restore the return, to within 0.1 basis point. That is a coincidence of the assumptions, not a rule, as the next table shows. The cut lowers the equity cheque by only $0.66m, which is 35% of the cut plus the 1.5% closing cost on it. But it also shrinks the loan by $1.17m, which lifts the cash flow every year and the sale proceeds in year 5, and those gains offset the $1.8m of equity paid in year 1.
| Case | IRR, no defect | IRR, defect, same price | Cut needed | Cut ÷ capex |
|---|---|---|---|---|
| Base case, capex in year 1, loan 65% of the price paid | 10.58% | 8.12% | $1.801m | 1.001x |
| Capex paid at closing instead of year 1 | 10.58% | 7.93% | $1.991m | 1.106x |
| Loan fixed at 65% of the original $42.0m | 10.58% | 8.12% | $1.604m | 0.891x |
| Leverage 50% instead of 65% | 9.34% | 7.56% | $1.732m | 0.962x |
| Exit cap rate 6.25% instead of 5.75% | 6.69% | 4.22% | $1.693m | 0.941x |
| Hold of 7 years instead of 5 | 11.08% | 9.25% | $1.885m | 1.047x |
Paying for the capex at closing, as in a seller credit settled on day one, needs 1.11x the capex. Sizing the loan on the original price pushes the ratio down to 0.89x, because the loan stays at $27.30m and the whole cut comes off the equity cheque. The ratio does not depend on the size of the defect, which is the one regularity in the table below.
| Capex | IRR at the same price | Cut needed | Cut ÷ capex | Cut as % of price |
|---|---|---|---|---|
| $0.9m | 9.32% | $0.900m | 1.001x | 2.14% |
| $1.8m | 8.12% | $1.801m | 1.001x | 4.29% |
| $2.7m | 6.96% | $2.701m | 1.001x | 6.43% |
| $3.6m | 5.86% | $3.602m | 1.001x | 8.58% |
Enough to restore the return it underwrote. In this example a $1.8m defect needs a cut of $1.80m, because the loan and closing costs move with the price.
No. It happens to restore the IRR here, but with the loan fixed at the original price the cut needed is $1.60m and with capex paid at closing it is $1.99m.
Yes, in proportion. For capex of $0.9m, $1.8m, $2.7m and $3.6m the cut is 1.0005x the capex each time, though the IRR gap grows.
The free companion files for The Real Estate Acquisitions Analyst rebuild a fictional multifamily acquisition, an industrial retrade and a year of deal flow with live formulas, plus an editable acquisitions toolkit. The deal in this article is invented and is not in them. No account and no email address.
Not on Amazon: 24 paperbacks by Julian R. Sterling on insurance and retirement, printed on demand and shipped worldwide. Browse the bookshop →
Reading guide: real estate investing, finance and fund management → · All 1908 articles →