Flip to Rental Pivot Calculator in Excel: Price Cut or Refinance?

The flip has been on the market for 70 days at $399,000. No offers, two showings last week, and the hard money note keeps charging $2,566.67 a month in interest. The idea that arrives around day 60 is always the same: stop selling, rent it out, refinance into a long-term loan and wait for the market to come back. A flip to rental pivot calculator in Excel is the tool for deciding whether to sell or rent a flip, and on the example deal below it shows something most investors do not price before they call a lender: converting this flip to a rental does not hand you cash. It asks you for $52,739.68 of new cash and swaps a known loss for a bet on appreciation.

Every number in this article comes from one example deal. Swap in your own; the structure of the comparison is what you keep.

Both exits run against the same clock: hard money interest plus vacant carry comes to $3,261.67 for every month the house stays unsold.

Price the sale you can actually close

The first column of the comparison is the sale, and it has to use the price a buyer will sign at. After 70 days with no offer, the market has already answered the $399,000 question. In the example, a price cut produces an offer at $372,000 that closes six weeks later, at month 8.5, inside the hard money term.

Leave out what you already spent. The down payment, the origination points and seven months of interest are gone on both paths, so they cannot help choose between them. Investors who keep them in the sheet end up picking the exit that "gets their money back", which is how a stuck flip turns into a negative rental. If you have not decided how deep the cut should be, the price reduction decision calculator handles that question; this article starts once a real offer price exists.

In the sheet, the sale column is two formulas. Monthly carry in E3 is =B5*B6/12+B7, and the net cash from selling in E4 is =B8*(1-B10)-B5-B9*E3, where B8 is the offer price, B10 the 7.5% of total selling costs and B9 the months to closing. On the example deal, E4 returns $59,207.49.

The refinance is sized by the rent, and the appraisal comes second

A DSCR refinance after hard money is where the pivot plan usually breaks. The plan sounds like this: the house appraises near $372,000, the lender does 75% loan-to-value (its limit for a 700 to 719 credit score on a rate-and-term refinance in the matrix below), that is $279,000, which pays off the $280,000 hard money loan almost exactly. The plan fails at the debt service coverage ratio, the test a DSCR lender runs instead of looking at your personal income: qualifying rent divided by PITIA (principal, interest, taxes, insurance and association dues).

At an 8.25% rate on a 30-year fixed loan (an example quote; use yours), a $279,000 loan costs $2,096.03 a month in principal and interest. Add $350 of taxes and $150 of landlord insurance and PITIA is $2,596.03 against $2,350 of rent. The ratio is 0.905.

One wholesale lender's published DSCR rental matrix (Constructive Capital, effective October 22, 2024) shows what happens next. Above 65% LTV it requires a DSCR of at least 1.00x on purchases and rate-and-term refinances. At 65% LTV or below it accepts 0.75x. So the loan on this house is the larger of two numbers:

• The loan the rent can carry at 1.00x: PITIA can be at most $2,350, which leaves $1,850 for principal and interest, which supports $246,250. That is 66.2% of the appraisal.
• The 65% fallback: 65% of $372,000 is $241,800.

The answer is $246,250, which is $33,750 short of the hard money payoff before a single closing cost. In the sheet, E5 tests the full-leverage loan with =B12/(PMT(B13/12,360,-B11*B15)+B14), E6 finds the largest loan the rent supports with =FLOOR(PV(B13/12,360,-(B12/B16-B14)),50), and E7 picks the loan the lender will write with =IF(E5>=B16,B11*B15,MAX(MIN(E6,B11*B15),B11*B17)). B16 holds the 1.00 minimum and B17 the 65% fallback.

Now the appraisal argument you are preparing for. Suppose the appraiser lands at $399,000, your list price. 75% of that is $299,250, and the DSCR at that loan is 0.855, so it fails again. The lender drops to the 65% tier: $259,350, at a DSCR of 0.96. You gain $13,100 of loan, where 75% of the extra $27,000 would have been $20,250. The same matrix asks for 12 months of PITIA in reserves instead of six when DSCR is under 1.0, which is $29,380.92 on that loan, and 24 months ($58,761.84) if the loan being paid off is not from a recognized servicer or bank, a description that can fit a private hard money lender. The appraiser will also see why the house is still yours: Fannie Mae's Selling Guide (B4-1.3-02) has the appraiser report every listing of the subject in the prior 12 months with offering prices and dates. The rent figure this matrix relies on, the Form 1007 rent schedule, belongs to the same family of appraisal forms.

