Difference between revisions of "Manuals/calci/FVIFA"
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, ...") |
(No difference)
|
Revision as of 06:31, 14 March 2017
FV(Rate, PaymentPeriods)
Where
- is the rate of interest per period,
- is the total number of payment periods in an annuity,
is the rate of interest per period,
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.
Displays $6.63 as a result.
2. =FVIFA(5%,20) : Calculates the future value interest rate in annuity
. Displays $33.07 as a result.
Related Videos
See Also
References