Use financial functions to perform a range of financial calculations.

There are several general financial functions in Anaplan. These include CUMIPMTCUMPRINCFVIPMTIRRNPERNPVPMTPPMTPV, and RATE.

Anaplan also offers investment management functions. These include COUPDAYBSCOUPDAYSCOUPDAYSNCCOUPNCDCOUPNUMCOUPPCDDURATIONMDURATIONPRICEYEARFRAC, 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 can choose to use other day count conventions.

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

Title Description
COUPDAYBS

Use the COUPDAYBS (coupon days before settlement) function to calculate the number of days from the beginning of the coupon period until its settlement date. The number returned includes both the first day of the period and the settlement date.

COUPDAYS

Use the COUPDAYS function to return the number of coupon days in the coupon period that contains the settlement date.

COUPDAYSNC

Use the COUPDAYSNC function to calculate the number of coupon days from the settlement date until the next coupon date. The number returned excludes the settlement date and includes the last day of the next coupon period.

COUPNCD

The COUPNCD function calculates the next coupon date after a settlement date.

COUPNUM

The COUPNUM function returns the number of coupons payable between a settlement and maturity date.

COUPPCD

The COUPPCD function calculates the previous coupon date before a settlement date.

CUMIPMT

The CUMIPMT function calculates the cumulative interest paid on a loan over a period given equal payments made to the balance.

CUMPRINC

The CUMPRINC function calculates the amount of principal paid on a loan over a period, given consistent, equal payments.

DURATION

You can use the DURATION function to calculate the Macauley duration for an assumed parity value of 100 monetary units.

The Macauley duration is the weighted average maturity of cash flows. That is, the weighted average distance to payment. It's used to measure a bond price's response to changes in yield. A higher Macauley duration value indicates a riskier investment.

FV

The FV function calculates the future value of an investment. The future value is the lump sum or closing balance received at the end of an investment.

IPMT

The IPMT function calculates the amount of interest to be paid on a loan in a given payment period. The function assumes a consistent interest rate and payment timings in each period.

IRR

The IRR function calculates the internal rate of return for a series of positive and negative transactions. It can be used either with all transactions over a timescale, or with specified transactions on certain dates.

MDURATION

You can use the MDURATION function to calculate the modified Macauley duration for an assumed parity value of 100 monetary units.

The modified Macauley duration expresses the measurable change in the value of a bond in response to a change in interest rates. The result represents the effect that a 1% change in interest rates will have on the price of a bond.

NPER

The NPER function calculates the required number of periods to achieve a certain value for a loan or investment. This is based on a given interest rate, consistent payments, and opening and closing balance.

NPV

The NPV function calculates the net present value for a series of positive and negative transactions with a constant interest rate.

PMT

The PMT function calculates the payments due for a loan or annuity over a specified number of periods, given a consistent interest rate and payment amount.

PPMT

The PPMT function calculates how much of a payment is allocated to its principal part rather than interest. The function assumes a consistent interest rate and payment timings in each period.

PRICE

The PRICE function calculates the price per 100 monetary units invested for a bond that pays periodic interest.

PV

The PV function calculates the present value of an investment or the principal value of a loan.

RATE

The RATE function calculates the interest rate for a loan or investment based on length, payments, and present and future value.

YEARFRAC

Use the YEARFRAC function to calculate the fraction of a year between two dates (inclusive of the start date, exclusive of the end date).

The function uses a basis (day-count convention) to count the number of days between these dates, and then divide that number by the basis.

YIELD

Use this function to calculate the yield to maturity (YTM) of a bond.

Disclaimer

We update Anapedia regularly to provide the most up-to-date instructions.