This guide develops the lease, recovery, investment and reporting skills used in ARGUS Enterprise's EMEA discounted cash flow track. Sixteen selected-response questions test distinctions and calculations; four linked Harbour Court practical tasks build rent, recoveries, valuation and sensitivity from complete inputs. Sixty concepts explain the underlying mechanics with worked examples and common errors. Coverage follows the supplied public initial-certification and training listings for the syllabus reference date of 16 October 2026; no future version or software-specific interface is asserted. Sources establish exam format and domain relevance, while technical examples use explicit educational assumptions. This twenty-item preview is original practice, not a full-length mock or official question bank.
What this guide covers
Practise ARGUS EMEA DCF with 20 original questions, worked modelling tasks and 60 detailed study concepts.
EMEA discounted cash flow: Introduction to AE
1. Present value discounts dated cash flows
A discounted cash flow valuation converts future net receipts into an equivalent amount at the valuation date. With an effective annual discount rate r and a receipt C after t years, present value is C/(1+r)^t. Sum the separately discounted receipts and payments rather than discounting their total using one arbitrary date. The discount rate represents the required return under the selected cash-flow basis. A DCF therefore needs both amounts and dates; identical nominal totals can have different values when collection, expenditure or disposal timing changes.
Worked example: An office receives €108,000 after one year and €116,640 after two years. At an effective annual 8% required return, each receipt has a present value of €100,000. Together they support a €200,000 value before any other costs or receipts.
Common mistake: A larger undiscounted total does not necessarily imply a larger present value when its receipts arrive substantially later.
Official syllabus reference: [2]
2. Analysis dates define stub periods
The analysis start, reporting calendar and holding period determine which portions of leases and expenses enter each forecast period. A stub period is shorter than a complete reporting year, often because valuation begins between annual boundaries. Calculate the actual covered portion using the scenario's stated monthly or daily convention. Do not assume that a twelve-column report necessarily represents the first twelve months of ownership. The disposal date also determines the last operating receipt retained by the seller and the income period used for any forward-looking terminal valuation.
Worked example: A model begins on 1 October and reports to 31 December. Under equal-month proration, annual rent of €120,000 contributes €30,000 to that first calendar stub. A subsequent complete calendar year contributes €120,000 before reviews, incentives or other changes.
Common mistake: Treating the first displayed calendar year as twelve owned months overstates income when the valuation begins partway through that year.
Official syllabus reference: [2]
3. Dimensional checks connect area and rent
Unit-based inputs require dimensional consistency before any financial interpretation. Multiplying square metres by euros per square metre per year produces euros per year. Payment frequency then converts that annual entitlement into periodic amounts. Area may also have different definitions, such as lettable or gross building area, so matching physical units alone is insufficient when the measurement basis differs. Preserve the stated basis for each lease, market assumption and recovery denominator. Unit checks are particularly valuable when importing data whose rate period or area convention differs from the model.
Worked example: A lease covers 900 m² at €280/m²/year. Multiplication gives €252,000 annual rent, and division by twelve gives €21,000 per complete paying month. If the source rate were monthly instead, the annual amount would require a different conversion.
Common mistake: Matching the currency symbol does not establish consistency when one rent rate is annual and another is monthly.
Official syllabus reference: [2]
4. Currency is a measurement basis
A property's local currency identifies the monetary basis of its rent, expenses, investment and valuation inputs. A portfolio reporting currency is a separate translation choice. Record the direction and date of every exchange-rate assumption so that multiplication or division follows the quoted units. Translating a completed valuation at spot differs from projecting future local-currency receipts through dated exchange rates. The appropriate method depends on the requested reporting basis. Currency conversion should never silently change the underlying lease rate, expense growth or local contractual entitlement.
Worked example: A UK asset is valued at £4 million. A valuation-date report uses €1.18 per pound, producing €4.72 million. Its local lease remains £200,000 annually; presenting the value in euros does not rewrite the tenant's contractual payment obligation.
Common mistake: An exchange-rate quote cannot be applied reliably until its currency direction and relevant reporting date have both been identified.
Official syllabus reference: [2]
5. Nominal and real assumptions must agree
Nominal cash flows include assumed price inflation, while real cash flows express purchasing power relative to a chosen price date. Match nominal cash flows with a nominal discount rate and real cash flows with a real rate. Under a consistent simplified annual relationship, 1 plus nominal return equals 1 plus real return multiplied by 1 plus inflation. Rent growth may include market-specific changes beyond general inflation, so it should not automatically equal the inflation assumption. State the basis explicitly before comparing valuation outputs or transferring assumptions between models.
Worked example: Suppose real required return is 4% and assumed inflation is 2%. The equivalent nominal return is 1.04 × 1.02 − 1 = 6.08%. A forecast already escalating all relevant prices for inflation should use the corresponding nominal basis.
Common mistake: Discounting inflation-escalated cash flows at a real rate generally overstates value because the inflation component is omitted from the required return.
Official syllabus reference: [2]
6. Effective rates preserve compounding
An effective annual rate includes the effect of compounding within the year. A nominal annual rate requires a stated compounding frequency before it determines periodic discount factors. For nominal rate j compounded m times annually, the periodic rate is j/m and the effective annual rate is (1+j/m)^m−1. Conversely, an effective annual rate converts to a monthly rate through its twelfth root. These conversions preserve the same accumulation over a year. Dividing an effective annual rate by twelve generally does not provide an exactly equivalent monthly rate.
Worked example: A nominal annual 12% rate compounded monthly gives 1% monthly and approximately 12.6825% effective annually. A monthly DCF can use 1% per month, while an equivalent year-based exponent uses 12.6825% as the effective annual return.
Common mistake: The phrases nominal annual and effective annual describe different compounding conventions even when the displayed percentage happens to be identical.
Official syllabus reference: [2]
7. Payment timing changes discount exponents
Receipts in advance, receipts in arrears and year-end aggregation place otherwise identical money at different dates. Earlier positive receipts have higher present value under a positive discount rate. A year-end convention places all annual cash at the end of the year; a midpoint approximation places it halfway through. Neither approximation automatically reproduces a monthly lease schedule. Select the convention specified by the exercise or valuation basis, and apply it consistently to income, expenditure and disposal. Changing timing should be distinguishable from changing the required return.
Worked example: At a positive discount rate, twelve €10,000 month-end receipts have greater present value than one €120,000 year-end receipt. The difference arises because eleven receipts arrive earlier, even though both schedules collect exactly the same annual nominal amount.
Common mistake: An annual report total does not establish that its underlying receipts actually occur together at the reporting year's end.
Official syllabus reference: [2]
8. Growth assumptions need dated anchors
A growth rate cannot project an input correctly without a base amount, base date and first escalation event. Specify whether increases occur on calendar boundaries, lease anniversaries or another schedule. Apply only the events between the dated source assumption and the target date. Repeated percentage increases usually compound on the preceding amount unless the scenario specifies an alternative. Rent growth and expense growth can have different anchors and frequencies. Keeping those schedules explicit prevents both missing pre-analysis growth and adding growth that is already reflected in a current estimate.
Worked example: An expense estimate is €50,000 at 1 January 2026, with 4% increases each following January. For calendar 2028, two increases produce €50,000 × 1.04² = €54,080. Starting a model in 2028 does not erase the estimate's earlier base date.
Common mistake: Using the analysis start as every assumption's growth base can understate or overstate inputs sourced from different dates.
Official syllabus reference: [2]
9. Shared assumptions and local overrides
A model can organise reusable assumptions at property or category level while retaining lease-specific exceptions. The essential modelling principle is precedence: an explicitly applicable local term should determine that lease's calculation instead of being obscured by a generic assumption. Document which records use shared assumptions and which use overrides. A global change should affect only records actually linked to it. This is a conceptual control rather than a claim about a particular software interface. It helps distinguish an intentional contractual exception from an accidental failure to propagate revised market assumptions.
Worked example: A letting category assumes six rent-free months for new offices. One signed lease grants four months, so that lease uses four while prospective lettings retain six. Changing the shared market assumption to five months should not rewrite the signed concession.
Common mistake: A changed central assumption does not prove every lease should change when some leases have explicit contractual overrides.
Official syllabus reference: [2]
10. Stable identifiers preserve model relationships
Stable property, unit and lease identifiers connect source data, model records and output reports. Names alone may change or repeat, making them unreliable matching keys. Distinguish the physical unit from the tenant and from successive lease contracts occupying that unit. Maintain a clear baseline model version before applying scenario changes, so comparisons reference the same underlying records. This structure supports reconciliations after imports, replacements and renaming. It also prevents a successor lease from appearing as an additional physical unit simply because its tenant has a different name.
Worked example: Unit R-04 remains the same 250 m² shop when Tenant Elm replaces Tenant Birch. Separate lease identifiers distinguish the two contracts, while the stable unit identifier keeps area, vacancy and successor income attached to one physical space throughout the forecast.
Common mistake: Renaming a tenant should not create additional lettable area or sever the link between an expiring lease and its replacement.
Official syllabus reference: [2]
11. Inputs, formulas and report outputs differ
An input is an assumption or source fact; a calculated field is produced from other values; a report output presents selected calculations. Trace an unexpected output back through its formula dependencies before changing an assumption. A displayed annual rent may derive from area, unit rate, occupied months and incentives, so directly matching that total without understanding its components can conceal multiple errors. Maintain independent arithmetic controls for important subtotals. The objective is to explain how an output is generated, including timing and exclusions, rather than merely reproducing a familiar number.
Worked example: A report shows €75,000 annual rent for a 500 m² suite quoted at €300/m²/year. The full-year entitlement is €150,000, but six payable months explain the output. Increasing the input rate to force €150,000 would corrupt the actual lease terms.
Common mistake: An unexpected report total is not sufficient evidence that the contractual rate is wrong; period coverage may explain it.
Official syllabus reference: [2]
12. Cash-flow signs and subtotal classification
A cash-flow schedule must identify receipts and payments consistently, even when reports display expenses as positive deductions. Classify each item by its economic role: operating income, operating expense, capital investment, financing or disposal. These classifications determine subtotals such as NOI, unlevered property cash flow and equity cash flow. A sign error can turn an expenditure into apparent income, while a classification error can preserve final cash but distort a key subtotal. State the report convention and reconcile from gross income through the successive deductions and additions.
Worked example: Rent of €200,000 less €40,000 operating expense gives €160,000 NOI. Deducting €25,000 capital expenditure gives €135,000 unlevered cash flow. Whether expenses display as negative entries or positive deductions, both subtotal calculations must preserve those economic directions.
Common mistake: Correct final cash does not guarantee correct NOI when operating costs and capital expenditure have been placed in the wrong categories.
Official syllabus reference: [2]
EMEA discounted cash flow: Rent Roll
13. Physical, economic and paying occupancy
Physical occupancy measures occupied area relative to an identified lettable-area denominator. Paying occupancy considers whether occupied space currently generates the relevant rent, while economic occupancy measures income against a defined potential-income benchmark. These measures can diverge during incentives, arrears or under-market leases. Specify whether occupancy is measured at a point in time or averaged across a period. For annual physical occupancy under equal-month assumptions, weight occupied area by occupied months. Do not use zero base rent as automatic evidence of vacancy when a tenant is physically occupying under a concession.
Worked example: A 200 m² suite in a 1,000 m² building is occupied all year but base-rent-free for three months. Its physical contribution is 20 percentage points throughout. Its contribution to a rent-paying occupancy measure depends on the measure's stated treatment of those months.
Common mistake: A rent-free tenant can occupy space and owe recoveries even when its current base-rent receipt is zero.
Official syllabus reference: [2]
14. Passing rent and market reversion
Passing rent is the contractual rent currently payable, while market rent estimates the rent achievable under the specified market assumptions. A difference creates potential reversion when an applicable review, renewal or replacement letting occurs. Market growth does not automatically amend the signed lease. Model the existing contract through its enforceable events, then apply the relevant market basis at the specified transition. Above-market passing rent may fall at reletting; below-market passing rent may rise. The timing and contractual restrictions determine when either change enters forecast cash flow.
Worked example: A 700 m² office pays €240/m²/year while market rent is €280. With no review for two years, current annual rent remains €168,000. A later market letting at unchanged market rent would produce €196,000 before vacancy and incentives are considered.
Common mistake: Replacing every occupied lease with current market rent immediately removes the contractual timing that determines when reversion can actually occur.
Official syllabus reference: [2]
15. Commencement, possession and rent start
Lease commencement, physical possession, base-rent commencement and recovery commencement can be different events. The scenario or lease evidence must determine each obligation rather than allowing one date to control every cash-flow component. A tenant may possess premises for fitting out before paying base rent, and recoveries may begin during that period. Conversely, a signed future lease does not necessarily mean current physical occupation. Build separate event schedules where the facts require them. This distinction affects occupancy reporting, rent-free incentives, recovery leakage and the period in which the landlord first receives cash.
Worked example: A shop's lease and possession begin on 1 May, recoveries start immediately, and base rent begins on 1 August after fit-out. For May–July, the unit is occupied and contributes recoveries, but its base-rent cash flow remains zero.
Common mistake: Using the base-rent start date as the occupation date can create artificial vacancy and incorrectly suppress recoveries during fit-out.
Official syllabus reference: [2]
16. Fixed rent steps versus growth
A fixed step is a contractual change to a specified amount or percentage on a stated date. It differs from a market-growth assumption used to project estimated future rents. Enter the contractual step schedule directly and avoid applying another growth mechanism to the same amount unless the lease expressly requires both. When a step occurs within a reporting year, split the year between the old and new rates using the stated proration convention. Review whether a quoted schedule lists total annual rent or incremental additions, because confusing those bases materially changes the forecast.
Worked example: Annual rent is €120,000 until 30 June and €132,000 from 1 July. Under equal-month allocation, the year contains €60,000 at the old rate and €66,000 at the new rate, giving €126,000 total rather than either full-year rate.
Common mistake: Applying market inflation on top of an already specified contractual rent schedule can count the same expected increase twice.
Official syllabus reference: [2]
17. Index reviews with caps and collars
An indexed review links rent changes to a defined index observation and review period. A cap limits the increase and a collar or floor limits the downside under the precise contractual wording. Establish whether limits apply annually or cumulatively, whether decreases are permitted, and which previous rent or index base is used. Apply the limits before calculating the reviewed rent. Successive permitted increases normally compound when each review uses the preceding rent. An annual minimum positive increase differs from a zero floor, and neither should be inferred without supplied lease terms.
Worked example: Rent of €80,000 is reviewed annually with a stated 0% floor and 4% cap. An index rise of 6% produces €83,200. A following index fall of 2% leaves rent at €83,200 because this scenario's floor prevents a decrease.
Common mistake: A cap on each annual increase does not automatically impose the same cap on the cumulative increase across several reviews.
Official syllabus reference: [2]
18. Market reviews and contractual floors
A market review changes rent according to the lease's specified market-rent mechanism, which can include a floor at the existing rent or other constraints. First project the relevant market rent to the review date, then apply the contractual comparison. A scenario expressly described as upward-only might use the greater of current passing rent and the reviewed market amount. That mechanism is a supplied lease assumption, not a universal regional rule. Distinguish review-date rent from expiry-date reletting rent, because the latter may have different restrictions and incentive assumptions.
Worked example: A lease expressly reviews to the greater of current annual rent, €150,000, and market annual rent. If market rent at review is €142,000, rent remains €150,000. If it is €159,000, the reviewed rent becomes €159,000 under that stated mechanism.
Common mistake: An upward-only review restriction in one lease does not establish that every review or later replacement lease has the same floor.
Official syllabus reference: [2]
19. Downtime creates dated vacancy loss
Downtime is the period between the end of an existing occupation and the start of replacement occupation under the model's assumptions. It removes rent during the vacant interval and may leave operating costs unrecovered. Model the interval on the calendar rather than subtracting an undated annual allowance when exact timing is supplied. A new tenant's rent-free period may follow occupation and therefore extend the base-rent cash gap without extending physical vacancy. Growth during downtime can also change the market rent available at the eventual letting date.
Worked example: A tenant leaves on 31 March. Three vacant months follow, and a replacement occupies on 1 July with two rent-free months. Physical vacancy covers April–June, while the base-rent gap runs through August. Recoveries depend separately on the replacement lease's commencement terms.
Common mistake: Adding downtime and rent-free months into one vacancy measure confuses an empty unit with an occupied unit receiving an incentive.
Official syllabus reference: [2]
20. Renewal probability weights complete branches
A renewal probability creates an expected result from mutually exclusive renewal and replacement outcomes. Calculate each branch using its own rent, downtime, incentives and costs, then multiply by its probability and sum. The resulting expected cash flow need not describe any single physically possible lease history. For nonlinear outputs such as IRR, the probability-weighted output may differ from the output calculated on expected cash flows. State which measure is being requested. Branch completeness matters because a replacement-only commission or incentive should not be applied automatically to the renewal branch.
Worked example: Renewal has a 70% probability and produces €100,000 first-year rent. Replacement has a 30% probability and produces €60,000 after downtime. Expected rent is €88,000. A €10,000 replacement-only commission contributes €3,000 to expected cost, not €10,000.
Common mistake: A probability-weighted forecast is not evidence that a fraction of the tenant renews while the rest simultaneously vacates.
Official syllabus reference: [2]
21. Incentives alter cash and effective rent
Rent-free periods and landlord contributions reduce the economic benefit of a lease relative to its headline rent. Model their actual cash timing first: zero base rent in specified months or a contribution payment on its stated date. An effective-rent comparison spreads or discounts those concessions over a defined term, but that analytical measure should not replace the contractual payment schedule. Recovery concessions require separate evidence. A headline rent can remain unchanged while effective rent falls, and differently timed incentives can have different present-value costs despite equal nominal amounts.
Worked example: A five-year lease quotes €120,000 annual base rent and six initial rent-free months. Ignoring discounting and other concessions, total base rent is €540,000 and simple annual effective rent is €108,000. Actual receipts still begin after the six-month concession ends.
Common mistake: A lower effective-rent statistic does not authorise replacing every contractual monthly payment with that averaged amount in a dated DCF.
Official syllabus reference: [2]
22. Turnover rent depends on the formula
Retail turnover rent links payments to tenant sales under a specified formula. Common modelling structures include the greater of a base rent and a percentage of sales, or base rent plus an additional percentage above a breakpoint. These structures produce different totals and must not be interchanged. Identify eligible sales, the sales period, the percentage, any breakpoint and whether the calculation is a top-up or an addition. Use the supplied lease mechanics without assuming regional uniformity. Changes in sales affect only the portion of rent exposed under that formula.
Worked example: A shop pays the greater of €90,000 base rent and 7% of annual eligible sales. Sales of €1.5 million produce €105,000 total rent, including a €15,000 top-up. Adding €105,000 to the base would incorrectly count the base twice.
Common mistake: A turnover percentage does not establish whether calculated turnover rent replaces the base, tops it up or is payable in addition.
Official syllabus reference: [2]
23. Leasing costs require a defined fee base
Leasing commissions, tenant improvements and legal costs are separate investment cash flows associated with lease events. A commission percentage needs an explicit fee base, such as first-year contractual rent or aggregate rent over a specified term. Tenant improvements may instead use an amount per area or a fixed contribution. Apply costs only to the relevant renewal or replacement branch and on the stipulated payment date. Distinguish leasing expenditure from operating expenses when the exercise places it below NOI. A correct percentage applied to an incorrect base still produces an incorrect forecast.
Worked example: A replacement lease has €200,000 first-year contractual rent and a commission of 8% of that amount, payable at commencement. Commission is €16,000. A separate €40/m² improvement contribution for 500 m² adds €20,000, giving €36,000 combined commencement expenditure.
Common mistake: Using total lease-term rent as the commission base overstates cost when the agreed fee applies only to first-year rent.
Official syllabus reference: [2]
24. WAULT to expiry differs from WAULT to break
Weighted average unexpired lease term summarises remaining contractual duration using a specified weight, often rent or area. Calculate the weighted sum of remaining terms divided by the total chosen weight. A measure to contractual expiry differs from a measure to the earliest applicable break date. Neither statistic guarantees how long income will actually continue, because exercise assumptions and subsequent renewals remain separate. State the measurement date, weighting basis and treatment of breaks. These definitions are essential when comparing properties with different rent levels, lease lengths or concentrated break exposure.
Worked example: Two leases each contribute €100,000 annual rent. One has six years to expiry and a break in two years; the other has four years without a break. Rent-weighted WAULT is five years to expiry but three years to earliest break.
Common mistake: A single WAULT number cannot be interpreted reliably without knowing whether it uses expiry dates, break dates and rent or area weights.
Official syllabus reference: [2]
EMEA discounted cash flow: Recoveries, Investment and Valuation
25. Recovery pools separate expense eligibility
A recovery pool groups expenses eligible for allocation under the scenario's lease terms. Operating expenses still occur even when they are excluded from tenant recovery. Establish the pool before applying tenant shares, timing, caps or exclusions. Different tenant groups may participate in different services, so a single property-wide pool is not always appropriate. Preserve gross expenses and recovery income separately to reveal landlord exposure. Eligibility is a contractual modelling assumption here; an expense's accounting description alone does not prove it can be charged to every occupier.
Worked example: Annual expenses are €100,000, comprising €70,000 eligible services and €30,000 landlord-only costs. A tenant owing 25% of the eligible pool contributes €17,500. Applying 25% to all expenses would charge €25,000 and overstate recovery by €7,500.
Common mistake: An expense can be a genuine operating cost while remaining entirely outside the tenant recovery pool under the supplied lease terms.
Official syllabus reference: [2]
26. Allocation denominators control vacancy leakage
A tenant's recovery share depends on both its participating area and the denominator defined for the pool. A fixed total-building denominator leaves vacant shares with the landlord. An occupied-area denominator reallocates the pool among participating occupied units if the supplied terms permit it. These mechanisms produce different tenant charges even when expenses and leased area are unchanged. Identify whether the denominator includes all lettable area, only a service group or another defined base. Do not let vacancy automatically change the denominator unless that behaviour is part of the stated recovery mechanism.
Worked example: Eligible expenses are €60,000 in a 1,000 m² building. A 200 m² tenant pays €12,000 using total area. If only 800 m² is occupied and the scenario instead requires occupied-area allocation, its share becomes €15,000. The denominator explains the difference.
Common mistake: Holding a tenant's area constant does not hold its recovery percentage constant when the selected denominator changes with occupancy.
Official syllabus reference: [2]
27. Base-year stops recover expense increases
A base-year or expense-stop structure can limit recovery to eligible expenses above an agreed reference amount. Establish the reference on a comparable pool, area and period basis, then calculate the positive excess under the scenario's terms. The landlord retains the reference expense and any ineligible amount. A stop is different from a cap: the stop determines the starting layer borne by the landlord, while a cap limits what may be recovered above it. Specify whether the reference is fixed or escalates and whether negative recoveries are prohibited.
Worked example: A lease recovers 30% of eligible building expenses above a fixed €100,000 stop, with no negative recovery. If eligible expenses reach €130,000, the excess is €30,000 and the tenant pays €9,000. At €95,000, this specified mechanism produces zero recovery.
Common mistake: Applying the tenant percentage to the entire expense pool ignores the landlord's reference layer in an excess-over-stop arrangement.
Official syllabus reference: [2]
28. Recovery caps and fixed contributions differ
A recovery cap limits a charge calculated from underlying eligible expenses; a fixed contribution specifies a payment that may be independent of actual expense. For a capped charge, calculate the contractual allocation first and then apply the stated limit. Determine whether the cap applies to total recovery, selected controllable expenses or annual growth in a charge. These are different mechanisms. A fixed contribution can create either surplus or shortfall relative to expense, while a cap generally exposes the landlord to allocated cost above the permitted recovery. Model each from its explicit wording.
Worked example: A tenant's eligible share is €24,000 and its stated annual recovery cap is €21,000, so recovery is €21,000. If another tenant instead owes a fixed €21,000 contribution, that payment remains €21,000 even when its allocated expense falls to €18,000.
Common mistake: A cap of €21,000 does not require charging €21,000 when the underlying contractual allocation is only €18,000.
Official syllabus reference: [2]
29. Expense gross-up separates variable costs
A gross-up estimates occupancy-sensitive expenses at a specified reference occupancy when the supplied recovery arrangement calls for it. Separate variable expenses from fixed expenses before adjusting. A simplified proportional gross-up divides observed variable expense by actual occupancy and multiplies by reference occupancy; fixed expense remains unchanged. The adjusted amount is a calculation basis, not necessarily an additional cash expense actually incurred. Use only the scenario's permitted mechanism and reference occupancy. Grossing up every cost indiscriminately overstates fixed items and can distort both tenant recovery calculations and landlord cash-flow reporting.
Worked example: At 80% occupancy, variable service expense is €32,000 and fixed expense is €50,000. A stated 100% proportional gross-up yields €40,000 variable expense and an adjusted pool of €90,000. Actual expense remains €82,000 unless the forecast separately changes it.
Common mistake: Gross-up of a recovery calculation should not automatically replace actual cash operating expense with a hypothetical fully occupied amount.
Official syllabus reference: [2]
30. Percentage fees can create circular formulas
A management fee requires an explicit income or expense base. If the fee is a percentage of income excluding recoveries, calculate it directly from that base. If fee recovery itself enters the income base on which the fee is calculated, the relationship may be circular and requires algebra or an explicitly defined software treatment. Do not resolve circularity by repeatedly adding estimated percentages without a stopping rule. Confirm whether the fee is recoverable, whether recoveries enter its base and whether vacancy or incentives affect the fee-bearing income.
Worked example: Suppose other income is €100,000, the fee is 5% of income including full recovery of that fee, and no other recoveries exist. Then F = 0.05(100,000 + F), giving F = €5,263.16. Excluding recovery from the base would instead give €5,000.
Common mistake: A stated fee percentage alone is insufficient to calculate the fee when the definition of its income base remains unresolved.
Official syllabus reference: [2]
31. NOI measures defined operating performance
Net operating income is an operating subtotal whose included categories must be stated. In these exercises, rental and recovery income less operating expenses gives NOI before capital expenditure, financing and disposal. Showing expenses and recoveries separately exposes the amount economically retained by the landlord. Comparisons require a consistent definition, because a report that deducts reserves or leasing costs within its subtotal may differ from another report's NOI. Use the supplied definition rather than assuming the label determines every inclusion. Operating cash performance and accounting profit also need not be identical.
Worked example: A property receives €500,000 rent and €80,000 recoveries while incurring €110,000 operating expenses. Under the stated definition, NOI is €470,000. A further €40,000 roof project reduces investment cash flow but is shown below this NOI subtotal.
Common mistake: Two reports labelled NOI are not comparable until their expense, reserve and leasing-cost inclusions have been checked.
Official syllabus reference: [2]
32. Capital expenditure has separate cash timing
Capital expenditure is investment in the property rather than a routine operating cost under the scenario's classification. Its amount and payment date affect unlevered cash flow and present value even when it sits below NOI. A reserve allowance differs from an actual capital project: including both for the same economic expenditure can double count. Forecast discrete works on their stated schedule and establish whether terminal income or sale adjustments already reflect the property's required condition. Do not infer recoverability or accounting treatment merely from the project's size.
Worked example: A property has €300,000 NOI and pays €100,000 for a refurbishment at year-end 2. That year's pre-financing cash flow is €200,000 before other adjustments. Adding a second €100,000 reserve for the same project would duplicate the forecast expenditure.
Common mistake: Excluding capital expenditure from NOI does not exclude it from the property's DCF or its required investment funding.
Official syllabus reference: [2]
33. Exit yield prices terminal income
An exit yield converts a specified terminal income measure into an estimated sale value. Under a forward-NOI convention, gross value at the end of year n equals year n+1 NOI divided by the exit yield. Deduct selling costs and other expressly supplied adjustments before discounting net proceeds to the valuation date. The exit yield is distinct from the DCF discount rate: one prices terminal income, while the other discounts dated cash flows. This direct-capitalisation step should not be confused with a separate traditional term-and-reversion valuation method.
Worked example: Year-6 NOI is €420,000 and sale occurs at the end of year 5 using a 6% exit yield. Gross sale value is €7 million. With 1.5% selling costs, net proceeds are €6.895 million before discounting for five years.
Common mistake: Using the DCF discount rate as the exit yield changes the disposal pricing assumption and is not a neutral shortcut.
Official syllabus reference: [2]
34. NPV includes acquisition outlays
Net present value compares discounted future net cash flows with the investment outlay on a consistent basis. Acquisition price and purchaser costs paid at time zero are not discounted for an additional year. Positive NPV means the supplied cash flows exceed the stated required return at that total outlay; it is not a guarantee of realised performance. Distinguish the present value of property receipts from the price a buyer can pay after allowing for purchaser costs. Percentage costs charged on price require algebra when solving the maximum price.
Worked example: Future net receipts have a present value of €2.1 million. Price is €2 million and purchaser costs are 4% of price, making total outlay €2.08 million. NPV is €20,000, while the maximum zero-NPV price is €2.1 million divided by 1.04.
Common mistake: A property receipt value equal to the purchase price does not imply zero NPV when additional purchaser costs are payable.
Official syllabus reference: [2]
35. IRR is the zero-NPV rate
Internal rate of return is a discount rate that makes the present value of a specified dated cash-flow stream equal to zero, including the initial outlay. It differs from an input required return and from a simple income yield. Conventional investment cash flows often have one economically relevant IRR, but multiple sign changes can produce multiple roots or ambiguous interpretation. Use dated cash-flow analysis when intervals are irregular. Compare IRR only across compatible leverage, currency and timing bases, and retain NPV when choosing between investments with different scale or cash-flow patterns.
Worked example: An investor pays €1 million now and receives €1.21 million after two years with no intervening cash. The annual IRR solves 1.21/(1+r)² = 1, giving 10%. Dividing the 21% total gain by two would give only an approximation.
Common mistake: IRR is not the same as annual rent divided by purchase price when capital expenditure, sale proceeds or timing affect returns.
Official syllabus reference: [2]
36. Debt transforms property cash into equity cash
Unlevered cash flow describes property investment performance before financing. Equity cash flow adds borrowing receipts and subtracts interest, principal repayments and other stated financing costs. Initial equity is therefore not necessarily equal to the property purchase price. Leverage can increase or decrease equity returns depending on financing cost, timing and property performance; it does not change underlying rent or NOI. Keep debt balances consistent across draws, amortisation and repayment at disposal. Match the discount rate or return comparison to the levered or unlevered stream being analysed.
Worked example: A €3 million acquisition is funded by €1.8 million debt and €1.2 million equity, ignoring costs. Annual property cash is €210,000 and debt service is €130,000, leaving €80,000 to equity. The loan balance must still be repaid from eventual sale proceeds.
Common mistake: Loan proceeds improve current equity cash availability but do not constitute rental income or an increase in property NOI.
Official syllabus reference: [2]
EMEA discounted cash flow: Portfolio Reporting & Sensitivity
37. Calendar alignment precedes aggregation
Portfolio totals require property cash flows aligned to the same actual dates and reporting intervals. A property's first forecast year may differ from another's because of valuation starts, acquisitions or fiscal calendars. Summing columns labelled Year 1 can therefore combine unrelated periods. Map underlying amounts to a common calendar before aggregation, and retain partial ownership periods where relevant. Valuation-date totals also require compatible dates or a stated roll-forward method. Alignment preserves the economic timing needed for annual reporting, liquidity analysis and portfolio return calculations.
Worked example: One property's Year 1 runs January–December and another's runs July–June. For a calendar-year report, the second property's July–December cash belongs in the current year and January–June in the next. Adding their complete Year 1 columns would mix reporting periods.
Common mistake: Identical column labels do not prove that different property models cover identical cash-flow dates or ownership periods.
Official syllabus reference: [2]
38. Ratios aggregate through their components
Many portfolio ratios must be calculated from aggregated numerators and denominators rather than averaged directly. Physical occupancy uses total occupied area divided by total lettable area. Average rent per area uses the relevant total rent divided by the corresponding area, subject to period consistency. A simple average is appropriate only when equal weighting is the intended statistic. Specify the population and denominator, particularly when some units are vacant or have nonstandard measurement bases. Reconstructing the ratio from components also exposes missing properties and inconsistent treatment of excluded area.
Worked example: A 2,000 m² building is 95% occupied and a 500 m² building is 40% occupied. Occupied area totals 2,100 m² out of 2,500 m², giving 84% portfolio occupancy. The unweighted average of 67.5% describes a different statistic.
Common mistake: Averaging property percentages gives each property equal influence even when their underlying areas or investment amounts differ substantially.
Official syllabus reference: [2]
39. FX bridges separate local performance
A reporting-currency change in value can arise from local property performance, exchange-rate movement or their interaction. Build an FX bridge by translating both local values at a common rate to isolate local change, then translating the current value at the current rate to isolate translation. State the sequence because sequential attribution assigns the interaction according to that order. This decomposition is descriptive rather than a separate valuation method. It helps explain why an asset can appreciate locally while declining in the portfolio's reporting currency.
Worked example: A UK asset rises from £10 million to £10.5 million. At the old €1.20 rate, local growth adds €0.6 million. Translating the new value at €1.10 reduces that €12.6 million amount to €11.55 million, an FX effect of negative €1.05 million.
Common mistake: A reporting-currency loss does not establish that the property's local-currency valuation fell; exchange-rate movement may explain the result.
Official syllabus reference: [2]
40. Report scope determines comparable totals
A report's filters, valuation date, scenario, currency and included properties define its scope. Reconcile those attributes before interpreting differences between two totals. A portfolio summary excluding disposals cannot be compared directly with an all-properties cash-flow report that includes their sale proceeds. Similarly, a lease report filtered to office space may not reconcile to a mixed-use property total without retail records. Scope reconciliation is a mathematical inclusion problem: identify which records contribute to each subtotal and calculate the effect of additions or omissions.
Worked example: A summary shows €8 million value while a detailed report totals €9 million. The detailed report includes a €1 million retail asset excluded by the summary's office-only filter. Once populations match, the discrepancy disappears without changing any property's valuation assumptions.
Common mistake: A difference between report totals is not automatically a calculation error when their property populations or scenario selections differ.
Official syllabus reference: [2]
41. Variance bridges explain income changes
A variance bridge decomposes the change between two results into identifiable drivers, such as area, rent rate, occupancy, incentives and expenses. For interacting drivers, define the calculation order so the bridge adds exactly to the total change. Holding one factor at its old value isolates another factor's initial effect; updating factors sequentially assigns the interaction to later steps. This is useful for explaining forecast revisions rather than merely reporting a percentage difference. Keep classification consistent so a recovery movement is not also counted as an expense reduction.
Worked example: Annual rent rises from 1,000 m² × €200 to 1,100 m² × €210. Apply area first: another 100 m² at €200 adds €20,000. Then apply the €10 rate increase to 1,100 m², adding €11,000. The bridge explains the €31,000 increase.
Common mistake: Calculating every driver against the old base can omit interaction effects and leave a variance bridge that does not reconcile.
Official syllabus reference: [2]
42. One-way sensitivity isolates a driver
A one-way sensitivity changes one input while keeping a documented base set of other assumptions fixed. The resulting output differences describe exposure to that input under those conditions. Use a plausible, explicitly stated range rather than presenting the tested endpoints as universal market limits. Check that linked calculations update appropriately: changing an exit yield should change selling costs if those costs are a percentage of sale value. Sensitivity is not a probability forecast and does not identify which outcome is most likely. Its interpretation depends on the controlled baseline.
Worked example: A model tests exit yields of 5%, 5.5% and 6% while preserving NOI, disposal date and discount rate. Lower sale values at higher yields show pricing exposure. Percentage selling costs recalculate with each gross sale value rather than remaining fixed accidentally.
Common mistake: Changing rent growth while testing exit yield creates a multi-assumption scenario and no longer isolates the exit-yield effect.
Official syllabus reference: [2]
43. Two-way grids reveal interaction
A two-way sensitivity grid calculates an output for every combination of two selected inputs. Each cell requires the full model result for that pair, with other assumptions held fixed. Identify the base intersection and read the combined scenario from its corresponding row and column. Do not add separate one-way percentage impacts unless the model relationship justifies that approximation. Discount rate and exit yield interact because the discount rate determines the present-value impact of terminal proceeds already changed by the yield. State units clearly for both axes and outputs.
Worked example: Base value is €10 million. Raising only discount rate reduces it to €9.6 million; raising only exit yield reduces it to €9.2 million. The combined grid cell is €8.85 million. Its €1.15 million loss must be read directly rather than assumed to be €1.2 million.
Common mistake: The sum of two isolated value changes need not equal their combined effect because valuation relationships can be nonlinear.
Official syllabus reference: [2]
44. Scenarios combine related assumptions
A scenario is a coherent set of changes intended to represent a particular operating or market condition. It can combine weaker rental growth, longer downtime, larger incentives and a changed exit yield when those assumptions belong to the stated narrative. Unlike an isolated sensitivity, it measures the net effect of several drivers together. Document every changed assumption and avoid automatically assigning a probability unless one is supplied. Correlation matters at portfolio level: applying unrelated independent stresses can produce a result that does not represent the intended shared economic environment.
Worked example: A retail downside assumes lower sales, six additional months of reletting downtime and a higher exit yield. Turnover rent, vacancy cash loss and sale proceeds all change. The output describes that combined scenario, rather than the separate effect of weaker tenant sales alone.
Common mistake: A downside scenario's valuation is not an expected value unless its probability and the probabilities of other outcomes have been specified.
Official syllabus reference: [2]
45. Portfolio IRR requires a combined investment schedule
Portfolio IRR is the discount rate that sets the net present value of combined investment cash flows to zero. Build one schedule containing acquisitions, operating distributions, further investments and disposals, using a common currency and a consistent property or equity basis. Aggregate receipts and payments on matching dates, then solve for the rate from that schedule. Individual property IRRs reflect different cash-flow patterns, so averaging them, even with acquisition-price weights, generally cannot reproduce the portfolio return. Specify annual periods or actual dated discounting because the selected timing convention determines the calculation.
Worked example: Amounts are €000. On 1 January 2027, A pays 200. One year later, A receives 20 and B pays 100. Another year later, A receives 209 and B receives 121. Combined annual flows are −200, −80, +330. Solving −200−80/(1+r)+330/(1+r)²=0 gives 10%; discounted flows sum to −200−72.727+272.727=0.
Common mistake: Acquisition-price weighting does not generally make individual IRRs additive. Calculate the portfolio return from combined cash flows, including investments made after inception.
Official syllabus reference: [2]
46. Concentration exposes clustered lease events
Portfolio concentration can be measured by tenant, sector, location or lease-event date using an explicit exposure base. Rent-weighted expiry analysis shows the share of current rent exposed to lease endings in each period. Break analysis may show earlier exposure than contractual expiries. A diversified property count can still conceal dependence on one tenant or one year of renewals. Calculate exposure from the relevant lease records rather than infer it from asset count. The result identifies where scenario analysis should focus; it does not establish that all exposed rent will be lost.
Worked example: A portfolio has ten buildings, but one tenant pays €1.2 million of €3 million total annual rent. Tenant concentration is 40%. If its earliest break falls next year, the portfolio's near-term lease-event exposure is larger than the building count alone suggests.
Common mistake: Many separate properties do not ensure diversified income when a single occupier or a narrow expiry window dominates rent.
Official syllabus reference: [2]
47. Precision differs from displayed rounding
Financial models normally calculate using more precision than they display. Summing rounded line items can differ slightly from rounding the sum of unrounded amounts. Preserve internal precision for compounding, discount factors and ratios, then round the final requested outputs. Report monetary units explicitly, particularly when switching between euros, thousands and millions. A small reconciliation difference may be presentational, but material differences require investigation rather than being dismissed as rounding. Establish an appropriate tolerance from the displayed units and number of rounded components.
Worked example: Three unrounded present values end in €0.49, €0.49 and €0.49. Rounding each to whole euros discards €1.47 in total, while rounding their combined amount adds one euro. Both presentations can arise from the same underlying calculation.
Common mistake: A one-euro displayed difference can be harmless, but rounding cannot explain a discrepancy larger than the components' plausible rounding effects.
Official syllabus reference: [2]
48. Value attribution separates income and reversion
A DCF value can be decomposed into the present value of holding-period operating cash flows and the present value of net disposal proceeds. This attribution shows how much of the result depends on terminal assumptions rather than near-term cash generation. Calculate both components using the same timing and discount basis as the full valuation. A large disposal share is not automatically an error, but it makes forward NOI, exit yield and selling costs especially influential. Avoid treating the terminal share as an additional value on top of a total that already includes it.
Worked example: A property has €1.5 million present value of operating cash and €6 million present value of net sale proceeds. Total value is €7.5 million, with 80% attributable to disposal. Exit-yield sensitivity therefore addresses a major source of valuation exposure.
Common mistake: Adding capitalised terminal value to a DCF total that already includes net sale proceeds counts the same disposal component twice.
Official syllabus reference: [2]
EMEA discounted cash flow: case-study modelling
49. Evidence precedence resolves conflicting inputs
Case modelling begins by identifying what each supplied document establishes and which instruction governs any conflict. A signed lease extract can specify contractual rent while a market schedule supplies replacement rent; these are different inputs rather than competing answers. When the case explicitly gives precedence, apply it and record the affected assumption. Where a genuine conflict remains, state a bounded modelling assumption instead of silently blending values. Build an input register connecting each material value, unit and effective date to its source. This creates a reproducible model without relying on unsupported interface behaviour.
Worked example: A rent roll lists €180,000 annual passing rent, while an attached signed variation changes rent to €192,000 from 1 July. If the case instructs that signed variations prevail, use six months at each rate, producing €186,000 for the calendar year.
Common mistake: Averaging conflicting source amounts creates a new assumption rather than resolving which contractual amount applies on each date.
50. Area roll-forwards conserve physical space
An area roll-forward tracks opening occupied area, move-ins, move-outs and closing occupied area for each period. Closing occupied plus vacant lettable area should reconcile to the defined physical inventory unless the case includes additions, removals or remeasurement. This control is independent of whether tenants pay rent. Maintain unit-level continuity when one lease ends and another begins, and avoid counting both contracts as separate space. A roll-forward can reveal gaps or overlaps that annual rent totals obscure, especially when incentives offset the financial effect of an erroneous occupation period.
Worked example: A building opens a month with 800 m² occupied out of 1,000 m². A 150 m² tenant leaves and a 100 m² tenant enters different space. Closing occupation is 750 m² and vacancy is 250 m², preserving the 1,000 m² inventory.
Common mistake: A successor tenant's record adds a new lease, not new physical area, unless the case explicitly describes additional premises.
51. Event ordering prevents overlapping rent
When reviews, breaks, expiry, incentives and new lettings occur near one another, the order of events determines which rent applies. Establish the last date covered by the outgoing lease and the first date covered by each successor obligation. A review scheduled after an exercised break should not generate rent for a contract that has ended. Where events share a date, use the explicit case convention and avoid charging both old and new rents for the same period. A chronological event ledger provides a direct way to verify this logic.
Worked example: A lease breaks on 30 June and would otherwise review on 1 July. A replacement occupies on 1 September. With the break assumed exercised, July's review does not apply; July–August is vacant and the new contract governs rent from its own payable date.
Common mistake: Applying every listed review mechanically can create income after a lease has already terminated under the scenario's break assumption.
52. Mixed-use segmentation matches service benefits
A mixed office/retail property may require distinct rent assumptions, expense pools and allocation populations for its uses. Segment the building according to the supplied services and contractual participation rather than force every expense through total property area. Shared expenses can have a building-wide denominator while office-only or retail-only services use their own participating areas. The segments must still reconcile to the physical property and total expenses. This structure permits meaningful comparisons without assuming office tenants subsidise retail-specific services or vice versa unless the case expressly requires that allocation.
Worked example: A property has 600 m² office and 400 m² retail. Shared security costs €20,000 and is area-allocated across both uses. A separate €9,000 office lift pool is charged only to offices. Retail's share of security is €8,000, with no office-lift allocation.
Common mistake: Using total building area for every service pool can allocate use-specific costs to tenants outside the defined participating group.
53. Chargeability matrices separate lease obligations
A chargeability matrix maps each lease period to the obligations active during that period: occupation, base rent, recoveries and any special charges. This is particularly useful when a rent-free concession affects only base rent. Instead of treating the lease as simply on or off, calculate each cash-flow component from its own activation rule. Check the matrix against commencement and incentive dates, then reconcile annual totals. The mechanism applies only to supplied contractual terms; do not infer that every concession exempts or preserves recoveries in the same way.
Worked example: A retail lease occupies April–December, pays no base rent in April–May and owes recoveries from April. Its matrix contains nine occupied months, seven base-rent-paying months and nine recovery-paying months. Each component therefore uses a different appropriate annual proration.
Common mistake: A zero base-rent flag should not automatically set recovery income to zero when recoveries remain chargeable during occupation.
54. Successor leases inherit space, not contract terms
A replacement lease continues the use of the same physical unit but normally follows its own commencement, rent, incentive and cost assumptions. Link the successor to the outgoing unit so area remains constant, then replace only the contractual terms that cease at expiry. An outgoing tenant's special recovery cap or historical rent step should not automatically carry into the new contract. Conversely, physical attributes such as area remain unless the case changes them. Explicit successor linking prevents perpetual old rent, duplicated occupation and inappropriate inheritance of tenant-specific concessions.
Worked example: A 300 m² shop expires at €200/m²/year with a tenant-specific recovery cap. After two vacant months, a new lease starts at €240/m²/year without that cap. The unit remains 300 m², but its rent and recovery mechanism change under the replacement contract.
Common mistake: Copying an expiring lease wholesale into a replacement can preserve obsolete tenant concessions and prevent the intended market reversion.
55. Expense bases distinguish totals from unit rates
A case expense may be quoted as a whole-property annual amount, an amount per area, a percentage of income or a discrete project. Identify that base before applying growth or occupancy adjustments. A fixed annual building total should not be multiplied by area again. A per-area expense needs the specified area base, which may be total area rather than occupied area. Escalate the underlying rate or amount from its correct date, then calculate the period expense. Recovery allocation occurs afterward and must not redefine what the property actually incurs.
Worked example: Cleaning is €12/m²/year on 1,000 m² total lettable area, regardless of occupancy. Annual expense is €12,000. If the rate increases 3% next year, expense becomes €12,360 even if occupation falls to 80%; any recovery shortfall is calculated separately.
Common mistake: Reducing every expense with occupancy understates costs that the supplied case defines by total area or as fixed building amounts.
56. Forward valuation income is not retained cash
A disposal calculation may require an extra forecast period solely to establish the income capitalised at sale. Under an end-of-year-3 sale using year-4 NOI, the seller receives year-3 operating cash plus net disposal proceeds, while year-4 NOI belongs only in the sale-value calculation. Keep this auxiliary forecast separate from retained holding-period receipts. Verify whether the forward income already reflects scheduled reviews, vacancy or expense changes. This distinction prevents both truncating the income basis too early and collecting another year of operating cash after the assumed ownership has ended.
Worked example: Sale occurs at year-end 3, with €300,000 year-3 cash and €330,000 year-4 NOI used at a 6% yield. Gross sale is €5.5 million. Before selling costs, terminal-date receipts total €5.8 million; the €330,000 is not added as another receipt.
Common mistake: Including the forward NOI both in capitalised sale value and as post-sale operating cash overstates the seller's receipts.
57. Sources and uses solve the affordable price
A sources-and-uses schedule separates what funds are available from what must be paid at acquisition. Uses may include price, purchaser costs, initial capital works and financing fees; sources may include debt and equity. For an unlevered zero-NPV price, future-receipt present value must cover price plus all initial investment uses. If purchaser costs are a percentage of price, divide the available amount by one plus that percentage after deducting any fixed initial costs. This algebra avoids understating transaction costs by calculating them on an incorrectly assumed net amount.
Worked example: Future receipts have present value €5.2 million. Fixed initial works are €200,000 and purchaser costs equal 4% of price. Available value for price plus percentage costs is €5 million, so maximum price is €5 million/1.04, approximately €4,807,692.
Common mistake: Subtracting 4% of receipt value is not the same as solving for costs defined as 4% of the unknown purchase price.
58. Reverse-solving identifies required rent
A reverse calculation solves for the input needed to meet a stated value or return target. Define which variables are fixed and how the unknown enters each cash-flow period. In a simplified constant-rent case, the present-value annuity factor converts an annual rent change into a value change. If rent also affects recoveries, fees or terminal value, include those relationships rather than treating it as an isolated receipt. The result is a required assumption under the stated model, not evidence that the market can achieve it. Compare the solved input with supplied market evidence separately.
Worked example: A two-year model has no disposal and needs €200,000 present value from equal year-end net rents at 10%. The factor is 1/1.10 + 1/1.10² = 1.735537. Required annual net rent is €200,000 divided by that factor, approximately €115,238.
Common mistake: A rent that mathematically supports a purchase price is not automatically a defensible market-rent assumption or a contractual entitlement.
59. Independent invariants locate model errors
An invariant is a relationship that should remain true under the stated model structure. Examples include occupied plus vacant area equalling inventory, gross expense less recovery equalling landlord exposure, and total DCF value equalling operating present value plus disposal present value. Use these independent relationships to locate an error's layer before changing inputs. If annual rent is wrong but area and monthly rate reconcile, inspect dates and concessions. A control derived through a different route is more informative than repeating the model's own formula with the same potentially incorrect inputs.
Worked example: A recovery report shows €52,000 income against a €48,000 eligible pool under fixed shares totalling 100%, with no mark-up or gross-up. That violates the stated allocation limit. Inspect duplicate tenant periods or shares before changing the actual building expense to force agreement.
Common mistake: Adjusting a genuine source expense to match an erroneous recovery total hides the allocation problem instead of correcting it.
60. Scenario acceptance uses expected output changes
A controlled scenario should produce changes consistent with the variables intentionally altered. Before running it, identify which outputs should move and which should remain invariant. For an exit-yield-only change, operating rent, expense and NOI should stay fixed, while gross sale, percentage selling costs and value should change. Compare the observed difference with an independent bridge, such as discounted change in net proceeds. Preserve the baseline assumptions and label scenario outputs clearly. This acceptance logic verifies both that the intended input changed and that unrelated assumptions did not drift.
Worked example: An exit-yield increase reduces net sale proceeds by €490,000 at year-end 3. At an unchanged 8% discount rate, value should fall by €490,000/1.08³, approximately €388,978. If reported NOI also changes, investigate an unintended assumption change before accepting the scenario.
Common mistake: A plausible downside value is insufficient validation when unrelated rent or expense inputs changed during the scenario run.
Official syllabus sources
- ARGUS Enterprise: (ASC) DCF Certification Exam (EMEA) – Altus Group UK webstore
- ARGUS Enterprise: DCF eLearning Beginner Package (EMEA) – Altus Group Europe webstore