The lender's calendar adds two more costs

Three rules in that matrix shape the pivot timeline, and your lender's version will have its own equivalents. Read them before you take the sign down.

• Seasoning sets which value counts. Owned 3 months or less, the loan is capped at purchase price plus verified improvements. Between 3 and 6 months, the loan cannot exceed 100% of that cost basis, though the matrix lets the as-is value size the loan when total loan-to-cost is 120% or less. After 6 months, the as-is appraisal applies, capped at 140% of cost basis. On this deal the cost basis is $307,000, so the cap is $429,800 and never binds. The rent binds first. For the full set of clocks lenders run, see the BRRRR seasoning period tracker.
• The house must be leased. For refinances, a single-family property must be leased at closing, and every property owned more than 6 months must be occupied and leased. At month 7, that means you find a tenant before you can even apply.
• Rate-and-term means rate-and-term. The borrower can take at most 2% of the loan amount in cash at a no-cash-out refinance. Cash-out has its own leverage table, capped at 75%.

The conventional route is closed for a different reason. Fannie Mae's cash-out rules (B2-1.3-03) require the first mortgage being paid off to be at least 12 months old by note date, and a 9-month hard money note never is. Its limited cash-out refinance (B2-1.3-02) has no such seasoning rule, but caps cash back at the greater of 1% of the new loan or $2,000, and it underwrites your personal debt-to-income ratio instead of the property's DSCR.

The lease requirement costs time. In the example, it takes six weeks to make the house rental-ready and sign a tenant, and the refinance closes a month after move-in, at month 9.5. That is past the hard money maturity, so the hard money extension fee lands: $2,800 for one point, paid to buy two weeks.

What converting the flip to a rental costs before it pays a dollar

Here is Path B, from today to the refinance closing table.

The matrix also wants six months of PITIA sitting in liquid accounts after closing, $14,099.94, plus 1% of the balance of your other mortgages. That money is not spent, but it cannot be the down payment on your next flip either.

Put the two columns side by side at the decision point. Selling puts $59,207.49 in your account by month 8.5. Pivoting takes $52,739.68 out by month 9.5. The difference in liquidity between the two exits is $111,947.17, on a house whose list price was $399,000. A stuck flip exit strategy that ignores this line is really a decision about how much of your next year's deal flow you want to give up.

In the sheet, cash to close in E8 is =B5+B20+E7*B19+B18-E7, with B20 the extension fee, B19 the refinance points and B18 the fixed refinance costs ($5,555). E9 adds the bridge cost from B21: =E8+B21.

Only appreciation can pay for the pivot

Once the refinance closes, the rental runs at a loss. Budget 5% vacancy, 8% management, 6% maintenance and 5% capital reserves, 24% of rent in all, or $564 a month. Taxes and insurance take $500. That leaves $1,286 before debt service, against $1,849.99 of principal and interest. Cash flow is -$563.99 a month, or -$6,767.88 a year. A loan sized to exactly 1.00x coverage guarantees this result: the rent covers PITIA and nothing else, so every operating cost comes out of your pocket. Principal paydown offsets part of it, $6,389.16 over three years, and that equity stays locked in the house until you sell.

So the honest version of the pivot is a three-year hold that ends in a sale anyway, with a second round of selling costs (6.5% here) and a make-ready after the tenant leaves (1.5%). The question becomes: how fast must the house appreciate for Path B to finish ahead of Path A? The sheet answers it in E12 with =((E4+E9-B23*12*E10+E11)/(1-B24)/B11)^(1/B23)-1, where E10 is the monthly cash flow =B12*(1-B22)-B14-PMT(B13/12,360,-E7) and E11 the loan balance at exit, =-FV(B13/12,B23*12,-PMT(B13/12,360,-E7),E7).

