Calculating the Value of a REIT Share

Calculating the Value of a REIT Share

An example is better suited here to help candidates understand the concept.

Example: Value of a REIT Share

Tysons Limited, a real estate asset management company, is keen on diversifying its portfolio through an office lease REIT investment.

The company needs to value the potential investment as of the end of 2015 based on the data below:

$$ {\begin{array}{l|c} \text{Estimated 12 months cash NOI} & $70,000,000 \\ \hline\text{FFO}&$60,000,000\\\hline\text{Cash and equivalents} & $55,000,000 \\ \hline \text{Accounts receivable}& $25,000,000 \\ \hline\text{Debt and other liabilities}& $300,000,000 \\ \hline\text{Non-cash rents}& $2,500,000 \\ \hline\text{Recurring maintenance-type capital expenditures}& $10,000,000 \\ \hline\text{Shares outstanding}& 10,000,000 \text{ shares} \\ \hline\text{Expected annual dividend 2016}&$5.00 \\\hline\text{Dividend growth rate in 2017 and 2018}& 2\text{%} \\ \hline\text{Dividend growth rate from 2019 to perpetuity}&1 \text{%} \\ \hline\text{Assumed cap rate }& 7\text{%} \\ \hline\text{Office subsector average price-to-FFO multiple}& 10\text{x} \\ \hline\text{Office subsector average price-to-AFFO multiple}&14\text{x} \\ \hline\text{Tysons Limited cost of equity capital}& 9\text{%} \\ \hline\text{Risk-free rate }& 2\text{%} \end{array}}$$

While using each of the approaches below, the amount of a REIT is closest to:

  1. Approach 1: Net asset value.
  2. Approach 2: Price-to-FFO.
  3. Approach 3: Price-to-AFFO.
  4. Approach 4: Discounted cash flow.

Solution

Approach 1: Net Asset Value

Step 1: Calculate the Estimated Value of Operating the Real Estate as Follows:

$$ \begin{align*} \text{Estimated Operating Value} & = \frac{\text{Estimated Cash NOI}}{\text{Assumed Cap Rate}} \\ \text{Estimated Operating Value} &= \frac{$70,000,000}{7\%}= $1,000,000,000 \end{align*} $$

Step 2: Calculate the Net Asset Value as Follows:

$$ {\begin{array}{l|r} \text{Estimated operating value} & $1,000,000,000 \\ \hline\text{Add: Cash and equivalents} & $55,000,000 \\ \hline \text{Add: Accounts receivable}& $25,000,000 \\ \hline\text{Less: Debt and other liabilities}&($300,000,000)\\ \hline\text{}& \bf $780,000,000  \end{array}}$$

Step 3: Calculate the NAV/Share as Follows:

$$ \begin{align*} \frac {\text{NAV}}{\text{share}} &= \frac{\text{NAV}}{\text{Shares outstanding}} \\ \frac {\text{NAV}}{\text{share}} & = \frac{$780,000,00}{10,000,000 \text{ shares}}= $78.00 \end{align*} $$

Approach 2: Price-to-FFO

Step 1: Calculate the FFO per share:

$$ \begin{align*} \frac {\text{FFO}}{\text{share}}&= \frac{\text{FFO}}{\text{Shares outstanding}} \\ \frac {\text{FFO}}{\text{share}} & = \frac{$60,000,000}{10,000,000}= $6.00 \end{align*} $$

Step 2: Apply the office subsector average P/FFO multiple of 10x yields:

$$ \text{REIT share value}= ($6 \times 10)= $60\text{REIT share value}=($6 \times 10)=$60 $$

Approach 3: Price-to-AFFO

Step 1: Calculate the AFFO value:

$$ {\begin{array}{l|r} \text{FFO} & $60,000,000 \\ \hline\text{Less: Non-cash rents) rent} & ($2,500,000) \\ \hline \text{Less: Recurring maintenance-type capital expenditures }& ($10,000,000) \\ \hline\text{}& \bf $47,500,000  \end{array}}$$

Step 2: Calculate AFFO per share:

$$ \begin{align*} \frac {\text{AFO}}{\text{share}} &= \frac{\text{AFO}}{\text{Shares Outstanding}} \\ \frac {\text{AFO}}{\text{share}} &= \frac{$47,500,000}{10,000,000 \text{ Shares}}= $4.75 \end{align*} $$

Step 3: Apply the office subsector average P/AFFO of 14x yields:

$$ \text{REIT share value}= ($4.75 \times 14)= $66.50 $$

Approach 4: Discounted Cash Flow

Step 1: Calculate the annual dividend per share (DPS):

$$ DPS=\text{Prior year DPS}+ \left(\frac{\text{Prior}-\text{year DPS}}{100\%} \times \text{Growth Rate} \right) $$

