Real Estate Finance Finance & Investments · Term 3
🔍 /
🔍
Start typing to search across all sections, formulas, key concepts, and quiz content.

Tips: Try cap rate, DSCR, perpetuity, forward rate, amortisation, REIT
Multiple words = AND search (all terms must match).
Finance & Investments · Term 3

Real Estate
Finance

Six topic-based sections covering property fundamentals, RE mathematics, economic factors, demand & supply economics, valuation methodologies, and a complete formulae reference - with comprehension checks, practice questions, and mock exams.

6 Sections 4 Mock Exams66 Practice QuestionsExam Cram 120+ Quiz Questions Course Materials

Section Map

Course Structure
Section 01

Introduction to RE Finance

Asset class scale, types & rights, return metrics, risk framework, 2007 & 2020 crises, cycles, financing, tokenization.

1
Section 02

RE Mathematics

APR vs EAR, day counts, compounding, mortgage amortization, yield curves, spread analysis.

2
Section 03

Economic Factors

Discount factors, interpolation, yield curves, sovereign spreads, forward rates, FRAs, risk premium decomposition.

3
Section 04

RE Economics

Demand elasticity, HAI, absorption, supply dynamics, stock-flow model, vacancy, property clock.

4
Section 05

RE Valuation

DCF, cap rates, capitalization methods, residual, replacement cost, comparison, AVM, levered IRR, S&LB, capital markets.

5
Section 06

RE Formulae

Complete formulae reference with worked examples for every formula in the course.

ƒ

Practice & Tools

Exam Prep
Mock Exam 1

Consolidated Quiz

25 MCQ questions across all sections. 60 minutes. Kahoot-style with explanations.

Mock Exam 2

Numericals Only

25 numerical questions from the formulae sheet. 60 minutes. Full worked solutions.

Section 01 · 8 Sub-sections

Introduction to Real Estate Finance

The largest asset class on earth. We cover what RE is, how it's classified, how investors earn returns, how risk is measured, how crises reshaped the market, and where it's heading.

30 Accordions6 Comp Checks5 Class NotesSessions 01 & 02

Section Map

Click any card to jump in
1.1

Definition & Scale

What RE is, global scale ($281T), legal definition, liquidity solutions, periodic table

5 accordions · 1 chart
1.2

Asset Types

5 asset classes, risk/yield spectrum, residential vs commercial financing, securitisation

3 accordions · 1 comp check
1.3

Investment Strategies

Core → Opportunistic spectrum, Four Quadrants, capital stack

3 accordions · 2 tables
1.4

Return Metrics

Timeless (COCR, Cap Rate, GIM), Time (IRR), Debt (LTV, DSCR)

3 accordions · 1 chart
1.5

Risk Framework

Five RE risk premia, asset vs income risk, discount rate

2 accordions · 1 chart
1.6

Capital Markets & ESG

Direct/indirect investment, REITs, tokenisation, ESG certs

4 accordions · 1 comp check
1.7

Crises & Cycles

RE cycles, 2007 GFC, 2020 COVID, rate transmission

5 accordions · 2 comp checks
1.8

Outlook 2025-2030

EU prices, rental yields, property clock, data centres, Marbella vs Dubai

5 accordions · 2 comp checks

Key Numbers

Session 01 - Slide Data
$281TGlobal RE value - largest asset class
5× GDPRE value vs total global GDP
15%RE share of Spanish economy
12%RE share of European economy
7%RE share of US economy
65%Senior debt in typical RE funding stack

Definition & Scale

Slides p.4–9
What Is Real Estate? The Legal Definition Slide p.5

Real estate: property, land, buildings, air rights above the land (with certain limitations) and underground rights below the land. It is the land and attached improvements that represents a capital good that produces a flow of services over time.

Land includes three layers:

LayerWhat It CoversLimit
Air rightsAbove the surface, from earth to National Aviation floorMax 300 metres
SurfaceEarth’s surface, lateral & subjacent supportRegulated
SubsurfaceSubstances including water, minerals, oil & gasRegulated
💡
The scale context: Global real estate is worth US$281 trillion - more than 5× total global GDP. Residential alone accounts for US$220.2 trillion. This dwarfs equities ($111T), bonds ($141T), oil reserves ($125T), and gold ($8.6T). The main limitation holding RE back relative to other asset classes? Lack of liquidity.
Global Real Estate vs Other Asset Classes (USD Trillions)
Solving the Liquidity Problem Slide p.7

The course frames liquidity as the only structural weakness of RE relative to other asset classes. Three solutions have been developed historically:

SolutionWhat It IsSessions Covered
REITsShares of companies fully investing in RE assets and renting them. Provides stock-market liquidity to RE exposure.S11
SecuritisationsBonds backed by RE mortgages (MBS, ABS). Converts illiquid mortgage pools into tradeable fixed income.S9
TokensDigital representation of ownership or rights in an RE asset, managed/optimised using AI technologies.S11
The Periodic Table of Asset Classes Slide p.8

The course uses the periodic table metaphor to classify all asset classes by liquidity (Riskalyze Risk Number - darker border = less liquid) and place Real Estate in the broader investment universe.

Periodic Table of Asset Classes (Source: Slide p.8)
FIXED EQ STRUCT PRIV REAL INFRA ALT HY High Yield SB Savings Bonds CD Cert. Deposit TB Treasury Bills MB Muni Bonds CB Corp Bonds CS Common Shares EF Equity Funds DpS Div-Paying PS Pref Shares FA Fixed Annuities SD Struct. Deposits ILP Interest-Linked ELP Equity-Linked CLP Credit-Linked MLP Market-Linked VC Venture Capital LBO LBO Fund FF Fund of Funds MC Mezzanine Cap. Re Residential 90 En Energy 93 In Industrial 74 REF RE Fund 94 Com Commercial 91 REIT Real Est. Trust 91 RL Raw Land NR Wa Water Ro Roads Rr Railroads Au Gold CO Crude Oil NG Natural Gas Cn Corn Wh Wheat Reading the Table REF = Real Estate asset Symbol = Abbreviation Number = Riskalyze liquidity score (NR = Not Rated) Higher score = less liquid RE scores 90–94: very illiquid ◀ Real Estate row
💡
Key takeaway: Real estate (scores 90–94) sits alongside raw land as the least liquid major asset class. This is the structural problem the whole course is designed to address - through mortgages, MBS, REITs, and tokenisation.
Key Definitions: Prices, Markets & Why People Buy Slide p.9, 14
ConceptDefinition
Rental rateThe service price - the price per unit of services for a specified time period, determined in the market for real estate space.
Market valueThe asset price - the present value of the service flow over the asset’s economic life, determined in capital markets.
Real estate marketThe geographic area where the per unit price of RE services is constant. There is no single RE market - there are thousands of micro-markets governed by: Typology, Location, Antiquity.
Consumption motiveTo use the services provided by the property - housing, office space, etc.
Investment motiveTo make money - income from rents, capital gain, and tax benefits.
RE Activities & Economic Impact Slide p.13, 15

Property-related activities are highly diverse. The 8 main activity types:

ActivityDescription
Property managementRentals management, buy/sell
PlanningCash flows generation
FinancingLeverage, mortgages, MBS
Construction activitiesDesign, development, build
ValuationEconomics, methodologies, big data
Facilities managementMaintenance of buildings and equipment
ConsultancyAdvisory for business lines
Brokerage servicesDeals intermediation
7%USA GDP contribution
12%European GDP contribution
15%Spanish GDP contribution

Types of Real Estate Assets

Slides p.20–25
The Five Asset Classes + Risk/Yield Spectrum Slide p.21–25
#Asset TypeSub-typesRisk / Yield Rank
1LandVacant land, working farms, ranchesMedium (development timing)
2ResidentialSingle-family, townhomes, duplexes, multifamily, land for dev.Lowest risk / lowest yield
3CommercialRetail (shopping centres, regional malls), officeMedium
4IndustrialFactories, warehouses, utilities, minesMedium-Low
5AlternativeData centres, storage, hotels (leisure & business), healthcare, schools, student housing, golf, nursing homes, cemeteriesVariable - often highest yield
Yield Spectrum (Slide p.25) - Exam Favourite From highest risk/yield to lowest risk/yield: Shopping centres → Others → Offices → Industrial & Logistics → Hotels → Residential (lowest). The order can change depending on global economy, sector, financial, political, and legal situation.
Risk & Yield Spectrum by Sector (relative index - higher bar = higher risk & yield)

⚠ Order can change with macro conditions. Chart shows typical ranking; not absolute yield values.

Hotel risk is managed via four ownership models (slide p.24): 1. Management agreement → 2. Franchise agreement → 3. Lease agreement → 4. Ownership (risk increases with number).

Residential & Commercial: The Financing Dependency Session 01 Notes

80–90% of property purchases are financed through mortgages, not cash. This creates a massive credit intermediation role for banks - an estimated 80% of residential market value flows through the banking system via mortgage lending. The implication: real estate finance is core to financial system stability and capital allocation.

Residential The dominant segment by market capitalisation. Single-family homes, multifamily apartments, condominiums. Subject to severe supply shortages in major cities (Madrid, London, San Francisco). Mortgage terms typically 15–30 years, fixed or variable rate, with 10–20% equity required.
Commercial Office, retail (shopping malls, street-level stores), hotels, industrial warehouses. Different lease structures and tenant creditworthiness profiles vs. residential. Cap rates and risk premiums differ significantly from the residential segment.
Agricultural - Fastest Growing Land dedicated to farming and food production, emerging as a strategic asset class driven by climate change, population growth, and food security concerns. Distinct valuation and risk characteristics with a different investor base from traditional commercial RE.
📝 Class Note

The course highlighted the Madrid residential market specifically - high rental and purchase prices due to limited new supply. The chronic undersupply in major cities is a structural feature, not a cyclical one: zoning restrictions, construction costs, labour shortages, and regulatory delays all constrain new development.

Securitisation & REITs: Solving Illiquidity Session 01 Notes

The single structural weakness of RE vs. other asset classes is illiquidity. Three market-level solutions have been developed:

SolutionMechanismLiquidity Created
Mortgages → MBSBanks pool hundreds of mortgages, create tranches (senior AAA, mezzanine, junior), sell as bonds to institutional investorsConverts illiquid loans into tradeable fixed income. Banks earn origination/servicing fees; investors earn yield.
REITsPublicly traded companies that buy, hold, and rent RE. Distribute 90%+ of taxable income as dividends. Fractional ownership via stock exchange.Only 8–10% of $750T RE market is in REITs - huge untapped potential. Daily price discovery, transparent valuation.
TokenisationDigital representation of ownership via blockchain and smart contracts. Each token = fractional ownership of underlying RE and all cash flows.UAE leads (first direct token issued early 2026). US/Europe ~20 years behind due to legacy tax/registration systems.
🎯
Exam angle: The 2007-08 crisis was fundamentally a failure of the MBS securitisation process - rating agencies assigned AAA to pools of subprime mortgages, hiding real risk. This is covered in detail in the crisis section below. Know the mechanism, not just the outcome.
🧠 Comprehension Check
REITs represent only 8–10% of the total RE market despite offering stock-market liquidity. What is the PRIMARY reason for this low penetration?
(a) Most governments do not allow REIT structures
(b) REIT returns are lower than direct ownership
(c) Most RE is held by owner-occupiers and private investors who have no incentive to list their assets; regulatory and tax barriers limit REIT formation
(d) Institutional investors prefer bonds over RE
(c) is correct. The vast majority of global RE is owned directly by occupiers (homeowners) or private investors. Converting these holdings into REIT structures requires complex legal restructuring, tax optimisation, and regulatory compliance. Only 35 countries have active REIT legislation, and many property owners prefer the control and tax benefits of direct ownership. Tokenisation aims to solve this by dramatically lowering the cost and complexity of fractional ownership.

Types of Real Estate Investments

Slides p.27–32
Investment Strategy Spectrum: Core to Distress Slide p.31
StrategyAsset QualityDevelopment RiskHorizonLeverageTarget Return
COREHigh quality, prime areasNoneLong-termLow5–8%
CORE +High quality, prime areasSome improvement opportunityMedium-longModerate8–10%
VALUE-ADDConsolidated or potential areasUse/profitability optimisationShort-mediumMedium10–15%
OPPORTUNISTICDeveloping areas, early-stageEarly-stage asset developmentShort-mediumHigh15%+
DISTRESSRecovery markets, troubled assets/debtRecovery playShort-mediumIf possible20%+
Exam Tip - Proyecto Helvetia Classification Helvetia (Sessions 13–14) is Opportunistic/Development: ground-up conversion of offices to luxury branded residences, 52% LTC bridge + 70% construction loan, targeting 22.7% gross IRR. Know where it sits and why the returns must compensate for development risk.
Investment Strategy Spectrum: Risk & Return Continuum
CORE 5–8% CORE+ 8–10% VALUE-ADD 10–15% OPPORTUNISTIC 15%+ DISTRESS 20%+ Low leverage • Income focus • Prime assets High leverage • Capital gain • Distressed Helvetia
The Four Quadrants of RE Finance Slide p.29

RE finance can be accessed through four distinct market quadrants. Different investors typically operate in one or some of them, although all are interrelated:

QuadrantVehiclesReturn Source
Private EquityCore, value-add and opportunistic fundsValue & dividends; medium-high liquidity
Private DebtMortgages, bridge loans, mezzanine loansInterest rate; low-medium liquidity
Public EquityREITs, SOCIMIs, listed companiesDividends & capital value; high liquidity
Public DebtMortgage-backed securities (MBS/ABS)Coupon; medium liquidity
RE Funding Structure: The Capital Stack Slide p.30

The financing structure is supported by different instruments with different risk profiles and returns. Certain investors only operate in one category:

Tranche% of StackRisk/Return
Senior65%Lowest risk; first to be repaid; lowest return
Stretched Senior15%Slightly higher LTV than plain senior
Junior / Mezzanine10%Subordinated; higher yield than senior
Preferred Equity5%Priority over common equity; fixed return component
Equity5%Highest risk; residual claimant; maximum upside
Proyecto Helvetia context: Besant Capital’s deal uses a bridge loan (50.2% LTC) converting to a construction loan (up to 70% LTC) + equity injections of €68M. This maps directly to the Senior + Equity layers of the stack. No mezzanine was drawn in the base case.
Typical RE Funding Structure (Capital Stack)
Equity (5%) Preferred Equity (5%) Junior / Mezzanine (15%) Stretched Senior (10%) Senior Debt (65%) Low risk High risk Risk & Return High return Low return

Return Metrics

Slides p.60–70
Timeless Metrics: COCR, ROI, ROE, GIM, Cap Rate Slide p.62–64

Timeless metrics do not require a time horizon - they measure a single snapshot of performance:

Cash on Cash Return (COCR) - also called Equity Dividend Rate: COCR = Annual before-tax CF / Total CF invested Income Return / Return on Investment (ROI): ROI = (Income - Expenses) / Investment Return on Equity (ROE): ROE = Annual Income / Equity Gross Income Multiplier (GIM): GIM = Sell price / Annual Income (ignores time value of money) Cap Rate / Exit Yield: Cap Rate = NOI / Property Value (uses value) Exit Yield = NOI / Exit Value (uses cost - drifts from cap rate over time) Property Value = NOI / Cap Rate (core valuation identity) Example (Slide p.63): Asset value: €15,000,000 NOI: €750,000 Cap Rate = 750,000 / 15,000,000 = 5% Exit Value (sale price) = NOI(n) / Cap Rate
Cap Rate & Interest Rate Relationship Cap rates are highly correlated with market interest rates. Rising rates ⇒ rising cap rates. Declining rates ⇒ cap rates compress. This is exactly what happened 2020–21 (rates at 0%, cap rates compressed, values spiked) and 2022–23 (ECB to 4.5%, cap rates rose, values fell 15–30%).
Cap Rate vs 10-Year Treasury (%) - USA 2010–2023 (Source: Slide p.65, FRED / Zillow)

When the 10Y Treasury crosses above the cap rate, RE investors stop buying - yield inversion. This is exactly what happened in 2022–23 and drove the global valuation correction.

Time Metrics: Payback, Period Return, IRR, Leveraged IRR Slide p.67
Payback Period: Payback = Equity investment / After-tax annual CF Period Return: Period Return = FV / PV - 1 Simple Annualised Return: Simple Ann. = (FV/PV - 1) / T Compound Annualised Return (CAGR): CAGR = (FV/PV)^(1/T) - 1 Internal Rate of Return (IRR): PV = Sum of [CF_i / (1 + IRR)^t_i] (IRR = r that makes PV of all CFs = 0) Leveraged IRR: Same formula as IRR but cash flows are net of debt service (interest + principal). When leverage is included we call it leveraged IRR. Used identically to unleveraged IRR.
📝
Exam distinction: Unlevered IRR uses total asset cash flows (pre-debt). Levered IRR uses equity cash flows (post-debt service). Leverage amplifies IRR when NOI > debt cost. In the REFM exercise, levered IRR target is 7% vs unlevered based on cap rate of 4.25%.
Debt Metrics: LTV, DSCR, DTI, Effort Rate Slide p.68
Loan to Value (LTV): LTV = Amount Loan / Property Value Debt to Income (DTI): DTI = Monthly payments / Monthly income Effort Rate (ER) - mortgage affordability: ER = Loan Expenses / Pre-tax income Threshold: 30–35% is the standard lender maximum Debt Service Coverage Ratio (DSCR): DSCR = EBITDA / (Interest + Principal) DSCR > 1.0 means property income covers debt service Banks typically require DSCR ≥ 1.20–1.25 minimum Debt to Equity (DTE): DTE = Total liabilities / Shareholders equity Working Capital (WC): WC = Current assets / Current liabilities
REFM exercise link: The amortising loan exercise in Sessions 9–10 explicitly asks you to calculate the salary required given a 35% Effort Rate. This is the same formula above - ER = Loan Expenses / Pre-tax income, with 35% as the bank’s threshold.
Discount Rates by Use Type - Risk vs Expected Return (Source: Slide p.70)

Each bubble = a property use type. Hover for label. Low risk = residential & office rent (~4–5%). High risk = development plays (15–20%+).

Risk Framework

Slides p.53–59
The 5 Types of RE Risk & Risk Premium Slide p.55–58

Market value = PV of expected benefits discounted at the market rate. The discount rate = risk-free rate + expected inflation + real estate risk premium. The risk premium is built from five components:

#Risk TypeDefinitionExamples
1Business riskUnexpected reduction in the demand for the services provided by the propertyTenant leaves, WFH reduces office demand, e-commerce kills retail
2Financial riskAssociated with using leverage to finance the acquisition. Debt versus EquityRate rise increases debt cost, LTV covenant breach, refinancing cliff
3Inflation riskAssociated with changes in the price level, particularly construction costsBuild cost overruns, material shortages, contractor insolvency
4Liquidity riskUncertainty of being able to sell the property when requiredFrozen credit markets (2008), forced sale at distressed prices
5Legal riskUncertainty from government involvement in RE - zoning, rent control, building codes, taxesSpain rent control 2023, planning refusal, heritage restrictions
Risk by Phase (Slide p.59) Investment phase: Financial + Legal + Inflation • Development phase: Financial + Legal + Inflation + BusinessCommercialisation phase: Financial + Legal + Inflation + Business + Liquidity. Risk accumulates as you move through the lifecycle - maximum risk at exit.
RE Phases & Risk Accumulation (Source: Slide p.59)
INVESTMENT DEVELOPMENT COMMERCIALISATION Financial Legal Inflation Financial Legal Inflation Business Fin. Legal Infl. Biz Liq. 3 risks 4 risks 5 risks (maximum) Lower risk Risk accumulates ↑
Two Components of Risk: Asset Risk vs Income Risk Slide p.54
Asset Risk
  • Technical quality / suitability to market demand
  • Location
Income Risk
  • Existence of development risk
  • Commercial risk
  • Existence and term of contracts
  • Tenant quality / guarantees

Capital Markets & RE

Slides p.33–52
Direct vs Indirect Investment Routes Slide p.34
RouteVehiclesReturn Sources
DirectEquity investments (buying RE assets), Debt investment (lending RE projects)Rents + Capital value change
IndirectRE funds, ETFs, REITs, publicly/privately held companiesDividends + Interest + Capital value change
REITs: Global Landscape & Qualifying Assets Slide p.45–51

REITs (Real Estate Investment Trusts) are the primary mechanism for listed RE exposure. Key facts:

  • Global REIT market cap approaching $2 trillion; 35 countries with active REIT legislation
  • Largest REITs globally (Jul 2025): American Tower ($102.6B), Welltower ($101.5B), Prologis ($101.3B) - all US-based
  • Spain’s equivalent: SOCIMI (created 2009)
  • For a company to qualify as a REIT: at least 80% of assets must be qualifying assets
  • Qualifying assets: urban RE (buildings, offices, shopping centres, warehouses, garages) acquired/promoted for leasing; land to be leased (development starts within 3 years); holdings in other REITs and RE funds
  • Specialisation is a generalised trend - sector-specific REITs dominate: shopping centres, hotels, offices, housing, hospitals, retail shops, parking, residences
💡
Market value formula (slide p.52): Property market value = PV of expected benefits discounted at market rate of return. The discount rate is a function of: (a) risk-free interest rates + (b) expected inflation + (c) uncertainty (risk).
Tokenisation: Blockchain-Based Fractional Ownership Session 01 Notes

Tokenisation transforms illiquid, high-value RE into tradeable digital tokens via blockchain and smart contracts:

  • Mechanism: Owner creates an SPV (special purpose vehicle). SPV’s equity is tokenised into digital tokens, each representing fractional ownership of the underlying RE and all cash flows. Tokens are tracked via distributed ledger and tradeable on decentralised markets.
  • Smart contracts encode the complete asset profile: ownership history, mortgage/lien information, lease terms, tenant credit profiles, tax records, regulatory compliance. All transparent, immutable, accessible to token holders. This eliminates information asymmetry and reduces due diligence costs.
  • IE Building example: Traditional outcome = €400M asset, limited buyer pool, illiquid. Tokenised outcome = 400 investors hold 0.25% tokens each, continuous trading, price discovery at €330–350M based on fundamentals.
📝 Class Note - Geographic adoption

UAE leads: Dubai/Abu Dhabi issued first direct RE token ~early 2026. Built regulation from scratch with no legacy tax/registration obstacles. Simpler tax regime and centralised registration database. US/Europe: 15–20 years behind. Complex century-old property registration, transfer taxes (stamp duty), multiple regulatory bodies (local/state/national). Each token transaction triggers tax reporting: buyer identity, purchase price, date.

🧠 Comprehension Check
An investor buys a €100K token representing 0.025% of a €400M building that generates €24M annual NOI. What is the investor’s expected annual income from this token (before fees)?
(a) €2,400
(b) €6,000
(c) €10,000
(d) €24,000
(b) is correct. The investor owns 0.025% of the NOI: €24M × 0.00025 = €6,000 per year. This represents a 6% yield on their €100K token (€6,000 / €100,000). Note: the cap rate is 24M/400M = 6%, so the token yield equals the building’s cap rate - as expected, since the token is a proportional claim on the asset.

Sustainability in Real Estate

ESG Framework
Why ESG Is Now a Financial Issue, Not Just Ethical S1 ESG

The built environment accounts for approximately 40% of global energy consumption and 36% of CO₂ emissions. ESG has moved from voluntary to mandatory in institutional-grade investment:

CertificationOriginScaleFinancial Impact
BREEAMUK, 1990Pass → Outstanding3–8% rent premium documented
LEEDUSA, 1998Certified → Platinum7–12% value premium (JLL data)
DGNBGermany, 2007Bronze → PlatinumLifecycle cost focus
EPC (EU)EU directiveA (best) → G (worst)G-rated assets face stranded asset risk post-2028

Note Proyecto Helvetia’s commitment to LEED and BREEAM at highest levels, PV solar, EV charging, greywater recycling - these directly support the €17,500–28,875/sqm branded residence price targets.

Session Slides

Available - 82 pages
Slides available: The course's 82-page introduction deck is fully incorporated above. Topics covered: Definition & scale • RE activities • Asset types & yield spectrum • Investment types (Core → Distress with exact return ranges) • Capital stack • Capital markets (direct/indirect, REITs, ETFs) • Risk framework (5 risk types) • Return metrics (Timeless / Time / Debt taxonomy with all formulas) • Trends & Outlook (see Session 2).

Class Notes: Session 01

16 March 2026
📝 Class Notes - Session 01 (16 March 2026)

Course structure: Theory + practical Excel modelling. Open-book exam with Excel access and a formula cheat sheet. Class participation 20%, group case study presentation 20%. Required readings on course platform for each session.

  • Global RE market value (end 2025): USD 750+ trillion - the figure used in class is higher than the $281T slide figure because it includes all land and agricultural RE
  • 80–90% of properties financed via mortgages, not cash - RE finance is core to financial system stability
  • REITs represent only 8–10% of total RE market value despite being publicly traded - huge untapped potential
  • Tokenization: UAE (Dubai) issued first direct RE token ~2 months ago. US/Europe estimated 20 years behind due to legacy tax/registration systems
  • IE Building example: 40-year lease with IE, ~6% annual return. DCF valuation yields €330–350M vs. €400M asking price. Key insight: discount rate = Spanish 30-year bond (4.21%) + RE risk premium
  • Five sources of RE risk premium (vs. government bonds): liquidity risk, concentration/size risk, geographic/regulatory risk, operational/management risk, market/cyclical risk
🧠 Comprehension Check
A property has NOI of €3M and an investor requires 7% return. A comparable property sold at €38M with NOI of €2.5M. Which valuation approach gives a LOWER value, and why?
(a) Direct capitalisation at 7% gives €42.9M; comparable implies 6.58% cap rate and €45.6M - DCF is lower
(b) Both methods give the same value
(c) The comparable method always gives a lower value
(d) Cannot determine without knowing the exit cap rate
(a) is correct. Direct cap: €3M / 0.07 = €42.86M. The comparable implies a market cap rate of 2.5/38 = 6.58%, which applied to our NOI gives 3M / 0.0658 = €45.6M. When your required return exceeds the market cap rate, your DCF value will be lower than what the market is pricing - meaning the market is “richer” than your hurdle. This is the core tension between Investment Value and Market Value.

Key Numbers

Crisis & Market Data · Merged from S02
−33%US house prices peak-to-trough 2007–09
−24%Spain RE prices 2008–14
€50BSAREB bad bank peak assets (Spain)
−70%Hotel RevPAR drop 2020
4.5%ECB deposit rate peak 2023
−20%EU prime office values 2022–24 avg

Real Estate Cycles

Historical Patterns
Why RE Markets Cyclically Over-Correct S2 Theory

RE cycles are driven by a fundamental structural lag: supply cannot respond immediately to demand signals. Planning, design, and construction take 2–5 years - meaning new supply always arrives into conditions shaped by the past, not the present.

