Refi at stabilization came in $1.8M short, so instead of cash out I wrote another check
First deal after a very long analysis stage, and the thing that broke was the one I'd modeled most confidently.
104-key extended stay, 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. My co-invest was $140k of about $2.9M of equity, so 4.8%.
The plan was a refinance at month 30 into fixed-rate debt, retire the bridge, and return a chunk of equity. My model had stabilized NOI at $1.42M, valued at a 7.2% cap for $19.7M, and 65% of that is $12.8M. Retire $10.3M plus an exit fee and reserves, call it $10.7M needed, and there's $2.1M of cash out. That was the line in my spreadsheet I never stress tested.
What happened. RevPAR was fine, $78 against $80 underwritten, occupancy actually a touch better than plan. The margin was the problem. Wages ran over, and the property insurance renewal roughly doubled from the first year. GOP margin came in at 38% against 44%. Trailing twelve NOI at the refi test was $1.18M, and the lender took a 4% of revenue FF&E reserve out of it before sizing, which I had never done in my own model.
Then the appraisal used an 8.4% cap. $1.18M at 8.4% is $14.05M. The lender's number sized around $8.9M. Against $10.7M needed, that is a $1.8M gap.
The fix was a $1.15M member loan from the sponsor at 12% accruing plus a $650k cash call to the equity. My pro rata was $31k. No distributions for 14 months and counting, and the member loan sits ahead of my capital.
What I'd do differently: run the refinance proceeds off an appraised value using an exit cap at least 100bps above my entry assumption, on a trailing twelve NOI net of a 4% FF&E reserve, and stress insurance and wages as separate lines rather than assuming the margin. My whole thesis rested on RevPAR, and RevPAR was the one thing that came in.