Real Estate Deal Analysis: From Rent to Cash Flow

Build a traceable starting point

Collect the rent roll, leases, trailing operating statements, collections records, current tax information, insurance quotes, utility costs, and repair history. Label every input with its period and source. An annual expense should not be mixed with monthly income.

Separate current results from the seller's forecast and your own plan. If market rent is higher than contract rent, calculate when a lawful change could occur and what turnover or renovation it may require. Avoid replacing today's costs with lower projected costs without evidence.

Calculate in an order you can explain

First estimate effective income after vacancy, concessions, and uncollected amounts. Subtract recurring operating expenses to reach NOI. Then account for debt service, replacement reserves, and other cash spending to estimate cash remaining.

For a hypothetical property, $240,000 scheduled annual rent minus $18,000 of vacancy and collection losses plus $6,000 of other income equals $228,000 effective income. Subtract $100,000 in operating expenses for $128,000 NOI. With $80,000 annual debt service and $12,000 in reserves, modeled cash remaining is $36,000 before income taxes and additional spending.

The arithmetic is straightforward. The difficult work is checking that the income is collectible, the expenses are complete, and the reserve matches the building's needs. These numbers are an educational example only.

Use each metric for its own question

Metrics answer different questions. Cap rate describes income relative to property price or value before financing. Cash-on-cash return compares a period's cash flow with invested cash. DSCR assesses debt-payment coverage. Debt yield compares NOI with loan principal. LTV relates borrowing to collateral value.

Stress the assumptions and write the decision

Lower collections, increase taxes or insurance, add an unexpected repair, and model the payment after an interest-only period ends. For a planned sale, vary both the exit cap rate and the sale date. Change related assumptions together when one event would trigger several costs.

Finish with a short decision memo showing purchase uses, funding sources, expected operations, downside cash needs, unresolved documents, and the conditions that would change the decision. A lender's approval is one input; it is not a substitute for your own understanding.

Use calculators to check arithmetic and compare scenarios. Keep the source documents and definitions next to the outputs so another person can follow how the result was produced.

Common questions