The Time Value of Money (TVM) is a core financial principle stating that a sum of money is worth more now than the same sum will be at a future date due to its potential earning capacity.
- Evaluate Investments: Compare the value of different investment opportunities.
- Plan for the Future: Determine how much to save for a future goal or how much a current investment will be worth.
- Analyze Loans and Debts: Understand payment structures, total interest paid, and remaining balances.
- Make Informed Financial Decisions: Quantify the impact of time, interest rates, and payment schedules on financial outcomes.
Key TVM Variables Explained
- N (Number of Periods): Total compounding or payment periods (e.g., 5 years x 12 months = 60 periods).
- I/Y (Interest Rate per Year): Enter as a percentage (e.g., 6 for 6%).
- PMT (Payment Amount): Fixed payment received or paid each period.
- PV (Present Value): Value of future money in today's terms.
- FV (Future Value): Projected value of money at a future date.
- P/Y (Payments per Year): Frequency of payments (e.g., 12 for monthly).
- C/Y (Compounding Periods per Year): Frequency of compounding (can differ from payments).
- P.T (Payment Timing): Choose 'END' for ordinary annuity or 'BEGIN' for annuity due.
Key TVM Formulas
Periodic interest rate ($i$):
$$ i = \left(1 + \frac{I/Y}{100 \cdot C/Y}\right)^{C/Y \,/\, P/Y} - 1 $$
Future Value of a Lump Sum:
$$ FV = PV (1 + i)^N $$
Future Value of an Ordinary Annuity (END):
$$ FV = PV (1 + i)^N + PMT \times \frac{(1 + i)^N - 1}{i} $$
Future Value of an Annuity Due (BGN):
$$ FV = PV (1 + i)^N + PMT \times \frac{(1 + i)^N - 1}{i} \times (1 + i) $$
Present Value of an Ordinary Annuity (END):
$$ PV = FV (1 + i)^{-N} + PMT \times \frac{1 - (1 + i)^{-N}}{i} $$
Present Value of an Annuity Due (BGN):
$$ PV = FV (1 + i)^{-N} + PMT \times \frac{1 - (1 + i)^{-N}}{i} \times (1 + i) $$
BGN timing factor: In an annuity due, each payment occurs at the start of its period, earning one extra period of interest compared to an ordinary annuity. This is captured by multiplying the annuity term by $(1+i)$.
Solving for N (lump sum, $PMT = 0$):
$$ N = \frac{\ln(-FV/PV)}{\ln(1+i)} $$
Solving for N (annuity, END, $PMT \neq 0$):
$$ N = \frac{\ln\!\left(\dfrac{PMT/i - FV}{PMT/i + PV}\right)}{\ln(1+i)} $$
Solving for I/Y (lump sum, $PMT = 0$):
$$i = \left(-\frac{FV}{PV}\right)^{1/N} - 1$$ $$I/Y = 100 \cdot C/Y \cdot \left[(1+i)^{P/Y \,/\, C/Y} - 1\right]$$
When $PMT \neq 0$ there is no closed-form solution for $I/Y$. The calculator solves it numerically using Newton-Raphson iteration.
Where:- $PV$ = Present Value
- $FV$ = Future Value
- $PMT$ = Payment per period
- $N$ = Total number of periods
- $i$ = Periodic interest rate per payment period
If the payment amount is zero (i.e., lump sum compound interest), the annuity formulas simplify to the lump sum formula above.
For more in-depth information on Time Value of Money concepts and formulas, refer to Mathematics of Finance Book .