# Current value of compound interest

How can I calculate the current value of a sum deposited in a past date, with a fixed interest rate?

For example, if \$1,000 were deposited on 1/1/2000 in an account which pays a 3% annual interest rate, how much would they be worth today?

# COMPOUND INTEREST:

• `cell F6:` `=B6*(1+C6)^(YEARFRAC(A6,TODAY()))`
• `cell G6:` `=B6*(1+C6/4)^(4*YEARFRAC(A6,TODAY()))`
• `cell H6:` `=B6*(1+C6/12)^(12*YEARFRAC(A6,TODAY()))`
• `cell I6:` `=B6*(1+C6)^(ROUNDDOWN(YEARFRAC(A6,TODAY()),0))`
• `cell J6:` `=B6*(1+C6/4)^(4*ROUNDDOWN(YEARFRAC(A6,TODAY()),0))`
• `cell K6:` `=B6*(1+C6/12)^(12*ROUNDDOWN(YEARFRAC(A6,TODAY()),0))`

# INTEREST MULTIPLIED BY YEARS:

• up to today's date:

``=B2 + C2/100*B2 * YEARFRAC(A2; TODAY())``

• up to to the start of new anual period (eg. from 01.01.2000 to 31.12.2018):

``=B2 + C2/100*B2 * ROUNDDOWN(YEARFRAC(A2; TODAY()); 0)``

• Many thanks! Just one difficulty: I had to use 3 (and not 3%) under annual rate in order to get to the same result. Or delete the "/100".
• yup, C2 was custom formatted with `@%` mask Commented Jan 18, 2019 at 11:40