Difference between revisions of "Manuals/calci/FV"

 
(6 intermediate revisions by 3 users not shown)
Line 1: Line 1:
=FV(Rate, PaymentPeriods, Payments, PresentValue, Type)=
+
<div style="font-size:30px">'''FV (Rate,NoPaymentPeriods,Payment,PresentValue,Type)'''</div><br/>
  
 
Where  
 
Where  
 
*<math>Rate</math> is the rate of interest per period,  
 
*<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>PresentValue</math> is the present value, and
 
*<math>Type</math> is value 0 or 1 indicating when the payments are due.
 
*<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.
FV() calculates the future value of an investment depending on payment periods, payment value and interest rate.
 
  
 
== Description ==
 
== 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.
+
*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>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 -
 
*Argument <math>Type</math> can be 0 or 1. Below table indicates the selection of type value -
Line 63: 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(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(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==
 +
 
 +
{{#ev:youtube|6OQKDsmr75I|280|center|FV}}
  
 
== See Also ==
 
== See Also ==
Line 72: Line 75:
  
 
*[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 ]]

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