Cycle PhaseCharacteristicsInvestor Behaviour
RecoveryVacancy falling, rents flat/rising, no new supply yetEarly movers buy; majority still cautious
ExpansionLow vacancy, rents rising strongly, construction startsWidespread buying, leverage increases
HypersupplyNew supply arrives into softening demand; vacancy risesSellers struggle; lenders tighten
RecessionHigh vacancy, falling rents, negative absorption, distressForced sales, NPLs, bad banks

The 2007–09 Global Financial Crisis

Systemic Failure
Root Causes: How a Housing Bubble Became a Global Crisis S2 GFC
1990s–2001Deregulation, financial innovation, and low rates create conditions for excess credit. US homeownership treated as a social policy goal.
2001–2006US house prices +80%. Subprime lending explodes. Originate-to-distribute model removes credit risk from originators - no skin in the game, volume over prudence.
2004–2007MBS, CDOs, CDO-squared proliferate. AAA tranches awarded to toxic pools. Rating agencies paid by issuers; conflict structurally embedded. Synthetic CDOs amplify exposure beyond underlying assets.
Early 2007US house prices plateau then fall. Subprime delinquencies spike. Bear Stearns hedge funds collapse (June 2007). Warning signs ignored.
Sep 2008Lehman Brothers collapses. Global credit markets freeze. LIBOR-OIS spread explodes. Money market funds “break the buck.” Central bank emergency intervention worldwide.
2009–2014European sovereign debt crisis compounds RE stress. Spanish banks hold billions in impaired collateral. SAREB (bad bank) created Nov 2012. Peak Spanish RE price decline: −24%.
Industry experience example: A Director of Risk & Valuations at SAREB (2013–2017) managed €50B+ of distressed RE assets. This perspective on valuation under stress is grounded in practice.
Key Mechanisms: Originate-to-Distribute & Tranching S2 GFC
MechanismDescriptionWhy It Failed
Originate-to-DistributeBanks originate mortgages, package and sell to markets. Originator bears no long-run credit risk.Removed incentive for quality. Volume maximised over prudence.
CDO TranchingMortgage pools sliced by seniority. Senior tranches get AAA despite subprime underlying.Correlation assumptions wrong. Risk obscured, not eliminated.
Rating Agency ModelPaid by issuers. Short historical data. Conflict of interest structural.AAA given to pools that later lost 50%+.
LeverageInvestment banks at 30:1+ leverage ratios.No buffer. Tiny value decline = insolvency. Lehman: $600B assets, $22B equity.

The 2020 COVID Shock

Exogenous Disruption
Winners and Losers: COVID’s Uneven Sectoral Impact S2 COVID

Unlike the GFC (a credit crisis), COVID was an exogenous demand shock that accelerated structural trends already in motion:

SectorImmediate ImpactStructural Long-Run Effect
RetailSevere - forced closures, rent moratoriums, CVAs.Non-experiential retail structurally challenged. E-commerce accelerated by 3–5 years.
OfficeSevere - near-zero physical occupancy in lockdowns.Hybrid working permanent. Sq m demand reduced; quality demand up. Bifurcation.
HotelsCatastrophic - RevPAR –70%+ in 2020.Leisure recovered 2022–23. Business travel still below 2019 levels.
LogisticsPositive - e-commerce boom, record take-up.Structural demand continues. Last-mile urban sites scarce and premium.
ResidentialPositive (suburban). Urban initially flat.Rental inflation crisis in major EU cities. Affordability worsening.
Life SciencesPositive - biotech/pharma investment surge.Strong institutional demand for lab/R&D. Supply constrained in clusters.
Data CentresVery Positive - digital acceleration.Secular growth: AI compute, cloud, streaming. Power is the new constraint.
Interest Rate Transmission: The 2022–23 Valuation Compression Session 02 Notes

The post-COVID rate cycle delivered the sharpest cap rate adjustment in decades:

  • 10-year Treasury rose ~400 bps (2021–2023), triggering cap rate expansion of 100–150 bps across most sectors
  • Value = NOI / Cap Rate - a 150 bps cap rate rise (e.g. 4% → 5.5%) reduces value by ~27% even with stable NOI
  • Floating-rate debt refinancing at higher rates further pressured debt service capability - many properties developed at peak leverage (75%+ LTV) became distressed
  • Institutional investors shifted to core RE (stabilised, income-producing) over development due to rate uncertainty
📝 Class Note - Session 02

Office bifurcation: Class A (modern, collaborative, ESG-compliant) remained in demand. Class B/C became functionally obsolete in many markets, with conversion costs making adaptation uneconomical. Retail: Mixed-use properties with experiential, non-Amazon-able services fared better than traditional department stores. Residential: Initially strong due to remote work migration and low rates, then squeezed as rate increases compressed affordability. Some Sunbelt markets benefited; Midwest manufacturing centres struggled.

🧠 Comprehension Check
A logistics warehouse generates stable NOI of €1.5M. During COVID (2020–21), the cap rate compressed from 5.5% to 4.0% due to e-commerce demand. By 2023, rising rates pushed cap rates back to 5.0%. Calculate the peak-to-2023 value decline as a percentage.
(a) 9% decline
(b) 20% decline
(c) 27% decline
(d) No decline - NOI is stable
(b) is correct. Peak value (4.0% cap): €1.5M / 0.04 = €37.5M. Value at 5.0%: €1.5M / 0.05 = €30.0M. Decline: (€37.5M − €30.0M) / €37.5M = 20%. The NOI didn’t change at all - the entire loss came from the cap rate moving 100 bps. This is why cap rate sensitivity analysis is the first thing an investor should run, even for “safe” sectors like logistics.

Outlook 2025–2030

Slides p.71–81
EU Market Data: House Prices, Rents & Investment by Sector Slide p.72, 77–78
+4.9%EU house prices Q4 2024 YoY
+3.2%EU rents Q4 2024 YoY
28%Living / multi-housing: EU investment share 2025
22%Office share (JLL Feb 2026)
21%Industrial & logistics share
13%Retail + Other share

EU investment recovery 2024 (CBRE data): Living (+8% YoY), Industrial (+13%), Hotels (+39%), Office (−16%), Retail (−10%). Top country by investment volume: UK €9.5B, Spain +14% YoY to €2.5B.

EU House Prices & Rents Index (2010 = 100) - Source: Slide p.72, Eurostat

House prices (+55% from 2010 baseline) have consistently outpaced rents (+30%). Q4 2024: prices +4.9% YoY, rents +3.2% YoY.

EU Real Estate Investment by Sector €bn (2011–2024) - Source: Slide p.77, CBRE

Living overtook Office as the #1 sector by 2021. Industrial & logistics doubled its share 2015–2022. Office and Retail structurally declining. Hotels recovering post-COVID.

European Rental Yields by City Slide p.73
CityGross Rental YieldAvg Value/m²
Dublin, Ireland7.33%€5,190
Istanbul, Turkey6.63%€1,250
Riga, Latvia6.46%€1,069
Lisbon, Portugal5.65%€2,512
Brussels, Belgium5.54%€2,749
Madrid, Spain5.30%€4,101
Athens, Greece5.25%€1,485
Milan, Italy5.04%€5,367
Amsterdam4.80%€7,963
Paris, France4.72%€9,940
Berlin, Germany3.83%€5,389
JLL Global RE Health Monitor & Property Clock (Feb 2026) Slide p.74–75

Selected cities from JLL’s Global RE Health Monitor (Q1–Q4 2025):

CityInvestment $bnRental Growth Q4-25Vacancy RateNet Absorption
New York29.1+2.2%14.1%+12.2%
London21.4+12.9%8.9%−2.8%
Tokyo28.3+16.5%0.7%−14.4%
Seoul23.2+6.4%4.6%−79.2%
Paris14.3+10.8%11.2%−42.1%
San Francisco5.3+1.6%34.4%−20.0%
Sydney6.4+10.9%17.8%−52.5%

JLL Property Clock - Living (Feb 2026): Bangkok, Madrid, Stockholm, San Francisco, Dallas → Growth accelerating. Brussels, London, Paris, Amsterdam → Growth slowing. Beijing, Shanghai → Bottoming out.

Data Centres: The Structural RE Mega-Trend Slide p.79–81

Key site selection factors for data centre RE: Power, Fibre connectivity, Water access, Security, Accessibility, Zoning, Permits, Cost.

RegionPrime DC Yield
USA (most liquid)4–12% (wide: size, tenure, location)
Japan4–5%
Western Europe5–7%
Singapore6–7%
Malaysia7–7.5%
China8–12%
💡
AI capex tsunami: Google, Amazon, Microsoft and Meta will spend more than $400bn on data centres in 2026, on top of $350bn in 2025. Data centre construction CAGR 5.95% (2025–2027). Leading countries: USA (5,381), Germany (521), UK (514), Spain (144). Market opportunities: renewable energy, 5G edge data centres, AI infrastructure, innovative technologies.
Marbella vs Dubai - A Tale of Two Luxury Markets Slide p.37

The course contrasts two live examples from the slides to illustrate market divergence:

FactorMarbellaDubai
Price/m² (avg)€4,228≈€4,740
Price growth 2025+9.8–13.8% YoY, stable+13% YoY, slowing
10-year appreciation+105%+ (stable)Cyclical - confirmed bubble risk
Tax on rental income19% (EU resident) / −24% non-EU0%
Capital gains tax19–28%0%
New supply pipeline≈8,000 homes/yr400,000+ by 2030
UBS bubble riskNot flagged5th highest globally
Geopolitical riskVery low (EU member)Continuously high

Session Slides

Available - 82 pages (shared with S1)
Slides available: Sessions 1 & 2 share the same 82-page deck. Trends & Outlook (slides p.71–81) is fully incorporated above: EU house price data, European rental yield table, JLL Global Health Monitor, JLL Property Clock, data centre yield ranges, and Marbella vs Dubai market comparison.

Class Notes: Session 02

20 March 2026
📝 Class Notes - Session 02 (20 March 2026)

Real estate as dual-demand asset: consumption demand (owner-occupiers, driven by household formation, immigration, living preferences) AND investment demand (investors seeking cash flows, driven by relative yields and appreciation expectations).

  • 2007-08 Crisis mechanics: Subprime ARMs issued at teaser rates that reset upward. Originate-to-distribute model meant banks had no skin in the game. Home prices fell 30%+; foreclosure flood depressed prices further. Leverage amplified losses - Bear Stearns, Lehman collapsed.
  • 2020 COVID impact by sector: Office vacancy surged (remote work); Class A survived, Class B/C became obsolete. Retail closures accelerated e-commerce. Residential initially strong (low rates + migration), later squeezed by rate increases.
  • Cap rate & interest rate link: Value = NOI / Cap Rate. When 10-year Treasury rose ~400 bps in 2022-23, cap rates expanded 100-150 bps, compressing valuations 30-50% even with stable NOI.
  • RE cycle phases: Recovery (low occupancy, rising rents) → Expansion (full occupancy, cap rate compression) → Hypersupply (overbuilding, concessions) → Recession (rising vacancy, cap rate expansion)
  • Debt metrics: LTV = Loan / Value. DSCR = NOI / Debt Service (lenders require >1.25x). DSCR <1.0x = cash flow negative = distress signal.
  • Structural trends post-2020: Core RE preferred over development. ESG/green buildings command premium rents. Remote work drives workforce migration to Sunbelt/lower-cost markets.
🧠 Comprehension Check
A property with NOI of €2M was purchased at a 4% cap rate. Interest rates then rise 200 bps, causing the market cap rate to expand to 5.5%. The NOI remains unchanged. What is the approximate loss in property value?
(a) €8.0M (16% decline)
(b) €13.6M (27% decline)
(c) €20.0M (40% decline)
(d) No change because NOI is stable
(b) is correct. Original value: €2M / 0.04 = €50M. New value: €2M / 0.055 = €36.4M. Loss = €50M − €36.4M = €13.6M, a 27.3% decline. This is exactly what happened in 2022-23: stable rental income but collapsing valuations because discount rates rose. It demonstrates why cap rate sensitivity is the single most important risk in leveraged RE.
🧠 Comprehension Check
A property has annual NOI of €800,000 and annual debt service of €700,000. The DSCR is 1.14x. A new lender requires minimum 1.25x DSCR. What is the MAXIMUM annual debt service the lender would approve?
(a) €700,000
(b) €640,000
(c) €800,000
(d) €1,000,000
(b) is correct. Max debt service = NOI / minimum DSCR = €800,000 / 1.25 = €640,000. The existing €700,000 debt service would be rejected because DSCR = 800/700 = 1.14x < 1.25x required. The borrower must either increase NOI or reduce the loan amount.
Section 02 · 3 Sub-sections

RE Mathematics

Interest rate conventions, day counts, compounding, yield curves, present value, and discount rate architecture for real estate.

APR & EARDay CountsCompoundingYield CurvesSession 03

Section Map

Click any card to jump in
2.1

Interest Rates & Day Counts

APR vs EAR, day count conventions (A/360, A/365, A/A, 30/360), rate conversion, mortgage payment maths

3 accordions · 1 class note · 1 comp check
2.2

Yield Curves & Compounding

Yield curve shapes (normal, flat, inverted), 3 compounding types, RE spread analysis

2 accordions · 1 class note · 1 comp check
2.3

Present Value & Discount Rates

PV of cash flows, discount rate architecture for RE, risk-free + premium decomposition

3 accordions · 1 class note

Key Numbers

Session 03 - REFM Exercise Set
Act/365Standard day count (RE finance)
0.99754DF: 1%, 90d, simple, Act/365
0.99343DF: 2%, 120d, simple, Act/365
1.5%Interpolated rate at 100d (ex. 1–2%)
4%YTM for PV of cash flows exercise
€2.22MPV of 5×€500k at 4% YTM

Interest Rate Fundamentals

Conventions & Algebra
Simple vs Compound Interest & Day Count Fractions S3 Core

All interest rate problems require three parameters: the rate, the period, and the day count convention. Getting these wrong is the most common exam mistake.

Simple Interest (used for <1 year, money market): FV = PV x (1 + r x t) DF = 1 / (1 + r x t) where t = days / day_basis Compound Interest (used for >1 year, mortgage calculations): FV = PV x (1 + r)^n DF = 1 / (1 + r)^n where n = number of periods Day Count Fraction (Act/365): t = actual calendar days between dates / 365 Day Count Fraction (Act/360 - money market convention): t = actual calendar days between dates / 360
Convention matters: The same 1% rate gives slightly different results under Act/360 vs Act/365 vs 30/360. In RE finance, Act/365 is the standard. Always check which convention a problem specifies - the course's exercises explicitly state it.
REFM Exercise 1: Discount Factor Calculation S3 Exercise

from the course exercise set. Given:

RateDaysConventionBasist = days/basisDiscount Factor
1% (0.01)90SimpleAct/36590/365 = 0.246581/(1+0.01×0.24658) = 0.99754
2% (0.02)120SimpleAct/365120/365 = 0.328771/(1+0.02×0.32877) = 0.99343
Step-by-step for Rate=1%, 90 days, Act/365: Step 1: t = 90 / 365 = 0.246575 Step 2: 1 + r x t = 1 + 0.01 x 0.246575 = 1.002466 Step 3: DF = 1 / 1.002466 = 0.99754 Step-by-step for Rate=2%, 120 days, Act/365: Step 1: t = 120 / 365 = 0.328767 Step 2: 1 + r x t = 1 + 0.02 x 0.328767 = 1.006575 Step 3: DF = 1 / 1.006575 = 0.99343
REFM Exercise 2: Linear Interpolation of Interest Rates S3 Exercise

When you know rates for two tenors but need an intermediate rate, linear interpolation is the standard approximation. The assumption is that rates move linearly between observed points.

Linear Interpolation Formula: r(t) = r1 + (r2 - r1) x (t - t1) / (t2 - t1) REFM Exercise: Known r(90d) = 1%, r(120d) = 2%. Find r(100d): r(100) = 0.01 + (0.02 - 0.01) x (100 - 90) / (120 - 90) r(100) = 0.01 + 0.01 x 10/30 r(100) = 0.01 + 0.01 x 0.3333 r(100) = 0.01 + 0.003333 r(100) = 1.3333% (approx 1.33%)
📝
Exam technique: The formula is just proportional distance. At 100 days you are 1/3 of the way from 90d to 120d, so you take 1/3 of the rate difference (1%) and add to the base rate (1%). Quick mental check: 100d should give a rate between 1% and 2%, closer to 1% - 1.33% passes the sanity check.
📝 Class Notes - Session 03 (26 March 2026)
  • APR vs EAR: 6% APR compounded monthly = EAR of 6.17%. Mortgage convention: APR with monthly compounding. Bond convention varies (US semi-annual, EU annual).
  • Day count matters: Actual/360 (Euribor, USD LIBOR) vs Actual/365 (GBP) vs Actual/Actual (government bonds) vs 30/360 (EUR swaps). Conversion: R_new = R_old × (basis_old / basis_new). E.g., 4% actual/360 = 4.056% actual/365.
  • Mortgage amortization: PMT = P × [r(1+r)^n] / [(1+r)^n − 1]. Month 1 of a $300K/6%/30yr loan: $1,500 interest, $299 principal. Month 360: ~$8 interest, ~$1,791 principal.
  • Excel implementation: YEARFRAC and DAYS360 functions handle convention-specific calculations automatically.
🧠 Comprehension Check
A floating-rate loan references 3-month Euribor quoted on actual/360 basis at 3.50%. You need to use this rate in a model built on actual/365. What rate do you enter?
(a) 3.50% (no change needed)
(b) 3.549%
(c) 3.452%
(d) 3.60%
(b) is correct. Convert: 3.50% × (365/360) = 3.549%. The actual/365 basis has a larger denominator, so the rate must be slightly higher to produce the same cash result. Getting this wrong on a €50M loan changes interest by ~€24,500/year.

Yield Curve Analysis

Market Context
Yield Curve Shapes & What They Signal S3 Core

The yield curve plots interest rates (yields) against maturity. Its shape encodes market expectations about growth, inflation, and central bank policy:

ShapeShort vs LongMarket SignalRE Implication
Normal (upward)Short < LongGrowth expected, duration risk compensatedPositive carry on RE; financing cheap
InvertedShort > LongRecession expected; market pricing rate cutsRefinancing stress; values under pressure
FlatShort ≈ LongTransition; peak rates or early cut cycleRE repricing ongoing - 2023–24 situation
HumpedMid-term peaksNear-term rises then cuts expectedShort-term pain, medium-term opportunity
Critical RE Relationship The cap rate spread over risk-free rates (typically 10Y government bonds) is the most-watched RE pricing metric. When this spread compresses (2020–2021: ECB at 0%, prime office yields at 3.5%), RE appears expensive on a relative basis. When the spread widens (2022–23: ECB at 4.5%, yields sticky at 4%), values must fall to restore equilibrium - which is exactly what happened.

Three Compounding Types

Simple · Compound · Continuous
Compounding Factor Formulas: All Three Types S3 Core

Three compounding conventions exist in financial markets. The choice affects both future value calculation and the corresponding discount factor. The course's slide distinguishes all three explicitly.

Simple Interest (money market, <1 year): FV = PV × (1 + i × yf) DF = 1 / (1 + i × yf) Compound Interest (>1 year, mortgages, bonds): FV = PV × (1 + i)^yf DF = 1 / (1 + i)^yf Continuous Compounding (derivatives, fixed income): FV = PV × e^(i × yf) DF = e^(-i × yf) where: yf = days / basis (basis = 360 or 365 per convention) e = 2.71828... (Euler’s number)
TypeFV formulaUsed for€1M at 4% for 1yr
SimplePV × (1 + i × yf)T-bills, interbank money market€1,040,000
CompoundPV × (1 + i)^yfMortgages, RE loans, bonds€1,040,000 (same at exactly 1yr)
ContinuousPV × e^(i×yf)Options pricing, rate swaps€1,040,811 (slightly more)
📝
Exam tip: Differences between types are small for short periods but compound over time. In RE exams, unless stated otherwise, assume compound annual for valuation (NPV, IRR) and simple Act/360 or Act/365 for money market / short-term discount factor calculations.
Converting between types (same rate, different convention): i_compound = e^i_continuous - 1 i_continuous = ln(1 + i_compound) i_360 = i_365 × (360/365) i_365 = i_360 × (365/360)
📝 Class Notes - Session 03
  • Normal yield curve: longer maturities = higher yields (term premium for duration risk). Standard market expectation.
  • Inverted curve: longer maturities have LOWER yields. Historically signals recession within 12–18 months.
  • RE spread analysis: cap rates typically trade at 150–300 bps spread over corresponding Treasury yield. Spread compression in low-rate environments reduces cap rates and inflates values.
  • Three compounding types: Simple (money markets, <1 year), Compound (long-term RE), Continuous (derivatives only - Black-Scholes). Real estate finance primarily uses compound rates.
🧠 Comprehension Check
The 10-year German Bund yields 2.8% and a prime Berlin office trades at a 4.2% cap rate. What is the risk spread, and what would happen to the cap rate if the Bund yield rises to 3.8% (assuming constant spread)?
(a) Spread is 1.4%; cap rate rises to 5.2%, compressing property values
(b) Spread is 1.4%; cap rate stays at 4.2%
(c) Spread is 7.0%; no impact on cap rate
(d) Cannot determine without NOI
(a) is correct. Spread = 4.2% − 2.8% = 1.4% (140 bps). If spread stays constant and Bund rises to 3.8%, cap rate = 3.8% + 1.4% = 5.2%. For a property with €2M NOI: old value = 2M/0.042 = €47.6M; new value = 2M/0.052 = €38.5M. That is a 19% decline from a 100 bps rate move.

Present Value of Cash Flows

REFM Exercise 3
REFM Exercise 3: PV of Constant Cash Flows at Given YTM S3 Exercise

from the course exercise: given a series of annual future cash flows and a Yield to Maturity (YTM) of 4%, calculate present value. YTM assumes a flat yield curve - same discount rate applied to all maturities.

PV Formula (compound discounting, annual): PV = CF1/(1+YTM)^1 + CF2/(1+YTM)^2 + ... + CFn/(1+YTM)^n DF(t) = 1/(1+YTM)^t REFM Exercise: 5 annual flows of €500,000, YTM = 4%: Year 1: 500,000 / (1.04)^1 = 500,000 / 1.04000 = 480,769 Year 2: 500,000 / (1.04)^2 = 500,000 / 1.08160 = 462,278 Year 3: 500,000 / (1.04)^3 = 500,000 / 1.12486 = 444,498 Year 4: 500,000 / (1.04)^4 = 500,000 / 1.16986 = 427,402 Year 5: 500,000 / (1.04)^5 = 500,000 / 1.21665 = 410,963 ------- Total PV: 2,225,910
💡
RE context: This is the core of the Income Approach to RE valuation. A stream of net rental income discounted at the appropriate rate gives you the asset’s intrinsic value. The YTM here is analogous to the required rate of return (or “all risks yield”) used in RE valuation.

Discount Rate Architecture in RE

Risk Premium Framework
What Discount Rate Do You Use for RE? S3 Core

The discount rate applied to RE cash flows is not a single market rate - it is a stack of components. Every layer compensates for a different risk that the investor bears.

Nominal Discount Rate = Real Risk-Free Rate + Expected Inflation + Risk Premium RE Risk Premium decomposes into five sub-risks: 1. Business risk - unexpected drop in demand (vacancy, rent decline) 2. Financial risk - interest rate, liquidity, and leverage risk 3. Inflation risk - real purchasing power erosion beyond expectations 4. Liquidity risk - uncertainty of exit timing / price 5. Legal risk - zoning changes, rent controls, building codes, taxes
ComponentCurrent proxy (Apr 2026)RE implication
Real risk-free rate~0.5–1.0% (ECB estimate)Floor; compensation for pure time preference
Expected inflation~2.0% (ECB target; inflation swap)Preserves real value of future cash flows
RE risk premium2–5% depending on asset / marketPrime logistics ~2%; value-add office ~5%+
Total nominal rate~4.5–8% for RE investmentsThis is the IRR hurdle rate / discount rate
Inflation Curves & Forward Estimation The inflation swap market provides the best market-derived estimate of expected long-term inflation. In an inflation swap, one party pays a fixed rate and receives actual CPI growth. The fixed rate clearing the market IS the market’s inflation forecast. The course's Bloomberg slide shows EUR inflation swap rates running ~2.0–2.4% out to 50 years - consistent with ECB anchoring.
The Risk Curve Ladder: From Sovereign to Corporate S3 Core

Different borrowers and instruments carry different credit risk. This creates a ladder of yield curves - each curve sits above the previous by an amount reflecting the incremental probability of default (PD).

CurveRisk LevelRE RelevanceApprox spread over risk-free
Sovereign (AAA)Risk-freeReference rate; ECB, German Bund0 bps (IS the benchmark)
High-quality sovereignNear risk-freeSpain, France OAT - used for RE in those markets~50–150 bps (the “spread”)
Interbank (EURIBOR)Low credit riskFloating rate RE loans priced as EURIBOR + spread~80–120 bps
Corporate investment gradeModerateREIT bonds; corporate mortgage lenders~120–250 bps
Corporate high yield / mezzHighMezzanine RE debt; development finance400–800 bps
Valuation model choice: You need EITHER (A) a risk-free curve + explicit PD/LGD assumptions for the asset, OR (B) a risk-adjusted curve that already embeds the credit risk of that cash flow. Using a risk-free rate to discount risky RE cash flows without adding a risk premium will systematically overvalue the asset.
📝 Class Notes - Session 05 (7 April 2026)
  • IRR reinvestment assumption: The IRR implicitly assumes reinvestment of interim cash flows at the same IRR rate - generally not achievable in practice. Use cautiously as a standalone metric.
  • Annuity formula caveat: PV = C × [1−(1+r)^(−n)] / r applies ONLY when all cash flows are identical and a single discount rate is used. In most RE models, cash flows differ across years.
  • Discount rate for RE: Start with the sovereign bond yield matching the investment horizon (e.g., Spanish 30-year for a Madrid property), then add the RE risk premium (typically 3–6%).
Section 03 · 4 Sub-sections

Economic Factors

Discount functions, forward rates, FRAs, sovereign yield curves, cash flow structures, loan types, and the five-component real estate risk premium.

Discount FactorsForward RatesFRAsLoan TypesSessions 05 & 06

Section Map

Click any card to jump in
3.1

Discount Functions & Interpolation

Building discount functions from spot rates, linear interpolation technique, convention conversions

2 accordions · 1 class note
3.2

Forward Rates & FRAs

Forward rate derivation, synthetic replication, FRA conventions and hedging applications

1 accordion · 1 class note · 1 comp check
3.3

Cash Flows & Loan Structures

RE cash flow treatment, cap rate & exit value, perpetuities, bullet vs amortizing, PMT formula

4 accordions · 1 comp check
3.4

Lending Ratios & Sovereign Curves

Six RE lending ratios, eurozone yield curves, 5-component risk premium decomposition

1 accordion · 1 class note

Key Numbers

