Analysis

What Can You Pay for a Rental and Still Hit Your Cash Flow Target?

Nov 6, 20268 min read

To find the purchase price a rental can support, subtract operating costs and your cash-flow target from collectible rent. What remains must cover the mortgage payment and any costs that rise with price. Solve for price, then check whether you have enough cash for the down payment, closing, repairs and reserves. The lower constraint governs your offer analysis.

The result is an underwriting limit under stated assumptions, not an appraisal or a prediction of what a seller will accept. This guide builds a manual worksheet using a hypothetical $2,400 rental. You can verify the candidate price in the single-family rental calculator; the article does not assume that the calculator has an automatic reverse-offer feature.

Define the cash flow you actually want

Specify whether the target is before or after management, maintenance and replacement savings. A $300 monthly target after all three is different from $300 before a roof reserve. Also identify whether you mean cash after financing or net operating income before financing.

Here, the target is $300 a month after operating allowances, principal and interest, and a recurring capital-replacement allowance. It is before personal income taxes and does not include appreciation or principal paydown as spendable cash. Principal paydown can improve equity while leaving the bank balance unchanged. Do not add it to the monthly distribution target.

The rental pro forma guide organizes the broader forecast. This worksheet isolates one question: how much price can that forecast support? Keep an independent repair budget and cash reserve stress test beside it, because an annual forecast does not reveal when a large bill comes due.

Choose the target before looking at the seller's price. Otherwise it is easy to keep lowering the target until the listing appears acceptable. Write down why the target matters: perhaps it compensates for management time, funds a portfolio reserve, or contributes toward a household savings goal. It should be a deliberate constraint rather than a leftover number.

Sort costs by what drives them

Some costs move with rent, others with purchase price, and others follow a quoted dollar amount. Putting them in the wrong group can make an algebraically correct formula produce an unusable offer.

InputHypothetical assumptionDriver
Scheduled monthly rent$2,400Comparable units
Vacancy and collection loss5% of scheduled rentRent
Management8% of collected rent after the loss allowanceCollections
Routine repairs5% of scheduled rentRent for this example
Capital-replacement savings5% of scheduled rentRent for this example
Insurance$120 monthlyQuote
HOA$40 monthlyAssociation schedule
Property tax1.2% of purchase price annuallyPrice for this example
Down payment25%Price
Mortgage7%, 30-year fixedLoan amount
Desired monthly cash flow$300Owner's target

Every figure is illustrative. The tax assumption is especially important: many jurisdictions do not tax a property at a fixed percentage of the new purchase price. Assessment practices, exemptions, special assessments and timing can differ. Read the property-tax reassessment guide and replace the simplified formula with the assessor's applicable method.

Management in this example is charged on expected collections. The 8% is applied after the 5% loss allowance. A contract charging on scheduled rent, imposing a minimum, or adding renewal and leasing fees needs different arithmetic. Include those terms before comparing two properties or two managers.

Find the money available for financing and taxes

Start with $2,400 rent and subtract $120 of vacancy and collection loss. Expected collections are $2,280. Management at 8% of those collections is $182.40. Repairs and replacement savings are $120 each. Insurance and HOA add $160.

Monthly bridgeAmount
Scheduled rent$2,400.00
Vacancy and collection loss-$120.00
Management-$182.40
Routine repairs-$120.00
Replacement savings-$120.00
Insurance and HOA-$160.00
Desired cash flow-$300.00
Available for principal, interest and tax$1,397.60

That final line is not the allowable mortgage payment alone. We have deliberately left property tax out because the example tax changes with price. Subtracting a guessed tax bill first and then forgetting to revise it at the solved price would make the model inconsistent.

Do not use gross rent as the debt-service budget. The difference between $2,400 and $1,397.60 is what allows the property to absorb the modeled expenses and still meet the target. The vacancy assumptions article and CapEx guide help replace percentage placeholders with property evidence.

Solve the maximum price

For a fully amortizing loan, the monthly payment per dollar borrowed depends on rate and term. At the example 7% over 360 monthly payments, that factor is approximately 0.00665302. A $100,000 loan therefore requires about $665.30 of monthly principal and interest.

With 25% down, the loan is 75% of the purchase price. Monthly principal and interest is purchase price multiplied by 0.75 and then by 0.00665302. Monthly tax in this example is purchase price multiplied by 0.012 and divided by 12, or 0.001 times price.

Add the two price-linked factors: 0.75 multiplied by 0.00665302, plus 0.001, equals approximately 0.00598977. Divide the available $1,397.60 by that factor. The supported price is approximately $233,331.

At that price, the mortgage payment is about $1,164.27 and tax is $233.33 monthly. Those add to $1,397.60, leaving the specified $300 after the other items. Calculations use unrounded factors; small differences can appear if each intermediate amount is rounded early.

