Difference between revisions of "Manuals/calci/FVSCHEDULE"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''FVSCHEDULE'''(Principal, Schedule) where, '''Principal''' - reprenets the present value. '''Schedule''' ...")
 
 
(9 intermediate revisions by 3 users not shown)
Line 1: Line 1:
−
<div id="6SpaceContent" class="zcontent" align="left">
+
<div style="font-size:30px">'''FVSCHEDULE(Principal, Schedule)'''</div><br/>
 +
Where
 +
*<math>Principal</math> represents the present value, and
 +
*<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'''(Principal, Schedule)
+
== Description ==
  
−
where,
+
FVSCHEDULE(Principal, Schedule)
  
−
'''Principal''' - reprenets the present 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 the array of <math>Schedule</math> argument are considered to be zero (0).
  
−
'''Schedule''' - an array of interest rates to apply.
+
== Examples ==
  
−
</div>
+
Consider the following example that shows the use of FVSCHEDULE function:
−
----
 
−
<div id="1SpaceContent" class="zcontent" align="left">
 
  
−
Calci returns the future value of an initial principal after applying a series of compound interest rates
+
<div id="2SpaceContent" class="zcontent" align="left">
 +
 
 +
{| id="TABLE3" class="SpreadSheet blue"
 +
|- class="even"
 +
| class=" " | 2
 +
| class=" " | 0.01
 +
| class=" " |
  
−
</div>
+
|- class="odd"
−
----
+
| class=" " |
−
<div id="7SpaceContent" class="zcontent" align="left">The values in Schedule either number or blank cells, any other value returns NaN.</div>
+
| class=" " | 0.56
−
----
+
| class=" " |
−
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
+
 
 +
|- class="even"
 +
| class=" " |
 +
| class=" " | 0.02
 +
| class=" " |
 +
 
 +
|- class="odd"
 +
| class=" " |
 +
| class=" " |
 +
| class=" " |
  
−
FVSCHEDULE
+
|}
  
−
<font size="6"></font>
+
=FVSCHEDULE(A1,[B1,B2,B3]) : Calculates the future value with Principal in cell A1 and <br />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. <br />Returns '''1.2096000000000002''' as a result.
  
−
</div></div>
+
==Related Videos==
−
----
 
−
<div id="8SpaceContent" class="zcontent" align="left">
 
  
−
Lets see an example in (Column1, Row5)
+
{{#ev:youtube|v=25xfoe1Mi-Y|280|center|FVSCHEDULE}}
  
−
<nowiki>=FVSCHEDULE(R1C1, R1C2:R1C4)</nowiki>
+
== See Also ==
  
−
FVSCHEDULE returns 9.4536.
+
*[[Manuals/calci/FV | FV]]
  
−
Consider another example (Column1, Row4)
+
== References ==
  
−
<nowiki>=FVSCHEDULE(12,[0.5,1,"FDJHJ"])</nowiki>
+
*[http://http://en.wikipedia.org/wiki/Future_value Future Value]
  
−
It returns NaN.
 
  
−
</div>
 
−
----
 
−
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
 
−
----
 
−
<div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div>
 
−
----
 
−
<div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div>
 
−
----
 
−
<div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div>
 
−
----
 
−
<div id="2SpaceContent" class="zcontent" align="left">
 
  
−
{| id="TABLE3" class="SpreadSheet blue"
+
*[[Z_API_Functions | List of Main Z Functions]]
−
|- class="even"
 
−
| class=" " |
 
−
| Column1
 
−
| Column2
 
−
| Column3
 
−
| Column4
 
−
|- class="odd"
 
−
| class=" " | Row1
 
−
| class=" " | 2
 
−
|
 
−
|
 
−
|
 
−
|- class="even"
 
−
| class="  " | Row2
 
−
| class="          sshl_f " | 0.01
 
−
|
 
−
|
 
−
|
 
−
|- class="odd"
 
−
| Row3
 
−
| class=" " | 2
 
−
|
 
−
|
 
−
|
 
−
|- class="even"
 
−
| Row4
 
−
| class=" " | 0.56
 
−
|
 
−
|
 
−
|
 
−
|- class="odd"
 
−
| class=" " | Row5
 
−
| class="sshl_f" | 9.4536
 
−
|
 
−
|
 
−
|
 
−
|- class="even"
 
−
| Row6
 
−
| class="  SelectTD ChangeBGColor SelectTD" |
 
−
<div id="2Space_Handle" class="zhandles" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" class="zhandles" title="Click and Drag over to AutoFill other cells."></div><div id="2Space_Drag" class="zhandles" title="Click and Drag to Move/Copy Area.">[[Image:copy-cube.gif]]  </div>
 
−
|
 
−
|
 
−
|
 
−
|}
 
  
−
<div align="left">[[Image:calci1.gif]]</div></div>
+
*[[ Z3 |  Z3 home ]]
−
----
 

Latest revision as of 15:55, 15 November 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.

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

FVSCHEDULE

See Also

References


Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/FVSCHEDULE&oldid=211341"