Difference between revisions of "Manuals/calci/FV"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''FV'''(Rate, NoPaymentPeriods, Payments, PresentValue, Type) where, '''Rate''' - is the interest rate per pe...")
 
Line 1: Line 1:
−
<div id="6SpaceContent" class="zcontent" align="left">
+
=FV(Rate, PaymentPeriods, Payments, PresentValue, Type)=
  
−
'''FV'''(Rate, NoPaymentPeriods, 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>Payments</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.
  
−
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
−
0              At the end of the period
+
|-
−
 
+
| 1 || Payments due at the beginning of the period  
−
1              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).
−
----
 
−
<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.
+
== Examples ==
  
−
Consider an another example(Column1, Row2)
+
Consider the following example that shows the use of FV function:
  
−
<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">
 
<div id="2SpaceContent" class="zcontent" align="left">
  
 
{| id="TABLE3" class="SpreadSheet blue"
 
{| id="TABLE3" class="SpreadSheet blue"
 
|- class="even"
 
|- class="even"
 +
| class=" " | 2%
 +
| class=" " | 4.5%
 
| class=" " |
 
| class=" " |
−
| Column1
+
 
−
| class="  " | Column2
 
−
| Column3
 
−
| Column4
 
 
|- class="odd"
 
|- class="odd"
−
| class=" " | Row1
+
| class=" " | 11
−
| class="sshl_f" | 2%
+
| class=" " | 5
−
| class=" " |
 
−
| class=" " |
 
 
| class=" " |
 
| class=" " |
 +
 
|- class="even"
 
|- class="even"
−
| class="  " | Row2
 
−
| class=" " | 11
 
−
| class=" " |
 
−
| class=" " |
 
−
| class=" " |
 
−
|- class="odd"
 
−
| Row3
 
 
| class=" " | -50
 
| class=" " | -50
 +
| class=" " | -45
 
| class=" " |
 
| class=" " |
−
| class=" " |
+
 
−
| class=" " |
 
−
|- class="even"
 
−
| Row4
 
−
| class=" " | 800
 
−
| class=" " |
 
−
| class=" " |
 
−
| class=" " |
 
 
|- class="odd"
 
|- class="odd"
−
| class=" " | Row5
+
| class=" " | -800
−
| class="sshl_f " | 1
+
| class=" " | -1000
−
| class=" " |
 
−
| class=" " |
 
 
| class=" " |
 
| class=" " |
 +
 
|- class="even"
 
|- class="even"
−
| Row6
+
| class=" " | 1
−
| class="sshl_f    SelectTD  SelectTD ChangeBGColor" | -259.258832
+
| class=" " | 0
−
| class=" " |
 
−
| class=" " |
 
 
| class=" " |
 
| 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.
 +
=FV(0.04/12,10,-1000,,1) : Annual interest rate is compounded monthly and PresentValue is omitted. <br />Displays '''10185.178946116719''' as a result.
 +
 
 +
== See Also ==
 +
 
 +
*[[Manuals/calci/FVSCHEDULE | FVSCHEDULE]]
 +
 
 +
== References ==
 +
 
 +
*[http://http://en.wikipedia.org/wiki/Future_value Future Value]

Revision as of 15:30, 26 February 2014

FV(Rate, PaymentPeriods, Payments, PresentValue, Type)

Where

  • is the rate of interest per period,
  • is the total number of payment periods in an annuity,
  • is the payment value for each period,
  • is the present value, and
  • 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

FV(Rate, PaymentPeriods, Payments, PresentValue, Type)

  • Argument is optional. But if is omitted, should be included.
  • Argument is optional. But if is omitted, it is assumed to be zero(0) and argument should be included.
  • Argument can be 0 or 1. Below table indicates the selection of type value -
Type value Description
0 Payments due at the end of the period
1 Payments due at the beginning of the period
  • If is other than 0 or 1, Calci displays #N/A error message.
  • For monthly payment, Rate should be divided by 12 (e.g. 10%/12) and PaymentPeroid should be multiplied by 12 (e.g. 4*12).

Examples

Consider the following example that shows the use of FV function:

2% 4.5%
11 5
-50 -45
-800 -1000
1 0 
=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. 
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. 
Displays 1245.5849933323898 as a result.
=FV(0.04/12,10,-1000,,1) : Annual interest rate is compounded monthly and PresentValue is omitted. 
Displays 10185.178946116719 as a result.

See Also

References

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