Business Functions Library for Excel

 Annuity family Functions based around annuity formulae Description: Do Time Value of Money calculations that use variations annuity formulae Introduction: 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. Functions in the Annuity family (17)FVM Future Value of an annuity allowing for different periodicity of payments per yearPVM Present Value of an Annuity allowing for different periodicity of payments per yearPmtM Annual Payment of an annuity allowing for different periodicity of payments per yearTermM Length of the Term of an annuity allowing for different periodicity of payments per yearIntRateM Interest Rate (AER-annual equivalent rate) of an annuity allowing for different periodicity of payments per yearPVEGAnn Present Value of an Exponentially Growing AnnuityPVEGAnnM Present Value of an Exponentially Growing AnnuityPVEGPerAnn Present Value of an Exponentially Growing PERIODIC AnnuityPVEGPerp Present Value of an Exponentially Growing PerpetuityPVEGPerpM Present Value of a PerpetuityPVEGPerPerp Present Value of an Exponentially Growing PERIODIC PerpetuitySumEGAnn 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

Business Functions Ltd, London, UK Website Design: Webpure