The FVSCHEDULE function returns the future value of an initial principal after applying a series of compound interest rates.

FVSCHEDULE takes 2 required arguments and no optional arguments:

Syntax: FVSCHEDULE(principal, schedule)

#1)
Using the FVSCHEDULE function:
#2)
The arguments for the FVSCHEDULE function are:
Argument Required? Description
principal Required The present value.
schedule Required An array of interest rates to apply.
#3)
One more thing:
The values in schedule can be numbers or blank cells; any other value produces the #VALUE! error value for FVSCHEDULE. Blank cells are taken as zeros (no interest).

Summary

The FVSCHEDULE function returns the future value of an initial principal after applying a series of compound interest rates.
comments powered by Disqus