|
Do Time Value of Money calculations that use variations annuity formulae
| Component | What the name means |
| FVM | Future Value of an annuity allowing for different periodicity of payments per year
| | PVM | Present Value of an Annuity allowing for different periodicity of payments per year
| | PmtM | Annual Payment of an annuity allowing for different periodicity of payments per year
| | TermM | Length of the Term of an annuity allowing for different periodicity of payments per year
| | IntRateM | Interest Rate (AER-annual equivalent rate) of an annuity allowing for different periodicity of payments per year
| | PVEGAnn | Present Value of an Exponentially Growing Annuity
| | PVEGAnnM | Present Value of an Exponentially Growing Annuity
| | PVEGPerAnn | Present Value of an Exponentially Growing PERIODIC Annuity
| | PVEGPerp | Present Value of an Exponentially Growing Perpetuity
| | PVEGPerpM | Present Value of a Perpetuity
| | PVEGPerPerp | Present Value of an Exponentially Growing PERIODIC Perpetuity
| | SumEGAnn | Sum of an exponentially growing annuity (growth annually in arrear).
| | SumEGAnnM | Sum of an exponentially growing annuity (growth applied with specified frequency).
| | SumEGAnnCont | Sum of an exponentially growing annuity (growth annually in arrear).
| | SumLGAnn | The sum of a linearly growing annuity (growth annually in arrear)
| | SumLGAnnM | The sum of a linearly growing annuity, taking into account the number of changes in rate per year.
| | SumLGAnnCont | The sum of a linearly growing annuity assuming constant continuous growth
|
- The two main functions of this family are PVM and PmtM which are simply variations on the basic PV and Pmt functions in Excel. Whereas Excel's functions are most suited to annual cashflows, these two functions allow for the fact that payments can occur during the year as determined by the variable PmtsPerYear. Refer to the CorrectionM function also for how the adjustment for non-annual cashflows is made.
- Next there are functions that deal with growing annuities and perpetuities, mostly based on the Gordon formula for an exponentially growing perpetuity. Principal amongst these functions are PVEGPerp and PVEGAnn, and for a simple summation without discounting, the somewhat simpler SumEGAnn.
- There are the growing perpetuity and annuity functions that make the adjustment for non-annual cashflows, these being PVEGPerpM and PVEGAnnM.
All of these functions basically use the standard annuity formula in combination with the annual adjustment formula of CorrectionM, itself a derivation from the annuity formula.
- There are also functions that deal with the present values of PERIODIC growing annuities, namely PVEGPerPerp and PVEGPerAnn. These deal with the situation where the cashflows, growing exponentially, occur at intervals other than annual.
| 