For a spreadsheet, the payment factor is the monthly interest rate divided by one minus the reciprocal of one plus that monthly rate raised to the number of payments. A zero-interest loan uses one divided by the number of payments instead. The price formula assumes the loan percentage, rate and term do not change as price changes.

See which assumptions change the offer most

Change one input at a time first. That shows the effect of each uncertainty without confusing a lower rent case with a higher tax case. Then combine plausible adverse changes in a separate downside scenario.

Change from the base caseSupported price, rounded
Base case: 7% mortgage, $2,400 rent, $300 target$233,331
Mortgage at 6.5%$243,463
Mortgage at 7.5%$223,827
Rent is $2,200$207,487
Annual tax is 1.8% of price$215,354
Desired cash flow is $500$199,941

The roughly $25,844 difference between the $2,400 and $2,200 rent cases is a reason to verify comps, not a reason to choose the higher rent. Use the rent-estimate tool as a starting point, then inspect comparable leases, concessions, condition and bedroom count. A citywide average cannot establish the rent for a specific unit.

For financing, the CFPB Loan Estimate explainer identifies the loan terms, projected payments and closing-cost sections to review. Where that form applies, compare actual quotes with consistent assumptions. Some business-purpose investment loans use different disclosures; ask the lender for a complete written fee and payment schedule.

These rates are sensitivity inputs, not current quotes. Buying points to reach the lower-rate row consumes cash at closing. Compare that additional cost and the expected holding period using the mortgage-points worksheet. A lower payment does not automatically mean the cheaper financing package.

Add a separate cash-to-close constraint

Suppose you have $80,000 available for the transaction and this property's reserves. You budget 25% down, closing costs equal to 3% of price, $12,000 of immediate work and $12,000 of untouched opening reserves. This is a simplified cash budget; use itemized lender, title, tax and insurance amounts for an actual purchase.

The acquisition equation is 28% of price plus $24,000. At the cash-flow-supported price of $233,331, total required cash is about $89,333. The monthly result works, but the proposed transaction exceeds the available cash by about $9,333.

Solve the cash equation separately: subtract $24,000 from $80,000 and divide the remaining $56,000 by 28%. The cash-limited price is $200,000. Under unchanged base-case assumptions, that price produces about $499.65 monthly cash flow. The cash limit is binding before the $300 return target is.

Do not close the gap by quietly deleting opening reserves. That changes the risk being accepted. A seller credit may cover certain eligible closing costs, subject to the loan and transaction rules, but it is not automatically cash for a future roof or post-closing bank balance. Document exactly which bill the credit pays.

Earnest money also needs careful handling. It is usually part of the buyer's funds already paid toward closing, rather than a second expense on top of the total purchase budget. Reconcile it against the settlement statement instead of counting it twice.

Use the listing price as a comparison, not an input you must justify

At a hypothetical $250,000 asking price, the base model produces about $200.16 monthly cash flow, below the $300 target. That does not prove the listing is overpriced for every buyer. It means it does not meet this buyer's target under this financing and expense set.

Someone paying cash or using different financing may reach a different limit. Someone willing to accept less cash flow may also bid more. Those are different investment cases, not corrections to your arithmetic. Keep them separate from the assumptions you can actually obtain.

If a repair concession is negotiated, determine whether it reduces price, pays a closing bill or leaves you responsible for the full repair after closing. Each treatment changes a different part of the worksheet. A $10,000 reduction in price does not put $10,000 back in cash when most of that price would have been financed.

For a major rehab, construction draws, delayed occupancy, interest-only payments or a balloon, replace this stabilized fixed-loan model with a dated cash-flow schedule. The simple formula is useful because its boundaries are explicit. Extending it to a different financing structure without changing the equation creates false precision.

Verify the candidate in the calculator

Enter the supported price, actual down payment, quoted rate and term in the single-family calculator. Match the rent and cost bases used here. If a field applies management or reserves to a different base, translate the dollar allowance rather than expecting identical output from differently defined percentages.

Check three outputs separately: monthly cash after the chosen allowances, cash needed to acquire the property, and cash remaining after closing. Then rerun the rent-down and expense-up cases. Save the base analysis to your account so changes to a quote or lease can be compared against the original decision.

Round your negotiating limit conservatively and leave room for uncertain costs. A result of $233,331 is not evidence that paying $233,332 makes the property a bad investment. It is a useful explanation of which assumptions support the price, which limits are binding, and which facts you still need before writing an offer.

Share:

Get new articles and market updates

Investing guides and market data, straight to your inbox. Unsubscribe anytime.

Related Articles

Ready to analyze your next deal?

Our calculators help you make data-driven investment decisions in minutes.

Explore Tools