What is the time value of money formula?

The core time value of money formula is FV = PV × (1 + r)^n, where PV is present value, FV is future value, r is the interest rate per period, and n is the number of periods. This equation can be rearranged to solve for any of the four variables when the other three are known.

What are the 5 variables in TVM?

The five TVM variables are: PV (present value — the current worth of money), FV (future value — the amount money grows to), r (interest rate per period), N (number of compounding periods), and PMT (periodic payment amount). Knowing any four lets you solve for the fifth.

How do you solve for interest rate in TVM?

For a lump sum, rearrange FV = PV × (1+r)^n to get r = (FV/PV)^(1/n) − 1. For example, if $5,000 grows to $8,000 in 10 years: r = (8000/5000)^(1/10) − 1 = 4.81%. When periodic payments are involved, numerical methods like Newton-Raphson or Excel's RATE function are needed.

What is the difference between simple and compound interest in TVM?

Simple interest is calculated only on the original principal: FV = PV × (1 + r×n). Compound interest earns interest on previously accumulated interest: FV = PV × (1+r)^n. Over long periods, compounding produces dramatically higher returns. For example, $10,000 at 8% for 20 years yields $26,000 with simple interest but $46,610 with compound interest.

How does TVM apply to retirement planning?

TVM is essential for retirement planning. It helps you calculate how much to save today to reach a future goal. For example, to accumulate $1,000,000 in 30 years at 7%, you'd need to invest about $820/month. It also helps determine how long retirement savings will last when making withdrawals.

What is the TVM formula in Excel?

Excel has five built-in TVM functions: =FV(rate, nper, pmt, [pv], [type]) for future value, =PV(rate, nper, pmt, [fv], [type]) for present value, =PMT(rate, nper, pv, [fv], [type]) for payment, =RATE(nper, pmt, pv, [fv], [type]) for interest rate, and =NPER(rate, pmt, pv, [fv], [type]) for number of periods.

Why is the time value of money important?

TVM is important because it recognizes that money received today has more value than the same amount in the future due to its earning potential. It is the foundation for virtually all financial decisions including investment valuation, loan pricing, retirement planning, capital budgeting, and comparing cash flows occurring at different times.

Time Value of Money Formula — TVM Equations Explained with Examples

The time value of money (TVM) is the single most important concept in finance. This guide walks you through all five TVM formulas — for PV, FV, rate, N, and PMT — with derivations, numerical examples, an interactive calculator, and Excel instructions.

What Is the Time Value of Money?

TVM Core Principle — A Dollar Today Is Worth More Than a Dollar Tomorrow

The time value of money states that money in hand today is worth more than the identical sum received in the future. This reflects the opportunity cost of waiting — money available now can be invested to earn returns through the power of compound interest.

Consider: receive $10,000 today or $10,000 one year from now. The rational choice is always today, because investing at 5% gives you $10,500 by year's end. Waiting costs you $500 in lost earnings.

Why TVM Matters in Finance & Investing

Investment valuation — Discounting future cash flows to determine what an asset is worth today
Loan pricing — Banks use TVM to calculate monthly payments and amortization schedules
Retirement planning — Projecting periodic savings growth via the retirement calculator
Capital budgeting — Corporations compare present values of project cash flows to choose investments
Risk assessment — Higher uncertainty demands a higher discount rate, reducing present value

The Five TVM Variables — PV, FV, Rate, N, PMT

Every TVM problem involves exactly five variables. Knowing any four lets you solve for the fifth — this is the power of the time value of money equation.

Present Value (PV) — What You Have Today

The current worth of a future sum, discounted at an appropriate rate. It answers: "How much must I invest today to reach a future goal?" See our present value formula guide.

Future Value (FV) — What You'll Have Tomorrow

The value money grows to after earning interest over time. It answers: "If I invest $X today, how much will I have in N years?" See the future value formula guide.

Interest Rate (r) — The Cost of Time

The return earned on invested capital — or the cost of borrowing. It captures opportunity cost, inflation expectations, and risk premium. Use the rate of return calculator to find implied rates.

