Use Excel's financial functions in your Anaplan XL reports.
| Function | Description |
| ACCRINT | Returns accrued interest for securities that pay periodic interest. |
| ACCRINTM | Returns the accrued interest for securities that pay interest at the maturity date. |
| AMORDEGRC | Returns the depreciation for each accounting period within the formula. |
| AMORLINC | Returns the depreciation for each accounting period. |
| COUPDAYBS | Returns the number of days from the beginning of the period to the coupon-period settlement date. |
| COUPDAYS | Returns the number of days in the period that contains the coupon period settlement date. |
| COUPDAYSNC | Returns the number of days between the settlement date to the next coupon date. |
| COUPNCD | Returns the next coupon date after the settlement date. |
| COUPNUM | Returns the total number of coupons to be paid between the settlement and maturity dates, rounded up to the nearest whole coupon. |
| COUPPCD | Returns the coupon date before the settlement date. |
| CUMIPMT | Returns the cumulative interest on a loan between start and stop dates. |
| CUMPRINC | Returns the cumulative principal amount between start and stop dates on a loan or mortgage. |
| DB | Returns the asset depreciation for a period using the fixed declining balance method. |
| DDB | Returns the asset depreciation for a period using the double-declining balance method or another specified method. |
| DISC | Returns the security discount rate. |
| DOLLARDE | Converts a fraction dollar price into a decimal dollar price. |
| DOLLARFR | Converts a decimal dollar price into a fraction dollar price. |
| DURATION | Returns the Macauley duration for an assumed par value. |
| EFFECT | Returns the effective interest rate annually. This is based on the nominal annual interest rate and the number of compounding periods per year. |
| FV | Returns the future value of an investment that makes payments as a lump sum or as a series of equal periodic payments. |
| FVSCHEDULE | Returns the future value of a principal amount after applying several, or a series of compound interest rates. |
| INTRATE | Returns the interest rate of a security that is fully invested. |
| IPMT | Returns the interest for a period of time based on an investment with periodic constant payments and a constant interest rate. |
| IRR | Returns the internal rate of return for a series of cash flows represented by numbers in the form of values. |
| ISPMT | Calculates the interest paid during a defined period of an investment. |
| MDURATION | Returns the modified duration of a security with a par value assumed to be $100. |
| MIRR | Returns a modified internal rate of return for several periodic cash flows. |
| NOMINAL | Returns the nominal annual interest rate given an effective rate and the total number of compounding periods for the year. |
| NPER | Returns the total number of periods for an investment. This is based on a periodic constant payment and a constant interest rate. |
| NPV | Calculates the net present value of an investment from the discount rate and several future payments and income. |
| ODDFPRICE | Returns the value of a security based on a per $100 face value and an odd (short or long) first period. |
| ODDFYIELD | Returns the security yield with an odd first period. |
| ODDLPRICE | Returns the per $100 face value of a security having an odd last coupon period. |
| ODDLYIELD | Returns the security yield that has an odd last period. |
| PDURATION | Returns the number of periods for the specified present value to reach the specified future value given the specified interest rate. |
| PMT | Calculates the loan payment for a loan based on constant payments and constant interest rates. |
| PPMT | Returns the principal payment for a period of an investment based on periodic constant payments and a constant interest rate. |
| PRICE | Returns the value of a security based on price per $100 face value and periodic interest payments. |
| PRICEDISC | Returns the value of a discounted security based on a price per $100 face value. |
| PRICEMAT | Returns the value of a security that pays interest at maturity and price per $100 face value. |
| PV | Returns the present value based on an investment. |
| RATE | Returns per period the interest of an annuity. |
| RECEIVED | Based on a fully invested security, returns the amount received at maturity. |
| RRI | Returns the effective interest rate required for the specified present value to reach the specified future value in the specified number of periods. |
| SLN | Returns the straight-line depreciation on an asset. |
| SYD | Based on a specified period, SYD returns the sum-of-years' digits of depreciation of an asset. |
| TBILLEQ | Returns the bond equivalent yield for a treasury bill. |
| TBILLPRICE | Returns the price per $100 face value for a treasury bill. |
| TBILLYIELD | Returns the yield of a treasury bill. |
| VDB | For a period, you specify, returns the depreciation of an asset. |
| XIRR | Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic. |
| XNPV | Returns the net present value for a schedule of cash flows that is not necessarily periodic. |
| YIELD | Based on a yield that pays periodic interest, returns the yield of the security. |
| YIELDDISC | Returns the annual yield for a discounted security. |
| YIELDMAT | Returns the annual yield based on a security that pays interest at maturity. |
