FV Financial Function in Excel – how can I use this financial function in my spreadsheets? Watch the video to learn more

This week’s hint and tip is on the FV financial function in Excel. This looks at the financial function which is applicable to home as well as business use. This isn’t covered in any of our courses so we decided to do a hint and tip on it.FV financial function in Excel: Excel icon We are going to go through it now below.

 

This week’s blog on FV financial function in Excel

This week’s video was recorded in Sept 2020 when interest rates across the country are very low and it’s hard to get any interest worthwhile from a bank or building society. So I thought it would be good to see how Excel could be used to compare investments pots of money across different interest rates.

We cover another financial feature in our master class course called Data Scenarios

The structure of the FV function used in our video is as follows:

FV financial function in Excel: screenshot of the FV function

The interest Rate is input as a yearly APR in cell D2 but since we have 3 separate interest rates on row 2 we use an absolute reference D$2 (Rate)

The number of periods is 10 years held in just 1 cell B2 (Nper)

The payment each year is in C2 (Pmt)

The initial investment is held is A2 (Pv)

All of the arguments stated above in bold are mandatory

 

Why is the answer in the video negative?

In Excel language, if the initial cash flow is an inflow (positive), then the future value must be an outflow (negative). You could always put a -ve before the FV if you wish.

 

The video below shows you what the FV function does and how you can use it in your spreadsheets in Excel. This feature in Excel can be very useful for working out how much an investment will make.

Take a look below at the video to find out more and then try it out on your own computer!

We hope you have enjoyed this hint and tip on FV financial function in Excel. Why not take a look at our previous one on dependent list type of data validation?

Cookie Control

Cookie control

We have placed cookies on your device to help make this website better.

I'm fine with this

We have placed cookies on your device to help make this website better.

You can use this tool to change your cookie settings. Otherwise, we’ll assume you’re OK to continue.

Some of the cookies we use are essential for the site to work.

We also use some non-essential cookies to collect information for making reports and to help us improve the site. The cookies collect information in an anonymous form.

To control third party cookies, you can also adjust your browser settings.

I'm fine with this
(One cookie will be set to store your preference)
(Ticking this sets a cookie to hide this popup if you then hit close. This will not store any personal information)
Information and Settings Cookie policy