Please note javascript is required for full website functionality.

# A to Z of Excel Functions: the FVSCHEDULE Function

18 November 2019

Welcome back to our regular A to Z of Excel Functions blog.  Today we look at the FVSCHEDULE function.

The FVSCHEDULE function

If you have ever been involved calculating financials, you will appreciate interest is a fundamental aspect.  Sometimes, interest rates vary and you want to calculate what the amount, including interest, will be worth at a later point in time.

Perhaps the easiest way to think of it is as follows:

• An original amount of \$100 this year will increase by 5% next year, i.e. be valued at \$105
• That amount of \$105 will increase by 10% over the following year, i.e. be valued at \$115.50
• That amount of \$115.50 will increase by 20% in the third year, i.e. be valued at \$138.60. etc.

Note that all of these valuations are for a point of time not a period.  This is a common mistake in modelling.

The FVSCHEDULE function calculates the future value of an investment based on variable compound interest rates and employs the following syntax to operate:

FVSCHEDULE(principal, schedule)

The FVSCHEDULE function has the following arguments:

• principal: this is required and represents the present value
• schedule: this is also required.  This represents an array of interest rates to apply.

The values in schedule can be numbers or blank cells (treated as 0%) if in cell ranges; cited explicitly, the values must be decimals (percentages and blanks will not work).  Any other value produces the #VALUE! error value for FVSCHEDULE.  Each period is assumed to be of equal length and the interest rate is quoted for the period in question (e.g. 3% per quarter if in quarters).