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:

DOWNLOAD EXCEL WORKBOOK

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

=FV(

Compound Interest Formula in Excel

 

STEP 2: The FV arguments:

rate

What is the rate of the interest?

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

=FV(B9,

Compound Interest Formula in Excel

nper

How many periods?

Select the cell containing the number of years:

=FV(B9, C9,

Compound Interest Formula in Excel

pmt

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

pv

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

HELPFUL RESOURCE:

oztraining_728x90

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

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

CountIf Formula in Excel What does it do?Counts the number of cells that matches your specified conditionFormula breakdown:=COUNTIF(range, criteria)What it means:=COUNTIF(range of cells to check, condition to check against)Do you have a scenario where you want to count the num...
Get the Average of Values with Excel’s AVERA... What does it do?Gives you the average of a group of valuesFormula breakdown:=AVERAGE(number1, number2...)What it means:=AVERAGE(the numbers you want to average) There are times when you have to get the average of your values in your Excel work...
RANDBETWEEN Function for Excel Dates What does it do?Generates random dates, in between a start date and an end dateFormula breakdown:=RANDBETWEEN(bottom, top)What it means:=RANDBETWEEN(starting date for random date generation, end date for random date generation) If you need to ...
Extract First Name From Full Name in Excel There were countless times when I had a list of full names, and all I needed was the First Name. It would be time-consuming to manually get the first names one by one. Thank goodness there are formulas to make my life easier!In Excel, it's very easy to do that with the LEFT a...