Discount Factor Calculator

The calculation itself

A discount factor is present value with the numerator set to one: 1 ÷ (1 + r)^t. It is the multiplier that converts a unit of money at period t into money today.

The running total down the column is the cumulative discount factor, and it is the annuity factor. Multiply a level payment by it and you have the present value of the whole stream — the same answer the annuity formula gives, reached by addition instead of algebra.

That equivalence is why printed discount tables always had two columns, and why building the table is more useful than computing one number.

In practice

At 10%, the factor for period five is 0.6209 — a dollar then is worth about 62 cents now.

Summed over ten periods the cumulative factor is 6.1446. So $1,000 a year for ten years at 10% is worth $6,144.60 today, against $10,000 of face value.

The shape is the useful part. Period one contributes 0.909, period ten contributes 0.386, and everything past about period fifteen adds very little at ordinary rates. A thirty-year forecast at 10% is mostly a ten-year forecast with decoration.

At 10% a future amount loses half its present value every 7.27 periods. That half-life framing makes the erosion concrete in a way a table of decimals does not.

Where the figure deceives

Factors below one are a consequence of a positive rate, not a law. Negative rates have appeared in real bond markets, and they produce factors above one — future money worth more than present money, which is strange but arithmetically ordinary.

Whole-period discounting assumes cash arrives on the last day of each period. It rarely does. The mid-year convention uses fractional periods — 0.5, 1.5, 2.5 — and raises the valuation slightly; it is standard in professional valuation and worth knowing about before reconciling two models that differ by a few percent for no visible reason.

And a factor table is only as meaningful as its rate. The precision of four decimal places says nothing about whether 10% was the right rate to tabulate.

Acting on it

Use the cumulative column whenever the payments are level — it turns a stream into one multiplication.

Look at where the factors stop mattering before deciding how long to forecast. Effort spent on years whose factors are below about 0.2 is largely wasted.

If you are reconciling against someone else's model, check the period convention first. End-of-period against mid-year is the commonest reason two correct models disagree.