Difference between revisions of "Manuals/calci/FVSCHEDULE"
Jump to navigation
Jump to search
| Line 11: | Line 11: | ||
FVSCHEDULE(Principal, Schedule) | FVSCHEDULE(Principal, Schedule) | ||
| − | *Argument <math>Schedule</math> can be a numeric value. | + | *Argument <math>Schedule</math> can be a numeric value or empty cell. For non-numeric values, Calci displays NaN error message. |
| − | *Blank cells in | + | *Blank cells in the array of <math>Schedule</math> argument are considered to be zero (0). |
== Examples == | == Examples == | ||
Revision as of 14:37, 27 February 2014
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() calculates 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: