How to Underwrite a Rental Property Before Making an Offer

I would underwrite the property before negotiating the loan. Financing can change the result, but it should not hide an unsupported rent estimate or a business that needs more cash than the buyer has.

A useful acquisition model answers four questions. What can the property reasonably collect? What will it cost to operate? What cash must the investor commit? What happens if the first plan disappoints?

The output should be a decision, not a spreadsheet full of optimistic cells. That decision may be buy, change the offer, obtain a missing document or pass.

Create an evidence column before a return column

Start with the specific address, legal property type, permitted rental use, association documents and physical condition. An attractive nightly projection has little value if the intended use is prohibited or the required operating setup is missing.

Beside every material input, identify the source and what remains assumed. Signed leases, completed property level receipts and relevant rental comparables carry different information. Seller estimates, a manager's forecast and a third party projection should remain labeled as forecasts.

For operating costs, obtain a buyer tax estimate, insurance quote and association schedule. Add property specific items such as pool care, pest control, internet, lawn service and utilities the owner will pay. A listing's expense total often reflects another owner's use and ownership period.

I would mark an unresolved material item as a condition of the offer analysis. Do not replace missing insurance or association information with zero just to obtain a complete looking return.

Build the operating year without mixing debt into expenses

Here is a hypothetical long term rental purchase at $400,000. Supported scheduled rent is assumed to be $3,600 monthly. A 5% allowance for vacancy and collection loss reduces annual scheduled rent of $43,200 to $41,040.

Assume management is 8% of collected rent, or $3,283.20 annually. Other operating costs are $6,000 property tax, $3,000 insurance, $1,200 association dues, $2,100 routine repairs, $1,000 turnover allowance and $600 of owner paid utilities. Those other costs total $13,900.

The property therefore leaves $23,856.80 after these operating costs and before mortgage payments and the separately stated replacement reserve.

Reserve conventions differ across statements. If using a net operating income figure or cap rate, identify whether the replacement reserve is already deducted. The OCC's commercial underwriting convention includes a replacement reserve. Do not compare a reserve adjusted figure with a seller's unadjusted cap rate as if they were the same calculation.

Put financing and committed cash into the model

Assume a $300,000 mortgage at an illustrative 7.50%, amortizing over 30 years. Monthly principal and interest are approximately $2,097.64, or $25,171.72 annually. This is a hypothetical financing assumption, not an available quote.

Taxes, insurance and association dues were already counted as operating costs. Do not subtract the full escrowed mortgage payment again. The debt line here is principal and interest only.

The cash needed is also more than the $100,000 down payment. Assume $12,000 acquisition costs, $8,000 initial repairs and $20,000 of committed operating reserves. Total cash allocated is $140,000. The negative $3,714.92 annual result is approximately negative 2.7% of that amount under this stated cash on cash convention.

Committed reserves are not immediately spent, but they are cash this plan requires to remain available. Show them separately if comparing with an investment using a different denominator. Do not improve the displayed return by quietly removing necessary capital.

Solve the input that would make it work

If the investor raises assumed rent to $3,900, the model still loses approximately $569 after the same reserve, using the same vacancy and management percentages. A slightly higher forecast does not fully repair this purchase.

With all other inputs fixed, annual collected rent after management is monthly scheduled rent multiplied by 12, then by 95%, then by 92%. That factor is 10.488.

The fixed annual demands are $13,900 plus $25,171.72 debt service plus $2,400 replacement reserve, or $41,471.72. Dividing by 10.488 produces a break even scheduled rent of approximately $3,954 monthly.

That is a required rent under the assumptions, not evidence the property can achieve it. I would compare it with supported market rent. If the market supports $3,600, the offer or financing must change, or the investor must consciously accept the subsidy.

For a short term rental, use booked nights, achievable rates, fees and variable costs instead of importing this lease rent formula. The break even occupancy guide solves that different model.

Stress the business and the cash timing

Change the assumptions that could realistically fail: lower collected rent, a repair, higher insurance or an extended opening period. A yearly result can also hide months when cash is needed before the rent arrives.

Do not deduct vacancy twice. If the revenue input is actual completed receipts after unbooked nights, a second general vacancy reduction should be a separately identified stress, not an unnoticed duplicate.

Compare a paid management case even if the buyer plans to self manage. Then identify what labor the owner is choosing to provide. A plan that only works with free labor should say so.

For an STR purchase, calculate the furnishing, compliance and launch capital before relying on the loan's remaining reserve figure. The guide on cash to buy and launch separates closing cash from the money needed afterward.

Underwrite an exit without appreciation doing all the work

Assume this same $300,000 loan remains outstanding for five years with scheduled payments and no extra principal. The balance would be about $283,852. If sale price remains $400,000 and hypothetical selling costs are 7%, sale proceeds before loan payoff are $372,000. After principal payoff, about $88,148 remains before other closing adjustments or taxes on the sale.

Unspent operating reserves are a separate asset. Annual cash losses, actual repairs, any prepayment charge and tax consequences still need to enter a complete holding period return. The $88,148 is a sale cash figure, not the investor's total profit.

I would also test a lower sale price and a longer hold. If a refinance is the preferred exit, test a smaller supported loan and no refinance as well. Future approval is not an acquisition fact.

The final offer analysis should name the supported rent, complete costs, cash committed, unresolved evidence and the result under a less favorable case. That lets the investor negotiate around the actual constraint and recognize when the property no longer deserves the capital.