DCF sensitivity: how to read the valuation scenarios in a property appraisal report

Published 27 July 2026 · Methodology · 13 min read · By D. Hamza

1. Why a serious DCF report always presents scenarios

The discounted cash flow method projects the future net income of an asset over an explicit horizon, then discounts it at a rate reflecting the risk, adding a terminal value at exit. We detail the mechanics in our case study on the DCF valuation of an office building. Every line of that calculation is an assumption about the future: rental growth, tenant behaviour, charges, exit conditions. None of these assumptions is certain.

The international standards draw the logical consequence. The RICS Red Book and the IVS require the assumptions of a valuation to be explicit, documented and traceable, and require the valuer to account for the uncertainty surrounding them — a principle that VPGA 10 of the Red Book (material valuation uncertainty) takes as far as a formal statement in disrupted market contexts. The sensitivity analysis is the tool that translates this requirement: it shows the reader what happens to the value when each key assumption departs from the central trajectory.

Concretely: a DCF report that delivers a single figure, with no scenarios and no sensitivity table, does not tell you whether that figure is robust (it withstands degraded assumptions) or fragile (it rests entirely on a favourable trajectory). For an investment committee, that difference is often worth more than the value itself.

2. Base, optimistic, pessimistic: what each scenario represents

The classic presentation retains three trajectories, built on the same model and the same horizon:

• Base (central) scenario. The set of assumptions the valuer judges most probable at the valuation date, in light of the actual tenancy schedule, the leases in place, the comparables and the dynamics of the local market. It is this scenario that carries the value conclusion of the report.
• Optimistic scenario. A reasoned and plausible upward flex: faster re-lettings, favourable rental reversion at renewals, compression of the required exit yield. This is not a dream scenario: every flexed assumption must remain defensible in light of the market.
• Pessimistic scenario. The symmetrical downward flex: prolonged vacancy, downward renegotiations, drifting charges, exit at a degraded yield. Here again, this is a plausible adverse scenario — not an extreme disaster scenario, which would belong to a separate stress test.

Concretely, the three trajectories flex the same variables, in coherent directions:

An essential reading point, often misunderstood: the optimistic and pessimistic scenarios are not alternative values among which the reader picks according to temperament. The concluded value is that of the base scenario. The other two measure the dispersion around that conclusion— in other words, the risk of the underlying asset. A seller who brandishes the optimistic scenario as “the value”, or a buyer who offers only the pessimistic one, are committing the same misreading.

3. The five key variables tested — and why those

Not all the assumptions of a DCF carry equal weight. In practice, five variables concentrate most of the sensitivity of an income-producing asset valuation:

A well-built report tests these variables in two complementary ways: one by one (univariate sensitivity: a single assumption is moved, all else equal, to identify those that dominate the result) then in coherent combination in the optimistic and pessimistic scenarios — because in reality, a deteriorating market moves several variables together: vacancy rises, re-letting rents fall and the exit yield softens simultaneously.

4. Reading the sensitivity table: normal spread and warning signs

The reader's first question: “is the gap between the pessimistic and the optimistic scenario normal?”. There is no universal spread: the legitimate range depends on the asset class, the firm term of the leases, the strength of the tenants and the liquidity of the local market. A building let long-term to solid covenants mechanically produces a tight range; an asset in repositioning, in short-term letting or dependent on a single tenant produces a wide range — and that width is information, not a defect of the report.

On the other hand, certain signals should trigger questions to the valuer:

