Time value of money calculator (future and present value)

Solve for the future value, present value, interest rate or time of a lump sum from the other three, with any compounding, including continuous.

Diperbarui Contoh terverifikasi: 9

$
%
years
Coba
Future value
$
Future value: $17,908.48
Tempat desimal: 2; Terdekat, jika berjarak sama menuju digit genap
Effective annual rate
6.0000%
Growth multiple (FV ÷ PV)
1.79085

$10,000.00 grows to $17,908.48 in 10 years at 6% a year — 1.791× the starting amount.

Value over time

$10K$12K$14K$16K0246810YearsPVFV
Value by year Baris: 10
TahunStart valueGrowthEnd value
1$10,000.00$600.00$10,600.00
2$10,600.00$636.00$11,236.00
3$11,236.00$674.16$11,910.16
4$11,910.16$714.61$12,624.77
5$12,624.77$757.49$13,382.26
6$13,382.26$802.94$14,185.19
7$14,185.19$851.11$15,036.30
8$15,036.30$902.18$15,938.48
9$15,938.48$956.31$16,894.79
10$16,894.79$1,013.69$17,908.48
Cara menghitung S
  1. Grow the present value

    FV=PV×(1+0.061)1×10=10,000.00×1.790847697=17,908.48FV = PV \times \left(1+\frac{0.06}{1}\right)^{1 \times 10} = 10{,}000.00 \times 1.790847697 = 17{,}908.48
  2. Effective annual rate

    (1+r1)1−1=6.0000%\left(1+\frac{r}{1}\right)^{1} - 1 = 6.0000\%

Tentang Time value of money calculator (future and present value)

The time value of money links four numbers for a single sum: the present value PV, the future value FV, the annual rate r and the time t. With compounding k times a year, FV = PV × (1 + r/k)^(kt), and continuous compounding gives FV = PV × e^(rt). Given any three, the fourth follows: dividing FV by the growth factor gives the present value, a root gives the rate, and logarithms give the time.

With the defaults, 10,000 at 6% compounded yearly grows to 17,908.48 in 10 years, 1.79 times the starting amount. Discounting runs the other way: 20,000 due in 10 years is worth 10,992.65 today at 6% compounded monthly.

This covers one deposit with no further payments; for regular contributions use the compound interest or SIP calculator. The rate is a nominal yearly rate, and the effective annual rate shows what the compounding adds to it.

Contoh penyelesaian

Future value of 10,000 at 6% for 10 years

Solve for
Future value
Present value
10,000
Interest rate (per year)
6%
Waktu
10 years
Compounding
Yearly
Future value
17,908.48

Sumber pemeriksaan: 10000 × 1.06^10 = 17908.4769654… (Python decimal)

Present value of 20,000 in 10 years at 6% monthly

Solve for
Present value
Future value
20,000
Interest rate (per year)
6%
Waktu
10 years
Compounding
Monthly
Present value
10,992.65
Effective annual rate
6.1678%

Sumber pemeriksaan: 20000 / 1.005^120 = 10992.6546672… (Python decimal)

Excel RRI: 10,000 to 11,000 over 96 months

Solve for
Rate
Present value
10,000
Future value
11,000
Waktu
8 years
Compounding
Monthly
Interest rate needed (per year)
1.1920%

Sumber pemeriksaan: Microsoft RRI documentation: =RRI(96,10000,11000) = 0.0009933 per month; × 12 = 1.19197 % (Python decimal 12·(1.1^(1/96) − 1))

Excel PDURATION: 2,000 to 2,200 at 2.5%

Solve for
Waktu
Present value
2000
Future value
2200
Interest rate (per year)
2.5%
Compounding
Yearly
Time needed
3.86 years

Sumber pemeriksaan: Microsoft PDURATION documentation: =PDURATION(2.5%,2000,2200) = 3.86 years; ln 1.1 / ln 1.025 = 3.85987 (Python decimal)

