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...")
 
 
(8 intermediate revisions by 3 users not shown)
Line 1: Line 1:
−
<div id="6SpaceContent" class="zcontent" align="left">
+
<div style="font-size:30px">'''FV (Rate,NoPaymentPeriods,Payment,PresentValue,Type)'''</div><br/>
  
−
'''FV'''(Rate, NoPaymentPeriods, Payments, PresentValue, Type)
+
Where
 +
*<math>Rate</math> is the rate of interest per period,  
 +
*<math>NoPaymentPeriods</math> is the total number of payment periods in an annuity,
 +
*<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.
 +
**FV() calculates the future value of an investment depending on payment periods, payment value and interest rate.
  
−
where,
+
== Description ==
  
−
'''Rate''' - is the interest rate per period.
+
FV(Rate, NoPaymentPeriods, Payments, PresentValue, Type)
  
−
'''NoPaymentPeriods''' - is the total number of payment periods
+
*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 -
 +
{| class="wikitable"
 +
|-
 +
! Type value !! Description
 +
|-
 +
| 0 || Payments due at the end of the period
 +
|-
 +
| 1 || Payments due at the beginning of the period
 +
|}
 +
*If <math>Type</math> 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).
  
−
'''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.
+
== Examples ==
  
−
'''PresentValue''' - the present value.If omitted assumed to be 0 and include Payments parameters.
+
Consider the following example that shows the use of FV function:
  
−
'''Type''' - is indicates payments due by number  0 or 1
+
<div id="2SpaceContent" class="zcontent" align="left">
  
−
'''TYPE          Payments due'''
+
{| id="TABLE3" class="SpreadSheet blue"
 +
|- class="even"
 +
| class=" " | 2%
 +
| class=" " | 4.5%
 +
| class=" " |
  
−
0              At the end of the period
+
|- class="odd"
 +
| class=" " | 11
 +
| class=" " | 5
 +
| class=" " |
  
−
1              At the beginning of the period
+
|- class="even"
 +
| class=" " | -50
 +
| class=" " | -45
 +
| class=" " |
  
−
</div>
+
|- class="odd"
−
----
+
| class=" " | -800
−
<div id="1SpaceContent" class="zcontent" align="left">
+
| class=" " | -1000
 +
| class=" " |
  
−
Calci returns the future value of an investment based on period, constant interest rate and constant payments.
+
|- class="even"
−
 
+
| class=" " | 1
−
</div>
+
| class=" " | 0
−
----
+
| class=" " |
−
<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
+
=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 '''10150.307304505215''' as a result.
  
−
</div></div>
+
==Related Videos==
−
----
 
−
<div id="8SpaceContent" class="zcontent" align="left">
 
  
−
Lets see an example in (Column1, Row6)
+
{{#ev:youtube|6OQKDsmr75I|280|center|FV}}
  
−
<nowiki>=FV(0.02/12,R2C1,R3C1,R4C1,R5C1)</nowiki>
+
== See Also ==
  
−
FV returns -259.258832.
+
*[[Manuals/calci/FVSCHEDULE | FVSCHEDULE]]
  
−
Consider an another example(Column1, Row2)
+
== References ==
  
−
<nowiki>=FV(0.02/12,5,-45,-1000,3)</nowiki>
+
*[http://http://en.wikipedia.org/wiki/Future_value Future Value]
  
−
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"
+
*[[Z_API_Functions | List of Main Z Functions]]
−
|- 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>
+
*[[ Z3 |  Z3 home ]]
−
----
 

Latest revision as of 04:27, 19 November 2020

FV (Rate,NoPaymentPeriods,Payment,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, NoPaymentPeriods, Payments, PresentValue, Type)

  • Argument is optional. If is omitted, should be included.
  • Argument is optional. 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 10150.307304505215 as a result.

Related Videos

FV

See Also

References


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