BRRRR Calculator in Excel: Model the Full Buy-Rehab-Refi Cycle

BRRRR Calculator in Excel: Model the Full Buy-Rehab-Refi Cycle

BRRRR — buy, rehab, rent, refinance, repeat — is a strategy whose entire economics live in the handoffs between stages. The purchase discount only matters if the rehab delivers the after-repair value; the ARV only matters if the refinance actually extracts it; and the refinance only extracts it if the stabilized rent supports the new loan. A BRRRR calculator that models the stages separately, without wiring them together, will happily approve deals that fail in the seams.

The free calculator on this page runs the full cycle end to end, and this guide walks the model stage by stage — including the constraint most BRRRR calculators skip, which is where the worked example below deliberately runs into trouble. All figures are illustrative examples, not market data.

The BRRRR Model at a Glance

Five stages, each producing numbers the next stage consumes:

1. Buy — purchase price plus acquisition costs → initial basis
2. Rehab — renovation budget, contingency, and carrying costs → all-in cost
3. Rent — stabilized income and expenses → NOI (and the DSCR the refi lender will test)
4. Refinance — new loan against the ARV, constrained by LTV and coverage → cash out, capital left in deal
5. Repeat — recycled capital and the post-refi hold economics

The single number the whole model orbits is capital left in the deal: all-in cost minus refinance proceeds. Drive it toward zero and your equity recycles into the next property; misjudge it and your capital is buried in a thin rental for years.

Our worked example, carried through every stage: purchase $180,000, renovation $45,000, closing and carrying costs $15,000, projected ARV $320,000, stabilized rent $2,650/month.

Stage 1: Buy — the Discount Is the Margin

BRRRR begins with buying below stabilized value — distressed condition, motivated seller, mispriced listing — because the strategy's margin is manufactured at purchase and harvested at refinance. Model the full acquisition cost: price, closing costs, inspections, and any acquisition financing points. If the deal uses hard money or a renovation loan for the acquisition phase, its costs belong in the model here, not as a footnote.

Our example enters at $180,000 against a $320,000 projected ARV — but that comparison means nothing until the rehab and carry costs join it.

Stage 2: Rehab — Budget, Contingency, Carry

Three components, each with its own failure mode:

• The scope budget — line-item renovation costs. Build it from a written scope of work, not a per-square-foot guess.
• Contingency — a percentage on top of the scope for what demolition reveals. Renovation budgets without contingency are not budgets; they are opening bids.
• Carrying costs — taxes, insurance, utilities, and financing interest during the months the property produces no rent. Every month of schedule slip is a real cost the model should price, which is why the timeline is an input, not a hope.

Our example carries $45,000 of renovation and $15,000 of combined closing and carrying costs, for an all-in cost of $240,000. The all-in figure — not the purchase price — is the number every downstream stage measures against.

The ARV itself deserves its own discipline: it must come from comparable sales of renovated product, adjusted honestly. The ARV calculator guide covers the comps method; the 70% rule explainer covers the classic screening shortcut and the markets where it breaks.

Stage 3: Rent — the Stage That Sizes the Refi

Between the rehab and the refinance sits the stage beginner models treat as a formality: stabilized operations. It is not a formality — it is the input the refinance lender underwrites.

Model it like a small pro forma: gross rent, a vacancy allowance, and line-item operating expenses (taxes at the post-renovation assessment, insurance, maintenance, management — modeled at market rate even if you self-manage, because your lender will).

Our example: $2,650/month is $31,800 gross; less a 5% vacancy allowance, collected income is about $30,200; with operating expenses around 35% of collections, NOI lands near $19,600 (illustrative).

Stage 4: Refinance — Where BRRRR Deals Actually Break

The textbook refinance is one line: new loan = ARV × LTV. At 75% loan-to-value on our $320,000 ARV, that is $240,000 — exactly our all-in cost. The perfect BRRRR: every dollar recaptured, infinite return on the capital left in, on to the next deal.

Now apply the constraint the textbook skips. Rental refinance lenders — especially DSCR loan programs — test the new loan against the property's income as well as its value, and lend to the lesser of the two constraints.

Run the coverage math on the $240,000 loan: at an illustrative 7.0% rate on a 30-year amortization, the annual constant is about 7.98%, so debt service is roughly $19,160 against $19,600 of NOI — a DSCR of about 1.02x. The property barely covers its own payments, and a lender requiring 1.20x coverage will not make that loan.

Size it the way the lender will: maximum debt service = $19,600 ÷ 1.20 ≈ $16,300; maximum loan = $16,300 ÷ 0.0798 ≈ $205,000. The refinance the deal actually supports is $205,000, not $240,000 — leaving roughly $35,000 of capital in the deal that the LTV-only calculation said you would recover.

This is the single most important thing a BRRRR calculator can do for you, and most do not do it: model the refinance as the lesser of the LTV loan and the DSCR loan. In higher-rate environments, coverage — not value — is routinely the binding constraint, and the gap between the two is capital you planned to recycle and will not. The full coverage mechanics are in the DSCR calculator guide, and the cash-out specifics — seasoning requirements, rate-versus-proceeds trade-offs — in the cash-out refinance calculator for investment property.

Two more refinance realities to model rather than discover:

• Seasoning. Many lenders require a holding period before lending on the appraised value rather than your cost. Months of seasoning are months of carry — put them in the timeline.
• The appraisal, not your ARV. The lender lends on their appraisal. If it comes in under your comp-based ARV, both constraints tighten. A serious model stresses the ARV downward and shows what a 5% appraisal miss does to proceeds.