Number of Periods (N) — How Long You Wait

Total compounding periods. For annual compounding, N equals years. For monthly compounding over 5 years, N = 60. Longer horizons amplify compounding exponentially.

Payment (PMT) — Periodic Cash Flows

Equal periodic deposits or withdrawals. When PMT is present, the problem becomes an annuity — payments at period end (ordinary) or beginning (annuity due).

TVM Formulas for Lump Sums

When there are no periodic payments (PMT = 0), the TVM equations simplify to four formulas — each solving for one variable.

Future Value Formula: FV = PV × (1 + r)ⁿ

The fundamental time value of money compound interest equation — what a lump-sum investment grows to.

FV = PV × (1 + r)ⁿ

💡 Example: Invest $5,000 at 7% for 10 years.
FV = $5,000 × (1.07)¹⁰ = $5,000 × 1.9672 = $9,836

Present Value Formula: PV = FV / (1 + r)ⁿ

The inverse — discounting a future amount back to today. Essential for comparing present and future values.

PV = FV ÷ (1 + r)ⁿ

💡 Example: $20,000 received in 8 years at 5%?
PV = $20,000 ÷ (1.05)⁸ = $20,000 ÷ 1.4775 = $13,537

Solving for Rate: r = (FV/PV)^1/n − 1

r = (FV / PV)^1/n − 1

💡 Example: $8,000 grew to $15,000 in 12 years.
r = (15,000 / 8,000)^1/12 − 1 = (1.875)^0.0833 − 1 = 5.34%

Solving for Time: n = ln(FV/PV) / ln(1 + r)

n = ln(FV / PV) ÷ ln(1 + r)

💡 Example: How many years to double $10,000 at 6%?
n = ln(2) / ln(1.06) = 0.6931 / 0.0583 = 11.90 years

📊 Quick TVM Calculator

Solve For

Present Value (PV)

Future Value (FV)

Annual Interest Rate

Number of Years (N)

years

TVM Formulas for Annuities

When periodic payments are involved, the time value of money annuity formula applies. See full derivations in our annuity formulas guide.

FV of Ordinary Annuity: FV = PMT × [((1+r)ⁿ − 1) / r]

An ordinary annuity has payments at the end of each period. The factor [((1+r)ⁿ − 1) / r] is called FVIFA.

FV_ordinary = PMT × [((1 + r)ⁿ − 1) / r]

💡 Example: $500/month for 20 years at 6% (0.5%/month).
FV = $500 × 462.04 = $231,020 — you contributed $120,000; interest earned $111,020. Try the annuity FV calculator.

PV of Ordinary Annuity: PV = PMT × [(1 − (1+r)⁻ⁿ) / r]

The lump sum needed today to replace a stream of future payments — critical for pension valuation and bond pricing.

PV_ordinary = PMT × [(1 − (1 + r)⁻ⁿ) / r]

💡 Example: Pension of $3,000/month for 25 years at 5%.
PV = $3,000 × 170.52 = $511,567

Solving for PMT Given FV or PV

PMT = FV × r / ((1 + r)ⁿ − 1)

PMT = PV × r / (1 − (1 + r)⁻ⁿ)

For an annuity due (payments at the beginning), multiply the ordinary annuity result by (1 + r) to reflect the extra compounding period.

Compound Interest and the TVM Equation

How Compounding Frequency Affects TVM Calculations

The basic TVM formula assumes annual compounding, but interest often compounds monthly, daily, or continuously. More frequent compounding produces higher effective yields — the core of the time value of money compound interest relationship.

Adjusting the Formula for Monthly, Quarterly & Daily Compounding

When interest compounds m times per year, the compound interest formula becomes:

FV = PV × (1 + r/m)^m×n

For continuous compounding (m → ∞):

FV = PV × e^r×n

$10,000 at 8% over 20 years under different compounding frequencies:

