Microsoft Office Tutorials and References

In Depth Information

**Financial Functions**

Returns the number of days in the coupon period that includes

the settlement date.

COUPDAYS

Returns the number of days from the settlement date to the next

coupon date.

COUPDAYSNC

Returns the number of days from the next coupon date after the

settlement date.

COUPNCD

Returns the total number of coupons payable between the

settlement and maturity date, rounded up to the nearest whole coupon.

COUPNUM

Returns the number of the previous coupon date before the

settlement date.

COUPPCD

Returns the cumulative interest on a loan between start and stop

dates.

CUMIPMT

Returns the cumulative principal amount between start and stop

dates.

CUMPRINC

Returns the asset depreciation for a period using the

fixeddeclining balance method.

DB

Returns the asset depreciation for a period using the

doubledeclining balance method, or another method you specify.

DDB

Returns the security discount rate.

DISC

Converts a fraction dollar price into a decimal dollar price.

DOLLARDE

Converts a decimal dollar price into a fraction dollar price.

DOLLARFR

Returns the duration for an assumed par value of $100 using the

Macauley method.

DURATION

Returns the effective interest rate annually, giving the nominal

annual interest rate and the number of compounding periods per

year.

EFFECT

Returns the future value of periodic payments and a constant

interest rate.

FV

Returns the future value of the initial principal after applying

several compound interest rates.

FVSCHEDULE

Returns the interest rate of a fully invested security.

INTRATE

Returns the interest payment for a period of time based on an

investment with periodic constant payments and a constant

interest rate.

IPMT

Returns the internal rate of return for a series of cash flows

represented by numbers in the form of values.

IRR

Returns a modified duration of a security with an assumed par

value of $100.

MDURATION