Model property, mortgages, other debt, and rent

Housing affects value, cash flow, and liquidity in different ways

A home or rental property can be a place to live, a source of rent, a large part of net worth, collateral for debt, and a possible future source of sale proceeds. Those roles must remain distinct. A house can make estimated net worth look strong while supplying no cash for retirement spending if the plan assumes it will be kept.

Property value, operating costs, rental income, mortgages, other liens, purchases, and sales are recorded separately so the projection can show how each affects the household. Debt attached to a property is still an obligation; it should not be hidden by entering only net equity.

Model the housing decision that actually changes the plan

Add property when its current value, recurring cost, rent, debt, future purchase, or future sale matters to retirement. If the household intends to remain in the home indefinitely, include it for a realistic net-worth view but do not treat its equity as spendable retirement funding.

Use a named What-if for downsizing, moving, renting, purchasing a second property, or selling a rental. Those decisions usually change several inputs at once: sale proceeds, debt payoff, transaction costs, new housing spending, property tax, rent, and possibly state tax or income.

Routine credit-card purchases paid in full belong in annual spending. Create a debt record only when a balance and payment obligation carry across planning periods.

Keep the property, its costs, and its loans separate

Record the property’s owner or household share, current value, valuation date, appreciation assumption, and recurring costs. Enter dependable rental income separately with realistic vacancy and expense assumptions already reflected in the amount if the screen does not model them independently.

Create each mortgage, home-equity loan, or other carried obligation under Debt & Loans and link secured debt to the correct property. Use the lender’s balance, interest rate, payment, and term rather than estimating equity and working backward.

For a future sale, enter the intended year and realistic net economics. The projection pays linked debt before making net proceeds available. Make sure a new home purchase or rent begins at the intended time so the scenario does not accidentally provide free housing or double-count costs.

Trace a move or sale through the affected years

In Projection, review property value, rental income, housing spending, debt service, loan balance, sale proceeds, and the account receiving any remaining cash. Inspect the year before the transaction, the transaction year, and the first full year afterward.

Compare the modeled payoff with a lender estimate and the sale proceeds with a realistic transaction estimate. If net worth rises but retirement funding does not, check whether the property remains unsold. If a sale appears to fund spending too early, verify the transaction year and annual timing.

For rent-versus-own or downsizing comparisons, keep unrelated income, spending, and market assumptions identical. The useful result is the consequence of the housing choice, not a better outcome caused by an accidental difference elsewhere.

A long-range property estimate is not a transaction statement

The annual model can differ from monthly lender amortization and does not establish market value, borrowing eligibility, sale timing, legal ownership, detailed rental taxation, property-tax rules, insurance availability, capital-gain exclusions, or exact transaction costs.

Use current lender, title, appraisal, tax, insurance, and transaction information before acting. When the value or timing is uncertain, compare conservative proceeds and adjacent years rather than trusting one precise forecast.