Manuals/calci/FV - Revision history

Devika: /* Examples */

2020-11-19T09:27:33Z

Examples

Devika: /* Examples */

2020-11-19T09:26:46Z

Examples

Devika at 22:15, 22 August 2018

2018-08-22T22:15:22Z

Devika at 22:19, 23 July 2018

2018-07-23T22:19:50Z

Devika at 22:19, 23 July 2018

2018-07-23T22:19:13Z

Jayaram at 10:50, 14 March 2017

2017-03-14T10:50:38Z

Swapna at 18:05, 19 July 2015

2015-07-19T18:05:17Z

Swapna at 21:35, 26 February 2014

2014-02-26T21:35:57Z

Swapna at 21:30, 26 February 2014

2014-02-26T21:30:59Z

MassBot1: Created page with "
'''FV'''(Rate, NoPaymentPeriods, Payments, PresentValue, Type) where, '''Rate''' - is the interest rate per pe..."

2013-10-25T02:36:05Z

Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''FV'''(Rate, NoPaymentPeriods, Payments, PresentValue, Type) where, '''Rate''' - is the interest rate per pe..."

New page

<div id="6SpaceContent" class="zcontent" align="left">

'''FV'''(Rate, NoPaymentPeriods, Payments, PresentValue, Type)

where,

'''Rate''' - is the interest rate per period.

'''NoPaymentPeriods''' - is the total number of payment periods

'''Payments''' - the payment made each period, it not change over the life of the annnuity.Payment contains principal and interest but except other fees and taxes.If omitted, include PresentValue parameters.

'''PresentValue''' - the present value.If omitted assumed to be 0 and include Payments parameters.

'''Type''' - is indicates payments due by number 0 or 1

'''TYPE          Payments due'''

0              At the end of the period

1              At the beginning of the period

</div>
----
<div id="1SpaceContent" class="zcontent" align="left">

Calci returns the future value of an investment based on period, constant interest rate and constant payments.

</div>
----
<div id="7SpaceContent" class="zcontent" align="left">

The annual interest rate is divided by 12 beacuse it is compounded montly.

</div>
----
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">

FV

</div></div>
----
<div id="8SpaceContent" class="zcontent" align="left">

Lets see an example in (Column1, Row6)

<nowiki>=FV(0.02/12,R2C1,R3C1,R4C1,R5C1)</nowiki>

FV returns -259.258832.

Consider an another example(Column1, Row2)

<nowiki>=FV(0.02/12,5,-45,-1000,3)</nowiki>

FV returns #ERROR(Type other than 0 or 1).

</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"
|- class="even"
| class=" " |
| Column1
| class=" " | Column2
| Column3
| Column4
|- class="odd"
| class=" " | Row1
| class="sshl_f" | 2%
| class=" " |
| class=" " |
| class=" " |
|- class="even"
| class=" " | Row2
| class=" " | 11
| class=" " |
| class=" " |
| class=" " |
|- class="odd"
| Row3
| class=" " | -50
| class=" " |
| class=" " |
| class=" " |
|- class="even"
| Row4
| class=" " | 800
| class=" " |
| class=" " |
| class=" " |
|- class="odd"
| class=" " | Row5
| class="sshl_f " | 1
| class=" " |
| class=" " |
| class=" " |
|- class="even"
| Row6
| class="sshl_f SelectTD SelectTD ChangeBGColor" | -259.258832
| class=" " |
| class=" " |
| class=" " |
|}

<div align="left">[[Image:calci1.gif]]</div></div>
----

@@ Line 62: / Line 62: @@
   =FV(A1/12,A2,A3,A4,A5) : Calculates the future value for the values in the range A1 to A5. <br />Annual interest rate is compounded monthly. Displays '''1370.3201724868504''' as a result.
   =FV(B1/12,B2,B3,B4,B5) : Calculates the future value for the values in the range B1 to B5. <br />Annual interest rate is compounded monthly. Displays '''1245.5849933323898''' as a result.
-  =FV(0.04/12,10,-1000,1) : Annual interest rate is compounded monthly and PresentValue is omitted. <br />Displays '''10185.178946116719''' as a result.
+  =FV(0.04/12,10,-1000,1) : Annual interest rate is compounded monthly and PresentValue is omitted. <br />Displays '''10150.307304505215''' as a result.
 ==Related Videos==

@@ Line 62: / Line 62: @@
   =FV(A1/12,A2,A3,A4,A5) : Calculates the future value for the values in the range A1 to A5. <br />Annual interest rate is compounded monthly. Displays '''1370.3201724868504''' as a result.
   =FV(B1/12,B2,B3,B4,B5) : Calculates the future value for the values in the range B1 to B5. <br />Annual interest rate is compounded monthly. Displays '''1245.5849933323898''' as a result.
-  =FV(0.04/12,10,-1000,,1) : Annual interest rate is compounded monthly and PresentValue is omitted. <br />Displays '''10185.178946116719''' as a result.
+  =FV(0.04/12,10,-1000,1) : Annual interest rate is compounded monthly and PresentValue is omitted. <br />Displays '''10185.178946116719''' as a result.
 ==Related Videos==

@@ Line 7: / Line 7: @@
 *<math>PresentValue</math> is the present value, and
 *<math>Type</math> is value 0 or 1 indicating when the payments are due.
+**FV() calculates the future value of an investment depending on payment periods, payment value and interest rate.
 == Description ==

@@ Line 1: / Line 1: @@
 <div style="font-size:30px">'''FV (Rate,NoPaymentPeriods,Payment,PresentValue,Type)'''</div><br/>
@@ Line 15: / Line 14: @@
 FV(Rate, NoPaymentPeriods, Payments, PresentValue, Type)
-*Argument <math>Payments</math> is optional. If <math>Payments</math> is omitted, <math>PresentValue</math> should be included.
+*Argument <math>Payment</math> is optional. If <math>Payment</math> is omitted, <math>PresentValue</math> should be included.
 *Argument <math>PresentValue</math> is optional. If <math>PresentValue</math> is omitted, it is assumed to be zero(0) and argument <math>Payments</math> should be included.
 *Argument <math>Type</math> can be 0 or 1. Below table indicates the selection of type value -

@@ Line 1: / Line 1: @@
 =FV(Rate, PaymentPeriods, Payments, PresentValue, Type)=
 Where
 *<math>Rate</math> is the rate of interest per period,
-*<math>PaymentPeriods</math> is the total number of payment periods in an annuity,
+*<math>NoPaymentPeriods</math> is the total number of payment periods in an annuity,
-*<math>Payments</math> is the payment value for each period,
+*<math>Payment</math> is the payment value for each period,
 *<math>PresentValue</math> is the present value, and
 *<math>Type</math> is value 0 or 1 indicating when the payments are due.
@@ Line 12: / Line 13: @@
 == Description ==
-FV(Rate, PaymentPeriods, Payments, PresentValue, Type)
+FV(Rate, NoPaymentPeriods, Payments, PresentValue, Type)
 *Argument <math>Payments</math> is optional. If <math>Payments</math> is omitted, <math>PresentValue</math> should be included.

← Older revision		Revision as of 10:50, 14 March 2017
Line 76:		Line 76:

	*[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 1: / Line 1: @@
-<div id="6SpaceContent" class="zcontent" align="left">
+=FV(Rate, PaymentPeriods, Payments, PresentValue, Type)=
-'''FV'''(Rate, NoPaymentPeriods, Payments, PresentValue, Type)
+Where
-where,
+FV() calculates the future value of an investment depending on Payment periods, payment value and interest rate.
-'''Rate''' - is the interest rate per period.
+== Description ==
-'''NoPaymentPeriods''' - is the total number of payment periods
+FV(Rate, PaymentPeriods, Payments, PresentValue, Type)
-'''Payments''' - the payment made each period, it not change over the life of the annnuity.Payment contains principal and interest but except other fees and taxes.If omitted, include PresentValue parameters.
+*Argument <math>Payments</math> is optional. But if <math>Payments</math> is omitted, <math>PresentValue</math> should be included.
+*Argument <math>PresentValue</math> is optional. But if <math>PresentValue</math> is omitted, it is assumed to be zero(0) and argument <math>Payments</math> should be included.
-'''PresentValue''' - the present value.If omitted assumed to be 0 and include Payments parameters.
+*Argument <math>Type</math> can be 0 or 1. Below table indicates the selection of type value -
+{| class="wikitable"
-'''Type''' - is indicates payments due by number  0 or 1
+|-
+! Type value !! Description
-'''TYPE          Payments due'''
+|-
+| 0 || Payments due at the end of the period
-              At the end of the period
+|-
+| 1 || Payments due at the beginning of the period
-              At the beginning of the period
+|}
+*If <math>Type</math> is other than 0 or 1, Calci displays #N/A error message.
-</div>
+*For monthly payment, Rate should be divided by 12 (e.g. 10%/12) and PaymentPeroid should be multiplied by 12 (e.g. 4*12).
-FV returns -259.258832.
+== Examples ==
-Consider an another example(Column1, Row2)
+Consider the following example that shows the use of FV function:
 <div id="2SpaceContent" class="zcontent" align="left">
 {| id="TABLE3" class="SpreadSheet blue"
 |- class="even"
 | class=" " |
-| Column1
 |- class="odd"
-| class=" " | Row1
+| class=" " | 11
-| class="sshl_f" | 2%
+| class=" " | 5
 | class=" " |
 |- class="even"
 | class=" " | -50
 | class=" " |
-| class=" " |
 |- class="odd"
-| class=" " | Row5
+| class=" " | -800
-| class="sshl_f " | 1
+| class=" " | -1000
 | class=" " |
 |- class="even"
-| Row6
+| class=" " | 1
-| class="sshl_f     SelectTD  SelectTD ChangeBGColor" | -259.258832
+| class=" " | 0
 | class=" " |
 |}
-<div align="left">[[Image:calci1.gif]]</div></div>
+ =FV(A1/12,A2,A3,A4,A5) : Calculates the future value for the values in the range A1 to A5. Annual interest rate is compounded monthly. <br />Displays '''1370.3201724868504''' as a result.
-----
+ =FV(B1/12,B2,B3,B4,B5) : Calculates the future value for the values in the range B1 to B5. Annual interest rate is compounded monthly. <br />Displays '''1245.5849933323898''' as a result.

Manuals/calci/FV - Revision history

Devika: /* Examples */

Devika: /* Examples */

Devika at 22:15, 22 August 2018

Devika at 22:19, 23 July 2018

Devika at 22:19, 23 July 2018

Jayaram at 10:50, 14 March 2017

Swapna at 18:05, 19 July 2015

Swapna at 21:35, 26 February 2014

Swapna at 21:30, 26 February 2014

MassBot1: Created page with " '''FV'''(Rate, NoPaymentPeriods, Payments, PresentValue, Type) where, '''Rate''' - is the interest rate per pe..."

MassBot1: Created page with "
'''FV'''(Rate, NoPaymentPeriods, Payments, PresentValue, Type) where, '''Rate''' - is the interest rate per pe..."