writer
2,661
edits
Changes
Jump to navigation
Jump to search
Created page with "=FV(Rate, PaymentPeriods)= Where *<math>Rate</math> is the rate of interest per period, *<math>PaymentPeriods</math> is the total number of payment periods in an annuity, ..."
=FV(Rate, PaymentPeriods)=
Where
*<math>Rate</math> is the rate of interest per period,
*<math>PaymentPeriods</math> is the total number of payment periods in an annuity,
FVIFA() calculates the future value interest factor of annuity depending on payment periods, and interest rate.
== Description ==
FV(Rate, PaymentPeriods)
*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 ==
1. =FVIFA(4%/12,6) : Calculates the future value interest rate in annuity where annual interest rate is compounded monthly. <br/> Displays '''$6.63''' as a result.
2. =FVIFA(5%,20) : Calculates the future value interest rate in annuity <br/>. Displays '''$33.07''' as a result.
==Related Videos==
{{#ev:youtube|6OQKDsmr75I|280|center|FV}}
== See Also ==
*[[Manuals/calci/FV | FV]]
*[[Manuals/calci/FVIF | FVIF]]
*[[Manuals/calci/FVSCHEDULE | FVSCHEDULE]]
== References ==
*[http://http://en.wikipedia.org/wiki/Future_value Future Value]
*[[Z_API_Functions | List of Main Z Functions]]
*[[ Z3 | Z3 home ]]
Where
*<math>Rate</math> is the rate of interest per period,
*<math>PaymentPeriods</math> is the total number of payment periods in an annuity,
FVIFA() calculates the future value interest factor of annuity depending on payment periods, and interest rate.
== Description ==
FV(Rate, PaymentPeriods)
*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 ==
1. =FVIFA(4%/12,6) : Calculates the future value interest rate in annuity where annual interest rate is compounded monthly. <br/> Displays '''$6.63''' as a result.
2. =FVIFA(5%,20) : Calculates the future value interest rate in annuity <br/>. Displays '''$33.07''' as a result.
==Related Videos==
{{#ev:youtube|6OQKDsmr75I|280|center|FV}}
== See Also ==
*[[Manuals/calci/FV | FV]]
*[[Manuals/calci/FVIF | FVIF]]
*[[Manuals/calci/FVSCHEDULE | FVSCHEDULE]]
== References ==
*[http://http://en.wikipedia.org/wiki/Future_value Future Value]
*[[Z_API_Functions | List of Main Z Functions]]
*[[ Z3 | Z3 home ]]