Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How to Use FVSCHEDULE Formula in Excel (2 Examples)

We have already seen how to use the FV (Future Value) function to calculate the future value of an investment with a constant or fixed interest rate, in a previous tutorial. This article will focus on using an Excel formula consisting of the FVSCHEDULE function. This function is used to calculate the future value of a payment, loan, or asset for changing interest rates. In real life, the varying interest rate is a pretty common occurrence with inflation and other causes. So this function is a handy one when it comes to calculating future values of a current asset in these scenarios.


Download Practice Workbook

You can download the workbook used for a demonstration from the link below.


Overview of FVSCHEDULE Formula

⏺ Function Objective

While the FV function is widely used to calculate future values in a payment or scheme, it only considers a fixed rate for both increases and decreases in values. However, what happens if the interest rate is variable or not fixed? In cases like these, in order to calculate the future value, we have to use the FVSCHEDULE Function.

Syntax

=FVSCHEDULE(principal,schedule)

⏺ Arguments Explanations

Argument Required/Optional Explanation
principal Required This is the present value.
schedule Required It is a series or array of differing interest rates to apply.

⏺ Returns

It returns the future values of the irregular payments.


How to Use FVSCHEDULE Formula in Excel

From the previous section, we can see that, we only need two arguments for formulas consisting of the FVSCHEDULE function in Excel. We just need the value of the present value of the payment and the interest rates as an array. Then we can use the function just like any other function in Excel.

Let’s take a look at the following example.

In this dataset, we have four changing interest rates for each year. For cases like these, we can use a formula consisting of the FVSCHEDULE function to determine the future value of the principal easily in Excel.

Follow these steps to see how we can do so for this dataset.

Steps:

  • First of all, select cell C9.
  • Then write down the following formula in the cell.

=FVSCHEDULE(C4,C5:C8)

using fvschedule excel formula for first dataset

  • After that, press Enter on your keyboard.

fvschedule excel formula first example result

That’s all you need to do to find the future value of a payment. Here, the value in cell C9 is the future value of the principal of $25000 with these interest rates.


2 Suitable Examples to Use FVSCHEDULE Formula in Excel

Now we will be showing two more practical cases of the usage of the formula consisting of the FVSCHEDULE function in Excel. We will be using different datasets for each one and a slightly different approach to using the same function.


1. Using FVSCHEDULE Formula with Cell References

In the first example, we are going to use the FVSCHEDULE function with cell references just like any formula used in Excel. For this example, we will be using the following dataset.

The appreciation in real estate indicates an increase in values. This works the same as an interest rate. This is a case where the increase isn’t fixed each year and a perfect example of the practicality of using functions like FVSCHEDULE.

Follow these steps to determine the future value of the property after three years with these appreciations.

Steps:

  • First, select cell C8.
  • Second, write down the following formula in the cell.

=FVSCHEDULE(C4,C5:C7)

fvschedule excel formula using cell reference

  • Finally, press Enter on your keyboard.

This is how we can use the formula consisting of the FVSCHEDULE function in Excel with cell references.


2. Applying FVSCHEDULE Formula with Array

Now we will use the same formula, but this time by manually entering the input values. For that, we need to use an array consisting of the interest/appreciation values as the schedule argument for the formula.

For example, let’s take a look at the following dataset.

The value for the second argument should be {0.04,0.035,0.02} for this dataset. Follow these steps for a detailed guide to the procedure.

Steps:

  • First, select cell C8.
  • Then write down the following formula in it.

=FVSCHEDULE(C4,{0.04,0.035,0.02})

fvschedule excel formula with array

  • Finally, press Enter on your keyboard.

fvschedule excel formula array result

This is how we can find the future value from varying interest rates using the formula of the FVSCHEDULE function in Excel using the array.


Things to Remember

👉 If you do not use the cell reference, make sure to put the values of the second argument in an array. Always put curly braces to start and end the array.

👉 All the values in the arguments of the function should be of numeric values. Otherwise, it will return an error.

👉 If there are any blank cells in the array, the function will work fine. As there was no value involved, it will work as though there was a zero on the spot.


Conclusion

That concludes the usage of the FVSCHEDULE function formula in Excel. Hopefully, you have grasped the idea of using the function and can use the function for your own purposes. I hope you found this guide helpful and informative. If you have any questions or suggestions, let us know in the comments below.

For more guides like this visit Exceldemy.com.

Taryn N

Taryn N

Taryn is a Microsoft Certified Professional, who has used Office Applications such as Excel and Access extensively, in her interdisciplinary academic career and work experience. She has a background in biochemistry, Geographical Information Systems (GIS), and biofuels. She enjoys showcasing the functionality of Excel in various disciplines. She has over ten years of experience using Excel and Access to create advanced integrated solutions.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo