How should I distinguish passing rent from market rent?

Passing rent is the amount due under the current lease. Market rent, often called estimated rental value or ERV in EMEA examples, is an assumption about what the space could command under stated market terms. A rent review, lease expiry or new letting may change the cash flow from one to the other. For example, £200,000 passing rent for the first six months and a £240,000 reviewed annual rent for the next six produces £220,000 for that year, before incentives or other adjustments.

Why can net operating income and investment cash flow differ?

Net operating income reflects property income less operating costs after the stated recoveries. Investment cash flow may also deduct capital expenditure, leasing costs and sale costs. If rent and recoveries total $600,000 and operating costs are $150,000, NOI is $450,000. With $50,000 of capital work, cash flow before financing and tax is $400,000. Identify which measure a valuation or report uses before comparing figures.

How do DCF and traditional valuation treat a lease that expires?

A DCF lays out the cash flow by period, including the remaining rent, any void, the new rent and the eventual sale value, then discounts those amounts using stated timing. A traditional term and reversion calculation values the remaining contractual income and the assumed income after reversion as separate interests. Both depend on the lease dates and the future rent assumption, but their yield and discount conventions must be stated before their results can be compared.

ARGUS Enterprise ASC Real Estate Study Guide

Start with concept 1 Choose a topic

ARGUS Enterprise turns property and lease assumptions into cash flows, valuations and reports. To use its results well, you need to trace each number back to an area, date, rent term, recovery rule or valuation assumption. This guide builds that reasoning across three ASC tracks: AMER discounted cash flow, EMEA discounted cash flow and EMEA traditional valuation. The tracks share rent-roll discipline, but their regional assumptions and valuation methods require separate treatment. Each planned example supplies its own units, dates and rates so you can calculate an expected result and diagnose a model that disagrees. Work through the track relevant to you, then use the case exercises to connect lease inputs with the final investment value.

AMER discounted cash flow: Introduction to AE; Rent Roll

1. Set the property basis

Start an AMER discounted cash flow model by fixing the valuation date, currency, area measure and forecast calendar. The valuation date is the point from which future receipts are valued; a change in date changes both the first partial period and discount timing. Rent quoted per square foot per year becomes a property amount only after multiplication by the applicable rentable area. Confirm whether a quoted area belongs to a unit or the whole building, and use the same area basis throughout the rent roll. Then distinguish a full-year contractual rate from rent actually earned within a forecast period. A lease beginning partway through a year may have the same annual rate but less first-year income. The ARGUS Enterprise beginner package identifies introductory modelling and rent roll work as part of this track; these basis decisions make later cash flow comparisons meaningful.

Worked example: AMER DCF, valued January 1 in dollars: a 10,000 sq ft property is fully leased from that date at $30 per sq ft annually. Scheduled base rent is 10,000 sq ft × $30 per sq ft per year = $300,000 for the calendar year. That is a gross rent line before any stated concession, vacancy, recovery or expense.

Watch the distinction: Applying $30 directly as property income loses the area multiplier. Treating $300,000 as cash after expenses also confuses scheduled base rent with a later income measure.

Reference: [2]

2. Reconcile occupied area

Physical occupancy compares leased rentable area with total rentable area at a specified date. First reconcile the building's office and retail areas to its total. Next sum the area under active leases, counting each unit once; the balance is vacant area. Divide leased area by total rentable area to obtain occupancy, using the same units in numerator and denominator. This measure answers an area question, while economic occupancy compares income with an income benchmark. A small, high-rent shop can contribute more rent than a larger, lower-rent office unit without changing its physical footprint. If a lease starts or ends within the forecast period, specify whether occupancy is measured on a date or averaged across time. An area reconciliation also catches duplicate units and omitted space before they distort scheduled rent and expense allocations.

Worked example: AMER DCF: the building contains 12,000 office and 8,000 retail sq ft, or 20,000 sq ft total. Leases cover 10,000 office and 6,000 retail sq ft, or 16,000 sq ft. Physical occupancy is 16,000 ÷ 20,000 = 80%. Vacant space is 2,000 office plus 2,000 retail sq ft, totaling 4,000 sq ft.

Watch the distinction: A rent-weighted percentage is not physical occupancy. Higher retail rent cannot make 16,000 leased sq ft occupy more than 80% of this 20,000 sq ft building.

Reference: [2]

3. Place lease commencement

Lease commencement determines when a tenant begins contributing rent to the forecast. Identify the forecast year boundaries, the lease start date and the contractual annual rate before prorating. Under an explicit even-monthly-accrual assumption, monthly rent equals annual rent divided by twelve, and first-year rent equals that amount multiplied by the paid months. A start date should be checked against any separate possession date, rent commencement date or concession: those dates can differ in a real lease. Do not automatically annualize a partial first year when reconciling the cash flow report. Conversely, retain the full annual rate in the rent roll so later full years are not understated. For a dated DCF, income belongs in the periods in which it is earned under the chosen timing convention, with discounting applied to the resulting period cash flows.

Worked example: AMER DCF, calendar-year forecast: a lease with $120,000 annual base rent begins April 1, with level monthly rent and no concession. Monthly rent is $120,000 ÷ 12 = $10,000. April through December provides nine paid months, so first-year base rent is 9 × $10,000 = $90,000. A complete following year would contribute $120,000.

Watch the distinction: Entering $120,000 in the first calendar year fills January through March before the lease starts. Reducing the lease's annual rate to $90,000 would understate later years.

Reference: [2]

4. Model stepped base rent

A stepped lease specifies different contractual rents for different intervals. Build the rent schedule from the effective dates and rates, then map each interval into the forecast periods. If a step occurs at a year boundary, each year receives its stated rate. If it occurs midyear, split that year's rent using the months or days governed by each rate, according to the case convention. Preserve the step schedule even when a report shows an average or a total: averaging can reproduce aggregate undiscounted rent while putting cash in the wrong years. Timing matters in DCF because an earlier dollar has a higher present value than an otherwise identical later dollar at a positive discount rate. Check that a step is an absolute new rent or an increase to the old rent; interpreting one as the other can compound the error.

Worked example: AMER DCF: a fully occupied lease pays $100,000 during forecast year 1 and steps to $105,000 on the first day of year 2. The annual base-rent lines are $100,000 and $105,000. Their two-year undiscounted sum is $205,000, but a $102,500 average entered in both years would misstate each year's cash flow by $2,500.

Watch the distinction: Averaging the two rents preserves their undiscounted total but changes their timing. That can change present value and obscure whether the contractual step was entered correctly.

Reference: [2]

5. Account for free rent

Free rent changes receipts during a defined concession period without necessarily changing the lease's face rent. Record the annual contractual rate, the concession start and end dates, and which rent components the concession covers. Some agreements waive base rent but still require reimbursements; the supplied lease terms decide that treatment. For a simple full base-rent holiday with level monthly rent, deduct the free months from the paid months in the relevant forecast year. Keep the full annual rate available for later periods and for comparisons with market rent. A concession can also begin after commencement, so placing it automatically at the start is unsafe. When auditing output, compare a rent schedule and a concession schedule separately. Their combination should explain cash base rent without treating the temporary holiday as permanent vacancy or a permanent lower rent rate.

Worked example: AMER DCF: a January 1 lease quotes $120,000 annual base rent and waives base rent for January through March only. Level monthly base rent is $10,000. The first calendar year has nine paid months, producing 9 × $10,000 = $90,000 cash base rent. The annual face rate remains $120,000 for an otherwise unchanged later year.

Watch the distinction: Changing the annual face rent to $90,000 makes the concession permanent. Leaving cash rent at $120,000 ignores the three waived months and overstates first-year receipts.

Reference: [2]

6. Calculate retail overage

Retail percentage rent can add a sales-linked amount to minimum base rent. Read the lease formula precisely: the percentage may apply to sales above a stated breakpoint, rather than to all sales, and the minimum rent may remain payable regardless of sales. Under an excess-sales formula, subtract the breakpoint from reported sales, floor the result at zero, then multiply by the percentage rate. Add that overage to minimum rent only if the lease states it is additional. Use sales and rent for matching periods and currency, and check whether the sales figure includes the categories defined by the lease. A forecast should distinguish contractual terms from an uncertain sales assumption. This makes sensitivity analysis possible: changing sales affects overage only after the breakpoint is exceeded. A high sales forecast cannot justify overage before the threshold is reached.

Worked example: AMER DCF: annual minimum rent is $80,000, plus 5% of annual sales above $1.6 million. Assumed eligible sales are $2 million. Excess sales equal $2,000,000 − $1,600,000 = $400,000; overage is 0.05 × $400,000 = $20,000. Total annual rent under this stated additive formula is $80,000 + $20,000 = $100,000.

Watch the distinction: Taking 5% of all $2 million sales produces $100,000 of overage, which ignores the breakpoint. The stated minimum is then added only to correctly calculated overage.

Reference: [2]

7. Separate rollover outcomes

At expiry, model renewal and replacement letting as separate outcomes. Renewal may keep the existing tenant in place under a new rate and incentive package. Replacement letting may involve vacancy, marketing costs, tenant improvements, a different rate and a new lease term. Compare them over the same forecast dates rather than comparing annual headline rents alone. Start with the last day of the existing lease, place any void months, then apply the incoming rent only after its stated start. If probabilities are supplied, they can support an explicitly weighted scenario; otherwise, keep the outcomes separate. A higher replacement rent can still produce lower near-term cash when the space is empty for part of a year. For more focused AMER DCF practice, the AMER DCF study guide provides the relevant track context.

