Financial - FVSCHEDULE Function
Advertisements
Description
The FVSCHEDULE function returns the future value of an initial principal after applying a series of compound interest rates. Use FVSCHEDULE to calculate the future value of an investment with a variable or adjustable rate.
Syntax
FVSCHEDULE (principal, schedule)
Arguments
Argument | Description | Required/ Optional |
---|---|---|
Principal | The present value. | Required |
Schedule | An array of interest rates to apply. | Required |
Notes
The values in schedule can be numbers or blank cells. Any other value produces the #VALUE! error value.
Blank cells are taken as zeros (no interest).
Applicability
Excel 2007, Excel 2010, Excel 2013, Excel 2016
Example
advanced_excel_financial_functions.htm
Advertisements