BRRRR Spreadsheet: The Tabs a Real One Needs

BRRRR Spreadsheet: The Tabs a Real One Needs

BRRRR deals fail in the seams — the handoffs where the rehab budget becomes the all-in cost, the all-in cost meets the refinance, and the refinance sets the hold economics. A BRRRR spreadsheet's job is to make those seams structural: each stage on its own tab, each tab consuming the previous tab's outputs by reference, so that a change anywhere (a scope increase, a rate move, a slower month) reprices the entire cycle automatically.

This is the workbook anatomy guide: the seven tabs a serious BRRRR spreadsheet carries, what each computes, and — the part that separates a workbook from a pile of worksheets — the formulas that connect them. The deal logic itself (why the refinance is dual-constrained, why the timeline is the hidden denominator) lives in the BRRRR calculator pillar; this article assumes the logic and builds the file. All figures are illustrative examples.

Tab 1 — Inputs: One Home for Every Assumption

Everything the user chooses lives here, and nowhere else: purchase terms, acquisition financing (hard money rate and points, if used), the rehab scope total and contingency percentage, the timeline in months, the stabilized rent and expense assumptions, the ARV, and — critically, as a pair — both refinance constraints: the program's maximum LTV and its minimum DSCR, with the refi rate and amortization.

The discipline is the same one every serious model follows: visually distinct input cells, referenced downstream, hardcoded nowhere. In a BRRRR workbook it earns extra weight, because the strategy is iterative — you will run this file on the next candidate house within weeks, and a workbook whose assumptions live in one block re-underwrites a new deal in ten minutes.

Tab 2 — Acquisition & Buy-Side Financing

The buy stage as a cost build: price, closing costs, inspections, and — if the purchase runs on hard money or a renovation loan — the origination points as a day-one cost and the loan's terms staged for Tab 4's carry math. The tab's single output is the acquisition basis, and its single connective formula is the one that hands that basis forward: every downstream tab references it, none recomputes it.

Tab 3 — Rehab Budget

Line-item scope by category (exterior, kitchen, baths, systems, flooring, paint, landscaping), each with budget and — once work starts — actual columns. Two structural rules: contingency as its own computed line (= ContingencyPct × Scope Subtotal, from the inputs tab), never smeared into the line items where it gets spent invisibly; and the budget total as a named output the timeline and scorecard consume. The full budgeting discipline — scope construction, contingency sizing, draw tracking — is its own subject, covered in the rehab budget template guide; structurally, this tab is that template embedded as a component.

Tab 4 — Timeline & Carry: the Tab Everyone Skips

The tab that separates real BRRRR workbooks from flip calculators with an extra column. One column per month from close to refinance, carrying:

• Holding costs — taxes, insurance, utilities, each a monthly rate from the inputs
• Financing carry — the hard-money interest accruing on the outstanding balance
• The seasoning clock — a counter against the refi program's seasoning requirement, because the refinance date is the later of "stabilized" and "seasoned"

The connective output is the total carry, and the structural point is that it is computed from the timeline, not estimated: stretch the schedule input from six months to nine and the carry — and therefore the all-in cost, and therefore the capital left in the deal — reprices through the chain without a single manual edit. That chain is the workbook's reason to exist.

Tab 4's bottom line + Tab 2 + Tab 3 = the all-in cost — the number the entire refinance stage measures against (about $240,000 on the pillar's worked deal).

Tab 5 — Stabilized Rental

A compact single-property pro forma: rent, a vacancy allowance, and line-item operating expenses — taxes at the post-renovation assessment, insurance re-quoted, and management at a market rate even if self-managing, because the refi lender underwrites one regardless. Outputs: stabilized NOI (for a commercial-style refi test) and the gross rent figure (for a rent-over-PITIA program test) — both, because Tab 6 needs whichever convention the chosen lender runs, and a workbook built for one convention meets the other lender eventually.

Tab 6 — The Refinance: Two Constraints, One MIN

The workbook's decisive formula lives here. Compute both loans the property supports:

• The LTV loan: = MaxLTV × ARV
• The coverage loan: the income-constrained maximum at the program's minimum ratio — the standard DSCR back-solve at the refi rate and amortization

— and the refinance proceeds are =MIN(LTV_loan, DSCR_loan), with a flag cell naming which constraint governs. On the pillar's worked deal, that MIN is the whole story: the LTV test says $240,000 and full capital recovery; the coverage test says about $205,000, and it governs. A BRRRR spreadsheet without this MIN is not conservative or aggressive — it is modeling a lender that does not exist.

