Manuals/calci/FVSCHEDULE
Jump to navigation
Jump to search
FVSCHEDULE(Principal, Schedule)
Where
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Principal} represents the present value, and
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Schedule}
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 Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Schedule} can be a numeric value or empty cell. For non-numeric values, Calci displays NaN error message.
- Blank cells in the array of Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle 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.
Related Videos
See Also
References