• A wide range without documented justification. A large dispersion is acceptable if the report explains why (fragile tenancy schedule, shallow market, regulatory uncertainty). An unexplained dispersion signals a poorly mastered model.
• A value dominated by the terminal value. If most of the value comes from the resale at the end of the horizon rather than from the intermediate flows, the conclusion rests almost entirely on the exit cap rate — the most distant and least verifiable assumption. The report must then show the sensitivity of the value to that single parameter.
• An unexplained asymmetry. If the optimistic scenario departs much further from the base than the pessimistic one (or the reverse), you need to understand why: either the asset's risk profile is genuinely asymmetric (and the report must say so), or the flexes have been calibrated inconsistently.
• A base scenario that is already optimistic. A classic signal: instant re-letting of vacant space, systematic favourable reversion, no rent-free periods, frozen OPEX. If the “central” scenario assumes everything goes well, the real base scenario is in fact the displayed pessimistic one.
• Purely mechanical scenarios. Three columns obtained by uniformly shifting all assumptions one notch, with no link to the asset's actual tenancy situation, add nothing: the sensitivity must be specific to the property — which leases expire during the horizon, which tenants weigh in the income, which works lie ahead.
• A pessimistic scenario incompatible with the debt. For a financed asset, if the value in the adverse scenario falls below the debt level or puts the covenants under strain, the sensitivity table becomes a credit-risk management document — not merely a valuation one. That point must go up to the committee as is.

The attentive reader will also check the internal consistency of the scenarios: in a credible pessimistic scenario, you cannot degrade vacancy while keeping re-letting rents at the base-scenario level — the variables must move together, in the same direction the market would.

5. Deciding on this basis: investment committee, asset manager, owner

The sensitivity analysis is not an academic exercise: it is a decision tool. Depending on your position, it reads differently:

• Investment committee (acquisition). The offer price is calibrated against the base scenario, but the margin of safety is measured against the pessimistic one: at what price level does the deal remain acceptable if the adverse scenario materialises? A file whose thesis holds only in the optimistic scenario is not an investment, it is a bet.
• Lender and debt structuring. The sizing of the financing is tested against the pessimistic scenario: debt-service coverage in the degraded trajectory, holding of value covenants. The sensitivity to the exit cap rate directly illuminates the refinancing risk at the end of the period.
• Asset manager. The univariate sensitivity ranks the value-creation levers: if the model is dominated by occupancy, the priority is securing the leases and the re-letting plan; if it is dominated by OPEX, it is the charges and works plan. The sensitivity table is, in effect, an asset-management roadmap.
• Institutional owner (reporting, arbitrage). From one valuation campaign to the next, comparing the scenarios shows whether the asset's risk profile is tightening or deteriorating — information that a single value never gives, and which directly feeds arbitrage decisions and investor reporting, in the logic we describe for the IFRS 13 fair value of OPCIs and listed property companies.

In every case, the good practice is the same: question the valuer on their flexes. A Red Book-compliant valuer documents their choices and can defend them; that is precisely what distinguishes a valuation report from a mere spreadsheet. Here is the grid of questions we recommend running through in committee:

6. What the RICS / IVS framework requires — and what the report must contain

Reading the scenarios presupposes knowing what a compliant report must deliver. On the sensitivity side, keep four requirements in mind:

• An explicit basis of value. The DCF most often serves a Market Value (IVS 104) — but the same model can serve other bases depending on the assignment, as we explain in our guide to the RICS Red Book bases of value. The scenarios always read relative to the basis retained.
• Traceable assumptions. Every parameter of the base scenario must be anchored to a source: tenancy schedule, leases, comparables, dated market data. The flexes of the alternative scenarios must be justified in the same way.
• The distinction between assumptions and special assumptions. If a scenario rests on an event not secured at the valuation date (obtaining a permit, signing a lease under negotiation), the Red Book requires it to be qualified as a special assumption, clearly flagged as such.
• The material uncertainty statement where applicable (VPGA 10). In a disrupted market or on an atypical asset, the valuer must formally flag that the valuation uncertainty is higher than normal — the scenarios then give it a quantified, file-specific measure.

A final word on the status of the report: an independent appraisal informs an investment decision, a financing, a reporting exercise or an amicable negotiation. It is not to be confused with a court-ordered expertise, where the expert is appointed by the judge — the two uses are distinct and complementary.

7. FAQ

Note: A methodological article intended for investment committees, asset managers, lenders and institutional owners. Deliberately, no discount rate, cap rate, spread percentage or amount is put forward: these parameters are specific to each asset, dated and documented in the appraisal report — that is precisely the purpose of the sensitivity analysis. The references to the standards (RICS Red Book, IVS 104, VPGA 10) describe a framework whose application depends on your assignment: frame it with the valuer in the terms of engagement. To go further, see our property valuation services, browse the blog, or read the version française of this article.