How to Run a DCF Analysis for Real Estate — Complete Guide (2026)
Last updated: March 2026
What is Discounted Cash Flow (DCF) Analysis?
Discounted Cash Flow (DCF) analysis is a valuation method that estimates the present value of an investment by forecasting future cash flows and discounting them back to today using a required rate of return. In real estate, DCF models project rental income, operating expenses, capital expenditures, and terminal value over a holding period to determine what a property is truly worth to an investor. Unlike cap rate analysis (which uses a single year snapshot), DCF captures the time value of money and allows for year-by-year changes in income, expenses, and market conditions. The result is a Net Present Value (NPV) that can be compared directly to the asking price—if NPV exceeds purchase price, the investment offers positive value at your required return rate. DCF is the gold standard for institutional real estate investors and sophisticated private investors who want rigorous, data-driven valuation.
Step-by-Step Guide
Project Annual Cash Flows
Build a year-by-year forecast of net operating income (NOI) for your entire holding period. Start with current or stabilized gross rental income, subtract vacancy losses (typically 5-12% depending on property type), and subtract operating expenses (property management, maintenance, insurance, taxes, utilities). Add assumptions for annual rent growth (2-4% typical) and expense inflation (3-5% typical). For commercial properties, model each lease separately with specific expiration dates, renewal assumptions, and rent steps. Include one-time capital expenditures like roof replacements, HVAC upgrades, or major renovations in the years they occur. The result should be 10-15 years of projected annual NOI (or however long you plan to hold the property) that reflects realistic income and expense trends.
Determine Your Discount Rate
Select a discount rate that reflects your required rate of return plus a risk premium appropriate for the property. Start with a risk-free rate (10-year treasury yield, currently ~4%), then add premiums for real estate market risk (3-5%), property-specific risk (1-3%), and illiquidity (1-2%). Typical discount rates are 8-12% for residential rentals, 6-12% for commercial properties (lower for core, higher for value-add/opportunistic), and 15-25% for fix-and-flip projects. Your discount rate should be higher than your expected cap rate—if you require 10% returns, use a 10% discount rate even if the property trades at a 6% cap rate. Conservative investors use higher discount rates to build in margin of safety.
Calculate Terminal Value
Estimate what the property will be worth when you sell it at the end of your holding period. The most common method is the exit cap rate approach: take your final year NOI and divide by a market cap rate to get terminal value. Use an exit cap rate 0.5-1% higher than current market cap rates to account for property aging and market risk. For example, if year 10 NOI is $100,000 and you use a 7% exit cap, terminal value is $1,428,571. Alternatively, you can assume the property appreciates at a fixed rate (e.g., 2-3% annually) from today's value. The terminal value is usually the largest component of total value in a DCF model, so test sensitivity by running scenarios with different exit cap rates (±0.5-1%) to see how it affects NPV.
Discount All Cash Flows to Present Value
Convert each year's cash flow and the terminal value into present value using your discount rate. The formula is: PV = FV / (1 + r)^n, where FV is future value, r is discount rate, and n is the number of years. For example, $50,000 in year 5 at a 10% discount rate has a present value of $50,000 / (1.10)^5 = $31,046. Do this calculation for every year's NOI and for the terminal value. Sum up all the present values to get the total property value. Most spreadsheet tools automate this using NPV or XNPV functions—just input your cash flows and discount rate. Remember that terminal value needs to be discounted just like annual cash flows since it occurs in the future.
Calculate NPV and Compare to Purchase Price
Subtract your total upfront investment (purchase price plus acquisition costs like closing fees, inspections, immediate repairs) from the sum of discounted cash flows to calculate Net Present Value (NPV). Positive NPV means the property is worth more than you're paying at your required return rate. For example, if discounted cash flows sum to $1.2M and you're buying for $1M all-in, your NPV is $200,000—representing built-in value and margin of safety. Higher NPV is better, but also consider NPV as a percentage of purchase price (20% NPV on the $1M example). Most investors target minimum 10-15% NPV/price ratio to ensure adequate risk-adjusted returns. If NPV is negative, the property doesn't meet your return requirements at the asking price—walk away or negotiate lower.
Run Sensitivity Analysis and Scenarios
Test how NPV changes when you vary key assumptions like discount rate, rent growth, vacancy rate, exit cap rate, and major expense assumptions. Create a sensitivity table showing NPV across a range of inputs—for example, what if vacancy runs 10% instead of 5%, or rent growth is only 1% instead of 3%? This reveals which variables have the biggest impact on your returns and helps you understand downside risk. Also run best-case, base-case, and worst-case scenarios with different assumption combinations. If NPV is still positive in the worst-case scenario, you have a robust deal. If NPV goes negative with small assumption changes, the deal is too risky. Use sensitivity analysis to guide your negotiation strategy and identify deal-breakers worth walking away from.
Best Practices
Use conservative assumptions for all income and expense projections—it's better to underestimate returns than overpromise and underdeliver
Build your DCF model in a spreadsheet with clearly labeled inputs so you can easily adjust assumptions and run scenarios
Separate one-time capital expenditures from ongoing operating expenses to accurately model cash flow timing
Include all transaction costs in year 0 (acquisition) and final year (disposition)—don't forget closing costs, commissions, and legal fees
Model vacancy and rent loss realistically based on local market data rather than using national averages that may not apply
Use actual lease terms and expiration schedules for commercial properties instead of simplified stabilized NOI assumptions
Cross-check your DCF results against comparable sales and cap rate analysis—if DCF value is wildly different, revisit your assumptions
Document all assumptions and data sources so you can justify your analysis to partners, lenders, or investors
Common Mistakes to Avoid
Using discount rates that are too low (6-7%) for risky properties, which inflates NPV and makes bad deals look good
Forgetting to include capital expenditures like roof, HVAC, and major systems in cash flow projections
Assuming 0% vacancy and 100% rent collection—even excellent properties experience some vacancy and tenant issues
Modeling unrealistic rent growth (5-8% annually) that exceeds historical market trends and inflation
Ignoring expense inflation entirely or using the same growth rate for rent and expenses (expenses typically grow faster)
Calculating terminal value using year 1 NOI instead of the final year's projected NOI, which drastically understates exit value
Try DCF Analyzer Free
DCF Analyzer
Discounted Cash Flow analysis for investment property valuation
Frequently Asked Questions
Cap rate valuation divides a single year's NOI by a cap rate to get property value (Value = NOI / Cap Rate). It's a snapshot approach that assumes income stays constant. DCF analysis projects multiple years of changing cash flows and discounts them to present value, accounting for time value of money, rent growth, expense increases, and market changes. DCF is more sophisticated and accurate, especially for properties with changing income profiles or long holding periods, while cap rate is simpler and good for quick comparisons.
Use 10-15 years for most buy-and-hold rental and commercial properties, which balances forecasting accuracy with capturing long-term value. Shorter holds (3-7 years) work for value-add projects where you plan to renovate and sell, or fix-and-flip deals (measured in months). Longer holds (15-30 years) suit core institutional assets acquired for stable income. Your holding period should match your actual investment strategy—don't use 20 years if you realistically plan to sell in 7-10 years.
Use unlevered (before-debt) cash flows for property valuation—this values the asset itself regardless of how you finance it. Unlevered DCF uses NOI minus CapEx as cash flows and discounts at your required property return rate. To analyze your actual returns with a mortgage, run a separate levered analysis using after-debt cash flows (NOI minus debt service) and compare equity invested to equity cash flows plus appreciation. Most institutional investors use unlevered DCF for acquisition decisions, then layer in financing separately.
Target NPV of at least 10-15% of purchase price to provide margin of safety and justify the investment over alternative opportunities. Higher NPV (20-30%+) is better and indicates a strong deal with built-in value. Compare NPV to your equity investment as well—if you're putting $200K down on a $1M property with $150K NPV, that's a 75% NPV/equity ratio which is excellent. Negative NPV means the property doesn't meet your return requirements at the asking price and should be avoided or renegotiated.
DCF captures appreciation through the terminal value calculation—the estimated sale price at the end of your holding period. If you project rent growth of 3% annually and use the same exit cap rate as today, your terminal value will be higher than current value due to NOI growth (which is income-driven appreciation). You can also model market appreciation by using a lower exit cap rate than today (higher values) or assume explicit appreciation rates. However, most conservative DCF models focus on income growth rather than speculating on cap rate compression.
Standard DCF models use pre-tax cash flows to value the property itself. To analyze your after-tax returns, build a separate tax analysis that models depreciation deductions, mortgage interest deductions, and capital gains tax on sale. After-tax NPV will be higher than pre-tax NPV due to tax shields, but it's specific to your tax situation. Use pre-tax DCF for property valuation and comparing deals, then layer in tax analysis for personal return projections once you identify a target property.
Re-run your DCF analysis annually to compare actual performance against projections and decide whether to hold or sell. Update rent assumptions based on current market data, adjust expense forecasts for actual costs, and refresh your discount rate and exit cap rate assumptions. If actual NOI is tracking 10-20% below projections, you may need to revise your hold strategy or exit earlier than planned. Annual DCF updates help you make data-driven decisions about renovations, refinancing, or disposition timing.
Yes, but development DCF requires more complex modeling. Include construction costs as negative cash flows during the build period (months or years with no income), model lease-up or absorption with gradual NOI growth to stabilized occupancy, then run standard DCF from stabilization forward. Use higher discount rates (12-20%+) for development to reflect construction, market, and lease-up risk. Also build in contingency budgets (15-25% of hard costs) and timeline buffers since developments almost always run over budget and schedule.
Discount rate should always be higher than cap rate. Cap rate is the current income return (NOI / Value) while discount rate is your total required return including future growth. Typical spread is 2-4%—for example, a 6% cap rate property might use a 9-10% discount rate. If you use a discount rate equal to or lower than cap rate, you're implicitly assuming zero or negative growth. The spread between discount rate and cap rate should roughly equal your expected annual NOI growth rate plus some risk premium.
Compare your assumptions against actual market data: rent growth vs local MLS/CoStar trends (past 5-10 years), cap rates vs recent comparable sales, discount rates vs REIT returns and private equity benchmarks. Validate expense assumptions against actual operating statements from similar properties. Cross-check your DCF output against what comparable properties sold for—if your DCF value is 30% higher than recent comps, your assumptions are probably too optimistic. Always stress-test by running worst-case scenarios with below-market growth and above-market expenses to see if the deal still works.
DCF Analyzer Use Cases
Related Tools
Start Using DCF Analyzer for Free
Join thousands of real estate agents using EstatePass. 60+ free tools — no credit card, no trial, no catch.