Session 04 - REFM Exercise Set
4%Spot rate (90 days) - REFM Ex.4
4.75%Spot rate (120 days) - REFM Ex.4
~6.5%Implied 30-day forward rate (90d to 120d)
3.75%Market cap rate in levered IRR exercise
4.25%Acquisition cap rate in IRR exercise
7%Target levered IRR (REFM exercise)

Discount Functions

Core Maths
Building a Discount Function from Spot Rates S4 Core

A discount function maps each future date to a discount factor (DF). It is the backbone of all cash flow valuation. DFs are derived from observable market rates (spot rates).

Discount Factor from Spot Rate (simple, Act/365): DF(t) = 1 / (1 + r_spot(t) x t) Discount Factor from Spot Rate (compound, annual): DF(t) = 1 / (1 + r_spot)^t Relationship between DF and Spot Rate: r_spot = (1/DF(t) - 1) / t (simple) r_spot = (1/DF(t))^(1/t) - 1 (compound)
RE Valuation Link In property valuation, the discount function is equivalent to constructing the set of discount rates applied to each year of projected rental income. A rising yield curve means future cash flows are discounted more heavily - reducing present value. This is why long-income assets (e.g., 25-year indexed leases) are extremely sensitive to rate moves.
📝 Class Notes - Session 05 (7 April 2026)
  • Discount factor = inverse of compounding factor: DF = 1 / (1 + r × YF) for simple interest. Always <1 for positive rates.
  • Linear interpolation: When a required maturity rate is not directly observable, interpolate between the two nearest available rates. Weight = (target − shorter) / (longer − shorter).
  • Converting between conventions: R_new = R_old × (basis_old / basis_new). Verify by confirming both produce the same future value.

Forward Rate Calculations

REFM Exercise 4
What Is a Forward Rate & Why It Matters S4 Core

A forward rate is the implied interest rate for a future period, derived from two observable spot rates. It represents the market’s expectation of the rate that will prevail between two future dates.

Forward Rate No-Arbitrage Condition (simple rates, Act/365): (1 + r1 x t1) x (1 + f(t1,t2) x (t2-t1)) = (1 + r2 x t2) Solving for the forward rate f(t1,t2): f(t1,t2) = [(1 + r2 x t2) / (1 + r1 x t1) - 1] / (t2 - t1) REFM Exercise 4: r(90d) = 4%, r(120d) = 4.75%, find f(90d,120d): t1 = 90/365 = 0.24658, t2 = 120/365 = 0.32877, t2-t1 = 30/365 = 0.08219 Numerator: (1 + 0.0475 x 0.32877) / (1 + 0.04 x 0.24658) - 1 = (1.015617) / (1.009863) - 1 = 1.006694 - 1 = 0.006694 f(90,120) = 0.006694 / 0.08219 = ~8.14% (annualised, Act/365)
Intuition check: The 30-day forward rate (8.14%) is much higher than either spot rate (4% and 4.75%). This makes sense - an upward-sloping curve implies the market expects rates to rise. The 90d-to-120d implied forward “bakes in” that expectation. A steeply upward-sloping curve creates high forward rates for near-term periods.
GivenValueInterpretation
r(90d) spot4.00%Lending today for 90 days costs 4%
r(120d) spot4.75%Lending today for 120 days costs 4.75%
f(90d,120d)~8.14%Implied rate for the period day 90 to day 120
📝 Class Notes - Session 06 (16 April 2026)
  • Forward rate formula: (1 + i_{0,2} × YF_{0,2}) = (1 + i_{0,1} × YF_{0,1}) × (1 + i_{1,2} × YF_{1,2}). Solve for i_{1,2}.
  • Example from class: 6-month Euribor = 2.36%, 12-month = 2.79%. Forward 6/12 = ~3.18% - higher than both spot rates because curve has positive slope.
  • Synthetic replication: Borrow 12 months, lend 6 months simultaneously. Eliminates interest rate risk AND liquidity risk. New risk introduced: credit risk on the 6-month counterparty.
  • FRA convention: ‘6/12 FRA’ = 6-month rate starting in 6 months. ‘9/12 FRA’ = 3-month rate starting in 9 months. FRAs hedge only rate risk (not liquidity risk).
  • When curve is positive: forward rates are always HIGHER than both spot rates they span - they are the time-weighted average pulling above the nearer spot.
🧠 Comprehension Check
The 6-month Euribor is 2.36% and the 12-month Euribor is 2.79% (both simple interest, actual/360). The 6/12 forward rate is approximately 3.18%. Why is the forward rate higher than both spot rates?
(a) Market error - arbitrage opportunity exists
(b) The 12-month rate is a time-weighted average of the 6-month spot and the 6/12 forward; since 2.79% exceeds 2.36%, the forward must pull above 2.79% to balance the equation
(c) Forward rates always equal the longer spot rate
(d) Central bank policy dictates forward rates
(b) is correct. The no-arbitrage condition requires: (1 + 2.79% × 1) = (1 + 2.36% × 0.5) × (1 + f × 0.5). The 12-month rate is the geometric average, so the forward must exceed 2.79% to compensate for the lower first-half rate. This is a mathematical necessity, not a market prediction.

Cash Flow Treatment for RE Valuation

Applied Framework
Structuring RE Cash Flows for Discounting S4 Applied

Before discounting, RE cash flows must be carefully structured. The key building blocks:

Cash Flow ComponentDefinitionTreatment
Gross Income (GI)Headline rent x lettable areaStarting point; inflate by rent review schedule
Vacancy / VoidEstimated unlet periods between leasesDeduct; typically 5–10% for stabilised assets
Effective Gross Income (EGI)GI minus vacancyEGI = GI x (1 - vacancy rate)
Operating Expenses (OPEX)Insurance, management, maintenance, ratesDeduct from EGI to get NOI
Net Operating Income (NOI)EGI minus OPEXCore valuation input; NOI / Cap Rate = Value
Capital Expenditure (CAPEX)Refurbishment, fit-out, major repairsShown separately below NOI; timing critical
Terminal Value (TV)Assumed sale at end of hold periodTV = NOI(final year) / Exit Cap Rate
Full DCF Structure for a 5-Year Hold: Year 0: -Purchase Price (outflow) Year 1: NOI1 - CAPEX1 Year 2: NOI2 - CAPEX2 Year 3: NOI3 - CAPEX3 Year 4: NOI4 - CAPEX4 Year 5: NOI5 - CAPEX5 + Terminal Value Terminal Value = NOI5 / Exit Cap Rate (or NOI6 / Exit Cap Rate) NPV = Sum of [CF(t) x DF(t)] = Sum of [CF(t) / (1+r)^t] IRR = r that makes NPV = 0
Cap Rate & Exit Value Mechanics S4 Core
Cap Rate (Capitalisation Rate): Cap Rate = NOI / Value (direct cap - entry or exit) Value = NOI / Cap Rate Exit cap rate vs. Entry cap rate: Entry cap rate: what you pay for today’s NOI on Day 1 Exit cap rate: what the market will pay for future NOI at sale REFM exercise context (IRR sheet): Market (exit) cap rate: 3.75% Acquisition cap rate: 4.25% Target levered IRR: 7% LTV: 65% bullet Financing rate: 4%
Value-Add Logic If you acquire at a 4.25% cap rate and grow NOI through active management or re-leasing, the asset re-prices at the market cap rate (3.75%) on exit. This cap rate compression - buying at a higher yield than you sell - is a core source of return in value-add strategies. Proyecto Helvetia takes a more extreme version: create value through conversion from offices to branded residences, then sell at luxury residential pricing.

Perpetuities

When Cash Flows Run Forever
Perpetuity Formula & Its Link to Cap Rate S4 Core

A perpetuity is a constant annual cash flow F that continues forever. Its present value converges to a finite number because each additional year’s PV shrinks geometrically.

Perpetuity Formula (derivation): V = F/r where F = constant annual flow, r = discount rate Derivation (limit of annuity formula as n → ∞): V = lim(n→∞) F/r × [(1+r)^n - 1] / (1+r)^n = F/r × lim(n→∞) [1 - 1/(1+r)^n] = F/r × 1 (since 1/(1+r)^n → 0) = F/r The course's Example: €1,000,000/yr at 3%: V = 1,000,000 / 0.03 = €33,333,333
Cap Rate IS a Perpetuity Rate The direct capitalisation formula used in RE valuation - Value = NOI / Cap Rate - is exactly the perpetuity formula (V = F/r) applied to real estate. The cap rate is the “r”, and stabilised NOI is the “F”. This is why a 5% cap rate on a property with €500k NOI gives a value of €10M. Understanding perpetuities is the mathematical foundation of income capitalisation.

Loan Types for Real Estate

Bullet · Amortising · Mezzanine
Bullet vs Amortising: Structure & Cash Flow Patterns S4 Core
FeatureBullet (Interest-Only)Amortising (French Method)
Principal repayment100% at maturity (balloon)Spread across each payment
Periodic paymentInterest only: P × r × yfConstant PMT covering I + P
Outstanding balanceUnchanged until maturityFalls each period
Total interest costHigher (no principal reduction)Lower (balance reduces)
Cash flow to borrowerHigher (lower payments)Lower (constant PMT)
RE use caseCommercial RE, investment funds, developmentResidential mortgages, long-term hold
Refinancing riskHigh - balloon at maturityLow - balance declines steadily
Bullet Loan - interest calculation: Monthly Interest = Principal × Annual Rate / 12 Total Interest = Monthly Interest × 12 × Years Principal repaid = Full amount at end of Year N REFM Example (Bullet): €800k, 3%, 20yr, monthly payments: Monthly interest = 800,000 × 3% / 12 = €2,000/month Annual interest = €24,000 Total interest over 20yr = €480,000 + €800,000 principal at Year 20
Why commercial RE loves bullet loans: A fund buying an office building expects to sell in 5–7 years. Bullet loans match this hold period - paying interest only keeps cash flows high during the hold, and the asset is sold to repay principal. Bullet loans expose lenders to refinancing risk, which is why LTV covenants and DSCR tests are central to commercial RE lending.
French Amortisation: The PMT Formula S4 Core

The most common residential mortgage method. Each payment is constant - but its split between interest and principal changes every period: early payments are mostly interest; late payments are mostly principal.

PMT Formula (constant periodic payment): PMT = [Rate/m × N × (1 + Rate/m)^(n×m)] / [(1 + Rate/m)^(n×m) − 1] where: Rate = annual interest rate n = number of years m = payments per year (12 = monthly) Outstanding Balance at any point: N_t = PMT × [1 − (1 + Rate/m)^−(n×m - t)] / (Rate/m) REFM Example: €100,000, 4% fixed, 20yr, monthly: Monthly rate = 4%/12 = 0.3333% n×m = 240 periods PMT = (0.003333 × 100,000 × 1.003333^240) / (1.003333^240 − 1) PMT = €605.98 per month Excel Functions: PMT(rate/m, n×m, -PV) → constant payment PPMT(rate/m, period, n×m, -PV) → principal portion of payment t IPMT(rate/m, period, n×m, -PV) → interest portion of payment t
💡
Key pattern to remember: In early payments, interest dominates (balance is high → more interest). As balance falls, interest shrinks and principal grows - but PMT stays constant. This is why the amortization schedule chart (slide p.39) shows a stacked bar where the red interest portion shrinks and blue principal grows over the loan life. Work through the numbers manually to verify.
🧠 Comprehension Check
A bullet loan of €40.9M at 4% annual interest over 11 years: what is the total interest paid? Compare with an amortizing loan at the same rate (PMT = €4.60M/year, total repaid = €51.3M).
(a) Bullet: €18.0M interest; Amortizing: €10.4M - amortizing is cheaper
(b) Both pay the same total interest
(c) Bullet: €10.4M; Amortizing: €18.0M
(d) Cannot determine without knowing NOI
(a) is correct. Bullet: annual interest = 40.9M × 4% = €1.636M × 11 years = €18.0M total interest, plus €40.9M principal at maturity = €58.9M total. Amortizing: total repaid = €4.60M × 11 = €50.6M, so interest = 50.6M − 40.9M = €9.7M. The amortizing loan costs ~€8.3M less in total interest because principal reduces each year, shrinking the interest base.

Lending Ratios: The Lender’s Toolkit

DTI · LTV · DSCR · Effort Rate
Six Ratios Every RE Lender Uses S4 Core
RatioFormulaTypical thresholdWhat it measures
Debt-to-Income (DTI)Monthly debt payments / Monthly gross income< 40–45%Personal affordability; can this borrower service total debt?
Effort Rate (ER)Housing expenses / Pre-tax income≤ 30–35%Mortgage-specific affordability; standard bank test in Spain/EU
Loan-to-Value (LTV)Loan amount / Property value≤ 70–80%Collateral coverage; how much equity cushion the lender has
Debt-to-Equity (DTE)Total liabilities / Shareholders’ equity< 2×Capital structure leverage for RE companies / developers
Working Capital (WC)Current assets / Current liabilities> 1.0×Short-term liquidity; can the entity meet near-term obligations?
DSCREBITDA / (Interest + Principal)≥ 1.20–1.25×Can operating income cover all debt service? Core commercial RE test
REFM Exercise: Effort Rate salary check: Given: Amortising loan €800k, 3%, 20yr → PMT = €3,628/month Effort Rate threshold: 35% Required monthly gross salary = €3,628 / 35% = €10,366/month Required annual gross salary = €124,389/year DSCR interpretation for commercial RE: DSCR = 1.0× → NOI exactly covers debt service (no margin) DSCR = 1.2× → 20% headroom (standard minimum for lenders) DSCR = 1.5× → Comfortable; lender will offer better pricing DSCR < 1.0× → Debt service exceeds income: covenant breach / default risk
DSCR in the S&L Exercise In the REFM Sale & Leaseback case (40,000m² retail, $25/m² NNN, 6.25% cap, 70% LTV), the Year 1 DSCR sits around 1.4× - comfortably above the 1.2× minimum. As rent steps up every 5 years (+5%), DSCR improves further. A deteriorating DSCR (e.g., vacancy, rate reset on floating debt) is the primary early-warning signal in commercial RE credit monitoring.
📝 Class Notes - Session 06 (16 April 2026)
  • No single ‘euro curve’: Each eurozone sovereign has its own yield curve. Germany = lowest (reference risk-free). Spain higher. France has widened recently due to political/fiscal concerns.
  • For a Spanish RE project: start with Spanish sovereign curve (not German), then add RE risk premium.
  • Five components of RE risk premium: business risk (value appreciation/depreciation), financial risk (leverage), inflation risk (rent vs inflation mismatch), liquidity risk (illiquidity of RE), legal risk (title, regulatory, tenure).
  • Corporate credit curves sit above sovereign curves: spread between German Bund and Spanish HY corporate = multiple layers of risk premium (country + credit + liquidity).
Section 04 · 6 Sub-sections

RE Economics

Demand elasticity, housing affordability, supply dynamics, stock-flow models, construction cycles, price adjustments, and market equilibrium.

DemandSupplyElasticityStock-FlowProperty Clock

Section Map

Click any card to jump in
4.1

Demand Framework

Space vs asset market demand, demand elasticity by sector, endogenous & exogenous determinants

3 sections · Key Numbers
4.2

Affordability & Amplification

Demand amplifiers (credit, expectations, foreign capital), HAI, effort rates, bubbles

2 sections · 1 comp check
4.3

Residential Cycle & Absorption

Demand cycle dynamics, current vs expected prices, gross & net absorption

2 sections
4.4

Supply Framework

Supply elasticity, exogenous determinants, development feasibility, new construction profile

3 sections · Key Numbers
4.5

Stock-Flow & Construction

Stock-flow identity, Pmin threshold, developer expectations (adaptive, rational, myopic)

2 sections
4.6

Price Adjustments & Equilibrium

Short-run vs long-run adjustment, vacancy, disequilibrium measures, property clock

2 sections · 1 comp check

Key Numbers

Session 05
+5%Canada real house price growth p.a. since 2016
3.5MCanada housing shortage (CMHC estimate)
500kHomes Canada needs per year; builds only 150–250k
60%Singapore stamp duty surcharge on foreign buyers (2013)
30–35%Effort rate: standard lender affordability threshold
2003Year Shiller warned US prices were out of whack with incomes

RE Demand Framework

Core Theory
Space Market vs Asset Market Demand S5 Core

RE demand operates on two distinct levels that are tightly linked but driven by different actors:

MarketWhat Is DemandedPrice SignalWho Drives It
Space MarketPhysical space - sqm of offices, apartments, warehousesRental rate (rent/sqm/yr)Occupiers: firms, households, logistics operators
Asset MarketOwnership of property as an investment vehicleCapital value (price/sqm)Investors: funds, REITs, private individuals
The Critical Link Asset value = Rental income / Cap Rate. Rising rents in the space market flow through to rising values in the asset market. But changes in capital markets (rising interest rates → rising cap rates) can crush asset values even when rents are flat or growing. Understanding this decoupling is essential for the exam and for Proyecto Helvetia analysis.
Demand Elasticity by Sector S5 Core
Price Elasticity of Demand (PED): PED = % change in quantity demanded / % change in price If |PED| < 1: Inelastic → price rises cause small drop in demand If |PED| > 1: Elastic → price rises cause large drop in demand Income Elasticity of Demand (IED): IED = % change in quantity demanded / % change in income Normal good: IED > 0 (RE is a normal good - demand rises with income) Luxury good: IED > 1 (branded residences, prime RE - income-sensitive)
SectorPrice ElasticityReason
Primary residentialInelasticHouseholds must live somewhere; limited substitutes; location-locked
Investment residentialMore elasticDiscretionary; investors are yield-sensitive; can park capital elsewhere
OfficeModerateFirms can reduce sqm, go hybrid, or sublease; long leases limit short-run response
LogisticsInelasticOperational necessity; e-commerce is structural; very few substitutes for prime last-mile
RetailElasticE-commerce substitution; non-food retail is discretionary for occupiers
💡
Why inelasticity drives crises: Inelastic demand means price spikes when supply is constrained. This is the structural reason residential prices in Madrid, London, Amsterdam, and most EU capitals have risen so dramatically - supply is restricted by planning and geography while demand is inelastic.

Demand Determinants

Endogenous & Exogenous
Endogenous Demand Determinants (Asset-Level Factors) S5 Core

Endogenous factors are internal to the asset or local market - things a developer, landlord, or asset manager can influence:

FactorImpact on DemandCourse Example
Location qualityPrimary driver of RE demand; location determines access to employment, amenities, transportHelvetia’s position between Barrio Salamanca, Justicia & Four Seasons
Asset quality / specificationHigher spec = premium demand; obsolete spec = structural vacancyGrade A vs. EPC-F heritage building; branded vs. standard residences
Price / rent levelDemand moves inversely with price (along the demand curve)Helvetia: €17,500–28,875/sqm price range vs. mass market €5,000/sqm
Lease flexibilityShorter, flexible leases increase occupier demand post-COVIDCo-working vs. traditional 10-year FRI; hybrid working normalised
Amenities & servicesStrong demand driver, especially luxury residential and prime officeHelvetia: spa, indoor pool, gym, cinema, cigar bar, private garden
Exogenous Demand Determinants (Macro Forces) Slide p.35

Exogenous determinants are outside any individual asset - macro forces that shift the entire demand curve left or right. These appear directly in the course's slide p.35:

#Demand DriverMechanismRE Impact
1Market sizePopulation growth, demographics, urbanisationMore households → more housing demand; ageing pop → healthcare RE; immigration → rental demand
2Income / wealthGDP growth, wage growth, wealth accumulationHigher income → larger homes, better locations, second properties, branded residences
3Substitute pricesCost of alternatives - renting vs. buying; bond yields vs. property yieldsWhen rates rise, bonds become attractive vs. RE → cap rate spread narrows → values fall
4ExpectationsPrice expectations, economic outlook, fear of missing out (FOMO)Positive expectations → demand surge; negative → demand freeze. Works both ways and is self-reinforcing
Exam tip: The same table on slide p.35 lists supply drivers opposite demand drivers. Expectations appears on BOTH the demand AND supply side - the only factor that moves both curves simultaneously. This makes it the single most powerful force in RE cycle amplification.

Demand Amplification & Bubbles

IMF Analysis
Why Demand Gets Amplified Beyond Fundamentals IMF F&D Dec 2024

Housing is different from other goods in two ways that create systemic amplification:

AmplifierHow It WorksHistorical Example
Price expectationsFOMO drives buyers to purchase at high prices on belief tomorrow will be higher. Robert Shiller (Nobel 2013): bubbles form from self-reinforcing narratives amplified by word of mouth.US subprime 2003–06; Spain 2000–07; Marbella 2021–present
Credit availabilityLooser mortgages → more buyers → higher prices → higher collateral → banks lend more. Self-reinforcing spiral. Breaks suddenly when collateral values fall.GFC 2008; Spanish Cajas 2006–08
Foreign capital flowsInternational investors seeking yield or safe-haven assets boost demand in target cities. Often use cash - bypass local lending regulations entirely.London prime; Miami; Madrid (Latin American buyers)
IMF Policy Toolkit (F&D Dec 2024) Regulators have three levers: (1) Microprudential - risk-weighting of mortgage assets, capital requirements; (2) Macroprudential - debt-service-to-income limits, LTV caps; (3) Monetary policy - rate hikes (blunt instrument, affects whole economy). For cash-rich foreign buyers: stamp duty surcharges (Singapore 60%, Canada/NZ: purchase bans). Fundamental solution: build more homes.
The Four Quadrant Model: Demand in Motion S5 Applied

The DiPasquale–Wheaton Four Quadrant model shows how a demand shock flows through both the space and asset markets:

Demand Shock Transmission Through the Four Quadrants
Q1: SPACE MARKET Rent & Occupancy Q2: ASSET MARKET Property Prices Q4: STOCK ADJUSTMENT Depreciation & Net Stock Q3: CONSTRUCTION New Supply Starts Demand ↑ → Vacancy falls Rents rise to clear market Rent = f(Stock, Demand) Higher rent → higher value Value = Rent / Cap Rate Cap Rate = f(interest rates, risk) New builds added to stock Old stock depreciates Long-run equilibrium stock Value > Replacement cost → Profitable to build Construction starts lag 2–5 yrs 2–5 year construction lag creates cyclical over/undershoot

Housing Affordability & Effort Rates

The course Deck p.9–14
The HAI (Housing Affordability Index) Deck p.10–11

The HAI measures whether a family earning the median income can qualify for a mortgage on a median-priced home. It is a single number that captures the interplay of income, prices, and financing conditions.

Housing Affordability Index: HAI = (MEDINC / QINC) × 100 MEDINC = Median family income QINC = Qualifying income (income needed to get a mortgage on a median-priced home) Interpretation: HAI = 100 → Median family has exactly enough income to qualify HAI > 100 → Median family has more than enough to qualify HAI < 100 → Median family cannot qualify for a mortgage Assumes 20% down payment (80% LTV), 30-year maturity
2020–2025 collapse: US mortgage payments on median homes more than doubled from 2020 to mid-2025. For a first-time buyer with 3.5% down, monthly costs went from $1,200 to over $2,500. The annual income required nearly doubled from under $70,000 to over $130,000 - excluding millions of potential buyers from the market.
Five Factors of Housing Affordability Deck p.9

The course identifies five variables that jointly determine whether housing is accessible:

#FactorEffect on AffordabilityDirection
1IncomeHigher income → more households can afford to buy↑ Income = ↑ Affordability
2Interest ratesLower rates → lower monthly payments → more buyers qualify↓ Rates = ↑ Affordability
3Amortisation timeLonger terms → lower monthly payment → more buyers qualify↑ Term = ↑ Affordability
4PriceLower prices → smaller loan needed → easier to qualify↓ Price = ↑ Affordability
5LTVHigher LTV → less equity needed upfront, but larger loan → higher monthly paymentMixed effect
💡
Spain 2008–2010: Price dropped dramatically (improving affordability) while LTV and rates also shifted. The course chart on slide p.9 shows these components can move in opposite directions, with price being the dominant force during the crisis.
Effort Rates Across European Cities Deck p.12

The effort rate measures what proportion of net salary goes to housing (rent or mortgage). Standard lender threshold is 30–35%.

CityAvg RentNet SalaryRent EffortAvg PriceMortg. PmtBuy Effort
London€2,500€3,20078%€700k€3,836120%
Paris€1,800€2,50072%€550k€2,576103%
Barcelona€1,300€1,80072%€400k€1,919107%
Madrid€1,300€1,95067%€420k€2,014103%
Amsterdam€2,000€3,00067%€550k€2,47666%
Berlin€1,400€2,60054%€450k€2,16064%
Vienna€1,100€2,70041%€375k€1,68043%
Helsinki€1,200€3,50034%€350k€1,62539%
Madrid in Context Madrid’s rent effort (67%) and buy effort (103%) both exceed the standard 30–35% lender threshold by a wide margin. A buy effort above 100% means the median earner literally cannot cover a mortgage payment from salary alone - requiring savings, dual incomes, or family help. This directly connects to Proyecto Helvetia’s target market: ultra-high-net-worth buyers for whom affordability is not a constraint.
🧠 Comprehension Check
A city has median household income of €45,000 and median home price of €360,000. Mortgage rate is 4%, 30-year term. The HAI threshold is 25% of gross income. Can the median household afford the median home?
(a) Yes - monthly payment is within 25% of income
(b) No - monthly payment exceeds 25% of gross monthly income
(c) Need more data on down payment
(d) HAI is not relevant to this calculation
(b) is correct. Monthly payment on €360K at 4%/30yr = PMT(0.04/12, 360, 360000) = ~€1,719. Monthly gross income = €45,000/12 = €3,750. Effort rate = 1,719/3,750 = 45.8%, far exceeding the 25% threshold. The median household cannot afford the median home - this is the affordability crisis in numbers.

Residential Demand Cycle

The course Deck p.8
Dynamics of the Residential RE Demand Cycle Deck p.8

The course's flowchart (deck p.8) breaks housing demand into two streams, each with distinct financing drivers:

Primary Demand & Replacement Demand Flow
Housing Demand Primary Demand Population / Households Rental Buy Financial Position / Accessibility Proprietary Funds (Savings rate + RE wealth) External Financing (Credit supply, DTI, LTV, Rates) Replacement Demand Move up the housing “ladder” Life-cycle needs + buy-to-rent KEY DRIVERS & CONNECTIONS Savings rate = f(labour stability, income) → labour market depends on GDP growth External financing = banks’ appetite to lend (LTV) vs households’ appetite for leverage (DTI) Replacement buyers: own RE assets are much more relevant (RE wealth as savings); higher stability Housing prices: the rent-vs-buy decision is based on financial capacity relative to prices Interest rates & LTV are the main variables in mortgage credit standards (*) Replacement demand follows same financing flowchart as primary demand
Current & Expected Prices: Shift vs Movement Deck p.15

A common confusion: seeing demand rise during rising prices seems to violate the law of demand. It doesn’t.

