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