Real/Nominal Adjustment Worksheet¶
Template — instantiates Temporal Discounting and Present-Value Framework Selection
Checks consistency among inflation, price levels, nominal flows, real flows, and discount rates.
A Real/Nominal Adjustment Worksheet is a fill-in template whose only job is to guarantee that every quantity in an appraisal lives on the same value basis before anyone discounts it. Its defining move is consistency-checking, not discounting: it verifies that real flows are paired with a real rate and nominal flows with a nominal rate, that inflation and price-base assumptions are stated once and applied everywhere, and that no line silently mixes bases. It computes no present value and issues no verdict — it is the gate every flow passes through so that the sum a discounting model later produces is meaningful rather than a mix of dollars that mean different things in different years. Get this wrong and a model can be flawless in its arithmetic yet wrong by a wide margin.
Example¶
A mining company is appraising a five-year processing contract in a country running ~15% annual inflation. The draft model looks rigorous, but a Real/Nominal Adjustment Worksheet catches that it is quietly incoherent. The worksheet lays out each input in a row and asks, for each, one question: real or nominal, and in which base year? The equipment quote is in nominal future currency (the supplier escalates prices with inflation). The labour saving was estimated in today's prices — real. And the discount rate pencilled in is the company's nominal borrowing cost. The draft is about to discount a real labour saving with a nominal rate: a classic basis mismatch that, at 15% inflation, understates the saving enormously.
The worksheet forces the fix onto one consistent basis. Either restate every flow in real terms and use a real rate — stripping the 15% inflation out of the nominal equipment quote — or inflate the real labour saving into nominal terms and keep the nominal rate. The template does not care which basis is chosen; it only certifies that one is chosen and applied to every row and to the rate. Once the worksheet is green, the numbers are safe to hand to a discounting model.
How it works¶
- One row per input, one basis question. Every cost, benefit, price, and rate is tagged real or nominal with its base year — nothing enters the appraisal untagged.
- Pair rates to flows. The worksheet enforces the matching rule: real flows with a real rate, nominal flows with a nominal rate, using the Fisher relation to convert between them when needed.[n1]
- State inflation and price base once. A single declared inflation and price-base assumption is applied uniformly, so two rows cannot silently assume different price levels.
- Certify before discounting. The template's output is a pass: a confirmation that the basis is internally consistent, which the discounting tools then rely on.
Tuning parameters¶
- Basis choice — whether the whole appraisal is done in real or nominal terms. Real is cleaner for long horizons and cross-year comparison; nominal matches contracts and actual cash but carries inflation in every figure.
- Inflation assumption — the single rate (or index) used to convert. A general index is simple; sector-specific indices are more accurate but multiply the bookkeeping.
- Granularity of tagging — tagging every line item versus whole categories. Line-level tagging catches subtle mixes but is heavier; category-level is faster but coarser.
- Currency handling — for cross-border flows, whether to convert then adjust or adjust then convert. The order changes the result and must be fixed once.
When it helps, and when it misleads¶
Its strength is that it neutralises one of the archetype's quietest, most expensive errors — a real/nominal mismatch that leaves the arithmetic pristine and the answer wrong. It is cheap insurance that makes every downstream discounting result trustworthy.
Its failure mode is a false sense of safety: a worksheet that is internally consistent can still rest on a badly wrong inflation assumption — consistency is not accuracy, and a uniformly applied but implausible inflation rate passes the check while corrupting the appraisal. It can also breed box-ticking, where a row is tagged "real" without anyone verifying the underlying estimate truly is. The discipline is to treat the pass as "bases are consistent," not "figures are right," to pressure-test the inflation assumption itself rather than only its uniform application, and to keep the tags honest by checking a few rows against their sources rather than trusting the labels.
How it implements the components¶
temporal_unit_and_value_basis_alignment— its core: it certifies that every flow and the rate share one compatible value basis before any summation.real_nominal_indexing_basis— it fixes the real-versus-nominal and price-base indexing decision, applying one inflation and base-year assumption across all rows.
It does no discounting and issues no verdict (present_value_conversion_rule — Net Present Value Model) and it runs no robustness sweep (sensitivity_and_threshold_test — Scenario Sensitivity Grid); it only guarantees the basis those tools consume is consistent.
Related¶
- Instantiates: Temporal Discounting and Present-Value Framework Selection — it upholds the invariant that real and nominal assumptions stay consistent.
- Sibling mechanisms: Net Present Value Model · Discounted Cash-Flow Table · Social Discount-Rate Schedule · Declining Discount-Rate Schedule · Scenario Sensitivity Grid · Payback and Break-Even Cross-Check · Real-Options Cross-Check
Editorial Notes¶
Form Classification¶
Form family: Representation, Specification & Plan
Rationale: Real Nominal Adjustment Worksheet operates by externalizes each input's real-or-nominal basis, base year, and matching conversion in a worksheet. That concrete deployed or enacted form is Representation, Specification & Plan under the frozen taxonomy.
Nearest alternative: Assessment, Review & Assurance — Although Assessment, Review & Assurance can support this mechanism, the frozen evidence makes its operative form the act that externalizes each input's real-or-nominal basis, base year, and matching conversion in a worksheet; the alternative is therefore secondary rather than defining.
Review outcome: Adjudicated after independent review; high confidence.
Origin Attribution¶
Primary origin: Economics & Finance
Origin pattern: Single lineage
Present-day reach: Specialized
Rationale: Real-versus-nominal adjustment and discount-rate consistency are core economic and financial analysis.
Review outcome: Independent reviewer agreement; high confidence.
Notes¶
[n1] The Fisher equation relates nominal and real rates through inflation: (1 + nominal) = (1 + real) × (1 + inflation). It is the conversion the worksheet uses to keep flows and rates on a matching basis. ↩