A refinance at stabilization that came in $1.8M short and turned a cash out into a capital call
A case worth studying, because the thing that breaks is the line that was modeled most confidently. The asset is a 104 key extended stay in a secondary market, bought at $9.5M with a $2.6M PIP, all in around $13.2M. Bridge loan of $10.3M, three years plus two one year extensions, floating. Take a co-investor with $140k of about $2.9M of equity, so 4.8 percent. The plan is a refinance at month 30 into fixed rate debt that retires the bridge and returns a chunk of equity. The model has stabilized NOI at $1.42M, valued at a 7.2 percent cap for $19.7M, and 65 percent of that is $12.8M. Retire $10.3M plus an exit fee and reserves, call it $10.7M needed, and there is $2.1M of cash out. That is the line in the spreadsheet that never gets stress tested. What happens. RevPAR is fine, $78 against $80 underwritten, occupancy a touch better than plan. The margin is the problem. Wages run over, and the property insurance renewal roughly doubles from the first year. GOP margin comes in at 38 percent against 44. Trailing twelve NOI at the refi test is $1.18M, and the lender takes a 4 percent of revenue FF&E reserve out of it before sizing, which the sponsor's model never did. Then the appraisal uses an 8.4 percent cap. At 8.4 percent, $1.18M is $14.05M. The lender's number sizes around $8.9M. Against $10.7M needed, that is a $1.8M gap. The fix is a $1.15M member loan from the sponsor at 12 percent accruing plus a $650k cash call to the equity. The co-investor's pro rata is $31k. No distributions for 14 months and counting, and the member loan sits ahead of that capital. What to do differently: run the refinance proceeds off an appraised value using an exit cap at least 100bps above the entry assumption, on a trailing twelve NOI net of a 4 percent FF&E reserve, and stress insurance and wages as separate lines rather than assuming the margin. The whole thesis rests on RevPAR, and RevPAR is the one thing that comes in.