Worked example: AMER DCF: an expiring lease is followed either by immediate renewal at $110,000 annually or by three vacant months and a new tenant at $120,000 annually. Over the next calendar year, renewal gives $110,000. Replacement gives 9/12 × $120,000 = $90,000. Renewal yields $20,000 more that year, despite its lower annual rate; later years require separate comparison.

Watch the distinction: Comparing $120,000 with $110,000 alone favors the new tenant without accounting for vacancy. The relevant first-year comparison is $90,000 against $110,000 under these assumptions.

Reference: [2]

AMER discounted cash flow: Detailed Recovery Structures; Investment, Valuation & Reporting; Efficient Modeling, Auditing & Risk Analysis; Sensitivity & XL4ADW

8. Trace expense recoveries

A recovery shifts specified operating costs from the owner to tenants. Model the gross property expense first, then add the reimbursements allowed by each lease as income or an expense offset, consistently with the report layout. The owner's economic burden is gross eligible expense less actual recovery. Check which cost categories qualify, whether vacant space has no paying tenant, and whether lease caps, stops or exclusions limit collection. Do not assume the owner can recover every increase merely because a property-level expense rises. Reconcile recoveries by tenant and category to the total shown in the operating statement. This is especially useful in a mixed office and retail case, where different leases can allocate the same cost differently. The sign convention in a report may vary, but the net economic effect must be the same: recovery reduces the owner's cost.

Worked example: AMER DCF: the property incurs $120,000 in annual operating expenses. Under the supplied leases, tenants reimburse $80,000 in the same year. If base rent is omitted from this narrow check, the owner's net operating cost is $120,000 − $80,000 = $40,000. An operating bridge would subtract $120,000 of expense and add $80,000 of recovery.

Watch the distinction: Subtracting the $80,000 recovery as another cost makes owner burden $200,000. Recovery is a receipt or offset; its sign must reduce the gross $120,000 expense.

Reference: [2]

9. Apply an expense stop

An expense stop assigns the owner a base amount of eligible operating cost and passes a defined excess to the tenant. Establish the stop's currency, area basis, covered expense categories and period before calculating anything. Compare actual eligible expense and the stop on the same per-area basis; multiply only the positive difference by the tenant's eligible area or stated share. A stop can be fixed or based on a base year, and individual leases may exclude categories or use other rules, so the case terms control the result. If actual expense remains below the stop, this simple excess formula yields zero reimbursement rather than a negative recovery. For auditing, reconstruct both the total actual eligible cost and the total stop amount. Their difference should equal the modelled recovery when no additional limits apply.

Worked example: AMER DCF: eligible annual expense is $18 per sq ft for a tenant covering 10,000 eligible sq ft. Its stated expense stop is $15 per sq ft annually, with full recovery of excess and no cap. The excess is $3 per sq ft; recovery is ($18 − $15) × 10,000 = $30,000. The owner retains the $150,000 stop amount on that area.

Watch the distinction: Multiplying the full $18 by 10,000 charges the tenant for the owner's stop too. Comparing annual dollars with a per-square-foot stop also mixes units.

Reference: [2]

10. Test a recovery cap

A recovery cap limits what a tenant pays even when its otherwise allocated share is higher. Calculate the uncapped reimbursement from the lease's allocation rule first. Then apply the cap using the same period and cost categories. The recoverable amount is the lesser of the uncapped amount and the stated cap, provided no other lease term changes it. The difference remains an owner cost for the period. A cap may limit a dollar amount, an annual increase or a particular expense category; those are different mechanisms, so identify the wording before selecting a formula. In a portfolio or mixed-use model, apply a tenant-specific cap to that tenant's allocation, not automatically to the entire property expense. An audit should show the uncapped amount, the binding limit and the resulting owner exposure.

Worked example: AMER DCF: a tenant is allocated $65,000 of eligible annual expense. Its supplied lease caps this year's reimbursement at $50,000, with no other adjustment. Recovery is min($65,000, $50,000) = $50,000. The capped portion, $65,000 − $50,000 = $15,000, stays with the owner. A report showing $65,000 recovery would ignore the binding cap.

Watch the distinction: Treating a $50,000 cap as an extra charge would produce $115,000 recovery. A cap is a ceiling on this tenant's reimbursement, not an addition.

Reference: [2]

11. Bridge NOI to cash flow

Net operating income measures property operations before separately classified capital and leasing outlays under the stated model convention. Begin with property revenue, including applicable rent and recoveries, and subtract operating expenses to reach NOI. Then deduct capital work and leasing costs in the periods when the case assumes they are paid. The result is property cash flow before financing, tax and any sale proceeds in this simplified bridge. Keep categories distinct: a repair treated as recurring operating expense affects NOI, while a specified capital improvement is placed below NOI. Classification should follow the supplied case assumptions, since moving the same cost changes reported NOI even when total cash flow is unchanged. Before discounting, inspect the annual lines to ensure no outlay is omitted, duplicated or placed in the wrong year.

Worked example: AMER DCF: stated annual NOI is $500,000. The same year includes $80,000 of capital work and $20,000 of leasing costs, both assumed paid at year end and excluded from NOI. Property cash flow before financing, tax and sale proceeds is $500,000 − $80,000 − $20,000 = $400,000. The NOI line remains $500,000.

Watch the distinction: Calling $400,000 NOI hides the classification of $100,000 in capital and leasing outlays. Adding sale proceeds to NOI would further confuse operations with investment cash flow.

Reference: [2]

12. Discount cash flow and sale

A DCF values each forecast cash flow at the valuation date. State whether cash flows occur at year ends, midyears or specific dates, then use a discount convention that matches those dates. Under annual year-end discounting, divide year 1 cash flow by one plus the annual discount rate, and year 2 cash flow by that factor squared. Sale proceeds occur at the assumed exit date and are combined with that period's operating cash flow before discounting. Do not discount a year 2 sale as if received in year 1 or add it to every forecast period. Confirm whether the stated proceeds are already net of sale costs. The resulting present value is sensitive to both amount and timing. For additional case-style drills, AE practice questions can be used alongside a written cash flow bridge.

Worked example: AMER DCF, valuation at the start of year 1: cash flow is $100,000 at year 1 end and $110,000 at year 2 end. Net sale proceeds of $1,100,000 also arrive at year 2 end. At a 10% annual discount rate, value is $100,000/1.10 + ($110,000 + $1,100,000)/1.10² = $90,909.09 + $1,000,000 = $1,090,909.09.

Watch the distinction: Discounting sale proceeds only once overstates value because the sale occurs at year 2 end. Omitting year 2 operating cash understates the final receipt.

Reference: [2]

13. Audit report totals

A report total is useful only when it reconciles to the components behind it. For a simplified property statement, add base and other rent to recoveries, then subtract operating expenses to reach NOI. Check that all lines cover the same property, forecast year and currency. If the displayed NOI differs, compute the discrepancy and look for a matching omitted or reclassified line. Also inspect whether the report has separate categories for vacancy, concessions, other income or expenses, since those can explain a difference without an input error. Work from summary to detail: confirm the property total, trace the suspect year, then inspect tenant or expense-category rows. Do not adjust assumptions merely to force agreement. An explicit reconciliation identifies whether the issue lies in source inputs, reporting filters, sign conventions or interpretation.

Worked example: AMER DCF: one annual report shows $400,000 base rent, $70,000 recoveries and $100,000 operating expenses, with no other lines assumed. Expected NOI is $400,000 + $70,000 − $100,000 = $370,000. Displayed NOI of $300,000 is $70,000 low, exactly matching recoveries. Check whether that line was excluded, filtered or assigned to another period.

Watch the distinction: Accepting $300,000 because it appears in a report skips the bridge. Adding the $70,000 twice would create a different error; trace its classification first.

Reference: [2]

14. Read sensitivity outputs

Sensitivity analysis changes one stated assumption while holding the comparison basis clear. With a simplified direct-capitalisation illustration, value equals stabilised annual net income divided by the capitalisation rate. If income stays fixed, a higher rate reduces value; the relationship is nonlinear, so calculate each scenario rather than multiplying the rate change by value. A full DCF sensitivity may also change future rent, vacancy, sale value or timing, producing a different result from a stand-alone capitalisation check. When figures move to external analysis, including XL4ADW work within this track, verify the selected property, scenario, currency, units, valuation date and calculation convention. A plausible number in the wrong units or from the wrong case can make the comparison misleading. Record both the absolute value change and its direction.

Worked example: AMER DCF sensitivity check using hypothetical stabilised NOI of $100,000 per year: at a 5% capitalisation rate, value is $100,000/0.05 = $2,000,000. At 5.5%, value is $100,000/0.055 = $1,818,181.82. Holding income fixed, the higher rate lowers this simplified value by $181,818.18. Any external comparison must use the same dollars and scenario.

Watch the distinction: A 0.5-percentage-point rate rise does not mean value falls by 0.5%. Dividing by the new rate shows a roughly 9.09% decline here.

Reference: [2]

AMER discounted cash flow: case-study modelling

15. Check case area inputs