Movement Along vs Shift Of the Demand Curve A movement along the demand curve happens when the price of the good itself changes - quantity demanded changes but the curve stays put. A shift of the demand curve happens when an exogenous factor changes (like expectations of future price increases). The demand increases not because prices rose, but because buyers expect prices to rise further - FOMO pushes the entire curve to the right.
📝
Exam distinction: Current prices and rents are endogenous determinants (movement along the curve). Expected future price changes are exogenous determinants (shift of the curve). This is a classic MCQ trap - the course highlights it explicitly on slide p.15–16.

Measuring Changes in Demand

The course Deck p.23–24
Gross Absorption vs Net Absorption Deck p.23–24
Gross Absorption (GA): GA₀ = Σ Sᵢ (i = 1 to n) Total space involved in ALL leases signed during a period. Not a good measure of marginal demand changes - it counts tenant movements between buildings, not net new demand. Net Absorption (AB): AB₀ = OS₀ − OS₀₋₁ Where: OS₀ = S₀ × (1 − V₀) S = total stock (occupied + vacant) V = vacancy rate OS = occupied space Interpretation: AB > 0 → Demand strong, more space occupied than vacated AB < 0 → More space vacated than occupied → weak demand or oversupply
MeasureWhat It CapturesLimitation
Gross AbsorptionTotal leasing activity (all new leases)Includes tenant churn - a tenant moving from Building A to Building B shows as absorption in B but doesn’t increase aggregate demand
Net AbsorptionNet change in occupied spaceBetter measure of marginal demand, but doesn’t distinguish between demand types or quality
Ex-Ante vs Ex-Post Demand Deck p.4

Two demand concepts that matter especially when supply is constrained:

ConceptDefinitionWhy It Matters
Ex-ante demandThe aggregate desired quantity before consumers interact with the marketplaceRepresents what people would want at given prices in an unconstrained world
Ex-post demandThe realised demand after interacting with the marketplaceMay differ from ex-ante due to supply constraints, rationing, or search costs
💡
Practical example: In Madrid, ex-ante demand for affordable apartments may be 50,000 units, but ex-post demand (actual transactions) is only 25,000 because supply simply doesn’t exist. The gap is unmet demand - the fuel for price inflation. Embedded in the demand definition is the concept of effective market demand: demand that is backed by actual purchasing power.

Key Numbers

Session 06
2–5 yrsTypical planning-to-delivery lag for new RE development
20 moHelvetia: permitting period before construction can start
24 moHelvetia: construction period after permits granted
8,000New homes per year in Marbella (constrained supply)
400k+New homes per year planned in Dubai (oversupply risk)
~60%Reduction in embodied carbon via RE rehabilitation vs. demolition

RE Supply Framework

Core Theory
Supply Elasticity: Why RE Supply Is Structurally Slow S6 Core

Unlike manufactured goods, you cannot simply “produce more” real estate quickly when prices rise. Supply elasticity in RE is determined by:

ConstraintEffect on Supply ElasticityExample
Planning & permittingMajor constraint - months to yearsHelvetia: 20-month permitting period. Spain’s residential permits take 1–3 years in major cities
Construction timeFixed lag - cannot be compressed below ~12–18 monthsHelvetia: 24 months construction. Large mixed-use: 4–6 years
Land availabilityAbsolute constraint in prime locationsNo more land in Madrid CBD, central London, Amsterdam centrum
Capital availabilityCyclical - tightens exactly when you need it most (downturns)GFC: construction lending froze 2008–10. Supply collapsed. Demand recovered first.
Labour & materialsModerate constraint - inflation risk in construction boom phasesPost-COVID: construction cost inflation +20–30% in Europe 2021–22
Zoning & land useRestricts density, limits conversionsHelvetia: converting offices to residential requires rezoning - key project risk
📝
Core exam point: Supply elasticity is LOW in RE, meaning supply responds slowly and incompletely to price signals. This is why markets over-correct: by the time new supply arrives (2–5 years after the demand signal), the market conditions may have completely changed. This lag is the engine of RE boom-bust cycles.
Exogenous Supply Determinants Slide p.35

from the course slide p.35 - the four exogenous supply drivers (parallel to demand drivers):

#Supply DriverMechanismDirection of Effect
1Capital & labour costsHigher construction costs reduce supply viability; lower costs stimulate developmentCosts ↑ → Supply ↓
2Land valueHigher land prices increase project break-even; constrain development in prime areasLand ↑ → New supply ↓ (but rehab ↑)
3Material costsSteel, cement, timber price volatility directly impacts development feasibilityMaterials ↑ → GDV margin ↓
4ExpectationsDeveloper confidence in future sale prices and rents drives or freezes development startsPositive → Supply ↑ (and vice versa)

New Construction Profile

Development Economics
The Development Feasibility Threshold S6 Applied

New supply only comes forward when the market price exceeds the total cost of delivering new space. This threshold is called the replacement cost in the Four Quadrant model:

Development Feasibility Condition: GDV (Gross Development Value) > Total Development Cost GDV = Expected sale price or capitalised rental income TDC = Land + Construction (hard & soft costs) + Finance + Fees + Profit Gross Development Value (GDV): GDV = NOI / Cap Rate (income-producing assets) GDV = Units × Price/unit (residential for sale) Developer’s Profit Margin: Profit = GDV − TDC Profit % = (GDV − TDC) / TDC × 100 Helvetia Example: GDV (Net Sales): €237.9M All-in cost: €156.8M Gross profit: €81.1M Gross margin: 32.2%
Why Supply Collapses in Downturns When values fall (cap rates rise or prices drop), GDV falls below TDC - development becomes unprofitable. Developers stop building. Supply collapses exactly when demand is also falling. The resulting supply shortage then sets up the next cycle: when demand recovers, there is no new stock, so prices spike again.
New Construction Profile: Phases & Key Decisions S6 Core
PhaseActivityTypical DurationKey Risk
Site acquisitionPurchase or option on land; due diligence on planning, legal, environmental1–6 monthsOverpaying for land; hidden contamination; legal encumbrances
Planning & designObtain planning permission, design development, technical studies6–24 monthsPlanning refusal; heritage restrictions; neighbour objections
Finance & pre-salesSecure construction loan, pre-sell units (residential) or sign anchor tenant (commercial)3–12 monthsCredit conditions change; pre-sales fall short of lender threshold
ConstructionGround-break through to practical completion12–36 monthsCost overruns, contractor insolvency, material delays
Sales / lease-upMarketing, negotiation, completion of sales or letting6–24 monthsMarket softens; absorption slower than forecast; pricing pressure
💡
Helvetia timeline (Slide p.26): NBO Nov 2023 → Closing Jun 2024 → Permitting (20 months) → Construction start Month 21 → Commercialisation from Month 9 → Delivery Month 47 → Exit 2028. Total: 3.9-year hold. Every phase has a specific risk profile that maps to the risk phases diagram from Session 1.
Supply vs Demand: The Marbella–Dubai Contrast Slide p.37

The course's slides use this contrast explicitly to illustrate what happens when supply dynamics differ radically in two otherwise similar luxury markets:

FactorMarbellaDubaiImplication
New supply pipeline≈8,000 homes/yr (low)400,000+ by 2030Marbella: supply constraint preserves values. Dubai: oversupply risk.
10-year appreciation+105%+ (stable)Cyclical - confirmed bubbleStable supply → stable appreciation. Boom-bust vs. steady growth.
UBS Bubble IndexNot flagged5th highest globallyExcess supply a leading bubble indicator
10-yr price growth 2025+9.8–13.8% YoY+13%, now slowingDubai slowing as supply hits market

Stock-Flow Identity & New Construction

The course Deck p.28–31
The Stock-Flow Identity Deck p.28

How the total RE stock evolves over time - one of the most important equations in RE economics:

Stock-Flow Identity: S₀ = S₀₋₁ × (1 − d) + C₀ Alternative form using permits: S₀ = S₀₋₁ × (1 − d) + a × PRM₀₋₁ Where: S₀ = real estate stock at time t d = depreciation rate C₀ = space completed at time t PRM = space permitted at time t−n a = percent of permits actually completed n = time between permit issuance and project completion
Depreciation TypeDefinitionExample
PhysicalPhysical aging and deterioration of the buildingRoof leaks, façade degradation, structural wear
FunctionalObsolescence compared to new buildings that provide services more efficientlyNo fibre broadband, poor HVAC, inefficient floor plates, no EV charging
EconomicExternal or environmental factors that negatively affect income-earning capacityNeighbourhood decline, new motorway noise, regulatory changes, flood risk reclassification
New Construction Behaviour & Pmin Threshold Deck p.29–31
New Construction Supply Function: Qₛ = c + dP Pmin Threshold: Below Pmin, developers cannot cover development costs + reasonable profit. No space will be developed when P < Pmin Supply Elasticity (ES): ES = (ΔQ / Q) ÷ (ΔP / P) ES > 1 → supply is price elastic ES < 1 → supply is price inelastic ES = 1 → supply is unit elastic New construction is on average very price elastic (ES >>> 1) This is especially true in office markets where development is “lumpy”
💡
Short-run vs long-run supply: In the short-run, RE stock is completely fixed (vertical supply curve) due to construction lags. Residential: 12–18 months minimum. Retail/office: 18–24 months minimum. This short-run price inelasticity is why demand shocks cause large price spikes - supply literally cannot respond.

Construction Expectations

The course Deck p.34
Three Types of Developer Expectations Deck p.34

How developers form expectations about future prices is critical to understanding supply cycles:

TypeFormulaMeaningImplication
MyopicP̂₀₊₁ = P₀Current prices/trends will continue unchangedLeads to oversupply in booms and undersupply in busts
AdaptiveP̂₀₊₁ = P₀ + dApply an adjustment (d) to current values based on past mistakesBetter than myopic but still backward-looking
RationalP̂₀₊₁ = P₀₊₁Use all available info to correctly predict market response to shocksTheoretically optimal - rarely observed in practice
The Myopic Reality Empirical evidence consistently shows RE investors and developers form expectations myopically. They see rising rents today and assume they will continue - so they start building. By the time the new stock arrives (2–5 years later), the market may have turned. This myopic behaviour is the engine of the boom-bust cycle in RE: build during booms (when you shouldn’t) and freeze during busts (when you should).

Price Adjustments & Equilibrium

The course Deck p.35–42
RE Price Adjustments: Short-Run vs Long-Run Deck p.36–37

RE prices are determined by the intersection of supply and demand where QD = QS. But the speed of adjustment differs radically between the short and long run.

TimeframeSupply CurvePrice Impact of Demand ShockWhy
Short-runVertical (perfectly inelastic)Large price increaseStock is fixed - no new buildings can appear instantly. All adjustment happens through price.
Long-runUpward-sloping (elastic)Moderate price increaseDevelopers have time to respond by building new units. Price increase is partially absorbed by new supply.
💡
Example (Deck p.37): Massive immigration into a city shifts demand right. In the short-run, prices spike because the housing stock is fixed. In the long-run, developers build new units, supply increases, and prices moderate - but never fully return to the original level because the long-run supply curve is upward-sloping (building costs more at higher quantities).
The Stock-Flow Model Deck p.38–39

The most powerful analytical tool for tracing how RE markets adjust over time. The course presents this as a four-equation system:

Stock-Flow Model - 4 Equations: D₀ = f(POP₀, I₀, R₀) Demand = f(population, income, rents) C₀ = f(R₀₋₁, c₀₋₁, X₀₋₁) Completions = f(lagged rents, cost of capital, shifters) R₀ = f(POP₀, I₀, S₀) Rents = f(population, income, stock) S₀ = S₀₋₁(1 − δ) + C₀ Stock = previous stock minus depreciation plus completions Equilibrium Conditions (all three must hold simultaneously): D₀ = S₀ Demand equals supply ΔS₀ = 0 No change in stock (new construction = depreciation) ΔR₀ = 0 No change in rents
Stock-Flow Cycle: Demand Shock Transmission
Demand increases Landlords raise rents Developers plan more (myopic expectations) Stock increases Rents fall Developers reduce supply (myopic) → stock falls → rents recover → cycle repeats This cycle converges to equilibrium over time - but very slowly due to construction lags

Measuring Disequilibrium

The course Deck p.40–45
Three Measures of Market Disequilibrium Deck p.40–42
MeasureFormula / DefinitionInterpretationLimitation
C − ABCompletions minus Net AbsorptionPositive & increasing = trouble (vacant stock rising). Historically, rising C−AB signalled crises.Shows trends in vacant stock levels, not vacancy rates. A growing market can absorb high completions.
Nominal Vacancy RateVacant stock / Total stockHigher vacancy = weaker market. Used to infer likely rent movements.Doesn’t indicate the extent of disequilibrium - no benchmark to compare against.
V₀ vs V*Nominal vacancy (V₀) compared to Structural vacancy (V*)V₀ > V* → market oversupplied, rents will fall. V₀ < V* → market tight, rents will rise.V* itself is unobservable - must be estimated or inferred from long-run averages.
Structural Vacancy Rate (V*) The structural vacancy rate is the portion of stock that is desirable to keep vacant for two reasons: (1) Owner profit-maximisation - the marginal benefit of keeping a unit vacant (holding out for a better tenant/higher rent) exceeds the marginal cost. (2) Tenant search facilitation - at any time, firms and households are searching for space, and some vacant stock must exist to accommodate that search. V* is not zero - a “healthy” market always has some vacancy.
Why RE Markets Stay in Disequilibrium Deck p.46

RE price adjustments are very slow due to three structural inefficiencies:

FactorMechanismTime Impact
Information inefficienciesRE markets lack centralised exchanges. Price discovery is slow, opaque, and transaction-based.Weeks to months for price signals to propagate
Long-term rental contractsCommercial leases of 5–15 years lock rents; demand and rental adjustments are delayed until break/renewal.Years of sticky rents even when market conditions change
Construction lags12–24 months minimum from decision to delivery. Cannot accelerate or cancel easily once committed.Supply responds 2–5 years after the demand signal
📝
Exam takeaway: Due to frequent exogenous demand shocks and slow adjustment, RE markets are in disequilibrium more often than not. This is the fundamental reason RE cycles exist - and why analysts use the stock-flow model, C−AB analysis, and vacancy rate trends to gauge where in the cycle a market sits.
RE Market Impact on the Economy Deck p.47

The course closes the economics deck with two feedback loops showing how unaffordable housing damages the broader economy:

Loop 1: Affordability → Economic Drag Expensive housing → less disposable income to consume → slower GDP growth. Less immigration (can’t afford to move) → less labour → less growth. Expensive housing → reduced labour mobility (workers can’t relocate for jobs). Less labour → construction costs rise → housing gets even more expensive. A self-reinforcing negative spiral.
Loop 2: Tourism & Housing (Airbnb Effect) Expensive housing → owners convert units into short-term tourism rentals (higher yield). More tourism assets → fewer residential units available. Fewer residential units → housing becomes even more expensive. Another self-reinforcing loop - directly relevant to Madrid, Barcelona, Lisbon, and other European tourism cities in the course.
🧠 Comprehension Check
A market has: natural vacancy rate = 5%, current vacancy = 2%, positive net absorption, and construction starts accelerating. Which RE cycle phase is this, and what should a developer do?
(a) Recession - stop all development
(b) Expansion - vacancy below natural rate signals strong demand; developer should start construction but model delivery into potential Hypersupply
(c) Recovery - too early to build
(d) Hypersupply - vacancy is artificially low
(b) is correct. Current vacancy (2%) below natural vacancy (5%) with positive absorption = Expansion phase. Rents are likely rising, occupancy is strong. However, the construction lag means a project started now delivers in 2–4 years. The developer must model whether cumulative new supply will push vacancy above the natural rate by delivery - if yes, they are building into Hypersupply.
Section 05 · 6 Sub-sections

RE Valuation

Six valuation methodologies, DCF modelling, financial products, capital markets, and levered IRR.

DCFCap RatesS&LBREITsSessions 08, 09 & 11

Section Map

Click any card to jump in
5.1

Purpose & Types of Value

Why valuation, value types, RICS/ECO/AVM standards

Class note · 5 accordions
5.2

Methodologies Overview

Four approaches, method × asset matrix, choosing the right method

Comp check · 4 accordions
5.3

DCF Methodology

NOI projection, residual value, discount rate, IRR vs CAGR, worked examples

Class note · comp check
5.4

Capitalisation & Other Methods

Term & reversion, hard core/top slice, residual, replacement cost, comparison

Deep-dive accordions
5.5

Financial Products

Mortgages, MBS/ABS, covered bonds, S&LB, lease types (gross/net/NNN)

Class note · 4 accordions
5.6

Capital Markets & Levered IRR

REITs, PE strategies, four channels, IRR analysis, investment decisions

Class note · comp check

Purpose & Types of Valuation

Foundation
What Is a Valuation & When Is One Needed? S7 Core

A valuation is an estimate of the economic value of a real estate asset at a specific point in time. It is not the same as price (what was paid) or cost (what it cost to build).

PurposeWho Requires ItStandard Applied
Mortgage security / loan underwritingBanks, debt fundsRICS Red Book Market Value
Investment acquisition / disposalFunds, REITs, private investorsRICS Red Book / local standards
Financial reporting (balance sheet)Listed companies, REITsIFRS 13 Fair Value
Tax purposes (inheritance, transfer)Tax authoritiesRegulatory / cadastral value
InsuranceAsset owners, banksReinstatement / replacement cost
Compulsory purchase / expropriationGovernmentsMarket Value + disturbance
Dispute resolution / litigationCourts, arbitratorsExpert witness / RICS guidance
💡
RICS Red Book (RICS Valuation - Global Standards) is the bible of professional real estate valuation. The course is an MRICS member. The Red Book defines Market Value as: "The estimated amount for which an asset should exchange on the valuation date between a willing buyer and a willing seller in an arm’s-length transaction after proper marketing where parties had each acted knowledgeably, prudently and without compulsion."

Types of Values

Slide p.8–12
The 15+ Definitions of “Value” in Real Estate Slide p.8

One of the most important lessons: the same property can have many different “values” simultaneously, depending on who is asking and why. The slide deck lists at least 15 distinct definitions:

Value TypeDefinition / Purpose
Market Value (MV)Estimated exchange amount between willing buyer & seller in arm’s-length transaction (RICS definition)
Fair ValuePrice received to sell an asset in orderly transaction between market participants (IFRS 13)
Equitable ValueEstimated transfer price reflecting respective interests of identified knowledgeable parties
Investment Value (Worth)Value to a particular owner or prospective owner for individual investment objectives
Special ValueAmount reflecting attributes only of value to a special purchaser
Marriage (Synergy) ValueAdditional value from combining two+ assets where combined > sum of separate values
Mortgage ValueValue for mortgage lending purposes (often conservative / ECO standard)
Cadastral ValueAdministrative tax value assigned by authorities
Accounting ValueBook value on financial statements (historical cost or fair value under IFRS)
Net Asset ValueTotal assets minus liabilities - common for REITs and investment vehicles
Rental ValueEstimated market rent achievable under current conditions
Quick Sale ValueValue under time constraint; always below Market Value
Insurance ValueReinstatement / replacement cost for insurance purposes
Statistical Value (AVM)Automated model output using indices, ML, and statistical methods
Broker Opinion of Value (BOV)Informal estimate based on intermediary’s market knowledge, within a transaction context
PriceWhat was actually paid - not necessarily equal to value
📝
Exam tip: “Your home as seen by…” - You see a mansion, the buyer sees a cottage, the bank sees collateral, the appraiser sees building elements, the tax authority sees a revenue source. Value depends on perspective and purpose.

Valuation Standards

Slide p.10–14
Three Main Valuation Standards: ECO, RICS & AVM Slide p.10
StandardFull NameFocusDescription
ECOOrder ECO 805/2003 (Bank of Spain)Mortgage concessionReal estate valuation for mortgage purposes. Requires property visit, market description, and physical verification. Spanish regulatory standard.
RICSRoyal Institution of Chartered SurveyorsInvestor / marketGlobal standard. Market Value defined as estimated exchange amount between willing buyer & seller in arm’s-length transaction after proper marketing, acting knowledgeably, prudently, without compulsion.
AVMAutomated Valuation ModelStatistical / scalableReal estate valuation using automatic models supported by observation of witnesses, debugging, statistical adjustments, and quantitative inferences.

Additionally, a Broker Opinion of Value (BOV) is an informal valuation based on an intermediary’s market knowledge, typically produced within the framework of a transaction.

RICS Valuation Process & Red Book Report Slide p.13–14

The RICS valuation follows a six-stage process:

StageProcessKey Activities
1Compilation of InformationInformation reception, documentation analysis
2Inspection of AssetsLocation, environment, property status, installations, free heights, strengths/weaknesses
3Market AnalysisInternal databases, local market contacts, town/city councils, comparable evidence
4Valuation & Report PreparationApply methodology, prepare draft report
5Verification of SecuritiesDelivery of draft initial values, verification with client
6Delivery of Final Values & ReportComplete report in agreed format and date, signed by individual RICS-recognised assessor
📚
RICS Red Book (2025 edition): Defines report contents, allows flexible formats (cards + report), content by asset type, and scope limitations when clearly defined. Must be signed by an individual RICS-accredited assessor (MRICS via essays + defence, or FRICS via recognised professional merit).
International Valuation Standards by Country Slide p.11

Different countries have different bodies governing RE valuation, accounting, financial markets, and banking:

DomainSpainUKUSAGermany
RE ValuationATASA / AEVRICSAppraisal InstituteHypZert
AccountingICACFRCFASB-
Financial MarketsCNMVFSASECBaFin
BankingBanco de EspañaBank of EnglandFederal ReserveDeutsche Bundesbank

At the European level, REV (Recognised European Valuers) and IVSC (International Valuation Standards Council) provide overarching frameworks. The IASB sets accounting standards (IFRS 13 Fair Value) used across jurisdictions.

📝 Class Notes - Session 08
  • Valuation throughout investment life: investment analysis → financing → purchase → accounting → management → return measurement → disinvestment → sale.
  • RICS Red Book (2025): Market Value, Fair Value, Investment Value, Equitable Value, Special Value, Marriage Value. Signed by RICS assessor.
  • ECO (Spain): Mortgage valuation under Order ECO 805/2003. Focus: mortgage concession. Includes property visit.
  • AVM: Automated models using hedonic pricing, regression, ML. Data sources: property characteristics, historical sales, market trends, geospatial data.

The Four Valuation Methodologies

Core Methods
Method 1: Comparative (Sales Comparison) Approach S7 Method

The most widely used method for residential property. Value is determined by comparing the subject property to recent transactions of similar properties.

Core Logic: Subject Value = Comparable Sale Price ± Adjustments Adjustments for: Location premium/discount Size difference (price/sqm normalisation) Age and specification Transaction date (time adjustment) Special features (terrace, garden, parking, views) Helvetia Application (Slide p.21 Comparable Table): Branded Residences average: €17,959/sqm (apartments) Ultra high-end average: €12,076/sqm (apartments) Branded Residences premium: +48.7% over ultra high-end Helvetia base price: €17,500–25,000/sqm (floors 1–6) Corrections for: garden location, corner premium, floor level, terrace
CompProjectDeliveryType€/sqm
1C. Lagasca 992019Apartment (ultra high-end)€12,000
2Four Seasons, C. Sevilla2020Branded Residences€15,200
3Mandarin, P. de Gracia BCN2023Branded Residences€18,500
4Mandarin, Hermosilla MAD2024Branded Residences€19,500
-Helvetia (target)2027Branded Residences€17,500–28,875
Method 2: Income Capitalisation (Investment Method) S7 Method

The primary method for income-producing commercial assets - offices, retail, logistics, hotels. Value is a function of the income stream and the required rate of return.

Direct Capitalisation (All Risks Yield): Value = NOI / Cap Rate (All Risks Yield) NOI = Gross Income − Vacancy − Operating Expenses Cap Rate = Risk-free rate + Risk premium DCF / Discounted Cash Flow: Value = Sum of [NOI(t) / (1+r)^t] + [Exit Value / (1+r)^n] Exit Value = NOI(n+1) / Exit Cap Rate REFM Exercise example: Income Y1: €3,090,228 Expenses Y1: €313,899 NOI Y1: €2,776,329 Acq. Cap Rate: 4.25% Market Cap Rate: 3.75% Exit Value (Yr 11): NOI / 3.75% = €82,515,205
Direct cap vs DCF: Direct capitalisation is quick but assumes NOI is perpetual and stable - a huge simplification. DCF is more rigorous: it projects each year’s NOI, applies individual discount factors, and adds a terminal value. Exam questions may ask you to compute both and explain the difference.
Method 3: Residual (Development Appraisal) Method S7 Method

Used to value development land or assess the viability of a development project. Works backwards from the completed development value.

Residual Land Value: Residual Value = GDV − Total Development Costs (excl. land) Where: GDV = Gross Development Value (sales or capitalised rent) TDC = Construction + Finance + Fees + Profit allowance Worked Example (simplified Helvetia): GDV (Net Sales): €237.9M Construction costs: €45.1M Finance costs: €14.3M Fees, opex, taxes: €15.0M Developer profit (22.7%): €68.0M equity target ----------------- Residual for land: ~€95–103M (→ actual acq price €103.5M)
Valuation in Reverse The residual method is valuation in reverse: instead of asking “what is this site worth?” you ask “given what I can build and sell, what can I afford to pay for the land?” Besant Capital used exactly this logic to set their €103.5M NBO for Helvetia.
Method 4: Cost (Contractor’s) Method S7 Method

Used where no market comparables exist and no income is generated - schools, churches, hospitals, specialised industrial. Value = cost to replace.

Depreciated Replacement Cost (DRC): Value = Land Value + Depreciated Replacement Cost of Building Land Value: Estimated from comparable land sales DRC: Current rebuilding cost × (1 − Physical depreciation) × (1 − Functional obsolescence) × (1 − External/economic obsolescence)
Best Used ForWeakness
Specialised properties (no market): hospitals, schools, churches, military basesIgnores market demand - a church in a declining town may cost €2M to rebuild but sell for €200k
Insurance purposes (reinstatement cost)Depreciation estimates are highly subjective
Heritage & listed buildingsRarely reflects market value - not accepted for mortgage purposes in most jurisdictions

Choosing the Right Method

Decision Framework
Method Selection by Asset Type & Purpose S7 Applied
Asset TypePrimary MethodCross-Check Method
Residential (owner-occupied)ComparativeCost (for new builds)
Residential (BTR / investment)Income capitalisationComparative
Office / Retail / IndustrialIncome capitalisation (DCF)Comparative (yield benchmarking)
Development landResidualComparative (land sales)
HotelsIncome (profits method)Comparative (price per key)
Specialised / public useCost (DRC)No reliable alternative
Branded Residences (Helvetia)Comparative + ResidualDCF of sales cash flows
📝
Exam tip: Valuers rarely use just one method. The RICS Red Book recommends cross-checking valuations using multiple approaches. When methods give different answers, the valuer must exercise professional judgement to reconcile - and document why.

Valuation Characteristics & Specificities

Slide p.5–6
Fundamental Characteristics Evaluated in Valuation Slide p.5

Before selecting a methodology, the valuer must assess six fundamental property characteristics:

