Microsoft Office Tutorials and References

In Depth Information

**Financial Functions**

Returns a modified internal rate of return for several periodic

cash flows.

MIRR

Returns the nominal annual interest rate given an effective rate

and a number of compounding periods per year.

NOMINAL

Returns the number of periods for an investment based on periodic

constant payments and a constant interest rate.

NPER

Calculates the net present value of an investment with the

discount rate and several future payments and income.

NPV

Returns the value of a security based on a per $100 face value and

an odd first period.

ODDFPRICE

Returns the security yield with an odd first period.

ODDFYIELD

Returns the per $100 face value of a security having an odd last

coupon period.

ODDLPRICE

Returns the security yield that has an odd last coupon period.

ODDLYIELD

Calculates the loan payment for a loan based on constant

payments and constant interest rates.

PMT

Returns the principal payment for a period of an investment based

on periodic constant payments and a constant interest rate.

PPMT

Returns the value of a security based on price per $100 face value

and periodic payments.

PRICE

Returns the value of a discounted security based on a price per

$100 face value.

PRICEDISC

Returns the value of a security that pays interest at maturity and

price per $100 face value.

PRICEMAT

Returns the present value based on an investment.

PV

Returns per period the interest of an annuity.

RATE

Returns the amount received at maturity based on a fully invested

security.

RECEIVED

Returns the straight-line depreciation on an asset based on one

period.

SLN

Returns the sum-of-years-digits depreciation of an asset based on

a specified period.

SYD

Returns the bond equivalent yield for a treasur y bill.

TBILLEQ

Returns the price per $100 face value for a treasur y bill.

TBILLPRICE

Returns the yield for a treasur y bill.

TBILLYIELD

Returns the depreciation of an asset for a period you specify.

VDB

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

that are not necessarily periodic.

XIRR