|
FVSCHEDULE |
  
|
|
FVSCHEDULE |
|
This function returns the future value of an initial principal after applying a series of compound interest rates. Calculate future value of an investment with a variable or adjustable rate.
Syntax
FVSCHEDULE(principal,schedule)
Arguments
This function has these arguments:
Argument |
Description |
principal |
Present value of the principal |
schedule |
Schedule, array of interest rates to apply |
Data Types
Accepts numeric data for both arguments. Returns numeric data.
Examples
FVSCHEDULE(4,A1:C1)
FVSCHEDULE(45,R1C1:R7C1)
FVSCHEDULE(1000,{0.8,0.6,0.7}) gives the result 4896
See Also