Did this BRRRR actually return all my cash? BRRRR-to-STR refi math workbook for Airbnb / vacation rental investors. ARV + cash-out + post-refi DSCR + capital-recycled %. Excel + Google Sheets. The BRRRR strategy (Buy, Rehab, Rent, Refinance, Repeat) is supposed to return all your cash so you can recycle it into the next deal. In practice, half of BRRRR-to-STR conversions leave money trapped in the property because the ARV didn’t support a 70-75% LTV refi, OR the post-refi DSCR fell below 1.20 and the lender wouldn’t approve the cash-out. This workbook runs the math BEFORE you commit. ARV calculator (two methods), refinance terms, post-refi DSCR projection, cash-left-in (or returned), capital-recycled %. WHAT’S INCLUDED 📋 Acquisition Tab — purchase, closing, rehab budget, holding costs 📋 ARV Estimation — comp-sales method + stabilized-NOI method (workbook picks conservative) 📋 Refinance Terms — projected LTV, rate, term 📋 Stabilized Operations — projected revenue + expenses post-rehab 📋 Cash-Left-In Calculator — total cash invested − refi proceeds 📋 Post-Refi DSCR — must be ≥1.20 to qualify for cash-out 📋 Capital-Recycled % — how much of original cash you can re-deploy
Related
- DSCR Tracker
- Refi-or-Sell Decision Matrix
- Rehab Budget + ROI Projection
- Rental Arbitrage Analyzer
- STR vs LTR Yield Comparison
Get the workbook
Format: Excel .xlsx + how-to PDF. Excel 2016+, Excel 365, Google Sheets compatible. Instant download after checkout. 14-day refund, no questions. Lifetime updates within v1.