$$ {\begin{array}{l|c|c|c|c|c} \textbf{Year}&{\textbf{2015} }&{\textbf{2016} }&{\textbf{2017} }&{\textbf{2018}}&{\textbf{2019}} \\ \hline\text{Dividend Per Share (DPS)} & & $5 & $5.10 & $5.20 & $5.25 \\ \hline {\text{Terminal value at the} \\ \text{end of 2018*}} & & & & $65.63 & \\ \hline \text{Present Values} & $63.57 & 4.59 & 4.29 & 54.69 &\\ \end{array}}$$

Step 2: Determine the terminal value at the end of 2018:

$$\text{Terminal value}= \frac{$5.25}{(9\%-1\%)}= $65.63$$

Calculate the value of a REIT per share by discounting the dividends at a rate of 9% as follows:

$$ $4.59+$4.29+$54.69=$63.57$$

REIT value per share = $ 63.57

Note: The resulting amount of a REIT share is likely to vary, sometimes significantly, depending on which approaches are used.

Question

Consider the following selected REIT financial data concerning an investment in an industrial building at the end of 2013:

$$ {\begin{array}{l|c} \text{Estimated 12 months cash NOI} & $35,000,000 \\ \hline\text{FFO}&$30,000,000\\\hline\text{Cash and equivalents} & $20,000,000 \\ \hline \text{Accounts receivable}& $20,000,000 \\ \hline\text{Debt and other liabilities}& $220,000,000 \\ \hline\text{Non-cash rents}& $4,000,000 \\ \hline {\text{Recurring maintenance-type capital} \\ \text{expenditures}}& $8,000,000 \\ \hline\text{Shares outstanding}& 10,000,000 \text{ shares} \\ \hline\text{Expected annual dividend 2014}&$6.00 \\\hline\text{Dividend growth rate in 2015 and 2016}& 7\% \\ \hline {\text{Dividend growth rate from 2017 to} \\ \text{perpetuity}} & 5\% \\ \hline\text{Assumed cap rate }& 8\% \\ \hline {\text{Office subsector average price-to-FFO} \\ \text{multiple}} & {12x} \\ \hline {\text{Office subsector average price-to-AFFO} \\ \text{multiple}} & {20x} \\ \hline\text{Tysons Limited cost of equity capital}& {11\%} \\ \hline\text{Risk-free rate }& {2\%} \end{array}}$$

The value of the investor’s potential investment using a price-to-FFO approach is closest to:

  1. $25.75.
  2. $36.
  3. $30.

Solution

The correct answer is B.

This is computed as follows:

$$ \begin{align*} \frac {\text{FFO}}{\text{share}} &= \frac{\text{FFO}}{\text{Shares outstanding}} \\ \frac {\text{FFO}}{\text{share}} &= \frac{$30,000,000}{10,000,000 \text{ Shares}}= $3.00 \end{align*} $$

Applying the office subsector average price-to-FFO:

$$ \text{REIT share value}= ($3.00 \times 12)= $36 $$

A is incorrect. The amount reflects the REIT per share value using the NAV approach.

C is incorrect. The amount reflects the price-to-AFFO applying the office subsector, elaborated in the workings below.

Reading 37: Investments in Real Estate Through Publicly Traded Securities

LOS 37 (d) Calculate and interpret the value of a REIT share using the net asset value, relative value (price-to-FFO and price-to-AFFO), and discounted cash flow approaches.

Shop CFA® Exam Prep

Offered by AnalystPrep

Featured Shop FRM® Exam Prep Learn with Us

    Subscribe to our newsletter and keep up with the latest and greatest tips for success
    Shop Actuarial Exams Prep Shop Graduate Admission Exam Prep


    Daniel Glyn
    Daniel Glyn
    2021-03-24
    I have finished my FRM1 thanks to AnalystPrep. And now using AnalystPrep for my FRM2 preparation. Professor Forjan is brilliant. He gives such good explanations and analogies. And more than anything makes learning fun. A big thank you to Analystprep and Professor Forjan. 5 stars all the way!
    michael walshe
    michael walshe
    2021-03-18
    Professor James' videos are excellent for understanding the underlying theories behind financial engineering / financial analysis. The AnalystPrep videos were better than any of the others that I searched through on YouTube for providing a clear explanation of some concepts, such as Portfolio theory, CAPM, and Arbitrage Pricing theory. Watching these cleared up many of the unclarities I had in my head. Highly recommended.
    Nyka Smith
    Nyka Smith
    2021-02-18
    Every concept is very well explained by Nilay Arun. kudos to you man!
    Badr Moubile
    Badr Moubile
    2021-02-13
    Very helpfull!
    Agustin Olcese
    Agustin Olcese
    2021-01-27
    Excellent explantions, very clear!
    Jaak Jay
    Jaak Jay
    2021-01-14
    Awesome content, kudos to Prof.James Frojan
    sindhushree reddy
    sindhushree reddy
    2021-01-07
    Crisp and short ppt of Frm chapters and great explanation with examples.