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, ...") |
|||
| Line 16: | Line 16: | ||
== Examples == | == Examples == | ||
| − | 1. =FVIFA(4%/12,6) : Calculates the future value interest rate in annuity where annual interest rate is compounded monthly. <br/> Displays ''' | + | 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.07''' as a result. | ||
==Related Videos== | ==Related Videos== | ||
Revision as of 04:57, 1 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.07 as a result.
Related Videos
See Also
References