Microsoft Office Tutorials and References
In Depth Information
ODDLPRICE
Returns the price per $100 face value of a security with an odd last period.
ODDLYIELD
Returns the yield of a security with an odd last period.
Returns the number of periods required by an investment to reach a speci-
fied value.
PDURATION*
PMT
Returns the periodic payment for an annuity.
PPMT
Returns the payment on the principal for an investment for a given period.
Returns the price per $100 face value of a security that pays periodic in-
terest.
PRICE
PRICEDISC
Returns the price per $100 face value of a discounted security.
Returns the price per $100 face value of a security that pays interest at
maturity.
PRICEMAT
PV
Returns the present value of an investment.
RATE
Returns the interest rate per period of an annuity.
RECEIVED
Returns the amount received at maturity for a fully invested security.
RRI*
Returns an equivalent interest rate for the growth of an investment.
SLN
Returns the straight-line depreciation of an asset for one period.
Returns the sum-of-years' digits depreciation of an asset for a specified
period.
SYD
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.
Returns the depreciation of an asset for a specified or partial period using a
double declining-balance method.
VDB
Returns the internal rate of return for a schedule of cash flows that is not
necessarily periodic.
XIRR
Returns the net present value for a schedule of cash flows that is not ne-
cessarily periodic.
XNPV
Search JabSto ::




Custom Search