Compounding	m	FV (20 Years)	Effective Rate
Annual	1	$46,610	8.000%
Quarterly	4	$48,010	8.243%
Monthly	12	$48,886	8.300%
Daily	365	$49,530	8.328%
Continuous	∞	$49,530	8.329%

Annual vs continuous compounding: a $2,920 difference driven entirely by compounding frequency.

How to Calculate TVM in Excel & Google Sheets

Excel and Google Sheets provide five built-in TVM functions corresponding directly to the five variables:

Excel FV Function: =FV(rate, nper, pmt, [pv], [type])

Scenario	Excel Formula	Result
$10,000 lump sum, 7%, 10 yrs	`=FV(0.07, 10, 0, -10000)`	$19,672
$500/month, 6%, 20 yrs	`=FV(0.06/12, 240, -500)`	$231,020

Excel PV Function: =PV(rate, nper, pmt, [fv], [type])

Scenario	Excel Formula	Result
$50,000 in 10 yrs at 6%	`=PV(0.06, 10, 0, -50000)`	$27,920
$1,000/yr for 20 yrs at 5%	`=PV(0.05, 20, -1000)`	$12,462

Excel RATE & NPER Functions

Function	Example	Result
RATE	`=RATE(10, 0, -8000, 15000)`	6.50%
NPER	`=NPER(0.06, 0, -10000, 20000)`	11.90 years
PMT	`=PMT(0.06/12, 240, 0, -231020)`	$500/month

Sign convention: Excel treats cash outflows (investments) as negative and inflows as positive. Make your initial investment (PV) negative when solving for FV.

Real-World TVM Applications

Retirement Planning: How Much to Save for $1 Million

Want $1,000,000 in your retirement account in 30 years at 7% compounded monthly?

PMT = $1,000,000 × (0.07/12) / ((1 + 0.07/12)³⁶⁰ − 1) = $820/month

You contribute $295,200 total; compound interest generates $704,800. Start 10 years later and the required payment jumps to $1,920/month — the cost of waiting.

Loan Analysis: The True Cost of Borrowing

A $300,000 mortgage at 6.5% for 30 years:

PMT = $300,000 × (0.065/12) / (1 − (1 + 0.065/12)⁻³⁶⁰) = $1,896/month

Total payments: $682,560. Interest alone is $382,560 — more than the principal. Use the investment FV calculator to see what that could earn if invested.

Investment Comparison: Choosing Between Two Opportunities

Option A: $50,000 in 5 years. Option B: $80,000 in 10 years. At 8% discount rate:

PV_A = $50,000 / (1.08)⁵ = $34,029

PV_B = $80,000 / (1.08)¹⁰ = $37,064

Option B wins ($37,064 vs $34,029). Without TVM analysis, you might mistakenly choose the shorter horizon.

Frequently Asked Questions

The core formula is FV = PV × (1 + r)ⁿ, where PV is present value, FV is future value, r is the rate per period, and n is the number of periods. It can be rearranged to solve for any variable. When periodic payments are involved, annuity TVM formulas apply.
PV (present value), FV (future value), r (interest rate per period), N (number of compounding periods), and PMT (periodic payment). Knowing any four lets you solve for the fifth.
For lump sums: r = (FV/PV)^1/n − 1. Example: $5,000 → $8,000 in 10 years gives r = 4.81%. With periodic payments, use numerical methods or Excel's =RATE().
Simple interest: FV = PV × (1 + r×n) — interest on principal only. Compound interest: FV = PV × (1+r)ⁿ — interest on interest. $10,000 at 8% for 20 years: simple = $26,000, compound = $46,610.
TVM calculates how much to save periodically to reach a goal (FV annuity formula), the present value of pension payments, and whether you're on track. Example: $820/month at 7% for 30 years = $1,000,000.
Five functions: =FV(), =PV(), =PMT(), =RATE(), and =NPER(). Each solves for one TVM variable when the others are provided.
Money today is worth more than the same amount later due to its earning potential. TVM is the foundation for investment valuation, loan pricing, retirement planning, and comparing cash flows at different points in time.