Real Estate Valuation: NPV & IRR Analysis

NPV and IRR analysis can be applied to real estate valuation.

The standard decision rules apply, in that an NPV greater than zero or an IRR above the required rate of return indicates that the real estate investment should be undertaken.

IRR Challenges for Real Estate Valuation:

  • IRR cannot properly value real estate investments where cash flows begin positive and become negative for a period.

  • IRR may not properly rank mutually exclusive projects, when the size and timing of the cash flows are materially different.

After Tax Cash Flows (ATCF)

In order to perform a discounted cash flow valuation, analysts need to know a real estate investment’s after tax cash flows (ATCF) and after tax equity reversion (ATER).

ATCF = Net Operating Income – Mortgage Payment – Income Taxes

ATCF must be used in conjunction with a property’s After Tax Equity Reversion (ATER), which is realized upon sale of the property at the end of the investment time horizon.

ATER is conceptually similar to the terminal value in stock valuation.

After Tax Equity Reversion (ATER)

ATER: The non-operating cash flow generated by property sale at the end of the investment horizon.

ATER = Net Sales Price – Capital Gains Tax – Mortgage Balance.

ATCF and ATER are used to perform an NPV or IRR analysis and this can be done on a CFAI approved calculator (HP 12C or TI BA2+).

Data Science in Finance: 9-Book Bundle

Data Science in Finance Book Bundle

Master R and Python for financial data science with our comprehensive bundle of 9 ebooks.

What's Included:

  • Getting Started with R
  • R Programming for Data Science
  • Data Visualization with R
  • Financial Time Series Analysis with R
  • Quantitative Trading Strategies with R
  • Derivatives with R
  • Credit Risk Modelling With R
  • Python for Data Science
  • Machine Learning in Finance using Python

Each book includes PDFs, explanations, instructions, data files, and R code for all examples.

Get the Bundle for $39 (Regular $57)
JOIN 30,000 DATA PROFESSIONALS

Free Guides - Getting Started with R and Python

Enter your name and email address below and we will email you the guides for R programming and Python.

Data Science in Finance: 9-Book Bundle

Data Science in Finance Book Bundle

Master R and Python for financial data science with our comprehensive bundle of 9 ebooks.

What's Included:

  • Getting Started with R
  • R Programming for Data Science
  • Data Visualization with R
  • Financial Time Series Analysis with R
  • Quantitative Trading Strategies with R
  • Derivatives with R
  • Credit Risk Modelling With R
  • Python for Data Science
  • Machine Learning in Finance using Python

Each book comes with PDFs, detailed explanations, step-by-step instructions, data files, and complete downloadable R code for all examples.