1. Calculation functions
  2. All Functions
  3. Financial functions

Use financial functions to perform a range of financial calculations.

There are several general financial functions in Anaplan. These include CUMIPMT, CUMPRINC, FV, IPMT, IRR, NPER, NPV, PMT, PPMT, PV, and RATE.

Anaplan also offers investment management functions. These include COUPDAYBS, COUPDAYS, COUPDAYSNC, COUPNCD, COUPNUM, COUPPCD, DURATION, MDURATION, PRICE, YEARFRAC, and YIELD.

Investment management functions enable you to perform common calculations relating to the price and yield of bonds and the coupon periods that define when the bondholder receives interest as the bond matures.

Many investment management functions rely on day count conventions to determine the number of days between two dates. Anaplan defaults to a modified version of the US 30/360 day count convention, but you may choose to use other day count conventions if you wish.

Most financial functions are unavailable in Polaris, but you can use FV, IPMT, NPER, PPMT, and PV. Learn more about the differences between Anaplan calculation engines.

TitleDescription
COUPDAYBSCalculates the number of coupon days before the settlement date.
COUPDAYSReturns the number of coupon days in the coupon period that contains the settlement date.
COUPDAYSNCDetermines the number of coupon days from the settlement date until the next coupon date.
COUPNCDCalculates the next coupon date after the settlement date.
COUPNUMReturns the number of coupons payable between the settlement date of a bond and the bond's maturity.
COUPPCDIdentifies the previous coupon date before the settlement date.
CUMIPMTCalculates the cumulative interest paid on a loan during a specified period.
CUMPRINCCalculates the cumulative total of the principal amount paid during a given period for a loan.
DURATIONUses the Macaulay duration to indicate a bond price's response to changes in yield. 
FVFuture value of an investment.
IPMTIPMT calculates the amount allocated to loan interest in a period.
IRRIRR calculates the internal rate of return of a series of future cash-flows.
MDURATIONUses the modified Macaulay duration to tell you by what percentage the value of a bond will change for a 1% change in the yield.
NPERCalculates the length of an investment term in periods.
NPVCalculates the net present value of a series of cash-flows using a constant interest rate.
PMTCalculates the payments for a loan or annuity with constant payments and a constant interest rate.
PPMTCalculates the amount of a payment allocated to the principal part of a loan
PRICEReturns the price per 100 monetary units of a bond that pays periodic interest.
PVCalculates the present value of future cash-flows.
RATECalculates a per period interest rate.
YEARFRACCalculates the fraction of a year between two dates.
YIELDDetermines the yield to maturity of a bond — the interest rate that, when used to discount the bond's future cashflows, produces the given price.