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
Search JabSto ::




Custom Search