Free Rental Properties DCF Analyzer (2026)

Most investors use discount rates between 8-12% for residential rentals. Use lower rates (8-9%) for stable properties in prime locations with strong tenant history, and higher rates (10-12%) for properties requiring renovation or in emerging markets. The discount rate should reflect your required return plus risk premium over treasury bonds.

Calculate terminal value by dividing the final year's net operating income (NOI) by an exit cap rate, then discount it to present value. Use an exit cap rate 0.5-1% higher than current market cap rates to account for property aging. For a $50,000 NOI and 6% exit cap, terminal value would be $833,333.

No, DCF analysis values the property itself (unlevered cash flows), not your financed position. Use NOI minus CapEx as your annual cash flow. To analyze your actual returns with financing, run a separate levered analysis comparing your equity investment against after-debt cash flows and equity buildup.

Project 10-15 years for most rental analyses, which balances accuracy with realistic forecasting limits. Shorter holds (5-7 years) work for value-add plays you plan to reposition and sell. Longer projections (20-30 years) are appropriate for core institutional-grade properties with stable fundamentals and low volatility.

Positive NPV means the investment is worth more than the purchase price at your required return rate. Look for NPV of at least 10-15% of purchase price to provide margin of safety. For a $500,000 property, target NPV of $50,000-75,000+ to ensure the deal compensates adequately for time, risk, and opportunity cost.

Include renovation costs as negative cash flows in the year they occur, then increase rental income in subsequent years to reflect market rate for upgraded units. For example, a $30,000 renovation in year 2 might boost monthly rent from $1,800 to $2,200, generating higher NOI that justifies the CapEx investment over time.