Financial Functions

Appendix E - Crystal Reports Built-in Functions
Mastering Crystal Reports 9
by Cate McCoy and Gord Maric
Sybex 2003

Crystal Reports 9 contains over 50 financial functions, with more than 40 of them being new in this release. The functions calculate values like internal rates of return, net present value, amortization, depreciation, coupon settlement information, annual percentage rates, and many more of similar nature to financial spreadsheet analysis and statistical financial software. Many of the functions are heavily used by third-party tools that ship with Crystal Reports, such as accounting systems. You can use one of these functions to get a single answer or you can combine functions, treating each as building block, to generate answers to complex financial reporting problems.

ACCRINT Returns accrued interest for a security that pays interest periodically.

ACCRINTM Returns accrued interest for a security that pays interest at maturity.

AmorDEGRC Returns depreciation on an asset for a given year.

AmorLINC Returns linear depreciation on an asset for a given year.

CoupDayBS Returns the number of days between the latest coupon date before the settlement and the actual settlement date.

CoupDays Returns the number of days in the coupon period containing the settlement date.

CoupDaysNC Returns the number of days between the settlement date and the next coupon date after the settlement date.

CoupNCD Returns the date of the next coupon after the settlement date.

CoupNum Returns the number of coupon periods between the settlement date and the maturity date.

CoupPCD Returns the date of the last coupon before the settlement date.

CumIPMT Returns the total interest paid on a loan for a given period.

CumPrinc Returns the total money paid toward the principal on a loan for a given period.

Days360 Returns the number of days between two dates using 30 days for a month and 360 days for year.

DB Returns a number representing the depreciation on an asset in a time period using the fixed-declining balance method.

DDB Returns a number representing the depreciation on an asset in a time period using the double-declining balance method.

DISC Returns the discount rate for a security based on settlement and maturity dates.

DollarDE Returns a currency value expressed as a decimal given a currency value expressed as a fraction.

DollarFR Returns a currency value expressed as a fraction given a currency value expressed as a decimal.

Duration Returns a number representing the weighted average of the present value of cash flows.

Effect Returns the effective annual interest rate given a specific interest rate and number of compounding periods.

FV Returns the future value of an annuity.

FVSchedule Returns the future value of an investment given interest rates for several periods.

IntRate Returns the interest rate for a fully invested security.

IPmt Returns a number representing the interest payment on an annuity.

IRR Returns the internal rate of return for cash flow in a period.

ISPMT Returns the interest paid during a given period.

MDuration Returns a number representing the modified duration of a bond.

MIRR Returns the modified internal rate of return for cash flow in a period.

Nominal Returns the nominal annual interest rate given the effective interest rate.

NPer Returns the number of periods for an annuity.

NPV Returns the net present value of an investment.

OddFPrice Returns the price of a security that pays interest periodically but has an odd first period.

OddFYield Returns the yield of a security that pays interest periodically but has an odd first period.

OddLPrice Returns the price of a security that pays interest periodically but has an odd last period.

OddLYield Returns the yield of a security that pays interest periodically but has an odd last period.

Pmt Returns the payment amount for an annuity with fixed payments and fixed interest.

PPmt Returns the principal payment amount for an annuity with fixed payments and fixed interest.

Price Returns the price of a security paying interest periodically per $100 of face value.

PriceDisc Returns the price of a discounted security per $100 of face value.

PriceMat Returns the price of a security that pays interest at maturity per $100 of face value.

PV Returns the present value of an annuity.

Rate Returns the interest rate for an annuity period.

Received Returns the amount received for a fully invested security at maturity.

SLN Returns the straight-line depreciation on an asset.

SYD Returns the sum-of-years’ digits depreciation on 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 for a Treasury bill.

VDB Returns the depreciation of an asset for a given period using the double-declining balance method.

XIRR Returns the internal rate of return for nonperiodic cash flows.

XNPV Returns the net present value for nonperiodic cash flows.

YearFrac Returns a fractional value representing the percentage of a year between two given dates.

Yield Returns the yield on a security paying periodic interest.

YieldDisc Returns the annual yield for a discounted security.

YieldMat Returns the annual yield of a security that pays its interest at maturity.

Use of content on this site is expressly subject to the restrictions set forth in the Membership Agreement

Conello © 2000-2003     Feedback