CharacteristicWhat It Covers
UseResidential, commercial, industrial, hotel, offices, etc.
TypologyIsolated, dividing walls, singular building, in row, detached, semi-detached, etc.
LocationDistrict, urbanisation, postal code, industrial estate, etc.
AntiquityAverage age, 1st hand, 2nd hand, old, reforms carried out, etc.
Construction CostsBuilding, housing, installations, elevator, heating, air conditioning, etc.
SurfacesConstructed area considering common zones
Specificities by Asset Type Slide p.6

Different asset types demand attention to different specific factors:

Asset TypeKey Specificities
ResidentialFloor level, number of bedrooms, elevator availability
ShopsCommercial attractiveness of surroundings and premises, relationship with façade frontage
WarehousesLocation in industrial polygon or not, useful height, identifiability, accessibility, proximity to motorways
LandExisting infrastructure, town planning qualification, buildability, views, sunlight, topography

Methodology × Asset Type Matrix

Slide p.18
Which Method for Which Asset? - The Complete Matrix Slide p.18

The course's slide identifies 14 asset types and maps them to 6 valuation methods. “X” = primary method, “Alt” = replacement cost always available as alternative:

Asset TypeComparisonResidualCapitalisationCash FlowsExploitationRepl. Cost
Services assetsXXAlt
Dotational assetsXXAlt
Agricultural farmsXAlt
Exploitation REXXAlt
Rent REXXAlt
ShopsXXXAlt
WarehousesXXAlt
OfficeXXAlt
DevelopmentXAlt
ResidencesXXAlt
Development landXAlt
Finalist landXAlt
Rustic landXXAlt
HousesXAlt
📝
Pattern to remember: Income-producing assets (offices, retail, warehouses, residences for rent) → Capitalisation + Cash Flows. Own-use assets (houses, shops, rustic land) → Comparison. Land for development → Residual. Agricultural/exploitation → Exploitation method. Replacement cost is always available as an alternative cross-check.
🧠 Comprehension Check
A 15-year-old shopping centre with varying lease expiries needs valuation for sale. Which methodology is PRIMARY?
(a) Comparison
(b) DCF
(c) Replacement cost
(d) Residual
(b) is correct. Multi-tenanted properties with varying expiries need DCF to project each lease’s cash flows individually. Comparison works for homogeneous assets; replacement cost where no active market exists; residual for development land.

Valuation Fundamentals

Framework
Types of Value & The RICS Red Book Standard S8 Core
Basis of ValueDefinitionWhen Used
Market Value (MV)The estimated amount for which an asset should exchange on the date of valuation between a willing buyer and willing seller in an arm’s-length transaction after proper marketing.Lending, acquisition, financial reporting
Market Rent (MR)The estimated amount for which an interest in RE should be leased on the valuation date between a willing lessor and lessee.Lease renewals, rent reviews
Investment ValueThe value of an asset to a particular owner or prospective owner for individual investment objectives.Acquisition decisions, portfolio analysis
Fair ValueThe price that would be received to sell an asset between market participants (IFRS 13 definition).Financial statements, IFRS reporting
Forced Sale ValueValue under compulsion or time constraint. Always below Market Value.Distressed sales, NPL portfolios (SAREB)
📚
RICS Red Book: The global standard for property valuations. All professional valuations must comply. The course is MRICS - meaning he is certified to sign RICS-compliant valuations. This is the standard used in Spain for mortgage lending (OM ECO 805/2003) and institutional transactions.

The Four Valuation Methodologies

Core Methods
Method 1: Comparative (Sales Comparison) S8 Method 1

The most direct method: value derived from analysis of recent transactions of comparable properties. The foundation of residential valuation and widely used for commercial.

Comparable Value = Adjusted Price/sqm of comparables × Subject GIA Adjustments made for: + Location premium / discount + Quality premium / discount + Size adjustment (larger = lower price/sqm) + Time adjustment (market movement since comparable transacted) + Condition, ESG rating, lease terms
Helvetia Application (Slide p.21) The Helvetia IM uses precisely this method. Comparable set: Four Seasons (C. Sevilla), Mandarin BCN & MAD, Lagasca 99. Branded residence premium vs. ultra-high-end: +48.7% on price/sqm. Penthouse premium: +71.3%. Base price of €17,500–25,000/sqm validated against these comps.
Method 2: Income Capitalisation (Direct Cap) S8 Method 2

For income-producing assets. Converts a single year’s net income into a value by applying a capitalisation rate.

Direct Capitalisation: Value = NOI / Cap Rate (the IRV formula: Income = Rate × Value) All Risks Yield (ARY) approach (UK/European standard): Value = Passing Rent / ARY ARY reflects ALL risks: vacancy, management costs, depreciation, illiquidity Example: Office building, 1,000 sqm, rent €300/sqm/yr, vacancy 5%, OPEX €20k Gross Income: 300,000 Vacancy (5%): -15,000 OPEX: -20,000 NOI: 265,000 Cap Rate: 5.5% Value: €4,818,182
📝
Exam trap: Cap rate uses NOI (after vacancy and OPEX), not gross rent. GIM (Gross Income Multiplier) uses gross rent. Always clarify which numerator is being used. The exam will give you gross rent and a cap rate - you must first net it down.
Method 3: Discounted Cash Flow (DCF) S8 Method 3

The most flexible method. Projects all future cash flows (rents, voids, capex, terminal value) and discounts at a target return rate. Essential for complex or development assets.

DCF Value: V = ∑ [CF(t) / (1 + r)^t] + [TV / (1 + r)^n] where: CF(t) = Net cash flow in period t (NOI - CAPEX - voids) r = Discount rate (required return / WACC) TV = Terminal Value = NOI(n+1) / Exit Cap Rate n = Hold period (typically 5–10 years) Key inputs and their sensitivity: Discount rate: 1% change → 10–20% value change (long-income assets) Exit cap rate: 0.25% change → 3–8% value change Rent growth: 1% pa difference → 5–12% cumulative NPV impact
DCF vs Direct Cap: Direct cap assumes income is stable in perpetuity. DCF explicitly models changing income (rent reviews, lease expiries, refurb capex, void periods) and a finite hold period. For stabilised assets - use direct cap. For value-add, development, or complex lease profiles - use DCF.
Method 4: Residual (Development Appraisal) S8 Method 4

Used for development sites and conversion projects. Works backwards from what the completed scheme is worth to derive what the land/site is worth today.

