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