Difference between revisions of "Manuals/calci/FVIFA"
Jump to navigation
Jump to search
| Line 18: | Line 18: | ||
1. =FVIFA(4%/12,6) : Calculates the future value interest rate in annuity where annual interest rate is compounded monthly. <br/> Displays '''6.050222778519099''' as a result. | 1. =FVIFA(4%/12,6) : Calculates the future value interest rate in annuity where annual interest rate is compounded monthly. <br/> Displays '''6.050222778519099''' as a result. | ||
| − | 2. =FVIFA(5%,20) : Calculates the future value interest rate in annuity <br/>. Displays '''33. | + | 2. =FVIFA(5%,20) : Calculates the future value interest rate in annuity <br/>. Displays '''33.06595410288845''' as a result. |
==Related Videos== | ==Related Videos== | ||
Revision as of 13:47, 23 March 2018
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.050222778519099 as a result.
2. =FVIFA(5%,20) : Calculates the future value interest rate in annuity
. Displays 33.06595410288845 as a result.
Related Videos
See Also
References