In a practical office and retail case, area is the first control total. List each distinct unit with its use, rentable area and lease status, then sum unit areas and compare them with the stated building area. A duplicate tenant row can inflate scheduled rent, recoveries and occupancy at once; a missing row can suppress them. Inspect identifiers and areas before changing rates to correct an implausible income total. If the building total differs from the unit sum, identify the exact area variance and trace it to a unit rather than spreading an adjustment across the building. The ARGUS Enterprise ASC certification exam includes an office, retail or mixed office and retail modelling case; this kind of reconciliation is a useful check before answering questions from a completed model.

Worked example: AMER mixed-use case: the building has 10,000 rentable sq ft, comprising 6,000 sq ft office and one 4,000 sq ft retail unit. The entered roll shows 6,000 + 4,000 + 4,000 = 14,000 sq ft because retail appears twice. The variance is 14,000 − 10,000 = 4,000 sq ft. Remove the duplicate and confirm the roll returns to 10,000 sq ft.

Watch the distinction: Lowering a rent rate to compensate for duplicate area might make income look plausible while leaving occupancy and recovery allocations wrong. Correct the repeated unit.

Reference: [1]; [2]

16. Build mixed-use rent

Mixed-use rent is built unit by unit because office and retail space can have different areas, rates and lease terms. Convert each quoted annual rate per square foot into annual base rent by multiplying it by that use's leased area. Then add the dollar amounts for the same forecast period. Do not average the quoted rates without weighting them by area; an unweighted average gives each use equal influence even when their footprints differ. Keep any vacant space separate from leased space, since market rent for vacant units is a forecast assumption rather than current contractual base rent. After calculating the combined amount, divide it by total leased area if a blended annual rate is useful as a check. That blended rate is a derived summary and should not replace the distinct office and retail lease inputs.

Worked example: AMER case, with both units leased for a full year: office occupies 6,000 sq ft at $40 per sq ft annually, giving $240,000. Retail occupies 2,000 sq ft at $60, giving $120,000. Total base rent is $360,000 per year across 8,000 leased sq ft. The area-weighted blended rate is $360,000 ÷ 8,000 = $45 per leased sq ft annually.

Watch the distinction: A simple average of $40 and $60 gives $50 per sq ft and overstates this case's blended rate. Weight rates by their respective leased areas.

Reference: [1]; [2]

17. Resolve an expiry year

An expiry-year schedule must preserve three distinct intervals: outgoing lease, vacancy and incoming lease. Set the forecast calendar first, then identify the old lease's final paid day, the empty months and the replacement rent commencement. Under level monthly accrual, divide each annual rent by twelve and multiply by its paid months. The void contributes zero base rent unless another specified receipt applies. This timing check matters even when the replacement annual rate exceeds the old rate: an empty quarter can more than offset the higher rate in that year's cash flow. Keep leasing costs, concessions and recoveries on separate lines if the case states them. Once the year is resolved, compare the resulting income with the full-year rates to catch accidental carryover of the old tenant or premature commencement of the new one.

Worked example: AMER case, calendar-year basis: the old tenant pays $120,000 annually through June 30, so six months produce $60,000. July, August and September are vacant and produce $0 base rent. A new tenant begins October 1 at $150,000 annually; three months produce 3/12 × $150,000 = $37,500. Total calendar-year base rent is $97,500.

Watch the distinction: Adding half of $120,000 to half of $150,000 fills the vacant quarter and overstates rent by $37,500. Count the replacement tenant's three paid months.

Reference: [1]; [2]

18. Calculate case recoveries

A case may state a single reimbursement share for eligible expenses. First determine the eligible expense amount; excluded costs should not enter the percentage base. Multiply eligible expense by the specified tenant share to obtain recovery, then subtract that recovery from eligible expense to find the owner's share. This simple allocation assumes the stated percentage applies to the full amount for the same period and that no cap, stop, vacancy adjustment or collection loss applies. If the case gives lease-specific terms, calculate each tenant separately before summing. In the operating statement, show gross expense and recovery consistently so the owner burden remains visible. A percentage that describes leased area is not automatically a recovery percentage: use the explicitly supplied lease rule. Reconcile tenant recovery plus owner exposure to the original eligible expense as a final arithmetic check.

Worked example: AMER case: annual eligible operating expenses are $90,000, and the supplied leases reimburse 75% of that amount. Recovery is $90,000 × 0.75 = $67,500. Owner exposure is $90,000 − $67,500 = $22,500. The check is $67,500 + $22,500 = $90,000, so the entire eligible expense has been allocated once.

Watch the distinction: Applying 75% to all property costs would overstate recovery if some costs were ineligible. Here the $90,000 is expressly the eligible base.

Reference: [1]; [2]

19. Complete the operating bridge

Complete a case's operating bridge before valuing it. Combine base rent and applicable reimbursements to obtain operating revenue, then subtract the gross operating expenses for the same period to get NOI. Deduct separately specified capital work below NOI to reach investment cash flow under the case convention. This ordering shows how much of gross expense the tenant recoveries offset and prevents capital work from disappearing inside an unexplained net figure. Verify that rent and recoveries cover the same calendar year and that an expense has not already been netted against recovery elsewhere. If financing or tax is excluded, label the cash flow accordingly; it is not an equity cash flow. When an output differs, recompute each bridge line in order. The first line that diverges usually identifies the input or classification needing review.

Worked example: AMER case: annual rent is $500,000, recoveries are $60,000 and gross operating expenses are $140,000. NOI is $500,000 + $60,000 − $140,000 = $420,000. Specified capital work of $20,000 is below NOI, leaving $420,000 − $20,000 = $400,000 property cash flow before financing, tax and any sale proceeds.

Watch the distinction: Subtracting only $80,000 of net expense and then adding $60,000 recovery again double counts the reimbursement. Use either a consistent net presentation or the gross bridge shown.

Reference: [1]; [2]

20. Value case exit proceeds

For a stated DCF exit, capitalise the forward net operating income at the assumed exit cap rate to estimate gross sale value. Forward means the income associated with the period after the sale under this simplified convention, not the seller's last historical rent line. Apply any stated sale cost to gross sale value to obtain net proceeds at the exit date. Finally discount those proceeds back to the valuation date using the assumed annual rate and the number of years to sale. Keep the exit cap rate and discount rate distinct: one converts forward income into a sale price, while the other converts dated proceeds into present value. Check whether the problem already describes sale proceeds as net, since deducting costs again would understate value. Add discounted operating cash flows separately when calculating total property value.

Worked example: AMER case, valued at the start of year 1: forward year 3 NOI is $120,000 annually. A hypothetical 6% exit cap rate gives gross sale value of $120,000/0.06 = $2,000,000 at year 2 end. Sale costs equal 2% × $2,000,000 = $40,000, leaving $1,960,000. At a 10% annual discount rate, present value of these exit proceeds is $1,960,000/1.10² = $1,619,834.71.

Watch the distinction: Capitalising year 3 NOI does not place the sale in year 3. Under the stated convention, sale occurs at year 2 end and is discounted two years.

Reference: [1]; [2]

21. Diagnose a rollover sensitivity

For an AMER discounted cash flow case, change one rollover assumption at a time. First identify the expiry date, then lay out the renewal and new letting paths month by month. A renewal may avoid vacancy and leasing costs while accepting a lower annual rent. A new letting may command more rent but begin later and require an allowance or commission. Compare cash flows for each forecast period, including recoveries and costs if the scenario changes them. Discount each period's difference from its payment date to the valuation date using the same rate and timing convention. If later cash flows or the exit value differ, include those changes too. A one-year rent difference alone measures the full value effect only when every other amount is held fixed.

Worked example: AMER case, with year-end receipts: renewal produces $100,000 in year 2, while delayed new letting produces $70,000. Assume identical cash flows in every other year, no changed costs, and a 10% annual discount rate. The year-2 difference is $30,000. Its present value is $30,000 ÷ 1.10² = $24,793. Renewal is worth $24,793 more under these limited assumptions.

Watch the distinction: Comparing $100,000 with $70,000 as if the $30,000 were today's value ignores the two-year delay. Discount the difference, and check whether later rent or exit proceeds also change.

Reference: [1]; [2]

EMEA discounted cash flow: Introduction to AE; Rent Roll

22. Define the EMEA rent basis

In an EMEA discounted cash flow model, the rent roll needs a consistent measurement basis before any lease calculations are useful. Record each unit's rentable area in the stated unit, its annual rent per unit of area or annual lump sum, the currency, and the dates when income starts and changes. Multiplying an area rate by area gives a whole-unit annual rent, but the forecast receives that full amount only for a complete paid year. Keep office and retail units distinct because their rents, lease events, and recovery terms may differ. Check whether an input describes passing rent, estimated market rent, or a future reviewed rent. The EMEA DCF study guide can provide further practice with this track's rent-roll and valuation sequence.

Worked example: EMEA DCF case: an office unit measures 1,000 sq m and its contractual rate is £300 per sq m per year. It is occupied and pays rent throughout the calendar year, with no concession or increase. Scheduled base rent is 1,000 sq m × £300 per sq m per year = £300,000 for that year. A partial year would require date-based proration.

Watch the distinction: A rate of £300 per sq m is not the property's £300 annual rent. Multiply by the relevant area, then apply occupancy dates and lease terms.

Reference: [4]

23. Time passing rent

Passing rent describes the rent under the existing lease, but its annual headline figure does not establish the cash received in a particular forecast year. Place commencement and expiry against the forecast calendar, then count paid months or days using the model's stated accrual convention. For level monthly rent, annual rent divided by twelve gives a monthly amount. A lease beginning midyear contributes only from commencement, unless another stated term changes the start of payment. Check any rent-free period, stepped rate, advance payment, or review date separately. When auditing the result, compare the first-year amount with the full-year run rate: a short first year can be correct even though it appears low beside the lease's annual figure. Keep currency and period labels visible.

