Difference between revisions of "Manuals/calci/FVIFA"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
| − | = | + | <div style="font-size:30px">'''FVIFA (Rate,NumberOfPayments)'''</div><br/> |
| − | |||
Where | Where | ||
*<math>Rate</math> is the rate of interest per period, | *<math>Rate</math> is the rate of interest per period, | ||
| − | *<math> | + | *<math>NumberOfPayments</math> is the total number of payment periods in an annuity, |
| Line 10: | Line 9: | ||
== Description == | == Description == | ||
| − | + | FVIFA (Rate,NumberOfPayments) | |
*For monthly payment, Rate should be divided by 12 (e.g. 10%/12) and PaymentPeroid should be multiplied by 12 (e.g. 4*12). | *For monthly payment, Rate should be divided by 12 (e.g. 10%/12) and PaymentPeroid should be multiplied by 12 (e.g. 4*12). | ||
Revision as of 16:05, 29 June 2018
FVIFA (Rate,NumberOfPayments)
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
FVIFA (Rate,NumberOfPayments)
- 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