Discounted Cashflow in Real Estate Valuations

 
 
 
 

Importance of Discounted Cashflow (DCF)

Whenever I interview candidates for a financial analyst position at Top Shelf Models, the most important factor in determining if they get the job is their understanding of DCF valuations. DCF is a valuation method to determine the present value (PV) of an asset based on the projected future value (FV) of the cashflows. The FV cashflows are discounted back to the PV using a discount rate (r). It is imperative that financial analysts understand the relationship between PV, FV and R.

DCF is calculated as follows:

PV = FV / (1 + r)^t

  • PV = Present Value

  • FV = Future Value

  • r = discount rate

  • t = time periods

Using Discounted Cashflow (DCF) in Real Estate

Most Private Equity Real Estate (PERE) funds are required to value their investments at least annually or even more often if material changes have occurred. There are various ways to value a real estate asset, but DCF valuations are commonly used. The purpose of the DCF valuation is to determine the PV of the asset. This PV amount is then compared to the cost basis to determine the unrealized gain/loss of the investment.

Another use of the DCF valuation in real estate is to determine the price you are willing to pay for the acquisition of an investment. The valuation will project the revenues, expenses and capital expenditures throughout the anticipated hold period and then discount those future values to calculate the present value, or amount you are willing to pay today. These calculations can be complex so we recommend using our TSM Financial Models to calculate these projections.

What Discount Rate to Use?

To project the FV, you use the TSM Financial Model like we discussed above, but what discount rate should you use? The discount rate should factor in the investment’s cost of capital, potential risks, and the risk-free rate of interest. All of these factors work together to help you calculate the PV.

A reasonable place to start deciding on the discount rate is by using the rate equal to the return the investors expect from the investment. For example, Investment A is acquired in a Value-Add Fund and is estimated to achieve a 15% gross IRR. For simplicity, let’s assume the FV of that investment is $10,000,000 in one year. To determine the PV of that amount, a good estimate would be to use the 15% discount rate which would equate to a PV of $8,695,652. Said another way, if you acquired the Investment A for $8,695,652 and sold it one year later for $10,000,000 then you would have achieved a 15% gross IRR.

A common mistake is to use a discount rate that is too low. In the example above, if you use a lower discount rate of 10%, then you would have been willing to acquire Investment A for $9,090,909 or $395,257 more than if you had used the 15% discount rate.

As mentioned above, this allows you to get a starting point for finding the appropriate discount rate. You will also need to consider the geography, property type, class of building, tenant risk, political risk, building specific risk, etc. before deciding on the rate you should use.

Discounted Cash Flow Model (DCF) Summary

DCF Valuations are used everyday in private equity real estate. Funds value their investments each quarter using DCF models. Buyers use the present value calculation to determine the acquisition price of potential investments. In order to conduct a DCF analysis, you must make assumptions about future cash flows and model those projections in a financial real estate model.

You must also determine an appropriate discount rate for the DCF valuation model, which will vary depending on the investment attributes and return expectations.

 

 

About the Author

Eric Bergin is the founder of TSM. He realized that there was a need for real estate financial models that were more than just generic templates. He wanted to create a personalized product for his customers that would ensure success for them and their company. Please reach out to him if you have any questions regarding discounted cashflows or if he can help you with your modeling needs.