Worked example: EMEA DCF case: an office lease begins on July 1 at £120,000 a year. Assume the forecast follows calendar years, rent accrues evenly by month, and there is no incentive or later rate change. July through December contain six paid months. Monthly rent is £120,000 ÷ 12 = £10,000; first-year rent is 6 × £10,000 = £60,000.

Watch the distinction: Entering the full £120,000 in the commencement year treats the tenant as paying from January. Count the paid portion of the forecast period before applying the annual rate.

Reference: [4]

24. Apply indexation

Indexation changes a rent rate at a specified date according to a stated index or assumed percentage. Identify the rent to which the adjustment applies, the effective date, and whether the adjustment compounds from the previous indexed rent. Calculate the revised annual rate first; then allocate the old and new rates to their respective portions of the forecast year. A January 1 increase affects a full calendar year, while a July 1 increase affects only half that year under even monthly accrual. A forecast percentage should be labelled as an assumption, since the realised index may differ. Also distinguish indexation from a market rent review: indexation applies an agreed formula, whereas a review may reset rent according to separate lease provisions and market evidence.

Worked example: EMEA DCF case: a lease pays £200,000 annually through December. Assume a hypothetical 3% indexation increase becomes effective January 1 and applies to the entire existing rent. The revised annual rate is £200,000 × 1.03 = £206,000. With twelve paid months and no other change, the new calendar year's cash rent is £206,000, which is £6,000 above the prior run rate.

Watch the distinction: Adding 3% to every forecast year's original £200,000 would miss compounding if later increases apply to the revised rate. Check each effective date and calculation base.

Reference: [4]

25. Place a rent review

A rent review belongs on its effective date, not at the beginning of an entire reporting year merely because that year contains the review. Start with passing rent for the pre-review period. Apply the reviewed annual rate only after the stated date, using the case's monthly or daily accrual convention. This produces an in-year cash amount that can differ from both annual rates. When modelling an uncertain future review, keep the assumed reviewed rate separate from the contractual passing rate so that sensitivity analysis can change one without corrupting the other. Check for a rent-free period or other incentive that starts at review; it can reduce cash received even after the headline rate rises. The case facts must establish the review outcome and timing.

Worked example: EMEA DCF case: passing rent is £240,000 a year from January through June. A stated review raises it to £270,000 a year on July 1. Assume level monthly accrual and no concession. Six old-rate months produce 6 × £20,000 = £120,000. Six new-rate months produce 6 × £22,500 = £135,000. Calendar-year rent is £255,000.

Watch the distinction: Using £270,000 for the whole review year moves the increase six months early. Split the year at July 1 and use each annual rate only for its applicable months.

Reference: [4]

26. Separate incentive and rate

A rent-free incentive changes the timing of cash receipts without necessarily changing the lease's stated annual rent. Record the contractual rate and the exact free period separately. Then calculate rent only for paid months, accounting for commencement and any later step or review. This matters in a DCF because a concession near the valuation date reduces early cash flow, which carries more present-value weight than the same amount received later. It also matters at exit: a headline annual rate may describe the tenant's future run rate while an active concession still suppresses near-term income. If the lease instead specifies a reduced rent for certain months, model that stated step rather than assuming those months are wholly free. Read the lease terms before spreading an incentive across periods.

Worked example: EMEA DCF case: a lease starts January 1 at £180,000 per year and grants January and February free. Assume even monthly rent and no other concessions. Monthly face rent is £180,000 ÷ 12 = £15,000. Ten paid months produce £150,000 first-year cash rent. If the lease remains unchanged, the next full calendar year produces £180,000.

Watch the distinction: Reducing the permanent annual rate to £150,000 carries a one-time incentive into later years. Keep £180,000 as the continuing rate and zero out only the two free months.

Reference: [4]

27. Model a lease break

A break option creates alternative lease paths. In the non-exercise path, continue the existing rent through the relevant term. In the exercise path, stop that rent at the assumed break date, insert any void period, then begin the replacement lease on its stated date. Model any specified letting costs, incentives, and recovery changes in the path where they arise. The break itself does not mean the tenant will certainly leave; a case must either state exercise or ask for scenarios. Compare each year's cash flow and, if valuing the property, discount the differences and reassess exit income where the tenancy outcome affects it. This explicit sequence prevents an apparently small rent-rate change from hiding several months without income.

Worked example: EMEA DCF case: year 3 would deliver £200,000 if the tenant stays. Assume instead that it breaks at the start of year 3, the unit is empty for January through March, and a replacement pays £180,000 annually from April 1. Nine paid months yield 9 ÷ 12 × £180,000 = £135,000. Exercise reduces year-3 rent by £65,000 before any reletting costs.

Watch the distinction: Applying the replacement tenant's £180,000 to all twelve months erases the void. The new annual rate begins only when the replacement lease starts.

Reference: [4]

28. Combine base and turnover rent

Retail turnover rent depends on the lease's stated sales measure and breakpoint. Under a base-rent-plus-overage structure, calculate fixed base rent first, then apply the agreed percentage only to qualifying sales above the threshold. The overage is zero when sales do not exceed that threshold. Keep the sales forecast, threshold, percentage, and measurement year aligned; an annual sales figure should not be compared with a monthly breakpoint without conversion. Some leases use different turnover formulas, so the case wording controls whether the percentage supplements base rent or substitutes for a minimum. A useful audit is to calculate the excess sales separately, check its units, and then add the resulting overage to the fixed rent. Changes in sales can affect recoveries or valuation only if the supplied assumptions connect them.

Worked example: EMEA DCF case: retail base rent is £120,000 per year plus 4% of annual sales above £3 million. Assume qualifying sales for the same year are £3.5 million. Excess sales are £3.5 million − £3 million = £500,000. Overage rent is 0.04 × £500,000 = £20,000. Total annual rent is £120,000 + £20,000 = £140,000.

Watch the distinction: Taking 4% of all £3.5 million sales would give £140,000 of overage and ignore the breakpoint. Apply the rate only to the £500,000 excess.

Reference: [4]

EMEA discounted cash flow: Recoveries, Investment and Valuation; Portfolio Reporting & Sensitivity

29. Allocate service charges

A service charge recovery transfers an eligible operating cost from owner to tenants according to the supplied lease terms. Begin with the gross cost. Determine which portion is recoverable, which tenants bear it, and whether vacancy, caps, exclusions, or timing affect collection. Record the gross service charge as an operating expense and the tenant reimbursement as recovery income, or use an equivalent net presentation consistently. The owner's exposure is gross cost minus actual recovery. This separation lets you diagnose whether a change in cost affects net operating income or is offset by tenant payments. Do not assume every property expense is recoverable: repairs, management, insurance, utilities, and vacant-space shares may receive different treatment under a particular case's leases. Trace the amount from cost allocation to tenant billing and then to the income report.

Worked example: EMEA DCF case: the year's service charge is £80,000. The supplied lease assumptions make 90% recoverable, with no cap or collection shortfall. Tenant recovery is 0.90 × £80,000 = £72,000. Owner exposure is £80,000 − £72,000 = £8,000. In a gross presentation, enter £80,000 expense and £72,000 recovery; the net effect on operating income is an £8,000 reduction.

Watch the distinction: Subtracting only £8,000 as an expense while also adding £72,000 of recovery counts the reimbursement twice. Reconcile gross expense, recovery, and owner exposure.

Reference: [4]

30. Find irrecoverable cost

Irrecoverable cost has two possible sources: an unrecovered portion of an otherwise eligible charge and an expense excluded from tenant recovery altogether. Calculate each separately. For an eligible charge, subtract actual tenant reimbursement from the gross amount. Then add any wholly nonrecoverable expenses to find the owner's total operating burden. Keep capital expenditure outside this operating-cost bridge if the case treats it below net operating income. A model audit should show both why a cost was not recovered and where it appears in the cash flow. For example, a shortfall may arise from vacant space or a contractual limit, while a separately excluded expense never enters the tenant allocation. This distinction helps you test a recovery assumption without accidentally changing the underlying gross cost.

Worked example: EMEA DCF case: £80,000 of eligible service charges generates £72,000 of tenant reimbursement. The unrecovered eligible portion is £80,000 − £72,000 = £8,000. A separate £20,000 operating expense is wholly nonrecoverable under the supplied assumptions. Owner cost totals £8,000 + £20,000 = £28,000. Gross expenses are £100,000, and £72,000 of recovery offsets them.

Watch the distinction: Calling the £20,000 excluded expense the entire irrecoverable amount overlooks the £8,000 gap on eligible charges. Add both owner-borne components.

Reference: [4]

31. Distinguish NOI and DCF cash

Net operating income measures property operations before separately identified capital and investment outlays. Start with rent and other operating income, including tenant reimbursements. Subtract gross operating expenses on the same basis. The result is NOI; subtract stated capital expenditure afterward to reach cash flow available for the DCF before financing and tax, if those items are outside the case. This order keeps a major roof replacement or other capital project from masquerading as an ordinary service charge. It also makes reports easier to reconcile: the rent roll supports rent, recovery schedules support reimbursements, expense schedules support operating cost, and the capital plan explains the bridge below NOI. If an expense classification differs in a supplied case, follow its definitions consistently and explain the bridge rather than mixing measures.

