Manuals/calci/FVIFA
FV(Rate, PaymentPeriods)
Where
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Rate} is the rate of interest per period,
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle PaymentPeriods} 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.050222778519099 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