The tab finishes the stage: refinance closing costs, the payoff of the acquisition loan, and the net cash out — proceeds minus payoff minus costs.

Tab 7 — The Scorecard

The dashboard the whole file feeds, and the four numbers that judge the cycle:

1. Capital left in deal = all-in cost − net refinance recovery
2. Post-refi cash flow and cash-on-cash on remaining capital — NOI less the new debt service, over the capital left in
3. Equity position = ARV − new loan
4. Cycle time and recycled capital — because BRRRR returns are per-cycle, and the months are the denominator

Plus the honesty pair worth displaying side by side: the deal at the LTV-test refinance versus the deal at the governing refinance — the gap between the plan as marketed and the plan as financed.

Tab 8 (the Repeat Tab) — the Portfolio Tracker

The strategy's fifth R earns a tab of its own: one row per completed deal — all-in, refinance recovered, capital left, cash flow, cycle months — with portfolio totals. Two outputs matter over time: total capital deployed versus total capital recycled (is the machine actually turning, or quietly consuming cash?) and average cycle time, the number that governs how fast the same equity compounds. A single-deal analyzer answers "is this deal good?"; the repeat tab answers "is this business working?" — and investors running the strategy seriously need both.

The Audit Strip: Five Checks a BRRRR Workbook Carries

Like every serious model, the workbook earns trust with permanent checks — and BRRRR's seams define which ones:

1. All-in reconciliation: acquisition basis + rehab total + computed carry = the all-in cost the refi tab consumes, to the penny — one ROUND(...)=0 flag that catches any tab quietly recomputing a number it should reference.
2. The MIN flag: a cell naming which refinance constraint governs, conditional-formatted — so a rate edit that flips the binding test announces itself instead of silently changing the story.
3. Budget-versus-actual variance: once work starts, Tab 3's actual column against budget by line, with the contingency's remaining balance displayed — the overrun early-warning that protects the all-in figure downstream.
4. Seasoning satisfied: a date check confirming the modeled refinance month clears the program's seasoning requirement — the compliance detail that otherwise surfaces as a delayed refi and unmodeled carry.
5. Scorecard consistency: capital left in + net cash out = all-in cost, the identity that catches sign errors in the refinance tab before they flatter the dashboard.

Five formulas, one row of conditional formatting, and the file becomes auditable by anyone — including the lender or partner who eventually asks to see it.

The Connective Tissue, Summarized

The tab list is only half the anatomy; the reference chain is the other half:

• Inputs → everything (one home for every assumption)
• Acquisition + Rehab + Timeline-computed carry → all-in cost
• Stabilized rental → NOI / gross rent → the coverage side of the refi MIN
• ARV input → the LTV side of the refi MIN
• MIN(constraints) → net cash out → capital left in → the scorecard
• Scorecard → a row on the repeat tab

Audit any candidate BRRRR spreadsheet — downloaded, purchased, or inherited — against this chain: change the timeline input and watch whether the capital-left-in figure moves. If it does not, the file has tabs but no seams, and the seams are where BRRRR deals live.

Frequently Asked Questions

What should a BRRRR spreadsheet include? Seven working tabs — inputs, acquisition, rehab budget, timeline/carry, stabilized rental, the dual-constraint refinance, and a scorecard — plus a portfolio tab for the repeat stage, all connected by reference so the cycle reprices as one system.

How is a BRRRR spreadsheet different from a flip calculator? A flip ends at sale, so its file ends at ARV minus costs. BRRRR exits into a refinance and a hold, which adds the three tabs flips never need — the stabilized rental, the dual-constraint refi, and the hold-economics scorecard — and makes the timeline a live input rather than a footnote.

Can I build this in Google Sheets? Yes — every formula here is platform-neutral. The Excel default matters mainly when the file circulates to lenders and partners who expect .xlsx.

What is the most common error in homemade BRRRR spreadsheets? The refinance modeled on LTV alone — no coverage test, no MIN, no binding-constraint flag. Second place: carry estimated as a lump sum instead of computed from the timeline, which leaves schedule risk unpriced.

The Anatomy, Assembled

The BRRRR Calculator ships this workbook built: the full input block, the acquisition and rehab cost build with computed contingency, the timeline-driven carry engine, the stabilized rental pro forma, the refinance as a true MIN of LTV and coverage with the governing constraint flagged, ARV stress, and the complete scorecard — fully unlocked, formula-transparent, versioned, with a documented methodology PDF. The full catalog is in the store.

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