Difference between revisions of "Manuals/calci/FVSCHEDULE"
Jump to navigation
Jump to search
| Line 5: | Line 5: | ||
*<math>Schedule</math> represents the array of interest rates to apply. | *<math>Schedule</math> represents the array of interest rates to apply. | ||
| − | FVSCHEDULE() | + | FVSCHEDULE() returns the future value of an initial principal after applying a series of compound interest rates. |
== Description == | == Description == | ||
Revision as of 16:09, 29 June 2018
FVSCHEDULE(Principal, Schedule)
Where
- represents the present value, and
- represents the array of interest rates to apply.
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
See Also
References