Financing the Buy and Rehab: the Cost Layer Most Models Skip

Most BRRRR deals do not sit in cash between purchase and refinance — they run on acquisition financing: hard money, a private lender, a renovation loan, or a credit line. That financing has three costs the model must carry, because all three land in the all-in figure the refinance has to clear:

• Points and fees at origination — often several percent of the loan on short-term money, paid up front.
• Interest carry — frequently at double-digit rates, accruing every month from close to refinance payoff. On an illustrative $160,000 hard-money loan at 11%, each month of the project costs about $1,470 of interest — which means a two-month schedule slip adds roughly $2,900 to all-in cost before a single change order.
• The payoff at refinance — the new loan's first job is retiring the old one; only proceeds above the payoff and closing costs are cash back to you.

This layer creates the timeline feedback loop that defines real BRRRR economics: slower rehab → more interest carry → higher all-in cost → more capital left in at the same refinance proceeds. It is also why the rate on short money matters less than borrowers think and the months outstanding matter more — and why a model with the timeline as a hard input, driving carry costs formula-by-formula, prices schedule risk that a static budget cannot see.

If instead you are funding the buy and rehab with cash, the same layer still exists in shadow form: the model should carry your cash's opportunity cost of sitting in an unfinished project, if only so that a financed and an all-cash version of the same deal can be compared honestly.

Stage 5: Repeat — the Post-Refi Scorecard

After the refinance, the model should report the numbers that decide whether the machine keeps turning:

• Capital left in deal: all-in cost minus refinance proceeds — our example, ~$35,000.
• Cash-on-cash on remaining capital: post-refinance annual cash flow (NOI minus new debt service) divided by capital left in. Note the built-in tension: extracting the maximum loan minimizes capital left in but also minimizes — sometimes eliminates — the cash flow on what remains. Our example at the $205,000 DSCR-sized loan clears roughly $3,200 a year of cash flow on $35,000 left in, about a 9% cash-on-cash (illustrative). At the $240,000 loan the lender refused, cash flow would have been near zero — the "perfect BRRRR" was also a break-even rental.
• Equity position: ARV minus the new loan — the wealth created, held as equity rather than cash.
• Recycled capital and cycle time: how much came back and how many months the full cycle consumed, because BRRRR returns are per-cycle returns and the timeline is the denominator.

The Excel Architecture

Wire the five stages so each consumes the previous stage's outputs: an inputs block (purchase, budget, timeline, rent, expense assumptions, ARV, and both refi constraints — LTV, rate, amortization, minimum DSCR); a cost build to all-in; a stabilized mini pro forma to NOI; a refinance block computing the LTV loan, the DSCR loan, and taking the lesser; and the scorecard. Keep inputs visually distinct, no hardcodes inside formulas, and add one cell that too many BRRRR spreadsheets lack: a flag that turns on when DSCR — not LTV — is the binding constraint, so the model tells you why the cash-out fell short. For the tab-by-tab anatomy of a full BRRRR workbook, see the BRRRR spreadsheet guide.

Where BRRRR Models Go Wrong

1. LTV-only refinance sizing — the big one, demonstrated above.
2. ARV from unrenovated comps — or from optimism. The whole model keys off this number.
3. No contingency, no carry — rehab budgets that assume perfect demolition and instant schedules.
4. Old tax assessment in the rent stage — renovation and revaluation raise taxes; the refi lender's underwriting will catch what your model missed.
5. Ignoring seasoning — months of carry between stabilization and the cash-out.
6. Scoring the deal on the extraction alone — a BRRRR that recovers all capital but cash-flows at break-even has converted your cash into a fragile rental. The scorecard needs both numbers.

Frequently Asked Questions

What does BRRRR stand for? Buy, rehab, rent, refinance, repeat — acquire below stabilized value, renovate, stabilize with a tenant, refinance against the new value to recover capital, and redeploy into the next property.

How is a BRRRR calculator different from a flip calculator? A flip exits by sale, so the model ends at ARV minus costs. BRRRR exits into a hold, so the model must continue through the refinance constraints and the post-refi rental economics — the two stages where BRRRR-specific failures live.

What LTV can I expect on a BRRRR cash-out refinance? Cash-out programs on investment property commonly cap somewhere around the 70–75% range, but the operative number is the lesser of the LTV loan and what your DSCR supports at current rates — confirm both on a live quote rather than modeling a remembered maximum.

What happens if the appraisal comes in below my ARV? Both refinance constraints shrink with it: less value for the LTV test, and the loan you hoped for may also fail coverage. Model an appraisal haircut scenario before you buy, not after.

Is BRRRR dead when interest rates are high? Higher rates shrink DSCR-constrained proceeds, which shrinks the capital recycled per cycle — the machine turns slower, not never. Deals need deeper purchase discounts or stronger rents to clear the same bar, which is exactly what a full-cycle model shows you deal by deal.

Run the Full Cycle Properly

The free calculator on this page models all five stages with the dual-constraint refinance. The BRRRR Calculator is the complete Excel implementation: the acquisition and rehab cost build with contingency and carry, the stabilized rental pro forma, refinance proceeds sized to the lesser of LTV and DSCR with the binding constraint flagged, ARV stress testing, and the full post-refi scorecard — fully unlocked, formula-transparent, with a documented methodology PDF.

For a guided web version of the analysis, the YieldSheets platform is in development — join the waitlist.

This article is for educational purposes only and does not constitute investment, legal, or tax advice. All figures are illustrative examples, not market data, rate quotes, or lender terms. Consult qualified professionals before making investment decisions.