Difference between revisions of "Manuals/calci/FVIFA"
Jump to navigation
Jump to search
| (2 intermediate revisions by the same user not shown) | |||
| 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, |
| − | + | **FVIFA() calculates the future value interest factor of annuity depending on payment periods, and interest rate. | |
| − | |||
| − | FVIFA() calculates the future value interest factor of annuity depending on payment periods, and interest rate. | ||
== 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). | ||
| Line 18: | Line 15: | ||
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== | ||
Latest revision as of 17:16, 22 August 2018
FVIFA (Rate,NumberOfPayments)
Where
- 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.
is the rate of interest per period,
is the total number of payment periods in an annuity,
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