Discounted Cash-Flow Table¶
Artifact — instantiates Temporal Discounting and Present-Value Framework Selection
Displays period-by-period flows, discount factors, and present-value contributions.
A Discounted Cash-Flow Table is the ledger of the present-value calculation — the artifact that lays the computation out in the open so a reader can audit it line by line. Where a Net Present Value Model hands you a single figure, the table shows its full working: one row per period, columns for the raw flow, the discount factor at that period, the resulting present-value contribution, and a running total. Its defining property is transparency of structure: nothing is collapsed. The whole point is that anyone can trace how a distant flow shrank, spot which years carry the result, and see — because the table labels it — whether each flow is stated in real or nominal terms. It computes no verdict and justifies no rate; it makes the arithmetic inspectable.
Example¶
A neighbourhood bakery is quoted a 6 kW rooftop solar array and wants to see, not just be told, whether it is worth it. The installer produces a Discounted Cash-Flow Table. Row by row across twenty years: the year-0 row shows the $11,000 install cost as a negative flow; each following row shows that year's electricity saving (starting near $1,300 and rising with an assumed tariff drift), an inverter-replacement cost dropped into year 11, and a small annual maintenance line. Two things are made explicit in the table's own headers. A column flags that the savings are stated in nominal dollars — the number the meter will actually show that year — so they can be discounted with a nominal rate rather than accidentally mixed. And a discount-factor column shows 1/(1.06)^t shrinking from 0.94 in year 1 to 0.31 in year 20.
The present-value contribution column is where the story lands: each year's saving multiplied by its factor. The owner can now see at a glance that the first eight years carry most of the value and the year-11 inverter hit is real but survivable. The table's running total closes at a modest positive present value — but crucially the owner saw the shape, not just the sum, and noticed the whole case leans on the tariff-drift assumption in the middle rows.
How it works¶
- One row per period, in order. The timing profile becomes the table's spine; a lumpy cost like the inverter swap sits in its actual year rather than being smeared.
- A visible discount-factor column. The conversion rule is shown as an explicit multiplier per row, not hidden inside a formula — the reader watches distant flows lose weight.
- A labelled basis. Each flow column is marked real or nominal with its price-base year, so the table itself records the indexing basis rather than leaving it to be assumed.
- A running present-value total. Contributions accumulate down the column, so the reader sees the sum build and can point at the rows that dominate it.
Tuning parameters¶
- Row granularity — annual rows or finer. More rows show lumpy timing faithfully but grow the artifact and its upkeep.
- Column set — the minimum (flow, factor, PV) or an expanded ledger (gross benefit, gross cost, cumulative undiscounted, cumulative discounted). More columns aid audit but crowd the view.
- Basis labelling — whether real/nominal and price-base year are shown per column or stated once in a header note. Per-column is safer against mixing; a header note is lighter.
- Precision shown — dollars, thousands, or rounded. Coarser display resists false precision but can hide a decisive small flow.
When it helps, and when it misleads¶
Its strength is auditability: it turns a discounting result from a claim into a document, exposes which periods drive the answer, and makes a real/nominal mix visible before it corrupts the total.[n1] It is the shared surface a reviewer, a client, and an analyst can all point at.
Its failure mode is that a clean-looking table lends false authority to whatever assumptions filled it — a plausible tariff drift or a chosen rate reads as fact once it is rendered in neat columns. The table can also mislead by omission: a horizon cut a few rows short simply drops later flows off the bottom, and the reader may not notice the missing rows. The discipline is to read the table as a display of assumptions, not evidence for them — to check the basis labels, confirm the last row is the true horizon and not a convenient stopping point, and send the underlying numbers to a robustness check rather than trusting the tidy grid.
How it implements the components¶
consequence_timing_profile— the table's rows are the timing profile, each consequence pinned to its own period and kept auditable rather than aggregated away.present_value_conversion_rule— it renders the conversion as an explicit discount-factor column and a present-value-contribution column, so the rule is shown rather than buried.real_nominal_indexing_basis— each flow column carries a real/nominal label and price-base year, recording the indexing basis on the face of the artifact.
It performs no arithmetic verdict — the single decision figure is Net Present Value Model's output, not the table's — and it displays a basis without reconciling it (temporal_unit_and_value_basis_alignment — Real/Nominal Adjustment Worksheet); it also neither justifies the rate (discount_rate_rationale — Social Discount-Rate Schedule) nor tests robustness (sensitivity_and_threshold_test — Scenario Sensitivity Grid).
Related¶
- Instantiates: Temporal Discounting and Present-Value Framework Selection — the table is the auditable surface the framework's calculation is laid out on.
- Consumes: Real/Nominal Adjustment Worksheet supplies the basis its columns display.
- Sibling mechanisms: Net Present Value Model · Social Discount-Rate Schedule · Declining Discount-Rate Schedule · Scenario Sensitivity Grid · Real/Nominal Adjustment Worksheet · Payback and Break-Even Cross-Check · Real-Options Cross-Check
Editorial Notes¶
Form Classification¶
Form family: Analysis, Modeling & Optimization
Rationale: The operative form is the period-by-period calculation that applies discount factors and converts future flows into present-value contributions and a running total.
Nearest alternative: Representation, Specification & Plan — The table externalizes the result, but a static table without the discount computation would not perform the mechanism.
Review outcome: Adjudicated after independent review; high confidence.
Origin Attribution¶
Primary origin: Economics & Finance
Origin pattern: Single lineage
Present-day reach: Specialized
Rationale: Finance cohered discounted cash-flow valuation and its canonical period-by-period table of flows, discount factors, and present-value contributions.
Related originating lineages:
- Accounting & Auditing — Accounting practice supplies and reconciles the period cash-flow inputs displayed in the valuation schedule.
Review resolution: Both current reviews place discounted_cash_flow_table primarily in economics_finance; the reconciled classification retains only lineages that materially shaped the mechanism and keeps breadth of origin separate from reach.
Review outcome: Reconciled after independent review; high confidence.
Notes¶
[n1] Discounted cash flow is the standard valuation method of expressing a stream of future cash flows in present-value terms via period discount factors. The table is its canonical presentation format — the layout that makes the method's per-period working legible. ↩