Module III·Article III·~4 min read
Calculation of Yield and Comparison with Other Assets
Real Estate Investment
Turn this article into a podcast
Pick voices, format, length — AI generates the audio
Calculation of Real Estate Investment Yield
Key Yield Metrics
1. Cap Rate (Capitalization Rate)
Formula: Cap Rate = NOI / Market Value × 100
Shows current yield without considering financing. Used to compare properties to each other.
Example: an apartment in Barcelona valued at €350,000. Annual rent €18,000, expenses €4,000. NOI = €14,000. Cap Rate = 14,000 / 350,000 = 4.0%
2. Cash-on-Cash Return
Formula: CoC = Annual Cash Flow / Equity × 100
Considers the effect of leverage.
Example: same apartment in Barcelona. Purchased with a 70% LTV mortgage. Equity: €105,000 + purchase costs €35,000 = €140,000. Mortgage payment: €12,000/year. Cash flow: €14,000 − €12,000 = €2,000. CoC = 2,000 / 140,000 = 1.4% (low due to high rates)
3. Total Return
Formula: Total Return = (Rental Income + Capital Appreciation) / Investment × 100
Example: same apartment. Net rent: €14,000/year. Price growth 3%/year = €10,500. Total Return = (14,000 + 10,500) / 350,000 = 7.0%
4. IRR (Internal Rate of Return)
IRR — discount rate at which NPV of cash flows = 0. Takes into account the time value of money and all flows (purchase, rent, sale).
Usually calculated in Excel/Google Sheets using the IRR function.
5. Equity Multiple
Formula: Equity Multiple = Total Income / Invested Equity
Example: invested €100,000, over 5 years received €45,000 in rent + sold for €130,000 = €175,000. Equity Multiple = 175,000 / 100,000 = 1.75x
The Effect of Leverage
A mortgage increases yield (and risk):
| Scenario | Without Mortgage | With Mortgage (70% LTV) |
|---|---|---|
| Value | €300,000 | €300,000 |
| Equity | €300,000 | €90,000 |
| NOI | €15,000 | €15,000 |
| Mortgage Payment | — | €10,000 |
| Cash Flow | €15,000 | €5,000 |
| Return on Equity | 5% | 5.6% |
| Price Growth 5% | €15,000 (5%) | €15,000 (16.7%) |
| Price Drop 10% | −€30,000 (−10%) | −€30,000 (−33.3%) |
Leverage magnifies both profits and losses.
Comparison with Other Asset Classes
Historical Yield (Data for 20 Years)
| Asset | Average Annual Yield | Volatility | Sharpe Ratio |
|---|---|---|---|
| Real Estate (direct) | 7–10% | 5–8% | 0.8–1.0 |
| REITs (public) | 8–12% | 15–20% | 0.5–0.7 |
| Stocks (S&P 500) | 8–10% | 15–20% | 0.5–0.7 |
| Bonds | 3–5% | 5–7% | 0.3–0.5 |
| Gold | 5–8% | 15–18% | 0.3–0.4 |
| Deposits | 1–3% | ~0% | — |
Advantages of Real Estate
- Stable cash flow — regular rent
- Inflation protection — rent and value increase with inflation
- Tax advantages — depreciation, mortgage deductions
- Leverage — ability to use mortgages
- Low correlation with the stock market (for direct investments)
Disadvantages
- Low liquidity
- High transaction costs (5–12%)
- Need for management
- Risk concentration (one property, one location)
Real Estate in the Context of a Multi-Asset Portfolio
The issue of real estate share in an investment portfolio remains debated among financial advisors. The classic approach is allocation of 20–30% to real assets, including real estate, within a diversified portfolio. However, for many individual investors real estate makes up 60–80% of their entire wealth — mainly due to the effect of leverage and the availability of mortgages. The key role of real estate in the portfolio is to provide stable cash flow and inflation protection with moderate correlation to stocks and bonds. Data show that direct investments in real estate have correlation with the stock market of about 0.3–0.5 over a 10-year horizon, making them an effective diversifier. Comparison with public REITs gives another picture: their correlation with the broad stock market is 0.6–0.8, since they are traded on exchanges and exposed to general market volatility. For an investor with a horizon of more than 10 years, direct real estate investments with a good rent-to-price ratio (gross yield >5%) and moderate leverage (LTV 60–70%) have historically provided total returns of 8–12% per year.
Practical Tasks
Task 1. Calculate IRR for the following investment: purchase of an apartment in Dubai for AED 1,000,000 (including costs). Net rental income: year 1 — AED 65,000, year 2 — AED 68,000, year 3 — AED 71,000, year 4 — AED 74,000, year 5 — sale for AED 1,250,000 + rent AED 77,000.
<details> <summary>Solution</summary>Cash flows: Year 0: −1,000,000; Year 1: +65,000; Year 2: +68,000; Year 3: +71,000; Year 4: +74,000; Year 5: +1,327,000 (sale + rent). IRR ≈ 11.8% (calculated in Excel: =IRR({-1000000, 65000, 68000, 71000, 74000, 1327000})). Equity Multiple = (65+68+71+74+1327)/1000 = 1.605x.
</details>Task 2. An investor with €500,000 considers three options: (A) apartment in Berlin (yield 3.5%, growth 3%/year), (B) ETF on STOXX Europe 600 (expected yield 7%, volatility 18%), (C) REIT-ETF (yield 5%, volatility 14%). Create an optimal portfolio considering diversification.
<details> <summary>Solution</summary>Optimal portfolio for moderate risk: 40% apartment (€200,000 + mortgage) + 30% STOXX 600 ETF (€150,000) + 30% REIT ETF (€150,000). Justification: apartment provides stable income + leverage; ETF — capital growth; REIT — liquid exposure to real estate. Expected portfolio yield: 0.4×6.5% + 0.3×7% + 0.3×5% = 6.2% with volatility ~8% (due to low correlation). Sharpe Ratio ≈ 0.6 (with risk-free rate 3.5%).
</details>§ Act · what next