Real Estate Valuation: Part 3 (Discounted Cash Flows)

This approach is called Discounted After-Tax Cash Flow Approach. This method is used as a supplement to the other valuation methods, such as cost, sales, and income approach.

Under this approach, the investor calculates the net present value of after-tax cash flows from the property discounted by his required rate of return. For the investment to be worthwhile, the NPV of cash flows should be positive. Alternatively, the IRR should be higher than the investor’s desired rate of return.

Numerical Example

An investor is considering purchase of a property now and selling it after a period of 5 years. The details of the property and its financing are provided below.

Property Purchase Details

Property Purchase Price1000000
Equity25%250000
Required Cost of Equity12%
Debt75%750000
Debt rate (p.a.)8%
Interest is Tax-deductibleYes
Straight Line Depreciation5%50000
Mortgage Payment66621
Marginal tax rate31%
Year 1 NOI100000
NOI Growth Rate10%

The property sale details are provided below:

Property Sale Details

Property sold after (Years)5
Capital gains tax rate20%
Sale Price (Forecasted)1200000
Property Sale Expenses as a % of sale Price5%

Result

Using the Discounted After-tax Cash Flow approach, the NPV of this project is positive ($78,098). Therefore, the investor should invest in this project.

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 $29 (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.