BRRRR Cash Left in Deal Calculator in Excel: What Actually Recycled

An investor in Columbus closes the refinance on his third BRRRR, watches $56,350 land in his account, and tells his partner the deal recycled. He bought the house at $118,000, put $42,000 of rehab into it, and the appraisal came back at $215,000. His napkin math says he is all in at $177,400 against a new loan of $161,250, so he left roughly $16,000 in the property. The real number is $20,750. Add the six months of reserves his lender requires him to keep parked and $29,180 of his capital is sitting inside that house, unavailable for the next deal. A BRRRR cash left in deal calculator built in Excel exists to close that $13,000 gap between the story and the bank statement, because the number that decides whether you get to repeat is not your equity, your ARV, or your cash flow. It is how much of your own money came back out.

Most BRRRR content treats zero cash left in deal as the win condition. It is not, and treating it that way is how investors end up owning eight houses that lose money every month. Cash left in deal and monthly cash flow are two ends of one lever. The refinance percentage does not create value, it only decides which end you take your compensation in. Here is how to build the model in Excel, and more importantly, how to read the answer when it tells you the deal never worked at any loan amount.

What Cash Left in Deal Actually Counts

The reason the Columbus investor was off by $13,030 is not bad arithmetic. It is an incomplete ledger. Cash left in deal is not all-in cost basis minus the new loan. It is every dollar that left your bank account, minus every dollar the refinance sent back. Those are different numbers because your cost basis includes money the purchase lender fronted, and your refinance proceeds are net of costs the loan amount never shows.

Four line items get dropped almost every time:

• Refinance closing costs. Origination, appraisal, title, and recording on a cash-out refinance run $4,000 to $6,000. That money comes off your proceeds, not off your loan amount.
• Holding costs during the rehab. Points and interest on hard money, plus taxes, insurance, and utilities while nobody is paying rent. Seven months on this deal cost $12,700.
• Lease-up costs. Marketing, tenant screening, the property manager's placement fee. Small, real, and always paid in cash.
• Lender reserves. Most DSCR lenders require six months of PITIA in verified reserves. You do not spend it, which is exactly why it gets forgotten, but you also cannot deploy it into the next purchase. It is committed capital.

Build the ledger as a single column so the total is one formula, not a mental estimate.

Note what is not in B12: the $100,300 the purchase lender put up. That is not your cash, so it never belonged in the cash-in ledger, and the refinance paying it off is not money coming back to you. Half the confusion around cash left in deal comes from mixing the two.

Track rehab as spend, not as budget

If your lender funds rehab in draws, you still front each line item and wait three to five weeks for reimbursement. Model the reimbursements as they land, not as they were promised. Use =SUMIFS(Ledger!D:D,Ledger!B:B,"Rehab",Ledger!C:C,"Paid") against a running transaction sheet so B8 reflects what actually cleared. A draw schedule that runs two draws behind can put $18,000 of temporary cash left in deal on your balance sheet for a quarter, which is enough to make you miss the next acquisition.

Build the Cash Left in Deal Calculator in Excel

The refinance block sits directly under the ledger so both totals are visible at once. Your loan amount is set by the appraisal, not by what you paid, which is the single most useful structural fact in the whole model.

B25 is the number to put in front of your own face. Capital recycle rate tells you what fraction of the money you deployed is available to deploy again, and it is the only input that matters when you are projecting how fast a portfolio grows. A 73 percent recycle rate does not mean you did 73 percent of a BRRRR. It means every deal permanently retires 27 percent of your working capital.

The operating block turns the new loan into a monthly outcome:

Now the two return lines that most spreadsheets skip. Cash-on-cash return on trapped capital is =IFERROR(B39*12/B24,"No cash trapped"), which returns 0.9 percent here. The honest version adds first-year principal paydown, since that is a real return on the dollars you left behind: =IFERROR((B39*12+B38*12+CUMIPMT(B17/12,B18*12,B21,1,12,0))/B24,"") gives $1,740 against $20,750, or 8.4 percent. That is the number to compare against what the same $20,750 would earn as the down payment on your next deal. If your next BRRRR returns 20 percent cash-on-cash, leaving $20,750 here to earn 8.4 percent costs you roughly $2,400 a year in opportunity, every year, until you sell or refinance again.

Zero Cash Left In Is the Wrong Target

Here is where the lever shows itself. Same house, same appraisal, same rent, four quotes from four lenders. Watch cash left in deal fall and watch what happens on the other end.

