Difference between revisions of "Manuals/calci/FVSCHEDULE"
Jump to navigation
Jump to search
| Line 22: | Line 22: | ||
{| id="TABLE3" class="SpreadSheet blue" | {| id="TABLE3" class="SpreadSheet blue" | ||
|- class="even" | |- class="even" | ||
| − | | class=" " | | + | | class=" " | 2 |
| − | | class=" " | | + | | class=" " | 0.01 |
| class=" " | | | class=" " | | ||
|- class="odd" | |- class="odd" | ||
| class=" " | | | class=" " | | ||
| − | | class=" " | | + | | class=" " | 0.56 |
| class=" " | | | class=" " | | ||
|- class="even" | |- class="even" | ||
| class=" " | | | class=" " | | ||
| − | | class=" " | | + | | class=" " | 0.02 |
| class=" " | | | class=" " | | ||
| Line 41: | Line 41: | ||
| class=" " | | | class=" " | | ||
| − | |||
| − | |||
| − | |||
| − | |||
|} | |} | ||
| − | < | + | =FVSCHEDULE(A1,[B1,B2,B3]) : Calculates the future value with Principal in cell A1 and array of interests from cells B1 to B3. <br />Returns '''3.214224''' as a result. |
| + | =FVSCHEDULE(1,[0.08,0.12]) : Calculates the future value with the mentioned argument values. <br />Returns '''1.2096000000000002''' as a result. | ||
== See Also == | == See Also == | ||
Revision as of 10:18, 1 May 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:
| 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.