These original lessons use explicit illustrative assumptions within the AMER discounted cash flow track. The supplied Altus Group sources were checked on October 13, 2026; no later cutoff is assumed. Calculations demonstrate gross terminal-value curvature and comparison of populated sensitivity-matrix cells without asserting release-specific software procedures or proprietary exam content. Source s2 establishes Sensitivity & XL4ADW as a public training topic; the numerical examples are independently constructed.
What this guide covers
Worked lessons on exit-cap sensitivity and matrix interaction in AMER discounted cash flow.
AMER discounted cash flow: Introduction to AE
1. Property, suite and lease records serve different purposes
A property model combines building-level assumptions with space-level and lease-level facts. Building area and common operating expenses describe the asset; suite area describes the space; rent, concessions and recovery obligations describe the lease. Keeping these levels distinct prevents a tenant provision from being applied across the building or a common expense from being entered repeatedly for each tenant. A suite can persist through vacancy and several successive leases. Use stable identifiers to connect those records while preserving their different economic functions.
Worked example: A 40,000-square-foot building contains four 10,000-square-foot suites. One suite changes tenants in July. Retain the suite's area and identity, end the outgoing lease, and attach the incoming lease rather than creating another 10,000 square feet of building space.
Common mistake: Creating a new physical suite for every replacement tenant can inflate rentable area and distort occupancy, rent and recovery shares.
Official syllabus reference: [2]
2. Analysis dates define the cash-flow window
The analysis start establishes which projected periods enter the model, while the holding period determines the investment horizon. Individual leases, expenses and capital items have their own effective dates inside or beyond that window. A reporting year may be a calendar year or an analysis year, so its label alone does not establish its months. Map dates before interpreting annual totals. Cash flows outside the holding period may still inform forward terminal NOI, but they should not also appear as separately received operating cash flows.
Worked example: An analysis begins April 1 and runs twelve months. A $10,000 monthly expense beginning July contributes nine payments, or $90,000, to that analysis year. A calendar-year report through December would instead show six payments, or $60,000.
Common mistake: Treating every report labeled Year 1 as January through December creates incorrect commencement counts and misleading comparisons between reports.
Official syllabus reference: [2]
3. Rent units must reconcile area, frequency and currency
A rent input combines a monetary unit, an area basis and a time basis. Annual dollars per square foot must be multiplied by the applicable square footage before allocation into monthly periods. A monthly total is already an amount and should not be multiplied by area again. Currency and area conversions require explicit conversion assumptions rather than relabeling. Build a simple annual-to-monthly control for each input type before adding lease events, especially when importing schedules that mix per-area rates and total amounts.
Worked example: A lease quotes $32 per square foot annually on 7,500 square feet. Annual rent is $240,000 and monthly rent is $20,000. If an abstract instead supplies the $20,000 monthly amount, enter it using the corresponding amount basis.
Common mistake: Using the correct numeric rent with the wrong frequency can create a substantial error even when the lease dates are accurate.
Official syllabus reference: [2]
4. Compound growth depends on its effective dates
Compound growth applies each increase to the previously grown amount. With annual growth g and n completed increases, an amount becomes its starting value multiplied by (1 + g)^n. The number of increases follows the specified effective dates, not merely the number of calendar labels touched. Growth of market assumptions also differs from fixed contractual rent steps. Specify whether the first increase occurs immediately, at the next anniversary or on a calendar date, and identify which input categories the growth assumption governs.
Worked example: An operating expense is $200,000 during Year 1 and increases 3% at the start of each following year. Year 2 is $206,000 and Year 3 is $212,180. Two increases have occurred by Year 3, not three.
Common mistake: Applying growth once for every displayed year can add an unintended increase to the initial amount and overstate the entire forecast.
Official syllabus reference: [2]
5. Cash receipts and accrued revenue can differ
Cash flow records when money is received or paid under the selected convention. Accrued revenue records income attributed to a period and can differ because of billing lags, concessions or accounting allocations. A DCF must use the cash-flow definition required by its valuation assumptions rather than substituting an accounting revenue measure. When reports differ, identify whether they show contractual billing, collected cash or another revenue basis. A timing difference can affect present value even when total income over the lease is unchanged.
Worked example: A tenant owes $12,000 monthly, but a stated collection arrangement defers January's payment to March. First-quarter contractual revenue remains $36,000, while monthly cash receipts are zero, $12,000 and $24,000. Discount those receipts using their actual assumed collection periods.
Common mistake: Assuming identical annual totals make monthly cash timing irrelevant overlooks the valuation effect of delayed or accelerated receipts.
Official syllabus reference: [2]
6. Physical occupancy is an area ratio
Physical occupancy measures occupied area divided by the defined available area for a specified date or period. It does not directly measure rent collected, because occupied tenants may receive concessions, pay different rates or owe recoveries without base rent. The denominator must remain consistent with the building definition. Point-in-time occupancy and average occupancy answer different questions when tenants move during a year. Use area-based occupancy for space utilization, then calculate revenue separately from each lease's payment rules and effective dates.
Worked example: A 50,000-square-foot building has 40,000 square feet occupied, including 5,000 square feet receiving free base rent. Physical occupancy is 80%. The concession reduces current rent receipts but does not reduce occupied area to 35,000 square feet.
Common mistake: Removing free-rent space from occupied area confuses a payment concession with physical vacancy and can distort expense gross-up calculations.
Official syllabus reference: [2]
7. The operating-to-capital cash-flow bridge
An operating bridge connects revenue to NOI, then separates capital and leasing expenditures from operating performance. Under a stated convention, base rent, recoveries and other operating income less operating expenses produce NOI. Deduct tenant improvements, leasing commissions and capital expenditure afterward to obtain property cash flow before financing. Exact report labels can vary, so establish the calculation rather than relying on a heading. This structure reveals whether a weak cash-flow year reflects operations, a leasing event or a planned capital project.
Worked example: A property earns $900,000 rent and $100,000 recoveries against $350,000 operating expenses, producing $650,000 NOI. Paying $180,000 TI and $40,000 roof capital expenditure reduces property cash flow to $430,000 without changing the stated NOI.
Common mistake: Subtracting TI within NOI and again below NOI understates cash flow and obscures comparisons of operating performance across years.
Official syllabus reference: [2]
8. Explicit downtime and general vacancy can overlap
Explicit downtime removes income from identified space during a specified vacant interval. A general vacancy allowance is a broader deduction whose application depends on the scenario's definition. Applying both to the same lost income can double count vacancy. Conversely, removing all general vacancy may be inappropriate if it represents additional collection loss or structural vacancy elsewhere. Define the allowance's basis and exclusions, then reconcile potential rent to modeled rent and remaining deductions. The correct treatment follows the economic coverage of each assumption.
Worked example: A suite's six-month rollover vacancy already removes $60,000 from potential rent. A separate allowance explicitly covers only occupied-space collection loss. Apply that allowance to its stated occupied-income base rather than treating the $60,000 downtime as an additional collection deduction.
Common mistake: Using a blanket vacancy percentage without identifying losses already modeled can count the same missing rent more than once.
Official syllabus reference: [2]
9. Discount rates must match cash-flow conventions
Discounting requires consistency between rate definition, period length and cash-flow timing. An effective annual rate r converts to an effective monthly rate of (1 + r)^(1/12) − 1. A nominal annual rate compounded monthly instead uses its specified monthly periodic rate. End-of-month and beginning-of-month receipts have different exponents. Nominal cash flows containing inflation should also be paired with a compatible nominal return assumption. State these conventions explicitly; a familiar percentage alone is insufficient to reproduce a valuation.
Worked example: At a 12% effective annual rate, the monthly equivalent is approximately 0.9489%. A $100,000 receipt at month 12 has present value $100,000/1.12. Using 1% monthly would instead discount by 1.01^12 and produce a different result.
Common mistake: Dividing every annual discount rate by twelve silently changes effective annual rates into a different compounding convention.
Official syllabus reference: [2]
AMER discounted cash flow: Rent Roll
10. Occupancy, lease commencement and rent commencement
A lease can contain different dates for possession, contractual commencement and the start of base-rent payments. These dates control different model effects. Occupancy may begin before rent is payable, while recoveries or other charges may begin under separate provisions. Expiration and replacement dates then determine whether any vacancy exists between leases. Abstract each date by function and test the affected monthly lines. Do not represent a rent concession by delaying occupancy unless the facts actually provide vacant space during that period.
Worked example: A tenant takes possession May 1, its lease commences June 1, and base rent begins August 1. The supplied agreement starts recoveries June 1. June and July therefore show occupied space and recovery income but no base rent.
Common mistake: Using rent commencement as the occupancy date can understate occupied area and suppress charges that begin before base rent.
Official syllabus reference: [2]
11. Fixed contractual steps differ from growth assumptions
A fixed rent step replaces or increases contractual rent on a specified date according to the lease. Market growth projects the rent obtainable in future leasing and does not automatically alter an existing fixed schedule. Percentage contractual increases also require their own base and anniversary rule. Build the signed schedule first, then apply market assumptions only at defined market-based events. This separation preserves contractual certainty while allowing future leasing conditions to change in sensitivity or scenario analysis without rewriting protected rent periods.
Worked example: A 4,000-square-foot lease pays $25 annually per square foot through June and $27 from July. Annual rent is six months of $100,000 annualized plus six months of $108,000 annualized, totaling $104,000, regardless of current market growth.
Common mistake: Applying market-rent growth on top of a fixed contractual step can introduce an increase the lease never requires.
Official syllabus reference: [2]
12. Free rent requires a defined charge scope
Free rent is a concession affecting specified payment obligations during defined periods. It may cover base rent alone or include other charges, depending on the supplied lease terms. Occupancy and the underlying face-rent schedule can continue during the concession. Model the abated charges explicitly so later rent steps, recoveries and leasing calculations retain the correct basis. Distinguish contractual face rent from cash rent after abatement, and do not assume commissions or recovery obligations use the reduced amount unless their rules say so.
Worked example: A tenant's monthly base rent is $15,000 and recovery charge is $2,000. A two-month base-rent-only concession produces $2,000 monthly receipts during those months and $17,000 afterward. Occupancy remains continuous, and the face base-rent rate stays unchanged.
Common mistake: Treating every free-rent clause as a waiver of all tenant charges can understate recoveries and misstate the concession's economic cost.
Official syllabus reference: [2]
13. Market leasing profiles govern future lease events
A market leasing profile groups assumptions used when space becomes available or an existing lease expires. Relevant assumptions can include starting rent, term, renewal probability, downtime, concessions, tenant improvements and commissions. The profile supplies a coherent future lease package rather than merely a rent forecast. Its applicability must match the space type and event date. Existing contractual provisions remain in force until the relevant transition. Review profile assignments whenever office and retail space, tenant sizes or expected leasing conditions differ materially.
Worked example: An office lease expires in three years. Its replacement profile assumes $35 annual rent per square foot, five months of downtime and $45 TI per square foot. Those assumptions begin at the modeled rollover event rather than changing today's contractual rent.
Common mistake: Assigning one profile solely for convenience can conceal meaningful differences in replacement costs and leasing periods between space types.
Official syllabus reference: [2]
14. Renewal probability weights mutually exclusive outcomes
Renewal probability expresses the assumed likelihood that an expiring tenant renews rather than departs. For exhaustive renewal and departure outcomes, their probabilities sum to one. Expected individual amounts can be calculated as probability-weighted outcomes, but expected model value may require valuing complete scenarios because timing and conditional provisions can be nonlinear. Keep renewal-specific rent, concessions and costs distinct from new-tenant assumptions. A high renewal probability reduces expected departure exposure; it does not eliminate the need to understand the departure case.
Worked example: A 60% renewal outcome costs $20,000 TI and a 40% departure outcome costs $100,000 TI. Expected TI is $52,000. The actual future expenditure will follow the realized outcome; $52,000 is a weighted analytical amount, not a negotiated lease budget.
Common mistake: Reading a probability-weighted leasing cost as the amount payable under either actual lease outcome confuses expectation with realization.
Official syllabus reference: [2]
15. Downtime delays the replacement lease timeline
Downtime is the vacant interval between the end of one occupancy and the beginning of the next, under the scenario's date convention. It removes rent during that interval and may alter recoveries, leasing-cost dates and the market rent applicable at commencement. Free rent follows occupancy and therefore has different area and recovery consequences. Trace the entire replacement timeline instead of treating downtime as a single annual deduction. Specify whether market rent is determined at expiration, availability or commencement when that distinction affects the calculation.
Worked example: A lease ends December 31. Three months of downtime place replacement occupancy on April 1. Two months of subsequent base-rent abatement delay base-rent receipts until June, while recoveries may begin in April if the replacement terms require them.
Common mistake: Combining downtime and free rent into one vacant interval can misstate physical occupancy and charges payable after possession begins.
Official syllabus reference: [2]
16. Tenant improvements combine an area basis and payment date
Tenant improvement expenditure commonly uses an allowance per square foot multiplied by the qualifying leased area, although a scenario may instead specify a fixed amount. The expenditure's payment date is separate from its amount and from the start of rent collection. Renewal and new-tenant allowances can differ substantially. Identify eligible area, amount basis, growth assumptions and timing before calculating the cash outflow. Under a stated operating convention, TI is a leasing or capital expenditure below NOI, while still reducing property and equity cash flow.
Worked example: A replacement tenant leases 8,000 square feet with a $25-per-square-foot TI allowance paid at commencement. The model records a $200,000 outflow on that date. If rent starts two months later, the TI payment does not automatically move with rent.
Common mistake: Placing TI in the first rent-paying month without checking the payment agreement can overstate value by delaying a substantial outflow.
Official syllabus reference: [2]
17. Leasing commissions depend on a defined commission base
A leasing commission can be a fixed fee or a percentage of a defined rent stream. Percentage calculations require the commission base: covered lease years, included rent steps, treatment of concessions and whether recoveries are excluded. A payment schedule may split the resulting fee across execution, commencement or later dates. Do not infer these terms from the percentage alone. Calculate the total obligation from the supplied definition, then place each installment separately so the cash-flow and present-value effects are transparent.
Worked example: A scenario sets commission at 4% of three years of contractual base rent: $100,000, $105,000 and $110,000. The fee is $12,600. If half is paid at signing and half at commencement, model two $6,300 outflows on their respective dates.
Common mistake: Applying the commission percentage to first-year rent alone understates fees when the specified commission base includes several lease years.
Official syllabus reference: [2]
18. Percentage rent uses sales and breakpoint definitions
Percentage rent in a retail lease links additional rent to a defined sales measure. A common scenario formula charges a stated percentage of sales above a specified breakpoint, subject to a zero floor. A natural breakpoint may be calculated as annual base rent divided by the percentage rate when that convention is expressly assumed. An artificial breakpoint is independently negotiated. Determine whether percentage rent supplements or substitutes for other rent, and use the supplied sales period and exclusions rather than assuming all reported sales qualify.
Worked example: A retail scenario specifies annual base rent of $120,000 and additional rent of 6% of annual sales above a $2 million breakpoint. With qualifying sales of $2.5 million, additional percentage rent is $30,000 and combined base-plus-percentage rent is $150,000.
Common mistake: Applying the percentage rate to all sales instead of sales above the stated breakpoint overstates additional rent under an excess-sales formula.
Official syllabus reference: [2]
AMER discounted cash flow: Detailed Recovery Structures
19. Pro rata recovery shares require the contractual denominator
A tenant's pro rata share allocates a defined expense pool using an agreed numerator and denominator. Tenant area divided by total rentable building area is one possible rule; occupied area, pool-specific area or a fixed percentage may be specified instead. These choices allocate vacancy and common costs differently. Calculate the share from the applicable agreement before applying stops, caps or other provisions. A change in physical occupancy does not by itself authorize a denominator change, and different expense pools may legitimately use different shares.
Worked example: A 15,000-square-foot tenant in a 100,000-square-foot building pays 15% of a $400,000 tax pool, or $60,000. Even if only 75,000 square feet are occupied, the recovery remains $60,000 when the lease denominator is total rentable area.
Common mistake: Automatically replacing total area with occupied area transfers vacancy costs to tenants even when the stated recovery formula does not permit it.
Official syllabus reference: [2]
20. Gross and net leases describe expense responsibility
Gross and net terminology summarizes how rent and expense responsibility are structured, but the actual recovery provisions determine the model. A gross arrangement may leave specified operating costs with the landlord, while a net arrangement may reimburse defined costs separately from base rent. Neither label establishes every exclusion, allocation rule or payment date. Model landlord expenses and tenant recovery income as separate streams so unrecovered amounts remain visible. Compare leases using both base rent and expense responsibility rather than assuming identical face rents imply identical economics.
Worked example: Two tenants each pay $200,000 annual base rent. One has no recovery obligation; the other reimburses $40,000 of defined expenses. If each is associated with $50,000 of landlord expense, their simplified net operating contributions are $150,000 and $190,000.
Common mistake: Treating a lease label as a complete recovery formula can omit exceptions that materially change the landlord's retained expense burden.
Official syllabus reference: [2]
21. Expense stops protect a defined landlord contribution
An expense stop generally leaves a specified amount of eligible expense with the landlord and charges the tenant for an excess under the stated formula. The stop may be expressed at building level, per square foot or as a tenant-level amount. Those bases must be aligned before subtraction. A common exercise formula is tenant share multiplied by the positive excess of building expense over a building-level stop. Establish whether a zero floor applies and whether caps or exclusions modify expense before the stop is tested.
Worked example: Eligible building expense is $360,000 and the building-level stop is $300,000. A tenant with a 10% share owes $6,000 under a positive-excess formula. Subtracting the full $300,000 from the tenant's $36,000 share would mix incompatible calculation levels.
Common mistake: Subtracting a building-level stop from a tenant-level expense amount produces an invalid comparison even when both values are expressed in dollars.
Official syllabus reference: [2]
22. Base-year recoveries use a defined comparison expense
A base-year recovery compares a later eligible expense amount with an agreed reference year's eligible amount. The tenant may reimburse its allocated positive increase, depending on the lease. The reference amount can require adjustments for occupancy, expense eligibility or unusual items, so it is not necessarily the unadjusted accounting total from that year. Keep the base-year definition consistent with the comparison pool and any gross-up rules. A fixed dollar stop and a base-year provision can resemble each other numerically while arising from different underlying definitions.
Worked example: A lease uses adjusted base-year eligible expenses of $500,000. Current comparable expenses are $560,000 and the tenant share is 8%. With a zero floor and no other adjustments, recovery is 8% of $60,000, or $4,800 for the year.
Common mistake: Comparing gross current expenses with a base year that excluded certain categories creates an apparent increase unrelated to genuine comparable expense growth.
Official syllabus reference: [2]
23. Gross-up normalizes eligible variable expenses
Expense gross-up adjusts specified occupancy-sensitive costs to a defined occupancy level for recovery calculations. Under a simple linear scenario, variable expense is multiplied by target occupancy divided by actual occupancy. Fixed costs remain unchanged unless the supplied terms state otherwise. This is a recovery-basis adjustment, not necessarily an additional cash expense paid by the landlord. Some real costs do not vary linearly, so use the method specified in the exercise or agreement. Confirm eligibility, actual occupancy, target occupancy and adjustment order before allocating the pool.
Worked example: At 75% occupancy, variable cleaning expense is $150,000 and fixed security expense is $80,000. A stated linear gross-up to 90% produces $180,000 cleaning plus unchanged security, creating a $260,000 recovery pool before tenant allocation.
Common mistake: Grossing up every expense and also increasing landlord cash expenses confuses recovery normalization with actual spending and can distort both sides of NOI.
Official syllabus reference: [2]
24. Expense pools and exclusions determine recoverability
A recovery pool groups expenses subject to the same tenant reimbursement rules. Taxes, insurance and common-area maintenance may require different allocations, exclusions or limitations. An expense can be a valid landlord operating cost yet remain unrecoverable under a particular lease. Build the eligible pool before applying tenant shares and avoid adding one expense to multiple pools unless explicitly required. Pool-level reconciliation should connect total landlord spending to eligible spending, then to tenant charges, making the landlord's unrecovered residual identifiable.
Worked example: A maintenance pool contains $120,000 cleaning, $30,000 landscaping and $20,000 leasing-office cost. The lease excludes leasing-office cost. Eligible expense is $150,000, so a 12% tenant share produces $18,000 recovery rather than $20,400.
Common mistake: Assuming every operating expense is recoverable ignores contractual exclusions and can overstate NOI even when the expense forecast itself is accurate.
Official syllabus reference: [2]
25. Cumulative and annual recovery caps follow different paths
A recovery cap limits a defined expense amount or increase, but its path depends on the supplied terms. A cumulative ceiling measured from a base can grow even when actual expense stays below it, preserving unused capacity. A cap tied to the prior actual or allowed amount may follow a lower path. Identify the covered expense categories, starting base, compounding rule and treatment of unused capacity. Then apply the cap to the correct component before combining uncapped items or calculating tenant-level charges.
Worked example: A cumulative 5% ceiling on a $100,000 base reaches $110,250 after two years. If first-year actual expense is $102,000, a different rule based on prior actual expense would yield a second-year ceiling of $107,100. The distinction changes recoverable expense.
Common mistake: Assuming all 5% caps produce the same result ignores the reference amount and whether unused annual capacity carries forward.
Official syllabus reference: [2]
26. Administration fees need a specified base and order
A recovery administration fee adds a stated percentage or amount to a defined charge base. Its base may be eligible maintenance expense, a tenant's allocated recovery or another specifically identified amount. Taxes and insurance may be included or excluded. Calculation order matters when a stop or cap also applies: a fee inside a capped pool can differ from a fee added after the cap. Express the full calculation in sequence before implementation rather than treating the fee percentage as a universal markup on every expense.
Worked example: A tenant owes $20,000 of maintenance recovery and $8,000 of tax recovery. The scenario permits a 10% administration fee on maintenance recovery only, added afterward. The fee is $2,000 and the total charge is $30,000, not $30,800.
Common mistake: Applying an administration percentage to every recovery category can overcharge categories explicitly excluded from the fee base.
Official syllabus reference: [2]
27. Estimated recoveries and true-ups have separate cash dates
Tenants may pay estimated recovery installments during a year and settle the difference after actual eligible expenses are known. The final liability and the cash collected within the expense year are then different measures. Model estimates, settlement amounts and receipt dates according to the scenario's cash-flow convention. Avoid recording both the full final charge and all estimated installments as separate income. A true-up can cross the valuation or sale boundary, so its ownership and collection assumptions must be explicit when they affect investment cash flow.
Worked example: A tenant pays twelve estimated installments of $1,000, then owes a final annual recovery of $13,500. A $1,500 settlement collected the following March is additional cash in that later period. The original expense year's collections remain $12,000.
Common mistake: Adding the entire final recovery to estimated receipts double counts amounts already collected and misstates the settlement-period cash flow.
Official syllabus reference: [2]
AMER discounted cash flow: Investment, Valuation & Reporting
28. DCF values dated property cash flows
Discounted cash flow values an investment by bringing each projected cash flow to a common valuation date. With annual end-period cash flows and an effective annual rate r, present value is the sum of CF_t divided by (1 + r)^t. Include operating cash after required property expenditure and net sale proceeds under the selected unlevered convention. Timing, sign and rate consistency matter as much as annual totals. A valuation is therefore a reproducible dated calculation, not simply an income multiple applied to one representative year.
Worked example: A property produces $100,000 at the end of Year 1 and $1,100,000 including sale at the end of Year 2. At 10%, present value is $90,909.09 plus $909,090.91, totaling $1 million under the stated annual convention.
Common mistake: Discounting the sum of all future receipts by one common exponent ignores their different dates and changes the investment's value.
Official syllabus reference: [2]
29. Terminal NOI must match the stated sale convention
A terminal capitalization calculation converts a defined income measure into gross sale price using an exit capitalization rate. In a forward-NOI scenario, sale at the end of Year N capitalizes Year N+1 NOI. Trailing or stabilized conventions use different income bases and must be stated separately. Do not substitute final holding-year cash flow for terminal NOI, especially when that cash flow includes TI or temporary concessions. The terminal assumption should identify both the income period and any explicit normalization used to represent the buyer's income expectation.
Worked example: Sale occurs at the end of Year 4. The stated convention uses Year 5 NOI of $700,000 and a 7% exit cap, giving $10 million gross price. Year 4 NOI of $650,000 remains part of operating cash flow, not the capitalization numerator.
Common mistake: Automatically capitalizing the final displayed operating year can use the wrong income period and materially misstate the reversion.
Official syllabus reference: [2]
30. Capitalization and discount rates perform different jobs
A capitalization rate converts a specified annual income measure into a point-in-time price through division. A discount rate converts dated future cash flows into present value through compounding. They are related investment assumptions but are not interchangeable. An exit cap acts on terminal income before net sale proceeds are discounted back to the valuation date. A discount-rate sensitivity can therefore change value without changing the assumed sale price, while an exit-cap sensitivity changes the reversion itself when terminal NOI is held fixed.
Worked example: Forward NOI of $600,000 capitalized at 6% gives a $10 million gross sale price. If sale is three years away, a 9% discount rate brings that price to approximately $7.72 million before considering selling costs or interim cash flows.
Common mistake: Using the discount rate as the exit capitalization rate changes the pricing assumption rather than simply discounting the same sale proceeds.
Official syllabus reference: [2]
31. Disposition costs reduce proceeds before discounting
Disposition costs convert gross sale price into net proceeds available at the sale date. A scenario may specify a percentage of gross price, fixed costs or both. Apply each cost to its stated base once, then combine net proceeds with any separate final-period operating cash flow. Financing payoff belongs in an equity-proceeds bridge rather than an unlevered sale calculation. Keeping these layers separate prevents sale costs from being deducted twice or loan repayment from contaminating property value before financing.
Worked example: A property sells for $5 million with costs of 2% of gross price plus a $25,000 fixed fee. Net unlevered proceeds are $4,875,000. If $2 million debt is repaid, net equity proceeds are $2,875,000 before any other specified items.
Common mistake: Deducting a sale-cost percentage from gross price and again from net proceeds applies the same transaction cost twice.
Official syllabus reference: [2]
32. Unlevered and levered analyses require different cash-flow sets
Unlevered analysis evaluates property cash flows before debt financing. Levered analysis evaluates cash flows to equity after loan advances, interest, principal and payoff under the stated financing terms. The corresponding return requirement must match the cash-flow set. Debt principal is not an operating expense, but it reduces equity cash when paid. Separate property performance from financing so a loan change does not appear to alter NOI. At acquisition, equity investment also reflects loan funding and transaction costs rather than simply equaling the property's price.
Worked example: A $4 million purchase funded with a $2.5 million loan requires $1.5 million equity before costs. If annual property cash flow is $300,000 and debt service is $180,000, equity receives $120,000. Property cash flow remains $300,000 regardless of that financing split.
Common mistake: Discounting after-debt equity cash flow at a rate intended for unlevered property cash flow mixes incompatible valuation inputs.
Official syllabus reference: [2]
33. NPV and IRR answer different investment questions
Net present value subtracts investment cost from the present value of future cash flows at a specified required return. Internal rate of return is a rate that makes the dated cash-flow stream's NPV equal zero. NPV measures value added at the chosen hurdle; IRR summarizes a break-even return under its timing convention. Cash flows with multiple sign changes can produce multiple or unhelpful IRR solutions. Compare investments using consistent dates and cash-flow definitions, and do not assume a higher IRR necessarily creates more dollar value.
Worked example: An investment costs $1 million today and returns $1.2 million one year later. Its IRR is 20%. At a 10% required return, NPV is $1.2 million/1.10 minus $1 million, or approximately $90,909 of value above the hurdle.
Common mistake: Treating IRR as a dollar profit measure obscures investment scale and can misrank projects when their capital requirements differ substantially.
Official syllabus reference: [2]
34. Acquisition costs connect property value to feasible price
A DCF of future property receipts can establish the present value available to cover acquisition outlays. If a buyer must also pay transaction costs, the feasible purchase price can be below that present value. Percentage costs calculated on price require solving price multiplied by one plus the cost rate, rather than subtracting that percentage from value indiscriminately. Fixed costs are deducted separately. State whether the reported result is property value, price excluding buyer costs or total investment, because those amounts answer different acquisition questions.
Worked example: Future receipts have present value $10.2 million. Buyer costs are assumed to equal 2% of purchase price with no fixed fee. The break-even price is $10.2 million/1.02, or $10 million; total initial expenditure then equals $10.2 million.
Common mistake: Subtracting 2% of value when costs are defined as 2% of purchase price uses the wrong percentage base.
Official syllabus reference: [2]
35. Report reconciliation starts with definitions and periods
Reports can show different totals because their periods, filters, aggregation levels or calculation definitions differ. A rent-roll view may annualize current rent, while a cash-flow report sums actual projected receipts over selected months. A valuation report may include capital items or sale proceeds absent from an operating statement. Reconcile differences by matching property, scenario, dates, units and line definitions, then bridge the components. A matching label such as income does not prove two reports measure the same economic quantity.
Worked example: A December rent roll annualizes a tenant's $10,000 monthly rent as $120,000. The tenant commenced October 1, so the calendar-year cash-flow report shows only $30,000. Both are correct because one is a run rate and the other is a period total.
Common mistake: Forcing an annualized rent-roll total to equal calendar-year cash receipts can erase legitimate commencement and concession effects.
Official syllabus reference: [2]
36. Portfolio amounts add, but return rates usually do not
Property cash flows and present values can be aggregated when currency, valuation date and treatment are consistent. Portfolio return measures should generally be calculated from combined dated cash flows rather than taking a simple average of property IRRs. Investment size and timing affect the portfolio result. Even a weighted average of individual IRRs need not reproduce the IRR of the aggregate stream. Check that property-level values use compatible bases before summing, and distinguish a presentation statistic from a return calculated on the actual combined investment.
Worked example: One investment costs $1 million and returns $1.1 million after a year; another costs $9 million and returns $10.8 million then. Combined IRR is 19%, from $11.9 million/$10 million minus one, rather than the 15% simple average.
Common mistake: Averaging individual property IRRs without combining their cash flows can misrepresent the return earned on the portfolio's actual invested capital.
Official syllabus reference: [2]
AMER discounted cash flow: Efficient Modeling, Auditing & Risk Analysis
37. Shared assumptions need controlled scope and overrides
Shared assumptions improve consistency when several properties or leases genuinely use the same economic rule. Their efficiency creates dependency risk: one change can affect many forecasts, while local overrides may prevent intended updates. Identify the assignment scope and any exceptions before bulk editing. Test one expected changed output and one expected unchanged output afterward. A useful control distinguishes inherited assumptions from deliberately overridden values, allowing an analyst to explain why similar leases respond differently without assuming the shared update failed.
Worked example: Three office profiles inherit 3% market-rent growth, but a fourth intentionally uses a fixed local assumption. Changing the shared growth to 4% should affect the three linked profiles. Review the fourth's documented override rather than changing it merely to make results uniform.
Common mistake: Assuming a shared update reaches every record ignores local overrides and can leave a portfolio with unintended mixed assumptions.
Official syllabus reference: [2]
38. Import mapping must preserve data meaning
An import translates source fields into model fields, so correctness depends on meaning rather than column position alone. Map identifiers, dates, area units, rent frequency, amount basis and sign conventions explicitly. Missing values require defined treatment because blank, zero and unchanged can mean different things. Reconcile record counts and control totals after import, then inspect a representative lease with a known calculation. A technically successful import can still be economically wrong if annual rates become monthly amounts or source dates are interpreted using the wrong format.
Worked example: A source column contains $24 annual rent per square foot, not monthly total rent. For a 5,000-square-foot suite, the control is $120,000 annually and $10,000 monthly. Use that known lease to verify the mapped basis before importing the remaining records.
Common mistake: Accepting a successful import message as proof of correct economics overlooks unit, frequency and field-definition errors that pass basic file validation.
Official syllabus reference: [2]
39. Stable identifiers prevent duplicate economic records
Record identity determines whether an update modifies an existing property, suite or lease or creates another one. Names alone may be ambiguous, change over time or repeat across properties. Use stable identifiers and a documented update key, then inspect duplicates and unmatched records. A duplicate lease can inflate income without changing physical building area, creating implausible revenue density or overlapping occupancy. Reconcile both counts and economic totals because one correct total does not establish that the underlying record structure is sound.
Worked example: An updated file calls Tenant 014 'North Trading Ltd' instead of 'North Trading.' Matching by stable tenant and lease identifiers updates its rent. Matching only by name may create a second lease and leave the original income active for the same suite.
Common mistake: Relying on tenant names as unique update keys can duplicate leases when spelling or legal names change between source files.
Official syllabus reference: [2]
40. Event-month tests locate timing errors
An event-month audit examines output immediately before, during and after a known transition. Lease commencement, expiration, rent steps, free-rent expiry and TI payment dates provide predictable breakpoints. Calculate expected monthly changes independently, then compare the corresponding report lines. Annual totals can conceal offsetting date errors, while event-focused checks identify the responsible assumption quickly. Include unaffected lines as controls so a base-rent concession does not accidentally alter recoveries or occupancy. This method tests the model's timing logic rather than merely its arithmetic totals.
Worked example: Free base rent ends August 31 and monthly face rent is $12,000. August should show zero base rent and September $12,000. If recoveries remain $1,500 in both months, their continuity confirms the concession was limited to the intended charge.
Common mistake: Checking only the annual rent total can miss a concession shifted one month when another timing error happens to offset it.
Official syllabus reference: [2]
41. Expense-to-recovery bridges explain retained landlord costs
A recovery audit connects actual landlord expenses to tenant reimbursement through eligibility, adjustment and allocation steps. Start with spending, remove exclusions, apply permitted gross-up or caps, calculate shares and stops, and compare resulting charges with collections under the relevant timing convention. The difference between expense and recovery is not automatically an error: vacancy, exclusions and landlord contributions can explain it. A bridge makes those causes measurable and helps detect duplicated pools, missing tenants or recovery assumptions that fail to follow contractual rules.
Worked example: Landlord maintenance expense is $300,000. Of that, $30,000 is excluded and tenants collectively recover 80% of the remaining eligible pool. Recovery is $216,000, leaving $84,000 with the landlord: $30,000 excluded plus $54,000 of unallocated eligible expense.
Common mistake: Expecting recoveries to equal all expenses can hide valid landlord obligations or encourage incorrect changes that overstate reimbursement.
Official syllabus reference: [2]
42. Scenario versions isolate the cause of value changes
A scenario version preserves a defined set of assumptions and outputs so changes can be compared reproducibly. Record the baseline, valuation date, changed inputs and output basis. For a controlled test, alter one assumption or an explicitly defined bundle while retaining other inputs. Differences then have an interpretable cause. If corrections and economic changes are mixed, separate their effects in a bridge rather than attributing the entire movement to the market. Version discipline supports model audit without requiring any particular proprietary interface.
Worked example: A baseline value is $12 million. Correcting a lease area raises value to $12.2 million; increasing the exit cap then reduces it to $11.6 million. Report a $0.2 million data correction and a $0.6 million valuation-assumption effect, rather than one unexplained decline.
Common mistake: Comparing scenarios with undocumented simultaneous edits can attribute a data correction to a market assumption and produce a misleading explanation.
Official syllabus reference: [2]
43. Lease-expiration concentration measures rollover exposure
Rollover concentration measures how much area or income reaches expiration within selected periods. Area exposure and income exposure can differ when rent levels vary. Concentrated expirations can combine vacancy, concessions and leasing expenditure in the same year, creating liquidity risk beyond the lost base rent alone. Build an expiration schedule and examine plausible renewal and departure outcomes for major tenants. Do not infer risk solely from average remaining lease term, because an average can hide a large near-term expiration alongside several long leases.
Worked example: A building has 20% of its area expiring next year, but that space supplies 35% of base rent. A rent-weighted exposure schedule highlights the disproportionate income risk, and a departure scenario adds the associated downtime, TI and commission requirements.
Common mistake: Using only the percentage of area expiring can understate exposure when the expiring tenants pay above-average rent.
Official syllabus reference: [2]
44. Nonlinear lease mechanics limit averaged-input models
The value produced from average inputs need not equal the average of values produced by distinct scenarios. Lease dates, conditional costs, recovery floors and terminal conventions can create nonlinear relationships. When probabilities describe mutually exclusive outcomes, calculate each complete outcome consistently and weight the resulting values to obtain the expected value under those assumptions. Averaged inputs can still provide a convenient approximation, but test their difference from the scenario-weighted benchmark. This distinction is especially useful when renewal and departure have materially different timelines.
Worked example: A renewal case worth $8 million has 75% probability, and a departure case worth $4 million has 25% probability. Expected value is $7 million. A model built from averaged downtime and TI that returns $7.3 million is an approximation with a $300,000 difference.
Common mistake: Assuming probability-weighted inputs automatically reproduce probability-weighted value overlooks conditional and timing effects inside the model.
Official syllabus reference: [2]
AMER discounted cash flow: Sensitivity & XL4ADW
45. Equal exit-cap steps produce unequal value changes
An exit-cap sensitivity can reveal curvature in terminal pricing. With terminal NOI fixed, gross terminal value equals NOI divided by the exit capitalization rate. Because the rate is the denominator, equal percentage-point increases produce progressively smaller dollar declines as the rate rises. Evaluate each input explicitly rather than extending one observed dollar change across the sweep. Label these outputs as gross terminal values when selling costs and discounting are excluded. A complete property DCF sensitivity would also incorporate operating cash flows, disposition costs and the timing of sale proceeds.
Worked example: Assume terminal NOI is $630,000, with no selling costs or discounting. Exit caps of 5%, 6% and 7% produce gross terminal values of $12.6 million, $10.5 million and $9.0 million. The successive one-percentage-point increases reduce value by $2.1 million and $1.5 million, respectively.
Common mistake: Applying the first interval's dollar decline to every later interval assumes a linear relationship; capitalization produces a reciprocal relationship when NOI stays fixed.
Official syllabus reference: [2]
46. Four matrix cells reveal sensitivity interaction
A two-variable sensitivity matrix shows whether the effect of one assumption depends on the other assumption's setting. For an Excel analysis using XL4ADW outputs, compare four populated cells: the base, each separate change and the combined change. Add the two separate value changes, then compare that sum with the actual combined change. Their difference measures interaction over those selected intervals. Discount rate and exit cap can interact because terminal proceeds are both capitalized and discounted. Keep other assumptions fixed and retain sufficient precision before interpreting small differences as meaningful economic effects.
Worked example: An illustrative matrix has discount-rate rows 8%/9% and exit-cap columns 6%/7%. Values ($m) are [12.0, 10.8] and [11.4, 10.3]. From the 8%/6% base, the 9%/7% result falls $1.7m. Separate changes total −$1.8m; the combined decline is $0.1m smaller.
Common mistake: Adding separate sensitivity losses assumes no interaction. The combined matrix cell must be checked because one assumption can change the other's dollar effect.
Official syllabus reference: [2]
47. Basis points describe absolute rate changes
One basis point is 0.01 percentage points, so 100 basis points equal one percentage point. A rate moving from 6% to 6.5% increases by 50 basis points but by approximately 8.33% relative to its starting level. These are different descriptions. Capitalized value changes through division by the revised rate and is not reduced by the same relative percentage. State whether a sensitivity increment is an absolute rate movement or a proportional change, then recalculate the valuation using the resulting rate.
Worked example: At $600,000 NOI, a 6% cap produces $10 million gross value. Increasing the cap by 50 basis points to 6.5% produces approximately $9.231 million. The $769,231 decline is about 7.69% of initial value, not 0.5%.
Common mistake: Treating a 50-basis-point cap increase as a 0.5% reduction in property value confuses rate units with valuation response.
Official syllabus reference: [2]
48. Coherent scenarios combine related assumptions
A scenario changes a defined package of assumptions to represent a possible economic condition. Unlike a one-variable sensitivity, it may combine weaker market rent, longer downtime, higher concessions and a different exit cap. The package should remain internally coherent and clearly separated from the baseline. Avoid changing signed contractual rent merely because market conditions weaken unless a separate specified mechanism affects collection or the contract. Scenario analysis describes outcomes under assumptions; probabilities and expected values require an additional explicit likelihood framework.
Worked example: A downside leasing case reduces future starting rents by 5%, adds three months of replacement downtime and raises the exit cap by 25 basis points. Existing fixed lease rents remain intact until expiration, so the scenario targets the stated future leasing exposure.
Common mistake: Calling an arbitrary collection of adverse edits a downside case can obscure inconsistent assumptions and make the result difficult to interpret.
Official syllabus reference: [2]
49. Spreadsheet retrieval depends on model identity
An XL4ADW-linked spreadsheet result is meaningful only when its retrieval parameters identify the intended data. Relevant dimensions include property, portfolio, scenario, valuation or reporting period, and requested measure. A copied formula can remain valid while pointing to the wrong model. Separate parameter cells from retrieved output and review their references before interpreting differences. Use the supported functions and connection behavior of the installed environment without assuming undocumented syntax. The key analytical control is that the workbook and comparison report describe the same economic object.
Worked example: A workbook copied from Property A still references A's identifier in a hidden parameter cell, although its visible heading says Property B. Reviewing the identifier resolves the mismatch before anyone changes B's lease assumptions to match the displayed NOI.
Common mistake: Assuming a worksheet title determines the retrieved property can leave a plausible-looking report connected to a different model.
Official syllabus reference: [2]
50. Period alignment and aggregation precede spreadsheet comparison
Spreadsheet reporting must distinguish monthly amounts, annual totals, annualized run rates and balances at a date. Sum period flows only across matching dates; do not sum point-in-time values such as property valuations as though they were receipts. Currency scaling also matters when a report shows thousands and a workbook stores full dollars. Establish a period map and unit label for each retrieved measure. A discrepancy that appears financial may instead arise from comparing an analysis-year flow with a calendar-year total or an annualized amount.
Worked example: A report presents NOI of 950 in thousands of dollars, while the workbook retrieves $950,000. These agree after scaling. If the report covers January–December but the workbook covers April–March, matching units alone still does not establish a valid comparison.
Common mistake: Reconciling numbers before checking dates and scaling can lead to unnecessary model edits that compensate for a reporting-definition difference.
Official syllabus reference: [2]
51. Refresh and recalculation are separate dependencies
A linked workbook can contain previously retrieved model data and spreadsheet formulas calculated from those results. Updating the model, refreshing external results and recalculating dependent workbook formulas are related but distinct steps. Confirm the intended source version, complete the supported retrieval refresh, and ensure dependent formulas calculate before relying on the output. Check a known changed measure to establish that the new information reached the report. Do not infer freshness merely because the workbook opened successfully or the displayed formulas remain syntactically valid.
Worked example: An AE expense change lowers annual NOI by $20,000. After refreshing the workbook's source results, confirm the NOI cell changes and then verify a dependent debt-coverage calculation updates. A static copied value elsewhere may remain stale even when the linked cell is current.
Common mistake: Assuming ordinary spreadsheet recalculation necessarily retrieves updated external model data can leave a report presenting a prior scenario's results.
Official syllabus reference: [2]
52. Independent spreadsheet controls test retrieved results
A spreadsheet control should calculate an expected relationship independently rather than merely repeat the same retrieval in another cell. Useful controls include annual rent from area and rate, NOI from component lines, and present value from dated receipts. Compare the independently calculated amount with retrieved output using a stated rounding tolerance appropriate to the report. If a control fails, inspect definitions and timing before overriding results. Independence matters because two cells using the same incorrect source reference can agree while both remain wrong.
Worked example: Retrieve base rent, recoveries, other income and expenses separately. Calculate NOI as their arithmetic bridge and compare it with retrieved NOI for the same dates. A second copy of the NOI retrieval would test formula consistency but not the component relationship.
Common mistake: Duplicating a retrieval formula and calling the duplicate an independent check provides little protection against an incorrect shared reference.
Official syllabus reference: [2]
AMER discounted cash flow: case-study modelling
53. Lease abstraction translates prose into testable inputs
A case-study lease abstract converts narrative facts into a structured set of economic inputs. Capture area, dates, rent basis, steps, concessions, recovery rules, expiration treatment and leasing costs, retaining the source meaning of each. Separate supplied facts from explicit modeling assumptions when a convention must be chosen. Build a small independent expected-output calculation for important provisions so the abstract can be tested after entry. This procedure reduces errors caused by remembering only headline rent while overlooking a payment start, expense exception or one-time expenditure.
Worked example: A case states that a 6,000-square-foot tenant starts July 1 at $28 annual rent per square foot with two free base-rent months. Abstract occupancy as July, payment start as September, and expected first-calendar-year base rent as four months totaling $56,000.
Common mistake: Entering a case directly from memory can merge distinct lease dates and omit provisions that materially affect the requested outputs.
54. An event timeline resolves boundary-date conflicts
A case timeline places expiration, vacancy, commencement, concessions, expenditure and sale on a common date axis. This reveals whether events overlap, leave a gap or fall exactly on the same discount date. Establish inclusive month conventions from the supplied facts instead of assuming a universal software treatment. A cost at the start of Year 2 can coincide with the end of Year 1 in an annual valuation timeline. Resolving these boundaries before calculation prevents otherwise correct amounts from being assigned to the wrong investment period.
Worked example: An outgoing lease ends December 31, the replacement starts January 1, and TI is paid that day. There is no downtime between the leases. For a valuation starting one year earlier, January 1 TI occurs at time 1, alongside end-of-Year-1 aggregated receipts.
Common mistake: Assigning all Year 2-related expenditures to the end of Year 2 delays costs that the case places at its beginning.
55. Monthly schedules produce annual totals without losing events
A monthly case schedule calculates each charge for the months when its conditions apply, then sums those flows into the requested reporting year. This preserves partial-year commencement, fixed steps and concessions without replacing them with an unsupported average rate. Annualization is appropriate for a run-rate question but differs from actual annual receipts. Keep monthly area and charge controls beside the cash schedule, and sum only the months belonging to the requested year. Use the case's separate valuation aggregation convention when discounting the resulting flows.
Worked example: A 3,000-square-foot tenant pays $24 annually per square foot from January through September and $28 from October. Monthly receipts are $6,000 for nine months and $7,000 for three months, giving $75,000 for the calendar year rather than a $84,000 year-end run rate.
Common mistake: Multiplying December rent by twelve answers a run-rate question and can overstate actual receipts in a year containing rent steps.
56. Rollover cash requirements exceed the rent-loss measure
A rollover year can combine lost rent, free rent, tenant improvements and commissions, making its cash requirement larger than the operating-income decline. Separate recurring operations from one-time leasing expenditure and place every amount on its stated payment date. A positive NOI does not guarantee positive property cash flow, especially when TI is paid before replacement rent begins. Build a rollover bridge showing the baseline income, lost receipts and leasing outflows so the case result explains both valuation and near-term funding exposure.
Worked example: A building's rollover-month NOI is $18,000, but it pays $90,000 TI and $12,000 commission in that month. Property cash flow is negative $84,000. Explaining only the month's rent concession would miss most of the actual cash requirement.
Common mistake: Using NOI as the available cash balance during rollover overlooks leasing expenditures that can create a substantial funding deficit.
57. Case recoveries must follow each tenant's lease terms
A multi-tenant case may assign different recovery formulas to tenants sharing the same building expenses. Calculate each obligation separately using its own share, stop, exclusions, concession treatment and active dates, then aggregate recovery income. Do not replace these formulas with an average building recovery rate unless the exercise explicitly instructs that approximation. The building expense remains one underlying outflow, while tenant charges represent separate receipts. This distinction is especially important when a replacement tenant begins recovery payments during free base rent or adopts different recovery terms.
Worked example: Tenant A pays a fixed $12,000 annual recovery throughout the year. Tenant B starts July and pays a $6,000 annualized recovery immediately, despite two free base-rent months. Combined calendar-year recovery is $15,000, reflecting A's twelve months and B's six.
Common mistake: Applying one tenant's base-rent concession to every recovery line can suppress charges that another lease or a separate obligation still requires.
58. The holding-period boundary separates operations from reversion
A case valuation includes operating cash flows received during the holding period and the investment's net sale proceeds at its end. Forward NOI used to price the sale is a valuation input, not an additional operating receipt retained by the seller after disposal. Include final holding-year operating cash flow separately when the case provides it, then add net proceeds on the sale date. This boundary avoids both omitting the final operating year and double counting the forward income already represented in the terminal price.
Worked example: A property is sold at the end of Year 3. The seller receives Year 3 property cash flow plus net sale proceeds priced from Year 4 NOI. Year 4 NOI is not also added as a separate seller receipt after the sale.
Common mistake: Adding forward terminal NOI to sale proceeds as an extra operating receipt counts income that belongs to the buyer's post-sale period.
59. A valuation bridge independently verifies the model result
A case valuation bridge lists each dated net receipt, its discount factor and its present-value contribution. Calculate sale price, disposition costs and any debt payoff in separate supporting steps appropriate to the requested valuation basis. The sum of the discounted contributions should match the reported model value within explained rounding. This bridge distinguishes an operating forecast error from a terminal-pricing or discount-timing error. It also makes sensitivity results interpretable because the analyst can identify which present-value component changed when a single assumption moved.
Worked example: A case has $200,000 at time 1 and $5 million at time 2, including sale. At 10%, the bridge shows $181,818.18 and $4,132,231.40, totaling $4,314,049.58. A different reported value can then be traced to its cash amounts or discount exponents.
Common mistake: Checking only that a valuation seems plausible cannot identify whether an error comes from cash-flow amounts, terminal assumptions or timing.
60. A model handoff needs reproducible output definitions
A useful case deliverable identifies the model version, valuation date, currency, area units, reporting periods and calculation conventions alongside the requested results. Each answer should be traceable to a defined output and its supporting schedule. Distinguish NOI, property cash flow, equity cash flow, gross sale price and net proceeds rather than presenting unlabeled amounts. Include material scenario assumptions and explain rounding differences. This is a technical reproducibility requirement: another analyst should be able to rebuild the calculation from the supplied facts and understand exactly what each reported number represents.
Worked example: Report '$7,014,049.59 unlevered present value at time zero, 10% effective annual discounting, end-year operating aggregation.' Attach the dated cash-flow bridge and state that leasing costs at the start of Year 2 occur at time 1, making the result independently reproducible.
Common mistake: Providing a precise value without its date, cash-flow basis or discount convention leaves the result ambiguous despite its apparent numerical accuracy.
Official syllabus sources
- ARGUS Enterprise: (ASC) Certification Exam – Altus Group Webstore
- ARGUS Enterprise: eLearning Beginner Package – Altus Group Webstore