Worked example: EMEA DCF case: annual rent is £500,000, tenant recoveries are £100,000, and gross operating expense is £150,000. NOI is £500,000 + £100,000 − £150,000 = £450,000. The case separately specifies £50,000 of capital expenditure in the same year. Cash flow before financing, tax, and sale proceeds is £450,000 − £50,000 = £400,000.

Watch the distinction: Reporting £400,000 as NOI hides the £50,000 capital deduction inside operations. Show £450,000 NOI first, then bridge to £400,000 cash flow.

Reference: [4]

32. Calculate terminal proceeds

A terminal value estimates sale value at the end of the holding period from an assumed forward annual income and exit yield. Choose the income that belongs after sale, such as the stated next-year stabilised NOI, and divide it by the yield expressed as a decimal. Then deduct selling costs according to the case's specified basis to obtain net proceeds. The terminal calculation takes place at the sale date; discounting those proceeds to the valuation date is a separate step. Verify that the yield and income are compatible: an annual whole-property NOI requires a whole-property yield, and a gross income figure should not silently replace net income. The EMEA DCF training listing identifies investment and valuation as course areas; the exit convention itself must come from the case assumptions.

Worked example: EMEA DCF case: assume the first full year after sale has £300,000 NOI and the hypothetical exit yield is 5%. Gross value at the sale date is £300,000 ÷ 0.05 = £6,000,000. Sale costs equal 1% of gross value, or £60,000. Net sale proceeds are £5,940,000. This amount still needs discounting if sale occurs after the valuation date.

Watch the distinction: Using the final holding-year cash flow as forward NOI may capitalise a year containing unusual costs or incentives. Use the income definition and forward period stated in the case.

Reference: [4]

33. Discount a dated exit

A DCF assigns each receipt to its expected date and converts it to value at the valuation date. With annual year-end timing, divide a year-1 amount by one plus the discount rate and a year-2 amount by that factor squared. At sale, add net sale proceeds to the operating cash flow received at the same date before applying the year-2 discount factor. This avoids discounting the exit one year too many or treating it as cash received today. Confirm that sale proceeds are net of any specified selling costs and that operating cash flows have already reflected the case's expenses and capital items. A quick reasonableness check is that the present value of positive future receipts must be less than their undiscounted sum when the discount rate is positive.

Worked example: EMEA DCF case: receive £200,000 at the end of year 1, then £220,000 cash flow and £5,000,000 net sale proceeds at the end of year 2. At an 8% annual discount rate, value is £200,000 ÷ 1.08 + (£220,000 + £5,000,000) ÷ 1.08². That is £185,185 + £4,475,309 = about £4,660,494.

Watch the distinction: Discounting the £5 million sale proceeds at year 1 overstates value because the sale occurs at year 2. Match every amount to its stated receipt date.

Reference: [4]

34. Read portfolio measures

A portfolio ratio needs weights that reflect the size of each property. If each property's stated yield is its annual net income divided by value on a comparable basis, multiplying yield by value reconstructs that property's income. Sum those incomes and divide by total value to get the portfolio income-to-value ratio. A simple average gives each property equal influence even when values differ. Before combining figures, verify a common currency, valuation date, income period, and yield definition. An exit yield, initial yield, and DCF discount rate describe different things; averaging them together produces a meaningless figure. Portfolio reports should therefore retain the property-level inputs so you can explain why the aggregate moves when a large asset changes, even if smaller assets stay constant.

Worked example: EMEA DCF portfolio: asset A is worth £4 million and has a comparable 5% income-to-value yield, implying £200,000 annual net income. Asset B is worth £6 million at 7%, implying £420,000. Combined income is £620,000 and combined value is £10 million. The portfolio ratio is £620,000 ÷ £10 million = 6.2%, rather than the unweighted 6%.

Watch the distinction: Averaging 5% and 7% to get 6% gives the £4 million asset the same weight as the £6 million asset. Use income totals and value totals.

Reference: [4]

35. Interpret a rent sensitivity

A rent sensitivity measures how a specified change in an assumption alters value. First establish a base case, then change the rent amount for the relevant period while holding discount rate, later rents, costs, and sale assumptions fixed if the question requires isolation. The present-value effect equals the changed cash flow divided by the discount factor for its payment date. A one-period rent reduction therefore has a smaller effect at today's date than its undiscounted amount. In a fuller model, lower rent might also reduce turnover-based income, recoveries, or terminal NOI, so the isolated calculation would understate the total change. State what remains fixed. For practice, the AE practice questions can be used to check whether a sensitivity changes one period or the whole forecast.

Worked example: EMEA DCF case: suppose year-1 cash rent, received at year end, falls by £100,000. Assume all other cash flows and exit proceeds are unchanged and the annual discount rate stays 10%. The value change is −£100,000 ÷ 1.10 = −£90,909, rounded to the nearest pound. The reduced-rent scenario is therefore about £90,909 lower in present value.

Watch the distinction: Subtracting £100,000 directly from today's value ignores the year's delay. Also check whether the scenario changes later income; this calculation assumes it does not.

Reference: [4]

EMEA discounted cash flow: case-study modelling

36. Reconcile the EMEA case roll

For an EMEA DCF office and retail case, reconcile the physical area before forecasting rent. List every unit with its use, area, lease status, and tenant or vacancy label. Sum office and retail areas separately, then compare their combined total with the case's stated property area. A discrepancy can come from an omitted unit, a duplicate, a mistyped area, or confusion between measurement bases. Do not repair the total by changing a rent rate: area feeds rent, occupancy, and potentially expense allocation, so the wrong area can distort several outputs. Once the area agrees, test each unit's annual rent as area times rate where applicable. The EMEA DCF certification listing confirms that the practical section uses an office, retail, or mixed case.

Worked example: EMEA DCF case: office unit A has 500 sq m, office unit B has 700 sq m, and retail has 300 sq m. Expected total area is 500 + 700 + 300 = 1,500 sq m. A model showing 1,400 sq m is short by 100 sq m. Inspect unit-level entries to find the missing or misstated 100 sq m before trusting rent or recovery totals.

Watch the distinction: Treating a £ rent total that looks plausible as proof the roll is complete can hide a missing unit. Reconcile area independently of income.

Reference: [3]; [4]

37. Combine review and concession

A reviewed rent and a concession can begin on the same date but affect different parts of the calculation. First divide the year at the review date. Calculate rent for the months before review at the old annual rate. Calculate the post-review monthly rate from the new annual figure, then exclude only the months covered by the concession. The revised annual rate remains the run rate after the free period; cash received during the review year is lower because one or more months are unpaid. This sequence is useful when a report shows a surprisingly small increase despite a large reviewed rate. Audit the event dates and the number of paid months before assuming the review was entered incorrectly. If the concession changes recoveries as well, treat that as a separate stated lease term.

Worked example: EMEA DCF case: rent is £240,000 annually for January through June, then reviews to £300,000 annually on July 1. July is free, and all other months are paid evenly. Six old-rate months yield 6 × £20,000 = £120,000. August through December yield 5 × £25,000 = £125,000. Total calendar-year cash rent is £245,000; the later annual run rate is £300,000.

Watch the distinction: Counting July at the reviewed rate produces £270,000 for the year and loses the free month. Apply the review, then exclude July's £25,000 payment.

Reference: [3]; [4]

38. Build a void and reletting

An expiry-year rent schedule needs three distinct intervals: the outgoing tenant's paid period, vacancy, and the replacement tenant's paid period. Start and end dates determine the months in each interval. Convert each annual rate to the case's monthly amount, multiply by paid months, and add the pieces. Vacancy contributes zero base rent unless the case supplies another income source. A higher replacement rent can still leave the year below the old annual run rate when the gap is long enough. In a full DCF, examine associated leasing fees, incentives, and recoveries as separate lines; the base-rent schedule alone does not measure all rollover effects. Check that outgoing and incoming rents do not overlap and that the model does not silently fill vacant months.

Worked example: EMEA DCF case: an existing lease at £240,000 per year ends June 30. July through September are vacant. A replacement starts October 1 at £300,000 per year. Under even monthly accrual, January through June provide 6 × £20,000 = £120,000; October through December provide 3 × £25,000 = £75,000. Total calendar-year base rent is £195,000.

Watch the distinction: Taking six months at £240,000 and six months at £300,000 assumes immediate reletting. The three-month void removes July, August, and September rent.

Reference: [3]; [4]

39. Split mixed-use recoveries

Mixed-use recoveries should follow each unit's lease terms, even when a common charge is stated per square metre. Allocate the gross charge to office and retail using their respective areas. Apply each use's reimbursement percentage to its allocated charge, then sum tenant recoveries. Subtract the sum from gross cost to find the owner's share. This method prevents a strongly recovering office lease from concealing a weaker retail recovery provision. Check whether the stated rate applies to all measured area, only occupied units, or another defined base; the example's result depends on the supplied basis. In an income report, the gross charge and recovery should reconcile to the same owner burden as the unit-by-unit calculation. A changed tenant mix can alter the net cost even if total area and gross expense stay constant.

Worked example: EMEA DCF case: a charge of £100 per sq m applies to 800 sq m of office and 200 sq m of retail. Office reimburses 100%; retail reimburses 50%. Gross charge is £80,000 + £20,000 = £100,000. Recoveries are £80,000 + £10,000 = £90,000. Owner exposure is £100,000 − £90,000 = £10,000, entirely from the retail allocation.

