Page 404 - Excel 2013 All-in-One For Dummies

386 Analysis ToolPak Financial Functions
Table 4-1 (continued) Function
COUPDAYS(settlement,maturity, frequency,[basis])
COUPDAYSNC(settlement,maturity, frequency,[basis])
COUPNCD(settlement,maturity, frequency,[basis])
COUPNUM(settlement,maturity, frequency,[basis])
COUPPCD(settlement,maturity, frequency,[basis])
CUMIPMT(rate,nper,pv,start_ period,end_period,type)
CUMPRINC(rate,nper,pv,start_ period,end_period,type)
DISC(settlement,maturity,pr, redemption,[basis])
DOLLARDE(fractional_dollar,fraction) DOLLARFR(decimal_dollar,fraction)
DURATION(settlement,maturity, coupon,yld,frequency,[basis])
What It Calculates
Calculates the number of days in the coupon period.
Calculates the number of days from the settlement date to the next coupon date.
Calculates a number that represents the next coupon date after a settlement date.
Calculates the number of coupons pay- able between the settlement date and maturity date, rounded up to the nearest whole coupon.
Calculates a number that represents the previous coupon date before the settlement date.
Calculates the cumulative interest paid on a loan between the start_period and end_period. The type argument is 0 when the payment is made at the end of the period and 1 when it’s made at the beginning of the period.
Calculates the cumulative principal paid on a loan between the start_period and end_period. The type argument is 0 when the payment is made at the end of the period and 1 when it’s made at the beginning of the period.
Calculates the discount rate for a secu- rity.
Converts a dollar price expressed as a fraction into a dollar price expressed as a decimal number.
Converts a dollar price expressed as a decimal number into a dollar price expressed as a fraction.
Calculates the Macauley duration for an assumed par value of $100. (Duration is defined as the weighted average of the present value of the cash flows and is used as a measure of the response of a bond price to changes in yield.)