Breakeven is 2.83% a year if the sale cash would have sat idle, and 4.31% a year if it would have earned the 13-week Treasury bill rate, 4.14% coupon-equivalent on October 23, 2026 (U.S. Treasury daily bill rates). For the second figure, E13 compounds each column: =((E4*(1+B25/12)^(B23*12+1)+E9*(1+B25/12)^(B23*12)+FV(B25/12,B23*12,E10)+E11)/(1-B24)/B11)^(1/B23)-1. The extra month in the first exponent is the gap between the sale closing at month 8.5 and the refinance at month 9.5.

Compare those thresholds with the market. The FHFA House Price Index rose 2.6% nationally from July 2025 to July 2026 (released September 29, 2026). On this deal, the pivot needs the house to beat the national pace for three straight years just to tie a sale whose cash earns Treasury bill interest. Both columns are pre-tax. A flipper's inventory is not a capital asset under 26 U.S.C. §1221(a)(1), and whether a converted house changes character is a facts-and-intent question the sheet cannot settle, so run that one with your tax preparer before you sign a lease.

When the rental pivot does beat the price cut

The obvious lever is rent, so run the deal at four rent levels. Everything else stays fixed.

Two things stand out. At $2,100 the loan falls into the 65% tier with a DSCR under 1.0, so the reserve requirement doubles to 12 months of PITIA. And at $2,600 the new cash drops by $32,527.50, but the breakeven barely moves when the cash would sit idle (2.96% against 2.83%): the bigger loan at 8.25% costs more in interest than the extra rent brings in. The extra rent solves the cash problem and leaves the return almost where it was, because the house was bought and renovated for a retail buyer, not for rent.

The other lever investors reach for is a deeper cut. Rerun the deal with a $360,000 sale that takes two months to close, and an appraisal at the same $360,000. Path A falls to $46,476.66. Path B still needs $52,739.68, because the rent sizes the loan. Breakeven moves only from 2.83% to 2.76% (idle) and from 4.31% to 4.12% (T-bill). The market that refuses your price also appraises your refinance and buys the house in three years, so a weaker market makes both exits worse together.

The pivot wins on deals with a different shape: a purchase cheap enough that rent covers PITIA at 75% LTV with room left, a DSCR rate close to the 7.32% average Freddie Mac reported for 30-year conventional loans on October 22, 2026, or a house you would have wanted as a rental on the day you bought it. The DSCR calculator tells you in a minute which side of 1.00x the deal sits on. If your plan was always a refinance and the appraisal is the problem, the appraisal shortfall calculator prices that case. A lease option is a third exit worth one row in the same sheet when a few buyers want the house but cannot close on it yet.

Lay out the sheet so the exit is chosen by cash

One tab, inputs in column B, outputs in column E. Keep the inputs you will argue about in their own cells so a lender quote or a new offer changes one number.

Add one flag next to the timeline: =IF(B26>B27,"EXTENSION FEE","OK"), with the refinance month in B26 and the hard money maturity in B27. On this deal it reads EXTENSION FEE, and that $2,800 is what it costs to discover the lease requirement late. Before you decide, collect three numbers from outside the sheet: the lender's current matrix (DSCR tiers, seasoning, lease and reserve rules), a written rent opinion on the Form 1007 basis, and the hard money lender's extension terms in writing. Holding costs during lease-up behave like the flip's own carry, so the holding costs calculator numbers carry straight into the bridge line.

Take the cut on this deal, and check DSCR at purchase on the next one

On the example deal, sell. Accept the $372,000 offer, close inside the hard money term, and put $59,207.49 back to work. The rental pivot asks for $52,739.68 of new cash, loses $563.99 a month, and needs 4.31% annual appreciation for three years to tie a Treasury bill, against 2.6% for the national index over the last year. Pivot only if your own sheet shows a DSCR loan that pays off the hard money with less than one month of carry in new cash, or a breakeven appreciation below the local trend you can document.

The bigger fix happens before the next purchase. Run every flip with a rental exit priced in, so you know on day one whether the house can carry a DSCR loan if the sale stalls. The BRRRR Deal Calculator does that in one workbook: the acquisition tab handles hard money points and rates, the rent analysis tab gives stabilized NOI and cash flow, and the refinance tab shows cash pulled out, capital left in the deal and the new payment. It sizes the refinance by LTV, so enter the rent-limited loan as an LTV (246,250 divided by 372,000 is 66.2% here) and it shows the capital trapped in the deal. It does not model the price-cut sale; that is the column from this article you place next to it.