What does it do?

Calculates the compound interest

Formula breakdown:

=FV(rate, nper, pmt, [pv])

What it means:

=FV(interest rate, number of periods, periodic payment, initial amount)

Say that you turn 18 years today (CONGRATS!) and you find out that your parents deposited an amount with their bank when you were born.

Now that you are 18 years old you can collect this money and go spend it all in one day!

How much would be available for you to spend?

Thankfully there is an easy way to calculate this with Excel’s FV formula! FV stands for Future Value.

The future value (FV) is the value of a current asset at a specified date in the future based on an assumed rate of growth over time.

In our example below, we have the table of values that we need to get the compound interest or Future Value from:

(Change the NUMBER OF YEARS column to 18 to see the results on your 18th birthday)

Compound Interest Formula in Excel

I explain how you can do this below:


STEP 1: We need to enter the FV function in a blank cell:


Compound Interest Formula in Excel


STEP 2: The FV arguments:


What is the rate of the interest?

Select the cell containing the interest rate (make sure that this is in a percentage):


Compound Interest Formula in Excel


How many periods?

Select the cell containing the number of years:

=FV(B9, C9,

Compound Interest Formula in Excel


What is the periodic payment?

We have no periodic payment, only an initial amount, so let us put in 0:

=FV(B9, C9, 0,

Compound Interest Formula in Excel


What is the initial amount?

PV stands for present value, the initial amount. We need to change this to a negative value by multiplying -1.

The reason why we need this as a negative value as Excel treats this as “money out” for your investment.

=FV(B9, C9, 0, A9 * -1)

Compound Interest Formula in Excel


Apply the same formula to the rest of the cells by dragging the lower right corner downwards.

You now have all of the compound interest results!  GO OUT & SPEND!

Compound Interest Formula in Excel


Get the Compound Interest with Excel’s FV Formula

Compound Interest Formula in Excel


How to Combine VLOOKUP and IFERROR to Replace the #N/A Error in Excel


If you like this Excel tip, please share itEmail this to someone


Pin on Pinterest


Share on Facebook


Tweet about this on Twitter


Share on LinkedIn


Share on Google+


Related Posts

Clear Everything Before the Hyphen with Excel̵... What does it do? Replaces part of a text string, based on the number of characters you specify, with a different text string Formula breakdown: =REPLACE(old_text, start_num, num_chars, new_text) What it means: =REPLACE(this cell, starting from this number, all the ...
Round Off Numbers with Excel’s ROUND Formula What does it do? Rounds a number to the nearest decimal based on your specified number of digits Formula breakdown: =ROUND(number, num_digits) What it means: =ROUND(the number, number of decimal places to round off) Ever had the need to round off numbers? ...
Cleaning Data with Excel’s SUBSTITUTE Formul... What does it do? Substitutes new_text for old_text in a text string. Formula breakdown: =SUBSTITUTE(text, old_text, new_text, ) What it means: =SUBSTITUTE(This cell, By this text character, To this text character, ) When you needed to replace a specific text...
10 + 1 Ways to Round Numbers in Excel This is a guest post by Alan Murray from Computergaga. There are many ways to round numbers in Excel. These techniques will typically involve formatting the values, or using formulas. This post will look at 10 rounding functions of Excel, and then look at some formatting te...