Manuals/calci/FVIFA

From ZCubes Wiki
Revision as of 05:31, 14 March 2017 by Swapna (talk | contribs) (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, ...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

FV(Rate, PaymentPeriods)

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.

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.63 as a result.

2. =FVIFA(5%,20) : Calculates the future value interest rate in annuity
. Displays $33.07 as a result.


Related Videos

FV

See Also

References