Watch the distinction: Applying one 90% recovery rate to both units matches the aggregate here but misstates each lease's obligation. Keep the office and retail calculations separate.

Reference: [3]; [4]

40. Reconcile case cash flow

A case cash-flow audit should move through a clear operating bridge before considering value. Sum contractual and variable rent for the forecast period, add tenant reimbursements, and subtract gross operating expenses to obtain net operating income. Then subtract capital work and any other separately stated below-NOI outlays to obtain investment cash flow for that period. Check that a recovery has not both reduced the gross expense input and appeared again as income. Also verify that capital work has not been included in operating expenses and deducted twice. The bridge helps locate discrepancies: if NOI is wrong, examine rent, recovery, or operating cost; if NOI agrees but DCF cash flow differs, examine capital and leasing items. Use the case's date and currency convention for every line.

Worked example: EMEA DCF case: annual rent is £400,000, tenant recoveries are £90,000, and gross operating expenses are £120,000. NOI is £400,000 + £90,000 − £120,000 = £370,000. The case also specifies £20,000 of capital work in that year. Cash flow before financing, tax, and any sale proceeds is £370,000 − £20,000 = £350,000.

Watch the distinction: Calling £350,000 NOI moves capital work into operating performance. Report £370,000 NOI and show the £20,000 deduction in the cash-flow bridge.

Reference: [3]; [4]

41. Complete the case DCF

For an EMEA discounted cash flow case, fix the valuation date and treat each year-end receipt as a separate dated amount. The holding period ends after year 2, so year 3 forward net operating income (NOI) supplies the income basis for the exit value; it is not another holding-period receipt. Divide that forward NOI by the stated exit yield, then deduct sale costs using their stated basis. Add the resulting net proceeds to year 2 operating cash flow and discount the combined year 2 amount. Discount year 1 cash flow once. This sequence prevents the common errors of counting year 3 income twice or placing the sale a year late. Check that NOI, cash flow, yield and costs are all in compatible currency and annual units. The EMEA DCF course list identifies valuation as part of this track.

Worked example: Assume an EMEA DCF valued today, with £200,000 operating cash flow at year 1 and £220,000 at year 2. Year 3 forward annual NOI is £240,000. At a hypothetical 6% exit yield, gross exit value at year 2 is £240,000 ÷ 0.06 = £4,000,000. Sale costs of 1% of gross value leave £3,960,000. At a 10% annual discount rate, present value is £200,000 ÷ 1.10 + (£220,000 + £3,960,000) ÷ 1.10² = £3,636,364, rounded.

Watch the distinction: Adding the £240,000 forward NOI as a third annual receipt counts income already represented by the capitalised exit value. Check the sale date and cash-flow dates first.

Reference: [3]; [4]

42. Audit the portfolio case

A portfolio figure is useful only after its property-level components reconcile on the same basis. First confirm that each property has the same reporting period, currency and income measure. NOI is rent and other operating income less operating expenses, including the effect of recoveries; it is distinct from cash flow after capital spending. Next, add the property NOI figures and compare the result with the portfolio total. If they differ, trace the gap through the included properties, ownership shares, report filters, period settings and classification of recoveries or expenses. The amount and direction of the discrepancy can point to a missing line, a duplicated property or a different definition of NOI. A correct arithmetic total does not prove that each property model is sound, but it gives a necessary control before interpreting portfolio yield or sensitivity.

Worked example: An EMEA DCF case shows property A with £300,000 annual NOI and property B with £500,000 for the same year, both at 100% ownership and in pounds. The expected portfolio NOI is £300,000 + £500,000 = £800,000. A report showing £900,000 is £100,000 too high. Recheck property inclusion, ownership and operating lines before using that portfolio figure in a yield calculation.

Watch the distinction: A £900,000 portfolio figure is not validated merely because it appears in a report. Reconcile its property list and income definition to the two £800,000 source totals.

Reference: [3]; [4]

EMEA traditional valuation: Introduction to AE; Rent Roll

43. Set traditional valuation units

Traditional valuation begins with a consistent income unit. Record the valuation date, currency, unit area and whether rent is quoted per square metre per year or as a whole-unit annual amount. Multiply area by the market rent per square metre to obtain annual estimated rental value (ERV). Only then apply a whole-property yield to annual net income. Check whether the stated rent is gross or net of owner costs; a yield applied to net income cannot be used directly on a gross rent without an adjustment. Timing matters as well: current passing rent, a later review and the rent expected at reversion may be different amounts. The valuation date determines how far each future receipt must be discounted. Keeping these labels beside every figure helps reveal area errors and prevents a per-square-metre rate from being mistaken for an annual property income.

Worked example: In an EMEA traditional valuation at 1 January, an 800 sq m office unit has a hypothetical ERV of £250 per sq m per year. Whole-unit annual ERV is 800 × £250 = £200,000. If an illustrative 5% yield applies to that level annual net income from the next year-end onward, the simple capitalised value is £200,000 ÷ 0.05 = £4,000,000. Dividing £250 by 5% would value only a per-square-metre figure.

Watch the distinction: A quoted £250 per sq m is a rate, not the unit's annual income. Multiply by the relevant area and account for owner costs before applying a net-income yield.

Reference: [5]; [6]

44. Identify the remaining term

The remaining lease term answers how long the current passing rent is expected to continue from the valuation date. It does not change the annual rent rate. Calculate the undiscounted term income by allocating that rate to the actual months, then locate each payment under the stated payment convention. A rent received monthly has a different present value from the same total received at the end of the term. The lease end also sets the earliest point for an assumed reversion to market rent, subject to any void, incentive or other case facts. In a traditional term-and-reversion calculation, value the finite passing-rent stream and the later reversion separately, then add their present values. This makes it possible to diagnose whether an apparent value change comes from rent level, remaining time, or the rate used to discount future income.

Worked example: At an EMEA valuation date, a lease has 18 months remaining at £120,000 annual net rent, accrued evenly. The undiscounted amount is £120,000 × 18 ÷ 12 = £180,000. Suppose £120,000 arrives at year 1 and £60,000 at month 18. With a hypothetical 6% effective annual discount rate, present value is £120,000 ÷ 1.06 + £60,000 ÷ 1.06^1.5, about £168,186, before any reversion.

Watch the distinction: Multiplying annual rent by 1.5 gives term income, not present value. Discount the dated receipts and value any later market-rent interest under its own assumptions.

Reference: [5]; [6]

45. Derive ERV from the roll

Estimated rental value (ERV) expresses an assumed market rent for the space at a specified date. Passing rent is what the existing lease currently pays. To derive ERV from a rent roll, identify each unit's area and use-specific market rate, multiply them, and sum the resulting annual amounts. Keep the rent basis consistent: a market quote per square metre, a whole-unit lease rent and net income after owner costs cannot be compared without conversion. The difference between passing rent and ERV signals potential rental growth or decline at the relevant review or reversion date; it is not necessarily cash available today. A lease may remain above or below market for years, and a future letting may involve a void or incentive. For focused practice, the EMEA traditional valuation guide keeps those timing and income measures together.

Worked example: An EMEA traditional valuation case has a 1,000 sq m unit paying £200,000 annual passing rent. Assume market ERV is £240 per sq m per year on the same gross-rent basis. Annual ERV is 1,000 × £240 = £240,000. The £40,000 difference is potential annual uplift when market rent can take effect. It is not added to today's passing income while the existing lease remains unchanged.

Watch the distinction: Copying passing rent into ERV hides an under-rented or over-rented lease. ERV comes from the stated market assumptions, with area and rent basis matched.

Reference: [5]; [6]

46. Date a traditional rent review

A review changes the income schedule only from its effective date under the case assumptions. Start with the valuation and forecast dates, then divide the year at the review date. Apply passing rent to the months before the change and reviewed rent to the months after it. If the review outcome is uncertain, a model can compare explicit outcomes, but it should not silently treat a forecast market rent as a contractual increase. Check the lease's payment timing and any stated delay or adjustment separately; the simple monthly allocation assumes rent accrues evenly and the revised rate takes effect as given. For traditional valuation, the reviewed rent also affects the term income valued before reversion. A sound audit compares the schedule's partial-year cash rent with the annual rate shown on either side of the review.

Worked example: Assume an EMEA traditional valuation calendar year in which annual rent is £180,000 through 30 April and a specified review sets it at £210,000 from 1 May. With even monthly accrual and no other adjustments, four old-rate months contribute £180,000 × 4 ÷ 12 = £60,000. Eight new-rate months contribute £210,000 × 8 ÷ 12 = £140,000. Total cash rent for the year is £200,000.

Watch the distinction: Using £210,000 for the whole year applies the reviewed rate four months early. Date the change before calculating the year's income or valuing the term.

Reference: [5]; [6]

47. Value an incentive period

An incentive can postpone cash rent while leaving the agreed annual lease rate intact. Record both the face rent and the period for which payment is waived. In an income schedule, the free months produce no base-rent receipt; paid months use the full contractual monthly rate. The concession therefore affects near-term cash flow and present value, even if later years receive the full annual amount. Check whether the stated free period begins at lease commencement, follows a void, or starts at another date. Also distinguish free base rent from any other charges if the case specifies different treatment. In traditional valuation, an immediate capitalisation of the headline annual rent would overstate value if the incentive period has not been allowed for. The valuation adjustment depends on when the missed receipts would otherwise have arrived.

