Manuals/calci/FVSCHEDULE
Jump to navigation
Jump to search
FVSCHEDULE(Principal, Schedule)
where,
Principal - reprenets the present value.
Schedule - an array of interest rates to apply.
Calci returns the future value of an initial principal after applying a series of compound interest rates
The values in Schedule either number or blank cells, any other value returns NaN.
FVSCHEDULE
Lets see an example in (Column1, Row5)
=FVSCHEDULE(R1C1, R1C2:R1C4)
FVSCHEDULE returns 9.4536.
Consider another example (Column1, Row4)
=FVSCHEDULE(12,[0.5,1,"FDJHJ"])
It returns NaN.
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 2 | |||
| Row2 | 0.01 | |||
| Row3 | 2 | |||
| Row4 | 0.56 | |||
| Row5 | 9.4536 | |||
| Row6 |