Two things in that table deserve a hard look. First, the 80 percent column recycles 87 percent of the capital and loses $1,416 a year. That is the deal an investor posts about. Eight of them is a portfolio that costs $11,328 a year to own before the first water heater fails. Second, every column passes the lender's DSCR test at 1.20, including the one that bleeds. DSCR compares rent to principal, interest, taxes, and insurance. It does not know about management, vacancy, maintenance, or capex. A lender approving your refinance is not confirming the deal works. It is confirming the loan is collectable.

So set your own two thresholds in the sheet and let it call the deal:

• B47, maximum acceptable cash left in deal: $8,000
• B48, minimum acceptable monthly cash flow: $150
• B49, verdict: =IF(AND(B24<=B47,B39>=B48),"RECYCLED","CHECK THE LTV TABLE")

Then run the LTV column from 60 percent to 80 percent in rows and flag each with =IF(AND(D55<=$B$47,F55>=$B$48),"PASS","FAIL"). The headline you actually want is =IF(COUNTIF(G55:G63,"PASS")=0,"NO LTV WORKS. FIX BASIS OR RENT.","OK"). On this deal, no LTV passes. Not one. That verdict is worth more than any single output in the model, because it tells you the refinance was never the problem.

Purchase Price Controls Trapped Cash, Rent Controls Cash Flow

Hold rehab, holding costs, ARV, and LTV fixed, then change only the purchase price. Your down payment moves by 15 percent of the change, and the payoff moves by 85 percent of the change. Add those together and something clean falls out of the algebra: cash left in deal moves dollar for dollar with the purchase price. On this deal the relationship is exactly =B4-97250. Every $1,000 you overpay is $1,000 trapped in the house for as long as you own it.

Meanwhile the payment is set by the appraisal, not the price, so the purchase price does not move your cash flow by a single dollar. Cash flow is a rent problem. Solve for the rent that clears your threshold with =(B48+B38+B31+B32+B34)/(1-0.09-0.06), which returns $2,053. Against a $215,000 ARV, that is 0.955 percent monthly rent to value. The one percent rule is not folk wisdom. It is roughly the rent required to make a 75 percent cash-out refinance cash flow at seven and a quarter.

Read the last row carefully. A perfect BRRRR, 100 percent of capital returned, and the house still pays you $15 a month. That is the trap in chasing zero cash left in deal as the goal. You can win the metric completely and own something that cannot fund its own roof.

What the Recycle Rate Does to Your Deal Count

Take a $150,000 working capital base, one deal at a time, nine months per cycle. Each deal ties up the full out-of-pocket amount during the project and permanently retires whatever gets left in.

The difference between paying $118,000 and $105,250 for the same house is 11 percent on the contract. On your business it is the difference between four deals and ten from the same capital. Model it with =IF(B24<=0,"Unlimited",ROUNDDOWN((150000-B12)/B24,0)+1) and put that cell next to your maximum offer, because it converts a negotiating position into a deal count. Walking away from an overpriced house is not discipline for its own sake. It is six future acquisitions.

The pre-refinance checklist

• Get the lender's exact cash-out LTV cap in writing, along with the seasoning period, before the rehab starts.
• Ask what the reserve requirement is in months and whether it must be seasoned. That is capital you cannot count on.
• Get a written closing cost estimate and subtract it from proceeds, not from the loan amount.
• Run your rent through a property manager, not through your own optimism. A $150 rent miss moves cash flow by more than a quarter point of rate.
• Compute cash left in deal at the appraisal you fear, not the one your comps support.
• Check that at least one LTV row passes both thresholds. If none does, renegotiate the price or drop the deal.

Run the Numbers Before the Offer, Not After the Refinance

Every calculation above works exactly as well before you write an offer as it does after the appraisal, and it is worth ten times more early. After the refinance, cash left in deal is a fact you record. Before the offer, it is a price you set, because the purchase price is the only input in the whole model that you control outright. The investor in Columbus did not have a refinance problem. He had a $20,750 offer problem, and he found out about it eight months and one appraisal too late.

If you would rather not rebuild the cash-in ledger, the net proceeds math, the LTV sweep, and the recycle rate on every deal, the SheetCraft Flip and BRRRR Calculator has all of it wired together already: a full cash deployed ledger with draw-reimbursement timing, cash left in deal and capital recycle rate as headline outputs, an LTV table that flags when no loan amount satisfies both your capital and cash flow thresholds, and a maximum offer solver that backs the purchase price out of the cash you need returned. It costs $49. That is one fifth of one percent of the capital this one deal left stranded, and the sheet takes about fifteen minutes to fill in. Decide what you are willing to leave in a house before you decide what you are willing to pay for it, and the repeat leg of BRRRR stops being a hope and starts being arithmetic.