Manuals/calci/FVSCHEDULE

From ZCubes Wiki
Jump to navigation Jump to search
FVSCHEDULE(Principal, Schedule)


Where

  • represents the present value, and
  • represents the array of interest rates to apply.
    • FVSCHEDULE() returns the future value of an initial principal after applying a series of compound interest rates.

Description

FVSCHEDULE(Principal, Schedule)

  • Argument can be a numeric value or empty cell. For non-numeric values, Calci displays NaN error message.
  • Blank cells in the array of argument are considered to be zero (0).

Examples

Consider the following example that shows the use of FVSCHEDULE function:

2 0.01
0.56
0.02
=FVSCHEDULE(A1,[B1,B2,B3]) : Calculates the future value with Principal in cell A1 and 
array of interests from cells B1 to B3. Returns 3.214224 as a result. =FVSCHEDULE(1,[0.08,0.12]) : Calculates the future value with the mentioned argument values.
Returns 1.2096000000000002 as a result.

Related Videos

FVSCHEDULE

See Also

References