Worked example: An EMEA traditional valuation case grants three free months from 1 January on a new lease with £240,000 annual base rent. Even monthly accrual gives £20,000 per month. January through March contribute £0; April through December contribute 9 × £20,000 = £180,000. The first-year concession is £60,000 relative to a fully paid year. Assuming no later change, the next full year's base rent is £240,000.

Watch the distinction: Reducing the annual lease rate permanently to £180,000 confuses first-year receipts with face rent. Keep the £240,000 rate and date the three waived months.

Reference: [5]; [6]

48. Keep uses distinct

Office and retail space can have different market rents, lease terms and letting risks. Calculate each use's ERV from its own area and annual rate before adding the whole-property amounts. This prevents a high retail rate from being applied to office area or an average rate from concealing a wrong unit classification. Keep units consistent, particularly when one source quotes rent per square metre and another quotes a whole-unit annual amount. If the purpose is valuation rather than a rent-roll check, distinguish gross ERV from net income available to capitalise after any owner costs. An aggregate ERV is useful for reporting, but retaining its office and retail components lets you test a use-specific review, expiry or sensitivity. Reconcile the combined area to the building's rentable area as a separate control.

Worked example: An EMEA traditional valuation case has 700 sq m of office at a hypothetical £200 per sq m per year and 300 sq m of retail at £300 per sq m per year. Office annual ERV is 700 × £200 = £140,000. Retail annual ERV is 300 × £300 = £90,000. Combined ERV is £230,000 on 1,000 sq m; it does not imply either use has a £230 average rate.

Watch the distinction: Multiplying all 1,000 sq m by the retail rate would produce £300,000 and overstate ERV by £70,000. Preserve each use's area and rate.

Reference: [5]; [6]

EMEA traditional valuation: Advanced Rent Roll, Investment and Valuation; Portfolio Reporting, Analysis & Sensitivity

49. Capitalise rack rent

Rack rent describes an income position in which current rent is at the assumed market level, so there is no separate under-rent or over-rent term to value. For a simplified perpetuity with level annual net income first received at the end of year 1, capitalised value equals annual net income divided by the stated yield. That shortcut assumes the income continues indefinitely, the yield captures the required return for that stream, and there are no separately modelled changes in rent or cost. Check that the income is sustainable and net on the yield's basis. If there is a rent-free period, imminent expiry, capital outlay or future change in rent, model or adjust that feature rather than applying the shortcut to an unqualified headline. In a report, compare the capitalised result with the input annual income and yield to catch unit mistakes.

Worked example: In a hypothetical EMEA traditional valuation, a rack-rented property provides £300,000 level annual net rent, first received at the end of year 1 and assumed to continue indefinitely. At a stated 6% annual yield, value is £300,000 ÷ 0.06 = £5,000,000 before any separately specified costs. Check: 6% of £5,000,000 is £300,000, matching the assumed annual income.

Watch the distinction: The £5,000,000 result relies on level net income starting at the stated time. A temporary concession or future rent change requires separate treatment.

Reference: [5]; [6]

50. Value term and reversion

Term and reversion separates two income interests. The term is the remaining finite stream of passing net rent. The reversion represents the later income assumed to begin when that term ends, often based on estimated rental value. Value each dated term receipt using the stated discount rate. If the reversion is a level perpetuity, divide its annual net income by the stated reversion yield to obtain a value at the reversion date, then discount that amount back to the valuation date. Do not confuse the yield used to capitalise the later income with the rate used to discount dated amounts; a case may specify different rates. A reconciliation should show the term receipts, reversion date, capitalised amount and present values separately. This structure also reveals how a longer lease at below-market passing rent delays the benefit of higher ERV.

Worked example: An EMEA traditional valuation receives £200,000 net rent at each of the next two year ends. From year 3 onward, level annual net rent is £250,000. A hypothetical 5% reversion yield gives £250,000 ÷ 0.05 = £5,000,000 at year 2. At a 6% annual discount rate, today's value is £200,000 ÷ 1.06 + (£200,000 + £5,000,000) ÷ 1.06², about £4,816,661.

Watch the distinction: Discounting the £5,000,000 as though it were available today overstates value. It is a year-2 figure and must be discounted from that date.

Reference: [5]; [6]

51. Recognise over-renting

A lease is over-rented when its passing rent exceeds the assumed market rent. The excess can have value during the remaining lease term, but it should not flow into a reversion that is explicitly assumed to reset to ERV. First schedule the above-market receipts for their remaining dates. Then use market net rent, not passing rent, to calculate the capitalised reversion at the reset date. Discount both components under the stated convention. The difference between them depends on how long the tenant continues paying the higher amount and on any case assumptions about lease performance, void or costs. An audit cue is a reversionary income line that still equals passing rent after a specified market reset. For a portfolio, keep this timing visible rather than reporting only a single blended yield.

Worked example: Assume an EMEA traditional valuation receives £300,000 annual net rent at year 1 and year 2. From year 3, net ERV of £240,000 applies indefinitely. At a hypothetical 5% reversion yield, the year-2 reversion is £240,000 ÷ 0.05 = £4,800,000. Discounting at 7% gives £300,000 ÷ 1.07 + (£300,000 + £4,800,000) ÷ 1.07², about £4,734,911.

Watch the distinction: Capitalising £300,000 after the year-2 reset assumes the over-rent lasts forever. Use the £240,000 market income for the stated reversion.

Reference: [5]; [6]

52. Distinguish bid and total cost

A property bid and an all-in acquisition cost answer different questions. If a case states purchaser costs as a percentage of the bid, total cost equals bid plus that percentage of bid. To turn a fixed all-in budget into the maximum bid, divide the budget by one plus the cost rate. Multiplying the budget by one minus the rate is only an approximation and gives a different result because the percentage applies to the bid, not to the total budget. Keep the cost convention explicit: a fixed fee, a percentage of price and a percentage of total cost require different equations. In traditional valuation, this bridge can be used after deriving a property value to assess whether it fits a buyer's budget. It does not alter the property's rental income or the yield calculation.

Worked example: An EMEA traditional valuation buyer has a hypothetical £5,000,000 all-in limit. Assume purchaser costs equal 2% of the property bid, with no other costs. Let bid be B: B + 0.02B = £5,000,000, so B = £5,000,000 ÷ 1.02 = £4,901,961, rounded. Costs are about £98,039. Their sum is £5,000,000, allowing for rounding.

Watch the distinction: Subtracting 2% of the £5,000,000 budget gives £4,900,000, but the stated cost percentage applies to the bid. Solve the equation using that basis.

Reference: [5]; [6]

53. Aggregate portfolio yield

A portfolio income-to-value measure uses aggregate annual net income divided by aggregate property value, with both totals measured on a consistent date and basis. This is equivalent to a value-weighted average of individual income-to-value ratios. A simple average of property yields gives a small asset the same influence as a large one, so it generally produces a different answer. Confirm that income is comparable across assets: passing net income, stabilised net income and ERV answer different questions. Likewise, do not mix gross rents with net rents or values before and after purchaser costs without a stated reason. Keep the property components visible so a surprising portfolio movement can be traced to a changed rent, value or asset mix. The AE practice questions offer another place to rehearse these reconciliations.

Worked example: An EMEA traditional valuation portfolio has property A worth £4,000,000 with £200,000 annual net income and property B worth £6,000,000 with £420,000. Their individual income-to-value ratios are 5% and 7%. Combined income is £620,000; combined value is £10,000,000. The portfolio ratio is £620,000 ÷ £10,000,000 = 6.2%, also (40% × 5%) + (60% × 7%).

Watch the distinction: A simple average gives 6%, which ignores the larger property's greater value. Weight the ratios by value, or divide total comparable income by total value.

Reference: [5]; [6]

54. Test yield sensitivity

For a fixed level annual net income capitalised as a perpetuity, value moves inversely with the yield: value equals income divided by yield. To test sensitivity, hold income and all other assumptions constant, calculate value at each yield, and compare both the currency change and its direction. A yield increase reduces value because the same income is divided by a larger rate. The response is not linear: equal percentage-point yield steps need not produce equal value changes. This simplified test isolates capitalisation risk; it does not include simultaneous changes to rent, vacancy, incentives or the remaining lease term. In a term-and-reversion model, a change to the reversion yield directly changes the capitalised future interest and then its discounted present value. State which yield changed before interpreting a sensitivity output.

Worked example: An EMEA traditional valuation assumes £300,000 annual net income indefinitely, first received at the next year-end. At a hypothetical 5% yield, value is £300,000 ÷ 0.05 = £6,000,000. At 6%, with income unchanged, value is £300,000 ÷ 0.06 = £5,000,000. The one-percentage-point yield increase reduces this simplified value by £1,000,000, or about 16.7% of the original value.

Watch the distinction: A one-percentage-point yield rise does not mean value falls by one percent. Recalculate income divided by each yield; the relationship is inverse.

Reference: [5]; [6]

EMEA traditional valuation: case-study modelling

55. Verify traditional case ERV

In a mixed-use traditional valuation case, verify estimated rental value from the unit schedule before accepting a report total. List each office and retail unit's area and market rent basis, multiply within each use, and sum the annual ERVs. Reconcile the areas to the stated building area so a missing or duplicated unit does not hide behind a plausible rent total. If the report exceeds your calculation, inspect the use-specific rates, unit areas and whether an additional rent line has been included. The size of the difference can help locate the error: a £20,000 excess might correspond to an incorrect rate over a known area or an unintended extra unit. Keep this ERV reconciliation distinct from passing rent, which follows existing lease terms. Only after the ERV inputs are sound should you use them in a reversion.