Pertanyaan

How do you calculate the future value of a lump sum?

Multiply the present value by (1 + r/k)^(kt), where r is the annual rate, k the compounding periods a year and t the years. 10,000 at 6% compounded yearly for 10 years grows to 10,000 × 1.06^10 = 17,908.48. Excel's =FV(6%, 10, 0, -10000) returns the same amount.

How do you calculate present value?

Divide the future amount by the growth factor: PV = FV ÷ (1 + r/k)^(kt). At 6% compounded monthly, 20,000 due in 10 years is worth 20,000 ÷ 1.005^120 = 10,992.65 today. A higher discount rate or a longer wait lowers the present value; Excel's =PV(0.5%, 120, 0, -20000) gives the same figure.

How do you work out the interest rate needed to reach a target?

Take the growth multiple to the power 1 ÷ (number of periods) and subtract 1: r = (FV ÷ PV)^(1/t) − 1. Doubling money in 10 years takes 2^(1/10) − 1 = 7.18% a year. Microsoft's example for Excel's RRI function, 10,000 growing to 11,000 over 96 months, gives 0.0009933 a month, 1.19% a year.

How long does it take for money to reach a target amount?

Divide the logarithm of the growth multiple by the logarithm of one plus the rate per period: n = ln(FV ÷ PV) ÷ ln(1 + r/k). Growing 2,000 to 2,200 at 2.5% a year takes ln 1.1 ÷ ln 1.025 = 3.86 years, the answer Excel's PDURATION function gives. Doubling at 7% compounded monthly takes 119.17 months, or 9.93 years.

What is the difference between a nominal and an effective annual rate?

The nominal rate is the quoted yearly rate; the effective rate includes interest earned on interest within the year: (1 + r/k)^k − 1. A nominal 6% compounded monthly is 6.1678% effective, 6.1831% compounded daily and 6.1837% compounded continuously (e^0.06 − 1). Compare offers on the effective rate, not the nominal one.

Seberapa akurat “Time value of money calculator (future and present value)”?

Akurasi bergantung pada masukan dan asumsi metode. Aritmetika desimal memakai 50 digit signifikan, tetapi perkiraan, metode numerik dan data sumber bisa kurang presisi; pembulatan yang ditampilkan tidak menghilangkan batasan itu. Contoh penyelesaian yang diperiksa dengan sumber independen: 9. Misalnya, “Future value of 10,000 at 6% for 10 years” diperiksa dengan 10000 × 1.06^10 = 17908.4769654… (Python decimal).

Dari mana metode ini berasal?

Microsoft Excel RRI function; Microsoft Excel PDURATION function; Brealey, Myers & Allen — Principles of Corporate Finance, ch. 2 (present values).

Tentang kalkulator ini

FV=PV(1+rk)kt  (continuous: PVert),r=k[(FV/PV)1/(kt)−1],t=ln⁡(FV/PV)kln⁡(1+r/k)FV = PV\left(1+\tfrac{r}{k}\right)^{kt}\ \ (\text{continuous: } PV e^{rt}),\quad r = k\left[(FV/PV)^{1/(kt)} - 1\right],\quad t = \frac{\ln(FV/PV)}{k \ln(1+r/k)}

Sumber

  1. Microsoft Excel RRI function
  2. Microsoft Excel PDURATION function
  3. Brealey, Myers & Allen — Principles of Corporate Finance, ch. 2 (present values)

Hanya untuk perencanaan. Pemberi pinjaman, otoritas pajak dan pasar menerapkan pembulatan, biaya dan aturan sendiri; konfirmasikan angka kepada mereka sebelum membuat komitmen.

Diperiksa dengan referensi

Kalkulator ini mencakup 9 contoh perhitungan dengan jawaban dari sumber independen. Contoh tersebut dijalankan dalam rangkaian pengujian dan dapat Anda jalankan di sini juga.

Kalkulator terkait