Manuals/calci/FVSCHEDULE - Revision history

Devika: /* Related Videos */

2018-11-15T20:55:22Z

2018-08-22T22:17:26Z

2018-06-29T22:11:00Z

2018-06-29T22:09:39Z

2017-03-14T10:51:23Z

2015-07-19T18:06:26Z

2014-05-01T15:19:47Z

2014-05-01T15:18:53Z

Examples

2014-02-27T19:37:00Z

2014-02-27T19:34:04Z

@@ Line 46: / Line 46: @@
 ==Related Videos==
-{{#ev:youtube|ahtplz1FEMs|280|center|FVSCHEDULE}}
+{{#ev:youtube|v=25xfoe1Mi-Y|280|center|FVSCHEDULE}}
 == See Also ==

@@ Line 3: / Line 3: @@
 *<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.
 == Description ==

@@ Line 1: / Line 1: @@
-=FVSCHEDULE(Principal, Schedule)=
+<div style="font-size:30px">'''FVSCHEDULE(Principal, Schedule)'''</div><br/>
 Where
 *<math>Principal</math> represents the present value, and

@@ Line 5: / Line 5: @@
 *<math>Schedule</math> 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.
+FVSCHEDULE() returns the future value of an initial principal after applying a series of compound interest rates.
 == Description ==

← Older revision		Revision as of 10:51, 14 March 2017
Line 57:		Line 57:

	*[http://http://en.wikipedia.org/wiki/Future_value Future Value]		*[http://http://en.wikipedia.org/wiki/Future_value Future Value]
		+
		+
		+
		+	*[[Z_API_Functions \| List of Main Z Functions]]
		+
		+	*[[ Z3 \| Z3 home ]]

@@ Line 45: / Line 45: @@
   =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.
 == See Also ==

@@ Line 22: / Line 22: @@
 {| id="TABLE3" class="SpreadSheet blue"
 |- class="even"
-| class=" " |
+| class=" " | 2
-| class=" " |
+| class=" " | 0.01
 | class=" " |
 |- class="odd"
 | class=" " |
-| class=" " |
+| class=" " | 0.56
 | class=" " |
 |- class="even"
 | class=" " |
-| class=" " |
+| class=" " | 0.02
 | class=" " |
@@ Line 41: / Line 41: @@
 | class=" " |
 |}
-<font color ="Red">Need to add examples after next release</font>
+ =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.
 == See Also ==

@@ Line 11: / Line 11: @@
 FVSCHEDULE(Principal, Schedule)
-*Argument <math>Schedule</math> can be a numeric value. Else Calci displays NaN error message.
+*Argument <math>Schedule</math> can be a numeric value or empty cell. For non-numeric values, Calci displays NaN error message.
-*Blank cells in between the Schedule array are considered to be zero (0).
+*Blank cells in the array of <math>Schedule</math> argument are considered to be zero (0).
 == Examples ==