Worked example: An EMEA traditional case has 600 sq m of office at a hypothetical £300 per sq m annually and 400 sq m of retail at £250. Office ERV is 600 × £300 = £180,000; retail ERV is 400 × £250 = £100,000. Total annual ERV is £280,000 across 1,000 sq m. A report showing £300,000 is £20,000 too high, so check unit areas and rates.

Watch the distinction: Treating the £300,000 report total as a market assumption bypasses the unit calculation. Rebuild ERV from the stated areas and use-specific rates.

Reference: [5]; [6]

56. Schedule a retail expiry

An expiry schedule needs three separate states: the outgoing tenant's rent, any vacancy, and the replacement tenant's rent. Place each state on the calendar before adding income. Continuing office rent runs independently of the retail expiry, so a retail void should not remove office receipts. For the expiring unit, use its old annual rate through the lease end, zero base rent during the specified vacant months, and the new annual rate from the replacement start. The replacement's full annual rate describes its steady income, not necessarily what is received in its first partial year. This schedule supplies the term cash flows used in traditional valuation and helps explain why a higher market rent may still yield lower short-term cash income. If letting costs or incentives are given, date them separately from base rent.

Worked example: In an EMEA traditional case, office rent continues at £180,000 annually. Retail pays £100,000 for all of year 1, becomes vacant from January through June of year 2, then a replacement pays £120,000 annually from 1 July. Year 1 rent is £180,000 + £100,000 = £280,000. Year 2 rent is £180,000 + (£120,000 × 6 ÷ 12) = £240,000.

Watch the distinction: Using £120,000 retail rent for all of year 2 fills six vacant months. Date the replacement start and retain the continuing office income.

Reference: [5]; [6]

57. Calculate reversionary rent

Reversionary rent is the market-based annual income assumed to apply at a specified future reset or reletting date. Derive it from each unit's market rent and area, then total the resulting annual amounts. Passing rent may differ because existing leases were agreed at another time or have not yet reached review or expiry. Check that office and retail rates are matched to the right areas, that all figures use the same currency and annual basis, and that the stated market rents are gross or net as required by the subsequent valuation. If a yield will be applied to net reversionary income, deduct any stated owner costs before capitalising. The reversion date is as important as the income level: a higher ERV beginning later may have less present value than the same income beginning now. Keep the current and future income lines separate in the case report.

Worked example: An EMEA traditional case assumes that, at reversion, 600 sq m of office earns £320 per sq m per year and 400 sq m of retail earns £300. Office annual ERV is 600 × £320 = £192,000. Retail annual ERV is 400 × £300 = £120,000. Combined annual gross ERV is £312,000. Use that amount only from the assumed reversion date, with any required owner-cost adjustment.

Watch the distinction: Adding the £312,000 ERV to passing rent double counts the same space. It replaces the relevant passing income at the stated reversion date.

Reference: [5]; [6]

58. Complete a term and reversion case

A case with changing term income and a later stable reversion needs both a dated income schedule and a clearly timed capitalised value. Enter the year 1 and year 2 net receipts separately. If level reversionary net income begins in year 3, divide it by the stated reversion yield to obtain a value at the end of year 2 under the year-end perpetuity convention. Add year 2 operating income to that year-2 reversion value, then discount both back two years; discount year 1 income one year. Check that the reversion is not also counted as a year 3 receipt. The traditional valuation course list places investment, valuation and reporting within this track; the case arithmetic still depends on its stated income and rate assumptions.

Worked example: An EMEA traditional case has £280,000 net income at year 1, £300,000 at year 2, then £320,000 annually from year 3 onward. At a hypothetical 5% reversion yield, the year-2 reversion is £320,000 ÷ 0.05 = £6,400,000. With a 6% annual discount rate, today's value is £280,000 ÷ 1.06 + (£300,000 + £6,400,000) ÷ 1.06², about £6,227,127.

Watch the distinction: Adding the £6,400,000 reversion at today's date skips two years of discounting. It is valued at year 2, alongside that year's £300,000 receipt.

Reference: [5]; [6]

59. Stress the case reversion yield

A reversion-yield stress test isolates the effect of the capitalisation assumption on a fixed future net income. Calculate the capitalised reversion at each stated yield, using the same annual income and reversion date. Subtract the two values to see the change at that future date. If the question asks for today's value effect, discount that difference from the reversion date using the stated discount convention. Keeping those dates separate prevents a year-2 sale-value change from being presented as an immediate change of equal size. A higher yield lowers capitalised value, with larger effects when the yield is low relative to the income. This test holds rent, void, costs and timing constant; changing those at the same time would make it harder to identify what caused the value movement.

Worked example: An EMEA traditional case has a fixed £300,000 annual net reversion beginning after the stated reversion date. At a hypothetical 5% yield, capitalised value at that date is £300,000 ÷ 0.05 = £6,000,000. At 5.5%, it is £300,000 ÷ 0.055 = about £5,454,545. The higher yield reduces reversion-date value by about £545,455. If reversion occurs later, discount that difference to find its effect today.

Watch the distinction: The £545,455 difference is measured at the reversion date. Calling it today's value change without discounting overstates its present effect.

Reference: [5]; [6]

60. Read passing and reversionary yields

Passing and reversionary income-to-value ratios use the same property value but different annual income measures. Divide current passing net rent by value to describe the current income relationship. Divide assumed market net rent at reversion by the same value to show the relationship if that market income were in place. A higher reversionary ratio can signal potential rental uplift, but it does not show when that uplift begins or what it costs to obtain. The lease term, reviews, void, incentives and capital spending still affect value. Check that both numerators are annual net figures on comparable bases; using gross ERV against net passing income creates a false spread. These ratios are diagnostic summaries, not substitutes for a term-and-reversion schedule. Read them alongside the dates and assumptions that connect current income to future income.

Worked example: An EMEA traditional case has a £5,600,000 property value, £280,000 annual passing net rent and £320,000 annual net ERV at reversion. Passing income-to-value ratio is £280,000 ÷ £5,600,000 = 5%. Reversionary ratio is £320,000 ÷ £5,600,000 = about 5.71%. The 0.71-percentage-point gap reflects £40,000 of assumed annual uplift, but its value depends on when that income starts and any intervening costs.

Watch the distinction: A 5.71% reversionary ratio does not mean the property currently pays that yield. Current passing net income supports 5%; future ERV has separate timing.

Reference: [5]; [6]

Official references and further reading

All study guides

Choose your exam version

ASC amer-dcf

ASC emea-dcf

ASC emea-traditional-valuation

AMER discounted cash flow: Introduction to AE; Rent Roll

1. Set the property basis

2. Reconcile occupied area

3. Place lease commencement

4. Model stepped base rent

5. Account for free rent

6. Calculate retail overage

7. Separate rollover outcomes

AMER discounted cash flow: Detailed Recovery Structures; Investment, Valuation & Reporting; Efficient Modeling, Auditing & Risk Analysis; Sensitivity & XL4ADW

8. Trace expense recoveries

9. Apply an expense stop

10. Test a recovery cap

11. Bridge NOI to cash flow

12. Discount cash flow and sale

13. Audit report totals

14. Read sensitivity outputs

AMER discounted cash flow: case-study modelling

15. Check case area inputs

16. Build mixed-use rent

17. Resolve an expiry year

18. Calculate case recoveries

19. Complete the operating bridge

20. Value case exit proceeds

21. Diagnose a rollover sensitivity

EMEA discounted cash flow: Introduction to AE; Rent Roll

22. Define the EMEA rent basis

23. Time passing rent

24. Apply indexation

25. Place a rent review

26. Separate incentive and rate

27. Model a lease break

28. Combine base and turnover rent

EMEA discounted cash flow: Recoveries, Investment and Valuation; Portfolio Reporting & Sensitivity

29. Allocate service charges

30. Find irrecoverable cost

31. Distinguish NOI and DCF cash

32. Calculate terminal proceeds

33. Discount a dated exit

34. Read portfolio measures

35. Interpret a rent sensitivity

EMEA discounted cash flow: case-study modelling

36. Reconcile the EMEA case roll

37. Combine review and concession

38. Build a void and reletting

39. Split mixed-use recoveries

40. Reconcile case cash flow

41. Complete the case DCF

42. Audit the portfolio case

EMEA traditional valuation: Introduction to AE; Rent Roll

43. Set traditional valuation units

44. Identify the remaining term

45. Derive ERV from the roll

46. Date a traditional rent review

47. Value an incentive period

48. Keep uses distinct

EMEA traditional valuation: Advanced Rent Roll, Investment and Valuation; Portfolio Reporting, Analysis & Sensitivity

49. Capitalise rack rent

50. Value term and reversion

51. Recognise over-renting

52. Distinguish bid and total cost

53. Aggregate portfolio yield

54. Test yield sensitivity

EMEA traditional valuation: case-study modelling

55. Verify traditional case ERV

56. Schedule a retail expiry

57. Calculate reversionary rent

58. Complete a term and reversion case

59. Stress the case reversion yield

60. Read passing and reversionary yields

Official references and further reading

Frequently Asked Questions

Related Study Guides

Certified Real Estate Appraiser (General/Residential)

Accredited Estate Planner (AEP)

Certified Enterprise Risk Analyst (CERA)