Articles

Does a price cut equal to the capex restore the return after a retrade?

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.

The assumptions

Illustrative acquisition, invented figures
ItemValue
Asking price$42.0m
Current NOI$2.31m, growing 3.0% a year
Debt65% of the price paid, 6.0% interest only
Closing costs and sale costs1.5% of price each
ExitYear 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.

Step 1: the return before the defect

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

Step 2: the return with the capex at the same price

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.

Equity cash flows, $m
YearNo defect, $42.0mDefect, $42.0mDefect, price cut $1.80m
Year 0−15.33−15.33−14.67
Year 10.74−1.06−0.99
Year 20.810.810.88
Year 30.890.890.96
Year 40.960.961.03
Year 520.9920.9922.23

Step 3: the price cut that restores the return

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.

What if: when the rule of thumb fails

Cut needed to restore the no-defect IRR
CaseIRR, no defectIRR, defect, same priceCut neededCut ÷ capex
Base case, capex in year 1, loan 65% of the price paid10.58%8.12%$1.801m1.001x
Capex paid at closing instead of year 110.58%7.93%$1.991m1.106x
Loan fixed at 65% of the original $42.0m10.58%8.12%$1.604m0.891x
Leverage 50% instead of 65%9.34%7.56%$1.732m0.962x
Exit cap rate 6.25% instead of 5.75%6.69%4.22%$1.693m0.941x
Hold of 7 years instead of 511.08%9.25%$1.885m1.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.

Same deal, different capex
CapexIRR at the same priceCut neededCut ÷ capexCut as % of price
$0.9m9.32%$0.900m1.001x2.14%
$1.8m8.12%$1.801m1.001x4.29%
$2.7m6.96%$2.701m1.001x6.43%
$3.6m5.86%$3.602m1.001x8.58%

The common mistakes

Takeaway

Questions readers ask

How much should a buyer ask for when diligence finds capex?

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.

Is a cut equal to the capex always enough?

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.

Does the cut scale with the size of the defect?

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 workbooks behind this article

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.

Open the companion files →

Not on Amazon: 24 paperbacks by Julian R. Sterling on insurance and retirement, printed on demand and shipped worldwide. Browse the bookshop →

Also on this site

Reading guide: real estate investing, finance and fund management → · All 1908 articles →