Residual Land Value: GDV = Gross Development Value (completed scheme value at today's prices) TDC = Total Development Cost (build, professional fees, finance costs) Dev. Profit = GDV × Target Profit Margin (typically 15–20% on cost) Residual Land Value = GDV − TDC − Dev. Profit Helvetia worked example: GDV (net sales): €237.9M All-in investment: €156.8M (land + build + soft costs) Gross Profit: €81.1M (34.1% margin on cost) Post-tax net profit: €44.0M (18.5% net margin) Implicit land value: €103.5M (€9,832/sqm of total area)
Why residuals are highly sensitive A 5% change in GDV (sale prices) flows entirely through to land value. In the Helvetia case, if branded residence prices fall 5% (−€11.9M on GDV), net profit falls by a similar amount. This sensitivity is why developers hedge via presales - Helvetia targets 1.5 units/month absorption with 15% deposit at signing.
📝 Class Notes - Session 08 (27 April 2026)
  • DCF exercise: 11-year horizon. Residual = NOI_yr11 / exit cap (4.5%) = ~€82.5M. Asset value = €62.9M at 7% discount rate.
  • IRR vs CAGR: IRR = 7%; CAGR = ~5.86%. Gap = reinvestment assumption. CAGR is more conservative.
  • Modelling error: Purchase price in Year 1 not Year 0 inflates IRR from 7% to 7.92%.
  • Levered IRR: 65% LTV at 4% bullet loan → levered IRR exceeds 7% because cost of debt (4%) < asset return (7%).
🧠 Comprehension Check
Asset value is €62.9M, IRR is 7%. If you mistakenly place the purchase in Year 1, what happens?
(a) IRR drops to ~6%
(b) IRR rises to ~7.92% - an artefact of discounting the cost one period forward
(c) No change
(d) IRR becomes negative
(b) is correct. Moving the cost from t=0 to t=1 reduces its present value in the IRR calculation (it gets discounted by one period), artificially inflating the IRR. This is a common spreadsheet error. Always place acquisition cost at time zero.

Detailed Methodology Deep Dives

Slide p.19–47
Comparison Method: The 5-Step Process & Homogenisation Slide p.19–24

The comparison methodology follows a rigorous 5-step process to derive value from market evidence:

StepNameActivity
1Assets IdentificationIdentify relevant characteristics of the property and area
2Data CaptureCapture comparable data from offer portals and closing records
3Offer Price AdjustmentAdjust bid prices to theoretical closing prices using coefficient β
4HomogenisationHomogenise relevant asset properties using adjustment coefficients
5Comparables WeightingAssign weights to comparables based on reliability and similarity
Step 3 - Offer Price Adjustment: Vcoa = Vco × β (β = adjustment coefficient, usually < 1) Bid prices have upward bias (sellers maximise position, leave room for negotiation). β depends on: asset typology, location, average selling time, new/2nd hand, demand/supply. Step 4 - Homogenisation Coefficient: αn = ∏ αi (product of all individual adjustment factors) Vth = Vt × αn (homogenised value of comparable t) If comparable is BETTER than subject: α < 1.00 (reduces comp price) If comparable is WORSE than subject: α > 1.00 (increases comp price) Value elements: Location, Use, Typology, Surface, Design, Qualities, Age, Conservation Step 5 - Final Asset Value (simple average or weighted): Va = Σ Vth,i / m (m = number of comparables) Or weighted: Va = Σ (wi × Vth,i) where Σwi = 1
Weighted Example from Slides (p.24) Comparables C1–C6 with homogenised values: 2000, 2500, 2100, 2450, 2050, 2000 €/m². Weights: 0.10, 0.25, 0.13, 0.30, 0.12, 0.10 (C2 and C4 weighted highest - same building as subject, more reliable). Result: 2,387.50 €/m².
DCF: Process, Residual Value & Cap Rates Slide p.25–34

The DCF method is used for multi-leased properties with varying expiry dates, empty surfaces, and unstable rents. It determines market value by analysing projected cash flows over a hold period, assuming a sale at exit.

DCF Process: 1. Project Income over time (rents × CPI inflation) 2. Project Expenses over time (management, defaults, marketing, taxes) 3. Calculate Net Cash Flows (NOI) per period 4. Calculate Residual Value at exit Residual Value (Terminal Value): RV = NOIn × (1 + π*) / (r − g) Where: π* = inflation, r = discount rate/yield, g = NOI growth rate r − g = cap rate (exit rate) Present Value (Property Value): PV = Σ (NOIi + RV) / (1 + r)ti IRR Relationship: Price = Σ CFNi / (1 + IRR)ti IRR is the OUTPUT of actual cash flows; Discount Rate is the INPUT of a DCF.
💡
Cap Rate = NOI / Market Value. Measures expected return on an RE investment. Highly correlated with market interest rates: rate hikes ⇒ cap rate hikes; rate cuts ⇒ cap rate cuts. Also known as exit yield. Key difference: cap rate uses asset value; exit yield uses asset cost. At purchase, they may be equal, but they diverge over time.
DCF Worked Example 1: Shopping Centre Valuation Slide p.32–33

Valuing a 50,000 m² shopping centre (35,000 + 15,000 m²) using a 10-year DCF:

ParameterValue
Rents30 €/m²/month
GRA (Gross Rentable Area)50,000 m²
Average Occupancy (10 years)80%
10-year CPI1.5%
Income from common expenses7 €/m²/month
Yield (Discount Rate)4.50%
g (EBITDA growth rate)1.00%
Cap Rate (Yield − g)3.50%
Management fees5.00% of rents
IAE (tax on economic activity)0.90%
Default1.00%

Variable costs over time include declining marketing expenses (3.1% Y1 → 0% from Y5 as the mall stabilises), declining lack-of-rents (10% Y1 → 0% from Y4), and stable taxes and insurance. The solution is worked in the 5-RE_Valuation Excel file.

DCF Worked Example 2: Office Building Valuation Slide p.35–37

Valuing a 9-level office building (666.66 m² per floor), built 2010, with a 7% IRR target and planned exit in 2033:

ParameterValue
Acquisition costs2.50%
Irrecoverable expenses5.25% (default 0.5%, management 1.75%, marketing 2.0%, unexpected 1.0%)
Long-term unoccupied3.00%
Exit Rate (Cap Rate)4.25%
Exit expenses2.75%
CPI1.6% (Y1), 1.7% (Y2), 1.8% (Y3–11)
Rents growth3.0% (Y1–5), 1.8% (Y6–10)

Results:

MetricValue
Net Value€62,777,259
Gross Value€64,346,690
Gross Return (Gross Inc / Vendor’s Price)4.92%
Semi-net Return (Net Inc / Vendor’s Price)4.42%
Initial Net Return4.31%
IRR 10 years7.01%
Annual Average Return4.93%
Net Value / m²€10,463
Residual Method: Static vs Dynamic Slide p.38–43
VariantForApproach
Residual StaticConsolidated lands (urbanisation executed)Uses current values; all costs at today’s prices
Residual DynamicUnconsolidated lands (urbanisation pending)Uses expected future values; DCF of phased cash flows
Static Residual: Vv = Cc + Cs + De + Bd Where: Vv = sales value, Cc = construction cost, Cs = land cost, De = development expenses (funding, fees, marketing), Bd = developer profit Therefore, land cost = Cs = Vv − (Cc + De + Bd) Dynamic Residual: Value calculated by discounting expected future cash flows (pre-sales, sales, expenses) at a rate reflecting the risk implicit in the operation (risk-free + risk premium). IRR varies by asset typology due to different risk profiles.
Static Residual Example (p.41) 1,000 m² plot, 2,615 m² buildable, 25 houses + 2 shops. Houses sell at €2,490/m², shops at €1,260/m². Construction: houses €840/m², shops €480/m², parking €300/m², storeroom €240/m². Developer margin 20%. Project fees 6%, admin costs 11%. Land value = GDV minus all costs and profit. Worked in Excel.
Dynamic Residual Example (p.43) Unconsolidated land, 5-year horizon, discount rate 8% (3% risk-free + 5% premium). Pre-sales/sales: €100k–€1.2M over years 1–5 (total €2.1M). Expenses: €100k–€800k over years 2–4 (total €1.3M). Land value = PV of net cash flows discounted at 8%.
Replacement Cost Method: Gross vs Net Slide p.44–47

Applicable for all buildings in all constructive states (project, construction/rehabilitation, finished). Produces a replacement cost - either gross (value at new) or net (depreciated).

Gross Replacement Cost: GRC = Land Value + Avg Construction Cost + Required Market Expenses Net Replacement Cost (Market Value): NRC = Land Value + (Construction Cost − Accumulated Depreciation) Example (Slide p.47): Shopping centre, 35,000 m², 10 years old. Land: €1,000,000 Construction costs: €3,000,000 Accumulated depreciation: €750,000 Market Value = 1,000,000 + (3,000,000 − 750,000) = €3,250,000

When is the Replacement Cost applied?

#Use Case
1No active RE market exists, but construction activity is present (rural villages, undeveloped land)
2Properties linked to an economic activity
3Current value of works on buildings under construction
4Value of investments in RE under construction

Key Numbers

REFM Exercise Set
€1MAsset value in REFM exercises
80%LTV in both bullet and amortising exercises
3%Interest rate (fixed) in REFM exercises
20 yrsMaturity in REFM exercises
35%Maximum Effort Rate for lender approval
12/yrPayment frequency (monthly)

Mortgage Structures

REFM Exercises 1 & 2
REFM Exercise 1: Bullet (Interest-Only) Loan REFM Sheet 2

A bullet loan pays interest only throughout the term. The full principal is repaid as a single lump sum at maturity. Common in commercial RE.

REFM Exercise Parameters: Asset Value: €1,000,000 LTV: 80% → Debt = €800,000 Type: Bullet fixed rate Rate: 3% per annum Frequency: 12 payments/year Maturity: 20 years Monthly Interest Payment: Monthly rate = 3% / 12 = 0.25% I Payment = 800,000 × 0.0025 = €2,000 / month Principal Payment (Year 20): P Payment = €800,000 (entire debt, single balloon) Total Interest Paid over 20 years: Total = 2,000 × 240 months = €480,000
📝
Bullet vs amortising: Bullet has higher total interest (principal never reduces) but lower monthly payment than amortising. Lower monthly cash drain = better for investors who need maximum near-term cash flow. Risk: must refinance or sell at maturity to repay balloon.
REFM Exercise 2: Amortising Loan & Salary Required REFM Sheet 3

An amortising loan pays both interest and principal each period. Principal falls progressively, so interest cost decreases over time. Standard residential mortgage structure.

REFM Exercise Parameters: Asset Value: €1,000,000 LTV: 80% → Debt = €800,000 Type: Amortising fixed rate Rate: 3% per annum Frequency: 12 payments/year Maturity: 20 years (240 months) Monthly Payment (PMT formula): r_m = 3% / 12 = 0.0025 n = 240 months PMT = PV × [r_m(1+r_m)^n] / [(1+r_m)^n - 1] = 800,000 × [0.0025 × (1.0025)^240] / [(1.0025)^240 - 1] = 800,000 × [0.0025 × 1.8208] / [1.8208 - 1] = 800,000 × 0.004552 / 0.8208 = €4,434.96 / month (approx) Salary Required (35% Effort Rate): Annual mortgage cost = 4,434.96 × 12 = €53,220 Effort Rate = Loan Expenses / Pre-tax income ≤ 35% Required salary = 53,220 / 0.35 = €152,057 / year
Effort Rate in Practice Spanish banks typically cap the effort rate at 30–35%. In 2024, with Madrid average salaries ~€35k and mortgage payments on a typical home exceeding €1,200/month, the effort rate for median earners often exceeds 40% - a key driver of the housing affordability crisis.

Securitisation: MBS & ABS

Core Theory
From Mortgage to MBS: The Securitisation Chain S9 Core

Securitisation converts illiquid mortgage pools into tradeable bonds. This is the mechanism that solved RE’s liquidity problem - and also the mechanism that nearly collapsed the global financial system in 2008.

StepActorAction
1. OriginationBank / mortgage lenderIssues mortgages to homeowners. Property is collateral.
2. PoolingOriginator / ArrangerBundles hundreds/thousands of mortgages into a pool. Diversification reduces idiosyncratic risk.
3. SPV TransferSpecial Purpose VehiclePool is sold to an SPV (bankruptcy-remote). Removes from bank’s balance sheet.
4. TranchingArranger / Rating AgencySPV issues bonds in tranches (Senior AAA, Mezzanine BBB, Equity NR). Losses hit equity first.
5. Sale to InvestorsCapital marketsPension funds, insurance cos, hedge funds buy tranches matching their risk appetite.
6. Cash flowHomeownersMonthly P&I payments flow from borrowers → SPV → bondholders in waterfall order.
InstrumentUnderlying PoolKey Feature
RMBS (Residential MBS)Residential mortgagesPrepayment risk: homeowners refinance when rates fall
CMBS (Commercial MBS)Commercial RE loansExtension risk: borrowers may not refinance at maturity
ABS (Asset-Backed Security)Consumer loans, auto, credit cardsShorter duration; diverse collateral types
CDO (Collateralised Debt Obligation)Pools of MBS/ABS tranchesRe-tranching of already-tranched assets - toxic in GFC
MBS Pricing: Duration, Prepayment & Spread S9 Core
MBS Price (simplified, like a bond): Price = ∑ [CF(t) / (1 + y/2)^t] where y = yield (OAS: Option-Adjusted Spread + risk-free rate) Key MBS risks not present in plain bonds: 1. Prepayment risk: homeowners prepay when rates fall (negative convexity) 2. Extension risk: homeowners prepay less when rates rise (duration lengthens) 3. Credit risk: borrower default → collateral recovery depends on RE values MBS Spread over Government Bond = compensation for: Liquidity premium + Prepayment risk + Credit risk + Structural complexity
The GFC lesson: AAA-rated senior CDO tranches assumed that US house prices could not fall nationally and simultaneously. When they did in 2007–08, correlation jumped to 1 - the diversification that underpinned the AAA rating evaporated. The tranching model worked fine in theory but the correlation assumption was catastrophically wrong.

Key Numbers

REFM Exercise Set
40,000m²S&L retail store size (REFM exercise)
$25/m²NNN base rent (growing 5% every 5 years)
6.25%Asking cap rate on Year 1 NOI
6.5%Disposition cap rate at end of 5-year hold
70%LTV on S&L property
3.25%Loan rate (30-year amortisation)

Covered Bonds

vs MBS
Covered Bonds: Structure & Why They’re Safer Than MBS S10 Core
FeatureCovered BondMBS
IssuerBank remains on the balance sheet; issues the bond directlySPV issues the bond; bank sells assets off-balance sheet
RecourseDual recourse: investor claims against issuing bank AND cover poolBondholders have recourse to SPV only (no bank backstop)
Cover poolDynamic: bank can substitute assets to maintain overcollateralisationStatic: fixed pool at issuance (amortises with prepayments)
RegulationHeavily regulated (EU Covered Bond Directive 2019); min 5% overcollateralisationLess regulated; structured by arranger
RatingTypically AAA/AA; often outrates the issuing bankVaries by tranche; senior typically AAA but weaker recourse
Risk in GFCMinimal - dual recourse protected investorsSevere - collateral values and correlation assumptions failed
💡
Spain context: Spanish cédulas hipotecarias are the covered bond equivalent - one of the most developed covered bond markets in Europe. Spanish banks used them heavily for RE funding pre-GFC, and they survived the crisis far better than the MBS structures that collapsed.

Sale & Leaseback

REFM Exercises 3–5
S&L Structure: What, Why & How REFM Sheet S&L Description
The REFM Scenario You have been presented with an off-market opportunity to personally purchase a 40,000 m², single-tenant retail store leased to the current owner. Upon selling the store, the company would leaseback the property from you on a 20-year lease with 5% rent increases every five years. The proposed rent is $25/m²/yr NNN.

NNN (Triple Net) lease means the tenant pays:

  • N1 - Net real estate taxes
  • N2 - Net building insurance
  • N3 - Net property maintenance

As investor/landlord, your only receipt is the rent - no operating cost leakage. This makes NNN leases the most attractive structure for investors: pure income, minimal management.

YearRent/m²/yrGross RevenueReimbursablesNOI
1–5$25.00$1,000,000$200,000$1,200,000
6–10$26.25 (+5%)$1,050,000growing
11–15$27.56 (+5%)$1,102,500growing
16–20$28.94 (+5%)$1,157,625growing
REFM S&L Calculations: Price, Loan, IRR REFM Sheet S&LCalculations
Step 1: Purchase Price (Direct Cap on Year 1 NOI): Year 1 Gross Revenue = 40,000 × $25 = $1,000,000 Reimbursables = 40,000 × $5 = $200,000 Year 1 NOI = $1,200,000 Asking Cap Rate = 6.25% Purchase Price = NOI / Cap Rate = 1,200,000 / 0.0625 = $19,200,000 Step 2: Loan Amount (70% LTV): Loan Amount = 0.70 × 19,200,000 = $13,440,000 Equity Required = 19,200,000 − 13,440,000 = $5,760,000 Step 3: Monthly Mortgage Payment (30-yr amort, 3.25%): r_m = 3.25% / 12 = 0.2708% n = 360 months PMT = 13,440,000 × [0.002708 × (1.002708)^360] / [(1.002708)^360 - 1] ≈ $58,479 / month (approx - verify with calculator)
Step 4: Terminal Value at Year 5: Year 6 NOI (approx, after 5% rent step-up) ≈ $1,260,000 Exit Cap Rate = 6.5% Terminal Value = Year 6 NOI / Exit Cap Rate = 1,260,000 / 0.065 = $19,384,615 Step 5: Net Sale Proceeds: Sale Price = $19,384,615 Remaining Loan Bal. = (from amort schedule after 60 months) Net Proceeds = Sale Price − Remaining Debt Step 6: IRR Calculation: Year 0: -$5,760,000 (equity investment) Year 1: NOI − Debt Service Year 2: NOI − Debt Service Year 3: NOI − Debt Service Year 4: NOI − Debt Service Year 5: NOI − Debt Service + Net Sale Proceeds IRR = rate that makes NPV of above cash flows = 0
📝
Key exam metrics to calculate: Purchase Price, Loan Amount, Equity Required, Unlevered IRR (without debt), Levered IRR (with debt), Year 3 Free & Clear Return (NOI/Value), Year 3 Cash-on-Cash Return (after-debt CF/equity), Terminal Value, Net Sale Proceeds. Work through these calculations step by step with your calculator.
REFM Exercise 4: Mezzanine Loan & Equity Return REFM Sheet Mezzanine

This exercise introduces the capital stack in a RE development context - calculating returns by tranche.

REFM Capital Stack: Senior debt: €12,000,000 at 5% interest Mezzanine: €4,000,000 at 12% interest Equity: €4,000,000 Total: €20,000,000 Final exit price (Year 3): €26,000,000 Equity Cash Flow (Year 0): Equity CF(0) = −€4,000,000 At exit (Year 3), waterfall: 1. Repay Senior: €12,000,000 + 3 years interest at 5% 2. Repay Mezz: €4,000,000 + 3 years interest at 12% 3. Equity residual: Exit price − Senior repayment − Mezz repayment Equity IRR: Equity CF(0) = −4,000,000 Equity CF(3) = 26,000,000 − (Senior + Mezz full repayment) IRR = solve for r in: 0 = −4M + Equity CF(3)/(1+r)^3
💡
Waterfall logic: Senior gets paid first - both principal and all accrued interest. Mezzanine gets paid second. Only what’s left belongs to equity. If the exit price falls below €16M (senior + mezz repayment), equity gets zero. This is the fundamental risk of high leverage.
📝 Class Notes - Session 09 (28 April 2026)
  • S&LB: Sale + lease. Owner becomes tenant. Common in industrial/logistics.
  • Lease types: Gross → Net → Triple Net (NNN: tenant pays rent + insurance + maintenance + taxes). NNN = bond-like income for investor.
  • Pricing: Same yield at different price/rent combos. €10M/€800K = 8% = €9M/€700K.
  • Motivations: Liquidity release, operational continuity, tax optimisation, off-balance-sheet financing.
  • Spain cadastral value: Selling significantly below triggers tax avoidance penalties.

Key Numbers

Session 11
$2TGlobal REIT market capitalisation
35Countries with active REIT legislation
80%Min qualifying assets required for REIT status
2009Spain SOCIMI legislation created
90%Min profit distribution required by REIT rules
0%Corporate tax rate for qualifying REIT income (most jurisdictions)

REITs & SOCIMIs

Public Equity
REIT Mechanics: Structure, Rules & Tax Efficiency S11 Core

A REIT is a company that owns income-producing real estate and distributes most of its earnings to shareholders. The key tax deal: no corporate tax at fund level in exchange for distributing at least 90% of taxable income.

REIT RequirementDetail
Asset test≥80% of assets must be qualifying RE (buildings, land, RE funds)
Income test≥75% of gross income from rents, mortgage interest, or RE gains
Distribution test≥90% of taxable income distributed as dividends each year
Ownership testMust be widely held; no single shareholder >10% (anti-abuse)
ListingMost jurisdictions require stock exchange listing for REIT status
CountryVehicle NameYear CreatedKey Feature
USAREIT1960Pioneer; 10 largest REITs globally all US-based
SpainSOCIMI20090% corporate tax; 80% qualifying assets; min 3 yr hold
FranceSIIC2003Société d’Investissements Immobiliers Cotées
GermanyG-REIT2007Restricted to commercial; no residential
UKUK REIT2007Property Rental Business must be ≥75% of total business
MexicoFIBRAS2010Fast-growing market; logistics and industrial focus
Top Global REITs & Sector Specialisation Slide p.46

Specialisation by sector is now the dominant REIT model. The largest REITs globally (Jul 2025 market cap):

RankREITMarket CapSector Focus
1American Tower (AMT)$102.6BTelecom towers & data centres
2Welltower (WELL)$101.5BHealthcare & senior housing
3Prologis (PLD)$101.3BIndustrial & logistics
4Equinix (EQIX)$74.0BData centres
5Simon Property Group (SPG)$61.0BPremium shopping malls
7Realty Income (O)$51.6BRetail NNN single-tenant
8Public Storage (PSA)$50.7BSelf-storage
Sector observation Of the top 10 global REITs, zero are traditional office or residential. Data centres, telecom infrastructure, healthcare, and logistics dominate - reflecting the structural shift in institutional RE capital allocation since 2015.

Private Equity RE & NPLs

Private Markets
Private Equity RE Funds: Structure & Returns S11 Core
FeatureCore/Core+ FundValue-Add FundOpportunistic Fund
Target IRR6–10%10–15%15–25%+
Leverage30–50% LTV50–70% LTV60–80% LTV
Hold period7–10+ years5–7 years3–5 years
Fee structure1.0–1.25% mgmt + 10–15% carry1.5% mgmt + 15–20% carry2% mgmt + 20% carry
Hurdle rate6–7%7–8%8–10%
Typical LPPension funds, insurance cosSovereign wealth, endowmentsFamily offices, HNWIs
💡
Carry (Carried Interest): GP’s share of profits above the hurdle rate. On a €100M fund with 20% carry and 8% hurdle: if the fund returns 15%, LP gets 8% + 80% of excess, GP gets 20% of excess above hurdle. This aligns GP incentives with performance.
NPL Portfolios: Non-Performing Loans & SAREB S11 Core

NPLs (Non-Performing Loans) are loans where the borrower has stopped making payments (typically >90 days past due). When backed by RE collateral, they become distressed RE opportunities.

ConceptDefinitionSpain Context
NPLLoan >90 days past due; borrower unable to service debtSpanish banks had €190B+ NPLs at 2013 peak
REOReal Estate Owned - bank takes possession after foreclosureBanks became involuntary RE owners post-GFC
SAREBSpain’s “bad bank” - state vehicle created 2012 to absorb toxic RE assets from rescued banksAbsorbed €50.8B of RE assets from Bankia, CAM, etc.
ServicerCompany managing NPL collection and REO disposalAltamira, Solvia, Haya Real Estate (now Anticipa/Aliseda)
NPL InvestorDistressed debt fund buying NPL portfolios at discount to parCerberus, Blackstone, Lone Star active in Spain
NPL Investment Return Logic: Purchase NPL portfolio at 30–50 cents on the euro of face value Recovery from: (a) Borrower work-out (restructured loan repayment) (b) Foreclosure + REO disposal (sell recovered property) (c) Loan sale to secondary buyer IRR target: 12–20% depending on portfolio quality and jurisdiction

Tokenisation of Real Estate

The course Research
RE Tokenisation: The Third Liquidity Solution S11 / Tokenization Doc

A token is a digital representation of ownership or rights in a real estate asset, recorded on a blockchain and managed/optimised using AI technologies. It is the most recent answer to RE’s structural illiquidity problem.

SolutionMechanismMin InvestmentLiquidity
Direct ownershipBuy property outrightHigh (€500k+)Low (months to sell)
REIT / SOCIMIBuy listed sharesLow (1 share)High (stock market)
MBS / Covered BondBuy RE-backed bondMedium (€100k+ institutional)Medium (bond market)
Tokenised REBuy fractional ownership token on blockchainVery Low (€50–1,000)Growing (24/7 secondary markets)
Case StudyDetails
Dubai DLD ProgramPhase I: Pilot tokenisation of RE deeds on XRP Ledger. Phase II (Feb 2025): Live on-chain transactions. Target: $16B tokenised RE by 2033
Madrid Centralized ModelSPV structure under CNMV supervision; ERC-3643 standard; KYC/AML at token issuance; investor protects under MiFID II
Regulatory frameworkEU: MiCA regulation. Spain: CNMV. UAE: VARA. All require KYC/AML compliance embedded in smart contract

Key Numbers

REFM IRR Exercise Set
19.1%Equity IRR (post-tax) - REFM LP exercise (Excem SPV)
1.58xEquity multiple (post-tax) - REFM LP exercise
50%LTC (loan-to-cost) in REFM LP exercise
18%+Target IRR - Preferred equity Mijas exercise
20%+Target IRR - Comporta opportunistic investment
3 yrsInvestment horizon - Preferred equity exercise

IRR Framework

Core Theory
Unlevered vs Levered IRR: The Core Distinction S12 Core
Unlevered IRR (Project IRR): Cash flows: Total asset investment out, all NOI in, total asset sale price in Unlevered CF(0) = −Purchase Price (100% of asset) Unlevered CF(t) = NOI(t) (no debt service deducted) Unlevered CF(n) = NOI(n) + Sale Price (no debt repayment) → Measures the return of the ASSET itself, independent of financing Levered (Equity) IRR: Levered CF(0) = −Equity (Purchase Price − Loan) Levered CF(t) = NOI(t) − Debt Service(t) Levered CF(n) = NOI(n) − Debt Service(n) + (Sale Price − Remaining Debt) → Measures the return to the EQUITY investor after all debt costs Leverage effect: If Asset IRR > Cost of Debt → Levered IRR > Unlevered IRR (positive leverage) If Asset IRR < Cost of Debt → Levered IRR < Unlevered IRR (negative leverage) If Asset IRR = Cost of Debt → Levered IRR = Unlevered IRR (neutral)
📝
Exam question type: “The unlevered IRR is 7%. The loan rate is 5%. Is leverage accretive?” Answer: Yes - borrowing at 5% to earn 7% improves equity returns. The spread (2%) accrues entirely to the equity investor, amplified by the leverage ratio.
MOIC (Money-on-Invested-Capital) & Equity Multiple S12 Core
MOIC / Equity Multiple: MOIC = Total Equity Cash Inflows / Total Equity Cash Outflows Example (REFM LP exercise): Equity invested: €18,350,000 Total returned: €28,993,350 (distributions + exit) MOIC = 28,993,350 / 18,350,000 = 1.58x MOIC vs IRR - key difference: IRR: time-weighted; penalises slow distributions MOIC: gross return multiple; ignores time A 2.0x MOIC over 10 years = ~7.2% IRR (poor) A 2.0x MOIC over 3 years = ~26% IRR (excellent) Always quote BOTH metrics. Neither alone is sufficient.

Real Investment Examples

Slides p.38–40
Case A: Preferred Equity - Mijas Golf Development Slide p.38
ParameterValue
LocationMijas, Costa del Sol - first line golf, multifamily
Asset typologyResidential land (5.2M€), outstanding mortgage 2.25M€
Built area7,250 sqm - 30 units at avg €833k/unit
Total sales proceeds target€25,000,000
Preferred equity ticket€2,250,000
Investment horizon3 years
Target IRR18% + % share in remaining ECF
MOIC target1.3x
Preferred equity CF share69%
Capital debt structureSenior €12M + Pref Equity €2.25M + Equity €3M
Construction period10 quarters
Case B: LP Equity - REFM Beachfront Development Slide p.39 / REFM IRR Sheet
ParameterExcem SPV (61.5%)LP (48.35%)GP (13.17%)
Total Sales€71,571,093€56,245,377€15,325,716
Avg price/unit€2,423,708€2,423,708€2,423,708
Units30236
Gross Profit€19,144,489€15,045,026€4,099,462
Net Profit (post-tax)€14,180,446€10,729,775€3,450,671
Equity IRR (post-tax)19.1%
Equity Multiple1.58x
LTC (debt/total inv. cost)50%
Project termQ4 2021 → Q4 2024 (36 months)
Investment Decision Framework: Main Metrics to Analyse Slide p.39

The course's slide lists the main analysis criteria for any LP equity investment decision. These are the lenses through which any deal must be evaluated:

#CriterionWhat to Check
1Equity IRRPost-tax levered return to equity. Benchmark against strategy (Core 6–8%, Oppo 15%+)
2Equity Multiplier (MOIC)Total cash returned / total cash invested. Must be read alongside IRR and hold period
3Debt/Equity ratioLTC or LTV. Higher leverage → higher IRR but more risk. Check covenant compliance
4Sales velocityUnits/month absorption. If too slow, carrying costs destroy IRR. Helvetia targets 1.5/month
5Land legal statusZoning confirmed? Building permit in hand? Any legal challenge? Spain: urban vs. urbanisable land
6Commercial attractivenessIs there a real market at target prices? Comparable evidence? Pre-sales?
7Technical issuesLocation suitability, safety, environmental situation, construction complexity
📝 Class Notes - Session 11 (18 May 2026)
  • Risk hierarchy: Residential (lowest) → CBD Offices → Non-prime Offices → Logistics → Hotels → Retail (highest). Determines discount rate.
  • Four capital channels: Public equity (REITs), Private equity, Private debt (mortgages/bridge/mezzanine), Public debt (MBS/ABS).
  • REITs trade at discount to NAV - structural feature, not mispricing.
  • PE tiers: Core (5–8%) → Core-Plus → Value-Add → Opportunistic → Distressed (20%+).
  • Basel III/IV: Made high-risk RE lending costly for banks → private lender market grew.
🧠 Comprehension Check
A property has 7% unlevered IRR. A 65% LTV bullet loan at 4% is available. What happens to equity IRR?
(a) Falls below 7%
(b) Rises above 7% because debt cost (4%) < asset return (7%)
(c) Stays at 7%
(d) Depends on exit cap rate only
(b) is correct. When cost of debt < asset return, leverage amplifies equity returns. Equity = 35% of value. Each year, NOI minus interest accrues to the smaller equity base, producing a proportionally higher return. Max levered IRR at max LTV + min rate; min at min LTV + max rate.
Exam Prep

Exam Cram: Master Review

Everything you need for the final exam in one page. Exam rules, master formula cards, high-yield flashcards, and key numbers.

25 Questions60 MinutesFormula Sheet AllowedNo Negative Marking

Exam Format

Must Know

⚠ Exam Rules

25 questions in 60 minutes. Weighted by complexity.
21 multiple choice (4 options, 1 correct)
1 fill-in-the-blank question
1 match question
2 additional questions (MCQ or other format)
70% theory-based, 30% numerical
No negative marking - always answer every question
• Formula cheat sheet allowed (the REF Formulae PDF)
• Bring a hand calculator
• Respondus LockDown Browser required

Time Value of Money

Core Formulas
Future Value (Simple): FV = PV × (1 + i × yf) Future Value (Compound): FV = PV × (1 + i)^yf Future Value (Continuous): FV = PV × e^(i × yf) Discount Factor (Simple): DF = 1 / (1 + i × yf) Discount Factor (Compound): DF = 1 / (1 + i)^yf Discount Factor (Continuous): DF = e^(−i × yf) Perpetuity: PV = F / r ← THIS IS THE CAP RATE FORMULA Annuity: PV = F × [1 − 1/(1+r)^t] / r Key insight: V = NOI/r is a perpetuity. Cap rate = r. This is the foundation of all RE valuation.

Yield Curves & Forward Rates

Core Formulas
Linear Interpolation: z_i = z_1 + [(z_2 − z_1) / (d_2 − d_1)] × (d_i − d_1) Forward Rate: f_(1→2) = [(1 + r_2 × yf_2) / (1 + r_1 × yf_1) − 1] × (1 / yf_(1→2)) FRA notation: "6x9" = 3-month rate starting in 6 months. Duration = end − start.

Loan Mathematics

Core Formulas
French Amortising Payment: P = [Rate/m × N × (1 + Rate/m)^(n×m)] / [(1 + Rate/m)^(n×m) − 1] Notional from Payment: N = P × [1 − (1 + Rate/m)^(−n×m)] / (Rate/m) Bullet Loan: Monthly = N × Rate/12 (principal repaid at maturity) French: cuota constant, interest falls, principal grows. Bullet: interest only, balloon at end. Higher total interest than French. Effort Rate = Monthly PMT / Gross Monthly Income (max ~35% in Spain).

Return & Debt Metrics

Core Formulas
COCR = Annual before-tax CF / Total CF invested ROI = (Income − Expenses) / Expenses ROE = Annual Income / Equity GIM = Sell Price / Annual Gross Income Exit Yield = NOI / Exit Value Period Return = (FV/PV) − 1 Simple Annualised = [(FV/PV) − 1] / T CAGR = (FV/PV)^(1/T) − 1 IRR = rate where PV = Σ CF_i / (1+IRR)^t_i Leverage = Debt / Asset Value LTV = Loan / Asset Value DTI = Debt / Income DSCR = NOI / Debt Service Payback Period = Equity Investment / After-tax Annual CF Levered IRR uses equity cash flows only (entry equity, after-debt CFs, exit equity).

RE Valuation Formulas

Core Formulas
DCF Price: PV = Σ (NOI_i + RV) / (1+r)^t_i IRR Price: PV = Σ CFN_i / (1+IRR)^t_i Residual Value: RV = NOI_(n+1) × (1+π*) / (r−g) Residual Method: V = C_c + C_s + D_e + B_d Term & Reversion: V = Term + Reversion − Expenses Term = F_c × [1 − 1/(1+r)^t] / r Reversion = {F_m × [1 − 1/(1+r)^100] / r} / (1+r)^t Hardcore / Top Slice: Hardcore = F_m × [1 − 1/(1+r)^100] / r Top Slice = {NIA × [1 − 1/(1+r)^100] / r} / (1+r)^t NIA = Dif TopSlice − Expenses r−g = cap rate. r = discount rate. g = NOI growth. π* = inflation.

High-Yield Flashcards

Top 20 Concepts
Cap rate as perpetuity?
V = NOI/r mirrors PV = F/r. Cap rate IS the discount rate in a no-growth perpetuity.
GFC cause?
Originate-to-distribute: banks sold mortgages into MBS pools, zero skin in the game, moral hazard.
4 RE cycle phases?
Recovery → Expansion → Hypersupply → Recession. Vacancy vs natural rate is the key signal.
DSCR minimum?
Typically ≥1.2x–1.5x. NOI / Debt Service. Below 1.0x = property can't cover its debt.
Covered bond vs MBS?
Covered bond: dual recourse (issuer + pool), on-balance sheet. MBS: pool only, off-balance sheet.
RICS Red Book?
Global valuation standards. Market Value = arm's length, willing buyer/seller, proper marketing.
French vs Bullet loan?
French: constant payment, principal grows. Bullet: interest only, balloon at end. French has lower total interest.
Forward rate "6x9"?
3-month rate starting in 6 months. Duration = end − start = 9 − 6 = 3 months.
Unlevered vs Levered IRR?
Unlevered: total asset return. Levered: equity return (after debt). Levered > Unlevered when asset return > cost of debt.
Why higher exit cap rate?
Asset older, lease expiries closer, uncertainty. Add 25–50bps to entry cap. Conservative underwriting.
SOCIMI / REIT?
Tax-efficient listed RE vehicle. 0% corp tax if distributing ≥80% profits. Must invest primarily in rental RE.
Supply elasticity in RE?
Inelastic short-term (18–36mo construction lag). Creates cobweb dynamics and boom-bust cycles.
4 valuation methods?
Comparative, Income (DCF), Cost/Replacement, Residual. Always state which method and why.
Effort Rate?
Monthly PMT / Gross Monthly Income. Spanish banks: max ~35%. Used to assess borrower affordability.
Term & Reversion?
Value = PV(current rent to lease end) + PV(market rent perpetuity from lease end). Two-layer valuation.
Hardcore / Top Slice?
Hardcore = PV(market rent forever). Top Slice = PV(excess rent during lease). Alternative layering to T&R.
Tokenization?
Blockchain fractionalisation of RE. Lower minimums, 24/7 liquidity, global access, smart contract distributions.
$281 trillion?
Global RE total value (MSCI/Savills). Largest asset class - bigger than all equities and bonds combined.
Sareb?
Spanish "bad bank" absorbing ~€50B toxic RE assets from rescued banks post-GFC. The course was Director of Risk there.
Inflation hedge?
CPI-linked rents + rising replacement costs. Imperfect: rate rises can overwhelm through cap rate expansion.

Key Numbers to Memorise

Exam Ammunition
NumberWhat It Is
US$281TGlobal RE value (MSCI/Savills)
35%Max effort rate (Spain)
1.2x–1.5xTypical minimum DSCR
60–80%Typical max LTV
25–50bpsExit cap rate premium over entry
€103.5MHelvetia acquisition price
22.7%Helvetia gross IRR (18.8% net)
80%Min distribution for SOCIMI/REIT tax benefit
5%Example cap rate: NOI €750k / Value €15M
🎓
Exam Strategy: With 60 minutes for 25 questions, you have ~2.4 minutes per question. Theory questions should take ~1.5 min; numerical questions ~3.5 min. Do theory first, then numericals. No negative marking means ALWAYS answer every question - guess if needed.
Section 01Practice Questions

Practice Questions - Intro to RE Finance

12 Questions
Q1 [Theory] Global real estate is the largest asset class. Approximately what is its estimated total value?
SolutionGlobal RE is estimated at approximately US$281 trillion (MSCI/Savills), exceeding the combined value of all equities and bonds.
Q2 [Theory] What is the key difference between "core" and "opportunistic" RE investment strategies?
SolutionCore: Stable, income-producing, prime-location assets. Low risk, lower return (target ~6–8% IRR).Opportunistic: Distressed, development, or repositioning plays. High risk, higher return (target ~15–20%+ IRR). More reliance on capital appreciation than income.
Q3 [Theory] Explain the "originate-to-distribute" model and why it contributed to the 2007 GFC.
SolutionBanks originated mortgages and immediately sold them into MBS pools. They earned fees at origination but bore no credit risk afterward - creating moral hazard. Originators had no incentive to verify borrower quality, leading to massive underwriting failures.
Q4 [Numerical] A property generates NOI of €3M. The market cap rate is 5%. What is the property value?
SolutionValue = NOI / Cap Rate= €3,000,000 / 0.05= €60,000,000
Q5 [Theory] Name the four phases of the RE cycle in order and describe one key characteristic of each.
SolutionRecovery: Vacancy falling but still above natural rate. No new construction.Expansion: Vacancy below natural rate, rents accelerating, new construction begins.Hypersupply: New completions exceed demand, vacancy rises, rent growth slows.Recession: Vacancy above natural rate, rents falling, no new starts.
Q6 [Theory] What does "dual recourse" mean in the context of covered bonds, and why did it matter during the GFC?
SolutionDual recourse means investors can claim against BOTH (1) the issuing bank and (2) the ring-fenced cover pool of mortgages. During the GFC, MBS investors only had recourse to the underlying pool (which contained toxic mortgages). Covered bond investors had a second layer of protection, which is why covered bond yields stayed stable while MBS yields spiked.
Q7 [Numerical] A cap rate expands from 4% to 5.5% on a property with stable NOI of €2M. Calculate the value change.
SolutionAt 4%: V = €2M / 0.04 = €50MAt 5.5%: V = €2M / 0.055 = €36.36MChange: €50M − €36.36M = −€13.64M (−27.3%)Stable NOI but collapsing valuations from cap rate expansion.
Q8 [Theory] Why is RE considered an effective inflation hedge?
SolutionRE acts as an inflation hedge through two channels: (1) Rental income - leases often contain CPI-linked rent escalation clauses, so income rises with inflation. (2) Replacement cost - construction costs rise with inflation, supporting asset values. However, the hedge is imperfect: in periods of rapid rate rises (like 2022–23), cap rate expansion can overwhelm NOI growth.
Q9 [Theory] What is a SOCIMI and how does it compare to a REIT?
SolutionSOCIMI (Sociedad Cotizada de Inversión en el Mercado Inmobiliario) is Spain’s REIT regime, established 2009/2012. Like REITs: must distribute most income, invested primarily in rental RE, listed on exchange. Key tax benefit: 0% corporate tax if distributing ≥80% of profits.
Q10 [Theory] What is the difference between systematic and idiosyncratic risk in RE?
SolutionSystematic risk: Market-wide, non-diversifiable. Examples: interest rate changes, economic cycles, regulatory shifts. Affects all properties.Idiosyncratic risk: Asset-specific, diversifiable. Examples: tenant default, environmental contamination, local planning changes. Can be reduced through portfolio diversification.
Q11 [Numerical] An investor buys a property for €10M and sells it for €13M after 3 years. Calculate the compounded annualised return (CAGR).
SolutionCAGR = (FV/PV)^(1/T) − 1= (13/10)^(1/3) − 1= (1.3)^(0.3333) − 1= 1.0914 − 1 = 9.14%
Q12 [Theory] Why is RE tokenization considered transformative for the industry?
SolutionTokenization uses blockchain to fractionalize RE ownership into digital tokens, enabling: (1) Lower minimums - retail investors can buy fractions of institutional-quality assets. (2) 24/7 liquidity - tokens trade on secondary markets, improving exit options. (3) Transparency - smart contracts automate distributions. (4) Global access - cross-border investment without traditional friction.
Section 02Practice Questions

Practice Questions - RE Mathematics

15 Questions
Q1 [Numerical] Using simple interest, calculate the future value of €100,000 at 3% for 180 days (ACT/360).
SolutionFV = PV × (1 + i × yf)yf = 180/360 = 0.5FV = 100,000 × (1 + 0.03 × 0.5)= 100,000 × 1.015 = €101,500
Q2 [Numerical] What is the discount factor for a 90-day instrument at 1% annual rate (simple interest)?
SolutionDF = 1 / (1 + i × yf)= 1 / (1 + 0.01 × 90/360)= 1 / 1.0025 = 0.99751
Q3 [Theory] Explain the difference between simple, compound, and continuous compounding.
SolutionSimple: Interest only on original principal. FV = P(1 + i×t). Linear growth.Compound: Interest on principal + accumulated interest. FV = P(1+i)^t. Exponential growth.Continuous: Compounding at infinite frequency. FV = Pe^(i×t). Highest FV for same rate.
Q4 [Numerical] Calculate the present value of a perpetuity paying €100,000 annually at a 4% discount rate.
SolutionPV = F / r= €100,000 / 0.04= €2,500,000This is the cap rate formula: V = NOI / r. The perpetuity is the mathematical foundation.
Q5 [Numerical] Given a 3% rate for 182 days and a 4% rate for 365 days, interpolate the rate for 300 days.
Solutionz_i = z_1 + [(z_2 − z_1) / (d_2 − d_1)] × (d_i − d_1)= 0.03 + [(0.04 − 0.03) / (365 − 182)] × (300 − 182)= 0.03 + [0.01 / 183] × 118= 0.03 + 0.006448 = 3.6448%
Q6 [Theory] What does a "normal" (upward-sloping) yield curve indicate about market expectations?
SolutionA normal curve means longer-term rates exceed short-term rates. This reflects: (1) Term premium - investors demand extra return for locking money up longer. (2) Expectations theory - markets expect future short rates to be higher (economic growth, potential inflation).
Q7 [Numerical] Calculate the compounded future value of €10,000 at 5% annual rate for 10 years.
SolutionFV = PV × (1 + i)^yf= 10,000 × (1.05)^10= 10,000 × 1.62889= €16,288.95
Q8 [Theory] Why is the present value of a cash flow compounded with a negative rate HIGHER than the future value?
SolutionWith a negative rate, the compounding factor (1+i)^t is less than 1 when i < 0. So FV < PV. This means the future value of money is worth LESS than today (deflationary environment). The discount factor exceeds 1, making present values higher than future values.
Q9 [Numerical] Given a discount factor of 0.9524, and a present value of €1,000,000, calculate the future value.
SolutionFV = PV / DF= 1,000,000 / 0.9524= €1,050,012This is equivalent to approximately 5% for 1 year: 1/(1.05) = 0.9524.
Q10 [Theory] Explain the ACT/360 vs ACT/365 day count conventions and where each is used.
SolutionACT/360: Actual days divided by 360. Used in money markets (EURIBOR, LIBOR). Slightly overstates the daily rate since it compresses the year.ACT/365: Actual days divided by 365. Used in UK markets and for some bond calculations. More closely reflects calendar reality.
Q11 [Numerical] PV of an annuity: €50,000/year for 20 years at 6%. Calculate.
SolutionPV = F × [1 − 1/(1+r)^t] / r= 50,000 × [1 − 1/(1.06)^20] / 0.06= 50,000 × [1 − 0.31180] / 0.06= 50,000 × 11.4699 = €573,496
Q12 [Theory] What is the relationship between the cap rate formula and the perpetuity formula?
SolutionThey are mathematically identical. Cap Rate: V = NOI / r. Perpetuity: PV = F / r. The cap rate IS the discount rate in a perpetuity model where NOI is assumed constant forever. This is why the course teaches the perpetuity derivation first - it is the foundation of property valuation.
Q13 [Numerical] The present value of 1,000,000 in 3 months at a 3% simple interest rate (annualised) is:
SolutionPV = FV / (1 + r × t)= 1,000,000 / (1 + 0.03 × 3/12)= 1,000,000 / (1 + 0.0075)= 1,000,000 / 1.0075 = €992,556
Q14 [Numerical] Convert a 5% annual compound rate to the equivalent continuous rate.
SolutionContinuous rate i_c = ln(1 + i)= ln(1.05)= 4.879%Verify: e^(0.04879) = 1.05 ✓
Q15 [Theory] Why does compounding frequency matter, and which gives the highest FV for the same nominal rate?
SolutionMore frequent compounding means interest earns interest sooner, creating a higher effective rate. For the same nominal rate: Continuous > Daily > Monthly > Quarterly > Semi-annual > Annual. The difference increases with the rate and the time horizon.
Section 03Practice Questions

Practice Questions - Economic Factors

12 Questions
Q1 [Numerical] A forward interest rate is described as "6x9." What does this mean, and what is the duration of the implied loan?
Solution6x9 means: starts in 6 months, ends at 9 months.Duration = 9 − 6 = 3 months.It is a 3-month rate starting in 6 months.
Q2 [Numerical] Given a 1% rate for 3 months and a 2% rate for 9 months (annualised compound), calculate the 6-month forward rate starting in 3 months.
Solution(1 + r_2 × yf_2) = (1 + r_1 × yf_1) × (1 + f × yf_f)Using compound: (1.02)^(9/12) = (1.01)^(3/12) × (1+f)^(6/12)(1.02)^0.75 / (1.01)^0.25 = (1+f)^0.5Solving: f ≈ 2.49%
Q3 [Theory] In a French amortisation loan, what happens to the principal portion of each payment over time?
SolutionThe principal portion grows over time. Total payment (cuota) stays constant. As the outstanding balance decreases, the interest portion shrinks, so the principal portion must increase to keep the total constant. This is the key pattern in the amortisation schedule.
Q4 [Numerical] Calculate the monthly payment on a €300,000 French amortising loan at 4% over 20 years.
SolutionP = [Rate/m × N × (1 + Rate/m)^(n×m)] / [(1 + Rate/m)^(n×m) − 1]Rate/m = 0.04/12 = 0.003333n×m = 20 × 12 = 240(1.003333)^240 = 2.22258P = (0.003333 × 300,000 × 2.22258) / (2.22258 − 1)= 2,222.58 / 1.22258 = €1,817.94/month
Q5 [Theory] What is the Effort Rate (debt-to-income ratio) and what threshold do Spanish banks typically apply?
SolutionEffort Rate = Monthly Payment / Gross Monthly Income. Spanish banks apply a maximum of approximately 35%. Example: if PMT = €1,818/month, minimum gross salary = €1,818 × 12 / 0.35 = €62,331/year.
Q6 [Numerical] A bullet loan of €800,000 at 3% for 20 years. Calculate total interest paid.
SolutionBullet loan: interest only, principal repaid at maturity.Monthly interest = 800,000 × 3% / 12 = €2,000Total months = 20 × 12 = 240Total interest = 2,000 × 240 = €480,000
Q7 [Theory] Compare bullet vs French amortising loans: which has higher total interest cost, and why?
SolutionBullet has higher total interest. In a bullet loan, the full principal remains outstanding for the entire term, so interest is calculated on the maximum balance every month. In a French loan, principal is gradually repaid, reducing the balance and thus the interest charged each period. The amortising structure saves significant interest over the loan life.
Q8 [Numerical] Given N = €300,000 and monthly PMT = €1,818, how much of the FIRST payment is interest vs principal at 4%?
SolutionFirst month interest = N × Rate/m = 300,000 × 0.04/12 = €1,000First month principal = PMT − Interest = 1,818 − 1,000 = €818Interest is 55% of payment in month 1. By the final years, almost all of the payment is principal.
Q9 [Theory] What is the DSCR (Debt Service Coverage Ratio) and what is the typical minimum threshold?
SolutionDSCR = NOI / Debt Service (annual loan payments). Lenders typically require DSCR ≥ 1.2x–1.5x depending on asset type and risk profile. A DSCR of 1.2x means NOI covers debt payments with a 20% cushion. Below 1.0x means the property cannot cover its debt obligations from operating income.
Q10 [Numerical] A property has NOI of €500,000. Annual debt service is €380,000. Calculate the DSCR.
SolutionDSCR = NOI / Debt Service= 500,000 / 380,000= 1.316xAbove the typical 1.2x minimum - the loan would likely be approved.
Q11 [Theory] What is LTV (Loan to Value) and why is it a critical metric for lenders?
SolutionLTV = Loan / Asset Value. Typical max LTV is 60–80% depending on jurisdiction and asset type. LTV measures the lender's exposure relative to the collateral. Higher LTV = less equity cushion = higher risk for the lender. If asset value drops below the loan balance, the borrower is "underwater."
Q12 [Numerical] Property value = €1,000,000. Loan = €650,000. Calculate LTV and the equity required.
SolutionLTV = Loan / Asset Value = 650,000 / 1,000,000 = 65%Equity = Asset Value − Loan = 1,000,000 − 650,000 = €350,000Equity as % = 100% − 65% = 35%
Section 04Practice Questions

Practice Questions - RE Economics

12 Questions
Q1 [Theory] Name three endogenous and three exogenous determinants of RE demand.
SolutionEndogenous (market-internal): Price level, existing housing stock quality, replacement cost.Exogenous (external): Population growth/demographics, GDP/income growth, interest rates/credit availability.
Q2 [Theory] Explain the concept of price elasticity of demand in RE. Is RE demand typically elastic or inelastic?
SolutionPrice elasticity = % change in quantity demanded / % change in price. RE demand is generally inelastic in the short term because: (1) housing is a necessity, (2) high switching costs, (3) supply constraints prevent substitution. In the long run, demand becomes more elastic as people can relocate or adjust housing consumption.
Q3 [Theory] What is the "absorption rate" and why is it critical for RE developers?
SolutionAbsorption rate = the pace at which available units are sold or leased in a given market over a specific period (usually monthly or quarterly). Critical because: it determines how fast a developer can sell inventory and recoup investment. Low absorption → longer holding costs → lower IRR. Developers use absorption rates to size projects and phase construction.
Q4 [Theory] How do interest rates affect RE demand through the "affordability channel"?
SolutionLower rates → lower mortgage payments → more households qualify → higher demand → price increases. Higher rates → higher payments → fewer qualify → demand drops → price pressure. Example: A 1% rate increase on a €300k mortgage increases monthly payment by ~€170, pricing out marginal buyers.
Q5 [Theory] Explain the stock-flow model of RE supply. Why does RE supply respond slowly to price signals?
SolutionStock: Existing built environment (vast, changes slowly). Flow: New construction (small relative to stock, typically 1–2% per year). Supply responds slowly because: (1) construction takes 18–36 months, (2) planning/permitting adds 6–18 months, (3) land assembly is complex, (4) construction capacity is constrained. This lag creates the RE cycle.
Q6 [Theory] What happens when RE supply is highly inelastic in the face of rising demand?
SolutionWhen supply is inelastic (fixed in the short run) and demand rises, the full impact falls on price. Prices spike because new supply cannot be added quickly enough to absorb the demand increase. This is the story of constrained markets like London, Hong Kong, San Francisco - limited land + restrictive planning = highly inelastic supply = volatile prices.
Q7 [Numerical] A city has 50,000 housing units. Natural vacancy rate is 5%. Current vacancy is 3%. What does this imply?
SolutionNatural vacancy: 50,000 × 5% = 2,500 units expected vacant.Current vacancy: 50,000 × 3% = 1,500 units vacant.Current vacancy (3%) < natural rate (5%) → the market is in the Expansion phase. Demand exceeds available supply, putting upward pressure on rents. This attracts new development.
Q8 [Theory] What are "cobweb dynamics" in RE markets, and why do they lead to boom-bust cycles?
SolutionCobweb dynamics arise from the supply lag: developers observe high prices today and start building, but by the time construction completes (2–3 years later), demand may have shifted. If many developers responded simultaneously, the market gets flooded with supply just as demand softens → prices crash → construction stops → eventually supply tightens again → prices recover → cycle repeats.
Q9 [Theory] How does the "Tobin Q" concept apply to RE development decisions?
SolutionTobin Q = Market Value / Replacement Cost. When Q > 1: market values exceed what it costs to build new → development is profitable → new supply is incentivised. When Q < 1: it costs more to build than the market will pay → no new development makes sense. The Q ratio signals whether the market is "overbuilt" or "underbuilt."
Q10 [Theory] Explain the difference between nominal and real house price appreciation.
SolutionNominal: Raw price change (e.g., price went from €200k to €220k = +10%). Real: Price change adjusted for inflation (e.g., if inflation was 4%, real appreciation = 10% − 4% = 6%). Real appreciation measures genuine wealth creation; nominal figures can be misleading in high-inflation environments.
Q11 [Numerical] A market had 1,200 transactions last year and 800 active listings. What is the months of supply?
SolutionMonthly transactions = 1,200 / 12 = 100/month.Months of supply = Active listings / Monthly transactions= 800 / 100 = 8 monthsAbove 6 months typically indicates a buyer's market; below 4 months a seller's market.
Q12 [Theory] Why is RE considered a "local" market despite global capital flows?
SolutionRE is fundamentally local because: (1) Location is fixed - cannot be moved or replicated. (2) Local regulations (zoning, planning, rent control) vary enormously. (3) Local economic drivers (employers, universities, infrastructure) determine demand. (4) Information asymmetry - local knowledge is critical. Global capital can flow in, but returns are determined by local fundamentals.
Section 05Practice Questions

Practice Questions - RE Valuation

15 Questions
Q1 [Theory] Name and briefly describe the four main RE valuation methods.
Solution1. Comparative/Market: Value based on recent sales of similar properties, adjusted for differences.2. Income/DCF: PV of expected future cash flows (NOI) + terminal value.3. Cost/Replacement: Value = land cost + construction cost + developer profit.4. Residual: V = C_c + C_s + D_e + B_d. Used for development sites.
Q2 [Numerical] A property has NOI of €750,000. Discount rate is 8%, NOI growth rate is 2%. Calculate the value using the perpetuity growth model.
SolutionV = NOI / (r − g)= 750,000 / (0.08 − 0.02)= 750,000 / 0.06= €12,500,000Cap rate = r − g = 6%. This is the Gordon Growth Model applied to RE.
Q3 [Theory] What is the difference between Market Value and Investment Value in the RICS Red Book?
SolutionMarket Value: The estimated amount for which an asset should exchange between a willing buyer and seller in an arm's length transaction, after proper marketing. Objective, market-based.Investment Value: The value of an asset to a specific investor, reflecting their individual tax position, synergies, required return. Subjective, investor-specific. Investment Value can exceed Market Value if the buyer has unique advantages.
Q4 [Numerical] DCF: NOI years 1–3 are €500k, €520k, €540k. Exit value at year 3 = €10M. Discount rate 7%. Calculate PV.
SolutionPV = 500/(1.07)^1 + 520/(1.07)^2 + (540+10,000)/(1.07)^3= 500/1.07 + 520/1.1449 + 10,540/1.22504= 467.3 + 454.2 + 8,604.1= €9,525,600
Q5 [Theory] Why do professional valuers typically apply a higher exit cap rate than the entry cap rate?
SolutionExit cap is higher because at the end of the hold period: (1) the asset is older and may need capex, (2) lease expiries are closer, reducing income security, (3) future market conditions are uncertain, warranting conservatism. Standard practice: add 25–50bps to entry cap at exit.
Q6 [Numerical] Capitalisation (Term & Reversion): Current rent €80k, market rent €120k, remaining lease 5 years, r = 7%. Calculate value.
SolutionTerm = F_c × [1 − 1/(1+r)^t] / r= 80,000 × [1 − 1/(1.07)^5] / 0.07= 80,000 × 4.1002 = €328,014Reversion = [F_m × (1 − 1/(1.07)^100) / 0.07] / (1.07)^5≈ [120,000 × 14.2693] / 1.40255= 1,712,316 / 1.40255 = €1,220,948Value = 328,014 + 1,220,948 = €1,548,962
Q7 [Theory] Explain the Residual Method of valuation. When is it used?
SolutionV_v = C_c + C_s + D_e + B_d, where C_c = construction cost, C_s = land cost, D_e = development expenses, B_d = development benefit/profit. Used for development sites where value depends on future use. The method works backward from the Gross Development Value (GDV) to determine the maximum land price or required profit margin.
Q8 [Numerical] Cash-on-Cash Return: Annual before-tax CF = €45,000. Total equity invested = €350,000. Calculate COCR.
SolutionCOCR = Annual before-tax CF / Total CF invested= 45,000 / 350,000= 12.86%
Q9 [Theory] What is the difference between an unlevered IRR and a levered IRR?
SolutionUnlevered IRR: Return on the total asset (equity + debt), ignoring financing structure. Measures pure asset performance.Levered IRR: Return on equity only, after debt service. Higher than unlevered when asset return > cost of debt (positive leverage). Cash flows used: equity contribution at entry, after-debt cash flows during hold, equity proceeds at exit.
Q10 [Numerical] GIM calculation: Property sold for €2,000,000. Annual gross income = €160,000. Calculate GIM.
SolutionGIM = Sell Price / Annual Gross Income= 2,000,000 / 160,000= 12.5x
Q11 [Theory] What is a covered bond and how does it differ from an MBS?
SolutionCovered bond: Debt instrument backed by a cover pool of assets (usually mortgages) BUT the issuer (bank) remains liable. Dual recourse. Stays on bank's balance sheet.MBS: Securities created by pooling and securitizing mortgages. Risk transferred to investors. Off-balance sheet for the originator. Single recourse (to the pool only).
Q12 [Numerical] ROE calculation: Annual income from property = €80,000. Equity invested = €600,000. Calculate ROE.
SolutionROE = Annual Income / Equity= 80,000 / 600,000= 13.33%
Q13 [Theory] What is the "exit yield" and how is it calculated?
SolutionExit yield = NOI at exit / Exit value. Also known as exit cap rate. It represents the yield at which you assume the property will trade when you sell it. Higher exit yield = lower exit value = more conservative assumption. Calculated the same as entry cap rate but applied to future NOI and exit price.
Q14 [Numerical] Residual Value (terminal value): NOI in year 6 = €600,000. Exit cap rate = 5.5%. Inflation adjustment = 2%. Calculate RV.
SolutionRV = NOI_(n+1) × (1 + π*) / (r − g)Since exit cap rate = r − g = 5.5%:RV = 600,000 × (1.02) / 0.055= 612,000 / 0.055 = €11,127,273
Q15 [Numerical] Simple annualised return: Buy at €5M, sell at €6.2M after 4 years. Calculate SAR.
SolutionSAR = [(FV/PV) − 1] / T= [(6.2/5.0) − 1] / 4= [0.24] / 4= 6.0% per year
Mock Exam

Mock Exam 1: Consolidated

25 questions, 60 minutes. 21 MCQ + fill-in-the-blank + match. Mirrors the real exam format.

25 Questions60 MinutesAnswer Explanations
⏱ 60:00
Q1 S1
Global real estate is estimated to be worth approximately:
Q2 S1
In the originate-to-distribute model (2007 crisis), the key problem was:
Q3 S1
A property has NOI of €2M. Cap rate expands from 4% to 5.5%. Value change:
Q4 S1
Which RE cycle phase has vacancy BELOW natural rate and accelerating rents?
Q5 S1
The five components of RE risk premium are:
Q6 S2
3.50% on actual/360 converted to actual/365 is:
Q7 S2
6% APR compounded monthly gives EAR of approximately:
Q8 S2
An inverted yield curve historically signals:
Q9 S2
PV of 3 annual cash flows of €100,000 at 3%:
Q10 S3
FRA notation '6/12' means:
Q11 S3
When yield curve has positive slope, forward rates are:
Q12 S3
Synthetic forward replication (borrow long, lend short) eliminates:
Q13 S3
For a RE project in Spain, discount rate starts with:
Q14 S4
The Housing Affordability Index (HAI) measures:
Q15 S4
In stock-flow model, new construction occurs only when:
Q16 S4
Net absorption is NEGATIVE when:
Q17 S4
Three types of developer expectations:
Q18 S5
RICS Market Value requires:
Q19 S5
Placing purchase price in Year 1 instead of Year 0 in a DCF:
Q20 S5
Bullet loan vs amortising (same size/rate): which pays MORE total interest?
Q21 S5
In a triple net lease (NNN), the tenant pays:
Q22 S5
REITs typically trade at a discount to NAV because:
Q23 S6
PV of perpetuity: €100,000/year at 4%:
Q24 S6
Discount factor = 0.9524, PV = €1,000,000. Future value:
Q25 S6
Interpolate: 3% for 182 days, 4% for 365 days. Rate for 300 days:
Mock Exam

Mock Exam 2: Numericals Only

25 calculation questions from the formulae sheet. Full worked solutions. Click Start to begin.

25 Questions60 MinutesAnswer Explanations
⏱ 60:00
Q1 TVM
FV of €500,000 at 5% simple interest for 270 days (actual/365):
Q2 TVM
Discount factor for 2 years at 6% compound:
Q3 TVM
Convert 5% annual compound to continuous rate:
Q4 TVM
PV of €1M in 3 years at 8% compound:
Q5 FWD
6m spot = 2.36%, 12m spot = 2.79% (simple, A/360). 6/12 forward rate:
Q6 FWD
3m spot = 2.25%, 12m spot = 2.75%. Forward 3/6 rate:
Q7 FWD
Interpolate: 90-day = 2.00%, 360-day = 3.50%. 180-day rate:
Q8 FWD
FV compounded with a negative rate is:
Q9 LOAN
Annual PMT on €1M loan at 5% for 20 years (French amortisation):
Q10 LOAN
€40M bullet loan at 4% for 10 years. Total interest paid:
Q11 LOAN
Monthly PMT on €300,000 at 6% APR for 30 years:
Q12 LOAN
€500,000 loan at 4% APR monthly. First month's interest:
Q13 RET
Property: €5M, NOI = €300,000. Cap rate:
Q14 RET
COCR: Equity = €1.5M, annual cash flow after debt service = €120,000:
Q15 RET
GRM: Price = €2M, annual gross rent = €160,000:
Q16 RET
Buy €10M, sell €13M after 5 years (no interim CFs). CAGR:
Q17 DEBT
Property €8M, loan €5.2M. LTV:
Q18 DEBT
NOI = €900,000, debt service = €680,000. DSCR:
Q19 DEBT
Income €60,000/yr. Max mortgage at 28% DTI:
Q20 VAL
NOI = €3.5M, exit cap rate = 4.25%. Residual value:
Q21 VAL
Term & Reversion: contract rent €200K/yr, lease 5 years, yield 6%. Term value:
Q22 VAL
Static residual: Sale €7M, construction €3M, expenses €500K, profit €1M. Land value:
Q23 VAL
Replacement cost: Land €1M, construction €3M, depreciation €750K. Market value:
Q24 VAL
Comparables [€2000,2500,2100,2450,2050,2000]/m² with weights [0.10,0.25,0.13,0.30,0.12,0.10]. Weighted value:
Q25 VAL
In French amortisation, the principal portion of each payment:
Mock Exam

Mock Exam 3: Balanced

25 questions, 60 minutes. 21 MCQ + 1 fill-in-the-blank + 1 match + 2 MCQ. 70/30 theory-numerical split.

25 Questions60 MinutesBalanced Coverage
⏱ 60:00
Q1 S1
RE is considered a heterogeneous asset class primarily because:
Q2 S1
The "originate-to-distribute" model created moral hazard because:
Q3 S2
Which compounding method produces the highest future value for the same nominal rate?
Q4 S3
In a French amortisation loan, the total payment (cuota) is:
Q5 S4
Which of the following is an exogenous determinant of RE demand?
Q6 S2
The discount factor for 180 days at 2% annual rate (simple interest, ACT/360) is:
Q7 S4
The cobweb model in RE markets describes:
Q8 S5
The RICS Red Book defines Market Value as:
Q9 S1
ESG in RE primarily impacts value through:
Q10 S5
Dual recourse in covered bonds means:
Q11 S5
NOI = €400,000. Cap rate = 5%. Property value is:
Q12 S3
The Debt Service Coverage Ratio (DSCR) is calculated as:
Q13 S5
A higher exit cap rate compared to entry cap rate reflects:
Q14 S1
A SOCIMI (Spanish REIT) benefits from 0% corporate tax if:
Q15 S4
Tobin Q > 1 in RE markets signals:
Q16 S2
Perpetuity: annual CF = €200,000, discount rate = 4%. PV is:
Q17 S5
COCR: Annual before-tax CF = €60,000, equity invested = €500,000. COCR is:
Q18 S2
Compounded annual return: buy at €2M, sell at €2.8M after 5 years. CAGR is:
Q19 S5
The Residual Method of valuation is most appropriate for:
Q20 S3
The yield curve is inverted. This typically signals:
Q21 S1
RE tokenization enables all of the following EXCEPT:
Q22 S2 • Fill-in-the-Blank
The present value of a perpetuity of €100,000 given a 4% rate is €____________.
Q23 S5 • Match
Match each valuation method to its primary approach:
Comparative Method
Income/DCF Method
Cost Method
Residual Method
Q24 S3
A property has NOI of €600,000 and annual debt service of €450,000. The DSCR is:
Q25 S5
GIM: Property sold for €3M, annual gross income €200,000. GIM is:
Mock Exam

Mock Exam 4: Valuation & Maths Heavy

25 questions, 60 minutes. Heavier on valuation methods and numerical calculations. 21 MCQ + 1 fill-in-the-blank + 1 match + 2 MCQ.

25 Questions60 MinutesValuation Focus
⏱ 60:00
Q1 S2
Future value of €50,000 at 6% compound interest for 5 years:
Q2 S5
DCF: NOI year 1 = €300k, year 2 = €310k, exit value at year 2 = €6M, r = 8%. PV is:
Q3 S3
Monthly PMT on €500,000 at 3.5% for 25 years (French amortisation):
Q4 S5
Cap rate compression from 6% to 4.5% on NOI of €1M. Value change:
Q5 S5
The four valuation methods recognised by RICS are:
Q6 S2
Interpolated rate: 90-day rate = 2%, 365-day rate = 3%. Rate for 200 days:
Q7 S5
Term & Reversion: when current rent is BELOW market rent, the "term" represents:
Q8 S3
Bullet loan €1,000,000 at 4% for 15 years. Total interest paid:
Q9 S5
In the Hardcore/Top Slice method, the "hardcore" layer represents:
Q10 S5
ROE: Annual net income = €120,000. Equity = €800,000. ROE is:
Q11 S2
Forward rate 3x6 with 3-month spot = 1.5% and 6-month spot = 2.0% (simple, annualised). The forward rate is approximately:
Q12 S1
The RE cycle phase where vacancy falls BELOW natural rate and rents accelerate is:
Q13 S5
Residual Value: NOI year 6 = €500k. Exit cap = 6%. Inflation = 1.5%. RV is:
Q14 S3
LTV = 70%, property value = €2M. Loan amount and equity required:
Q15 S5
The comparative valuation method adjusts for differences in:
Q16 S2
The PV of an annuity of €80,000/yr for 15 years at 5% is closest to:
Q17 S5
Levered IRR is higher than unlevered IRR when:
Q18 S1
Sareb was created to:
Q19 S5
The Effort Rate measures:
Q20 S2
Simple annualised return: €1M invested, €1.5M received after 6 years. SAR is:
Q21 S5
In the Proyecto Helvetia case, the branded residence premium over ultra high-end apartments was approximately:
Q22 S5 • Fill-in-the-Blank
A property with NOI of €750,000 and a cap rate of 5% has a value of €____________.
Q23 S3 • Match
Match each debt metric to its formula:
LTV
DSCR
DTI
Effort Rate
Q24 S5
A property's exit cap rate is set at 50bps above entry because:
Q25 S2
The discount factor for 1 year at 5% compound rate is:
Section 06Practice Questions
Numerical Practice

RE Formulae - Practice Questions

20 numerical MCQs at medium and hard difficulty. All questions use only the REF formulae sheet. Select your answer, then check at the bottom.

20 QuestionsMedium & HardFormulae Sheet Only
✎ Untimed Practice
Q1 Medium
Future value of €250,000 at 4.5% compound interest for 8 years:
Q2 Medium
Discount factor for 270 days at 2.5% annual rate (simple interest, ACT/360):
Q3 Medium
Continuous compounding: FV of €500,000 at 3% for 5 years:
Q4 Hard
PV of an annuity: €120,000/year for 25 years at 7%. Value:
Q5 Medium
Interpolated rate: 90-day rate = 1.5%, 360-day rate = 3.0%. Rate for 180 days:
Q6 Hard
Forward rate: 6-month spot = 2.0%, 12-month spot = 3.0% (simple interest). The 6-month forward rate starting in 6 months is:
Q7 Hard
Forward rate: 3-month spot = 1.0%, 9-month spot = 2.5% (simple interest). The 6-month forward rate "3x9" is:
Q8 Medium
Monthly payment on €400,000 French amortising loan at 3% for 20 years:
Q9 Medium
Bullet loan: €600,000 at 3.5% for 15 years. Total interest paid over the life:
Q10 Hard
French loan: €500,000 at 4% for 25 years. In the FIRST month, how much is principal vs interest?
Q11 Medium
COCR: Annual before-tax CF = €72,000. Total equity invested = €480,000. Cash-on-cash return:
Q12 Medium
CAGR: Purchase at €4M, sale at €5.6M after 4 years. Compounded annualised return:
Q13 Hard
Payback period: Equity investment = €2,400,000. After-tax annual CF = €320,000. How many years to recover equity?
Q14 Hard
GIM: Property sold for €4,500,000. Annual gross income = €280,000. A second property has GIM of 18x. Which is cheaper per unit of income?
Q15 Medium
Property value = €3,200,000. Loan = €2,240,000. LTV and equity:
Q16 Hard
NOI = €420,000. Annual debt service = €350,000. The lender requires DSCR ≥ 1.3x. Does the deal pass?
Q17 Hard
DCF: NOI years 1-3: €400k, €415k, €430k. Exit cap 5.5%, inflation 2%. Discount rate 8%. PV of the property:
Q18 Hard
Residual Value: NOI year 11 = €900,000. Discount rate 9%, growth 2%. RV at year 10:
Q19 Hard
Term & Reversion: Current rent €100k, market rent €150k, lease expires in 4 years, r = 6%. Term value:
Q20 Hard
Cap rate expansion: NOI = €1.2M. Entry cap = 4.5%, exit cap = 5.0%. What is the value loss from cap rate expansion?
Reference

Glossary

Key terms from all 15 sessions, organised by topic block. Each entry includes a definition and the session where it is first introduced.

Foundations & Asset Types

S1–S2
A – C
TermDefinitionSession
Air rightsOwnership of the space above a parcel of land, up to a regulated maximum (typically 300m). Can be sold or leased independently of surface rights.S1
All-Risks Yield (ARY)A single capitalisation rate that implicitly accounts for all risks, growth expectations, and depreciation. Used in the income capitalisation approach. V = NOI / ARY.S7
Alternative assetsReal estate sectors outside traditional office/retail/industrial: data centres, student housing, healthcare, hotels, storage, senior living. Often higher yield due to operational complexity.S1
Asset marketWhere ownership claims on real estate are traded (investment market). Determines capital values. Distinct from the space market where occupiers pay rent for use.S5
Brown discountThe price reduction applied to assets with poor ESG credentials (low EPC rating, no sustainability certification). Counterpart to the green premium.S1, S2
Cap rate (Capitalisation Rate)NOI divided by asset value. The fundamental income-based yield metric. Cap Rate = NOI / V. Rising cap rates = falling values (all else equal).S1, S4
Capital stackThe hierarchy of financing instruments in a real estate deal, from senior debt (lowest risk, first claim) through mezzanine to preferred equity and common equity (highest risk, residual claim).S1, S12
COCR (Cash-on-Cash Return)Annual pre-tax cash flow divided by total cash invested. Measures cash yield on equity. Also called Equity Dividend Rate. Excludes capital appreciation.S1
Core strategyInvestment in high-quality, stabilised, prime assets with low leverage. Target returns 5–8% IRR. Lowest risk profile on the Core→Distress spectrum.S1
D – G
TermDefinitionSession
Debt Service Coverage Ratio (DSCR)NOI divided by annual debt service (interest + principal). Must exceed 1.0 for income to cover debt. Banks typically require DSCR ≥ 1.20–1.25.S1, S9
DiPasquale-Wheaton (Four Quadrant)Model linking the space market (Q1: rents), asset market (Q2: values), construction market (Q3: new supply), and stock adjustment (Q4). Explains structural RE cycles.S11
Distressed strategyInvestment in troubled assets, NPL portfolios, or recovery markets. Target returns 20%+. Highest risk; requires specialist workout expertise.S1, S12
Dual recourseThe structural feature of covered bonds: investors have a claim against both the issuing bank AND the cover pool of mortgages. Distinguishes covered bonds from MBS.S9, S10
Effort RateMonthly mortgage payment divided by gross monthly income. Lender affordability threshold. Standard maximum: 30–35%. REFM: at 35%, a €4,435/month PMT requires €152k annual salary.S1, S9
EPC (Energy Performance Certificate)EU regulatory rating from A (best) to G (worst) indicating building energy efficiency. G-rated assets face stranded asset risk post-2028 as minimum standards tighten.S1
Equity Dividend RateSee COCR. Annual before-tax cash flow divided by total equity invested.S1
GDV (Gross Development Value)Total anticipated sales revenue (residential) or capitalised rental income (commercial) from a completed development. The starting point of the Residual Method.S8, S13
GIM (Gross Income Multiplier)Purchase price divided by gross annual rent. Quick valuation heuristic. Does NOT account for operating expenses. GIM = 1 / Gross Initial Yield.S1
Green premiumThe additional rent or capital value achievable for a sustainably certified asset vs an equivalent non-certified building. LEED Platinum: typically 7–12% value premium (JLL data).S1
I – R
TermDefinitionSession
IRR (Internal Rate of Return)The discount rate that makes NPV = 0 across all cash flows in a deal. The primary time-weighted return metric. Unlevered IRR uses pre-debt flows; levered IRR uses post-debt flows.S1, S10
LTV (Loan-to-Value)Loan amount divided by asset value. Primary measure of leverage. Banks use LTV covenants; development loans use LTC (Loan-to-Cost) instead.S1, S9
NOI (Net Operating Income)Effective Gross Income minus operating expenses (management fees, insurance, maintenance, rates). Excludes debt service, depreciation, and capital expenditure. V = NOI / Cap Rate.S4, S7
NPL (Non-Performing Loan)A loan where the borrower has missed scheduled payments (typically 90+ days in arrears). In RE, the underlying property is the key recovery asset.S12
Opportunistic strategyHigh-risk, high-return RE investing: development, major repositioning, distressed acquisitions. Target IRR 15%+. Proyecto Helvetia is an opportunistic development deal.S1, S13
REIT (Real Estate Investment Trust)A listed company owning income-producing RE that provides stock-market liquidity to RE exposure. Qualifying rules: typically 80%+ qualifying assets, mandatory distribution of taxable income. Spain: SOCIMI.S1, S11
Residual MethodValuation method for development land: Land Value = GDV − Construction costs − Finance costs − Professional fees − Developer profit. Works backwards from completed value to justify land price.S8, S13
ROI (Return on Investment)(Income − Expenses) / Investment. Simple income-based return metric. Does not account for time value of money or leverage.S1
ROE (Return on Equity)Annual income divided by equity invested. Reflects the return to the equity portion of the capital structure after debt service.S1
S – Z
TermDefinitionSession
SAREBSpain’s “bad bank” created November 2012 to absorb toxic RE assets from nationalised banks (peak €50B+ of assets). The course was Director of Risk & Valuations 2013–2017.S2
SOCIMISociedad Anónima Cotizada de Inversión en el Mercado Inmobiliario. Spain’s REIT equivalent, created 2009. Requires 80%+ qualifying RE assets.S1, S11
Space marketWhere occupiers (tenants and owner-occupiers) demand physical space. Rents are set here by supply/demand for sq m. Distinct from the asset market where investors trade ownership claims.S5
Value-Add strategyInvestment targeting assets with identified upside through active management: refurbishment, re-leasing, change of use. Target IRR 10–15%. Medium risk/leverage.S1
Yield compressionA fall in the cap rate, implying rising asset values (when NOI is constant). Occurred 2020–21 as ECB held rates near zero. Reversed 2022–23 as ECB raised rates to 4.5%.S1, S2
Yield expansionA rise in the cap rate, implying falling asset values. Happened across European RE 2022–24 as interest rates rose sharply.S2, S7

Real Estate Mathematics

S3–S4
Interest Rates & Discount Functions
TermDefinitionSession
Act/360Day count convention: actual calendar days / 360. Used in US money markets and some derivative contracts.S3
Act/365Day count convention: actual calendar days / 365. Standard in RE finance and the course's REFM exercises. Use this unless stated otherwise.S3
Discount factor (DF)The present value of €1 receivable at a future date. DF = 1 / (1 + r×t) for simple interest. Always < 1 for positive rates. REFM: 1%, 90d, Act/365 → DF = 0.99754.S3
Discount functionA curve mapping each future date to its discount factor. Constructed from market spot rates using interpolation between observable tenors.S4
Forward rateThe implied interest rate for a future period, derived from two spot rates using the no-arbitrage condition. REFM Exercise 4: r(90d)=4%, r(120d)=4.75% → f(90,120) ≈ 8.14%.S4
Linear interpolationMethod for estimating an intermediate rate between two known tenor/rate pairs: r(t) = r1 + (r2−r1) × (t−t1)/(t2−t1). REFM Exercise 2: r(100d) ≈ 1.33% between 1% at 90d and 2% at 120d.S3
No-arbitrage conditionThe principle that investing for 2 years at the 2-year spot rate must give the same return as rolling over the 1-year spot rate into the 1-year forward rate. Ensures no riskless profit exists.S4
Present Value (PV)The current value of a future cash flow, discounted at the required return. PV = CF / (1+r)^t. Sum of PVs = NPV. REFM Exercise 3: 5×€500k at 4% YTM = €2,225,910.S3, S4
Simple interestInterest calculated only on the principal: FV = PV × (1 + r×t). Used for periods under 1 year (money market). Contrast with compound interest used for multi-year horizons.S3
Yield curveA graph of interest rates vs maturity. Normal (upward): growth expected. Inverted: recession priced in. Flat: transition. Humped: near-term rise then cuts. Shape critically affects RE cap rate spreads.S3
YTM (Yield to Maturity)The constant discount rate that equates the PV of all future cash flows to the current price. Assumes flat yield curve - same rate applied to all maturities.S3

RE Economics

S5–S6
Demand & Supply Determinants
TermDefinitionSession
Construction lagThe 2–5 year gap between a development decision and completion. Means new supply always responds to past conditions, not current ones. Primary cause of RE boom-bust cycles.S6
Demand amplificationThe process by which price expectations and credit availability drive RE demand beyond fundamental levels. Mechanisms: Shiller irrational exuberance, procyclical lending, foreign capital inflows.S5
Endogenous determinantsDemand/supply factors internal to the asset: location, quality, price, lease terms, amenities (demand-side); construction costs, planning (supply-side). Can be influenced by the owner/developer.S5
Exogenous determinantsDemand/supply factors external to any individual asset (macro forces): market size/population, income/GDP, substitute prices, expectations. from the course materials slide p.35.S5
Hypersupply phaseStage 3 of the RE cycle: new supply arrives faster than demand absorption, pushing vacancy up and rents down even while the broader economy may still be growing.S2, S6
Price elasticity of demand% change in quantity demanded / % change in price. Inelastic demand (residential, logistics) means supply shortfalls create outsized price spikes. Elastic demand (discretionary retail) adjusts to price changes.S5
Procyclical lendingBanks loosening credit standards during booms (rising prices → higher collateral → more lending → higher prices) and tightening in downturns. Amplifies both upswings and crashes.S5
RE cycle phasesRecovery → Expansion → Hypersupply → Recession. Each phase has distinct vacancy, rent, and construction characteristics. Supply lag means phases last 3–7 years typically.S2, S6
Shiller bubbleA RE price bubble driven by irrational expectations and self-reinforcing narratives rather than fundamentals. Named after Nobel laureate Robert Shiller who identified US housing overvaluation in 2003.S5
Supply elasticityThe responsiveness of new supply to price signals. Logistics: high elasticity (greenfield land available, fast planning). Residential in constrained cities: very low (planning restrictions, infrastructure costs).S6

Valuation

S7–S8
Types of Value & Valuation Methods
TermDefinitionSession
Comparative MethodValuation by analysing recent transactions of comparable properties, adjusted for differences in location, size, condition, and lease terms. Most appropriate for liquid, homogenous markets.S7, S8
DCF (Discounted Cash Flow)Valuation method projecting explicit cash flows (NOI, capex, terminal value) over a hold period and discounting at WACC or required return. NPV = ∑[CF(t)/(1+r)^t]. Best for irregular cash flows.S7, S8
Exit cap rateThe capitalisation rate applied to the terminal year NOI to estimate the asset’s sale price at the end of the hold period. Typically set 25–50bps above entry cap to reflect asset ageing and uncertainty.S4, S8
Fair ValueIFRS accounting concept: the price at which an asset would be exchanged between knowledgeable, willing parties. Similar to Market Value but used in financial reporting contexts.S7
Forced Sale ValueEstimated proceeds from a sale conducted under time pressure without adequate marketing. Always below Market Value. Used in distressed scenarios and receivership valuations.S7
GIY (Gross Initial Yield)Passing rent / purchase price. A quick measure of income return on cost. Does NOT deduct purchaser costs or operating expenses. Contrast with NIY and cap rate.S7
Income CapitalisationV = NOI / Cap Rate (or ARY). Direct capitalisation of stabilised income. Simple but requires accurate comparable evidence for the cap rate. Best for stabilised, income-producing assets.S7, S8
Investment ValueThe value of an asset to a specific investor given their required return, tax position, and portfolio synergies. May differ from Market Value when the investor has above/below-market cost of capital.S7
Market ValueRICS Red Book definition: the estimated amount for which an asset should exchange between willing buyer and seller in an arm’s-length transaction with adequate marketing time and no compulsion.S7
Market RentThe estimated amount at which a property should be leased at the valuation date between a willing landlord and willing tenant. Basis for ERY (Estimated Reversion Yield) in reversionary valuations.S7
RICS Red BookRICS Valuation - Global Standards. The authoritative professional standard for valuers worldwide. Defines bases of value, valuation approaches, and professional conduct requirements.S7
Terminal Value (TV)The assumed sale price of an asset at the end of a DCF hold period. TV = NOI(exit year) / Exit Cap Rate. Often represents 60–80% of total DCF value for long-hold investments.S4, S8

Financial Products & Debt

S9–S10
Mortgages, MBS & Structured Finance
TermDefinitionSession
ABS (Asset-Backed Security)A security backed by a pool of non-mortgage assets (auto loans, credit cards, trade receivables). Same tranching structure as MBS. Generic term that includes MBS as a sub-category.S9
Amortising loanA mortgage where each payment covers both interest and principal, reducing the balance over time. Monthly PMT = PV × r(1+r)^n / [(1+r)^n − 1]. Balance reaches zero at maturity.S9
Bullet loanInterest-only mortgage: monthly payments = principal × annual rate / 12. Full principal repaid as a balloon payment at maturity. REFM: €800k at 3% for 20yr = €2,000/month, €480k total interest.S9
CDO (Collateralised Debt Obligation)A structured product backed by a pool of debt instruments (including MBS tranches). CDO-squared stacks CDOs on CDOs. Opacity and correlation mispricing made these a primary GFC amplifier.S9
Cédula hipotecariaSpanish covered bond backed by the issuing bank’s entire mortgage portfolio. Has dual recourse (issuer + cover pool). The dominant Spanish bank funding instrument for RE lending.S10
CMBS (Commercial Mortgage-Backed Security)MBS backed by commercial property loans (office, retail, industrial, hotel). Higher individual loan sizes and more bespoke underwriting than RMBS. Loan-level analysis required.S9
Covered bondBank-issued bond backed by a dynamic cover pool of mortgage loans. Dual recourse: investors claim against both issuer and pool. Structural safety vs MBS: cover pool actively managed; issuer remains on hook.S10
Mezzanine debtSubordinated debt sitting between senior debt and equity in the capital stack. Typically 8–14% rate, often PIK (interest compounds to exit). Higher risk than senior, lower than equity.S10, S12
MBS (Mortgage-Backed Security)A security backed by a pool of mortgage loans. Securitisation chain: originate → pool → SPV → tranche → rate → sell → service. Tranching redistributes but does not eliminate credit risk.S9
NNN (Triple Net) leaseA lease where the tenant pays base rent PLUS property taxes, insurance, and maintenance. The landlord receives truly net income with no cost uncertainty. Trades at tighter cap rates.S10
Originate-to-distributeBanking model where mortgages are originated, packaged, and sold to capital markets. Removes long-run credit risk from originators - destroyed underwriting incentives pre-GFC.S2, S9
PIK (Pay-in-Kind)Interest that accrues and compounds rather than being paid in cash. Used in mezzanine and development finance where assets generate no current income. Paid in full at exit from sale proceeds.S10, S12
PMTThe constant periodic payment in an amortising loan. PMT = PV × r(1+r)^n / [(1+r)^n − 1] where r = periodic rate and n = number of periods. REFM: €300k at 4%/12 for 240 months ≈ €1,818/month.S9
RMBS (Residential Mortgage-Backed Security)MBS backed by pools of residential mortgages. Highly standardised loans enable large, diversified pools. US subprime RMBS were the GFC ground zero product.S9
S&L (Sale & Leaseback)A transaction where an owner-occupier sells a property and simultaneously leases it back. Unlocks capital while retaining operational use. REFM: 40,000m², $25/m² NNN, 6.25% cap → $19.2M price.S10
SPV (Special Purpose Vehicle)A legally separate entity created to isolate assets in a securitisation. Bankruptcy-remote: its assets are shielded from the originating bank’s balance sheet. Step 2 of the MBS chain.S9

Capital Markets & Returns

S11–S12
REITs, Private Equity & NPLs
TermDefinitionSession
Bridge loanShort-term financing (typically 12–36 months) used to fund an acquisition while longer-term finance is arranged. Helvetia: €52M bridge at EURIBOR+2.15%, repaid by construction loan drawdown.S10, S13
Carry (Carried interest)The GP’s profit share (typically 20%) on returns above the hurdle rate in a RE fund. Aligns GP incentives with LP performance. Only earned after LPs recover capital + preferred return.S12
Cash-on-Cash multiple (CoC)Total equity returned / total equity invested. Helvetia: 1.65x net CoC (€112.2M returned on €68M invested). A time-unadjusted measure of total capital recovery.S1, S13
ETF (Exchange-Traded Fund)A listed fund tracking an index, providing intraday liquidity. RE ETFs: iShares US Real Estate (IYR) tracks physical RE companies; iShares Mortgage RE (REM) tracks mortgage REITs and MBS holders.S11
GP (General Partner)The fund manager in a limited partnership structure. Makes investment decisions, typically co-invests 1–5%, earns management fees (1.5–2% p.a.) and carried interest.S12
Gross IRR vs Net IRRGross IRR: return before management fees and carry. Net IRR: after all fees and GP carry. Helvetia: 22.7% gross vs 18.8% net - a 3.9pp gap representing fund costs.S13
Hurdle rateThe minimum IRR LPs must receive before the GP earns carried interest. Typically 8% in private RE funds. Ensures GP only profits after LPs achieve an acceptable return.S12
Loan-to-ownNPL investment strategy: acquire the distressed loan at a discount, then enforce security to take title to the underlying RE asset. Goal: buy property below market value via debt mechanism.S12
LP (Limited Partner)Institutional investor (pension fund, insurance co., SWF) committing capital to a RE fund. Passive; limited liability; receives distributions and NAV appreciation; no day-to-day investment decisions.S12
LTC (Loan-to-Cost)Loan amount / total project cost. Used for development finance underwriting. Distinct from LTV which uses asset value. Helvetia: bridge loan 50.2% LTC; construction loan up to 70% LTC.S10, S13
WaterfallThe distribution sequence in a multi-tranche deal. Senior debt repaid first, then mezzanine, then equity. REFM: exit €26M → senior €12.6M → mezz €4.48M → equity €8.92M (2.23x CoC).S10, S12
Whole loanA single lender providing debt across the full LTV range (e.g. 0–80%), then selling down slices. Simplifies execution for the borrower; lender earns origination premium.S12

Proyecto Helvetia Key Terms

S13–S14
Branded Residences & Deal Mechanics
TermDefinitionValue in Deal
Branded residenceA luxury residential unit carrying a five-star hotel brand (e.g. Four Seasons, Mandarin, W). Commands a significant premium over equivalent unbranded ultra-luxury product.+48.7% apartments, +71.3% penthouses vs Four Seasons comps
GDV (Gross Development Value)Total net sales revenue from all 34 residences in Helvetia.€237.9M (€22,599/sqm avg)
Gross IRRReturn on equity before management fees and carried interest.22.7%
Net IRRReturn after all fees, carry, and transaction costs.18.8%
Net CoC multipleTotal net equity returned / equity invested.1.65x (€68M invested → €112.2M returned)
Acquisition priceBuilding purchase at closing (June 2024).€103.5M (€9,095/sqm on total area basis)
Bridge loanAcquisition financing at closing.€52M at EURIBOR+2.15% (50.2% LTC)
Construction loanDevelopment financing drawn progressively as work progresses.€82M at EURIBOR+2.5% (70% of constr. cost)
Equity injectedSponsor and co-investor equity.€68M (~40% of total project cost)
Permitting phasePeriod from acquisition to construction start awaiting planning consent.20 months (M0–M20)
Construction phaseActive demolition, refurbishment, and fit-out period.24 months (M20–M44)
Delivery / exitUnit handovers, loan repayment, equity distributions.Month 47 (~2028)
Section 06 · 7 Sub-sections

RE Formulae

Complete formulae reference with interactive mini-simulators. Each sub-section covers a formula family.

7 FamiliesInteractive SimsExam Cheat Sheet

Section Map

Click any card to jump in
6.1

Time Value of Money

PV, FV, discount factors, compounding types, day count conversions

Simulators
6.2

Yield Curves & Forward Rates

Spot rates, forward rate formula, interpolation

Simulators
6.3

Loan Mathematics

PMT formula, bullet vs amortising, monthly conversion

Simulators
6.4

Return Metrics

Cap rate, COCR, GIM, ROI, IRR, leveraged IRR

Simulators
6.5

Debt Metrics

LTV, DSCR, DTI, effort rate, equity calculation

Simulators
6.6

RE Valuation Formulae

NOI, residual value, DCF PV, cap rate decomposition

Simulators
6.7

Capitalisation & Comparison

Term & reversion, perpetuity, homogenisation, offer adjustment

Simulators

1 - Time Value of Money

Deck p.2
Compounding Factors (Future Value) Deck p.2
Simple Interest: FV = 1€ × (1 + i × yf) Compound Interest: FV = 1€ × (1 + i)yf Continuous Interest: FV = 1€ × ei×yf Where: i = annual rate, yf = year fraction (time in years)

⚙ Mini-Simulator: Compounding Comparison

Discount Factors (Present Value) Deck p.2
Simple Interest DF: PV = 1€ / (1 + i × yf) Compound Interest DF: PV = 1€ / (1 + i)yf Continuous Interest DF: PV = 1€ × e−i×yf Discount Factor = 1 / Compounding Factor - always between 0 and 1 Higher rate or longer time → smaller DF → money today is worth more
💡
Key intuition: Discounting is compounding in reverse. The DF tells you what €1 received in the future is worth today. In RE valuation, every future NOI cash flow is multiplied by its DF to get its present value. The sum of all discounted cash flows = the property value.
PV of Cash Flow Streams & Perpetuity Deck p.3
PV of a series of cash flows: PV = Σ Fᵢ / (1+r)tᵢ = Σ Fᵢ × DFᵢ PV of constant annuity (F identical each period): PV = F × [1 − 1/(1+r)t] / r Perpetuity (infinite constant cash flow): PV = F / r The perpetuity formula is the foundation of the cap rate: Value = NOI / Cap Rate is just PV = F / r Finding the required cash flow from PV: F = PV / DF (single cash flow)

⚙ Mini-Simulator: Perpetuity & Annuity

2 - Yield Curves & Forward Rates

Deck p.4
Interpolation & Forward Rate Formulas Deck p.4
Linear Interpolation (finding a rate between two known points): zᵢ = z₁ + [(z₂ − z₁) / (d₂ − d₁)] × (dᵢ − d₁) z = rate, d = date/tenor. Used when you know 1Y and 2Y rates but need the 1.5Y rate. Forward Rate (rate implied between two future dates): f₁→₂ = [(1 + r₂×yf₂) / (1 + r₁×yf₁) − 1] × 1/yf₁→₂ The forward rate is the market’s implied rate for a future period. If the 1Y rate is 3% and the 2Y rate is 3.5%, the implied 1Y rate one year forward must be approximately 4% to make both investments equivalent.

⚙ Mini-Simulator: Forward Rate

3 - Loan Mathematics

Deck p.4
PMT & Notional Formulas Deck p.4
Payment (PMT) - fixed periodic payment on an amortising loan: P = [Rate/m × N × (1 + Rate/m)n×m] / [(1 + Rate/m)n×m − 1] Notional (N) - loan amount affordable for a given payment: N = P × [1 − (1 + Rate/m)−n×m] / (Rate/m) Where: Rate = annual interest rate, m = payments per year, n = years This is the French amortisation formula - constant total payment, declining interest, rising principal.

⚙ Mini-Simulator: Loan PMT & Max Notional

4 - Return Metrics

Deck p.5
All Return Formulas + Dashboard Link Deck p.5
Cash on Cash Return (COCR): COCR = Annual before-tax CF / Total CF invested Income Return (ROI): ROI = (Income − Expenses) / Expenses Return on Equity (ROE): ROE = Annual Income / Equity Gross Income Multiplier (GIM): GIM = Sale Price / Annual Income (lower = cheaper relative to income) Exit Yield / Cap Rate: Exit Yield = NOI / Exit Value Payback Period: Payback = Equity Investment / After-tax Annual CF Period Return: (FV / PV) − 1 Simple Annualised Return: ((FV / PV) − 1) / T Compounded Annualised Return (CAGR): (FV / PV)1/T − 1 Internal Rate of Return (IRR): PV = Σ CFᵢ / (1 + IRR)tᵢ (the rate that makes NPV = 0) Leverage IRR: Same as IRR but using equity cash flows (after debt service) instead of total asset cash flows

5 - Debt Metrics

Deck p.5
Leverage, LTV, DTI & DSCR Deck p.5
Leverage: Leverage = Debt / Asset Value Loan to Value (LTV): LTV = Loan / Asset Value Typical max: 60–80% Debt to Income (DTI): DTI = Debt / Income Lender threshold: typically < 35% Debt Service Coverage Ratio (DSCR): DSCR = NOI / Debt Service Must be > 1.0; lenders want ≥ 1.20–1.50 DSCR < 1.0 means the property cannot cover its debt payments from income alone DSCR = 1.25 is a common minimum covenant in commercial RE lending

⚙ Mini-Simulator: Debt Metrics

6 - RE Valuation

Valuation Deck
Comparison Method Formulas Val. Deck p.19–24
Offer Price Adjustment (Step 3): Vcoa = Vco × β Vco = offer price, β = adjustment coefficient (usually < 1) Converts listed (offer) prices to theoretical closing prices Homogenisation Coefficient (Step 4): αn = ∏i=1n αi αi = individual factor adjustment for element i (location, age, quality, etc.) α < 1.00 = comparable is BETTER than subject α > 1.00 = comparable is WORSE than subject Homogenised Comparable Value: Vth = Vt × αn Asset Value (simple average): Va = Σi=1m Vth,i / m Asset Value (weighted): Va = Σ (wi × Vth,i) where Σwi = 1

⚙ Mini-Simulator: Comparison Homogenisation

DCF & Capitalisation Formulas Val. Deck p.25–34
Cap Rate (Capitalisation Rate): Cap Rate = NOI / Market Value Also: Cap Rate = Yield − g (where g = NOI growth rate) Direct Capitalisation (Perpetuity): Value = NOI / Cap Rate Residual Value (Terminal Value at exit): RV = NOIn × (1 + π*) / (r − g) π* = inflation, r = discount rate, g = growth rate, (r−g) = cap rate DCF Present Value: PV = Σi=1n (NOIi + RV) / (1 + r)ti NOIi projected with inflation; RV added to final period only IRR (Internal Rate of Return): Price = Σi=1n CFNi / (1 + IRR)ti IRR = discount rate that makes NPV = 0 IRR is the OUTPUT of actual flows; Discount Rate is the INPUT of a DCF

⚙ Mini-Simulator: Cap Rate & Direct Capitalisation

Residual Method Formulas Val. Deck p.38–43
Static Residual (Consolidated Land): Vv = Cc + Cs + De + Bd ⇒ Cs = Vv − (Cc + De + Bd) Vv = sales value of completed RE product Cc = construction cost (actual or potential) Cs = cost of land (the residual we solve for) De = development expenses (funding, professional fees, marketing) Bd = benefits of the development (developer profit margin) Replacement Cost (Cost Method): Gross RC = Land + Construction Cost + Required Expenses Net RC = Land + (Construction Cost − Depreciation) Depreciation = physical + functional obsolescence + economic obsolescence

7 - Capitalisation & Comparison Summary

Valuation Deck
Method Selection Quick-Reference Val. Deck p.17–18
Four Main Valuation Axes: 1. MARKET (Comparison) → Comparables → Offer & closing prices 2. FLOWS (DCF/Cap) → Discount CF, Residual value, Capitalisation → Flow projections & yields 3. COST (Replacement) → Reposition → Construction costs & depreciation 4. AVM (Automated) → Indices, Machine Learning → Prices & features Key Relationships: Cap Rate = NOI / Value = Yield − g Value (perp.) = NOI / Cap Rate = NOI / (r − g) Exit Value = NOIn+1 / Exit Cap Rate IRR = rate where NPV = 0 (price = PV of all cash flows) Land Value = GDV − Construction − Dev. Expenses − Dev. Profit
📝
Exam tip - interest rate impact: When interest rates rise, cap rates tend to rise, which means property values fall (Value = NOI / Cap Rate). This is the core transmission mechanism from monetary policy to RE markets. The slide deck shows this with a chart of US cap rates vs 10-year Treasury yields (2010–2023) - when Treasuries crossed above cap rates, investors stopped buying RE because risk-free returns exceeded property yields.
Real Estate Finance
· IMBA
P&H← By subject