Covering the mortgage is only part of break-even
A rent that pays the mortgage can still leave you subsidizing the property. Property taxes, insurance, HOA dues, owner-paid bills, repairs and empty periods all compete for the same rent. A reserve for later replacements reduces what is available to spend even before a major repair happens.
Here, break-even means that expected rent covers those costs, the full mortgage payment, the reserve and estimated income tax. The monthly surplus target starts at zero. Raise it if you want income beyond covering the property. That target is a cash amount, not a cap rate or a promised return on your equity.
Your rental scenario
The underlined amounts are an editable starting example. This is a complete year for a residential rental already placed in service before the year starts, with no personal use. It assumes deductible ordinary operating expenses, a single fixed-rate repayment loan and the standard 27.5-year building recovery period. The financing starts at the entered loan balance and amortization term; closing-day costs are separate.
What the entered rent produces before financing
Rent collected and operating costs
At 8% vacancy, the expected rent collected is $24,288.00 a year. After management and $7,200.00 of other operating costs, the property produces $15,144.96 before the loan, income tax and reserve.
Separate loan interest from principal
The next twelve mortgage payments
The twelve payments total $17,065.84: $14,550.95 of interest and $2,514.88 of principal. The payment figure excludes tax and insurance escrow; those expenses are counted separately in the operating sheet.
Taxable profit is different from cash left over
Estimated rental income tax
The rental's taxable result is -$8,133.27 after actual mortgage interest and $8,727.27 of building depreciation. The estimated additional income tax is $0.00. The tax loss is shown, but no refund or offset against other income is assumed.
Cash available at the entered rent
After payments, reserve and estimated tax
At the entered rent, -$260.07 a month remains on average after operating costs, full loan payments, the reserve and estimated income tax. Your selected monthly surplus is $0.00.
The entered $2,200.00 rent is $307.27 below the required rent. Its average monthly cash result is -$260.07, which is $260.07 below your $0.00 target.
A replacement reserve is not a repair expense
The reserve is money set aside for future work. It reduces your spendable cash here, but saving money is not itself a current tax deduction. Enter paid, deductible repairs separately. Replacing or substantially improving an asset can require capitalization and depreciation instead of an immediate deduction.
Check the property tax bill, insurance quote and HOA budget for the actual property. Ordinary deductible HOA expenses belong in the annual HOA field; a capital special assessment needs separate treatment. Include only owner-paid utilities and other ongoing bills in the other-costs field. If mortgage escrow collects tax and insurance, do not count that escrow payment again: this model already includes the underlying expenses.
Depreciation can reduce tax without paying the loan
Land is not depreciable. For residential rental buildings under the general system used here, the standard recovery period is 27.5 years. The model uses the original depreciable building basis divided by that period and caps the deduction at the amount still unrecovered. These tax inputs are separate from the price you test.
This full-year estimate excludes the placed-in-service and disposal-year mid-month adjustments, alternative depreciation systems and separate assets with other recovery periods. It also excludes bonus depreciation, cost segregation and sale-time depreciation recapture. Use your existing depreciation schedule to check the basis and remaining amount.
Tax savings are not guaranteed cash receipts
The estimated tax is positive rental profit multiplied by your combined income-tax planning rate. That rate is an assumption: actual federal and state rules interact, and your marginal rate can change as income rises. This is not a calculation of your household tax return. QBI deductions, local income tax, NIIT and any tax on a sale are omitted.
A negative tax result is not treated as a refund. Rental losses can be limited by passive activity and at-risk rules, with exceptions depending on your circumstances. Any benefit from offsetting other income or using prior losses needs separate verification. That is why the cash answer does not rely on a refund arriving to pay the mortgage.
Test the required rent against the local market
The required figure is the advertised rent before expected vacancy and management fees. It is rounded upward to the cent to cover the chosen target under the model. If no rent is retained after those allowances, the result explains what must change. A requirement above the model's rent range also explains which assumptions need changing.
Compare the answer with genuinely comparable leases, not the asking rent that makes the spreadsheet attractive. If comparable properties cannot command that rent, revisit purchase price, financing, operating costs or your surplus target. The calculation does not establish a lawful rent increase or predict tenant demand.
A zero surplus target covers the entered costs but does not compensate you for your time, equity or risk. A positive monthly average also needs a cash buffer: annual bills, vacancies and repairs do not arrive evenly. Unexpected work, letting fees and bad debts can leave a particular year below the plan.
Methodology
Annual rent is reduced by vacancy and management, then by operating costs. The model calculates interest and principal for twelve monthly loan payments, caps full-year building depreciation, and estimates tax on positive rental profit. It solves for the rent that leaves the selected surplus after full loan payments, reserve and tax; tax losses create no assumed refund.