Cash-Out Refinance Calculator for Rental Property: Pull Equity, Keep Cash Flow

An investor in Ohio owns a rental worth $400,000 with $210,000 left on a 4.0 percent mortgage. He does the math everyone does: $400,000 minus $210,000 is $190,000 of equity, and a lender will let him pull most of it out tax-free. He calls a broker, gets approved for a 75 percent cash-out at $300,000, and walks away with $82,500 to fund the next deal. It feels like free money, because the IRS does not tax loan proceeds. Eight weeks later the new payment hits and the property that paid him $790 a month now costs him $107 a month to own. He did not unlock $82,500 of free money. He converted a cash-flowing asset into a liability he has to feed, and he did it at the worst possible time. A working cash out refinance calculator for rental property built in Excel would have shown him that before he signed, because it answers the question the equity number never does: how much cash can you actually pull before the new rate breaks the deal.

Equity is what you could sell for. Cash-out capacity is what you can borrow against today, at today's rate, while keeping the property bankable and cash-flowing. Those are two different numbers, and in a higher-rate market they are not close. This is how to build the calculator that tells them apart.

Tax-Free Is Not Free

The pitch for a cash-out refinance leans hard on one true fact: the money you receive is not taxable. It is debt, not income, so there is no capital gains hit and no ordinary income tax. That part is real. The part the pitch skips is that a cash-out refinance does not just add new debt. It replaces your entire existing loan with a bigger one at the current rate. You are not borrowing $90,000 extra at 7.25 percent. You are re-pricing your whole $210,000 balance from 4.0 percent up to 7.25 percent, and then adding the new money on top.

That re-pricing is the hidden cost. The investor above was paying $1,150 a month on his old $210,000 loan. At 7.25 percent, that same $210,000 balance would cost $1,433 a month. So before he receives a single dollar of cash, the decision to touch the loan at all costs him $283 a month, $3,396 a year, in extra interest on money he already had. The headline says tax-free. The fine print says you just gave up the cheapest loan you will ever have.

Build the Cash-Out Calculator in Excel

Put every input down column B so the formulas read cleanly. The goal is three outputs: the most a lender will lend, the cash that actually reaches your account, and what the new payment does to your monthly cash flow.

Cell B7 is your net operating income, rent minus everything except the mortgage. Itemize B6 properly: taxes, insurance, vacancy at 5 percent, repairs, capital reserves, and management. Do not use a flat percentage of rent here, because the whole point of the calculator is to catch the property that does not behave like the average.

Now the outputs. The maximum loan a lender will write is the appraised value times the loan-to-value ceiling. Cash-out refinances on investment property almost always cap lower than a primary residence, usually 70 to 75 percent, and most lenders require six to twelve months of seasoning before they will count a higher appraised value.

Two things break at once. B16 shows the property now loses $107 a month. And B17 shows the debt service coverage ratio fell to 0.95, which means the rent covers only 95 percent of the new mortgage. No investment lender writes a 0.95 DSCR loan. The minimum is usually 1.25. So the $82,500 the broker quoted is not actually available. The lender will decline the loan at that amount, and even if they did not, you would be feeding the property out of pocket to own it.

The Three Numbers That Cap Your Cash-Out

Your real cash-out is the lowest of three ceilings: the LTV the lender allows, the loan size that keeps DSCR at or above the lender minimum, and the loan size that keeps your own cash flow above zero. Build all three and take the smallest. The DSCR ceiling is the loan amount whose payment equals your NOI divided by the required ratio. In Excel that is the present value of that payment stream.

The binding constraint is not the equity. It is the rate. This investor has $190,000 of equity on paper, and he can responsibly pull about $10,000 of it. Option A looks like the deal until the DSCR test kills it. Option B is the most a lender will actually fund without forcing the payment past what the rent supports. Option C, your personal floor, lands a hair tighter. The honest answer to "how much can I pull" is $8,000 to $10,000, not $82,500. The other $72,000 of equity is real, but you can only reach it by selling, not by borrowing at 7.25 percent.

The Re-Pricing Penalty Nobody Mentions

Go back to Option A and split the new payment into its two parts. The new P and I is $2,047. The old was $1,150. That is $897 more a month, $10,764 a year. Decompose it.

The $283 a month is pure penalty. You pay it for the privilege of touching a loan that was cheaper than anything on the market, and you get nothing for it. It is the cost of unlearning a 4.0 percent rate. Any cash-out calculator that does not show this line is hiding the worst part of the trade. When rates are below your existing note, a cash-out refinance is close to free. When they are above it, the first few thousand dollars you pull cost you the entire rate spread on your existing balance.

The Redeployment Test

Suppose you take Option A anyway, because you have a deal that needs the cash. The honest cost of that $82,500 is the full $10,764 a year in extra debt service, because you only triggered the re-pricing by doing the refinance. That is a true cost of capital of 13.0 percent (=10764/82500) on the cash you receive, and that is before you account for the property flipping to negative cash flow. So the test is simple and brutal: the next deal has to return more than 13 percent cash on cash just to break even against what the refinance costs you.

Run it as a single flag. Put your expected return on the redeployed cash in B20 and compare:

At an 11 percent expected return, the next deal loses to the refinance. You would be borrowing at a 13 percent true cost to chase an 11 percent return, while turning a $790-a-month winner into a property that bleeds. The spreadsheet says keep the low rate. Most of the time, in a market where new rates sit above your existing note, that is the right answer. The cash-out makes sense when your existing rate is already high, when the next deal clears the true cost with room to spare, or when you genuinely need liquidity and have priced the cost honestly. It rarely makes sense just because the equity is sitting there.

Run Every Refinance Through the Model First

The reason investors over-pull is that the equity number is easy and the cash-out number is hard. Equity is one subtraction. Real cash-out capacity requires an LTV ceiling, a DSCR test, a cash-flow floor, a re-pricing decomposition, and a redeployment hurdle, all moving together when you change the rate by half a point. Do it by hand once and you will accept the broker's number forever, because the broker's number is the one that gets the loan funded, not the one that keeps your portfolio solvent.

If you want the cash-out model already wired up, the SheetCraft Flip and BRRRR Calculator has the full refinance leg built in: LTV and seasoning caps, DSCR at the lender minimum, the re-pricing penalty split out as its own line, and a redeployment test that compares the true cost of your cash against the deal you want to fund. It is the same engine BRRRR investors use to decide whether the refinance pulls all their capital back out or leaves some trapped. Drop in your appraised value, your existing balance and rate, and today's quote, and let the sheet tell you the difference between the equity you can see and the cash you can actually pull. Stop refinancing on the headline number. Run the deal through the model first and let it kill the cash-out that would have cost you the cheapest loan you own.