Manuals/calci/FVSCHEDULE

From ZCubes Wiki

Revision as of 09:18, 1 May 2014 by Swapna (talk | contribs) (→‎Examples)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Jump to navigation Jump to search

FVSCHEDULE(Principal, Schedule)

Where

$Principal$ represents the present value, and
$Schedule$ represents the array of interest rates to apply.

FVSCHEDULE() calculates the future value of an initial principal after applying a series of compound interest rates.

Description

FVSCHEDULE(Principal, Schedule)

Argument $Schedule$ can be a numeric value or empty cell. For non-numeric values, Calci displays NaN error message.
Blank cells in the array of $Schedule$ 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.

See Also

FV

References

Future Value

Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/FVSCHEDULE&oldid=198772"