Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Financial

 
ACCRINT*The accrued interest for a security that pays interest periodically.
ACCRINTM*The accrued interest for a security that pays interest at maturity.
AMORDEGRC*The depreciation of an asset over a particular period.
AMORLINC*The depreciation of an asset over a particular period.
COUPDAYBS*The number of days between a coupon starting and settlement.
COUPDAYS*The number of days between the next coupon and settlement.
COUPDAYSNC*The number of days from the settlement date to the next coupon.
COUPNCD*The next coupon date after the settlement date.
COUPNUM*The number of coupons between the settlement and maturity.
COUPPCD*The previous coupon date before the settlement.
CUMIPMT*The cumulative interest paid between two periods.
CUMPRINC*The cumulative principal paid on a loan between two dates.
DBThe depreciation of an asset (fixed-declining balance method).
DDBThe depreciation of an asset (double-declining balance method).
DISC*The discount rate for a security.
DOLLARDE*The dollar fraction expressed as a decimal.
DOLLARFR*The dollar decimal expressed as a fraction.
DURATION*The annual duration of a security that pays interest periodically.
EFFECT*The annual interest rate given a nominal rate and compounding frequency.
FVThe future value of an investment over a period of time.
FVSCHEDULE*The future value of an initial principal after applying compound interest rates.
INTRATE*The interest rate for a fully invested security.
IPMTThe interest payment for a given period of an investment.
IRRThe internal rate of return for a series of cash flows.
ISPMTThe interest paid during a specific period of an investment.
MDURATION*The modified duration for a security that pays interest periodically.
MIRRThe internal rate of return for a series of cash flows.
NOMINAL*The nominal rate equivalent to a given annual effective with a given compounding frequency for a nominal rate.
NPERThe number of periods for an investment.
NPVThe net present value of an investment.
ODDFPRICE*The price per $100 face value of a security with an odd first period.
ODDFYIELD*The yield of a security with an odd first period.
ODDLPRICE*The price per $100 face value of a security with an odd last period.
ODDLYIELD*The yield of a security with an odd last period.
PMT*The payment for a loan with constant payments and fixed interest.
PPMTThe payment on principle for a given period for an investment.
PRICE*The price per $100 face value of a security.
PRICEDISC*The price per $100 face value of a discounted security.
PRICEMAT*The price per $100 face value of a security that pays interest at maturity.
PVThe present value of an investment.
RATEThe interest rate per period of an annuity.
RECEIVED*The number received at maturity for a fully invested security.
SLNThe depreciation of an asset using the straight line method.
SYDThe depreciation of an asset using the sum of years method.
TBILLEQ*The bond equivalent yield for a treasury bill.
TBILLPRICE*The price per $100 face value for a treasury bill.
TBILLYIELD*The yield for a treasury bill.
VDBThe depreciation of an asset using the double-declining balance method.
XIRR*The annual effective interest rate for a schedule of cash flows.
XNPV*The net present value for a schedule of cash flows.
YIELD*The yield on a security that pays periodic interest.
YIELDDISC*The annual yield for a discounted security.
YIELDMAT*The annual yield of a security that pays interest at maturity.
 
 Note: * These are Analysis ToolPak functions

 Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top