LessonThis is a lesson restated in new words. Any figure in it is an example from the source, not this desk's record.
The time value of money is the idea that a cash amount and a date belong together. A quantity you can use today and the same quantity dated in the future are different economic objects, because interest is the exchange rate between those dates. This opening session of the quantitative-finance series is about that comparison: present value as today's reading of a later sum, continuous time as one way to describe the accrual, and a spreadsheet as the practical place to line the dates up.
Why it matters
Every later pricing step in this series discounts something. An option payoff is a possible cash amount on an expiration date. A hedge that locks in a value one step ahead is still a value one step ahead, and it has to be carried back to the day the price is agreed. None of that arithmetic makes sense until a later dollar is allowed to be worth a different number of today's dollars. The session is the vocabulary for that move. Interest is the rate used in the exchange. Present value is the result of applying the exchange to a future amount. A longer gap, or a higher interest rate, moves the present value farther from the future amount.
The idea in plain words
Pick a date and a sum. Ask what that sum is worth on a different date. Moving forward in time, interest adds to the sum. Moving backward, interest is taken out, which is discounting. The forward move answers how much a present sum grows into. The backward move answers how much you would accept today in place of a known later sum. Both moves use the same rate. They point the clock in opposite directions.
Continuous time is the version in which the clock is not chopped into coupons. Interest is described as accruing along the whole interval, and the exchange between two dates depends on the length of the interval and on the rate, without a separate factor for each coupon date. Discrete compounding is the other classroom picture, with a factor applied once per period. The session treats the continuous description as a legitimate way to write the same idea, with the length of the interval part of the answer.
A spreadsheet is the tool the session points at for doing the comparison in practice. Dates go in one column, amounts in another, and the rate is a single cell the formulas can share. Changing the rate or the gap recomputes the present reading without a new derivation. That is the right scale for a first session: one rate, two dates, and a formula that can face either direction.
How to use it
Write down the amount and the date it is paid. Write down the date you want the reading for, and write down the interest rate that connects them. If the reading date is earlier, you are discounting. If it is later, you are accruing. Keep the rate and the gap in the same units. A yearly rate belongs with a gap measured in years. A continuous convention uses the length of the gap as the time argument of the exponential. A per-period convention uses the count of periods.
What usually goes wrong
Mixing a percent with a decimal silently scales every result by 100. Mixing a monthly rate with an annual gap does the same kind of damage. The sheet should show the unit next to the rate.
Treating the future amount as already comparable with cash in hand skips the conversion. That error gets more expensive as the date moves out. It is the error this session exists to name.
Use a rate and a pair of dates you actually have. The comparison itself does not depend on one famous numerical example.
Questions people ask
What does present value mean here?
It is the amount today that the chosen interest rate sets as the equivalent of a stated later sum. The later sum and the present value are linked by the rate and the time gap.
Why does the session mention continuous time?
Because later models in the series accrue and discount along a continuous clock. The time gap enters the conversion directly, rather than as a count of coupon dates.
Where should the arithmetic be done?
In a spreadsheet, with the amount, the rate, and the gap in separate cells, so a change in any one of them recomputes the time-adjusted value.