BRRRR vs Traditional Buy and Hold Calculator: Split the Rehab Paycheck From the Rental Return

Two investors start with $160,000 each in the week of April 9, 2026. One buys three rent-ready houses with 25 percent down and locks a 30-year loan. The other buys a distressed house for cash, renovates it, rents it and refinances it, then does it again every eight months. Sixty months later the first investor is worth $250,091 and the second $639,718. A BRRRR vs traditional buy and hold calculator usually stops at that line and names a winner. The useful part is the next line down: $403,591 of the BRRRR investor's result is the profit on seven renovation projects, and the rental portfolio left after you take it out earned $76,127, against $106,291 for the three plain houses, on 2.82 times the debt. The calculator below shows both lines, so you can decide which business you want to run.
Every number below comes from one model with stated assumptions. Rates come from Freddie Mac's Primary Mortgage Market Survey, refinance rules from the Fannie Mae Selling Guide, and everything else is an input you replace with your own market and your own lender quotes.
Same $160,000, Same Week, Two Strategies
A fair comparison holds three things constant: the starting capital, the start date and the horizon. Most BRRRR vs buy-and-hold comparisons hold none of them. They put one BRRRR deal next to one turnkey deal and divide each deal's cash flow by the cash left in it. The BRRRR deal below leaves $272.50 in the house and loses $121.19 a month after the refinance, so its cash-on-cash return is minus 534 percent. That figure is arithmetic on a near-zero denominator and tells you nothing about which strategy to run.
The Inputs tab puts the two strategies in two columns. Column B is buy-and-hold, column C is BRRRR.
| Input (row) | Buy-and-hold (B) | BRRRR (C) |
|---|---|---|
| Purchase price (8) | $180,000 | $112,000 |
| Purchase closing costs (9) | 3% | 2% |
| Down payment (10) | 25% | All cash |
| Rehab budget (11) | $0 | $36,000 over 3 months |
| Months until rent-ready (12) | 0 | 4 |
| Vacant carry per month (13) | n/a | $505 |
| Value when stabilized (14) | $180,000 | $210,000 |
| Freddie Mac 30-year average on loan date (15) | 6.37% (April 9, 2026) | 7.40% (October 8, 2026) |
| Note rate with 0.75 point investor premium (16) | 7.12% | 8.15% |
| Rent (20) | $1,725 | $1,850 |
| Taxes and insurance per month (21) | $335 | $355 |
| Vacancy, repairs and management (22) | 24% of rent | 24% of rent |
Global inputs sit above the columns: capital in B3 ($160,000), horizon in B4 (60 months), appreciation in B5 (2.5 percent a year, an assumption) and the investor premium over the Freddie Mac average in B6 (0.75 point, also an assumption; replace it with a quote). The vacant carry of $505 is $220 of taxes, $135 of insurance and $150 of utilities while nobody pays rent.
Buy-and-hold needs $50,400 per house, so $160,000 buys three and leaves $8,800 in reserve. BRRRR needs $152,260 for the first house: $114,240 to close, $36,000 of rehab and $2,020 of carry for four months. Both investors start with a similar cushion: $8,800 for buy-and-hold, $7,740 for BRRRR.
The Refinance Date Sets the BRRRR Rate
The buy-and-hold investor fixed a rate on the purchase date. The BRRRR investor bought for cash and gets a rate only when the refinance closes, six months later. Freddie Mac's weekly survey put the 30-year average at 6.37 percent on April 9, 2026 and at 7.40 percent on October 8, 2026. Over those same six months the BRRRR investor's future rate went up by 1.03 points, while the buy-and-hold investor's rate stayed where it was locked.
Rows 23 to 25 turn that into monthly cash flow per house:
- Net operating income:
=B20-B21-B20*B22 - Principal and interest:
=PMT(B16/12,360,-B18), whereB18is the loan,=B8*(1-B10)for buy-and-hold and=C14*C17for BRRRR withC17at 75 percent - Cash flow per door:
=B23-B24
| Per house, per month | Buy-and-hold | BRRRR |
|---|---|---|
| Net operating income | $976.00 | $1,051.00 |
| Loan amount | $135,000 | $157,500 |
| Principal and interest | $909.06 | $1,172.19 |
| Cash flow per door | $66.94 | -$121.19 |
| Cap rate (NOI over value) | 6.51% | 6.01% |
| Loan constant (annual debt service over loan) | 8.08% | 8.93% |
Both houses borrow at a loan constant above their cap rate, which is negative leverage, the condition explained in the cap rate calculator article. The BRRRR house is further underwater on that test because it borrows 75 percent of a higher value at a higher rate. The renovated house rents for more and still loses $121.19 a month.
The clock is set by the Selling Guide
The six months come from Fannie Mae's Selling Guide, section B2-1.3-03 (version dated December 10, 2025), sets three rules that decide when the BRRRR money comes back:
- At least one borrower must have been on title for six months before the new loan disburses.
- Under the delayed financing exception, a cash buyer can refinance sooner, but the new loan can be no more than the documented amount paid to purchase the property plus the closing costs, fees and points of the new loan. Rehab money is not on that list. For this house, a month-4 refinance returns $114,240 and leaves $38,020 of rehab and carry inside the house.
- If a first mortgage is being paid off, it must be at least 12 months old, measured note date to note date. Buy with a hard money loan and a conventional cash-out refinance waits a full year.
The same section prices a delayed financing loan as a cash-out loan ("cash-out pricing is applicable") and lists loan-level price adjustments for cash-out refinances, which is why row 19 carries 3.5 percent for refinance costs and points (2.5 percent closing plus 1 point, both placeholders for your lender's quote). Section B2-2-03 caps a borrower at 10 financed properties for an investment loan, counting a mortgaged home. The BRRRR seasoning period tracker handles the date arithmetic for each lender; this calculator only needs the result in months.
Build the Deals Tab: Where the BRRRR Clock Lives
Buy-and-hold is one line: three houses bought in month 0. The doors formula is =MIN(10,INT(B3/B26)), where B26 is =B8*(B9+B10), the cash per house. BRRRR needs a row per deal, because each deal's start date depends on when the previous one paid back.
| Column | Deals tab field | Formula in row 3 (deal 2) |
|---|---|---|
| B | Buy month | =E2+Inputs!$C$31 |
| C | Size factor | =MIN(1,(INDEX(Timeline!$H:$H,B3+2)-5000)/Inputs!$C$26) |
| D | Cash spent | =C3*Inputs!$C$26 |
| E | Refinance month | =B3+Inputs!$C$30 |
| F | New loan | =C3*Inputs!$C$18 |
| G | Cash back | =F3*(1-Inputs!$C$19) |
| H | Monthly payment | =PMT(Inputs!$C$16/12,360,-F3) |
| I | Balance at horizon | =-FV(Inputs!$C$16/12,Inputs!$B$4-E3,-H3,F3) |
C30 on Inputs is the seasoning (6 months), C31 the months it takes you to find and close the next deal (2), and C26 the all-in cash per deal, =C8*(1+C9)+C11+C12*C13. The size factor matters more than it looks. When the refinance returns less than the deal cost, or negative cash flow has drained the account, the next deal has to be smaller. The factor scales price, rehab, rent and value together, and a deal below half size gets flagged with =IF(C3<0.5,"STOP",""), because a $56,000 house is a different market, not a smaller version of this one.
The Timeline tab runs months 0 to 60 down the rows. Column H is the cash balance: last month's balance, plus rent cash flow, plus refinance proceeds, minus purchases, rehab and carry. Rent-ready doors in any month come from =SUMPRODUCT((A3-Deals!$B$2:$B$12>Inputs!$C$12)*Deals!$C$2:$C$12), and debt service from =SUMPRODUCT((Deals!$E$2:$E$12<A3)*Deals!$H$2:$H$12). Empty deal rows carry a size factor of zero and drop out of both sums.
Per deal, the base case works out cleanly. All-in $152,260. Appraisal $210,000. Loan $157,500. Cash back after 3.5 percent costs $151,987.50. Left in the deal $272.50. Each deal creates $57,740 of equity between the all-in cost and the appraised value, which is the forced equity BRRRR courses talk about. With a two-month search the investor buys in months 0, 8, 16, 24, 32, 40 and 48, the last at 99 percent of full size because the negative cash flow on the first six houses has drawn down the account.
The Answer Every Calculator Gives, and the Bridge Behind It
At month 60 the Results tab reads:
| Month 60 | Buy-and-hold | BRRRR |
|---|---|---|
| Houses | 3 | 7 |
| Market value | $610,960 | $1,568,727 |
| Mortgage debt | $381,718 | $1,076,353 |
| Cash on hand | $20,848 | $147,345 |
| Net worth (value minus debt plus cash) | $250,091 | $639,718 |
| Portfolio cash flow per month | $200.81 | -$847.10 |
BRRRR is ahead by $389,627, and if you stop there the question is settled. The Bridge tab breaks each result into the sources of that money, and it reads differently:
| Bridge line | Buy-and-hold | BRRRR |
|---|---|---|
| Starting capital | $160,000 | $160,000 |
| Forced equity (value at stabilization minus all-in cost) | -$16,200 | $403,591 |
| Refinance costs and points | $0 | -$38,531 |
| Appreciation at 2.5% a year | $70,961 | $100,868 |
| Principal paid down | $23,282 | $24,540 |
| Cumulative cash flow | $12,048 | -$10,750 |
| Net worth at month 60 | $250,091 | $639,718 |
| Rental portfolio return (refinance costs, appreciation, principal and cash flow) | $106,291 | $76,127 |
The formulas sit on Deals and Timeline. Forced equity is =SUMPRODUCT(Deals!C2:C12*Inputs!C14)-SUM(Deals!D2:D12). Refinance costs are =-SUM(Deals!F2:F12)*Inputs!C19. Principal paid is =SUM(Deals!F2:F12)-SUM(Deals!I2:I12). Cumulative cash flow is =SUM(Timeline!E2:E62). The buy-and-hold forced equity is negative because buying at retail only costs you the closing costs: $5,400 a house, three times.
Forced equity is pay for work. Seven times, the BRRRR investor found a distressed house, priced the rehab, hired and supervised the crews, carried the vacancy and leased the result, and each project paid $57,740, about $9,623 for each month between purchase and refinance. That is a construction business. A flipper doing the same seven projects earns the same spread, sells instead of refinancing, and pays selling costs out of it.
What the rental portfolio itself earned is the sum of appreciation, principal, cash flow and refinance costs. On that line the three plain houses beat the seven renovated ones by $30,164, while carrying $381,718 of debt instead of $1,076,353. The BRRRR portfolio has more houses appreciating, but it pays $38,531 to refinance them and $10,750 to carry them at 8.15 percent. The rental property comparison spreadsheet makes the same point for single acquisitions: ranking on the wrong denominator reverses the order.
What Moves the Result
Three inputs move the BRRRR column far more than anything else. Each table below changes one input and keeps everything else at the base case.
Months between deals
| Search months (C31) | Cycle | Houses | Net worth | Forced equity | Rental return | Cash flow, month 60 |
|---|---|---|---|---|---|---|
| 1 | 7 months | 8 | $706,214 | $461,060 | $85,154 | -$968 |
| 2 | 8 months | 7 | $639,718 | $403,591 | $76,127 | -$847 |
| 4 | 10 months | 6 | $568,325 | $345,663 | $62,662 | -$726 |
| 6 | 12 months | 5 | $502,807 | $288,286 | $54,521 | -$605 |
| 10 | 16 months | 4 | $434,365 | $230,634 | $43,732 | -$484 |
Deal flow drives the result. At a one-month search the investor ends with eight rentals; add a mortgaged home and that is nine of Fannie Mae's ten. Buying with hard money pushes the cycle to 14 months under the 12-month note rule: four houses and $465,163 of net worth, before a dollar of hard money interest, which this model does not charge.
The rate on refinance day
| Freddie Mac average at refinance | Cash flow per door | Net worth | Rental return | Cash flow, month 60 |
|---|---|---|---|---|
| 6.37% (April 2026 level) | -$9.58 | $668,881 | $104,701 | -$67 |
| 7.40% (October 2026 level) | -$121.19 | $639,718 | $76,127 | -$847 |
| 8.40% | -$233.32 | $602,678 | $48,282 | -$1,594 |
Even at the April rate, the BRRRR rental portfolio earns $1,590 less than buy-and-hold over five years. Every refinance date is a new rate exposure, and the model holds 7.40 percent for all seven of them; set row 15 to whatever you expect, and run the 8.40 percent line before you buy.
The appraisal
| Appraisal below plan | Left in each deal | Houses | Net worth | Forced equity | Cash flow, month 60 |
|---|---|---|---|---|---|
| 0% | $272 | 7 | $639,718 | $403,591 | -$847 |
| 10% | $15,471 | 7 | $441,842 | $201,472 | -$22 |
| 15% | $23,071 | 6 | $355,459 | $115,342 | $240 |
A low appraisal halves the forced equity and shrinks every later deal, down to 51 percent of full size by the sixth house at a 15 percent shortfall. It also lowers the loan, which is why cash flow improves. The cash left in deal calculator covers that trade in detail. Even here BRRRR still finishes ahead on net worth. Solving for the crossover, BRRRR only falls behind buy-and-hold when the spread between all-in cost and appraised value drops to about $6,401 a deal, an ARV of $158,661 on this house.
Which One to Run
On net worth, BRRRR wins almost every row of these tables. The question this calculator settles is different: whether you want the construction business that produces that result, and whether you can carry the rental portfolio it leaves behind. Run your own numbers through four checks.
- Price the paycheck. Divide forced equity per deal (
Inputs!C29,=C14-C26) by the hours you will spend per project. If that rate does not beat what the same hours earn elsewhere, buy-and-hold is the better use of your time. - Compare the rental lines. If the BRRRR rental return on the Bridge tab trails buy-and-hold at your refinance rate, you are storing rehab profits in houses that underperform plain rentals. Consider selling some of the renovated houses and holding fewer, or refinancing below 75 percent.
- Fund the negative cash flow. At 7.40 percent the BRRRR portfolio here costs $847.10 a month by month 60. That money comes from your income or your reserves; the HELOC vs cash-out refinance comparison shows what borrowing it costs instead.
- Count your deal flow honestly. If you closed one distressed purchase in the last twelve months, that is your pace: set the search time in
C31to six months, which makes the cycle twelve.
Track each house afterward in a real estate portfolio tracker so the Bridge lines stay current as rents and rates move.
Every BRRRR row on the Deals tab starts with three numbers: the all-in cost, the cash back at refinance and the new payment. The BRRRR Deal Calculator produces those for one deal: acquisition with hard money points and short-term rates, a line-item or quick-entry rehab budget, rent and operating expenses down to stabilized NOI, and a refinance tab that returns cash pulled out, capital left in the deal and the new monthly payment. It does not run the 60-month timeline or the buy-and-hold comparison. Run each candidate deal through it, copy the three outputs into a Deals row, and the Bridge tab will show whether that house adds to the rental portfolio or only to the rehab business.
Related template
BRRRR Deal Calculator
Model the full Buy-Rehab-Rent-Refinance-Repeat cycle. See exactly how much capital comes back at refinance — before you commit a dollar.
Get the Template — $49