Back to Harbaugh Real Estate

Real Estate Investment Model

Use this model to estimate the total net gain or loss, total return, and annualized rate of return for a real estate investment property.

As of August 2, 2026

Summary

Primary investment outcomes

Projected results update as you change assumptions.

Net Gain/Loss

Projected net gain

$76,780

Total Return

Positive total return

13.63%

Annualized Return

Positive annualized return

1.29%

Starting assumptions are editable estimates for an investment property. Adjust any input to reflect your property and plan. Specialized property types may need additional metrics or analysis outside this model.

Inputs

Acquisition and value

Purchase price, closing costs, rehab, and after-repair value.

Inputs

Financing

Down payment percentage drives derived loan amount. All-cash purchases deactivate loan fields.

Down Payment Amount

$50,000

Initial Loan Amount

$200,000

All-in Acquisition Cost

$270,000

Inputs

Rental operations

Holding period, rehab timing, rent, vacancy, and rent growth.

Inputs

Expenses and CapEx

Combined operating expenses, CapEx allowance, and expense inflation.

Taxes, insurance, HOA, utilities, repairs, management, and similar costs.

Enter $0 if long-term replacements are already in operating expenses.

Source: FRED · CPIAUCNS (CPI, not seasonally adjusted, percent change from year ago) · Observation: June 2026

Inputs

Growth and sale

Appreciation and all-inclusive sale costs. Holding period is set with rental operations.

Appreciation compounds from Initial ARV over the holding period. Sale costs are applied to the projected sale price. Holding period and rent growth remain under Rental operations.

Supporting results

Income and capital components

Income Gain/Loss

−$14,413

Capital Gain/Loss

$91,193

Income Return

-2.56%

Capital Return

16.19%

Supporting results

Cash ledger

Gross receipts and Cumulative Cash Invested for the holding period.

Collected Rental Income

$263,750

Projected Sale Price

$376,297

Total Cash Received

$640,047

Cumulative Cash Invested

$563,267

Projected Sale Costs

$30,104

Net Sale Proceeds

$172,603

Supporting results

Holding-period operations

NOI after CapEx allowance differs from conventional NOI that excludes CapEx.

Conventional NOI before CapEx

$163,476

Total Projected CapEx Allowance

$21,487

Holding-Period Net Operating Income (after CapEx allowance)

$141,989

Total Projected Operating Expenses

$100,274

Total Projected Mortgage Interest

$141,401

Cumulative Principal Repaid

$26,410

Remaining Loan Payoff

$173,590

Holding-Period Mortgage Debt Service

$167,811

Projected Operating Cash Flow Before Taxes (after CapEx allowance)

−$25,823

Property Value Gain

$111,297

Notes

How to read this model

  • Results are gross of federal, state, and local income taxes, capital-gains taxes, and depreciation recapture. Property taxes are included through projected operating expenses.
  • Inflation projects future nominal expenses and CapEx. It does not discount or restate investment returns. Rent growth and property appreciation are separate assumptions.
  • Monthly CapEx Allowance is a smoothed economic projection and may not match literal monthly spending. Holding-period NOI subtracts both projected operating expenses and the CapEx allowance.
  • Mortgage interest is an expense. Mortgage principal and remaining payoff are financing cash flows, not expenses.
  • This model accounts for projected rental income and projected sale price as receipts. Mineral royalties and other potential income are not included.
  • Annualized Return is a compounded equivalent of Total Return, not IRR or XIRR, and may be unavailable in specified invalid domains.
  • The model is primarily intended for holding periods of five years or longer. Shorter periods remain calculable but carry more estimation risk. Specialized property types may require additional metrics or analysis. These projections are decision-support estimates, not guarantees.

“Reset all inputs to recommended defaults” restores the starting assumptions for the entire calculator. Annual Expense Inflation resets to the current FRED-derived value when available, or to the configured fallback when it is not.